Project

General

Profile

Unit Costs

At the moment we can sell items as individual units or as ‘units of sale’ eg box or roll.
We are now able to keep records of purchases in this method as well.
We can also record the price purchased in a different currency if necessary.
The currency is determined by the supplier currency setting.
There is a new tab called ‘Unit Costs’ in the ‘Stock Items’ form.
This has fields for ‘Unit Description’, ‘Default’ and ‘Cost’, and ‘Base Currency Cost’.
The ‘Base Currency Cost’ is calculated by dividing the currency rate into the ‘Cost’.
The ‘Unit Cost Price’ field in the ‘General’ tab is renamed to ‘Unit Cost Price (Base)’ and there is another field called ‘Unit Cost Price’ where the foreign currency price is entered.
When this is entered, the ‘Unit Cost Price (Base) is calculated by dividing the currency rate into the ‘Unit Cost Price’.

There is also now an ‘Inactive’ field against the ‘Unit Costs’ tabs in the stock record.
This defaults to false in both cases but if it is set to true, then you will not be able to select this in, respectively, component order detail line entry or in regular purchase order entry.

Please note that the 'Unit of Sale' record where quantity = 1 will affect the 'Unit Cost Price' and 'Unit Cost Price (Base)' field in the 'Stock Item > General' tab.

The 'Unit Costs' price is shown in the component entry in the sales order:

But please note that
Also, the 'Unit Cost Price' is shown in the purchase order:

Also, the 'Unit Cost' price can be uplifted in the 'Supplier Amend' tab:

The 'Unit Costs' tab can be updated in batch mode via the 'Import From Excel' routine or 'Stock Control > Stock Item Update > Unit Cost / Unit Of Sale / Product Blind Type'.