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/Delivery Order Line — entity reference
REFERENCE · Last reviewed

Delivery Order Line — entity reference

One item being dispatched on a delivery order: item, SKU, lot, storage location, quantity, price and tax. Most lines are created by the action that creates the delivery order (Allocation Delivery, Picked Delivery and Delivery on a fulfilment or sales order, Delivery on an invoice, a Part To Part claim decision, or van-load release), and they carry a link to the source line they relieve. You can also add lines by hand with Quick Add on the delivery order's Lines tab. Creating a line moves no stock: Post Inventory on the delivery order posts every unposted line as an Outward inventory ledger movement. Changing Quantity or Unit Price on a saved line posts or re-posts that line straight away. Lines are numbered from the Delivery Order Line document name setting (series DL).

Fields

FieldLabelTypeRequiredWhat it does
AllocatedQuantityAllocated QuantityDecimalThe quantity taken from the fulfilment allocation line, set when the line is created by Allocation Delivery. Not updated afterwards.
AmountAmountCalculated (calculated)Calculated taxable amount: Base Amount less the net scheme and net discounts, or Base Amount alone when Apply Post Tax Discount is on.
ApplyPostTaxDiscountApply Post Tax DiscountBooleanWhen on, discounts are worked out on the amount including tax and taken off after tax, instead of before tax.
AssetIdAssetLookup → AssetAn asset linked to the line. None of the shipped delivery actions fill it.
BaseAmountBase AmountCalculated (calculated)Calculated as Quantity times the unit price (Unit Price 2 when it is above zero, otherwise Unit Price).
BillReturnLineIdBill Return LineLookup → BillReturnLineNot filled by any shipped flow for delivery order lines.
ContractDiscountContract DiscountPercent
ContractDiscountAmountContract Discount AmountCurrency
ConversionRatioConversion RatioDecimalThe multiplier from the line's unit of measure to the item's base unit, stamped from the item's unit-of-measure configuration when the quantity is derived.
ConversionRatio1Conversion Ratio 1Decimal
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
DeliveredInvoiceQuantityDelivered Invoice QuantityDecimalThe total quantity of invoice lines that were created from this delivery line by Create Invoice. Recalculated whenever such an invoice line is saved or deleted.
DeliveredQuantityDelivered QuantityDecimalNot maintained by the system for delivery order lines.
DeliveryOrderDiscountDelivery Order DiscountCalculated (calculated)Calculated from the delivery order's header Discount, so every line can see the header discount.
DeliveryOrderIdDelivery OrderLookup → DeliveryOrderThe delivery order this line belongs to. The partner account and branch whose stock is relieved come from this header.
DiscountDiscountPercentThe line discount percentage. A new line takes the delivery order's header discount when the header has one. Typing a Discount Amount clears it.
Discount2Cash DiscountPercent
DiscountAmountDiscount AmountCurrencyA fixed discount amount for the line. When it is above zero it is used instead of the percentage, and saving it sets Discount to 0.
DiscountAmount2Cash Discount AmountCurrency
EligibleReturnQuantityEligible Return QuantityCalculated (calculated)Calculated as Quantity minus Returned Quantity: how much of this line can still be returned.
ExternalIdExternalText
GrossAmountGross AmountCalculated (calculated)Calculated line total: Amount plus Tax Amount, less the discounts when Apply Post Tax Discount is on. Post General Ledger books the total of the lines' gross amounts.
IdIdGuidYes
InventoryFulfilmentAllocationLineIdInventory Fulfillment Allocation LineLookup → InventoryFulfilmentAllocationLineThe fulfilment allocation line this delivery relieves. Posting releases the allocated stock as well as posting the outward movement.
InventoryFulfilmentPickingLineIdInventory Fulfillment Picking LineLookup → InventoryFulfilmentPickingLineThe fulfilment picking line this delivery relieves. Posting releases the picked stock as well as posting the outward movement.
InventoryLedgerIdInventory LedgerLookup → InventoryLedgerThe inventory ledger entry this line posted. Empty until the line is posted. Post Inventory picks only lines where this is empty.
InvoicedQuantityInvoiced QuantityDecimalFor lines created from an invoice or an invoiced order line, the part of the delivery quantity that was already invoiced, set on creation. Invoice-sourced lines post this quantity against the stock pending delivery.
InvoiceLineIdSale Invoice LineLookup → InvoiceLineThe invoice line this delivery relieves, set when the delivery was made from an invoice. Posting such a line reduces the stock pending delivery instead of posting a plain outward movement.
IsGLPostingApprovedGL Posting ApprovedBoolean
IsILPostedIL PostedBooleanNot set for delivery order lines. Whether a line is posted shows in Inventory Ledger.
IsILPostingApprovedIL Posting ApprovedBooleanA per-line approval gate for inventory posting that the posting path never consults - the line is posted purely on InventoryLedgerId being empty. Setting it grants no authorisation on its own.
IsInspectionDoneInspection DoneBooleanIntended to record that the pre-delivery inspection was completed, but no code path sets it. Actual inspection evidence lives in the checklist lines that Populate Checklist creates, not here.
IsInspectionRequiredInspection RequiredBoolean
IsInsuranceDoneInsurance DoneBoolean, unique
IsRegistrationDoneRegistration DoneBoolean
IsRegistrationRequiredRegistration RequiredBoolean
ItemAliasIdItem AliasLookup → ItemAliasThe customer- or supplier-specific alias for the item, resolved on insert by the item alias service. It lets the printed delivery note show the counterparty's own product code while ItemId stays the internal item.
ItemIdItemLookup → ItemThe item being dispatched. On creation xMatix checks that the item is active and that a SKU is given where the item needs one. Locked after the first save when the line came from a sales order line.
ItemLotIdItem LotLookup → ItemLotThe lot or serial being dispatched, copied from the allocation, picking, invoice or order line the delivery came from. The picker lists only lots of the line's item and SKU. Locked after the first save when the line came from a sales order line. Not on the Quick Add form, so a hand-added line has no lot unless you set it on the line's record page.
ItemLotTypeIdItem Lot TypeLookup → ItemLotTypeThe lot type of the item, copied from the order or invoice line. The picker lists only lot types of the line's item.
ItemNameItem NameText
ModifiedByIdModified ByLookup → UserAccountYes
NameDocument NumberTextThe line number, given on creation from the Delivery Order Line document name setting (default series DL, a day-month-financial-year date part and six digits). Not entered by the user.
NetDiscountNet DiscountCalculated (calculated)Calculated total of the line, cash and contract discounts: each uses its amount when set, otherwise its percentage of the base amount (or of base plus tax when Apply Post Tax Discount is on).
NetSchemeDiscountNet Scheme DiscountCalculated (calculated)Calculated scheme discount: the scheme amount when set, otherwise the scheme percentage applied to the base amount (or to base plus tax when Apply Post Tax Discount is on).
OrderLineIdSale Order LineLookup → OrderLineThe sales order line this delivery relieves. Saving, changing or deleting the line updates that order line's delivered quantity, and its presence locks Item, SKU and Item Lot.
OriginalItemIdOriginal ItemLookup → Item
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartnerAccountText
PendingInvoiceQuantityPending Invoice QuantityCalculated (calculated)Calculated as Quantity minus Delivered Invoice Quantity: how much of this line Create Invoice can still bill. It counts only invoices raised from this delivery, so a line that was delivered from an invoice still shows its full quantity here.
PendingShippedQuantityPending Shipped QuantityCalculated (calculated)Calculated as Quantity minus Shipped Quantity. Because Shipped Quantity is never updated, it always equals Quantity and does not show what has been released to shipments.
PickedQuantityPicked QuantityDecimalThe quantity taken from the fulfilment picking line, set when the line is created by Picked Delivery. Not updated afterwards.
PolicyNumberPolicy NumberText
PriceAsOnDatePrice As On DateDate
PriceListIdPrice ListLookup → PriceList
PriceListRuleIdPrice List RuleLookup → PriceListRule
PurchaseOrderLineIdPurchase Order LineLookup → PurchaseOrderLine
QuantityQuantityDecimalThe quantity being delivered. It must be at least 1: the shipped Quantity Rule Validation refuses anything lower with the message 'Quantity cannot be 0'. This is the quantity Post Inventory posts as Outward (for invoice-sourced lines the posting uses Invoiced Quantity). Changing it on a saved line posts or re-posts the line to the inventory ledger and updates the delivered quantity on the source line.
RecordTypeIdRecord TypeGuid, hidden
RegistrationNumberRegistration NumberTextThe registration number of the delivered unit, for vehicle-style goods. No code writes it on the delivery line - the equivalent value that the system actually maintains is on the ItemLot record, which is copied lot to lot on transfers.
RequestedQuantityRequested QuantityNumberA working quantity used by the Selective Release Shipment dialog: the quantity of this line to put on the shipment.
ReturnedQuantityReturned QuantityDecimalThe total quantity of credit note lines that point back at this delivery line. Recalculated when such a credit note line is saved or deleted.
SchemeDiscountScheme DiscountPercentThe trade-scheme discount percentage, copied from the invoice line on deliveries made from an invoice.
SchemeDiscountAmountScheme Discount AmountCurrencyThe trade-scheme discount amount, copied from the invoice line on deliveries made from an invoice.
SchemeLineIdScheme LineLookup → SchemeLine
SchemeRewardPointsScheme Reward PointsLargeNumberReward points the scheme engine attached to this line when a points-based benefit applied. The scheme ledger reads it to post the points, so it is engine-written rather than user-entered.
ServiceOrderLineIdWork Orde LineLookup → ServiceOrderLine
ShippedQuantityShipped QuantityDecimalMeant to hold the quantity released to shipments. Nothing updates it, so it stays at 0.
SKUIdSKULookup → SKUThe item variant being dispatched. The picker lists only SKUs of the line's item. Locked after the first save when the line came from a sales order line.
StorageLocationIdStorage LocationLookup → StorageLocationThe storage location the goods leave from, copied from the allocation, picking or invoice line. It is part of the stock key the inventory ledger posts against. Not on any shipped line form, so a hand-added line has none.
Tax1Tax1Currency
Tax1NameTax Name 1Text
Tax1RateTax Rate 1Currency
Tax1TypeTax Type 1Text
Tax2Tax2Currency
Tax2NameTax Name 2Text
Tax2RateTax Rate 2Currency
Tax2TypeTax Type 2Text
Tax3Tax3Currency
Tax3NameTax Name 3Text
Tax3RateTax Rate 3Currency
Tax3TypeTax Type 3Text
Tax4Tax4Currency
Tax4NameTax Name 4Text
Tax4RateTax Rate 4Currency
Tax4TypeTax Type 4Text
Tax5Tax5Currency
Tax5NameTax Name 5Text
Tax5RateTax Rate 5Currency
Tax5TypeTax Type 5Text
Tax6Tax6Currency
Tax6NameTax Name 6Text
Tax6RateTax Rate 6Currency
Tax6TypeTax Type 6Text
TaxAmountTax AmountCurrencyThe line's total tax, worked out from the tax group when the line is created. It is not worked out again when you later change the quantity, price or tax group of a saved line.
TaxGroupIdTax GroupLookup → TaxGroupThe tax group used to work out the line's tax. Filled on creation from the tax group rules when you leave it empty.
UIPropsUI PropsText
UnitCostUnit CostCurrencyThe cost per unit carried through from the source allocation line when the delivery raises an invoice. Inventory posting reads UnitPrice first and falls back to this value for the ledger row's unit cost.
UnitPriceUnit PriceDecimalThe selling price per unit. Copied from the order or invoice line where the delivery came from one. A new line saved with no price is priced from the price list rules (the delivery order's price list when it has one). A price you type on a new line is kept.
UnitPrice2Unit Price 2CurrencyAn override price set from the price list rule's second price. When it is above zero, Base Amount uses it instead of Unit Price. Not on any shipped line form.
UOMUOMText
UOM1UOM1Text
UOMQuantityUOM QuantityDecimalThe quantity as entered in the line's chosen unit of measure. It is multiplied by ConversionRatio (and the second UOM leg by ConversionRatio1) to derive the base-unit Quantity, so this is what the user types and Quantity is what the system stores and posts.
UOMQuantity1UOM Quantity 1Decimal
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete
EditEditEditEdit
EditInLineEditEditInlineEdit
HeaderEditEditEditEdit
NewInLineNewNewInlineNew In Line

Validations

ValidationApplies toError messageNotes
Quantity Rule ValidationQuantity, ErrorQuantity cannot be 0Quantity cannot be 0

Lookup filters

FilterLookup fieldNotes
Lot For SKUItemLotId
Lot Type for ItemItemLotTypeId
Sku For ItemSKUId