Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Taking Your Financial Reports to the Next Level with Management Reporter – Postings Audit (5 of 8)

Taking Your Financial Reports to the Next Level with Management Reporter – Postings Audit (5 of 8)

  • Comments 1

The fifth report in the “Taking your Financial Reports to the Next Level with Management Reporter” series is called “Postings Audit.” Entering transactions accurately is important for proper reporting. Transactions should be posted to the correct accounts and dimensions with the correct amounts. The Audit report helps you evaluate how transactions were posted by providing a look a the details for each transaction in a straightforward way.

The Row Definition for the report contain a Dimension Value Set of several accounts that commonly have posting issues. Alternatively, a Row Definition similar to a trial balance containing all natural accounts could be used. The Column Definition contains the month-to-date amounts as well as several columns with specific transaction attributes. These attributes may vary by the Dynamics ERP you use, but for Dynamics GP I used the following:

  • Transaction Date
  • Audit Trail Code
  • Journal Entry
  • Distribution Reference
  • Source Document
  • Series
  • Originating Master Record Name

 

 

This video contains how to create a Postings Audit report for your business.  

 

 

In summary, the key features included in the “Postings Audit" report were:

  • Dimension Value Set to display a list of the accounts that should be reviewed.
  • Transaction attributes to show the journal entry number and other key transaction details.
  • Downloading the report to Excel, where it's easier to review large amounts of data.  

 

Links to other posts in this series:  

Leave a Comment
  • Please add 7 and 2 and type the answer here:
  • Post
  • Any insight on how adding attributes works with AA/GP/MR? In some initial testing, I am only able to pull "Originating Master" data when looking only at GL financial dimensions. When Analytical Accounting data is added to the MR report, the originating data no longer populates.

Page 1 of 1 (1 items)