MEGA Report - RPA Settings Audit 

This report shows how your store's Product Analysis Report (RPA) settings (also called your ranking report) compare with the suggested settings in AWOR's (Ace Way of Retailing) order point scheme. The RPA report updates each SKU's popularity code which forms the foundation of your order point scheme (ROP). This step is essential for stores employing Ace's ROP scheme.  The AWOR Order Point scheme uses percentage breakpoints to convert percentage-based popularity into annual units sold such that SKUs with 1-8 sales per year receive a "D" popularity code (B = 9 -25 annual units, etc.) regardless of store unit volume. Therefore, each store will have custom percentage breakpoints to achieve this proper conversion.  These breakpoints need to be tuned from time to time to keep the conversion in alignment (for more information see Acenet -> AWOR -> Store Operations -> Computer Sug. Ord. -> Item Ranking).

1. In your Mango RPA Settings report, look for the text "ALERT: RPA setup issue detected."

   Where is the ALERT text?

    

   If the ALERT text is in your report, please stop here and troubleshoot your RPA setup below (there may be a sequencing or filtering issue with your report). If you need assistance please contact us.

   Troubleshoot your RPA setup

   Exclude Items section should be blank   Ranking Group and Filters should be blank   Code Selection should be all blank   RANKINV queue should be set to End of Month

   If the ALERT text is not in your report, please follow the steps below to tune your RPA (ranking) settings.

 

2. In Epicor's Eagle Browser, enter SEQ in the launch prompt to open the Schedule End-of-Day Queue.
3. Locate the RANKINV queue (this is the queue which holds the RPA report for your stores). Other possible names POPULAR, POPCODE, RANK, RPA. Caution: Do not sort any headings in SEQ as it can sequence your automated reports.



 

4. Double-click on the RANKINV queue and open the RPA report (Option U) for the desired store.



 

5. If you're prompted with a reminder to click the Queue button to save your changes, click OK to close the reminder.
6. Click the Options link in the left column.
7. In the Percentage Breakpoints fields, replace the values for each breakpoint as they are listed in the A Value, B Value, C Value, etc. column of Mango's RPA Settings report.
8. Click the Queue button (F7).
9. In the Save to EOD Queue dialog, click the 1 button to save your changes to the RANKINV queue.

Your new RPA percentage breakpoint settings will be saved and your store will be ranked with its new settings when the RPA runs at the end of the month.