BeyondERP.Newsletter
Menu

Transaction page · Inventory management

Counting

A journal page where you record a physical count of items at a location and post it against the on-hand inventory.

Used by
Materials manager, Quality control clerk, Quality control manager and 9 more roles
Business process
Count inventory
Menu item
InventJournalTableCount
Main table
InventJournalTable
Data entity
InventInventoryCountingJournalHeaderEntity
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 journal page where you record a physical count of items at a location and post it against the on-hand inventory.
What you do hereUse this journal to post count differences; when the counted quantity differs from on hand, an inventory receipt or issue is posted.
ExampleFor example, you can set up counting groups so that items are counted at a set frequency or when stock drops to a certain level.
Counting 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 › Journal entries › Item counting › Counting
Set up firstCounting groups Microsoft Learn Inventory journal names Microsoft Learn
Used next byCounting history Microsoft Learn
Related pagesTag counting Microsoft Learn
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.

Steps from Microsoft

  1. Go to Inventory management > Journal entries > Item counting > Counting.
  2. Select New, choose the counting journal name and the Worker, and select OK.
  3. Select New and enter the Item number.
  4. Enter the Site, Warehouse and Location.
  5. In the Counted field, enter the quantity you counted.
  6. Select Save.
  7. Select Post, and then select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
CountedThe quantity you counted; if it differs from On-hand, the Quantity field shows the difference.Microsoft Learn
Counting reason codeThe reason code that explains the count on the line.Microsoft Learn
Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
If you change it laterIf Lock items during count is turned on in the parameters, items can't be physically updated while they are being counted. Microsoft Learn
Technical architect

5Technical

Menu itemInventJournalTableCount Checked in Dynamics 365
FormInventJournalCount Checked in Dynamics 365
TableInventJournalTableShown as “Inventory journal table” in Record infoKey field: JournalId, JournalType, JournalNameId, DescriptionChecked in Dynamics 365
Data entitiesInventInventoryCountingJournalHeaderEntityInventory counting journal headers Microsoft data model InventInventoryAdjustmentJournalHeaderEntityInventory adjustment headers Microsoft data model InventInventoryMovementJournalHeaderEntityInventory movement headers Microsoft data model ProjectItemJournalTableEntityProject item journal header Microsoft data model
Who can open itPrivilegesMaintain counting journals InventJournalTableCountMaintainView counting journals InventJournalTableCountViewMaintain retail stock counts RetailStockCountsMaintainDutiesApprove physical inventory counting InventPhysicalInventoryCountingApproveMaintain physical inventory counting InventPhysicalInventoryCountingMaintainMaintain retail counting RetailCountingMaintainMaintain retail store inventory worksheets RetailStoreInventoryWorksheetsMaintainInquire into warehouse operation progress WMSWarehouseOperationProgressInquire
12 security rolesMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkQuality control manager InventQualityControlManagerReceiving clerk InventReceivingClerkShipping clerk InventShippingClerkRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store manager RetailStoreManagerRetail warehouse clerk RetailWarehouseClerkRetail warehouse manager RetailWarehouseManagerWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorker
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceWarehouse worker WMSWarehouseWorkerRetail store manager RetailStoreManagerRetail operations manager RetailOperationsManagerRetail warehouse clerk RetailWarehouseClerkTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkShipping clerk InventShippingClerkGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventJournalTableCount
Integrate withInventInventoryCountingJournalHeaderEntity data entity Microsoft data model
Data migrationInventInventoryCountingJournalHeaderEntity (Inventory counting journal headers): loaded for each company.Microsoft Learn
Table definitionInventJournalTable columns and relations Microsoft data model
Everyone

7Sources