xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse 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
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/Inventory Cost Consumption — entity reference
REFERENCE · Last reviewed

Inventory Cost Consumption — entity reference

One draw of an issue against a cost lot, recorded per accounting book and per method because FIFO and LIFO consume different layers for the same physical issue. The sum of CostAmount across the rows sharing a SourceLedgerId is that issue's cost of goods sold, and it is exactly the amount the cost-posting service puts on the resulting COGS or inventory-loss journal. A single issue produces several rows when it spans multiple layers. Like the lots, these rows are rewritten wholesale each time the scope is replayed rather than appended to, so they are a derived audit trail rather than an event log.

Fields

FieldLabelTypeRequiredWhat it does
AccountingBookIdAccounting BookLookup → AccountingBook
BranchIdBranchLookup → Branch
CostAmountCost AmountCurrencyQuantity times unit cost, rounded to two decimals per draw so that summing the draws ties exactly to the amount posted on the cost journal - the engine deliberately sums rounded draws rather than rounding a total.
CostLotIdCost LotLookup → InventoryCostLotThe cost layer this draw was taken from. Under MovingAverage and WeightedAverage every draw points at the single synthetic pool row rather than at a receipt, so it cannot be used to trace an issue back to a purchase.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated OnDateAndTimeYes
IdIdGuidYes
IssueDateIssue DateDateThe document date of the issue movement. It is what slices consumption into fiscal periods when the inventory period balance cache derives a period's outward value.
ItemIdItemLookup → Item
MethodMethodTextThe cost-flow method that produced this draw. The same physical issue yields different consumption rows under FIFO than under LIFO, which is why the method forms part of the key rather than being derived at read time.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYesA generated identifier of the form ICC followed by the row's id and a line index. It carries no business meaning and is regenerated whenever the scope is replayed.
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → AccountThe owning company or legal entity, following the finance convention where partner account means the company rather than a trading counterparty.
QuantityQuantityCurrencyThe quantity drawn from this one layer, not the total quantity of the issue. Sum the rows sharing a SourceLedgerId to get the issued quantity.
RecordTypeIdRecord TypeGuid, hidden
SourceLedgerIdSource LedgerLookup → InventoryLedgerThe InventoryLedger issue row this draw belongs to, and the key used to total an issue's cost of goods sold; several rows share it when the issue spans multiple layers. It also acts as the idempotency anchor so re-posting an issue cannot double-consume.
UIPropsUI PropsText
UnitCostUnit CostCurrencyThe cost per unit of the layer being drawn from, or the prevailing running or period average under the average methods.
UpdatedDateTimeUpdated OnDateAndTimeYes

Actions

ActionLabelTypeWhat it does
CloneCloneServerAction (Clone)Create a copy of this record
DeleteEntityDeleteDeleteDeleteEntity
DeleteHeaderDeleteDeleteDelete
DeleteRowDeleteDeleteDeleteRow
EditEntityEditEditEditEntity
EditEntityInLineEditEditInlineEditEntityInLine
EditHeaderEditEditInlineEditHeader
EditRowEditEditEditRow
NewNewNewNew