Can any please advise.
We are due to review and update our prices that will be effective from 01/01/2021 and have created a migration job to load base prices.
Our source file includes PART_NO, PRICE and VALID_FROM.
The migration job, updates the SALES_PART and SALES_PART_BASE_PRICES but I am not convinced I am updating correctly.
It looks like I cannot load the prices in advance as the Sales Part price field changes along with the Sales Part Base Price as soon as it is migrated in.
Can someone please advise the best way to update our base prices in advance?