Permissions Needed:
Check out our article, Users - Permissions for a Cycle Count or Full-Store Inventory.
Before You Begin Analyzing Results
- Run a database backup on the server (File > Backup).
- Printed, saved, or emailed a copy of your Inventory by Category Summary report (to have pre-reconcile inventory totals).
If you are not familiar with the Reconcile screen, check out our article, Inventory Center - Reconciliation: Navigate the Reconcile Screen.
Wait to remove your blue tape and section numbers until you complete Analyzing your results. It can be really helpful to have these accessible in case you need to go back to a specific section for verification or discrepancies.
Analyze Results
- From the Inventory Event, Click the Reconcile icon in the top toolbar
- Next, select the Category/Categories that you have scanned for. If you are doing a full store inventory, select all categories.
- Click Continue.
- The results will be displayed in the Reconcile screen.
- Recommended ways/order to Analyze the results:
- Discrepancies: It is possible to fix some of the discrepancies you will need to leave the reconcile screen. For more information on resolving discrepancies, check out our article, Inventory Center - Reconciliation: Resolve Discrepancies.
- Sort New Qty column: This helps to catch any quantity issues that could have been missed (e.g.: Case Qty items scanned as individual quantities, a sudden increase in an item that perhaps in miss labeled, etc.).
- Sort New Ext Cost column: This helps to catch any qty or case qty issues that could have been missed.
- Sort Difference column: This helps to catch any large decreases or increases between Old Ext Cost and New Ex Cost.
Updating the New Qty
Remember that if you begin modifying the New Qty and have to back out of the reconcile screen, you will lose any of the updates made to the New Qty.
- If you'd like a copy of your results after Analysis, click Export from the top toolbar. This will export the results to excel.
- Once you have finished Analyzing results, it is time to Reconcile.
Reconcile Results
- Click Reconcile in the top toolbar.
- If you are really ready, click Yes to the Reconcile Inventory prompt. If you want to go back to the results, click No.
- The Reconcile progress bar will display
- Click Ok to the Reconciliation complete prompt.
- If you'd like to print a copy of the Inventory by Category Summary Report, Click Yes to the prompt. If you'd like to save or email a copy of the report, click No to the prompt. You can do that from within Reports > Inventory folder > Inventory by Category Summary.
- From the Reconcile screen click the Back button.
If you receive the message below after hitting the Back button, your reconcile results have not been saved/updated. Click No to the prompt and click Reconcile again. If you cannot Back out of the Reconcile screen without the message popping up, contact Ascend Support.
Post Reconcile
- Run a database backup on the server (File > Backup).
- Print, save, or email a copy of your Inventory by Category Summary report (to have post-reconcile inventory totals to compare with the pre-reconcile).
- Download the Post-Inventory Shrink Adjustments Query from the Ascend ShareFile/Retailer Portal.
- Open the document and copy all available text.
- Select Reports > SQL Query in Ascend. If you are not familiar with running a custom query, check out our article, Reporting - How to Run a Custom Query.
- 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-107