Discontinued Flag Mismatch

This report identifies SKUs that are flagged as discontinued in your system, although they are still active in your Ace warehouse.

  • Steps to process this report:

    1. In Epicor's Eagle Browser, open Inventory Maintenance.
    2. Enter a SKU from your Discontinued Flag Mismatches report and click the Display button.
    3. Select the Codes tab.
    4. Situation A: The store's Discontinued (Disc) Flag is set to Y when the item is still Active at the RSC
    5. Select N from the Discontinued field (3rd column in IMU). (Multi-store note: The Discontinued setting is master data and applies to all of your stores.)
    6. Select Y from the Store Closeout field if you do not wish to stock this SKU (if you wish to stock the SKU then select N).
    7. Multi-store step: The Store Closeout setting is specific to the store selected in the Store field. To change the Store Closeout setting for other stores, select a different store and click the Change button. Repeat this step for each store you want to change.
    8. Click the Change (F5) button to save the changes.
    9. Situation B: The store's Disc flag is set to N when the item has been canceled at the RSC
    10. Select Y from the Discontinued field (3rd column in IMU). (Multi-store note: The Discontinued setting is master data and applies to all of your stores.)
    11. Click the Change (F5) button to save the changes.
    12. Repeat these steps for each SKU listed in your Discontinued Flag Mismatches report.

    • This process outlines a fast and effective way to fix Discontinued flag issues. The risk involved is when updating a SKU's DISC flag back to No since it is active in your RSC. This can cause product to order again on an RSO when you potentially did not want it. Because of this please manually review the store closeout flag for SKUs where the RSC Disc (Column I) is set to No.

      File Prep (A)

      1. Enable Editing and Enable Content. Enable Content
      2. Sort out any data you may want to exclude using the column filters. Consider filtering out RSC Disc = N based on the warning above.
      3. Click the button in the header called "Export for DI".
      4. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the 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 Discontinued, click OK. Position 3.
      15. Under Import Options, set the Flex Name to DISC.
      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 -> Select the store you're working on.
      4. Options -> Options -> F (update inventory file).
      5. Options -> Flex Name -> DISC.
      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.

  • Steps to process this report:

    1. Select the Products Menu.
    2. In the search box, type a SKU from your report and press Enter.
    3. In the General tab, toggle the Discontinued flag off (grey).
    4. In the Stock & Sell tab, set Store Closeout to Yes, if you do not wish to carry the SKU.
    5. Press Save in the upper-right.
    6. Repeat these steps for each SKU listed.

    • This process outlines a fast and effective way to fix Discontinued flag issues. The risk involved is when updating a SKU's DISC flag back to No since it is active in your RSC. This can cause product to order again when you potentially did not want it. Because of this please manually review the store closeout flag for SKUs where the RSC Disc (Column I) is set to No. 

      File Prep (A)

      1. Enable Editing and Enable Content. Enable Content
      2. Sort out any data you may want to exclude using the column filters. Consider filtering out RSC Disc = N based on the warning above.
      3. Click the button in the header called "Export for DI".
      4. The file is automatically prepped as a .txt file and needs to be saved. Save location defaults to the Desktop\MangoFiles...
      5. Close out of Excel.

      Import the Data (B)

      1. Select the Utilities menu and click Imports.
      2. Under the Import Type column, select Products.
      3. In the upper left, click Start Import.
      4. Select the Upload File icon in the upper left.
      5. Find and select the file you saved in Step A.4 above, and click open.
      6. Under Choose Delimiter, select Comma.
      7. Under Parameters, select Update Records.
      8. Turn the File Contains Headers toggle to off (gray).
      9. Make sure the Mapping Type is set to New Mapping. 
      10. Click Upload.
      11. Select the Data Mapping button in the upper right.
      12. Under the Map to Field column, set Description Map to - blank.
      13. Using the search field above, find Discontinued.
      14. Under the Map to Field column, set Discontinued Map to - Column 3.
      15. Click Map Data & Proceed.
      16. Click Leave.
      17. Under Data Preview, select Mapped Columns and Verify that each column has the appropriate data.
      18. Click Finalize at the bottom right corner.
      19. A popup will appear; click Finalize again.
      20. Import is underway, click Ok.

MEGA Discontinued Flag Mismatches.png