Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Vendor posting group change

Posted on by 5

Hi all, im a bit confused since in BC unlike other NAV versions in G/L journals i can not find and move out a Vendor posting group field/column. For this reason i can not figure out how to post an operation with a different Vendor/Customer posting group. For example i need to change earlier operations GL account from trade payables to prepayment. For this i used journal and there put a new operation on two lines useing different vendor posting group. But now im not able to do this.

I understand there is another option but do not know it and hope for your advice.

  • MarioG Profile Picture
    MarioG 5 on at
    RE: Vendor posting group change

    Thanks Gavin for your response. But will this transaction replace the existing open line on Vendor card from Trade Payables to Prepayment if you use only GL Account as Bal. Account Type not Vendor?

    Thanks

  • MarioG Profile Picture
    MarioG 5 on at
    RE: Vendor posting group change

    Its exactly for daily accouting purposes.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Vendor posting group change
    [quote user="Manan_Shah"]

    Hi Mario,

    Please ask your development partner to develop this functionality where you can change Vendor posting group according your requirement, You have remove few base restriction and need to add field on General Journal page. 


    Hope this will help.


    Many Thanks,
    Manan 

    [/quote]

    I would strongly recommend against this solution because it can break the data integrity of Business Central.

    All transactions for the same vendor should be posted using the same vendor posting group. That is how the system is designed to be consistent.

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Vendor posting group change

    I would not recommend you do any development around this because you can easily break the data integrity of your system.

    The vendor posting group should be set on the vendor and not be changed on individual transactions.  The vendor posting group decides what balance account your account payables will be posted to, and if you have different vendor posting groups on different transactions for the same vendor your accountant will have a very hard time reconsiling your balance accounts.

    What is the business need for having to change vendor posting group on transaction level ?

  • Suggested answer
    Manan_Shah Profile Picture
    Manan_Shah 1,457 on at
    RE: Vendor posting group change

    Hi Mario,

    Please ask your development partner to develop this functionality where you can change Vendor posting group according your requirement, You have remove few base restriction and need to add field on General Journal page. 


    Hope this will help.


    Many Thanks,
    Manan 

  • Suggested answer
    Gavin Profile Picture
    Gavin 2,333 on at
    RE: Vendor posting group change

    Hi,

    I also can't see it to add via personalisation in Business Central? Therefore this would need to be added via a page extension as the field in the GL line table.

    Alternatively you could add an additional line to move out of the Accounts Payables thats on the Vendor Posting Group and into the Prepayment account as part of the same journal.

    For example, in the journal below the first line has the entry to the Vendor and will use the GL account assigned to the Vendor Posting Group and the second line moves it out of the Accounts Payables GL code and into the Prepayment GL code:

    pastedimage1671806548236v1.png

    Giving GL entries below:

    pastedimage1671806612808v2.png

    Hope this helps.

    Thanks

    Gavin

  • MarioG Profile Picture
    MarioG 5 on at
    RE: Vendor posting group change

    Not sure i understood your question correctly. Do you mean page preview?

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,215 Moderator on at
    RE: Vendor posting group change

    what exactly is your page?

  • MarioG Profile Picture
    MarioG 5 on at
    RE: Vendor posting group change

    Thanks Daniele for your answear. I know how to add useful fields but the point is that Vendor posting group does not exist in the list. Can you find & see this field in your version?

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,215 Moderator on at
    RE: Vendor posting group change

    hi

    I hope you meant this

    pastedimage1671784125252v1.png

    pastedimage1671784231883v2.png

    pastedimage1671784319504v3.png

    pastedimage1671784359928v4.png

    check my answer if it helped you, thanks

    DANiele

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans