Views:

Applies to Product -Dynamics 365 Commerce

What’s happening?
The customer is seeking to run an inventory stock report for their POS system, but the inventory tables are empty, preventing them from accessing the necessary data.


Reason:
The tables RETAILINVENTAVAILABILITY, RETAILPRODUCTWAREHOUSEINVENTORY, and RETAILITEMONHANDQUANTITY were found to be empty, which is causing the inability to generate the inventory stock report.


Resolution:
To run an inventory stock report for the POS system, follow these steps:
Scheduled Counts:

  1. Create a Counting journal in the headquarters linked to the store's warehouse.
  2. Access the predefined counting journals in POS and use the count operation.
Unscheduled Counts:
  1. Initiate an unscheduled stock count directly in POS using the count operation.
Performing Count in POS:
  1. Navigate to the Inventory section and select the count operation.
  2. Create a new stock count journal by selecting the + icon.
  3. Select the Journal name and click Create.
  4. Enter the Product Number or scan a barcode, then enter the quantity.
  5. Click Submit to send the stock count to HQ for processing.
Processing in Headquarters:
  1. Go to Retail and Inventory management > Counts.
  2. Select the stock count created from POS.
  3. Click Validate to complete the processing.
Data Synchronization:
  1. Run the Product availability from Retail and navigate to Products and inventory > Product availability. This will take a snapshot of the inventory from the SCM module.
  2. Run the 1130 (Product availability) job to sync the snapshot data that the Product availability job created from headquarters to your channel databases.

After performing these steps, the tables should be populated, allowing the customer to generate the inventory stock report. Please note that the inventory calculation method may affect the data displayed, and all on-hand availability data is considered an estimated value and may not be 100% accurate.