Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Generic Line Data. Attempt to modify a different record than was retrieved

Status
Not open for further replies.

Deborahza

Technical User
Jan 16, 2009
17
GB
Hi,
I have a problem on day end. There are two receipts that have the same RCPLSEQ and in SQL I can find one in the PORCPM table and one in the POLINEZ.
I need to delete the one (it's in the PORCPM table) so that the day end will run.
What tables do I need to delete this Receipt out of? It has no PO or Invoice against it.

Thanks in advance
Debbie
 
Thanks Tuba.
I did a SQL query and the only tables that had the receipt were PORCP H1/2/L/M/I
So I deleted the lines and re-ran the day end process.
It ran further and has created an AP batch but it does not complete. Description: Day End Processing could not process all transactions.
I am busy running the integrity now.

Have I maybe missed something?
TYIA

 
Data integrity will not fix this, don't bother.
Run RVSPY during dayend for more details.
 
RVSpy output not creating log. :(
[89ac.7ff.3298] PO0335: PODEPR [00:18:30.57] Unload
[89ac.7ff.3298] 9903 <== [00:18:30.59; t=95140;ovh=82198] {**ERROR**}
Those are the last two lines. On the Day End screen, gives the dayend number 8492,1...
but no other info.
I can restore the back up but I don't know what else to do to fix it besides deleting the receipt.


 
That doesn't make sense. The log should be huge on a day-end. Add DBSPY messages to it, too.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top