Inventory report
The Inventory Report provides an overview of your current inventory.
- Click Warehouse in the top menu and select Inventory in the section Reports in the drop-down menu.
- In the filters on the left side of the table, you can limit your search. You can filter by Partner, SKU and Tags, Category, Trace and Cutoff date. Click the button Apply to activate the filter.
- You can use the filter Show Cost Prices to view the report with values. If you have enabled Actual Cost Pricing in you company settings, you will be able to choose between viewing the report with either expected cost prices or actual cost prices. The value is calculated as the average cost price of the lots that you have or had in stock on the selected cut off date.
- By clicking the tabs, you can change the view of the report. You can, for example, see your inventory summarized by SKU for goods with traceability, eg. foods. In the following sections, you can read about the tabs in the report.
- To view the report in a printer friendly format, click Printer Friendly.
- To export the report to Excel, click XSLX.
By SKU - With traceability
| Column | Explanation |
| Stock Keeping Unit – SKU Code | This is the SKU number |
| Stock Keeping Unit – Global Name | This is the name specified for the SKU at setup. |
| Stock Keeping Unit – Unit | This is the unit of the SKU eg. Colli, kg, liter etc. Read more about units of measure here. |
| Supply – Expected | This is the expected supply of the SKU to the warehouse, e.g. expected purchase orders or expected finished goods in production, still not received in stock. |
| Supply – Confirmed | This is the confirmed supply of the SKU to the warehouse, eg. confirmed lots that are available on stock (lots with status Confirmed or On Location). |
| Total – Supply | This is the totale amount of supplied lots, eg. The sum of both the expected and the confirmed lots. |
| Demand – Not picked Orders | This is the demanded quantity of the SKU on existing orders where the lots have not yet been picked, e.g. on sales orders where the status of the order is Lots not selected. |
| Demand – Not picked Quotes | This is the demanded quantity of the SKU on existing quote orders where the lots have not yet been picked, e.g. on quote orders where the status of the order is Lots not selected. |
| Demand – Total | This is the total demanded quantity of the SKU i.e. the sum of demanded lots on both orders and quote orders. |
| Totals – Total Available | This is the sum of the available amount of the SKU, i.e. the total supply of the SKU compared to the total demand of the SKU |
| Totals – On hand | This is the total quantity of the SKU available on stock i.e. lots that are not only confirmed, but that are physically on stock and have the status On Location. |
By SKU - Without traceability
| Column | Explanation |
|---|---|
| Stock Keeping Unit – SKU Code | This is the SKU number |
| Stock Keeping Unit – Global name | This is the name specified for the SKU at setup. |
| Stock Keeping Unit – Unit of measure | This is the unit of the SKU eg. Colli, kg, liter etc. |
| Stock Keeping Unit – On Hand | This is the total quantity of the SKU that is available in stock, ie that has status On the location. |
By SKU - Valuation (Approximately)
The valuation in this report is based on an average cost price across locations and time for SKUs without traceability, eg. labels and packaging.
The cost price for SKUs with traceability, eg. food is calculated as the average cost price of the lots that are in stock of this item on the selected cut off date.
Please note: If you have enabled actual cost pricing in your company settings, be aware that expenses are not date-limited.
This means that if a billing document is received in January regarding an order with a delivery date in December, the expenses will be included in the cost price in December.
This is in contrast to the Inventory Valuation Report, where the expense is included in the cost price when the document is received and posted.
| Column | Explanation |
|---|---|
| Stock Keeping Units – SKU Code | This is the SKU code. |
| Stock Keeping Units – Global name | This is the name specified for the SKU at setup. |
| Stock Keeping Units - Unit of Measure | This is the unit of the SKU, eg. pieces, kg or liters. A unit of measure is the unit in which a given quantity is measured. |
| In Transit from Supplier - Quantity of UoMs | This is the expected supply of the SKU to the warehouse from purchase orders. These are goods on a purchase order with a pick-up date and delivery date before the cut off date and a availability date after the selected cut off date. For example, if the Unit of Measure is pcs and there are 500 in this column, there are 500 pcs on the way from the supplier. |
| In Transit from Supplier - Valuation | This is the cost price of the goods that are on their way from the supplier. These are goods on a purchase order with a pick-up date and delivery date before the cut off date and a availability date after the selected cut off date. The currency in which the value is shown are the default currency for your company profile. Click on the company name in the upper right corner and select company settings, to see your default currency. |
| On Hand -Quantity of UoMs | This is the number/quantity of goods in stock on the selected cut off date. The lots have the status On location. |
| On Hand - Valuation | This is the value of the goods in stock on the selected cut off date. The lots have the status On location. |
| In Process -Quantity of UoMs | This is the expected supply of finished goods under production. These are goods on a production order with a pick-up date before the cut off date and a availability date after the selected cut off date. |
| In Process - Valuation | This is the value of the finished goods, which are expected to be included in the inventory and which are in production, have not yet been received. These are goods on a production order with a pick-up date before the cut off date and a availability date after the selected cut off date. |
| In Transit to Customer - Quantity of UoMs | This is the number of good disposed in a sales order with a pick-up date before the cut off date and a delivery date after the selected cut off date. Eg. a sales order with a pick-up date on January 6 and a availability date on January 8, with the selected cut off date being January 7. |
| In Transit to Customer - Valuation | This is the value of the goods disposed in a sales order with a pick-up date before the cut off date and a availability date after the cut off date. |
| Totals - Quantity of UoMs | This is the this is the summed number of goods that is in stock and in transit from supplier and in process, including what is in transit to the customer. |
| Totals - Valuation | This is the this is the summed value of the goods that is in stock and in transit from supplier and in process, including what is in transit to the customer. |
By Lot
| Column | Explanation |
|---|---|
| Lots – lot number | This is the different lot numbers of the SKU to which the inventory figures relate. |
| Lots – Lot description | This is the description of the lot, i.e. text inserted on the lot as an Attribute or as a Trace. |
| Lots – Location | This is the location of the lot. |
| Lots – Dates | Depending on the date registrations you use in the system, this could be the date of production, the date of availability, Best-before date or Expiry date. |
| Lots – Units | This is the selected standard unit of measure of the SKU |
| Lots – Available, Box unit | This is the number of box units of the lot available on stock |
| Lots – Available, Unit of Measure | This is the number of units of measure of the lot available on stock. |
| Lots – On hand, Unit of Measure | This is the number of units of measure of the lot registered as physically on stock i.e. lots with status On Location. If there is a minus (-) in front of the number in this column, it means that the lot is set aside for an outgoing order without being received in stock. |
By Lot – In process
| Column | Explanation |
|---|---|
| Lots – lot number | This is the different lot numbers of the lots in process. |
| Lots – Lot description | This is the description of the lot in process, i.e. text inserted on the lot as an Attribute or as a Trace. You can read about attributes here You can read more about traces here. |
| Lots – Location | This is the location of the lot in process. |
| Lots – Dates | Depending on the date registrations you use in the system, this could be the date of production, the date of availability, Best-before date or Expiry date. |
| Lots – Units | This is the selected standard unit of measure of the lot in process. |
| Lots – In process, box units | This is the number of box units of the lot in process. |
| Lots – In process, Units of measure | This is the number of units of measure og the lot in process. |
Extraction
If you want to create your own inventory report which contains the exact information of your needs, you can create a pivot table. Your data is already in tabulated form - which means, that every single type of data is in separate columns, to ensure the data is compatible when generating a pivot table.
Click the tab Extraction in the inventory report, and click XLSX in the upper right corner. By this, a spreadsheet is generated for download, which can then be adjusted to your needs.
Most spreadsheets has a pivot function. It varies from sheet to sheet, how the pivot table is generated. You can do an internet search, by entering e.g. “Pivot table excel” into your search engine.