BeyondERP.Newsletter
Menu

Report page · Cost management

ABC classification

A report that classifies items into A, B and C classes for a date range, using the percentages you set and a chosen ABC model.

Business process
Print inventory costing reports in Dynamics 365 Finance
Menu item
output:InventABC
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that classifies items into A, B and C classes for a date range, using the percentages you set and a chosen ABC model.
What you do hereUse this report to classify items by an ABC model such as Revenue, with your own share for each class and an internal interest percentage.
ABC classification page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze financial performance › Analyze costs › Print inventory costing reports in Dynamics 365 Finance
Menu pathCost management › Inquiries and reports › Inventory accounting - analysis reports › ABC classification
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itBefore reviewing inventory policies, coverage or counting frequency per item class, typically after a full year or season of sales.
How oftenOn demand, for example once a year or when the product range changes.
What the output showsItems ranked by the selected ABC model for the period and split into classes A, B and C according to the percentages. Too many items in class A usually means the A percentage is set high or the period is too short.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inquiries and reports > Inventory accounting - analysis reports > ABC classification.
  2. Enter the From date and To date of the period whose transactions the classification is based on.
  3. Select the ABC models to use, for example Revenue, to rank items by their revenue in the period.
  4. Enter the share for A: Highest, B: Middle and C: Lowest, and the Internal interest in % used in the calculation.
  5. Run it and review which items fall in class A, B and C before you change planning or counting policies for them.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads transactions for the period; it changes nothing. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:InventABC Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerProduction manager ProdProductionManagerProduction supervisor ProdProductionSupervisorGive people one of these roles. On this system, 18 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:InventABC
Everyone

7Sources