During work, there are occasional needs for changes to historical data that can affect the calculation of average purchase prices. One such situation is the subsequent unlocking of a receipt to record additional costs that were not known at the time of creating the receipt.
This method is applied in exceptional situations when goods inputs were not correctly recorded before their issuance.
It is important to note that refreshing is not possible for goods transferred between multiple warehouses (stock transfers, production orders, etc.)!!!
In such cases, it is MANDATORY to first delete any newer inter-warehouse documents!!!
To recalculate average purchase prices within the Backstore, we have a built-in recalculation function that can be used at two levels:
- Entire organizational unit
- Individual product variant
Refreshing the entire organizational unit
This option performs a re-calculation of prices and sorts documents by date for the entire organizational unit within a specific year. To choose this option, select the “Recalculate MAC” function.
A screen for selecting the warehouse and year will appear. Choose “Recalculate” to confirm the entry.
Refreshing an individual product variant
If we want to refresh data for a specific product variant, we can select the “Recalculate MAC” option within the product transactions. This option refreshes the MAC amounts for the item. Documents are ordered by the closing date, so this option reorders documents by document date and recalculates the average purchase price.
