During a full-store inventory (or cycle count) the first thing you need to do is scan your products, and then move that data from the scanner onto your computer. Article: Walking through the inventory scanning process for Cycle Counts and Full-Store Inventory.
Once you've imported those files into Ascend, it's time to Analyze inventory scan results and fix any discrepancies.
Once everything is done, you can reconcile.
Note: Reconciling your inventory counts from the Inventory Center hides the Inventory Event.
Before you reconcile
Look back over everything and make sure you're comfortable with the results (namely, the New qty column). Once you hit that reconcile button, it can not be undone!
Then click Analyze. This updates and saves any changes you've made. Your Discrepancies should clear up at this point.
Let's reconcile your inventory
- Once you're done and feeling good about what's on your screen, you can select Reconcile.
- Select Yes on the pop-up to confirm you want to reconcile the inventory.
- You'll be prompted to print the Inventory by Category summary report, which you can use for comparison between your "pre-inventory" and "post-inventory" values.
- Create a database backup by selecting File > Backup on the Ascend desktop.
- Download the post-inventory shrink adjustments query from the Ascend Retailer Portal.
- Open the document and copy all available text.
- Select Reports > SQL Query in Ascend.
- Paste the text in the upper portion of the screen.
- Select Execute.
- You'll get a date prompt. These dates should correspond with the date of your last full-store inventory and the current full-store inventory.
- Then click OK.
The results will display. You can export the results to Excel by selecting the Export icon, if needed.
If you want to know your total shrink value for this full-store inventory, export the report to Excel and then add up the Monetary Change column to get the total value.
Additional Resources
KB22-115