BeyondERP.Newsletter
Menu

Report page · Inventory 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
Count inventory
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 processMaintain inventory levels › Count inventory
Menu pathInventory management › Inquiries and reports › Inventory value 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 itWhen you want to see how items would be classified for a period before you update their ABC classes.
How oftenOn demand, before each ABC update.
What the output showsItems with their A, B or C class for the chosen model and period, based on your percentages. If nearly every item lands in one class, the percentages or date range usually need adjusting.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Inquiries and reports > Inventory value reports > ABC classification.
  2. Enter the From date and To date of the period the classification is based on.
  3. Select the ABC models, for example Revenue, to choose what items are ranked by.
  4. Enter the percentages for A: Highest, B: Middle and C: Lowest, and the Internal interest in %.
  5. Run the report and review the class of each item. The report only shows the result; the ABC classification periodic task is the one that updates the items.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNothing to undo: The ABC report only reads transactions; item classes aren't changed. 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 itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerProduction supervisor ProdProductionSupervisorAccounting manager LedgerAccountingManagerGive 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