End of day failure POINVZ1.C

[zmacgregor]

I recently did a server replacement, got accpac 5.4a install on a new server (WS2025), got it all running, and fixed all the issues I've come across till now. I'm getting an error with day end (Description: Internal error. Reading receipt posted header (1763 POINVZ1.C)). I've done integrity checks on every module, and corrected all the errors on the PO modules, working on others, but they dont seem related. I'm running out of ideas here and could absolutely use some help or guidance. I ran RV spy on the day end procedure, and here's where it stops...


I will also attach the full RV spy log. Thank you in advance for any assistance

 

[DjangMan]

So the actual error is here - around line 29150:
[1fec] PO0422: POINVJ [11:48:15.59].Read(view=0x095d360c)
[1fec] 1 <==[11:48:15.59;t=0;ovh=0] {**ERROR**}
[1fec] PO0702: PORCPJ [11:48:15.60].Put(view=0x09726d84, field=1, size=10, verify=0, buffer='\00\00\00\00\00\00\54\95\90\8c' -> 5495908)
[1fec] 0 <==[11:48:15.60;t=0;ovh=0] {}
[1fec] PO0702: PORCPJ [11:48:15.61].Read(view=0x09726d84)
[1fec] 1 <==[11:48:15.62;t=16;ovh=0] {**ERROR**}
[1fec] 1 <==[11:48:15.63;t=5735;ovh=5359] {**ERROR**}
[1fec] 1 <==[11:48:15.63;t=50640;ovh=43585] {**ERROR**}

The logic has found a record in POINVJ and is trying to find the related receipt record in PORCPJ and cannot.

You have a couple of options - one is to contact a data repair company like Musick International.

The other is to carefully scrape out the records related to the offending invoice that are causing the problems and then never touch that PO or the receipts again. You'll also need to watch the inventory costs and accounting.

 

[NKOS13]

Seems like you have orphans,
1. If your databases are not to big, please do a Sage dump and load from the old environment prior to moving to the new SQL infrastructure.
2. If the issue persists are no. 1 above, go to these tables and trace which transactions have a header but no detail or a detail and no header and correct accordingly