Adjustment | Adjustment | Number | | Net signed quantity from untyped adjustment lines against this batch - this, not the adjusted-in counter, is where positive adjustments land. Counts fully into both the lot's available and in-hand balances. |
BatchNo | Batch No | Text | | Your batch identifier. Goods receipt does not copy it, so enter it on the lot; transfers and van sales copy it to the destination lot. |
BranchId | Branch | Lookup → Branch | | The branch that holds the lot. The picker lists only the chosen partner account's branches. Allocation and invoicing pick only lots at the document's branch. |
ComponentNumber | Component Number | Text | | The manufacturer's or component reference, copied from the goods receipt line and carried onto cloned lots. |
Cost | Cost | Currency | | A cost value that goods receipt and posting do not fill; transfers copy it to the destination lot. Use Unit Cost for the received cost. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | | |
DateOfDispatch | Date Of Dispatch | Date | | Not filled by any process; it holds a value only if entered by hand. Not on the seeded forms. |
DateOfExpiry | Date Of Expiry | Date | | Expiry date of the batch. Goods receipt does not fill it; enter it on the lot. When a fulfilment order line has Limit Expiry Days, auto-allocation takes only lots whose expiry is on or before today plus that many days, and skips lots with no expiry date. |
DateOfInward | Date Of Inward | Date | | Not filled by any process; Date Of Receipt is the receipt date that goods receipt sets. Not on the seeded forms. |
DateOfMfg | Date Of Mfg | Date | | Manufacturing date of the batch. Goods receipt does not fill it; enter it on the lot. Transfers copy it to the destination lot. |
DateOfReceipt | Date Of Receipt | Date | | The goods receipt's document date, set when the receipt creates the lot. |
DateOfRegistration | Date Of Registration | Date | | Registration date for registrable goods. Not filled automatically; when a receipt or invoice creates an asset from the lot, the asset takes this date. Not on the seeded forms. |
DateOfSupplierDispatch | Date Of Supplier Dispatch | Date | | The supplier's dispatch date, copied from the goods receipt header when the lot is created. Not on the seeded forms. |
DateOfSupplierInvoice | Date Of Supplier Invoice | Date | | The supplier's invoice date, copied from the goods receipt header when the lot is created. |
Disassemble | Disassemble | Number | | Always zero: no posting writes it, although both balances subtract it. |
ExternalId | External | Text | | |
ExternalName | External Name | Text | | |
HashCode | Hash Code | Number | | An internal token assigned when the lot is created. It is not a checksum and no process reads it. |
HoldCode | Hold Code | Text | | Any value quarantines the lot: invoicing and fulfilment allocation never pick a lot with a hold code. Clear it to release the lot. Nothing sets it automatically, and it is not on the seeded forms, so an administrator must add it to the lot record page before users can set it. |
Id | Id | Guid | Yes | |
IsClosed | Is Closed | Boolean | | Informational only. No process reads it, so it does not stop the lot being picked; use Hold Code for that. Not on the seeded forms. |
IsClosedForSale | Is Closed For Sale | Boolean | | Informational only. No process reads it, so it does not stop the lot being sold; use Hold Code for that. Not on the seeded forms. |
IsTransactionLocked | Is Transaction Locked | Boolean | | Set by Start Counting and cleared by Finish Counting on a cycle count with inventory locking. While it is on, any save that changes the lot, including a posting, is refused with 'Item is locked for transaction! Please contact your Administrator for more details.' A save that clears the flag is accepted. |
ItemId | Item | Lookup → Item | | The item the lot belongs to. Lot pickers on order, invoice and delivery order lines list only lots of the line's item and SKU. |
ItemLotCode | Lot Code | Text | | A short code shown in the allocation and manual-picking screens. Nothing assigns it automatically; enter it by hand if you use it. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The commercial grade of the lot's stock, such as saleable, sample or promo. Copied from the goods receipt line. When a sales line has a lot type, only lots of that type are picked; a line with no lot type accepts any lot. Not on the create form. |
LandedCost | Landed Cost | Currency | | Not filled by any receipt or posting. Not on the seeded forms. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
MRP | MRP | Currency | | Maximum retail price copied from the goods receipt line, and copied onto cloned lots. Not on the seeded forms. |
Name | Name | Text | | The lot number, generated on save from the Item Lot Name Setting (by default series LOT, a DDMMYYYY date and a six-digit counter). Document lines, ledger entries and the related-lot link refer to it. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The company that owns the lot: the goods receipt header's partner account, or the transfer's destination company for a cloned lot. Hidden on tenants that run one company. |
PurchaseDate | Purchase Date | Date | | Not filled automatically; transfers and van sales only copy it from the source lot. Not on the seeded forms. |
QuantityAdjustedIn | Postitive Adjusted | Number | | Always zero: positive adjustments are counted in Adjustment instead. |
QuantityAdjustedOut | Negative Adjusted | Number | | Batch quantity written off by negative untyped adjustment lines, accumulated as a positive magnitude because the engine applies it as a decrement of a negative quantity. |
QuantityAssembledIn | Quantity Assembled In (Future Use) | Number | | Batch quantity produced by assembly adjustments; despite the label marking it for future use it is actively written, because the seeded assemble rule's field name resolves to this property. It also absorbs disassembly adjustments, since the seeded disassemble rule points at the same assemble field. |
QuantityAssembledOut | Quantity Assembled Out (Future Use) | Number | | Always zero: no posting writes it. Disassembly adjustments are counted in the assembled-in counter. |
QuantityAvailable | Available | Calculated (calculated) | | Calculated quantity free to promise: the in-hand inflows minus everything sold, allocated, picked, on hold, under inspection, on loan, damaged, expired, short, transferred out or dispatched. Allocation and invoicing pick only lots with available quantity. |
QuantityDamaged | Damaged | Number | | |
QuantityExcess | Quantity Excess | Number | | |
QuantityExpired | Expired | Number | | |
QuantityInHand | In Hand | Calculated (calculated) | | Calculated quantity present at the location: receipts, assembly, transfers in, sale returns, excess and adjustments, minus sold, transfers out, purchase returns, damaged, expired, shortage, unbilled dispatches and quantity on loan. It can read negative when issues were posted against a lot that never received the matching quantity. |
QuantityInPendingDeliveries | Pending Deliveries | Number | | Batch quantity invoiced but not yet delivered, incremented alongside the sold counter and released again when the delivery posts. |
QuantityInTransit | Transit | Number | | The lot-level in-transit balance for two-step transfers: outward release adds the moving quantity on the destination clone, and inward receipt removes it. |
QuantityOnAllocation | Allocated | Number | | Quantity of this batch reserved by fulfilment allocation lines; picking drains it as it fills the picked counter. Subtracted from the lot's available balance and ignored by its in-hand balance. |
QuantityOnFulfillment | Quantity On Fulfillment (Future Use) | Number | | Always zero and counted in neither balance. Reserved quantity is tracked in Allocated and Picked. |
QuantityOnHold | Quantity On Hold (Future Use) | Number | | Batch quantity blocked by OnHold adjustment lines; despite the label marking it for future use it is actively maintained by posting, and is subtracted from the lot's available balance. |
QuantityOnInspection | Inspection | Number | | Batch quantity held for incoming inspection, posted from inspection lines on a goods receipt. Subtracted from the lot's available balance and ignored by its in-hand balance. |
QuantityOnInward | Unbilled Receipts | Number | | Per-lot mirror of the received-but-unbilled stock bucket, moved by the same posting call that moves the stock row. Adds to the lot's calculated available and in-hand balances. |
QuantityOnLoan | Quantity On Loan (Future Use) | Number | | Batch quantity lent out by OnLoan adjustment lines; despite the label marking it for future use it is actively maintained by posting, and is subtracted from the lot's available balance. |
QuantityOnOutward | Unbilled Dispatches | Number | | Per-lot mirror of the dispatched-but-uninvoiced bucket. Subtracted by the lot's available balance and absent from its in-hand balance. |
QuantityPicked | Picked | Number | | Quantity of this batch on picked fulfilment lines, incremented as allocation is drained. Subtracted from the lot's available balance only. |
QuantityPurchased | Purchased | Number | | Quantity posted by supplier bills that name the lot. It is counted in neither In Hand nor Available. |
QuantityPurchaseReturned | Purchase Returned | Number | | An older counter that is not stored; nothing reads or writes it. |
QuantitySaleReturned | Sale Returned | Number | | An older counter that is not stored; nothing reads or writes it. |
QuantityShortage | Shortage | Number | | |
QuantitySold | Sold | Number | | |
QuantityTransferIn | Transfer In | Number | | An older counter that is not stored and always reads empty. Transfers in are counted in Transfer Inward. |
QuantityTransferOut | Quantity Transfer Out | Decimal | | An older counter that is not stored and always reads empty. Transfers out are counted in Transfer Outward. |
RecordTypeId | Record Type | Guid, hidden | | |
RegistrationNumber | Registration Number | Text | | Registration number for registrable goods. Not filled by goods receipt; transfers copy it to the destination lot. Not on the seeded forms. |
RelatedItemLotId | Related Item Lot | Lookup → ItemLot | | The source lot this lot was cloned from by a transfer or van sale. Empty on lots created by goods receipt or by hand. Follow it to trace one batch across branches. |
SaleDate | Sale Date | Date | | Not filled by invoicing, which records the sale date on the asset instead. Not on the seeded forms. |
SerialNumber | Serial Number | Text | | Serial identity of a single-unit lot, copied from the goods receipt line. Receipt lines for items with Track Asset need one before they can be received. |
SKUId | SKU | Lookup → SKU | | The item variant the lot belongs to. Copied from the goods receipt line. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The bin or location the lot sits in. Copied from the goods receipt line, and rewritten when a transfer inward line is received with a storage location. Not on the create form. |
SupplierInvoiceNumber | Supplier Invoice Number | Text | | The supplier's invoice number, copied from the goods receipt header when the lot is created. |
TotalCost | Total Cost | Currency | | A total cost value that goods receipt and posting do not fill. It stays at zero unless entered by hand. |
TransferInward | Transfer Inward | Decimal | | Cumulative quantity transferred into this batch's location, incremented by the inward leg of a transfer posting. Counts positively into the lot's available and in-hand balances. |
TransferOut | TransferOut | Decimal | Yes | An older counter that is not stored and always reads empty. Transfers out are counted in Transfer Outward. |
TransferOutward | Transfer Outward | Decimal | | Cumulative quantity transferred out of this batch, incremented by the outward leg of a transfer posting. Subtracted by the lot's available and in-hand balances. |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | Per-unit cost copied from the goods receipt line when the lot is created, and used as the unit cost on ledger entries that move this lot. Not on the seeded forms. |
UpdatedDateTime | Modified Date | DateAndTime | | |
