...
Add the Inventory items (components) into the spread sheet that you want to be able to select/populate and order (remember to add in the below)
You must have supplier selected
| Field | Details |
|---|---|
| Code | Suppliers Code for the item |
| Description | Item Description |
| Last Purchase Price | The price you last purchased it for |
| Standard Cost | The suppliers normal sell price |
| Tax Rate | Your tax rate |
| Units Purchase | What unit do you purchase in IE: BX is Box (These units of measure can be edited in inventory settings Purchase Orders ) |
| Min Quantity | The Min Qty you need to keep on hand |
| Max Quantity | Max Qty to keep on hand |
| Re Order Multiplier | In terms of the stocking unit how many multiples are required to re order as (E.g controls come in packs of 10 so you have to order 10 or 20 not 15) |
| ForeX Code | Code used for ForeX |
| Last Purchased ForeX | The price you last purchased it for in ForeX |
| Stocking Multiplier | Multiple "Unit Stock" by "Units purchased" |
| Units Stock | What unit do you stock in IE: BX is Box |
| Selling Multiplier | |
| Units Sell | What unit do you sell in IE: BX is Box |
| Cost Method | What cost do you want to default to (Average, Standard, Last purchased) |
| Product Size | |
| Product Type | Component, Serivce, Manufactured |
| Operation | If this is a new item then the operation is A, E is to edit and existing item and D in to Deactivate |
...