×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

IC Day End Attempt to modify a different record than was retrieved

IC Day End Attempt to modify a different record than was retrieved

IC Day End Attempt to modify a different record than was retrieved

(OP)
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

RE: IC Day End Attempt to modify a different record than was retrieved

Go to IC Setup > Options > Costing
What is the setting for Cost Items During?

Sage 300 Certified Consultant

RE: IC Day End Attempt to modify a different record than was retrieved

(OP)
Hi Ettienne

Thanks for your response. Costing is set to "During Day End Processing". Has been like that since we started working with this client in 2003. Not sure what the POLINEZ table's function is. Sage tech notes have it flagged as a temp table which is normally empty.

RE: IC Day End Attempt to modify a different record than was retrieved

Your setting is good.

Sage 300 Certified Consultant

RE: IC Day End Attempt to modify a different record than was retrieved

If you are seeing so many errors in PO then something is wrong. Are there any customizations or 3rd party applications running?
POLINEZ is labelled as Generic Line Data and relates to proration, it is not a temporary table and it is not normally empty.
PO is terrible when it comes to fixing errors, if you had an error on a PO or receipt then any future transaction against that same PO will result in another error. My best advise is that if there was an error against a PO then do not use that PO again for any receipts or invoices.

Sage 300 Certified Consultant

RE: IC Day End Attempt to modify a different record than was retrieved

(OP)
Thanks Ettienne

I suppose the best thing to do is to run a data integrity on PO to see if anything is highlighted. This DB is huge and the data integrity on PO takes about 4 days to run. I will revert to the client and see if they have had any issues reported to their super-user.

thanks again

RE: IC Day End Attempt to modify a different record than was retrieved

(OP)
Hi Ettienne

Have chatted to the client to get clarity on a couple of things. They have an integration which runs every hour on the hour from their fuel management system. All of the mis-matched transactions we have fixed today have come from the fuel management system. Just wondering what the impact will be if the integration is running and a day end is run.

Thanks
Linda

RE: IC Day End Attempt to modify a different record than was retrieved

That's probably a question that we can't answer because we don't know what the integration is actually doing. But- it would probably be a good thing to pause that integration when day-end is running, just to be safe.

The other thing to consider is that maybe the integration isn't generating the transactions properly. Maybe it is and this issue is elsewhere but you certainly have something to investigate.

RE: IC Day End Attempt to modify a different record than was retrieved

How is that integration "integrating"? I've seen some horrible integrations that write data directly to the data tables, because what could go wrong?
It would be best to stop/pause the integration while day end processing is running.

Sage 300 Certified Consultant

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close