Day end processing error when processing O/E Invoices

[vincejci]

Hi All,

I encountered errors when running day-end processing in I/C. The error happens when it starts processing O/E Invoices. But previous O/E invoice transactions where processed without problems.

Here's the error messages from Day-end:

a. Description: Invoice Invalid list choice put to field 'Tax Reporting Calculate Method'.
Source: 09:21:38

b. Description: Internal error. Cannot insert A/R invoice (8801 OEPOSTI1.C).
Source: 09:21:38


So far i already run data integrity checks on O/E, I/C and A/R

Any help/tips is very much appreciated.

Thanks guys
Vince

 

[Jay Converse]

Version?
Service packs?
Third party add-ons?

 

[vincejci]

I'm running ACCPAC 6.0 ERP 100 on Oracle 10g as back-end.
No service packs.

 

[Jay Converse]

PU2 is the current SP level for 6.0.

 

[vincejci]

I installed PU1 for accpac 6.0. Erorr was not resolved.

Any ideas?

Thanks

 

[DjangMan]

Run the RVSpy utility when you run day-end. It is going to record a great deal of information so make sure you set the options to log to a file.

When the error appears, stop rvSpy from running. Then go to the end of the log and search up for the word ERROR. Start your search there and report what you find.

 

[vincejci]

I ran RVspy here are the error lines I got from the log.

84.7ff.fb8] OE0422: OEINVHO [14:09:55.70].RecordClear(view=0x05FE2594)
[c84.7ff.fb8] 0 <==[14:09:55.70;t=0;ovh=0] {}
[c84.7ff.fb8] OE0422: OEINVHO [14:09:55.70].Browse(view=0x05FE2594, filter=(NULL), direction=forward)
[c84.7ff.fb8] 0 <==[14:09:55.70;t=0;ovh=0] {}
[c84.7ff.fb8] OE0422: OEINVHO [14:09:55.70].Fetch(view=0x05FE2594)
[c84.7ff.fb8] OE0420: OEINVH [14:09:55.70].Get(view=0x05F2B00C, field=1, size=10)
[c84.7ff.fb8] 0 <==[14:09:55.70;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\45\9c' -> 459}
[c84.7ff.fb8] 1 <==[14:09:55.71;t=16;ovh=0] {**NO-MORE-DATA**}
[c84.7ff.fb8] AR0032: ARIBH [14:09:55.71].Put(view=0x040CD00C, field=141, size=4, verify=0, buffer='\00\00\00\00' -> '????')
[c84.7ff.fb8] 0 <==[14:09:55.71;t=0;ovh=0] {}
[c84.7ff.fb8] AR0032: ARIBH [14:09:55.71].Insert(view=0x040CD00C)
[c84.7ff.fb8] 1024 <==[14:09:55.71;t=0;ovh=0] {**ERROR**}
[c84.7ff.fb8] 9903 <==[14:09:55.71;t=8500;ovh=7906] {**ERROR**}
[c84.7ff.fb8] 9903 <==[14:09:55.73;t=33562;ovh=30814] {**ERROR**}
[c84.7ff.fb8] IC0276: ICDEP [14:09:55.73].Cancel(view=0x02CEACF4)
[c84.7ff.fb8] 0 <==[14:09:55.73;t=0;ovh=0] {}

On the bottom portion of the log.

[c84.7ff.fb8] 0 <==[14:09:57.45;t=0;ovh=0] {}
[c84.7ff.fb8] AP0402: APIBHO [14:09:57.46].Unload
[c84.7ff.fb8] AP0021: APIBH [14:09:57.46].Close(view=0x0402004C)
[c84.7ff.fb8] 0 <==[14:09:57.46;t=0;ovh=0] {}
[c84.7ff.fb8] AP0021: APIBH [14:09:57.46].Unload
[c84.7ff.fb8] AP0023: APIBS [14:09:57.46].Close(view=0x02DBE7C4)
[c84.7ff.fb8] 0 <==[14:09:57.46;t=0;ovh=0] {}
[c84.7ff.fb8] AP0023: APIBS [14:09:57.46].Unload
[c84.7ff.fb8] 0 <==[14:09:57.46;t=32;ovh=32] {}
[c84.7ff.fb8] PO0335: PODEPR [14:09:57.46].Unload
[c84.7ff.fb8] 9903 <==[14:09:57.46;t=83016;ovh=72384] {**ERROR**}
[c84.7ff.fb8] IC0275: ICDEND [14:10:45.26].Close(view=0x02CC52DC)
[c84.7ff.fb8] IC0380: ICOPT [14:10:45.28].Close(view=0x02CC72C4)
[c84.7ff.fb8] 0 <==[14:10:45.28;t=0;ovh=0] {}
[c84.7ff.fb8] IC0380: ICOPT [14:10:45.28].Unload
[c84.7ff.fb8] 0 <==[14:10:45.28;t=0;ovh=0] {}
[c84.7ff.fb8] IC0275: ICDEND [14:10:45.28].Unload


What can you make of it?

Thanks for the help.

 

[DjangMan]

Tax Reporting Calculate Method in the ARIBH table is field 147 of view AR0032.

Track down a line that says something like:

 [c84.7ff.fb8] AR0032: ARIBH    [14:09:55.71].Put(view=0x040CD00C, field=147, ...

Accpac should only be putting a 0 or 1 (No or Yes). Above that line you'll see where there is a call to OEINVH.Get. See what field it is pulling it's data from - that might be the bad field.

It could be that OEINVH.TAXOVERRD has a bad value, or AUTOTAXCAL has a bad value. There are a few other fields in OEINVH that could cause that.