BeyondERP.Newsletter
Menu

Page · Retail and Commerce

Stock counts

A page that lists the counting journals Commerce headquarters creates for scheduled store stock counts; each journal is linked to a store's warehouse and specifies the items to count.

Used by
Materials manager, Quality control clerk, Quality control manager and 9 more roles
Business process
Maintain inventory levels
Menu item
RetailInventJournalTableCount
Main table
InventJournalTable
Data entity
InventInventoryAdjustmentJournalHeaderEntity
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 page that lists the counting journals Commerce headquarters creates for scheduled store stock counts; each journal is linked to a store's warehouse and specifies the items to count.
What you do hereUse this page to create scheduled stock counts that store staff complete with the Stock count operation in POS, and to validate and post the counts that stores send back to headquarters.
ExampleFor example, create a counting journal for a store's warehouse listing the items to count; the store then opens it in POS, counts, and commits the result back for posting.
Stock counts 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
Menu pathRetail and Commerce › Inventory management › Stock counts
Used next byStock count operation (POS) Microsoft Learn
Related pagesInventory lookup (POS) 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.

How to use it

  1. Go to Retail and Commerce > Inventory management > Stock counts.
  2. Use the Filter box to find a journal.
  3. Select New, pick the journal Name and enter a Description.
  4. Open the journal to enter the counted lines, then select Validate and Post.
  5. Use Functions and Print for the journal's other actions.

Source: Checked in Dynamics 365

Test checklist

  1. Create a scheduled stock count journal for a store warehouse with a few items.
  2. In POS, open the Stock count operation, count the items and commit.
  3. In headquarters, check the counts arrived, validate them and post.
  4. Check the store's on-hand matches the counted quantities.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Once a store completes a count in POS it is committed and sent to headquarters, where it must be validated and posted as a separate step; check the counted quantities at validation, before posting. Microsoft Learn
Technical architect

5Technical

Menu itemRetailInventJournalTableCount Checked in Dynamics 365
FormInventJournalCount Checked in Dynamics 365
TableInventJournalTableShown as “INVENTORY JOURNAL TABLE” in Record infoChecked in Dynamics 365
Data entitiesInventInventoryAdjustmentJournalHeaderEntityInventory adjustment headers Microsoft data model InventInventoryCountingJournalHeaderEntityInventory counting journal 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 RetailServiceRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerRetail warehouse clerk RetailWarehouseClerkRetail warehouse manager RetailWarehouseManagerTo use itMaterials manager InventMaterialsManagerWarehouse manager WMSWarehouseManagerQuality control manager InventQualityControlManagerQuality control clerk InventQualityControlClerkReceiving clerk InventReceivingClerkGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Validate, Post, Create lines, Functions, View postings, Print, Unlock, WorkflowChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=RetailInventJournalTableCount
Integrate withInventInventoryAdjustmentJournalHeaderEntity data entity Microsoft data model
Table definitionInventJournalTable columns and relations Microsoft data model
Everyone

7Sources