...
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).
Some of the below fields will not appear in the exported spreadsheet but will be under your invetory item in BUZ
You must have supplier selected for purchase orders to Auto generate
| Field | Details | Note |
|---|---|---|
| Code | Your 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 | Wont show in spreadsheet |
| Max Quantity | Max Qty to keep on hand | Wont show in spreadsheet |
| 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) | If your "Unit purchase" is in Meters, your "Unit stock multiplier" needs to be entered as MM |
| ForeX Code | Code used for ForeX | Wont show in spreadsheet |
| Last Purchased ForeX | The price you last purchased it for in ForeX | Wont show in spreadsheet |
| Stocking Multiplier | Multiple "Unit Stock" by "Units purchased" | |
| Units Stock | What unit do you stock in IE: BX is Box | |
| Selling Multiplier | ||
| Supplier | Enter you Supplier here | |
| Supplier Code | Enter the Code your Supplier provides you for the item | |
| 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 |
...