Home > Operational Level > Level 0 - Completion > Count Sheets
Level 0 - Understanding Count Sheets The heart of Mango's Inventory Accuracy system is its monthly Count Sheets. It's important for everyone using Mango to understand this report and process them each month. For many stores, processing Mango's monthly Count Sheets using their mobile Zebra device(s) is more labor efficient. Follow the steps below to take advantage of paperless processing! If you favor paper Count Sheets, that process is outlined near the bottom of the page.
Enable MANGOAPI
Make sure your Eagle MANGOAPI queue is scheduled - the MANGOAPI creates the count sheet list in your Eagle system each month.
Update Eagle Mobile+
Role-Based Security Configuration
For a user to automatically be assigned to the count list they must be assigned to a role with security bit 423 and/or 863 set to YES.
Check which roles have these security bits set to yes.
Now you'll need to verify the person (user) counting is assigned to at least 1 role where the security bit was set to yes
Eagle Options Configuration
The first block of Option IDs below are required and must to be set to the specified value for the Count Sheets to work on your Zebra device. The second block of Option IDs are recommended settings but can be tweaked to a user's preference
Report Location
Action Email -> Office Exceptions.pdf -> usually Page 3
This report lists SKUs that are on your current Count Sheets with Count Type XX, indicating an item with very low sales volume in your store and peers. Many times these SKUs are "phantom inventory" where they exist in your computer system but have not been part of your store's assortment for a long time. Risk: the SKUs in this report are active in your RSC and risk being reordered if zeroed out during Count Sheet processing.
SKUs on this report
Steps to process report:
It's time to hit the sales floor and begin counting Count Sheets.
Quantity-on-hand variance research is the most important accuracy process in your store. PIP research is typically performed by your inventory coordinator where he/she diligently scrutinizes variances in the Physical Inventory Posting (PIP) viewer before variances are finalized. You should set dollar thresholds $15.00 (for example) that trigger mandatory research when the variance dollar amount is exceeded. Stores employing good variance research can quickly find and fix the root cause of inaccuracy.
1) Sort PIP by the Shrinkage column you created in Level 0 - Completion (Step 1), or the Repl Cost Varinace column if it's available in your PIP viewer.
Inventory counts entered into PIP from Eagle Mobile+ updates the item’s quantity on hand only after the RPI is run. To create an RPI to finalize the inventory counts, follow the steps below.
Your Count Sheet completion metric is a 3-month average and because of this we allow you to make up missed counts from the previous 2 months and get credit for the work. The steps outlined below use the LISTS feature from Eagle Browser to achieve 100% Count Sheet Completion!
Eagle Browser LISTS
LISTS is a great way to quickly see any remaining Count Sheet SKUs that still need a count. Note: if you follow the steps below but do not see the Mango Count Sheet list then a 1-time setup needs to be performed on your Eagle Server, click here for those instructions. Your Eagle Server needs to be on Level 28 (released in 2018) or higher to use this functionality.
Video Instructions
Mango's Count Types are the reason SKUs are reported on your Count Sheets. Before heading to the sales floor, print out and read through the explanation for each type. Understanding these Count Types will give you clues while out counting. Example: an XX or MC type is less likely to be found than an RC or TI , and TI types might also be in back stock.
Please be sure to review variances in PIP before finalization. Guidance can be found in the PIP Overview module.
Print the Level 0 Checklist here! Next Step - Understanding Completion Previous Step - PIP Overview