How to change the purchase price for old product balances

If a new batch of goods arrived at a higher price, when posting it (in the «Goods Receipt» mode), the program will notify you about the price change: the previous purchase price will flash in red, indicating the increase. You simply enter the new price for this new batch.

If you want to forcibly change the purchase price specifically for old remaining stock that is already in the warehouse, Torgsoft offers several ways to do this:

1. Through «Stock Balance Analysis» (recommended method) 

Go to the menu Analysis -> Stock Balance Analysis. Turn on the switch «Group by supplier price» and select the required product (with a balance greater than zero). Click the «Change purchase price» button. In the window that opens, specify the new purchase price, markup, and selling price.

How it works: the program will automatically create a «Return to supplier» document at the old price and immediately create a new «Receipt» with the new purchase price.

2. Through «Warehouse Status» — only for the «Last purchase price» method

Go to the menu Warehouse → Warehouse Status, select the required product, click the «Product sales terms» button and choose the action «Change purchase price». In the window that opens, specify the new purchase price.

How it works: the program will create an incoming invoice with a zero quantity of goods. This document will record the new purchase price in the system, but will not change the quantity of goods in the warehouse.

3. Adjustment directly in the incoming invoice — only if there has been no movement for the product 

If you need to change the purchase price in an already created incoming invoice, go to the menu Document → Purchase Price Adjustment, select the required invoice and enter the new price in the «Purchase price» column.

How this will affect the total cost price

The impact of the new purchase price on the total cost price depends on the Cost Price Calculation Method set in your settings (Settings -> Parameters -> Accounting):

Method «Last purchase price»

If this method is selected, the cost price of all remaining stock of this product in the warehouse will automatically change and will be displayed according to the last purchase price. Accordingly, the profit from subsequent sales (even from the old batch) will be calculated based on this new, higher cost price.

Method «By supply batches» (FIFO - first in, first out)

In this case, on the «Warehouse Status» form, the cost price of the remaining stock will be calculated as the average purchase price of the product, taking into account all available batches. For example: If you have 10 pcs. left at 30 UAH, and you post another 20 pcs. at 40 UAH, the average cost price in the warehouse will be 36.66 UAH. However, during sale, the program will write off the goods according to the FIFO principle: first, the old batch will be written off at a cost price of 30 UAH, and only when it runs out will the new batch start being written off at a cost price of 40 UAH. Profit will be calculated as accurately as possible for each specific unit sold.