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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Purpose of Posting Groups in Journals

(1) ShareShare
ReportReport
Posted on by 919

Hi

I have used the posting groups to reflect the financial impact when creating a sales or purchase invoice, or doing inventory transactions, and that all makes sense to me and works perfectly fine

but there are some areas where I don't understand the usage of posting groups and how it affects the transaction

1- The chart of account - in the account Definition or when creating a new account, you can link it to a posting group on the account card.  What does that mean?

2- In the Journals (General Journal, Payable Journal, or Receivables Journal ), again I see that there are posting groups used.  For example, If I select in the Journal one side as an expense account and the other side as the vendor.  Then the payable account will come from the posting group linked to the vendor and the expense side will come from the expense account I selected.  Where does the posting group in the Journals come in play and change the accounting and what is the purpose behind it in the General Journals, or payable , or Receivable Journals ?

Thanks

Ola

  • Dirk Profile Picture
    Microsoft Employee on at

    Interesting question - let me try to answer with a little more background information.

    In general Posting Groups are used to create links between the different application areas such as Customers, Vendors, Item, Resources, Fixed Assets and the General Ledger application area.

    Posting Groups are used to find the right G/L Accounts.

    For more information see msdn.microsoft.com/.../hh168345(v=nav.90).aspx

    But that doesn’t explain what we need the Posting Groups for in the G/L Accounts itself.

    If you enter a G/L Account directly into a journal of course you don’t need any logic to find this G/L account! You just enter the number directly. There is no “direct” impact on the accounting!

    But in case you want / have to work with VAT (like in all European country versions) you need at least the following Posting Groups in the G/L Journal Line:

    - VAT Business Posting Group

    - VAT Product Posting Groups  

    in combination with

    - Posting Type (Sale / Purchase)

    These three parameters control the VAT handling, such as VAT percentage, G/L Accounts for the VAT Amount, etc.

    (More details about the VAT setup can be found in the help mentioned earlier.)

    You can enter the VAT Posting Groups manually in the G/L Journal Line, but you can also set up these Posting Groups and the Posting Type in the G/L Accounts and then get these fields prepopulated in the G/L Journal Line.

    The values can still be changed if needed.

    That makes it easier for you to get all the needed information entered in the G/L Journal Line and ’s the main reason for having the VAT Posting Groups in the G/L Accounts.

    And then there are still the "General Business Posting Group" and the "General Product Posting Group".

    These General Posting Groups are not needed for VAT.

    But there are use-cases for these two parameters too (Remark: you cannot use these two parameters without using the "Posting Type" also).

    In Journals:

    Imagine you register a sales invoice through a Sales Journal or through a General Journal and you want to allow the customer to deduct Payment Discount if they pay the invoice in a certain time frame.

    In this case it makes a difference whether or not you used the General Posting Groups in the journal (the Posting Groups on the G/L Accounts are just for pre-population)!

    The difference is where NAV checks for the Payment Discount G/L Account. If you didn’t use the General Posting Groups when posting the sales invoice through the journal then the Payment Discount G/L Account is taken from the Customer Posting Group. And if you used the General Posting Groups when posting the sales invoice through the journal then the Payment Discount G/L Account is taken from the General Posting Setup.

    (The second options offers a little more flexibility, if needed. In some countries this is even mandatory)

    In Documents (for example Sales Invoice, Purchase Invoice, etc.):

    As mentioned in the help …

    If you use an Item the Posting Groups (from the customer/vendor and from the item) are used to determine the G/L Account (indirectly).

    There is a check with the posting routines that you have to use Posting Groups if you register a transaction through a sales/purchase document.

    And now … if you want to use a G/L Account directly in a document … the same check for Posting Groups is done within the posting routines. This means that the Posting Group field has to be filled for all lines in a document (except lines of Type = Blank/Text).

    If you would not use a Posting Group for a G/L Account Line the following error message is thrown:

    ---------------------------

    Gen. Prod. Posting Group must have a value in Sales Line: Document Type=Invoice, Document No.=xxxx, Line No.=yyyyy. It cannot be zero or empty.

    ---------------------------

    And therefore it makes sense to enter the default Posting Groups in the G/L Account and get it pre-populated when the G/L Account is used in a document.

    Hope this helps

     Dirk

  • Ola Darwish Profile Picture
    919 on at

    Hi Dirk,

    Thank you so much for your reply

    I m still a bit confused but I will try to write what I understood and you can confirm and/or correct my understanding

    since I 'm in Canada and we don't use VAT, I will skip the part  for VAT

    in this part below

    you mean that the posting groups that I select on the Journal will override the ones attached to the customer in a sales invoice

    "Imagine you register a sales invoice through a Sales Journal or through a General Journal and you want to allow the customer to deduct Payment Discount if they pay the invoice in a certain time frame.

    In this case it makes a difference whether or not you used the General Posting Groups in the journal (the Posting Groups on the G/L Accounts are just for pre-population)!

    The difference is where NAV checks for the Payment Discount G/L Account. If you didn’t use the General Posting Groups when posting the sales invoice through the journal then the Payment Discount G/L Account is taken from the Customer Posting Group. And if you used the General Posting Groups when posting the sales invoice through the journal then the Payment Discount G/L Account is taken from the General Posting Setup."

    and for this part below where you are describing purchase and sales invoices , I didn't really understand the usage of posting groups.

    I understand that the posting groups linked to the item, customer or vendor play the role in deciding the accounts, but not sure about the GL account line

    can you please send screenshots to elaborate

    "If you use an Item the Posting Groups (from the customer/vendor and from the item) are used to determine the G/L Account (indirectly).

    There is a check with the posting routines that you have to use Posting Groups if you register a transaction through a sales/purchase document.

    And now … if you want to use a G/L Account directly in a document … the same check for Posting Groups is done within the posting routines. This means that the Posting Group field has to be filled for all lines in a document (except lines of Type = Blank/Text).

    If you would not use a Posting Group for a G/L Account Line the following error message is thrown:"

    Thanks

    Ola

     

    Thanks

  • Dirk Profile Picture
    Microsoft Employee on at

    Hi Ola,

    Hmmm ... I think I added to your confusion because my answer was too much related to VAT.

    I just learned that in the NA version of D365FF both features related I described are not enabled/not needed.

    However I created an example based on the UK version of D365FF (just in case)

    This still doesn't explain why we need to have the Posting Groups in the G/L Accounts in the NA version.

    I'll try to find that out.

     Dirk

  • Ola Darwish Profile Picture
    919 on at

    Hi Dirk,

    no worries, thank you so much for trying to help me

    Ola

  • Verified answer
    Dirk Profile Picture
    Microsoft Employee on at

    Another scenario (other than the Paym. Discount scenario ) which proofs the benefit of having the Gen. Product Posting Group set up in the G/L Account is a sales invoice where you use a G/L Account and a Line Discount.

    In this scenario D365FF need to identify the G/L Account for the line discount which can only be set up in the General Posting Setup table.

    In this scenario the G/L Account is entered manually to the line, the discount account comes from the General Posting Setup table using the Gen. Business Posting Group which comes with the customer and the Gen. Product Posting Group which comes with the sales G/L Account which is entered manually to the line.

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 Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans