Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Invoice Rounding Accou...
Microsoft Dynamics NAV (Archived)

Invoice Rounding Account in Customer Posting Groups Setup Requiring a General Product Posting Group

(2) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good Day All,

I am working with a client to set up a new entity. I have completed 95% and they are about to go live. It looks like we are running into a problem when setting up the Invoice Rounding Account GL account on the Customer Posting Groups screen. 

Error-Message-1.png

It states "Gen. Prod. Posting Group must have a value in G/L Account: No.=66200. It cannot be zero or empty" I understand this means that I need to go to the G/L Account card and set up the General Product Posting Group on that specific G/L account. The issue that I'm having is that the client is getting confused and stating "We have to have these rounding accounts used for ALL posting groups." 

I have dug around, but I simply can't find anywhere that actually explains what a gen product posting group does on a GL account and why it is needed on a rounding account in the Customer Posting Group setup. 

I understand why the Customer Posting Group requires a rounding account to be assigned, but why does that account then need its own posting group?


Thank you kindly in advance,

Matt

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice Rounding Account in Customer Posting Groups Setup Requiring a General Product Posting Group

    Hi Robertas

    I've a customer asking the same question - why do you need Gen. Product Posting Group code for a G/L Account used in the SO line.  The posting will not use any of the accounts referenced by the Gen. Product Posting Group.

    I tried setting up the GST Product Posting code for the G/L Account (as you suggested), and then use this account in SO line (G/L Account line type), and I get the same error message: "Gen. Prod. Posting Group must have a value in Sales Line"

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Invoice Rounding Account in Customer Posting Groups Setup Requiring a General Product Posting Group

    Hi Matthew,

    I don't think that the General Product Posting Group is required as such, because technically the invoice rounding is created as a new sales line on the document with the difference. This line is 'G/L Account'-type line, so General Posting groups don't matter.

    However, what you DO need on the sales line with rounding difference, is the VAT Posting Group, as VAT might need to be adjusted as well. Theoretically the Gen. Product Posting Group sets VAT Product Posting Group when setting GL Accounts (I know it's not always true). So basically, that is the way for system to say that GL Account must be setup with Posting Groups, even though in theory it only needs VAT Prod. Posting Group when posting rounding.

    Hope that makes sense.

    Robertas

  • Suggested answer
    Paras mehan Profile Picture
    Paras mehan 3,518 on at
    RE: Invoice Rounding Account in Customer Posting Groups Setup Requiring a General Product Posting Group

    Hi,

    Please go to 66200 G/L Account Card and mention any of the Gen. Prod. Posting Group in that Account. 

    Now comes to why Invoice Rounding Account is required:- when you will post the sales order and total amount will come in decimals then system will round off the total value and post the difference decimal in the invoice rounding account.

    Why Posting Group is Required:- When you will post the invoice then one new sales line will created of Invoice Rounding Account with decimal Value. Any of the G/L Which is reflecting through sales line that need Gen. Prod. Posting Group.

    Hope it clear your doubt.

    Best Regards,

    Paras M

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans