OE invoice getting Miscellaneous charge code does not exist error message

[vbdbcoder]

Hello All,

We just upgraded Sage 300 to version 2023 PU1 at a client. When invoicing in OE, all of a sudden, we got an error message "Miscellaneous charge code MC0003 does not exist" when trying to create an OE invoice. The MISC charge code was used many years ago and now does not exist in OE Misc setup. And the source OE order and OE shipment does not have any MISC charge item when the OE invoice is being created. The error message prompts and the user has to click a button to close the window. What triggers this error message window to prompt?

Thanks!

 

[ettienne]

Run RVSpy to see what triggers it.
What happens when you add MC0003?

Sage 300 Certifiable Consultant

 

[vbdbcoder]

Thanks for your response.

1) Added Misc Item MC0003 to OE setup works and stops the error message prompt. There is no impact on AR or GL since the item is not being used. That was something I did to fix it. But I still don't know what triggers the error message prompt.
2) Rvspy log can't point me to a possible place to review for a fix. Below are the log records that are relevant to the "MC0003" error message, for your leisure reading. I see OE MISC tax table and OE MISC item table being called. My "O\E Options" has nothing to reference the MISC item being automatically inserted. I don't have Orchid Extender or any integration or customization on OE shipment and OE invoice screens.

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.59].Init(view=0x136AA874)

[21e4.7ff.2624] OE0460: OEMISCT [16:04:06.61].Cancel(view=0x136AC2BC)

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.61].Get(view=0x136AA874, field=1, size=3)

[21e4.7ff.2624] 0 <==[16:04:06.61;t=0;ovh=0] {buffer='\55\53\44' -> 'USD'}

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.62].Get(view=0x136AA874, field=2, size=6)

[21e4.7ff.2624] 0 <==[16:04:06.62;t=0;ovh=0] {buffer='\20\20\20\20\20\20' -> ' '}

[21e4.7ff.2624] 0 <==[16:04:06.62;t=16;ovh=16] {}

[21e4.7ff.2624] OE0460: OEMISCT [16:04:06.64].Put(view=0x136AC2BC, field=2, size=6, verify=0, buffer='\20\20\20\20\20\20' -> ' ')

[21e4.7ff.2624] 0 <==[16:04:06.64;t=0;ovh=0] {}

[21e4.7ff.2624] OE0460: OEMISCT [16:04:06.64].Put(view=0x136AC2BC, field=1, size=3, verify=0, buffer='\55\53\44' -> 'USD')

[21e4.7ff.2624] 0 <==[16:04:06.64;t=0;ovh=0] {}

[21e4.7ff.2624] 0 <==[16:04:06.65;t=47;ovh=47] {}

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.65].Put(view=0x136AA874, field=1, size=3, verify=0, buffer='\55\53\44' -> 'USD')

[21e4.7ff.2624] 0 <==[16:04:06.65;t=0;ovh=0] {}

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.67].Put(view=0x136AA874, field=2, size=6, verify=0, buffer='\4d\43\30\30\30\33' -> 'MC0003')

[21e4.7ff.2624] OE0460: OEMISCT [16:04:06.67].Put(view=0x136AC2BC, field=2, size=6, verify=0, buffer='\4d\43\30\30\30\33' -> 'MC0003')

[21e4.7ff.2624] 0 <==[16:04:06.67;t=0;ovh=0] {}

[21e4.7ff.2624] 0 <==[16:04:06.68;t=16;ovh=16] {}

[21e4.7ff.2624] OE0440: OEMISC [16:04:06.68].Read(view=0x136AA874)

[21e4.7ff.2624] 1 <==[16:04:06.68;t=0;ovh=0] {**NOT-FOUND**}

[21e4.7ff.2624] OE0691: OESHID [16:04:06.79].Update(view=0x135EF4BC)

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.79].Get(view=0x13565F1C, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2)

[21e4.7ff.2624] 0 <==[16:04:06.81;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.81].Put(view=0x13565F1C, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\0a\00')

[21e4.7ff.2624] 0 <==[16:04:06.82;t=0;ovh=0] {}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.82].RecordClear(view=0x13565F1C)

[21e4.7ff.2624] 0 <==[16:04:06.84;t=0;ovh=0] {}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.84].Browse(view=0x13565F1C, filter='', direction=forward)

[21e4.7ff.2624] 0 <==[16:04:06.86;t=0;ovh=0] {}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.86].Fetch(view=0x13565F1C)

[21e4.7ff.2624] OE0691: OESHID [16:04:06.86].Get(view=0x135EF4BC, field=1, size=10)

[21e4.7ff.2624] 0 <==[16:04:06.87;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}

[21e4.7ff.2624] OE0691: OESHID [16:04:06.87].Get(view=0x135EF4BC, field=2, size=2)

[21e4.7ff.2624] 0 <==[16:04:06.87;t=0;ovh=0] {buffer='\40\00'}

[21e4.7ff.2624] 1 <==[16:04:06.89;t=31;ovh=31] {**NO-MORE-DATA**}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.89].Put(view=0x13565F1C, field=999999997 <IMPEXP_IDX / SYSACCESS_IDX>, size=2, verify=0, buffer='\00\00')

[21e4.7ff.2624] 0 <==[16:04:06.89;t=0;ovh=0] {}

[21e4.7ff.2624] OE0702: OESHIDO [16:04:06.90].RevisionPost(view=0x135563CC, level=2)

[21e4.7ff.2624] 0 <==[16:04:06.90;t=0;ovh=0] {}

[21e4.7ff.2624] OE0705: OESHIDB [16:04:06.90].RevisionPost(view=0x13451734, level=2)

[21e4.7ff.2624] 0 <==[16:04:06.92;t=0;ovh=0] {}

[21e4.7ff.2624] OE0703: OESHIDD [16:04:06.92].RevisionPost(view=0x1355B8FC, level=2)

[21e4.7ff.2624] 0 <==[16:04:06.92;t=0;ovh=0] {}

[21e4.7ff.2624] OE0709: OESHIDS [16:04:06.93].RevisionPost(view=0x1356553C, level=2)

[21e4.7ff.2624] 0 <==[16:04:06.93;t=0;ovh=0] {}

[21e4.7ff.2624] OE0708: OESHIDL [16:04:06.93].RevisionPost(view=0x13565F1C, level=2)

[21e4.7ff.2624] 0 <==[16:04:06.93;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:06.95].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:06.95;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:06.97].Get(view=0x135FBDC4, field=76, size=10)

[21e4.7ff.2624] 0 <==[16:04:06.97;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}

[21e4.7ff.2624] OE0692: OESHIH [16:04:06.97].Put(view=0x135FBDC4, field=76, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)

[21e4.7ff.2624] 0 <==[16:04:06.97;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:06.98].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:06.98;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.00].Get(view=0x135FBDC4, field=134, size=10)

[21e4.7ff.2624] 0 <==[16:04:07.00;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.00].Put(view=0x135FBDC4, field=134, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)

[21e4.7ff.2624] 0 <==[16:04:07.01;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.01].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.01;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.03].Get(view=0x135FBDC4, field=77, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.03;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.04].Put(view=0x135FBDC4, field=77, size=2, verify=0, buffer='\00\00')

[21e4.7ff.2624] 0 <==[16:04:07.04;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.04].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.04;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.06].Get(view=0x135FBDC4, field=135, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.06;t=0;ovh=0] {buffer='\02\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.06].Put(view=0x135FBDC4, field=135, size=2, verify=0, buffer='\03\00')

[21e4.7ff.2624] 0 <==[16:04:07.06;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.07].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.07;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.09].Get(view=0x135FBDC4, field=138, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.09;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.09].Put(view=0x135FBDC4, field=138, size=2, verify=0, buffer='\00\00')

[21e4.7ff.2624] 0 <==[16:04:07.09;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.11].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.11;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.11].Get(view=0x135FBDC4, field=202, size=10)

[21e4.7ff.2624] 0 <==[16:04:07.11;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.12].Put(view=0x135FBDC4, field=202, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)

[21e4.7ff.2624] 0 <==[16:04:07.12;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.14].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.14;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.14].Get(view=0x135FBDC4, field=573, size=10)

[21e4.7ff.2624] 0 <==[16:04:07.14;t=0;ovh=0] {buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.15].Put(view=0x135FBDC4, field=573, size=10, verify=0, buffer='\00\00\00\00\00\00\00\00\00\0c' -> 0)

[21e4.7ff.2624] 0 <==[16:04:07.15;t=0;ovh=0] {}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.15].Get(view=0x135FBDC4, field=437, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.17;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.17].Get(view=0x135FBDC4, field=218, size=2)

[21e4.7ff.2624] 0 <==[16:04:07.17;t=0;ovh=0] {buffer='\00\00'}

[21e4.7ff.2624] OE0692: OESHIH [16:04:07.18].Put(view=0x135FBDC4, field=218, size=2, verify=0, buffer='\00\00')

[21e4.7ff.2624] 0 <==[16:04:07.18;t=0;ovh=0] {}

[21e4.7ff.2624] 0 <==[16:04:07.18;t=391;ovh=391] {}

[21e4.7ff.2624] OE0691: OESHID [16:04:07.20].Fetch(view=0x135EF4BC)

[21e4.7ff.2624] 1 <==[16:04:07.20;t=0;ovh=0] {**NO-MORE-DATA**}

[21e4.0.2624] AR0016: ARRTA [16:04:07.22].Load

[21e4.0.2624] AR0016: ARRTA [16:04:07.22].VersionTemplate()

[21e4.0.2624] 0 <==16:04:07.23 {version='69A', date='2021-06-30'}