Create VMI forecast

  1. In the menu, expand Base Modules Distribution > Inventory Management > Vendor Managed Inventory > Maintenance and double-click Work with Vendor Managed Inventory. DSW170 Work with Vendor Managed Inventory selection panel appears. 
  2. Click OK on the selection panel.
  3. Click Add to create a new forecast. DSW170 Vendor Managed Inventory Forecast panel appears in add mode.
View the fields on this panel
Field Description
Customer Customer code for the customer you are creating the forecast for. 
VMI ID This is free text to uniquely identify the VMI forecast for the entered customer.
Start/End date The start and end dates indicate the beginning and the end of the season or cycle.
Status The status of the forecast will default to A – Active when you are creating a new forecast. On finalization the status will change to C – Completed. When the forecast is being updated the status would be U – Updating.
Dlv cut-off The delivery cut-off date is when the last delivery would be accepted. It must be after Start date and before End date.
Consignment w/h The system will default the warehouse setup for VMI consignments.
Next dlv date The delivery date should be within Start date (or today’s date) and delivery cut-off date. The next delivery date must be entered when the forecast is created. After that the system would calculate the next delivery date for replenishment based on the delivery frequency and the delivery day of week.
Next issue date Next issue date is the date when the products would be issued by the warehouse. The system will work out the next issue date based on warehouse parameters.
Item Item code for the vendor managed product.
Max qty This is the maximum holding quantity of the product at the store location. On replenishment run, the stock would be replenished if lower than the maximum quantity.
Weight This is the weight for the maximum quantity. It would be calculated by the system based on the product weight in the Item masterfile.
  1. Enter the forecast information, as necessary.
  2. Click Delivery detail to enter the delivery details. DSW170B Delivery Detail panel appears.
View the fields on this panel
Field Description
Dlv day of week  Nominate the day of the week the customer would prefer delivery of stock. 
Dlv frequency 

The customer has the option to select a delivery frequency that’s suitable for their requirements. The system defined deliveries are listed below.

  • Monthly 1st week
  • Monthly 2nd week
  • Monthly 3rd week
  • Monthly 4th week
  • Semi-monthly 1st & 3rd week
  • Semi-monthly 2nd & 4th week
  • Weekly  
Carrier  Select a carrier for delivery, if left blank the system will default to the customer’s carrier as specified in the Customer masterfile.  
Min dlv weight  Minimum delivery weight can also be recorded in case there is a requirement for it to be used for replenishment in future. 
Contact  Select a customer contact person. 
Email address  Email address of the customer contact that is going to receive the stock reports. The email address would default for the selected customer but it can be overwritten. 
Display unit dimension  Enter the length, width and the depth that will house the products at the store location. 
Display unit max weight  Enter the maximum weight of the display unit that will house the products at the store location.
  1. Enter the delivery details, as necessary.
  2. Click OK to save the forecast. The stock can now be issued and delivered to the store locations.