Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Change Item Posting Groups

Posted on by 315

I understand from this previous post...

https://community.dynamics.com/nav/f/34/t/143963

that if I change the item posting groups that only future posted transactions will be reflected.

What happens where I have a sales order that is posted prior to the posting group change, and then pull that order into an invoice. Will the previous posting groups be reflected in the posted transaction or will the updated posting groups be reflected.

Also is there an instruction set to accomplish this through xml that anyone can direct me to? 

*This post is locked for comments

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Change Item Posting Groups

    The quick answer to this is that the Sales Invoice copies from the Sales Order, and the Sales Order has already taken a snapshot of the Item card. When you change the Item card it will only affect new Sales Orders and their derivative Sales Invoices.

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Change Item Posting Groups

    If sales order is open then you can delete that line and enter again.

    Or

    Try to validate the item no and check the posting group

  • Kelly Top Profile Picture
    Kelly Top 2 on at
    RE: Change Item Posting Groups

    Hi Alexander,

    Can you please tell me how you can change the posting group when I'm in the Sales Order Lines?  I tried to see if it was a hidden column, but I don't seem to have this field.

    Thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Change Item Posting Groups

    Hi,

    There is a function called VAT rate change tool, which is used to change a specific VAT product posting group and Gen. Product posting group for a group of master data. With this function you can change the two posting groups for a group of filtered items, g/l accounts and resources, as well as documents that are not posted but registered with the item such as sales orders, purchase orders or journal lines etc.

    Check the link below.

    msdn.microsoft.com/.../hh168604(v=nav.90).aspx

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Change Item Posting Groups

    IF you changing the posting group then it will change for new transactions which are going to post and it will not change the past transactions which already posted.

    You need to think over it  before changing as it will hamper your business processes.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Change Item Posting Groups

    Hey Addision,

    As Alexander suggested when you choose Type Item and selects item No then it automatically gets copied from the Item card. Actually all needed information gets copied from the Item card but you have the flexibility to change it over there before Posting, but once you Posted then you cant do anything.

    Ideally it's not good to play with the Posting Groups in between your Business and changing your GL accounts. Check this link

    http://forum.mibuso.com/discussion/15128/changing-the-table-g-l-entries-g-l-account-no

    https://dynamicsuser.net/nav/f/users/47318/editting-chart-of-accounts

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Change Item Posting Groups

    Posting groups are set on the item card, and when you select the item in the Sales Order lines, they are copied from the item card to the lines of the Sales Order. You can manually change the posting groups in the Sales Order Lines and post the Sales Order using them. So, if you will make changes to the item card after it has been selected in the Sales Order, there will be no changes in the Sales Order lines and posting the invoice would result in the posting using old posting groups.

    This is generally same for all the other information: for shipping addresses, customer names, etc. The logic if that if it has been already selected in the Sales Invoice, the changes to the cards would not affect what has been already populated to the Sales Invoice.

    In order to have it posted to the new item groups, you need either to re-select the items (which might be not possible already in your example), or manually change the posting groups to new ones in the Sales Order lines.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans