AdjustedOut | Negative Adjusted | Number | | Written off by adjustment lines with no type and a negative quantity, accumulated as a positive amount. Lowers both balances. |
Adjustment | Positive Adjusted | LargeNumber | | Added by adjustment lines with no type and a positive quantity. Counts in both balances. |
Allocation | Allocation Quantity | LargeNumber | | Reserved by allocation lines from fulfilments, sales orders and service orders. Picking moves it to Picked; delivery order and invoice lines that use an allocation without a pick take it away. Lowers Available only. |
Assemble | Assembled In | Number | | Added by adjustment lines of type Assemble and also of type Disassemble, because the seeded Disassemble setting targets this bucket. Adds to both balances. |
Available | Available | Calculated (calculated) | | Calculated free-to-promise stock: Unbilled Receipts + Transfer Inward + Purchased + Sale Return + Positive Adjusted + Excess + Assembled In, minus Unbilled Dispatches, Transfer Outward, Purchase Return, Damaged, Expired, Shortage, Allocation, Picked, Negative Adjusted, On Hold, On Loan, Inspection, Sold and Assembled Out. A posting that would make it negative is refused with 'Stock Available Quantity cannot be negative!!'. |
AverageCost | Average Cost | Currency | | Not maintained by xMatix; the mobile Stock on hand list and partner takeover display it, so it shows empty or zero. Stock value comes from inventory valuation. |
BranchId | Branch | Lookup → Branch | | The branch that holds the stock. Part of the record key, taken from the document header (each leg for transfers). Empty on tenants that run without branches. |
ClosingStock | Closing Stock | Number | | Not maintained. Closing figures come from the item ledger, the Inventory Stock statement and inventory period balances. |
CostofGoods | CostofGoods | Currency | | Not maintained by xMatix. Cost of goods sold comes from inventory valuation. |
CostPrice | Cost Price | Currency | | Not maintained by xMatix. Stock value comes from inventory valuation. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Damaged | Damaged Quantity | LargeNumber | | Written off by goods receipt, transfer inward and single-step transfer lines with a damaged quantity, and by Damaged adjustments. Lowers Available only. |
DeAllocation | DeAllocation | Number | | Never written and not part of any balance. Releasing an allocation reverses the Allocation bucket instead. |
Disassemble | Assembled Out | Number | | Never written: disassembly adjustments add to Assembled In instead. Stays at zero. |
Excess | Excess Quantity | LargeNumber | | Over-received or found quantity from goods receipt and transfer lines and Excess adjustments. Adds to both balances. |
Expired | Expired Quantity | LargeNumber | | Written off by Expired adjustments only. Lowers Available only. |
External | Quantity External | Number | | Never written and not part of any balance. |
ExternalId | External | Lookup | | |
FinancialYear | Financial Year | Number | | Not maintained: stock records have no period dimension. |
Fulfilment | Fulfilment | LargeNumber | | Never written; subtracted by Quantity Projected only. Stays at zero. |
HashCode | Hash Code | Number | | Not used on stock records. |
Id | Id | Guid | Yes | |
InHand | In Hand | Calculated (calculated) | | Calculated physical stock: Positive Adjusted + Purchased + Transfer Inward + Unbilled Receipts + Transit + Sale Return + Excess + Assembled In, minus Negative Adjusted, Sold, Transfer Outward, Purchase Return and Assembled Out. Damaged, expired, held, loaned, allocated and picked stock still counts. A posting that would make it negative is refused with 'Stock In Hand Quantity can't be negative.' |
Inspection | Inspection | LargeNumber | | Held for incoming inspection by open inspection lines on a goods receipt, released when the inspection line is marked done. Lowers Available only. |
InspectionAdjustment | Inspection Adjustment | LargeNumber | | Never written and not part of any balance. Stays at zero. |
InTransit | Transit | Number | | Released on a two-step transfer and not yet received, kept on the destination branch's record with no storage location; receiving the transfer clears it. Counts in In Hand only. |
InventoryTurnover | Inventory Turnover | Currency | | Not maintained by xMatix; any dashboard that averages it shows zero unless imported data filled it. |
Inward | Unbilled Receipts | LargeNumber | | Received but not yet billed. Goods receipt lines add to it; a bill line raised against the goods receipt line moves the quantity to Purchased. Counts in both balances. |
IsTransactionLocked | Is Transaction Locked | Boolean | Yes | Set by Start Counting and cleared by Finish Counting on a cycle count with inventory locking, for the records its count lines reference. While set, any posting that changes the record is refused with 'Item is locked for transaction! Please contact your Administrator for more details.' |
ItemId | Item | Lookup → Item | | The item. Part of the record key. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | Not used: posting never fills it and it is not part of the key. Because order and service order lines are linked to a stock record using their lot type too, a line that names an Item Lot Type is not linked and shows Stock Available 0. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | | The record's reference, set automatically from the Inventory Stock Name Setting (series IS). |
OnHold | Quantity On Hold | LargeNumber | | Blocked by OnHold adjustments. No setting releases it; it comes down only when the adjustment's posting is reversed. Lowers Available only. |
OnLoan | Quantity On Loan | LargeNumber | | Lent out by OnLoan adjustments. No setting releases it; it comes down only when the adjustment's posting is reversed. Lowers Available only. |
OpeningStock | Opening Stock | Number | | Not maintained: stock records are running totals with no period. Opening figures come from the item ledger and inventory period balances. |
Outward | Unbilled Dispatches | LargeNumber | | Delivered but not yet invoiced. Delivery order lines not raised from an invoice add to it; invoice lines with a delivered quantity take it away. Lowers Available only. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The company that owns the stock. Part of the record key, taken from the posting document's header rather than the line. Not shown on the record page; read it on the list. |
PendingDeliveries | Pending Deliveries | Number | | Added by the inward leg of a Pending Deliveries Transfer and taken away by its outward leg and by delivery order lines raised from an invoice. Not part of any balance. |
Picked | Picked Quantity | LargeNumber | | Picked for fulfilment, moved here from Allocation by picking lines and taken away by delivery order or invoice lines that use the pick. Lowers Available only. |
Pipeline | Quantity On Pipeline | LargeNumber | | Inbound quantity on posted shipments, taken away when the goods receipt for the shipment is received. Affects only Quantity Projected. |
ProfitPrice | Profit Price | Currency | | Not maintained by xMatix. |
Purchased | Purchased Quantity | LargeNumber | | Quantity posted by bill lines. A bill against a goods receipt moves quantity here from Unbilled Receipts, so balances don't change; a bill with no goods receipt adds it outright and raises both balances. |
PurchaseReturn | Purchase Return Quantity | LargeNumber | | Never written: credit notes have no inventory ledger setting, so supplier returns don't move stock. Stays at zero. |
QuantityProjected | Quantity Projected | Calculated (calculated) | | Calculated forward-looking balance that also counts inbound shipments (Pipeline) and subtracts SoftCommit, dispatches, allocation and picking. Shown on the record only; no feature reads it. |
RecordTypeId | Record Type | Guid, hidden | | |
SalePrice | Sale Price | Currency | | Not maintained by xMatix. Selling prices come from price lists. |
SaleReturn | Sale Return Quantity | LargeNumber | | Never written: credit notes have no inventory ledger setting, so customer returns don't move stock. Stays at zero. |
Shortage | Shortage | Number | | Short-received quantity from goods receipt and transfer lines and Shortage adjustments. Lowers Available only. |
SKUId | SKU | Lookup → SKU | | The item variant. Part of the record key. |
SoftCommit | SoftCommit | LargeNumber | | Committed by service order lines (the sales order line setting ships inactive). Allocation on an already-posted order or service order line moves it to Allocation. Affects only Quantity Projected. |
Sold | Sold Quantity | LargeNumber | | Added only by invoice lines that have a delivered quantity. Invoice lines drawing on an allocation or pick without a delivery release that bucket instead, and an invoice line with no allocation, pick or delivery moves no bucket at all. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The location inside the branch. Part of the record key, so the same item at two locations has two records. Empty on the in-transit record a two-step transfer keeps at the destination branch. |
TransferInward | Transfer Inward | LargeNumber | | Quantity transferred in by transfer lines. Adds to both balances. |
TransferOutward | Transfer Outward | LargeNumber | | Quantity transferred out by transfer lines. Lowers both balances. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
Value | Value | Currency | | Not maintained by xMatix. Stock value comes from inventory valuation. |
