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



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 NA"
4. The file is automatically prepped and needs to be saved. Save location defaults to C:\3apps\Temp\..."
5. Close out of Excel

Network Access Import (B)

1. In Eagle Browser, launch Network Access (NA)
2. In the Function line type IMU and press Enter
3. In the upper right, click Options -> Keys -> Programmable Keys
4. Pick an open Key, for this help I will use Ctrl + F11
5. Under Data File Name: click the ". . .". 
6. Select the file we saved in Step A.4 above
7. One time setup - Under Macro Definition: paste the following WITHOUT the asterisks.  **If you are unable to Paste the macro, this is because you have Secure Access. Please see the "Building the Macro for Secure Access users" below.
   1. Single Store: **{Column 2}{BREAK}{PGUP}{PGUP}{END}{END}{END}{DOWN}{Column 3}{F5}{PGUP}{PGUP}{PGUP}{F12}**
   2. Multi Store: **{Column 2}{END}{END}{END}{Column 1}{BREAK}{PGUP}{PGUP}{END}{END}{DOWN}{Column 3}{F5}{PGUP}{PGUP}{PGUP}{F12}**
8. Uncheck the box that says "Macro playback follows keyboard focus"
9. Click OK
10. Press F12 to ensure the screen is clear
11. Press the programmable key you used, in this case, I used Ctrl + F11
12. The screen will begin to flash. This process may take several minutes depending on the number of stores/updates
13. When the screen has stopped you can close out of Network Access, you're finished!

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. 

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.

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 NA or DI"
4. The file is automatically prepped and needs to be saved. Save location defaults to your desktop
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, 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.