Business Central - Posting Groups

Posting Groups

Posting Groups

Posting groups are used in Microsoft Dynamics 365 Business Central as a way of mapping complex transactions to the general ledger. By using posting groups, you can make sure that sales, purchases, and other transactions are posted to the correct G/L account without having to specify that account directly on the transaction. For example, it is possible to process the sale of an item to a customer without specifying which general ledger accounts are impacted. However, a review of the posted invoice shows that entries were posted to the general ledger. This happened because the customer and item were both assigned posting groups that identify which G/L accounts should be used for the sales activity. Posting groups allow complex accounting transactions to be posted seamlessly, behind the scenes, enabling non-accountants to safely process transactions. 

In addition to mapping transactions, posting groups are also available for filtering on most reports.

There are three types of posting groups in Business Central: general posting groups, specific posting groups, and tax posting groups. Setup of these posting groups is typically performed by an administrator or key user with responsibility for the general ledger.

General Posting Groups

General posting groups are assigned to customers, vendors, items, and resources. These posting groups link transactions from purchase and sales documents as well as some journals to the general ledger. There are some exceptions, but typically general posting groups are linked to the income statement accounts that will be updated during a transaction posting.

There are two types of general posting group: general business posting groups and general product posting groups. 

-       General Business Posting Groups are assigned to customers and vendors. Examples of general business posting groups are: Wholesale and Retail, Domestic and International, Consumer and Corporate, etc. 

-       General Product Posting Groups are assigned to items and resources. Examples of general product posting groups are: product lines, resource types, etc.

For each combination of business and product posting groups, you can assign a different set of G/L accounts. With this flexibility, you can post the sale of the same item to different sales accounts in the G/L based on the customers being assigned to different business posting groups. For example, you could differentiate the sales accounts that should be affected for international versus domestic sales.  You may also use the same G/L account for different combinations, enabling you to use posting group filters for reporting purposes.

Specific Posting Groups

Specific posting groups are assigned to customers, vendors, items, bank accounts, and fixed assets. These posting groups link the subsidiary ledgers (such as AR or AP) in Business Central to the general ledger. 

There are some exceptions, but typically specific posting groups are linked to the balance sheet accounts that will be affected during a transaction.

Specific posting groups include the following:

-       Customer Posting Groups are linked to accounts receivable accounts.

-       Vendor Posting Groups are linked to accounts payable accounts.

-       Inventory Posting Groups are linked to inventory asset accounts.

-       Bank Account Posting Groups are linked to bank accounts.

-       Fixed Asset Posting Groups are linked various fixed asset related accounts (acquisition, accumulated depreciation, depreciation expense, etc.). 

You can create multiple posting groups within each type, allowing you to post transactions to different control accounts. For example, multiple inventory posting groups allow you to easily view values of raw materials and finished goods on your balance sheet. The different posting groups can also be useful when printing reports or processes. For example, you could use multiple vendor posting groups to run an aged accounts payable report for expense versus trade vendors, or create a check run for just employees.

When using specific posting groups, it is recommended that direct posting be turned off for the related G/L account to ensure that the subsidiary ledger always ties to the general ledger.

Tax Posting Groups

Tax posting groups are used mainly with value-added tax, which is a transaction tax. This tax is paid by the end consumer, including businesses. The principles for setting up tax posting groups, both business and product types, are similar to those used for setting up general posting groups. Tax posting groups are not normally set up for US-based businesses. Please discuss tax posting groups with your Consulting representative before setting up this feature.

Setup

The definition and setup of posting groups is a critical step towards ensuring a proper posting structure, as well as providing the necessary details and flexibility for reporting. This can be a complicated process, and it is highly recommended that you discuss your business needs with your Consulting representative. Together, we will determine the appropriate posting groups and related setup for your company.

As your business grows and changes, it may be necessary for you to make additions and modifications to your existing posting group setup. While these changes are to be expected and a part of any evolving business, they need to be as carefully considered as your initial posting group setup; failure to implement posting group changes according to a well-defined strategy can lead to data inconsistencies. Please discuss any necessary posting group changes with your Consulting representative.

Once your posting groups have been defined, they must be linked with the appropriate general ledger accounts. 

In order to complete posting group setup, you must set up your chart of accounts.

