This report identifies SKUs in your system that have significant negative value or have negative quantity on hand month after month. This condition can indicate a purchasing issue or a Keep Stock Info misconfiguration. Significant negative value in ending inventory can obscure dollar value and can cause erroneous shrinkage to be reported. Generally, stores exclude negative value from their reported ending inventory by utilizing an option within their RIV report. However, this option is not consistently set across stores or even within the same store (different options for month-end and year-end). Because of these adverse accounting risks, negative value should be minimized. This report is part of Level 2 - Dollar Accuracy Boundary reports.

•  

  • The Keep Stock Info 'N' field is used for SKUs that the system doesn't order automatically or when QOH info doesn't need to be kept. Examples of this: Dump SKUs (for fasteners or screen repair), General Department ring SKUs (30, 40, 50).

  

  • File Prep (A)

    1. Enable Editing and Enable Content.
    2. Click the button in the header called Export SKU List.
    3. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
    4. 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), and 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 Quantity On Hand, click OK. Position 3.
    15. Under Import Options, set the Flex Name to NEGFIX.
    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 -> Enter the store you're working on.
    4. Options -> Options -> F (update inventory file).
    5. Options -> Flex Name -> NEGFIX.
    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.

  • A - Store: Eagle store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Last Sale: last time the item was sold.

  

•  

  • The Track Inventory toggle is used for SKUs that the system doesn't order automatically or when QOH info doesn't need to be kept. Examples of this: Dump SKUs (for fasteners or screen repair), General Department ring SKUs (30, 40, 50).

  

  • A - Store: Propello store ID.

    B - SKU: Item Number.

    C - Description:

    D - Location: Primary Location.

    E - QOH: Current as of the 1st of the month.

    F - Last Sale: last time the item was sold.