I'm working with a UK client who wants to use an account for both sales invoices and for vendor ledger entries. By vendor ledger entry, I mean that we post a set of general journal lines which end up in the Vendor Ledger Entries archive. We're having trouble with configuring the account in a way that it works for both:
Scenario #1:
- The account's Gen. Posting Type, Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group are all blank.
- Trying to post a sales invoice which uses that account gives an error stating "Gen. Prod. Posting Group Must Have Value in Sales Line".
Scenario #2:
- The account's Gen. Posting Type is blank, while the Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group have values.
- Trying to post a vendor ledger entry which uses that account gives an error stating "Posting to Account X must either be of type Purchase or Sale (see Gen. Posting Type), because there are specified values in one of the following fields: Gen. Bus. Posting Group, Gen. Prod. Posting Group , VAT Bus. Posting Group, or VAT Prod. Posting Group".
Scenario #3:
- The account's Gen. Posting Type is set to Sale, and the Gen. Bus. Posting Group, Gen. Prod. Posting Group, VAT Bus. Posting Group, and VAT Prod. Posting Group have values.
- Trying to post a vendor ledger entry which uses that account gives an error stating "Gen. Posting Type must not be Sale in Gen. Journal Line".
Is there any way to setup this account to work for both transaction types? This affects at least a few other accounts too, so a more global solution such as General Posting Setup would be fine.
For our specific use case, it appears that setting the Gen. Posting Type to Purchase works.
Hi, just to share some info.
In this major update, there is the following new feature. Since it has not been released yet, I'm not sure whether it can meet your needs.
Use different general ledger accounts for payables, receivables (General availability: Sep 2023)
https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/use-different-general-ledger-accounts-payables-receivables
Hope this helps.
Thanks.
ZHU
If you have to calculate tax you can not post to the same account for purchase and sales. But if you have no tax calculation you can try to keep the posting type on the G/L account to blank.
Maybe this can be helpful:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156