Day End Error (POLINEZ table)

[vbdbcoder]

Hi there,

Day End stopped and said "Record has been modified by another program. Day End Processing could not process all transactions." I did an RVspy and could see the errors below:

[3fb4.7ff.2ac8] PO0712: PORCPN [08:38:10.16].Put(view=0x1109276C, field=1, size=10, verify=0, buffer='\00\00\00\00\00\02\51\99\69\9c' -> 25199699)
[3fb4.7ff.2ac8] 0 <==[08:38:10.16;t=0;ovh=0] {}
[3fb4.7ff.2ac8] PO0712: PORCPN [08:38:10.17].Put(view=0x1109276C, field=2, size=10, verify=0, buffer='\00\00\00\00\00\02\51\99\63\6c' -> 25199636)
[3fb4.7ff.2ac8] 0 <==[08:38:10.17;t=0;ovh=0] {}
[3fb4.7ff.2ac8] PO0712: PORCPN [08:38:10.17].Read(view=0x1109276C)
[3fb4.7ff.2ac8] 1 <==[08:38:10.20;t=32;ovh=0] {**NOT-FOUND**}

I checked table "PORCPN" and the record was not in the table per the above values. (select * from PORCPN where RCPHSEQ = 25199699 and RCPLSEQ = 25199636)

Also a few lines below in RVspy:

[3fb4.7ff.2ac8] PO0520: POLINEZ [08:38:10.53].Get(view=0x110D26E4, field=29, size=10)
[3fb4.7ff.2ac8] 0 <==[08:38:10.53;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}
[3fb4.7ff.2ac8] PO0520: POLINEZ [08:38:10.53].Put(view=0x110D26E4, field=29, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)
[3fb4.7ff.2ac8] 0 <==[08:38:10.53;t=0;ovh=0] {}
[3fb4.7ff.2ac8] PO0520: POLINEZ [08:38:10.54].Update(view=0x110D26E4)
[3fb4.7ff.2ac8] 1122 <==[08:38:10.54;t=15;ovh=0] {**ERROR**}
[3fb4.7ff.2ac8] 1122 <==[08:38:10.55;t=16937;ovh=15891] {**ERROR**}
[3fb4.7ff.2ac8] 1122 <==[08:38:10.55;t=87984;ovh=77825] {**ERROR**}
[3fb4.7ff.2ac8] IC0276: ICDEP [08:38:10.56].Cancel(view=0x0FBFCE44)

I checked Table "POLINEZ" field # 29. it is "GLISPOSTED - Boolean - G/L Data to be posted?" field.

Any suggestions on what to fix?

Thanks in advance.

 

[DjangMan]

Typically we say that you clear out pending all records relating to that purchase order and then never use that purchase order again. Create a new PO if you still have more to receive on it. The PO tables are complicated and a mess to figure out.

Googling "accpac POLINEZ error" will show you at least five results from tek-tips that should offer you some suggestions. The big thing is that repairing it is, by far, the trickier option vs cleaning out the bad transaction.

 

[vbdbcoder]

Thanks Djangman.

I could identify the PO # and the Receipt #. It is completed. Its Receipt and Invoice are created. But Receipt lines are not in PORCPN table, and they are in POLINEZ table.

Seems that the only option is to insert the missing receipt lines in PORCPN table and try. Looking for script to populate PORCPN table from PORCPL (and\or other tables).

 

[vbdbcoder]

Would like to share my fix:

After trying a few things, I fixed the Data in SQL to get Day End to work. Below are the 2 SQL statements to delete from the 2 tables.

delete from POLINEZ where RCPLSEQ in (25199636, 25199638)
delete from POCOSTZ WHERE RCPNUMBER = 'RCP0039064'

RvSpy can provide the transaction # and table name. I needed to run RvSpy multiple times to get the error and fix 1 error at a time. PO module is tough. But it seems that Day End would push records to PO tables (POLINEZ, PORCPN...), starting from PO record source tables (PO, Receipt, Invoice).

Hope this helps anyone who needs to deal with PO module error in Day End.