Important Grid Information
Each of the main grids require at least the following columns for the App to work:
ID
|
LocationCode
|
SuggestedOrderQty
|
UOM
|
UnitCost
|
LocationID
|
ProductCode
|
QuantityOnSalesOrder (Manufacture only)
|
ProductID
|
SupplierCode
|
SupplierID
|
|
Outside of these columns the user can add/remove or rename any of the other columns.
The Inventory Replenishment software will automatically identify capital letters in a name of a column and put a space between those letters for easy reading. For example, UnitCost = Unit Cost.
The fields which the user can edit the data on the replenishment side are:
SupplierCode, Unit Cost and the SuggestedOrderQty.
Related Articles
Inventory Replenishment Introduction
If you're not on top of your Inventory re-ordering process, you might run out of valuable stock lines, severely impacting the bottom line. If you have too much inventory, that’s tying up valuable capital. That’s another problem. The Plus Software ...
Stock Replenishment
When clicking on the Replenishment menu and the Stock Replenishment tab, the user is able to view the grid containing the Suggested Order for Stock. REMINDER: The Stock Replenishment Suggested Order formulae is contained under Settings: Let’s run ...
Manufacturing Replenishment
When clicking on the Replenishment menu and the Manufacturing Replenishment tab, the user is able to view the grid containing the Suggested Order for Manufacture. REMINDER: The Manufacturing Replenishment Suggested Order formulae is contained under ...
Replenishment for Jobs
There are 5 easy steps to processing an order into your Accounting system: Modify the SQL Scripts (if needed). This SQL scripts supplied will work immediately. If the User needs to modify the calculation or logic, this will occur before generating ...
Different ways to forecast within Inventory Replenishment
As Inventory Replenishment can be programmed to include any SQL source data there are numerous ways to forecast, depending on the needs of the business. For example, you could connect the product data to a historical orders database. It would then be ...