Sales Price Lists - New Pricing Experience - Auto Create Duty Prices

Auto-create and maintain duty-linked sales prices in real time using Auto Create Duty Prices.

In Bevica Essentials V23.45.6.0 we have made a major improvement to the management and maintenance of Sales Price Lists using Auto Create Duty Prices. This article outlines the changes we have made, the differences you will see as a user and any other useful information on how to manage and maintain your Sales Price List using Auto Create Duty Prices.

Full details on creating and managing your price lists can be found on our Sales & Purchase Price Lists - New Pricing Experience page.

What happens to my current Sales Price Lists?

On install of Bevica Essentials V23.45.6.0 it is advised that you run the Regenerate Duty Lines function for all your lists where Auto Create Duty Prices is being used. This is to ensure all lines are correctly linked.

The Regenerate Duty Lines function will run the same procedure as the previous Verify Lines function, for large lists this can take some time to process, if preferable, this can be run out of hours on a Job Queue, using Report ID 70527 - Calculate Price List Duty Prices. Once this process has been run, this will only ever need to be used again for full list updates. Alternatively, this can be run once per list, or using the filtering option for all price lists at once.

Why did we make this change?

We identified the Verify Lines action on a Sales Price List where Auto Create Duty Prices is enabled as an area where we could make performance improvements. When selecting to Verify Lines Bevica was recalculating the duty price for the full list which for large price lists could take some time. Instead, we wanted to re-design the function to improve performance but also improve usability.

What is the change we have made?

When a price is amended, you are required to verify the lines within the list. Previously, selecting to Verify Lines when Auto Create Duty Prices is active would re-calculate all duty pricing for that specific Sales Price List. In addition, until Verify Lines was selected you would not have seen the linked duty price either create or update.

In V23.45.6.0 if Auto Create Duty Pricing is active, your linked duty price will be created & updated in real time as the parent price is created/updated. When pricing is updated, the updated price will still be highlighted red & italic, prompting you to Verify Lines, however this function no longer creates your duty price, this will just run some data checks on the item and then mark this as verified.

There is still an option to recalculate the duty pricing for the full list if required. Within the ribbon there is an option titled Regenerate Duty Lines. Selecting this will open up as below:

At this stage, you can select to update the duty pricing for a specific list, or you can refine the selection using filters. This function can also be run via a Job Queue. The Report ID is 70527.

Key Differences

Action	'Old'	'New'
Toggle on 'Auto Create Duty Price' for existing list	Linked duty pricing would only be generated when Verify Lines is selected.	Linked duty pricing will be automatically created for the existing prices.
Updating already linked pricing	Linked price would only be updated when Verify Lines is selected	Linked duty price will be updated in real time
Selecting Verify Lines	All linked duty pricing would be re-calculated & updated where applicable followed by standard data checks against the item card such as UoM and variant.	Only standard data checks are carried out as linked duty pricing will have already updated.
New Feature Regenerate Duty Prices	N/A	To force an update on all duty pricing, Regenerate Duty Pricing can be used. This can be run for a single list, multiple lists or set on a Job Queue to run out of hours for large price lists.