We have just recently found a large number of invoices associated with Sales orders that do not match the GL code of the parts on the Sales Order. If i am correct, the GL comes from the GROUP on the sales order line. On the order it is “part” but the invoice is pulling “completed rig” (not not actual GL titles, just using those names to show that it is wrong). What would cause the Invoice to be pulling a different GL? Not all orders have this issue and only started happening in November to the best of our knowledge.
Is it possible you (or somebody) overrode the Group GL by adding a GL Control to the Part itself? Part–>Accounting–>GL Control
What about Kits? We don’t use them, but could it be a GL Issue with KIT being selected?
Just spitballin’ here.
Thanks for the idea, spot checked a few and none of the parts had any GL control on the Part > Accounting tab. We also don’t use KITS, so not going to be that.
Does “completed rig” have any meaning for you at all, company-wise? Did you look in the journal review to see if something in there is conflicting or showing what is missing? I’m not sure ERP 10 has that…
Adding to @josephp’s thoughts:
Are any of these ship-direct (from Jobs and not inventory)? That could be the Product Group on a job.
My first thought would be to find out what in your GL Controls identifies the account you are saying is incorrect for the AR Account. This should provide some guidance as why it is doing it. I would also look at your GL Controls for the account you think it should be going to and ask why isn’t it.
Solved. It was the GL control of the product group. Dont know how I missed that previously. No clue who would have changed it or why…so odd. Not many people have access to it.