BeyondERP.Newsletter
Menu

Setup page · Inventory management

Counting reason codes

A setup page where you create the reason codes that are recorded when inventory is counted or adjusted.

Used by
Materials manager, Quality control clerk, Quality control manager and 5 more roles
Business process
Maintain inventory levels
Menu item
InventCountingReasonCode
Main table
InventCountingReasonCode
Data entity
InventInventoryCountingReasonCodeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you create the reason codes that are recorded when inventory is counted or adjusted.
What you do hereUse this page to analyze counting results and differences, and to post adjustments to the right offset account based on the reason.
ExampleFor example, a reason code can record that a count was done because of a broken pallet.
Counting reason codes 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

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.

Step by step, with screenshots

Set up Counting reason codes1 screen

Use this page to analyze counting results and differences, and to post adjustments to the right offset account based on the reason.

  1. Screen 1

    Create a counting reason code

    Go to Inventory management > Setup > Inventory > Counting reason codes

    1. Select New
    2. Enter the counting reason code and a description
    3. Optionally choose the offset account that adjustments with this reason post to
    4. Select Save
    5. Add the code to a counting reason code group so workers can pick it during counting
    1Counting reason codeBEAT-DMG
    DescriptionDamaged goods
    Offset account610100
    Create a counting reason code (zoomed on the outlined fields)
    Show the full screenCreate a counting reason code
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Inventory management > Setup > Inventory > Counting reason codes.
  2. On the Action Pane, select New.
  3. Enter the Counting reason code and a Description.
  4. Optionally, enter or select an Offset account.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Counting reason codeThe code that states why a count or adjustment was made.Microsoft Learn DAMAGEDReasonCode
Offset accountThe account that counting journals using this code post to.Microsoft Learn 610100LedgerDimension
DescriptionA description of the counting reason code.Microsoft Learn Damaged goodsDescription

Test checklist

  1. Create a code DAMAGE with an offset account and a code RECOUNT without.
  2. Post a counting journal line with a negative difference and reason DAMAGE.
  3. Check the voucher posts the offset to the DAMAGE account.
  4. Post a line with RECOUNT and check it uses the inventory posting profile account; check Counting history shows the reason codes.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Counting reason codesAgree a reason code strategy first, and give a code an Offset account only where that reason must post to its own accountLearn recommends defining the strategy (how many codes, mandatory or not, whether codes drive offset posting) before setup. A code's offset account replaces the inventory posting profile account when counting journals post.Adding an offset account to a code without telling finance: counting journals that use the code post to that account instead of the inventory posting profile account.Test: Counting reason code offset account
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Codes and offset accounts can be changed at any time and apply to counting journals posted afterwards. Microsoft Learn
If you change it laterWhen a code has an offset account, counting journals that use the code post to that account instead of the inventory posting profile account. Microsoft Learn
Technical architect

6Technical

Menu itemInventCountingReasonCode Checked in Dynamics 365
FormInventCountingReasonCode Checked in Dynamics 365
TableInventCountingReasonCodeShown as “Counting reason codes” in Record infoKey field: ReasonCode, Description, LedgerDimensionChecked in Dynamics 365
Data entitiesInventInventoryCountingReasonCodeEntityCounting reason codes Microsoft data model
Who can open itPrivilegesMaintain counting reason codes InventCountingReasonCodeMaintainView counting reason codes InventCountingReasonCodeViewMaintain offset account for counting reason code InventCountingReasonOffsetAccountMaintainDutiesInquire into warehouse operation policies WMSWarehouseOperationPoliciesInquireEnable warehouse operation process WMSWarehouseOperationProcessEnableInquire into warehouse operation progress WMSWarehouseOperationProgressInquire
8 security rolesMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkQuality control manager InventQualityControlManagerReceiving clerk InventReceivingClerkShipping clerk InventShippingClerkWarehouse planner WHSWarehousePlannerWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorker
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itWarehouse manager WMSWarehouseManagerTo use itQuality control manager InventQualityControlManagerMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkShipping clerk InventShippingClerkWarehouse worker WMSWarehouseWorkerGive people one of these roles. On this system, 8 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventCountingReasonCode
Integrate withInventInventoryCountingReasonCodeEntity data entity Microsoft data model
Data migrationInventInventoryCountingReasonCodeEntity (Counting reason codes): loaded for each company.Microsoft Learn
Table definitionInventCountingReasonCode columns and relations Microsoft data model
Everyone

8Sources