Basic General Ledger Integration through Posting Setups in Dynamics NAV

By Sean Solberg | January 25, 2017

Basic general ledger integration through posting setups in dynamics nav

*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.

Integration_Sean

Integration_Sean2

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.

Integration_Sean3

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.

Integration_Sean4

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:

Integration_Sean6

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

https://msdn.microsoft.com/en-us/library/hh168552(v=nav.90).aspx

https://msdn.microsoft.com/en-us/library/hh169539(v=nav.90).aspx

Related Posts

Recommended Reading:

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X