Printing in-transit inventory

The Print In Transit Inventory (whinr1410m300) session is used to print overviews of inventory that is on its way from one warehouse to another. The report displays item quantities listed on transfer orders. The items are issued from the origin warehouse but have not yet been received in destination warehouse. These items are loaded onto trucks or other means of transport, or located at pooling points such as harbors or airports.

The report displays the item quantities and item values by inventory transaction.

Note: Goods in-transit quantities and items issued to customers, projects, production lines, or service departments are not regarded as in-transit inventory.

The information is retrieved from the Item - Warehouse - Inventory Transactions (whinr1510m000) and Inventory Integration Transactions (whina1524m000) sessions.

Multiple transactions can be performed for each order line. Therefore, an order line can be displayed multiple times on the report.

The in-transit quantity is calculated by subtracting the received quantity from the issued quantity. For a receipt, the earliest issue is consumed first. This results in a report as shown in this example:

Example

Transactions
Transfer order Order line Date Quantity Issued/Received
TRAM00001 10 20 August yyyy 5 Issued
TRAM00001 10 22 August yyyy 3 Issued
TRAM00001 10 26 August yyyy 3 Received
Quantities displayed on the report
Transfer order Order line Date Calculation Quantity in transit
TRAM00001 10 20 August yyyy 5 issued - 3 received = 2
TRAM00001 10 22 August yyyy 3 issued - 0 received = 3
Note: If multiple inventory transactions are present for an order, and one or more transactions fall outside the date range specified for the report, only the transactions within the date range are included in the calculation and printed on the report.

Report options

The table displays the available options for the in-transit inventory report:

Option Layout
Destination Warehouse The in-transit inventory is sorted by destination warehouse.
Origin Warehouse The in-transit inventory is sorted by origin warehouse.
Print Quantities Only Values are excluded from the report.
Include Finalized Transfers

Inventory listed on transfer orders whose receipt is confirmed in the destination warehouse is included in the report.

This information is displayed:

  • The outbound and inbound transaction dates
  • The outbound, inbound, and in-transit quantities
  • The outbound, inbound, and in-transit values. Excluded from the report if the Print Quantities Only check box is selected.

The order types and item descriptions are left out of the report.

Aggregate by Item The in-transit inventory is aggregated by item and destination warehouse if the Destination Warehouse option is selected, and origin warehouse if the Origin Warehouse option is selected.

The values of each transaction listed on the report are retrieved from the transaction amounts listed in the Inventory Integration Transactions (whina1524m000) session.

The in-transit value is an approximation of the value of the goods on the way to the destination warehouse. It is calculated by subtracting the inbound transaction value from the outbound transaction value, but cannot be less than zero. When the inbound line of a transfer order line is fully received, the in-transit value is set to zero.

The values are expressed in the local currency if the Use Local Currency check box is selected, or the currency specified in the Currency field.