The Update Purchase Prices button in the price list allows you to bulk-update purchase prices in the price list agenda according to selected criteria, such as warehouse selection, calculation method, or which price should be used for the calculation. This feature is available in the web interface from version 2022-11-11.
You can find the feature in the Price List module in the bottom toolbar, under the three-dot icon.
Available options
selection of price list items
option to apply the purchase price calculation to all displayed items, which can be further filtered
option to apply the purchase price calculation to a selected product group.
the repricing algorithm offers the ability to define the range of prices to be considered in the calculation
selected accounting period — current or a previous one
source of the purchase price, with the option to choose between the average stock price or the last purchase price
warehouse — you can select all warehouses or only specific ones for the calculation
calculation method — weighted average across selected warehouses, or average excluding zero prices
Calculation procedure
After clicking the Update Purchase Prices button, a new form opens, allowing you to select which price list items you want to update the purchase price for.
Confirm your item selection — all displayed items or a group — by clicking Next.
In the next step, the repricing algorithm is presented with the options described above, which are factored into the calculation.
Confirm the calculation criteria by clicking Next.
On the last screen of the form, you will see an overview of the items to be updated, showing their current purchase price as set in the price list and the new purchase price that will be applied. The form also offers the option to display items where no price change will occur, or items with a zero stock price. If you choose to display these items, no change will be made and the zero price will not be set. This view is for informational purposes only.
Click Finish to update the purchase prices in the price list for the displayed items. Once the process is complete, a summary showing the number of updated records will be displayed, and the update is done.
Need help?
If you have any questions about the application, please contact us at podporaflexi@abra.eu or via the chat window in the bottom right corner.