Page 5833 "Item Statistics 2"
Base Application · Microsoft.Inventory.Analysis
Across versions
- BC23-27not present
- BC28added
- BC29-30unchanged
Neighbourhood 2 connected objects and pages
Base Application · Microsoft.Inventory.Analysis · captioned “Item Statistics” · BC28-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Item Statistics |
| SourceTable | Item Statistics Cache |
| PageType | Card |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| General | Current Inventory Value (LCY) | CurrentInventoryValue | 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. from the table field |
| Expired Inventory Value (LCY) | ExpiredStockValue | 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… from the table field | |
| This Fiscal Period | ItemDateName[1] | ItemDateNames[1] |
— |
| Sales Growth Rate (%) | SalesGrowthRateThisPeriod | 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… | |
| Net Sales (LCY) | NetSalesLCYThisPeriod | 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… from the table field | |
| Gross Margin (%) | GrossMarginThisPeriod | 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… | |
| Return Rate (%) | ReturnRateThisPeriod | 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… | |
| This Fiscal Year | PlaceHolder | PlaceHolderLbl |
— |
| Sales Growth Rate (%) | SalesGrowthRateThisFY | 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. | |
| Net Sales (LCY) | NetSalesLCYThisFY | 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… from the table field | |
| Gross Margin (%) | GrossMarginThisFY | 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… | |
| Return Rate (%) | ReturnRateThisFY | 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… | |
| Last Fiscal Year | Placeholder1 | PlaceHolderLbl |
— |
| Sales Growth Rate (%) | SalesGrowthRateLastFY | 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. | |
| Net Sales (LCY) | NetSalesLCYLastFY | 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… from the table field | |
| Gross Margin (%) | GrossMarginLastFY | 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… | |
| Return Rate (%) | ReturnRateLastFY | 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… | |
| Lifetime | Placeholder2 | PlaceHolderLbl |
— |
| Placeholder3 | PlaceHolderLbl |
— | |
| Net Sales (LCY) | NetSalesLCYLifetime | 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. from the table field | |
| Gross Margin (%) | GrossMarginLifetime | 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… | |
| Return Rate | ReturnRateLifetime | 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… |
Procedures
2 local procedures, no public ones.
Triggers
OnOpenPage, OnPageBackgroundTaskCompleted, OnPageBackgroundTaskError
Relations
- source table Table 5310 “Item Statistics Cache”
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 358 “DateFilter-Calc” (2 calls:
CreateDateFilters → CreateAccountingPeriodFilter,CreateDateFilters → CreateFiscalYearFilter)
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: "page", object_name: "Item Statistics 2"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.