We have today discovered that since the upgrade to GP2010 (from 10.0), Inventory Adjustments for FIFO Perpetual valued Items are being journalized in the GL differently from Version 10.0.
Prior to GP2010 an Inventory Adjustment would use the standard Inventory Accounts definied for the Item (Inventory and Inventory Offset). Now the system is using the WIP Rounding Account from Manufacturing Costing Setup screen instead of the Inventory Offset Account.
WTF! Has anyone seen this? These adjustments have absolutly nothing to do with Manufacturing activities - they are simply materials being issued out for internal uses.
Any help would be appreciated.
Thanks
Tim
*This post is locked for comments
Just tried it in Fabrikam using the ARM item which is FIFO Periodic valued. You're right...can't duplicate. The Controller here has just completed some testing in our test company and finds that the problem doesn't occur if you don't select a Default warehouse. ??????????
Still tracking.
Thanks
Tim
Are you able to recreate this in Fabrikam? I can't seem to find any manner of posting or setup that would cause this to happen.
David,
Thanks for taking the time to look at this.
Yes, I am entering an Inventory Adjustment Transaction from the Item Transaction Entry Window. This is only happening for Items with FIFO Periodic valuation. Items with FIFO Perpetual valuation are posting with the distribution as expected (Inventory and Inventory Offset from the Item Card).
I have run SQL Profiler and I can see the SQL call-out to the Manufacturing Costing Setup Table to fetch the Account Index for the Rounding Account during the Posting to the GL process. I can't see any other call-out to a Manufacturing Setup Table - so I guessing that the activity is DEXterity triggered with other setups at startup. Well, I hope that's it because I want to shut it off!
I have checked all of the obvious and not so obvious - that's why I'm polling others like yourself.
I'm giving this thread a few more days and then I'll be calling MS Support.
Thanks again.
Tim
This does not happen for me in GP 2010 R2. It uses the Inventory and Inventory Offset accounts from the item card.
You are entering an Inventory Adjustment Transaction in the Item Transaction Entry window? The Inventory Offset distribution is coming from the WIP Rounding Account? For all items?
I assume you've checked the obvious...that you actually have an Inventory Offset populated for this account and, if not, that you do not have the WIP Rounding Account set as the Inventory Offset in Posting Setup?
Perhaps you need to take a look at your account indexes at the database level? I can't think of any other setup in Manufacturing that would override the Inventory Offset account.
David
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156