Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Adjustment G...
Microsoft Dynamics GP (Archived)

Inventory Adjustment GL Distributions being changed by Manufacturing Module

(0) ShareShare
ReportReport
Posted on by Tim Foster 8,515

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

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Inventory Adjustment GL Distributions being changed by Manufacturing Module

    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

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: Inventory Adjustment GL Distributions being changed by Manufacturing Module

    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.

  • Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: Inventory Adjustment GL Distributions being changed by Manufacturing Module

    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

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: Inventory Adjustment GL Distributions being changed by Manufacturing Module

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans