Basic General Ledger Integration through Posting Setups in Dynamics NAV

by | Updated January 3, 2018 | Dynamics 365 Business Central, Dynamics NAV, Financials

*This post was written for Dynamics NAV but the content directly applies to Dynamics 365 for Financials, which is the cloud product based on Dynamics NAV. You may notice some slight differences in the screenshots, but the information and steps are directly applicable to Dynamics 365 for Financials.

When transactions are created within Dynamics NAV that do not directly reference the general ledger (GL) accounts to which they should be posted, setup tables are employed to map the accounts during posting. This post will cover some basic GL integration scenarios through posting setups in Dynamics NAV.

In many cases, the posting setups are intuitive. As an example, each vendor is pointed to a “Vendor Posting Group” record where the accounts payable account is maintained. Likewise, customers and items have associated “Customer Posting Groups” and “Inventory Posting Groups”, respectively. Most entities in NAV have a similar configuration, including banks, fixed assets, resources, and jobs. Dynamics NAV refers to these as “specific” posting groups and they roughly correlate with the balance sheet side of a transaction.

On the other side of the ledger, NAV sometimes needs to determine how to post the offset entry – most notably when buying or selling items and resources. This part of the integration uses “general” posting groups and is not quite as obvious.

If we consider the sale of a $100 widget from our GREEN location, valued at $80 in our inventory, we can start to see how the two types of posting setup tables apply and interact. We will ignore taxes, discounts and other nuances that could complicate the posting. We will also avoid a discussion of costing methods in Dynamics NAV.

Below are screenshots of our customer and Widget item.



The $100 sale will certainly hit our accounts receivables account. This is defined by the “Customer Posting Group” assigned to the bill-to customer. In this case, our customer is pointed to the DOMESTIC “Customer Posting Group.” That group, in turn, is pointed to account 13100 for accounts receivable.


The item’s asset account is also pretty easy to find. Our Widget is associated with the FINISHED “Inventory Posting Group.” That posting group, for the WHITE location, uses account 14200 as the asset account.


NAV additionally needs to determine where to post the revenue and the cost of the sale. To determine these accounts, NAV looks to the “General Posting Setup” table.

The “General Posting Setup” table represents the intersection of “General Business Posting Groups” and “General Product Posting Groups.” The former are normally associated with vendors and customers while the latter is associated with things like items and resources. This is often confusing, so it can be easier to consider the general business posting group as representing the “who” of the transaction and the general product posting group as representing the “what” of the transaction.

Once our transaction has pulled the “Gen. Bus. Posting Group” from the customer and the “Gen. Prod. Posting Group” from the widget, it has what it needs to tell the posting process how to impact the general ledger.

During posting, these two posting groups are found together in the “General Posting Setup” table. For our example, the customer is associated with “Gen. Bus. Posting Group” NATIONAL and the item is associated with “Gen. Prod. Posting Group” RETAIL.

NAV General Posting Setup

As a result, our revenue will go to the “Sales Account” (44100 in this case) and the cost of sales will go to our “COGS Account” (54700).

From a general ledger perspective, our posting should look like this:


For more information on posting group setups in Dynamics NAV, visit the following MSDN links:

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


14jan11:00 am12:00 pmConfab with Stoneridge - Livestream - Looking Forward: Predictions for Technology in 2021

20jan10:00 am10:30 amThe Modern Manufacturer - Demand Forecasting Functionality

27jan12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 1 – Fit

28jan11:00 am12:00 pmConfab with Stoneridge - Livestream - Ask the Experts!


03feb10:00 am10:30 amThe Modern Manufacturer - Enterprise Asset Management

03feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 2 – Platform

10feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 3 – Implementation Partner

11feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Live Agents, Power Virtual Agents, Omnichannel – Oh My!

16feb12:00 pm12:45 pmFour Keys to Choosing the Best ERP or CRM Solution: Part 4 – Cost

17feb10:00 am10:30 amThe Modern Manufacturer - Machine Maintenance Work Orders

25feb11:00 am12:00 pmConfab with Stoneridge - Livestream - Surfing Through the Dynamics 365 Wave 1 2021 Release

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!