Skip to main content

Notifications

Announcements

No record found.

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

General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

Posted on by 20

Hi all,

I'm looking at a general posting setup where a combination exists where gen. bus. posting group has a value, but gen. prod. posting group is blank. I need to replicate this in a diffrerent enviroment. But when I try to do so I get an error "Gen. Prod. posting group must have a value".

How was this setup? Do I have to load via a config package and ignore validation? Or is there a setting somewhere that allows this be set this way.

Thanks

  • Suggested answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    A purchase line (like a sales line) must have a value in the Gen. Prod. posting group field.

    When you post using a G/L line, the Gen. Prod. Posting group is copied from the G/L.

    Here I have an expense account with the field blank

    pastedimage1665056966000v1.png 

    If I create an invoice I get the error message if I try to post it.

    pastedimage1665057021212v2.png

    If you open page inspection you will see the Gen. Prod. Posting group in the purchase line.

    I have seen that error before on sales orders. It was due to a recurring sales line with missing setup.

    I am afraid I could not replicate the error, maybe it's worth checking?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    Hi, just adding a blog of my friend that hopefully gives you some hints.

    How Posting Setups and Posting Group are classified in Chart of Account in D365 BC and Navision

    https://www.sarab-dynamics.com/post/how-posting-setups-and-posting-group-are-classified-in-chart-of-account-in-d365-bc-and-navision

    Thanks.

    ZHU

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    thanks for the screenshot...interesting, yes looks like its possibly related to the G/L account not having a product posting group.

    However, I am still not able to recreate this error, there must be another setting that requires the G/L Account to have the product posting group populated.

    someone else had the same error previously: community.dynamics.com/.../1248944

  • MMcdowell Profile Picture
    MMcdowell 20 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    I can use the cancel functionality in Cronus against a purchase invoice with a GL line, but in Cronus all of the expense accounts have product posting groups set.

  • MMcdowell Profile Picture
    MMcdowell 20 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    Hey Andy,

    [quote user="andy4029"]

    I tested using the Cancel action on a posted purchase invoice in a company that doesn't have general posting setup configured and it works fine. Something else must be going on.

    Can you post a screenshot of the error message you get and the invoice?

    [/quote]

    pastedimage1665010123775v1.png

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    I tested using the Cancel action on a posted purchase invoice in a company that doesn't have general posting setup configured and it works fine. Something else must be going on.

    Can you post a screenshot of the error message you get and the invoice?

  • MMcdowell Profile Picture
    MMcdowell 20 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    Correct, but it doesn't work (using the cancel action). It's expecting a combination to exist when it shouldn't. Must be a shorfall of using that action. Using the create corrective credit memo allows me to post it, without requiring a setup that should not exist.

  • AD-22040756-1 Profile Picture
    AD-22040756-1 624 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    If your invoice is against GL accounts that means you are not using the general posting setup and gen. bus. posting groups/gen. prod. posting groups.

    All you are using is the Vendor Posting Groups. This is why it still works even though the setup is blank/wrong.

    The implication of leaving it blank is that when you will try to post something that requires it you will get an error message preventing you from posting. To simplify it, the General Posting setup is used for p&l accounts on transactions that have vendors/customers and/or items. Gen. bus. posting groups are assigned to customers/vendors and gen. prod. posting groups are assigned to items. There is no situation in the system where you have a vendor/customer in conjunction with an item and the gen. prod. posting group can be empty, this is why i first asked what kind of transactions you are posting. 

    More info from Microsoft: Set up posting groups in Dynamics 365 Business Central - Training | Microsoft Learn

  • MMcdowell Profile Picture
    MMcdowell 20 on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    Yes I will, thanks Kim. I don't see much information out there about this but I found an old blog post about NAV 2015, mentioning that the correct/cancel functions only work when the purchase invoice was against items. The invoice I am using was done against a GL account.

    For my own curiosity (not that I will) what would be the implications of leaving the combination with gen. prod blank?

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: General posting setup - Combination where gen. bus. posting group has a value, but gen. prod is blank

    You should still fix your data and setups so that no gen. prod. posting group is blank.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans