AllocatedQuantity | Allocated Quantity | Number | | Quantity reserved for this line: the total of its allocation lines, recounted whenever allocation lines are added, so Cancel Allocation lines bring it back down. While it is above zero the line cannot be deleted and its Item, Item Lot, SKU and source order line are locked. Do not type it; the next recount overwrites it. |
BackOrderQuantity | Back Order Quantity | Number | | Purchase order quantity raised against this line through the Back Order auto order: the total Quantity of the purchase order lines linked to it. A system field that users cannot edit. It counts as transacted, so the line's Quantity cannot be lowered below Allocated plus Cancelled plus Back Order Quantity. |
BranchId | Branch | Lookup → Branch | | Defaulted from the fulfilment. Allocation uses the fulfilment's branch, not this copy, so editing it does not redirect allocation; the Back Order auto order, however, picks up lines by this copy. |
CancelledQuantity | Cancelled Quantity | Number | | Quantity of this line that will not be reserved. Nothing in the fulfilment actions writes it; typing a value takes it out of Pending Allocation Quantity, so Allocation and the Back Order auto order leave it alone. It cannot exceed Quantity. It is not passed back to the source order line, which still counts the full Quantity as released. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
EligibleBackOrderQuantity | Eligible Back Order Quantity | Calculated | | Calculated as Pending Allocation Quantity minus Back Order Quantity: the shortfall not yet covered by a purchase order. Shown on the line's record page for information; the Back Order auto order works the figure out itself rather than reading this field. |
Id | Id | Guid | Yes | |
InventoryFulfilmentId | Inventory Fulfillment | Lookup → InventoryFulfilment | | The fulfilment this line belongs to. Its partner account and branch decide whose stock, and which branch's stock, allocation searches. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | Always empty. Fulfilment order lines have no inventory ledger setting, so they never post to stock; ledger activity starts at the allocation line. |
InventoryStockId | Stock | Lookup → InventoryStock | | Set when the line is saved to the stock record that matches the line's partner account, branch, item, item lot type, SKU and storage location exactly, and left empty when none matches. For reference only: allocation runs its own stock search and does not use this link. |
IsILPosted | IL Posted | Boolean | Yes | Not used for fulfilment order lines, which never post to the inventory ledger. |
IsILPostingApproved | IL Posting Approved | Boolean | Yes | Not used for fulfilment order lines, which never post to the inventory ledger. |
ItemId | Item | Lookup → Item | Yes | The item to reserve. Its lot and inventory tracking decide how allocation works: lot-tracked items draw from item lots, other inventory items from stock records, and an item that tracks neither gets no allocation line and no error. Locked on a line released from a sales order, and on any line once something is allocated. The item must be active, and a SKU is required when the item says so. |
ItemLotId | Item Lot | Lookup → ItemLot | | When set, allocation uses only this lot and never falls back to another one, so a lot with nothing available leaves the line unallocated. Copied from the source line; it cannot be changed on a line released from a sales order, or on any line once something is allocated. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | When set, allocation only takes lots of this lot type. Release does not copy it, so released lines accept any lot type until you set one. |
label | label | LongMultiLineText | | Display text for the line. Nothing reads it. |
LimitExpiryDays | Limit Expiry Days | Number | | For lot-tracked items: when above zero, allocation only takes lots whose expiry date falls within this many days from today, and skips lots with no expiry date. Zero, the default, applies no expiry filter. Release never sets it; it is on the line's record page only. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The line's number, assigned from the FFO series by the fulfilment order line document name setting when the line is created. |
OrderLineId | Sale Order Line | Lookup → OrderLine | | The sales order line this line was released from. Its Quantity is added to that order line's Fulfilment Order Quantity. It cannot be changed once set. Empty on lines released from a service order and on lines added by hand. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | Defaulted from the fulfilment. Allocation uses the fulfilment's partner account, not this copy; the Back Order auto order, however, picks up lines by this copy. |
PendingAllocationQuantity | Pending Allocation Quantity | Calculated (calculated) | | Calculated as Quantity minus Allocated Quantity minus Cancelled Quantity: what allocation still has to reserve. Allocation and Selective Allocation only work on lines where it is above zero, and the Back Order auto order buys for what is left here. |
Quantity | Quantity | Number | | The quantity to fulfil, copied at release from the source line's pending fulfilment quantity, or from the requested quantity in a selective release. It must be greater than zero, and it cannot be lowered below Allocated plus Cancelled plus Back Order Quantity. Lowering it gives the difference back to the source order line, which can then be released again. |
RecordTypeId | Record Type | Guid, hidden | | |
RequestedQuantity | Requested Quantity | Number | | Not stored. The quantity you enter for this line in the Selective Allocation dialog; it must be greater than zero and no more than Pending Allocation Quantity. |
ServiceOrderLineId | Work Orde Line | Lookup → ServiceOrderLine | | The service order line this line was released from, used instead of the sales order line. Its Quantity is added to that service order line's Fulfilment Order Quantity. Service order release copies no storage location. |
SKUId | SKU | Lookup → SKU | | Allocation matches the SKU exactly: a line with a SKU only takes stock or lots of that SKU, and a line without one only takes stock or lots recorded without a SKU. Locked on a line released from a sales order, and on any line once something is allocated. |
StockAvailable | Stock Available | Calculated | | Not filled in by anything, so it reads zero. Check availability on the stock record or the stock balances screen instead. |
StockInHand | Stock In Hand | Calculated | | Not filled in by anything, so it reads zero. Check stock on hand on the stock record or the stock balances screen instead. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | Allocation tries stock in this storage location first and then any other eligible stock. For items that are not lot-tracked, stock records held in a storage location are only searched when a line in the same allocation run names that location, so a line with no storage location reserves only stock recorded without one. Copied from a sales order line; service order release leaves it empty. It stays editable. |
UIProps | UI Props | Text | | |
UnitPrice | Unit Price | Currency | | Copied from the source order line. For items that are not lot-tracked it becomes the allocation line's unit cost (lot-tracked allocations take the lot's cost). It cannot be negative. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
