Product Analysis Report (RPA)

About the Product Analysis Report (RPA)

The Product Analysis Report (RPA) ranks inventory items based upon their sales history.  By comparing the popularity and inventory value of each item, you can determine whether or not your inventory investment is distributed properly.

Report RPA optionally updates both the popularity and user codes in Inventory Maintenance.  On most Inventory reports, you can use these codes to include or exclude items.

Note:  Any items that have an N in either the Keep Prices field or the Keep Stock Info field in Inventory Maintenance (Codes tab) never print on the RPA.

For more information about how the system calculates product ranking using the breakpoints and A, B, C ranking codes, click here to go to the RPA ranking help topic.

Options Setup for RPA

Review the following options in Options Configuration that affect the Product Analysis Report (RPA).

Option 8461 "Number of breakpoints allowed in the Product Analysis Report (RPA)"This option was added for Automotive (JCON Eagle) where eight movement code rankings are used. This option defaults to four codes, which is typically used in the Hardware/Homecenter/Lumber market, but can be changed to 8 if desired.

Set this option to 4 (the default) if you use four breakpoints when ranking the popularity of your items with the Product Analysis Report (RPA). Set this option to 8 if you use eight breakpoints. You may also want to review option 8389 "Popularity Code Schema." This option determines whether your Popularity codes are alpha or numeric codes.

Option 8389 "Popularity Code schema"This option was added for Automotive (Jcon Eagle) where numeric movement code rankings are used.  This option defaults to "alpha" codes, which are typically used in the Hardware/Homecenter/Lumber market, but can be changed to numeric if desired.

Set this option to 1 if you want your Popularity Codes to be the values A through D plus X  if using four breakpoints, or A through H plus X if using eight breakpoints. Otherwise, set this option to 2 if you want your Popularity Codes to be the values 1 through 4 plus X, or 1 through 8 plus X.  
The number of breakpoints used in the Product Analysis Report (RPA) is defined in Option 8461 "Number of breakpoints allowed in the Product Analysis Report (RPA)".  

(Optional) Double Ranking Code Setup for RPA

If you want to double-rank your items (i.e. by gross profit dollars AND by units sold), you can set up Double Ranking Codes which allow you to define how you want to update the Popularity Code when running RPA with option R, the Double Ranking option. Note that Option 8389 ’Popularity Code Schema’ must be set to 1 (A-H) to set up Double Ranking Codes. Click here to go to the setup topic for Double Ranking Codes.

Printing the Product Analysis Report

1. From the Eagle Browser, click Reports Menu, Inventory Reports, Product Analysis (RPA).  The Product Analysis Report window displays.

2. If you have set up a Default Report Profile for this report, you can simply click Run to use the defaults.  Or, you can retrieve a saved report, make any necessary changes, and click Run.  Otherwise, continue with the next step.

3. From the page, review the default entries in the fields and make changes if needed.  For a definition of each field, click here.

4. Click . A page of fields displays.  In the Options field, click in the box to the left of the options you want.  Fill in any other fields on the page, as desired.  For a definition of each field, click here.

5. Click .  A page of fields displays.  

   6. • Fill in the Store, Ranking Group, and Max # Per Group fields as desired.

      • In the lower portion of the window, fill in the desired fields to limit the items that are included on the report.  

For a definition of each field, click here.

6. (Optional) Click . A page of fields displays. Fill in the desired fields to include or exclude groups of items.  

7. (Optional) Click . A page of fields displays. Fill in the fields if you want to fax the report.

For a definition of each field, click here.

8. Click Run if you are running this report now, or click Queue if you are adding this report to a queue. For more information about creating queues, click here.

Top