Inventory Cost Lot — entity reference

A cost layer kept by the inventory costing engine for one company's primary accounting book, one item and one branch: how much stock arrived at what unit cost, and how much of it is still on hand. FIFO and LIFO keep one layer per receipt. Moving Average and Weighted Average keep a single pool layer that holds the whole on-hand balance at the average cost. Each inventory posting deletes the layers of the item and branch it touches and rebuilds them by replaying that item and branch's whole inventory ledger. You read layers in the Valuation lots drill of the Inventory Valuation statement and on the Inventory Valuation Lot page. The newest open layer's cost is also one of the cost sources for Cost Plus pricing on quote and service order lines. Do not create or edit layers by hand.

Fields

Field	Label	Type	Required	What it does
`AccountingBookId`	Accounting Book	Lookup → AccountingBook		The accounting book the layer was costed for. Only the company's active primary book gets layers. A secondary book never has any, so the Valuation lots drill shows no lots when a secondary book is picked.
`BranchId`	Branch	Lookup → Branch		The branch whose stock the layer belongs to. Layers are kept per item and branch, so every storage location in the branch shares them.
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`EffectiveUnitCost`	Effective Unit Cost	Currency		The unit cost the valuation uses, behind the Effective Cost and Remaining Value columns of the Valuation lots drill. The engine always writes the same value as Unit Cost, because landed cost is never added to a layer.
`Id`	Id	Guid	Yes
`ItemId`	Item	Lookup → Item		The item the layer values.
`ItemLotId`	Item Lot	Lookup → ItemLot		Never filled by the engine. Under specific identification the lot is carried in Lot Key. Under the other methods layers are not tied to a lot.
`LandedCostPerUnit`	Landed Cost Per Unit	Currency		Never filled. No screen, action or job posts a landed cost voucher into the cost layers, so freight and duty are never added to a layer and the Landed / Unit column of the Valuation lots drill stays empty.
`LotKey`	Lot Key	Text		The item lot the layer belongs to under specific identification, which the seeded method list does not offer. Empty under FIFO, LIFO and the average methods, so the Lot column of the Valuation lots drill is normally blank.
`Method`	Method	Text		The costing method the layer was built under, stored as the engine token: FIFO, LIFO, MovingAverage or WeightedAverage. When the method that applies to an item and branch changes, the engine builds a new set of layers under the new method and leaves the old method's layers as they were, so both sets show in the drill.
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Name	Text	Yes	A generated name of the form ICL-, the receipt date as ddMMyyyy, a hyphen and a six-digit running number within the item and branch. It is regenerated each time the item and branch are rebuilt, so never use it as a reference.
`OriginalQuantity`	Original Quantity	Currency		The quantity the layer started with, before any issue. For the pool layer of the average methods it is the total quantity received over the item and branch's whole history.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`PartnerAccountId`	Partner Account	Lookup → Account		The company the layer belongs to.
`ReceiptDate`	Receipt Date	Date		The document date of the inventory movement that created the layer. FIFO issues the oldest date first and LIFO the newest. For the pool layer of the average methods it is the date of the first receipt.
`RecordTypeId`	Record Type	Guid, hidden
`RemainingQuantity`	Remaining Quantity	Currency		The part of the layer not yet issued. Remaining Quantity times Effective Unit Cost is the layer's remaining value. For the pool layer of the average methods it is the item and branch's whole on-hand balance as the costing engine sees it.
`Sequence`	Sequence	LargeNumber		Never filled on cost layers. Layers are ordered by Receipt Date.
`SourceLedgerId`	Source Ledger	Lookup → InventoryLedger		The inventory ledger entry that created the layer, under FIFO and LIFO. Empty on the pool layer of the average methods, which has no single receipt behind it.
`StorageLocationId`	Storage Location	Lookup → StorageLocation		Never filled. Layers are kept per branch, not per storage location, whatever a valuation policy's Costing Level says.
`UIProps`	UI Props	Text
`UnitCost`	Unit Cost	Currency		The unit cost recorded on the inventory ledger entry that created the layer. For the pool layer of the average methods it is the closing average cost.
`UpdatedDateTime`	Modified Date	DateAndTime	Yes

Actions

Action	Label	Type	What it does
`Clone`	Clone	ServerAction (`Clone`)	Create a copy of this record
`DeleteEntity`	Delete	Delete	Delete
`DeleteHeader`	Delete	Delete	DeleteHeader
`DeleteRow`	Delete	Delete	DeleteRow
`EditEntity`	Edit	Edit	Edit
`EditIn`	Edit	EditInline	Edit
`EditInline`	Edit	EditInline	Edit
`EditRow`	Edit	Edit	Edit
`NewHeader`	New	New	New

AccountingBook — looks up via AccountingBookId
Item — looks up via ItemId
ItemLot — looks up via ItemLotId
UserAccount — looks up via OwnerId
Branch — looks up via BranchId
StorageLocation — looks up via StorageLocationId
Account — looks up via PartnerAccountId
UserAccount — looks up via ModifiedById
UserAccount — looks up via CreatedById
InventoryLedger — looks up via SourceLedgerId
InventoryCostConsumption — referenced by via CostLotId
InventoryOpeningLotState — referenced by via SourceCostLotId

Inventory Cost Lot — entity reference

Fields

Actions

Related entities

Related topics