The system uploads the following fields' values from the Inventory Modeling spreadsheet program. You do not have to upload all fields. During the upload process, you select which fields you want to upload to your system.
Review the following information to understand the impact on your system changing these fields may have. When you upload the value of these five fields, you change this value for each product listed in the spreadsheet.
|
Important: We recommend that you save the original extract file to your computer from the system generated e-mail and make changes to a copy of the original. Making changes to a copy allows you to still have the original data to reference without having to create a new extract file. |
The quantity multiple in which stock may be purchased or transferred, depending on the product divisibility (whether or not your system allows a package to be broken to fulfill an order) and economic order quantity relative to transfers and the availability of stock in the parent branch.
|
Inventory Modeling Use |
Restrictions or Requirements |
|
Change the buy package |
If this field is left blank or null the system updates with a null in the record. This setting causes the field to default to the branch hierarchy setting. |
Indicates whether the buy package can be divided and the item procured in a quantity other than the buy package quantity.
|
Inventory Modeling Use |
Restrictions or Requirements |
|
Change whether you want to allow splitting buy packages. |
If this field is left blank or null the system updates with a null in the record. This setting causes the field to default to the branch hierarchy setting. |
The buy package and package division fields work together.
Note: The combination of the buy package quantity and divisibility produces different results for automated purchasing and transfers, depending on whether the vendor will divide the package quantity and whether a child branch expects a full or divided package quantity.
Also consider that when calculating the line buy quantities, the system may round to package quantities. Package quantities and their divisibility may be set at a product level, or branch level if the branch is a child branch in a central warehouse procurement path. For more information about package quantities and the economic order quantity or examples of how these quantities change in Primary Inventory Maintenance, see How Eclipse Uses Package Quantities in Line Buy Calculations.
Inventory Modeling simulates how buying in package quantities changes what you keep on hand and how you purchase your inventory. Normally, the vendor indicates if package quantities can be divided. This indication directly effects how the system calculates demand which in turn changes how you manage your inventory. Use the Buy Package Qty and Pkg Div fields on the spreadsheet to evaluate the best combination for your company.
For the buy package, the system uses the unit of measure that is identified in Product Maintenance for each product, such as each, box, or case. Use the system validated abbreviations, such as ea for each.
For the package division, the system uses the division specified in Primary Inventory Maintenance off Product Maintenance. You can assign one of the following divisibility settings to a product's buy package quantity:
Yes - Enter Y to allow the buy package quantity to be divided.
No - Enter N to disallow the buy package quantity to be divided.
Only - Enter O to allow the buy package quantity to be divided, but require the branch to take the remaining amount into stock.
The flag set that indicates if the product is normally in stock. Normally, the system bases inventory calculations on products that are in stock. However, you can change the inventory modeling spreadsheet to see how your stock values changed based on having all the products in stock.
|
Inventory Modeling Use |
Restrictions or Requirements |
|
Use this flag if all items should be considered as stock items regardless if they usually are nonstock items, normally.
|
If this column is left blank/null, then the system updates the stock item flag with a null and display a dash (-). Again, this is how they get rid of an existing override in the system. |
|
If this field is set to Y in the system when the data is extracted and it is changed to N on the spreadsheet and the Stock Item flag is selected to upload, the system updates the field in Product Maintenance. The system captures this change in the Product Change Log. |
The estimated minimum quantity to stock in your warehouse for each product.
|
Inventory Modeling Use |
Restrictions or Requirements |
|
The minimum quantity uploads to Min field on the User Controls window through Primary Inventory Maintenance. For more information, see Setting Product User Control Parameters. |
If this column is left blank/null, then the system deletes out the minimum, the maximum, and the expiration date fields |
|
This minimum quantity value on the spreadsheet changes the Grand Total Inventory (Model) and Grand Total Inventory (Model) w/ overrides fields which work together. |