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:
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:
Links to other posts in this series:
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.