...

Using the current VMI balance and the configuration minimum units setting, this process determines which stores need deliveries and creates orders for them with the required items to fulfill the target.

The VMI balance is updated when invoices are sent to Prescient, and when customer sales are imported from Prescient.

...

1. 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. 
   
   
2.  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. 
   
   
3. If product 1513115 needs 2 cases because Factor is 1 and Mix = N then software needs to order 2 cases. 
   
   

4. There are three items with the same factor (factor of three). In the column "Need", these are the units needed for each item to reach the target for that item.

   Since we don't want to order fractional units, each item is adjusted up to the whole number as shown in column "Adjust up". This is what we want, ordering more. The issue is the total is 17, which is not divisible by three.

   The next factor value up is 18 but the total is 17 with a difference of one. We need to give the difference to one of the item to make 18. The logic is to give the difference to the item with the highest units to order. In this case it's item #2 which was adjusted to 8. It will get the difference, ending with 9.

   
   
   Image Added

   
   

   
   

Generate Button

Once item quantities have been calculated, click on the Generate button to create customer order for those customers. 

...

The file will be created in the folder which has the file path being set in the Export Directory, under Customer Order tab in System Settings.

Image Added

In addition, this process updates will add the invoiced quantities to the current balance to account for the invoiced quantities.

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.

Export Button

After orders are retrieved, all or some of them can be included in a generated csv file by clicking on Export.  The file name and location are configured with the global setting VMIExportFilePath

Image Added

Commit/Update

After the file is generated, the process will prompt the user whether or not to commit the exported orders.

Committing orders does two things:

• Update to the VMI ledger for each item with an addition of the order line quantity
• An entry in the table VMIExportLog for the order ID.  Once an order has entry in this table, the Invoice Export will not include it in its retrieve results.

VMI Reports

There are three custom reports available. They are accessible from Orders→Report Wizards menu.

Image Added