Use RVSPY to figure out the bad transaction and delete it.

This I got sorted, it was on table POLINEZ. But have an issue on PO invoices.

RVSPY_INV.rar

Please see attached RVSPY

File is empty

Pieter can you please resend the RVSPY file if you still have it?

Dear Seisat. Here you go. Note it is zipped in winrar.2185.RVSPY_INV.rar

If that one is empty, look at this one.RVSPY_SAGEPOINV.rar

Okay I see this one is Empty

Contact Musick, you need help.

Hi Jay, Whom is Musick????

Okay I see. How much do they charge?

Is this in dollars?

The cost for data repair depends on the size of the database and the Sage version. 

FixIT Professional is on our website: www.Musick-Int.com 

We are a USA company prices in USD. 

Glad to assist. Questions Contact [email protected] 

I've mailed. I'll be waiting on quote if you'd be able to assist.

Hello Pieter, 
Thank you for attaching the correct file. I see that you have already been referred to the Gurus of data repairs. But FWIW, I came across three or four occurrence of the word "ERROR" in the RVSPY logfile. The first one points to a GL BATCHID    = "011855" which is possibly an empty and open batch (you will have to check it out). This always has to be deleted (The System always deletes some batches but could have failed deletion due to some technicality) in order for Day End to run to completion. 

The other error message points to some Purchase order, possibly PO0520 & PO0335(You will also have to check some lines in this PO). 

But again I could be fishing around and Musick are the right people that will fix you pretty good.

Hello Pieter, 
Thank you for attaching the correct file. I see that you have already been referred to the Gurus of data repairs. But FWIW, I came across three or four occurrence of the word "ERROR" in the RVSPY logfile. The first one points to a GL BATCHID    = "011855" which is possibly an empty and open batch (you will have to check it out). This always has to be deleted (The System always deletes some batches but could have failed deletion due to some technicality) in order for Day End to run to completion. 

The other error message points to some Purchase order, possibly PO0520 & PO0335(You will also have to check some lines in this PO). 

But again I could be fishing around and Musick are the right people that will fix you pretty good.