AssetId | Asset | Lookup → Asset | | The asset created from this line. Receive creates one asset per posted line for items with Track Asset, carrying the line's received quantity, unit cost, lot and serial number. |
ClaimableQuantity | Claimable Quantity | Calculated (calculated) | | Shortage Quantity plus Excess Quantity. Calculated, for information. |
ComponentNumber | Component Number | Text | | A second identifier such as an engine or component number. Optional: Receive does not require it. Copied onto the lot and onto any asset created from the line. |
ConversionRatio | Conversion Ratio | Number | | The conversion between UOM and the item's base unit. |
ConversionRatio1 | Conversion Ratio 1 | Number | | The conversion between UOM1 and the item's base unit. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DamagedInventoryLedgerId | Damaged Inventory Ledger | Lookup → InventoryLedger | | Not filled by the shipped receiving steps. The damaged posting is recorded in the inventory ledger against the line itself. |
DamagedQuantity | Damaged Quantity | Number | | Quantity that arrived damaged. Posts to the damaged stock bucket and is left out of the inspection quantity. When an inspection line is completed, it is replaced by the total damaged quantity of the line's inspection lines. A claim generation setup can raise supplier damage claims from it. |
DateOfExpiry | Date Of Expiry | Date | | The expiry date. Cannot be earlier than Date Of MFG. Not copied onto the lot and read by no other step. Not on the shipped line forms. |
DateOfMFG | Date Of MFG | Date | | The manufacturing date. Cannot be in the future (Date Of MFG should be less than or equal to today's date). Copied onto any asset created from the line. Not on the shipped line forms. |
ExcessQuantity | Excess Quantity | Calculated (calculated) | | Received Quantity minus Supplier Quantity when more was counted than the papers say, otherwise 0. Empty while Supplier Quantity is empty. Calculated. Posts to the excess stock bucket. |
ExternalId | External | Text, unique | | |
GoodsReceiptId | Goods Receipt | Lookup → GoodsReceipt | | The goods receipt the line belongs to. Filled by the release or by adding the line from the receipt's Lines tab. |
Id | Id | Guid | Yes | |
InspectionAdjustmentInventoryLedgerId | Inventory Ledger Inspection Adjustment | Lookup → InventoryLedger | | Not filled by the shipped receiving steps. Cannot be changed once set. |
InspectionInventoryLedgerId | Inventory Ledger Inspection | Lookup → InventoryLedger | | Not filled by the shipped receiving steps. Cannot be changed once set. |
InspectionQuantity | Inspection Quantity | Number | | Filled in by the system for items with Inspection On Receipt. Inspection works from Pending Inspection Quantity, not from this field. |
InventoryFulfilmentOrderLineId | Inventory Fulfillment Order Line | Lookup → InventoryFulfilmentOrderLine | | The customer fulfilment line this stock was bought for, used by Release Back Orders. Cannot be changed once set. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The first inventory-ledger row the line posted, filled when Receive posts it. Its presence is how receiving knows the line is already in stock: Receive skips such lines, and later edits to the line do not re-post. |
InvoiceQuantity | Invoice Quantity | Number | | How much of the line has been billed, totalled from the quantity of the bill lines linked to it. |
IsApproved | Approved | Boolean | | Not set by the shipped receiving steps. |
IsClaimed | Claimed | Boolean | | Set when a claim has been generated from this line, so the same line is not claimed twice. |
IsILPosted | IL Posted | Boolean | | Not set by the shipped receiving steps. Use Inventory Ledger to see whether a line is in stock. |
IsILPostingApproved | IL Posting Approved | Boolean | | Set by Receive on the lines it receives. It is what makes the line post to stock when it is saved. |
IsPosted | Posted | Boolean | | Not set by the shipped receiving steps. |
ItemId | Item | Lookup → Item | | The item received. Copied from the purchase-order or shipment line by the release. Must be active, and cannot be changed once the line is saved (Key fields are not editable once the related objects are added). Only items with Track Inventory post to stock. |
ItemLotId | Item Lot | Lookup → ItemLot | | The stock lot of the received goods. Empty until Receive, which creates a lot for every selected line whose item tracks inventory and has none yet; you can also pick an existing lot. Lot-tracked items cannot post without it. While the item tracks lots, every later save of the line rewrites that lot's serial number, component number, MRP, unit cost, lot type and storage location from the line. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot type (for example new or used stock) the received goods are booked under. Copied onto the lot Receive creates. Not filled by the releases. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
MRP | MRP | Currency | | The maximum retail price printed on the goods. Must be above zero when entered (the message says MRP can't be negative). Copied onto the lot. Not used for valuation. |
Name | Document Number | Text | | The line number, generated on create from document numbering (shipped series GRNL, the date as DDMMYYYY and a six-digit counter). |
OrderedQuantity | Ordered Quantity | Number | | The quantity the purchase-order line released onto this receipt (the requested quantity, or the order line's pending quantity). Empty on lines released from a shipment. It is a system field: changing it on a saved line is refused. Ticking the line in the Receive panel copies it into Supplier Quantity and Received Quantity when it is above zero. A line linked to an order line posts inward stock only when this is above zero. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PackageGoodsReceiptLineId | Package Goods Receipt Line | Lookup → GoodsReceiptLine | | A link to a package (kit) line on the same receipt. Not filled by the shipped release steps. |
PendingInspectionQuantity | Pending Inspection Quantity | Calculated (calculated) | | Received Quantity minus Started Inspection Quantity. Calculated. Inspection creates an inspection line only while this is above zero. |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | Received Quantity minus Invoice Quantity. Calculated. Release Bill puts this quantity on the new bill line and needs at least one line where it is above zero. |
PipelineQuantity | Pipeline Quantity | Calculated (calculated) | | The Supplier Quantity when the line was released from a shipment whose stock was already posted in transit, otherwise 0. Calculated. Such lines move their quantity out of the in-transit bucket into inward stock. |
PurchaseOrderLineId | Purchase Order Line | Lookup → PurchaseOrderLine | | The purchase-order line the quantity was released from. It drives the over-receipt check, the order line's Receipt Quantity roll-up and the three-way match. Empty on lines added by hand. |
ReceivedQuantity | Received Quantity | Number | | The quantity physically counted in. On receipts released from a purchase order this is the quantity that posts to inward stock. It is also what the receipt's Total Amount, the accrual journal, the bill release and the three-way match use, so fill it on every kind of receipt. A line with a received quantity above zero cannot be deleted. |
RecordTypeId | Record Type | Guid, hidden | | |
ReturnedQuantity | Returned Quantity | Number | | Quantity returned to the supplier, totalled from the bill-return credit note lines linked to this line. |
SerialNumber | Serial Number | Text | | The serial or chassis number of the unit. Required by Receive only for items with Track Asset; other items may leave it empty. Copied onto the lot Receive creates and from there onto the asset. Not copied from a shipment line by Release Receipt, so enter it on the receipt line. |
ShipmentLineId | Shipment Line | Lookup → ShipmentLine | | The inbound shipment line the line was released from. Its Supplier Quantity rolls back into the shipment line's Receipt Quantity. |
ShortageQuantity | Shortage Quantity | Calculated (calculated) | | Supplier Quantity minus Received Quantity when the supplier quantity is higher, otherwise 0. Calculated. Posts to the shortage stock bucket. |
SKUId | Item SKU | Lookup → SKU | | The item variant. Required when the item requires a SKU and must belong to the item. Cannot be changed once the line is saved. The SKU's Maximum Lot Quantity, or else the item's, splits a new line into several lines of at most that quantity. |
StartedInspectionQuantity | Started Inspection Quantity | Number | | How much of the line has been sent to inspection, totalled from the received quantity of its inspection lines. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The bin or location in the branch the goods are put away to. The stock posting is booked against it, and it is copied onto the lot and onto split lines. |
SupplierQuantity | Supplier Quantity | Number | | The quantity on the supplier's delivery papers. Required before Receive. The supplier quantities of all receipt lines for one purchase-order line cannot add up to more than that order line's quantity minus its cancelled quantity. On receipts released from a shipment or created by hand, this is the quantity that posts to inward stock. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The tax group carried onto the bill line that Release Bill creates. Not filled by the releases and not copied onto the extra lines a maximum-lot split creates. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost per unit, copied from the purchase-order line's unit cost or the shipment line's unit price. It becomes the cost of the stock and of the lot, and the basis of the receipt's Total Amount and accrual journal. Changing it after Receive does not revalue the stock already posted. |
UOM | UOM | PickList | | An alternative unit of measure for the quantity. Must be one of the item's units of measure. With a unit picked, Received Quantity and UOM Quantity are kept in step through the item's conversion. Values: MB, Messages, Pack, Each. |
UOM1 | UOM1 | PickList | | A second alternative unit of measure, used like UOM. Values: Pack, Each. |
UOMQuantity | UOM Quantity | Number | | The received quantity expressed in the alternative unit (UOM). |
UOMQuantity1 | UOM Quantity1 | Number | | The received quantity expressed in the second alternative unit (UOM1). |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |