The Lost Art of Reconciling by Posting Type in Dynamics AX

by | Updated December 20, 2017 | Dynamics 365 for Finance and Operations, Dynamics AX, Financials

I was recently training some controllers on month-end reconciliations in Dynamics AX – how to reconcile the sub-ledger to general ledger. We had a small discrepancy in Accounts Payable and I wanted to show them how to track it down.

I’ve always taken a three-step approach to reconciliations:

  1. Review the relevant Ledger reconciliation report.
  2. Analyze the postings to the GL account(s) in question to find any postings that don’t belong.
  3. Analyze the postings in other GL account(s) to find any stray postings that should’ve gone into the account we’re reconciling.

We executed step 1 and it didn’t give us the answer. I’ve found step one to be fairly hit or miss in my career depending on how Dynamics AX postings are configured.

We moved on to step 2 and popped open the good old Ledger Transactions Inquiry form. I was struck by how intensely the controllers latched on to voucher prefixes as a primary means of analyzing these transactions. Voucher prefixes are alphanumeric codes embedded in number sequences that are intended to provide a hint as to where the GL transaction originated from. Some common examples of vouchers might be GJ00001 where GJ means General Journal or APP00001 where APP means AP Payment. It occurred to me that just about every accountant I’ve ever worked with in Dynamics AX has done the same thing – use the voucher prefix to analyze transactions. But that’s not the only way to get it done. A special and important field called Posting Type is the other half of the reconciliation recipe.

Voucher prefix and posting type in transactions in Dynamics AX.

Posting types are what tell a transaction in Dynamics AX which main accounts to use. For example, when you setup Inventory Posting, you configure the account to use for Cost of Sales postings when you invoice a Sales Order. The posting type for Cost of Sales is called “Cost of Goods Sold – Invoiced”. So you’d associate your Cost of Sales main account of 5000 to the Cost of Goods Sold – Invoiced posting type in setup, as shown below.

'Posting types are what tell a transaction in AX which main accounts to use, such as "Cost of goods sold, invoiced."

Then, whenever any sort of transaction that posts a Cost of Goods Sold – Invoiced line as a part of its voucher posting, it will know to use account 5000. Here’s an example of the voucher posting from a sales order invoice:

The voucher posting from a sales order invoice.
You can see why posting type is such a powerful tool in reconciliation because it links you back to how Dynamics AX determined which account to use when posting.

So in Step 2, reviewing for BOTH voucher prefixes that don’t belong and posting types that don’t belong is a very effective way to identify reconciliation discrepancies.

Step 3 is the inverse of Step 2. Basically, you search for voucher prefixes or posting types that you expect to post to the account in question but that landed elsewhere. So for example, if you wanted to confirm that all your cost of goods sold postings correctly ended up in account 5000, you’d search the voucher transaction inquiry window where account is not equal to 5000 (!5000) and where posting type is “Cost of goods sold, invoiced.” If you find entries with those posting types somewhere else, start investigating why!

Closing tip on posting type in Dynamics AX

When searching and filtering by just about any “type” field (like posting type, project type, etc) you can’t use wildcard characters, you have to enter the text exactly. You can still use all other search syntax like ! for “not” and a comma to separate multiple values you’re searching for.

Happy reconciling!

Related Posts

2 Comments

  1. Muhammad Yousaf

    How to do this in Dyanmics AX 2012 R2

    Regards
    Yousaf

  2. Dalton Roll

    Hello Yousaf,

    I have spoken to the blog writer and got the following response.

    “Good news – it’s exactly the same. All you have to do is personalize to move the posting type from the bottom of the window into the grid. Voile!”

    Regards,
    Dalton

Submit a Comment

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

Upcoming Events

march

03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

april

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Jumping into the Deep End of the Data Lake

14apr10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

21apr12:00 pm1:00 pmGetting Started with Barcode Scanners and WMS Apps for Business Central

22apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Moving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turn

28apr12:00 pm1:00 pmPower Up Microsoft Dynamics by Automating Budgeting, Dashboarding and Reporting

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