We have a site that have entered new prices into the pricelists manually for many years.
Adding a new price list line and leaving the old price as-is, without ‘closing’ the old price with a ‘Valid to’ date.
Now we want to close the old prices by adding a ‘Valid to’ date to all price list lines that has a newer price.
Is there a function in IFS to close old pricelist lines? Or do we have to this with SQL or migration job?
If there are many lines in the same pricelist you have the option to select all the lines and apply a valid to date as below. But if there are many price lists where you are unable to manually apply the valid to date then you have to use an SQL migration job.
I think I’ll have to solve this with SQL. There are around ~42.000 price list lines that need to be updated.
Manually selecting the price list lines will take too much time, we don’t want to close the last active line for each sales part.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.