| Table of Contents | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Status | Binary equivalent in IN_Main.Status |
|---|---|
Active | 0 |
Discontinued | 1 |
Deleted | 2 |
Slow | 3 |
Obsolete | 4 |
Inventory Prices Tab
Sell Price - the default selling price for the item, Ex Tax. This field can form the basis of price scheme prices, e.g. by adding margins or discounts to certain customers. The tick box Sell Price Represents Tax Inclusive on the Main tab determines if this price is Ex or Inc of GST
RRP - this price is Inc Tax and can be used as the basis for price scheme prices, e.g. giving discounts on RRP.
Last Cost - this field is updated with the cost of the item the last time it was received or purchased, if the appropriate System Settings in Receiving, Invoicing and Landed Cost are set. Otherwise it remains static and is editable.
Standard Cost - no longer used. Jiwa uses actual cost, not standard cost.
G.P. (%) - calculated as (Sell Price - Last Cost ) / Sell Price. When a staff member has Minimum GP Enforcement set on their staff record, this controls whether a selling price can be changed so that it's less than Minimum Sell Price in the tab of inventory as follows:
Not Enforced - not checking on sell price
Warning Only - displays a warning with the minimum sell price recommended but does not enforce it
Enforced - does not permit the sell price to be changed to less than the Minimum Sell price for that item
Minimum Markup GP% - Manually entered value and can be used in conjunction with the user setting, Minimum GP Enforcement, to ensure item is not sold below the minimum sell price
Minimum Sell Price is calculated as (1 / ((100 - Minimum Markup GP% ) / 100) ) x Last Cost
...
Each inventory item can be associated with an upsell product. ‘Would you like fries with that?’ kind of thing. To set Upsells on an inventory item open the item in Inventory Maintenance > Alternate (“Linked Products” in Jiwa 8) > Upsell Products. Add one or more products to the grid here. The quantity suggests how many upsells products you would add to an order for each of these items. E.g. for one table you might upsell two chairs.
...