...
| Field | Details | Notes | |
|---|---|---|---|
| PKID | This is the Primary Unique Identifier for the row in the database | BUZ creates this for you, leave this field blank | |
| Code | Your Code for the item | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you | |
| Description | Item Description | If this is in a main inventory group and has an * in the heading BUZ will auto generate this for you | |
| DescnPart1 (Material) | Description Part 1 | in most cases used for Material | |
| DescnPart2 (Material Types) | Description Part 2 | in most cases used for Material type (Blockout / Translucent) | |
| DescnPart3 (Colour) | Description Part 3 | in most cases used for Material Colour | |
| Price Grid Code | Price grid code that this inventory items relates to | ||
| Cost Grid Code | Cost grid code that this inventory items relates to | ||
| Discount Group Code | Discount group code that this inventory items relates to | ||
| 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 ) | use the unit of measure code not description | |
| Stocking Multiplier | Multiple "Unit Stock" by "Units purchased" | ||
| Units Stock | What unit do you stock in IE: BX is Box | use the unit of measure code not description | |
| Selling Multiplier | Multiple "Unit Sell" by "Units purchased" | ||
| Units Sell | What unit do you sell in IE: BX is Box | use the unit of measure code not description | |
| Cost Method | What cost do you want to default to (Average, Standard, Last purchased) | ||
| Product Size | |||
| Product Type | Component = "C", Service = "S", Manufactured = "M" | Use only the first letter in the column | |
| Supplier | Enter your Supplier here | use supplier code which is setup in BUZ contacts→ Suppliers | |
| Supplier Code | Enter the Code your Supplier provides you for the inventory item, used for purchase orders | ||
| Supplier Description | Suppliers Description of goods, used for purchase orders | ||
| Length | |||
| Maximum Width | Maximum width this item is available in | ||
| Extra Time to Fit | Extra time in minutes to fit this item (additional to the inventory group) | ||
| Customer Var 1 (Pack Size) | Fabric WidthPattern Repeats in millimetres. used for Curtain pricing script | ||
| Custom Var 2 (PackOpt) | Pattern RepeatsFabric Width in millimetres. used for Curtain pricing script | Continuous Y or N | |
| Custom Var 3 (PackType) | Y or N | Continuous /Railroad Y or N | |
| Warning | Warning flag to appear when item is selected in cart | ||
| RptCat | Report Categroy | used to group items in a category for reporting | |
| Operation | If this is a new item then the operation is A, E is to edit and existing item and D in to Deactivate |
...