Cost Price Types & How They Get Updated

Below shows the Four types of Cost Prices and how each are updated on the system.

Avg Purchasing Cost:

The cost price worked out over time. Each time you check in an order or complete a stock transfer, this average cost price is recalculated. This average cost price is used for reporting profitability.

Imported Cost Price:

This field can be used to calculate profit in the Retail 365 reports in cases where you’d rather use an alternative cost to the built-in Average Cost Price field. If an Imported Cost Price has not been specified, the system will default to using the Average Cost Price.

• This cost price type can only be updated via a Product Update File from the Product Imports section. If you wish to remove a product's Imported Cost Price this also can only be completed through a Product Update File by setting the value in the file to -1.

Latest Cost Price:

The most recently purchased price from the supplier (the delivered price in the orders). Each time the product is ordered the Latest Cost Price is updated with the new List Cost Price.

List Cost Price:

This gets updated by the IPU File, Product Imports, Advance Search & Product Updates