web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Can an account be used for both sales and purchasing in a UK company?

(0) ShareShare
ReportReport
Posted on by 20

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.

I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    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:

    community.dynamics.com/.../demystifying-gen-posting-type-on-g-l-account-card-in-microsoft-365-business-central

  • Suggested answer
    YUN ZHU Profile Picture
    101,995 Super User 2026 Season 1 on at

    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

    pastedimage1682557469873v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Jonathon Minard Profile Picture
    20 on at

    For our specific use case, it appears that setting the Gen. Posting Type to Purchase works.

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans