Through some means, whether it was a glitch, poor customization, or user error, we have lots still showing in our inventory that have already been shipped and invoiced. Management and Accounting want to get remove these from our inventory without it making any more GL transactions. The only way I’m aware of to get rid of them is through a quantity adjust which will cause GL transactions. Is there any other way to deal with this?
You could create an Adjustment code to point back to the GL that it came from and use that on you qty adjustment. Because it is the same $$$ amount going out and coming back in it doesn’t show up in the GL. Try in your test environment to see if it works for you.
Similarly, create a clearing GL Account in the Balance Sheet and a Reason Code that points to it. Adjust out the inventory using this account. Next create a reversing entry against this transaction. This account should always have a zero balance as a check.
I have this simallar issue where it shows the lot as onhand. Even though there is no qty on hand. I have reached out to epicor and they send me a fix program that unchecks the on hand check box on the Lot table.
I agree with @Mark_Wonsil . Another option is to create a Reason Code linking GL Control to iInventory account and do qty adjustment.