Product Tracking Quantities

View stock quantities and pending stock movements for a selected product, with serial-number and lot tracking detail. This is the tracked-stock companion to the Product Quantities page; use it for products where serial numbers or lot numbers are recorded against stock.

Note: This page is only available in Saturn editions, where multi-location stock and serial/lot tracking are supported.

Product Selection

Use the product lookup at the top of the page to choose a product. The selected product code is kept in the URL so the page can be bookmarked or shared. Until a product is selected the page shows a "Select a product to view quantities and pending movements" prompt.

Once a product is selected, the page shows a row of tabs: a Stock tab followed by one tab per pending-movement class. The Stock tab holds the quantities-by-location grid and the serial/lot tracking detail; the remaining tabs each list the pending movements for one class. Each pending tab label includes a count of matching rows.

Stock Tab — Quantities by Location

The top half of the Stock tab shows a grid of quantities by location for the selected product. Click a row to select a location; the serial/lot tracking detail below is then filtered to that location.

LocationCode The stock location code.
QuantityInStock Current on-hand quantity at this location.
QuantityAllocated Quantity allocated to orders at this location.
QuantityAvailable Available quantity (In Stock minus Allocated).
QuantityOnOrder Quantity on purchase orders.
QuantityOnBackOrder Quantity on back orders.
QuantityShipped Quantity shipped but not yet received.
QuantityCommitted Quantity committed to orders.
QuantityInTransit Quantity in transit between locations.
QuantityInProduction Quantity currently in production.
QuantityReturned Quantity returned.
StocktakeVariance Stocktake variance quantity for this location.

Additional columns are hidden by default and can be shown through the grid's column customisation, including Location Name, Bin Code, Theoretical (theoretical quantity), the unit-of-measure (UOM) equivalents of each quantity, and Minimum, Maximum and Rec. Reorder levels.

Stock Tab — Tracking Details

The bottom half of the Stock tab shows serial/lot tracking detail, filtered to the location selected in the grid above. The available tabs depend on whether the product is serial-tracked, lot-tracked, or both:

Serials

For serial-tracked products. Each row is one serial number, showing the serial number (Serial Number), its current status (Status), and any expiry date (Expiry Date). When a location is selected above, only serials at that location are listed.

Lots

For lot-tracked products. Each row is one lot, showing the lot number (Lot Number), quantity (Quantity), and any expiry date (Expiry Date). When a location is selected above, only lots at that location are listed.

Note: Products that are neither serial-tracked nor lot-tracked still show the Stock tab and quantities-by-location grid, but the tracking area reads "No tracking configured for this product." For those products use Product Quantities instead.

Pending Movement Tabs

Each pending-movement class has its own tab next to the Stock tab, with the count of matching movements shown in the tab label (for example, Allocated (3)). The grid shows quantity in/out, source module, class, location, document date, party, document class and effective date by default; further columns (document number, order number, references, comments, print/post status, UOM quantities) can be shown through column customisation. Which tabs appear depends on which modules are installed:

Allocated Allocated stock movements. Shown when the Invoicing (IN) or Order Entry (OE) module is available.
Back Order Back order movements. Shown when the Order Entry (OE) module is available.
On Order Pending purchase order movements. Shown when the Purchase Orders (PO) module is available.
Shipped Shipped but not received movements. Shown when the Accounts Payable (AP) module is available.
Committed Committed stock movements. Shown when the Purchase Orders (PO) or Accounts Payable (AP) module is available.
In Production Stock currently in production. Always available.
Returned Returned stock movements. Always available.
Variation Stocktake variation movements. Always available.
In Transit Stock in transit between locations. Saturn only.

Click a pending-movement row to drill through to its source document where one exists (an Invoicing invoice, an Order Entry order, or a Purchase Orders order). You can also open the source document in a new browser tab from the row's context menu.

Actions