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.

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.

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.

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.

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.