The Update purchase prices function in the price list lets you update purchase prices in bulk based on selected criteria, such as the choice of warehouses, the calculation method, or which price to use for the calculation. The function is available in the web interface from version 2022-11-11.
In the Price List module, first select at least one item using the checkbox. You will then find the function in the bottom bar under the three-dot icon (More functions). If no item is selected, the option is inactive.
Options offered by the function
selection of price list items
all in the list, meaning all displayed items, which you can filter further
selected only items
only items from a selected product group
the repricing algorithm lets you define the range of prices to be considered in the calculation
selected accounting period: the current one or one of the previous periods
where the purchase price should be taken from, with the option to choose the warehouse (average) price or the last purchase price
warehouse prices: for the calculation, you can choose all warehouses, a single selected warehouse, or multiple selected warehouses
calculation method: weighted average across the selected warehouses, or average across the selected warehouses with a non-zero price
Calculation procedure
After you click Update purchase prices, the Purchase Price Update wizard opens and prompts you to choose which price list items should have their purchase price changed.
Confirm your item selection (all in the list, selected only, or only a product group) by clicking Continue.
In the next step, Repricing Algorithm, the options described above that feed into the calculation are offered.
Confirm the calculation criteria by clicking Continue.
On the final screen, Repricing Results, you get an overview of the items that will be changed, their current purchase price set in the price list, and the new purchase price that will be set. The wizard also lets you display items whose price will not change, as well as items with a zero warehouse price. If you display these items, they will not be changed and no zero price will be set. This view is for reference only.
Click Finish to update the purchase prices in the price list for the displayed items. Once the update is complete, a summary showing the number of changed records is displayed, and the update is done.
Need help?
If you have any questions about the application, contact us at podporaflexi@abra.eu, or use the chat in the bottom-right corner.