General Posting Group Setup

Setup for general posting groups is performed in the General Posting Setup window. This is a matrix-style window in which you can assign G/L accounts to different general business and general product posting group combinations. For each combination, you can assign G/L accounts for different business scenarios, such as sales, purchases, and COGS. In this way, you can ensure that the proper accounts are impacted when the specific general business/general product posting groups combination occurs on a transaction. For example, if you set up different general business posting groups for domestic versus international customers, you could differentiate the sales accounts that should be affected for both types of sales. 

The following are some recommendations for completing general posting setup:

  • General posting setup accounts are generally income and expense accounts.
  • A separate general posting setup line should be created for every combination of general business and general product posting group that may occur.
  • In addition, for every general product posting group, you must also create a general posting setup line with a blank general business posting group. This is necessary for making journal entries and processing other activity that is unrelated to a customer or vendor. Only the inventory adjustment account should be filled in on these lines.
  • Only fill in the G/L accounts where you expect transactions to occur. For example, do not enter an account in the Sales Prepayment Account field if you will not be processing prepayments. This can help identify and prevent errors in data entry.
  • Generally, the Purch. Account and Direct Cost Applied Account fields are linked to the same G/L account for a wash-in/out effect. Alternatively, these can be set up as unique accounts next to each other for visibility.
  • You should only fill in the sales and purchase payment discount fields if the Adjust for Payment Disc. check box in the General Ledger Setup window has been selected. 

It is possible to copy an existing general posting setup line to a new line by selecting the relevant line and then choosing the Copy action in the ribbon. You can then specify the general business and general posting group combination to which you want to copy the line’s settings, as well as whether you want to copy all accounts, or selected ones. This is useful if you have multiple general business/product posting groups with similar accounts, as you can copy existing setup to these other lines, then perform the necessary tweaks or changes.

You must have already set up the target general posting setup line(s) before you can copy existing data to them.

Specific Posting Group Setup

For customer, vendor, bank account, and fixed asset posting groups, the assignment of G/L accounts occurs in the same window in which the posting groups themselves are created. For example, in the Customer Posting Groups window, you would create each customer posting group you want to use, then assign G/L accounts to that posting group on the same line. The process of assigning G/L accounts to customer, vendor, bank account, and fixed asset posting groups is essentially the same, although the type of activity for which you can assign general ledger accounts is of course dependent on the posting group (for example, you would define receivables accounts for customer posting groups and payables accounts for vendor posting groups).

The setup for inventory posting groups is different in that G/L accounts are assigned to different combinations of location and inventory posting group. This setup is performed in the Inventory Posting Setup window. For each combination of location and inventory posting group, you can assign G/L accounts for inventory assets, WIP, and different types of manufacturing variance. In addition, for every inventory posting group, you must also create an inventory posting setup line with a blank location. This is necessary for making journal entries and processing other activity that is unrelated to a location. 

Understanding Posting Setup

Account High level overview



Journal Entry Transaction Examples

Purchase & Sales


Inventory Adjustments


Transfers



Item Charges



Manufacturing



Narrative Analysis by Posting Group

See attachment for setup examples.

Informational videos

    • Related Articles

    • Set Up Finance Charge Terms

      When a customer does not pay by the due date, you can have finance charges calculated automatically and add them to the overdue amounts on the customer's account. You can inform customers of the added charges by sending finance charge memos. But ...
    • Specify posting periods

      In this article To specify posting periods Video guidance See also Use posting periods to specify when users can post to the general ledger. To specify posting periods Choose the icon, enter General Ledger Setup, and then choose the related link. On ...
    • Collect Outstanding Balances

      In this article Statements Reminders Finance Charges Multiple Interest rates See Also Managing receivables includes checking whether amounts due are paid on time. If customers have overdue payments, you can begin by sending the Customer Statement ...
    • Send Reminders of Outstanding Balances

      You can use reminders to remind customers about overdue amounts. You can also use reminders to calculate finance charges such as interest or fees and include them on the reminder. Before you can create reminders, you must set up reminder terms and ...
    • Set Up Bank Accounts

      In this article To set up bank accounts To enter an opening balance To set up your bank account for import or export of bank files To set up vendor bank accounts for export of bank filesShow 2 more You use bank accounts in Business Central to keep ...