Hi folks,
Not sure if this is the correct place to ask this, but it's worth a try.
We have an issue where after posting a trade agreement journal, the existing lines in the journal which have been updated do not post the updates to the pricing, but the new records are posted correctly.
Our process is as follows:
- Pricing journal is created with the existing live prices for a customer.
- New prices are added into the journal.
- Old prices are set to expire from the date the new prices are live from (so ToDate of the old price is set to the day before the FromDate of the new price).
- Journal is posted.
- Changes are reflected in the respective pricing screens.
But the issue is that upon posting the journal, the changes to the ToDate of the existing lines does not actually get posted, only the addition of the new records.
This appears to only have started happening recently, after many years of the process working without issue.
The users are reporting that they occasionally receive the following error when posting the journal, although it isn't every time, and sometimes the records may not be updated even if this error is not displayed:
If anyone has any ideas or suggestions it would be really appreciated!
Thanks,
Ben