| 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
E.g. 100 - 8 = 92
92 / 100 = 0.92
1 / 0.92 = 1.086956
1.086956 x 710 = 771.73913, rounded to $771.74
...
Alternative Inventory
Where an item has no stock AND it has an alternative set, that message is displayed regardless of the status of item (except for Deleted, deleted items cannot be added to sales orders or purchase orders).
...