CMP-01 Lot Traceability Report

Lot stock by location - the in-warehouse leg of lot traceability.

This report shows lot stock by location: for each lot, SKU and location it shows the quantity on hand and the quantity already allocated. It is the in-warehouse leg of lot traceability. It uses real-time data, so the quantities reflect stock as it stands when you run it.

What this report is for#

Use it when you need to locate a lot inside the warehouse: which locations hold it, how much is on hand there, and how much of it is already allocated. It covers only the in-warehouse leg — where the lot came from and where it went are followed in the receiving and outbound reports named in the counting notes below.

How the numbers are counted#

In-warehouse leg: on-hand and allocated per lot, SKU and location. Inbound origin and outbound destination legs are read from receiving events (INB-01) and outbound detail (OUT-06) with the same lot number.

Each row is one lot number, one SKU and one location.

Dimensions and filters#

• Lot No. — the lot number
• SKU / Item — the product
• Location — the storage location
• Qty On Hand — quantity currently on hand
• Qty Allocated — quantity already allocated
• Filters you can set: Warehouse, Client

How to read it#

Read the two quantity columns together on the same row: on hand is what is physically there for that lot, SKU and location, and allocated is the part of it already promised. To follow one lot end to end, start here for its in-warehouse positions, then read the receiving events (INB-01) and the outbound detail (OUT-06) with the same lot number for the inbound and outbound legs.

Typical uses#

• Locate every location holding a given lot
• Check how much of a lot is on hand and how much is already allocated
• Start an end-to-end lot trace, then continue in INB-01 and OUT-06 with the same lot number

Reports features used in this article: pick this report in Reports, set the date range or warehouse filter and click Run to see the result; use Export to download the result as a CSV file; or use Subscribe to have the same view sent to your inbox on a schedule.

Note on subscriptions: your subscription and its filters are saved right away. Scheduled email delivery is being switched on in stages — sending starts as soon as delivery opens for your organization.