Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Changing the Posting Group for a group of inventory items? Can several be done at once?

Posted on by 645

We have 422 items that we are going to move to a new posting group. I was reading about the modify and modify all function http://msdn.microsoft.com/en-us/library/dd338657(v=nav.70).aspx . 

Will this work to change the Gen. Prod. posting Group? I am trying to avoid changing each item one by one. I want to change them all at once and then make one G/L entry to correct the costing. 

*This post is locked for comments

  • Verified answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Changing the Posting Group for a group of inventory items? Can several be done at once?

    Function which you have refereed in here is a C/AL code and you will need to have the access to development environment and need to have a development license. Also you need to have experience in writing batch process modifications. You can do this by using report or codeunit in development environment.

    Or without using the programming you can modify the items by using XML uploading. For this also you need to have access to development environment.

    So I suggest you to contact your NAV partner for this modification.

    Plus if you change the posting group of this 422 items it does not change in the posted entries. It will only change it for future entries.

  • Verified answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Changing the Posting Group for a group of inventory items? Can several be done at once?

    Hi Rebekah,

    that's a little dangerous. Moving the items to a new posting group won't affect existing purchase/sales/service order/WMS (incoming, outgoing, transfer)/item journal lines. By this I mean the tables, affecting all types of unposted documents. All these will be posted with the old group code unless your change routine also is changing these, too.

    Also, the command you're referring to is C/AL. You can use it in a batch (report or codeunit), and it will do what you require. To use it, though, you need access to the development environment, an apropriate NAV license, and the know-how for writing such a batch. Your NAV partner should be able to do it easily.

    The correction of the costing would probably work as you intended.

    with best regards

    Jens

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans