Ok, I do not speak the Finance language very well so please bear with me…
We are noticing a strange issue with some of our AP postings. For example, I am looking at two almost identical invoices for the same same supplier (only the invoice numbers and amounts differ) that were posted from the same AP Group on the same date but for some reason one invoice posted to our “AP Clearing” account and the other posted to our (correct) “Technology Services” account. Neither Invoice has a PO associated to it and both Invoices had a GL Account (both have the “Technology Services” account) manually entered onto the Line. And the Supplier is setup with the same “Technology Services” GL account. I have no idea what would have caused these two, almost identical invoices, to post to two different accounts? Would anyone be able to shed some light on how this could have happened and help us pinpoint and fix this problem?
Thank you so much for any thoughts, suggestions, or help you can provide!
-Heather
Your AP Invoice postings come from one of the following (excluding in this
case the Supplier GL Control code since the same supplier is being used and
you are getting different GL accounts we will assume you do not have a GL
Control code on the supplier setup)
Part Class GL Control or
AP Account
If one of the invoices has a part with a part class and CL Control Code
with a GL account then it would use that account
If one of the invoices has a part with a part class but there is no GL
Control Code attached it would use the AP Expense Account
If one of the invoices has a part on the fly without a GL account then it
would use the default AP Expense account
I’m looking at each Invoice now and the lines do not have any Parts associated to them (both Part and Supplier Part are blank). They are a Miscellaneous Billing Line Type. I will run this by our Finance team and see what they say. Thank you for listing this out for us! I’ll update this ticket on their findings.
when a misc charge is addedd to the invoice header and an amoun is entered, it automatically generates the GL combination. If for some reason the Misc charge code is changed, it will remain there in the APinvoice, so instead of just changing the charge code, it is necessary to remove the misc charge line and enter it with the correct code.
at least this is what I have been able to identify in our process.
I wanted to thank all of you so much for the quick responses and valuable information, thoughts and advice on this! I cannot thank you enough!
At the time I posted this problem here I also entered a new help ticket with Epicor. The support analyst that I worked with had seen this issue before with another customer who migrated from E9 to E10 and thankfully had a SQL Script that I could run to fix the issue. The script involved updating the Ice.SysBigSequence.CurrentValue field to the Maximum Absolute value of the ERP.TranGLC.SysGLControlCode only where Name equaled ‘SysGLCntrlCodeSeq’. I hope I translated that correctly because I wasn’t sure if it would be a good idea to post the full script or not. And I did run the script in TEST before I applied it to LIVE.
But this seemed to fix the issue of our Misc. AP Invoices (without POs) posting to the wrong GL Account even when a GL Account was manually entered onto the line for that Invoice. I hope no one else runs into this issue but if they do I hope this post helps!
Thanks again everyone for all of the help!
-Heather
2 Likes
aidacra
(Nathan your friendly neighborhood Support Engineer)
8
Support thanks you 
