...
Below is the layout of the import CSV recordfile. Only four fields from the CSV that are used to update the vendor inventory:.
- Supplier Store ID = Customer, Customer Location
- Item Number = Item Code
Business Day = Transaction Date
Units = Units
...
- If product 0116172 needs 5 shelves and product 0316184 needs 2 shelves because both products are set to Mix = Y, are the same Type (SHELF) and the same Factor (3) then their needs can be combined to determine quantity to order. (All of these three things need to be the same in order to be grouped in a mix.)
* The type SHELF is shipped on a metal cart and there are 3 shelves on a cart. This is where the factor 3 comes into play. We also need to only sell full carts.
* Product 011672 is 5 shelves which is a 1 and 2/3 carts.
* Product 0316184 is 2 shelves or 2/3 of a cart.
In the scenario above, what the software needs to order is Product 011672 for 4 shelves and Product 036184 for 2 shelves, this gives us two full carts. This is because the factor of 3, which is interpreted as a single cart (3 shelves = 1 cart) - The mix isn't a "replacement" quantity its that the items can be mixed on the same cart. - If product 0516184 needs 10 shelves because it has Mix = N then its needs cannot be combined with 0116172 and 0316184. Product 0516184 does have a Factor of 3, so the software needs to order 9 shelves or three full carts.
- If product 1513115 needs 2 cases because Factor is 1 and Mix = N then software needs to order 2 cases.
Generate Button
Once item quantities have been calculated, click on the Generate button to create customer orders order for those customers.
The created customer orders must then travel through the standard logistic and invoice workflow process.
...
In addition, this process updates the current balance to account for the invoiced quantities.
The final step on the VMI workflow process is to generate an outgoing CSV file to be sent to Prescient. The file contains information from invoiced orders with a format and specifications required by Prescient.
...
The results are orders that have been invoiced and registered but not yet submitted to Prescient.