| 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
...
In the Second Region, the default supplier is Quality Imported Foods.
...
Upsells
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 > 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.
...
To see the Upsells in the sales order you need Sales Order Customer Panel. If not already enabled login to Plugin Maintenance and enable the plugin called ‘Sales Order Customer Panel’. Log out and log back in again.
Now follow the guidance here: https://jiwa.atlassian.net/wiki/x/CoCPEQ