By Troy Minor, Raffa Technology
Standing at the door to your office is a manager who wants to know why the expenses for her department for the month are 20 percent over budget. You accept the request for more information and task a member of your staff to pull the data or you do it yourself. You may run a GL detail report and compile the data in Excel and then email it. You performed this activity last month and the month before and anticipate doing it next month for at least one department or project manager. There is a better way.
Many of the tools we use have features and functionality that would enhance our productivity. Many times, we do not know that the features exist. One such feature is the ability to view transaction level details in your Management Reporter (MR) reports. Most users are familiar with the ability to drill down from a summary financial report to the account level and to the transaction level, but many users do not know that the specifics of a particular transaction can also be viewed. The transaction details in the screen capture below provide additional insight into the transactions that make up the account activity.
The transaction details or attributes are suppressed until a user drills down to the detail level from the account level. The attributes are not limited to the fields in the image, but also include journal entry number, customer number, source module or series, batch number, audit trail codes and a few others. To include the transaction details, there is a small amount of report configuration that must take place, but it only takes a few minutes to make the changes. Additionally, Management Reporter requires that there be at least one current month or current period column in the report format.
Using Management Reporter’s transaction attribute functionality will not only provide transaction data to accounting and finance personnel, but will also put additional information in the hands of report consumers outside of the finance department. Project and department managers will already have access to some of the information that they need to answer variance questions. Providing this additional capability to your managers in advance of them asking for it not only increases the service level your department provides to its internal customers, it also eliminates some of the questions that are asked month after month by report consumers.
If you need additional information on how to configure MR to provide detailed transaction information or options to publish/push reports out to end users, the Raffa Technology team can help. Please contact Troy Minor at firstname.lastname@example.org if you are a Dynamics GP user or Michael Ranes at email@example.com if you are a Dynamics SL user for any questions on Management Reporter and its functionality.