Skip to main content

Notifications

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

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

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.

  • Jonathon Minard Profile Picture
    Jonathon Minard 20 on at
    RE: Can an account be used for both sales and purchasing in a UK company?

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

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,035 Super User 2024 Season 2 on at
    RE: Can an account be used for both sales and purchasing in a UK company?

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Can an account be used for both sales and purchasing in a UK company?

    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans