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).