Table 5310 "Item Statistics Cache"
Base Application · Microsoft.Inventory.Analysis
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC26-27not present
- BC28added
- BC29-30unchanged
Neighbourhood 2 connected objects and pages
Base Application · Microsoft.Inventory.Analysis · BC23-25, BC28-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Item Statistics Cache |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Item No. | Code[20] | — | |
| 22 | Description | Text[100] | — | |
| 2 | ItemLedgerEntryNoLatest | Integer | — | |
| 3 | ValueEntryNoLatest | Integer | — | |
| 4 | LastUpdated | Date | — | |
| 5 | CurrentInventoryValue | Decimal | Specifies the current inventory value (in local currency), calculated as the sum of Cost Amount (Actual) + Cost Amount (Expected) on posted Value Entries for this item. Run the Adjust Cost - Item Entries batch job to ensure the amount is up to date. | |
| 6 | ExpiredStockValue | Decimal | Specifies the inventory value (in local currency) of quantities whose expiration date is earlier than the work date. Calculated as the sum of Cost Amount (Actual) + Cost Amount (Expected) from Value Entries applied to open Item Ledger Entries (Remaining Qty. > 0) with Expiration Date < Work Date. Ru… | |
| 7 | SalesGrowthRateThisPeriod | Decimal | Specifies the percentage change in sales compared to the previous period in the fiscal year, calculated as ((Sales in the current period in the fiscal year - Sales in the prior period in the fiscal year) ÷ Sales in the prior period in the fiscal year) x 100%. A positive value indicates growth, while… | |
| 8 | NetSalesLCYThisPeriod | Decimal | Specifies the total revenue (in local currency) from sales for the current period in fiscal year after deducting given discounts and returns. This value represents the actual income generated from sales transactions during the fiscal year. Calculated as: Net Sales = Total sales in the period - Tota… | |
| 9 | GrossMarginThisPeriod | Decimal | Specifies the percentage of revenue remaining after deducting the cost of goods sold (COGS) for the current period in the fiscal year. This metric indicates how efficiently the company produces and sells its products. Calculated as: Gross Margin (%) = ((Net Sales - COGS) ÷ Net Sales) x 100%. A highe… | |
| 10 | ReturnRateThisPeriod | Decimal | Specifies the percentage of sold quantity that were returned during the current period in the fiscal year. This metric helps measure product quality and customer satisfaction. Calculated as: Return Rate (%) = (Returned Quantity ÷ Total Sold Quantity) x 100%. A lower percentage indicates fewer return… | |
| 11 | SalesGrowthRateThisFY | Decimal | Specifies the percentage change in sales compared to the previous fiscal year, calculated as ((Sales in current fiscal year - Sales in the last fiscal year) ÷ Sales in the last fiscal year) x 100%. A positive value indicates growth, while a negative value indicates a decline in sales. | |
| 12 | NetSalesLCYThisFY | Decimal | Specifies the total revenue (in local currency) from sales for the current fiscal year after deducting given discounts and returns. This value represents the actual income generated from sales transactions during the fiscal year. Calculated as: Net Sales = Total sales in the fiscal year - Total retu… | |
| 13 | GrossMarginThisFY | Decimal | Specifies the percentage of revenue remaining after deducting the cost of goods sold (COGS) for the current fiscal year. This metric indicates how efficiently the company produces and sells its products. Calculated as: Gross Margin (%) = ((Net Sales - COGS) ÷ Net Sales) x 100%. A higher percentage r… | |
| 14 | ReturnRateThisFY | Decimal | Specifies the percentage of sold quantity that were returned during the current fiscal year. This metric helps measure product quality and customer satisfaction. Calculated as: Return Rate (%) = (Returned Quantity ÷ Total Sold Quantity) x 100%. A lower percentage indicates fewer returns and higher p… | |
| 15 | SalesGrowthRateLastFY | Decimal | Specifies the percentage change in sales compared to the previous fiscal year, calculated as ((Sales in the last fiscal year - Sales in the prior fiscal year) ÷ Sales in the prior fiscal year) x 100%. A positive value indicates growth, while a negative value indicates a decline in sales. | |
| 16 | NetSalesLCYLastFY | Decimal | Specifies the total revenue (in local currency) from sales for the last fiscal year after deducting given discounts and returns. This value represents the actual income generated from sales transactions during the last fiscal year. Calculated as: Net Sales = Total sales in the last fiscal year - Tot… | |
| 17 | GrossMarginLastFY | Decimal | Specifies the percentage of revenue remaining after deducting the cost of goods sold (COGS) for the last fiscal year. This metric indicates how efficiently the company produces and sells its products. Calculated as: Gross Margin (%) = ((Net Sales - COGS) ÷ Net Sales) x 100%. A higher percentage refl… | |
| 18 | ReturnRateLastFY | Decimal | Specifies the percentage of sold quantity that were returned during the last fiscal year. This metric helps measure product quality and customer satisfaction. Calculated as: Return Rate (%) = (Returned Quantity ÷ Total Sold Quantity) x 100%. A lower percentage indicates fewer returns and higher prod… | |
| 19 | NetSalesLCYLifetime | Decimal | Specifies the total revenue (in local currency) from sales after deducting given discounts and returns. This value represents the actual income generated from sales transactions during the lifetime. Calculated as: Net Sales = Total sales so far - Total returns so far - Total given discounts so far. | |
| 20 | GrossMarginLifetime | Decimal | Specifies the percentage of revenue remaining after deducting the cost of goods sold (COGS) for the lifetime. This metric indicates how efficiently the company produces and sells its products. Calculated as: Gross Margin (%) = ((Net Sales - COGS) ÷ Net Sales) x 100%. A higher percentage reflects bet… | |
| 21 | ReturnRateLifetime | Decimal | Specifies the percentage of sold quantity that were returned during the lifetime. This metric helps measure product quality and customer satisfaction. Calculated as: Return Rate (%) = (Returned Quantity ÷ Total Sold Quantity) x 100%. A lower percentage indicates fewer returns and higher product acce… |
Keys
- Key1: Item No. (clustered)
Procedures
InitAndInsert(ItemNo: Code[20])(obsolete 29.0: Use InitAndInsert with ItemNo and ItemDescription parameters instead.)InitAndInsert(ItemNo: Code[20]; ItemDescription: Text[100])UpdateIfNeeded(Item: Record Item; CurrentDate: Date; ItemDateFilters: array[4] of Text[30]; PriorPeriodItemDateFilters: array[4] of Text[30]): Update the Item Statistics Cache record if there are new Item Ledger entries or Value entries, or if the month has changed.
Plus 4 local procedures.
Pages and codeunits on this table
- Page 5833 “Item Statistics 2” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 5833 “Item Statistics” (6 calls:
UpdateForItemLedgerEntry → CalculateProductReturnRate,UpdateForValueEntry → CalculateCurrentInventoryValue,UpdateForValueEntry → CalculateExpiredStockValue, …)
Deprecations
- procedure InitAndInsert: Pending 29.0 (#if not CLEAN29), “Use InitAndInsert with ItemNo and ItemDescription parameters instead.”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Item Statistics Cache"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.