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.

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

0 Comments

Submit a Comment

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

Upcoming Events

september

01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV

october

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

13oct12:00 pm12:30 pmWave 2 Release – What’s Coming for Dynamics 365 Sales and Customer Service

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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!

X