web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Microsoft Dynamics GP ...
Microsoft Dynamics GP (Archived)

Microsoft Dynamics GP Change Inventory Accounts across all Clases

(0) ShareShare
ReportReport
Posted on by Lisa Hunter 1,616

Can anyone tell me the best way to update 175 inventory classes to new GL accounts for inventory and inventory offset.  Is the best way through SQL and update both the inventory class table and the Item Master table?  Are there any other tables?  Anyway to do this through the front end of GP?

Thank you!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    I would simply choose the Macro method, rather than SQL. When changing the accounts on the class levels, Dynamics GP pops up a message to "roll down" the changes into items within the class. 

    Therefore, record a macro on the Item Class window to type in the class name, then go to the accounts to fill the correct new accounts accordingly, then to click roll down in order for the changes to take effect on the child entities. 

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Lisa,

    The best way, in my opinion is to ALWAYS use the user interface. You know that all of the proper tables are updated if you do it that way. That said, we all know that modifying the SQL tables is sometimes the only practical solution.

    In the case you described, here are some other solutions:

    1. First, of course, is to open each class you want to change, change it and roll it down. You can do this manually, or (better) develop a 'mail-merge' macro to do it for you. Changing 175 classes would certainly be boring, but it's really not that big of a deal. This is, in my opinion, the best solution if number 2 doesn't work for you.

    2. I don't know how many total inventory classes you have, but if all of the classes (or most of the classes) are using the same accounts, I would blank out those accounts at the class level and put them at the company level. (Administration | Setup | Posting | Posting Accounts; select the Inventory series).

    Do either of these work for you?

    Kind regards,

    Leslie

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans