Special Fee Codes

This exception report audits SKUs (Ace RSC only) where assessment fees are required to be passed on to your customers by state-level product stewardship programs. This report assumes your Eagle Special Fee Codes are set up in accordance with instructions available on Acenet. This exception audits codes assigned to relevant SKUs but does not audit the fees assigned to codes. Please click on the appropriate Acenet link below to ensure your store is charging the appropriate fee for your state.

More information about Legislative Issues can here found here (Acenet).

  • MULTI-STORE WARNING: If you are multi-store you can only do one store at a time. Select a single store in Excel as you do these steps.

    Prerequisite - Set OPT ID 1651 = Yes

    File Prep (A)

    1. Enable Editing and Enable Content.
    2. MULTI-STORES: you'll need to select 1 store at a time using the filters (column A). Data Import cannot handle all-store data at once.
    3. Click the button in the header called "Export for DI".
    4. The file is automatically prepped and needs to be saved. Save location defaults to C:\3apps\Desktop\MangoFiles..."
    5. Close out of Excel.

     

    Import the Data (B)

    1. Open Eagle Browser.
    2. Locate the folder named Data Import and click on it.
    3. Select Inventory Import Designer.
    4. Under Import File Type select Comma Delimited.
    5. In the top ribbon, select Open (F3).
    6. Select the file you saved in Step A.4 above.
    7. Double check the Import File Type is still Comma Delimited.
    8. In the top ribbon, select Map Field (F6). This is where we'll begin to tell the Eagle system what each column is from the saved file.
    9. Find and select Store (immediate update), click OK.
    10. It will ask what Position. Store was column 1 in our file so enter 1, click OK. We'll repeat this for the remaining columns.
    11. In the top ribbon, select Map Field (F6).
    12. Find and select SKU, click OK. Position 2.
    13. In the top ribbon, select Map Field (F6).
    14. Find and select Special Fee Code, click OK. Position 3.
    15. Under Import Options, set the Flex Name to SPFEE.
    16. Click on Store for chg and select the store you're working on.
    17. In the top ribbon, click Import.
    18. A new dialog box will appear, click Import.
    19. Once complete the box will pop up, click Cancel and close out of Data Import.



    Finalize Changes (C)

    1. In the Launch bar of Eagle Browser, type RFL and press Enter.
    2. Print Setup -> Print To -> S (spooler).
    3. Options -> Store -> Delete out the value so it is blank.
    4. Options -> Options -> F (update inventory file).
    5. Options -> Flex Name -> SPFEE.
    6. In the top ribbon, click Run (F4).
    7. You may see a message "No records exist for this flex name." This is okay as things can be automatically finalized for you and doesn't always require the RFL Step.
    8. You may see a message "Do you wish to exit". Click Yes.
    9. Close out of RFL. You're now complete. You can spot check IMU if you would like.

MEGA Report Special Fee Codes.png