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.

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

I hope you meant this

check my answer if it helped you, thanks

DANiele

Was this reply helpful? Yes No
MarioG 5 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

what exactly is your page?

Was this reply helpful? Yes No
MarioG 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Gavin 2,508 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Manan_Shah 1,459 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

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 ?

Was this reply helpful? Yes No
Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

[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.

Was this reply helpful? Yes No
MarioG 5 on at

Like (0)

Report

Its exactly for daily accouting purposes.

Was this reply helpful? Yes No
MarioG 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No