How to tie inventory report to GL?

[JasonMcD (Jason McDermott)]

Part of the reason that the GL gets out of whack is that it is all too easy to buy a part against one GL account and then issue it from inventory against a different GL account.

For example:

Warning! PO release for “Other” ignores Part GL code

Well this was a swift kick in the pants today. It’s fully documented, but wow I did not expect this at all. Ready? So, general rule in any kind of transaction is: If there is a GL on the Part, use that first Otherwise look for a GL on the Part Class Then look other places All normal so far, right? OK great. I have a part (920457) that Is non-quantity-bearing Has a GL control on the Part itself Has a GL control on the Part Class also Here is what actually happens with these transactions: …

I can explain some other scenarios, too.

Really, all you have to do is change a part class on a part and boom, GL is off at the very next transaction.

Or the people that make a PO for some MRO item (coffee, for example) and choose a part class that goes to inventory or R&D or anything but the right place.