Use correct filters when running reports

Select the correct filters when running inventory reports. This ensures you’re checking the right period and date for quantity updates.

Print the Count Variance Report

1. Go to Process then Count Inventory.
2. Select the option to Print the Count Variance Report.
3. Use the recommended filter settings.

This report shows the quantity differences from your count.

 NOTE: The system won't post a variance of 0.00. 

Check Inventory History

1. Go to View then Inventory.
2. Select History then Item Sequence.
3. Use the same date and period as your count.
4. This report shows posted transactions under Inventory Count. 

 NOTE: If you posted the quantities, they’ll appear here. 

Check Inventory Activity Summary

1. Go to View then Inventory.
2. Select Activity Summary.

This shows adjusted quantities by period. You can drill down for more detail.

Transactions are missing

If inventory count updates don’t show in reports, run a fix:

1. Back up your company. 
2. Go to Process then Count Inventory. 
3. Select Yes to rebuild batch quantities and follow the prompts.
4. Select Clear the snapshot without updating inventory quantities.
5. Go to Next, then select Process. 
6. Select Finish and close Sage 50cloud Pastel. 
7. Run the Stock Fix Utility.  

Reprocess Inventory Count

After running the Stock Fix Utility, reprocess the inventory count.

If issues persist, contact support for further assistance.