Reports

General

A multitude of reports are available that can be exported from the system. These are provided as .xlsx files for download.

For some lists, the data can be restricted via a filter before downloading.

Reports are reports about e.g. all article stocks in the warehouse, hazardous materials etc.. They can be created at any time.

Structural changes may occur in the reports at any time. For example, new columns.

Base data

Report	Filter	Description
closed circuit equipments	Barcode Equipment type In use	If the Closed Container Circuit function is used, a corresponding report can be generated.
Equipent types	Deactivated Suitable for equipment account Suitable for forklift Suitable for packing Suitable for picking	Report on equipment types created under Master Data → Equipment types .
Business partners	Partner types	Overview of all business partner data or the selected types. Also includes additional data such as shipping services and rates, if these have been stored.
Articles	Client	Overview of all Articles or those belonging to the selected client.
Bill of material	Article: Number	Overview of parts lists for articles.
Users	Deactivated	Overview of user accounts created in the system.

Stock

Report	Filter	Description
Storage units	Equipment type Client Serial number Batch expiration date Expiration warning date Manufacturing batch Production date Special stock number Special stock number2 Article: Number	Generates a report on the storage units in the warehouse that match the filter.
Stock	Client Article: Number	Report on stock levels for the relevant mandate and/or article
Stock grouped by qualifications	Batch Country of origin Manufacturing batch Storage area code Storage location qualification Client Expiration date Production date Special stock number Special stock number2 Article: Number Article: Product category	Generates a report in which the stocks are merged according to the specified stock qualifications. In addition to the filters set, the stocks are also separated according to ERP storage location.
Stock on reporting date	Article: Name Article: Number Is outbound Is inbound Equipment: Barcode Equipment: Width Equipment: Gross weight Equipment: Height Equipment: Length Client Quant: Gross weight Reporting date Transfer equipment: Barcode Transfer equipment: Width Transfer equipment: Gross weight Transfer equipment: Height Transfer equipment: Length Goods in date	If stock on reporting date is activated a report with the corresponding filteres can be created.
Hazardous material overview	Client Article: Number
Movements	Article: Number Time stamp
Equipment exchanges	Equipment type From business partner Time stamp To business partner	Report on equipment exchange history.
Storage places	Client Article: Number	Report on all storage locations in the warehouse, provided no filter is set. If there are stocks in the storage locations, these are listed with client, number, description, and quantity.
turnover rate	Anlagedatum Articlenummer Client
serial numbers	-	Report on inventory with serial numbers.

Inventory

Report	Filter	Description
Adresses with inventory dates	-	All storage locations, with inventory date if one is set for the location.
Inventory receipt details	Article: Client Article: Number Creation date	Overview of inventory receipts and associated items.

Goods In

Report	Filter	Description
Goods in orders	Category Client Creation date Done date Planned goods in date Status Supplier	Overview of goods inorders available in the system.
Delivery Notes	Category Client Creation date Done date Status	Overview of delivery notes available in the system.
goods in receipts	Client Creation date Done date Status	Overview of goods in receipts available in the system.

Production

Report	Filter	Description
Production orders	Client Creation date Production date Status	Overview of production orders available in the system.
Production receipts	Client Creation date Status	Overview of production inputs available in the system.

Goods Out

Report	Filter	Description
Customer Orders	Client Order creation date Order done date Planned goods out date Status	Overview of customer orders in the system.
Goods out reciepts	(Planned) goods out date Client Creation date Status	Overview of goods issues available in the system.

Transfer

Report	Filter	Description
Picking orders	Client Creation date Status Storage unit → Article: Number	Overview of picking orders.
Transfer orders	Creation date Status Unit filter → Storage unit → Article: Number	Overview transfer orders.
Internal orders	Client Creation date Status	Overview of internal orders.
Rebooking orders	Client Creation date Status	Overview of rebooking orders.

Billing

Report	Filter	Description
Billings	Client Creation date	Report on created billings.
Daily storage occupation	Client Date	Report on equipment movements during the selected period (Initial stock, In, Out).
Addison fin. acc	Client Creation date	exoirt as .csv for usage with the addison accounting software.

Billing & Contract

Report	Filter	Description
Contract for work billing	Billing period from Billing period until Client Creation date Invoice date Status	Overview of work contract billings.
Service fee billing	Billing period from Billing period until Client Creation date Invoice date Status	Overview of service billings.
storage fee billing	Billing period from Billing period until Client Creation date Invoice date Status	Overview of storage fee billings.

Addison FiBu

This report generates CSV files with accounting data for import into the Addison financial accounting system.

In the report, the data of the billing is linked and output according to the specifications of the Addison financial accounting software:

Column A contains the record type, i.e. always a B for posting.
The FiBu account number of the warehouse manager is always written in column B.
Column C shows the posting date.
Column D contains the document date of the invoice, whose invoice number you can find in column E.
The posting text in column F throws out the rate types in summary.
Column G shows the amount.
Column H indicates the account of the business partner that will be charged, or the revenue, or the sales tax account.
Column I contains a 0 or the contra account from the first line of the corresponding posting record, i.e. the FiBu account number of the settled business partner.
In column J the tax key is output with 0, because the tax of the posting record, if sales tax is calculated, is written in a separate line.
Columns K and L are not filled because they are not used in COGLAS.

A posting record extends over three lines if VAT is calculated. Without VAT accordingly on two lines.

In the first row, the account of the business partner (column H) with the gross or, if no sales tax is charged, net amount (column G) written against contra account 0.
In the second line, the net revenues are shown as a minus amount (column G) with the revenue account (column H) against the contra account (column I), which was defined in the previous line as an account (column H) is led, written.
In the third line of the posting record, the VAT amount is entered as a minus amount (column G) with the sales tax account (column H) against the contra account (column I), which is displayed in the first row as an account (column H) is led, written.

→ back to COGLAS processes
→ back to COGLAS menu