Small and medium business | Business Central, N...

Vendor posting group change

(0) Share

Report

Posted on by MarioG

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.

All responses (10)

Answers (0)

MarioG 5 on at

Like (0)

Report

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 5 on at

Like (0)

Report

RE: Vendor posting group change

Its exactly for daily accouting purposes.
Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (1)

Report

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 993 Super User 2024 Season 1 on at

Like (1)

Report

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 1,457 on at

Like (1)

Report

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 2,341 on at

Like (0)

Report

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:

Giving GL entries below:

Hope this helps.

Thanks

Gavin
MarioG 5 on at

Like (0)

Report

RE: Vendor posting group change

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

DAnny3211 9,274 Super User 2024 Season 1 on at

Like (0)

Report

RE: Vendor posting group change

what exactly is your page?
MarioG 5 on at

Like (0)

Report

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 9,274 Super User 2024 Season 1 on at

Like (0)

Report

RE: Vendor posting group change

hi

I hope you meant this

check my answer if it helped you, thanks

DANiele