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.
Prerequisite: One-Time Back Office Setup Enable MANGOAPI Make sure your Eagle MANGOAPI queue is scheduled - the MANGOAPI creates the count sheet list in your Eagle system each month. From Eagle, type SEQ into the launch bar and press enter Look for a queue named MANGOAPI, it's usually near the bottom If the queue is not present, follow these instructions for enabling the API Update Eagle Mobile+​ Launch Eagle Mobile+. Find the version number of the application under the title on the login screen and confirm you are running version 2.4 (219) or higher. Update the application if you are running on an earlier version of Eagle Mobile+. Exit Eagle Mobile+ and launch Google Play Store Search Eagle Mobile+ Tap the search results for: Eagle Mobile+ Tap Update; once completed return to home screen 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. Open Eagle Browser In the launch bar, type RBS and press Enter In the header, click Misc Kpad Select Review Security Bit Usage for Roles Enter in bit 423 and click OK This will display a list of roles where this bit is set to YES Repeat these steps for bit 863 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 Open Eagle Browser In the launch bar, type RBS and press Enter Select the user from the User dropdown and press Refresh Verify they are assigned to the correct role and store 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 Open Eagle Browser In the launch bar, type OPT and press Enter In the header, click ID (Ctrl + i) A new window will appear, search the Option ID in the table below and change the Current Value to the Suggested Value Press Change (F5) ​ Eagle System Settings Desc. Option ID Suggested Value Completed Mobile Use Physical Inventory with Count List 1155 Yes Inventory Item Lists Enabled 9585 Yes Mark items on PI list as counted when RPI is run? 1876 Yes EM+ Physical Inventory from List with Next 1956 Yes EM+ Physical Inventory from List Auto Display 1957 Uncounted EM+ Physical Inventory Item List Field 1958 Loc Mobile Inventory Update QOH & Locations 1131 P = Update to PIP, Run RPI to Post to Inventory Number of Locations Per Item 1136 6 Mobile Physical Inventory Display finalized items in Count List 1158 No Mobile Physical Inventory Add or Replace Quantity 1141 R = Replace any existing Physical Inventory quantity with new quantity Mobile Physical Inventory Save Location? 1142 No Mobile Physical Inventory Count First Scan as 1? 1143 QOH Mobile Physical Inventory Flexible Display Field 1 1151 N = Committed Quantity Mobile Physical Inventory Flexible Display Field 2 1152 A = Retail Price Mobile Physical Inventory Flexible Display Field 3 1153 I = Discontinued Mobile Physical Inventory Flexible Display Field 4 1154 J= Store Closeout Mango on System (Eagle Level 32.1+) 2071 Yes Step 1: XX Check Report 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 Are on your current Count Sheets to be inventoried as XX Count Types. Have Store Closeout set to N (can be reordered). Are Active or Closeout in your RSC (can be replenished). Are very slow sellers in your store and in peer stores. Are not part of a "collection" (e.g. v-belts, numbered drill bits, paint bases, etc.). Are not Discovery SKUs. Are not COM excluded SKUs (Loc2 = XDR, for stores using COM). Steps to process report: Decide if the SKU should be reordered if zeroed during counting. If the SKU should be reordered then do nothing, skip to the next SKU. if you do not want the SKU reordered then: Display the SKU in Inventory Maintenance. Change to the Codes tab in Inventory Maintenance. Change the Store Closeout flag to "Y" (3rd Column). Press Change. ​ Step 2: Counting It's time to hit the sales floor and begin counting Count Sheets. From your Zebra, open the Ace Retailer app and sign in. This can be used to pull up images of Ace SKUs you may have trouble finding Return the home screen of the Zebra device Open Eagle Mobile. You can easily switch between the 2 app by clicking the "square" icon in the bottom right Enter your Eagle login Click on Physical -> from List. Select the MANGO COUNT SHEET list Select the first SKU or press the Next button to find a SKU to start with Locate the item on the sales floor and scan it If you scanned the correct SKU you'll receive a message saying "Correct Item". If you scanned the incorrect SKU it will say "is not the Item Displayed". Make sure all items on the hook/bin are the same and that the item is not also displayed in another location or in back stock. Count the item and enter in how many you counted into the Count field. Press Add, this will automatically advance to the next SKU If the screen advances to a SKU that you want to skip, press Next. You can return to count this SKU at a later time by repeating steps 5 - 12. Repeat steps 8 - 12 until all SKUs in the MANGO COUNT SHEET list have been completed. Step 3: PIP Research 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. Get a good first count It all starts with a good initial count. Our How to Count video will help your team understand the importance of counting better. Folks giving you frequent bad counts need to be identified and trained! If additional training fails then counting may not be the best task for that individual and their counting responsibility reassigned. 2. Research variances in PIP before RPI is run Variance research is the cornerstone of inventory accuracy. It's how you figure out and fix the process or person causing issues, and once fixed, the accuracy of your store increases. 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. 2) Verify each variance over/under your mandatory research policy threshold ($15.00 for example) Recount the SKU Look in nearby bins hooks for the item Look in top stock and back stock Look in return and defective bins. Look in special order shelves Look for multiple locations (clip strips, end caps, etc.) 3) Try to determine the variance root cause Was it a bad count? A count correction? Cashiering error? Receiving error? Theft? 4) If the variance was a result of a cashiering or receiving error then fix it in MPO or POS and delete the entry in PIP. Do not use PIP to correct cashiering or receiving errors as this will skew shrink, purchasing, sales and order points. 3. Perform deep variance research You can follow the Shrink Report - Variance Research help dig even deeper. Step 4: Finalize PIP 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. On the Eagle Browser Launch line, type RPI and press Enter. Set up the screens as indicated below: Print Setup In the Print To field, select S – Spool Only Options In the Reconcile Options field, select these options: F – Finalize Counting I – Change Location Codes S – Show Detail V – Print Variances Only From / To No need to specify a range Miscellaneous Print Sequence – Option 5 (Location/SKU) Fax Setup No input is required. To run the report, click Run (F4). Step 5: Count Sheet Progress Viewer 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. In Eagle Browser, launch LISTS Under List Type click the drop-down and select P Under Item List click the drop-down and select MANGO COUNT SHEETS ​(if multi-store, make sure to select your store) Locate the column Date Last PIP, you may need to add this column to the view Double click on the column header to sort the data The SKUs with the oldest Last Physical Dates will come to the top Double click again and the SKUs with BLANK or newest Last Physical Dates will come to the top Any SKU without a Last Physical Date in the current month still needs to be counted ​ Video Instructions
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 Are on your current Count Sheets to be inventoried as XX Count Types. Have Store Closeout set to N (can be reordered). Are Active or Closeout in your RSC (can be replenished). Are very slow sellers in your store and in peer stores. Are not part of a "collection" (e.g. v-belts, numbered drill bits, paint bases, etc.). Are not Discovery SKUs. Are not COM excluded SKUs (Loc2 = XDR, for stores using COM). Steps to process report: Decide if the SKU should be reordered if zeroed during counting. If the SKU should be reordered then do nothing, skip to the next SKU. if you do not want the SKU reordered then: Display the SKU in Inventory Maintenance. Change to the Codes tab in Inventory Maintenance. Change the Store Closeout flag to "Y" (3rd Column). Press Change.
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. Get a good first count It all starts with a good initial count. Our How to Count video will help your team understand the importance of counting better. Folks giving you frequent bad counts need to be identified and trained! If additional training fails then counting may not be the best task for that individual and their counting responsibility reassigned. 2. Research variances in PIP before RPI is run Variance research is the cornerstone of inventory accuracy. It's how you figure out and fix the process or person causing issues, and once fixed, the accuracy of your store increases. 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. 2) Verify each variance over/under your mandatory research policy threshold ($15.00 for example) Recount the SKU Look in nearby bins hooks for the item Look in top stock and back stock Look in return and defective bins. Look in special order shelves Look for multiple locations (clip strips, end caps, etc.) 3) Try to determine the variance root cause Was it a bad count? A count correction? Cashiering error? Receiving error? Theft? 4) If the variance was a result of a cashiering or receiving error then fix it in MPO or POS and delete the entry in PIP. Do not use PIP to correct cashiering or receiving errors as this will skew shrink, purchasing, sales and order points. 3. Perform deep variance research You can follow the Shrink Report - Variance Research help dig even deeper.
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