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

[Deborahza]

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

 

[Jay Converse]

PORCP*

 

[Deborahza]

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

 

[Jay Converse]

Data integrity will not fix this, don't bother.
Run RVSPY during dayend for more details.

 

[Deborahza]

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.

 

[Jay Converse]

In RVSPY, options/output.

 

[Deborahza]

Ticked and path is C:\Windows\RVSPY.LOG

 

[Jay Converse]

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