Dayend just exits without completing

[mathe]

I'm having a problem when i run I/C Dayend, it just exits without completing. There was a network problem at one of the client machines while reciepting an invoice.The client ended up with a "database error" and ever since then Dayend has not been able to complete.
I deleted the order from the database but still Dayend just exits.

 

[ettienne]

Run data integrity, and then run RVSpy while you process IC day end.

 

[mathe]

I have run Integrity check and rvspy as suggested but now my problem is how do i put it through to you guys to check since i dont see anywhere i can attach files on this post?
Anyway, I was keeping a close eye to the screen while dayend was running and it exits where it tries to post a certain receipt.
I tried to delete the receipt but when i run dayend i get an error saying dayend could not process all transactions.

 

[mathe]

I have been reading other threads trying to find out how rvspy works and for now what i can say is that there are errors on the following tables/views;
PORCALO
POAAPC
GLJEC
PORCPAH
PORCPAL
POHSTL
Integrity Check picked up errors in PO of old purchase orders using a non existent GL account, in IC there are 435 errors, all in location details. The error reads like:
"Quantity on sales order "###" for item "any item" at location "my location" does not match quantity on sales order "###" stored in IC."
So this error reiterates for 435 Items in IC.
There are 9 errors in AP, 1 in AR and 20 in service manager

 

[ettienne]

Run intergity check on IC with the fix option checked, that will fix those errors.
If you lost PO receipt details then you may need to look at the PORCPI and PORCPM tables.

 

[easyzone]

I had a problem like this when a custom table was removed that a trigger on one of my accpac tables was using. The RVSpy showed no obvious error information You might check to see if anything like this has happened.