Hi folks
My client is running Sage 300 2014. We are once again experiencing day end issue where the error message is:
Generic Line Data. Attempt to modify a different record than was retrieved
Day End Processing could not process all transactions
We have established that there is a sequencing issue on the POLINEZ table where the PRORSEQ has gone out of whack. Does anyone have a script to fix this? At this stage we are running RVSPY, finding the incorrect transaction and running an update in SQL - it's exceptionally time consuming.
script:
Use Test_Dat
update POLINEZ SET PRORSEQ = '102414822'
where RCPLSEQ = '102405100'
Then we run dayend again to catch the next one.
I am trying to establish what causes this. The POLINEZ table for this client has 711443 rows.
Many thanks
My client is running Sage 300 2014. We are once again experiencing day end issue where the error message is:
Generic Line Data. Attempt to modify a different record than was retrieved
Day End Processing could not process all transactions
We have established that there is a sequencing issue on the POLINEZ table where the PRORSEQ has gone out of whack. Does anyone have a script to fix this? At this stage we are running RVSPY, finding the incorrect transaction and running an update in SQL - it's exceptionally time consuming.
script:
Use Test_Dat
update POLINEZ SET PRORSEQ = '102414822'
where RCPLSEQ = '102405100'
Then we run dayend again to catch the next one.
I am trying to establish what causes this. The POLINEZ table for this client has 711443 rows.
Many thanks