Cycle Count Line — entity reference

One stock position or lot to count within a cycle count, generated from stock when the count's scope changes. The Lines tab offers no New, so lines come only from generation. On Hand Quantity is the book figure captured when the line is created, Recorded Quantity is what the counter found (including damaged and expired units), and Discrepency Quantity is Recorded Quantity minus On Hand Quantity. Recorded Quantity defaults to 0, so a line never recorded releases as a write-off of its whole book figure. Release For Adjustment turns each non-zero discrepancy into an untyped adjustment line and recorded damaged and expired quantities into Damaged and Expired lines, each linked back to the count line. Generated lines are checked like any item line: an inactive item, or an item that requires a SKU but has none on the line, stops the save. A line with a positive discrepancy cannot be deleted, and a line for an item already on another started-but-unfinished count of the same partner account and branch (and storage location, when set) is refused.

Fields

Actions

Validations

Lookup filters

Related entities

• SKU — looks up via SKUId
• InventoryStock — looks up via InventoryStockId
• UserAccount — looks up via CreatedById
• UserAccount — looks up via OwnerId
• Resource — looks up via CountedByResourceId
• CycleCount — looks up via CycleCountId
• UserAccount — looks up via ModifiedById
• StorageLocation — looks up via StorageLocationId
• ItemLot — looks up via ItemLotId
• ItemLotType — looks up via ItemLotTypeId
• Item — looks up via ItemId
• AdjustmentLine — referenced by via CycleCountLineId

Related topics

• Entity reference index
• Customizing xMatix