xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
Auto DMSConsumer Goods DMSSales Force Automation (SFA) FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Inventory Fulfillment Picking Line — entity reference
REFERENCE · Last reviewed

Inventory Fulfillment Picking Line — entity reference

A pick-list line: one picking line per allocation line that the Picking or Selective Picking action on a fulfilment drew from, listed in the Inventory Fulfillment Picking Line grid on the fulfilment's record page and numbered from the FP series. There is no New button and no list of its own in any app; a picking line without an allocation line is refused. The line copies the item, SKU, lot, lot type, storage location and unit cost from its allocation line, and moves its Quantity from the stock record's Allocation bucket to Picked as soon as it is created. Confirm Picking only turns on Picking Confirmed; it does not move stock again. Cancel Picking never edits a line: it writes a cancellation row with a negative Quantity that points to the original and posts the reverse movement. Cancellation rows are never confirmed, so once one exists the whole-document Picked Delivery refuses the fulfilment and Selective Picked Delivery must be used. Picked Delivery turns the pending quantity into delivery order lines.

Fields

FieldLabelTypeRequiredWhat it does
CancelQuantityCancel QuantityNumberRequested quantity that was not confirmed. Confirm Picking sets it to 0 on the standard screens; a cancelled pick shows in Returned Quantity instead.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
DeliveryQuantityDelivery QuantityDecimalTotal quantity of the delivery order lines raised from this pick.
DocumentDateDocument DateDateThe date the line was created.
ExternalIdExternalText, unique
IdIdGuidYes
InventoryFulfilmentAllocationLineIdFulfillment Allocation LineLookup → InventoryFulfilmentAllocationLineThe allocation line this pick draws from. Required: a picking line without one is refused with 'Picking can only be created from an Allocation Line!'.
InventoryFulfilmentIdInventory FulfilmentLookup → InventoryFulfilmentThe fulfilment the line belongs to.
InventoryLedgerIdInventory LedgerLookup → InventoryLedgerThe inventory ledger entry the line posted, filled when the line is created.
InventoryStockIdStockLookup → InventoryStockThe stock record the posting moved quantity in, filled by the posting.
IsILPostedIL PostedBooleanYesNot set by the picking actions; use Inventory Ledger to see whether the line posted.
IsILPostingApprovedIL Posting ApprovedBooleanYes
IsPickingConfirmedPicking ConfirmedBooleanYesTurned on by Confirm Picking. Picked Delivery refuses a fulfilment with any unconfirmed line, and Cancel Picking refuses unconfirmed positive lines. Cancellation rows never have it. Switching it by hand posts nothing.
ItemIdItemLookup → Item
ItemLotIdItem LotLookup → ItemLotThe lot to pick from, copied from the allocation line. Locked once the line has a positive quantity.
ItemLotTypeIdItem Lot TypeLookup → ItemLotTypeThe lot's type, copied from the allocation line.
LastModifiedByIdLastModifiedByGuid
ModifiedByIdModified ByLookup → UserAccountYes
NameDocument NumberText
OrderIdOrderLookup → Order
OrderLineIdSale Order LineLookup → OrderLineThe sales order line the picked stock answers, copied from the allocation line.
OwnerIdOwnerLookup → UserAccountYes
ParentInventoryFulfilmentPickingLineIdInventory Fulfillment Picking LineLookup → InventoryFulfilmentPickingLineOn a cancellation row, the picking line it reverses. The original's Returned Quantity is the total of the rows that point to it.
PendingDeliveryQuantityPending Delivery QuantityCalculated (calculated)Picked quantity not yet delivered: Quantity less Delivery Quantity and Returned Quantity, and 0 on a cancellation row. What Picked Delivery would deliver.
PickedByResourceIdPicked ByLookup → ResourceMeant to name the picker, but no standard screen sets it.
PickedQuantityPicked QuantityCalculated (calculated)Quantity still counted as picked: Quantity less Returned Quantity. Cancel Picking cancels it whole, even the part already delivered.
QuantityQuantityDecimalThe quantity picked, posted from the Allocation bucket to Picked. Equal to Requested Quantity on the standard screens; negative on a cancellation row. Editing it reverses and re-posts the ledger entry without comparing it with what is reserved or delivered.
RecordTypeIdRecord TypeGuid, hidden
RequestedQuantityRequested QuantityDecimalThe quantity the pick was raised for: the allocation line's pending picking quantity, or the quantity entered in Selective Picking.
ReturnedQuantityReturned QuantityDecimalQuantity cancelled from this pick: the total of its cancellation rows. Creating or deleting a delivery order line from the pick, or changing that line's Quantity or Unit Price, recounts it from the delivery lines' returned quantities instead, which drops an earlier cancellation.
ServiceOrderIdService OrderLookup → ServiceOrder
ServiceOrderLineIdService Order LineLookup → ServiceOrderLineThe service order line the picked stock answers, copied from the allocation line. Its Picked Quantity is the total of these picking lines.
SKUIdSKULookup → SKU
StorageLocationIdStorage LocationLookup → StorageLocationWhere to pick from, copied from the allocation line and carried to the delivery order line. Changing it by hand does not re-post the ledger.
UIPropsUI PropsText
UnitPriceUnit PriceCurrencyCopied from the allocation line's Unit Cost: a lot's cost, or the order line's selling price for stock that is not lot-tracked.
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteBlocked once the pick has a non-zero quantity; use CancelPicking on the fulfilment, which writes a reversing negative pick and posts the ledger back.
DeleteInListDeleteDeleteDelete
EditEntityEditEditEdit
EditInLineEditEditInlineEdit
EditListRowEditEditEditListRow
NewNewNew, inactiveDeactivated on purpose. Picks are produced only by the fulfilment's picking actions, and the handler rejects any positive-quantity pick that has no allocation-line parent.

Validations

ValidationApplies toError messageNotes
Quantity Rule ValidationQuantity, Error, inactiveQuantity shouldn't be less than zeroQuantity shouldn't be less than zero
Unit Price Rule ValidationUnitPrice, Error, inactiveUnit Price can't be less than zeroUnit Price can't be less than zero