| Latest arrivals | Current QOH | Average Cost Price | ||
| 4 in January @ $490.00 each | 10 | (2 x $500) + (5 x $510) + (3 x $520) | = $5110 / 10 | = $511.00 |
| 4 in February @ $500.00 each | ||||
| 5 in April @ $510.00 each | ||||
| 3 in June @ $520.00 each | ||||
Average Cost Prices
Retailer has the ability to display and report on average cost prices. The average cost price is calculated based on the current quantity-on-hand and the cost price of the latest arrivals.
For example:
After enabling average cost prices, Retailer will use the average cost price in place of the most recent cost price is all reports and GP% calculations. Both cost prices will be displayed in the stock screen.
Cost prices are recorded at time of sale. Activating average cost prices will not recalculate historic sales data. Sales reports for dates from before you enable average cost prices will NOT be affected.
Enabling Average Cost Prices
Once you enable average cost prices, the average cost price will be calculated based on the current quantity on hand.
Before enabling average cost prices, make sure you have performed a backup. Click HERE for instructions on performing a backup of your data.
- On the top menu bar of Retailer, click on Setup → System.
- Click on the Stock tab.
- In Cost Price Method, select Use Average Cost Prices from the drop-down box.
- Click Save.
- The Calculate Average Cost Prices screen will appear.
- Tick the tick-box and click Start.
- Click Yes to the next 2 warning messages.
- Click close once Retailer finishes calculating the average cost prices.
Recalculating Average Cost Prices
All Average Cost Prices can be recalculated on demand.
- On the top menu bar of Retailer, click on Utilities → Calculate Average Cost Prices.
- Tick the tick-box and click Start.
- Click Yes to the next 2 warning messages.
Related Articles
Additional Decimal Places for Cost Prices
To add more decimal places to cost prices in Retailer: 1. Go to Setup -> System. 2. Click on the Stock tab. 3. Change the Cost Price Precision to 3 or 4 decimal places. 4. Press Save. 5. Restart Retailer. This change applies to every item, it can’t ...Setting Up Trade Prices
Retailer allows users to set trade prices for stock and allows specified trade customers to receive those trade prices for purchases. You can also apply these trade prices to products in the Point of Sale screen manually for non-account sales. Before ...Update Prices using Markup rules
Setup Stock Markup A markup percentage can be defined at a Department and/or Category level for Retail/Sell, Web and Trade Prices. See Adding / Editing Departments or Adding / Editing Categories See Differences Between Markup and Margin When is ...How to show / hide the Gross Profit on discount screens
In Retailer, there are various areas where a discount screen can be brought up to enter a discount for items. These screens can display useful figures relating to the discount such as before and after prices, and the Gross Profit (GP). If the Gross ...Cost Price Code
Cost Price Codes are designed to be used with sales of a generic item where the cost price can vary. When such a generic item is sold, Retailer prompts for a Cost Price Code to be entered. Retailer then translates this Cost Price Code into a Cost ...