The open cost lots at the start of a fiscal period, one row per lot, keyed by partner account + accounting book + fiscal period + item + branch + valuation method. It exists so inventory valuation can be replayed for a single period from an opening snapshot plus that period's movements instead of from inception, with each period's closing lots rolled forward as the next period's opening rows. It is a derived artefact, not a data-entry entity, and is blocked from integration sync for that reason.
Fields
| Field | Label | Type | Required | What it does |
|---|
AccountingBookId | Accounting Book | Lookup → AccountingBook | | The book this snapshot belongs to. Secondary books do not keep their own perpetual per-method balances, which is exactly why they need these snapshots to bound a replay to one period. |
BranchId | Branch | Lookup → Branch | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
FiscalPeriodId | Fiscal Period | Lookup → FiscalPeriod | | The period this snapshot opens, not the period it was computed from - a period's closing lots are written forward against the following period. |
Id | Id | Guid | Yes | |
ItemId | Item | Lookup → Item | | |
LotKey | Lot Key | Text | | The lot identity used only under specific identification valuation; it is left empty for methods such as FIFO or weighted average, where lots are consumed by sequence rather than by name. |
Method | Method | Text | | The valuation method this snapshot was produced under, part of the row's identity: the same item and period can hold separate opening lots per method, which is what lets a secondary accounting book be replayed differently from the primary one. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | |
ReceiptDate | Receipt Date | Date | | The original receipt date of the lot, preserved across the roll-forward so date-ordered valuation methods keep their ageing after a period boundary. |
RecordTypeId | Record Type | Guid, hidden | | |
RemainingQuantity | Remaining Quantity | Currency | | The quantity still unconsumed in this lot at the period boundary. Replay seeds the period with these as leading receipts, so this is the opening balance the period's issues draw against. |
Sequence | Sequence | LargeNumber | | The consumption order of this lot within the snapshot, assigned when a period's closing lots are rolled forward. Replay reconstructs the opening lots by this order first and receipt date second, so it determines which lot is drawn down first. |
SourceCostLotId | Source Cost Lot | Lookup → InventoryCostLot | | A soft reference back to the perpetual cost lot this snapshot row came from, held without a foreign key so pruning cost lots cannot break a period's opening state. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The cost per unit carried by this open lot into the new period, and therefore the rate at which its remaining quantity is charged out when consumed. |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
