Embedded Files
The below will cover how we do our daily ordering for AOL shorts and forecast , WA shorts and commercial
Ordering Dashboard.mkvUsing the ordering Dashboard - Shorts
Using the ordering Dashboard - Shorts
This is only used for AOL shorts, AOL forecast WA Forecast for Siemens, and Winning shorts , video ends at 1:55
Ordering Dashboard.mkvUsing the ordering Dashboard - Forecast
Using the ordering Dashboard - Forecast
Video starts a 1:55
On the forecast page:
Perform the main checks which for shorts is to check the top 10 shorts for AOL and WA to ensure there is nothing peculiar. Then check until you get to QTY 10 on AOL Forecast (or the top 10, if the QTY is low). For WA Forecast for Siemens, do the same.
Filter to Highlights "1" and sense check the Pilot Orders (AKA Opening Orders). If anything appears unusually high, find similar SKUs and check if they're strong sellers. Flag to TL/Manager if you think it needs to be reduced.
Remove V08037 from opening orders
Filter to Audio Visual. Check the top 10 being ordered and then check 75 inch TVs and above.
Importing an order into Req Worksheet.mkvPreparing the req worksheet for POs
Preparing the req worksheet for POs
Upload the dashboard sheet into Google Sheets.
On the forecast sheet, filter to V10653 in 501WHSE and 801WHSE and delete them.
Combine the AOL Forecast and AOL Shorts sheets. Then concatenate the Date, Location and SKU then follow the steps on the SUMIF part of the Helpful References material.
Combine the WA Forecast and WA Shorts sheets. Then concatenate the Date, Location and SKU then follow the steps on the SUMIF part of the Helpful References material.
Press control A and format to plain text
Move the algo tags to column N and download as csv
Rename file to business unit - shorts / forecast / bulks - todays date eg AOL - Shorts - 21-07-2023
Open NAV > Requisition worksheet > select your name
Select " Import replenish lines " and copy the csv into the xdrive and upload into NAV
Ensure all are ticked for AutoRelease before taking any further steps.
Ensure your Outlook is open on the NAV screen before following any further steps.
Follow the guidelines in the Retail and Commercial ordering sheet here following the daily AOL ordering tab
Column B is what you will be searching
Column C is the filter
Column A is your action
Carry out action message on the req worksheet
Go back to the guide and complete all steps under " Do after creating POs "
Advise RnD in the Algo Orders chat that ordering has been done.
Page updated
Report abuse