Pending Stock Movements

View pending stock movements for a selected product. This page uses the SubCollectionList component with the icpendingmovementlist endpoint, fetching the Pending sub-collection from the ICProduct entity. Records can be opened by navigating to their source documents.

Product Selection

A product must be selected before pending movements are displayed. The parent lookup configuration:

Endpoint ICProduct
Code Field ProductCode
Description Field Description
Lookup Table ICPROD
Domain Selector "IC Product Code"

Default Columns (Mercury)

When not in Saturn mode, the following columns are displayed:

QuantityIn Quantity in for this pending movement.
QuantityOut Quantity out for this pending movement.
BalanceQuantity The balance quantity.
SourceModule The source module code.
Class The motion class (Allocation, BackOrder, OnOrder, etc.).
DocumentDate The document date.
DocumentPartyCode The party code associated with the document.
DocumentClass The document classification.
EffectiveDate The effective date of the movement.
Saturn Only: In Saturn editions, the default columns include LocationCode between Class and DocumentDate.

Additional Columns

The following additional columns are available but not shown by default:

LocationCode The stock location (default in Saturn mode).
PeriodName The accounting period name.
DocumentNo The document number.
OriginationDate The origination date of the movement.
JobCode Associated job code.
DocumentPartyName The full name of the party.
PackingSlipNo Packing slip number.
Reference Reference text.
QuotationReference Quotation reference.
Comment Comment text.
PrintStatus The print status of the document.
PostStatus The post status of the document.
OrderNo The order number.

Selection Filters

StockGroupCode Filter by stock group. Looks up from the ICGROUP table (StockGroupCode / StockGroupName).
Class (Motion) Filter by motion type. Dropdown with the following options:
  • Allocated (Allocation)
  • In Transit (InTransit)
  • On Order (OnOrder)
  • Shipped (Shipped)
  • Back Order (BackOrder)
  • Committed (Commitment)
  • Returned (Returned)
  • In Production (InProduction)
  • Variation (Variation)
  • All Pending (*) - default
Saturn Only: In Saturn editions, additional selection filters are available: BranchCode (COBRANCH table), DepartmentCode (CODEPT table), and LocationCode (ICLOCN table).

Client-Side Filtering

Selection filters are applied client-side to the loaded Pending sub-collection data. Filters for Class, LocationCode, StockGroupCode, BranchCode, and DepartmentCode are all evaluated against the movement records.

Default Sort

Records are sorted by DocumentDate (descending), showing the most recent movements first.

Drill-Down

Each row carries an Actions column with an Open button (and an Open in New Tab option). Opening a row navigates to its source document, determined by the SourceModule field and the row's SourceDocumentID:

IN Opens the IN Invoice at /ininvoice?documentID= using SourceDocumentID.
OE Opens the OE Order at /oeorder?documentID= using SourceDocumentID.
PO Opens the PO Order at /poorder?documentID= using SourceDocumentID.

Rows whose source module is none of the above, or that have no SourceDocumentID, are not openable.