This week’s Management Reporter tip for Microsoft Dynamics ERP is on the benefit of Account Numbers.Account Numbers in the column definitions can show the account numbers that make up the row definition without having to drill into the details.Column Definition:Result:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Rolling 12 Months. … [Read more...] about Management Reporter Tips and Tricks – 7. Account Numbers
Management Reporter Tips and Tricks – 6. Start and End Dates
This week’s Management Reporter tip for Microsoft Dynamics ERP is on utilizing Start and End Dates.Start Dates and End Dates in the column definitions can be used to report results by a data range, such as a weekly range. This restriction is useful for daily or weekly sales reporting, cash analysis needs, and other date-sensitive reports.Column Definition:In the Start Date and End Date columns, you can enter a specific day of the period. For example, “1” indicates the third day of the period. This is a nice feature as you do not need to reselect actual dates when you run the report in the next period.Result:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in … [Read more...] about Management Reporter Tips and Tricks – 6. Start and End Dates
Adding Custom Fields to a Screen in Dynamics SL
One common customization for screens in Microsoft Dynamic SL is to add fields to store non-standard data. Depending on the quantity of additional information (and its type), this can be either very simple or quite complex. Let’s start at the beginning.First, a general word on customizations – screens can be customized at multiple levels. The basic levels are All Users, One Group, One User, and Self. (It is possible to adjust the level numbers to gain additional layers, but normally, that is more trouble than it is worth.) Most customizations will be done at the All Users level.The first step is to select the proper level. This is done by double clicking on the customization level at the base of the menu window (shown below). Note that … [Read more...] about Adding Custom Fields to a Screen in Dynamics SL
Management Reporter Tips and Tricks – 5. Reporting Units & Dimension Filters
This week’s Management Reporter tip for Microsoft Dynamics ERP is on Reporting Units and Dimension Filters.Reporting Units and Dimension Filters in the column definitions can be used to separate GL accounts and departments on the report without having to drill into the details.Column Definition:Result:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Start/End Dates. … [Read more...] about Management Reporter Tips and Tricks – 5. Reporting Units & Dimension Filters
Management Reporter Tips and Tricks – 4. @UNIT Restrictions
The fourth tip in our weekly Management Reporter series for Microsoft Dynamics ERP is on @UNIT Restrictions. In case you missed any of the previous tips, you can check them out on our blog.@UNIT Restrictions can be used in the row definition to display specific parts of your reporting tree without having to generate the entire tree in your reports or drill into the details.Row Definition: Requires a tree to be selected for the report.Result:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Reporting Units & … [Read more...] about Management Reporter Tips and Tricks – 4. @UNIT Restrictions
Management Reporter Tips and Tricks – 3. Ratios in Reports
This week’s Management Reporter tip for Microsoft Dynamics ERP, the third in our series, is on Ratios in Reports.Ratios can sometimes be complicated and may seem like you need to export to Excel to do them. Using other non-printing rows to calculate ratios and other formulas will eliminate the need to export to Excel.Row Definition: Use the NP function to hide the data used for the ratios or formulas under print control.Result:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – @UNIT Restrictions. … [Read more...] about Management Reporter Tips and Tricks – 3. Ratios in Reports
Management Reporter Tips and Tricks – 2. Using PERIOD in the Column Formula
Last week, I started a weekly segment on Management Reporter tips for Microsoft Dynamics ERP. The tip last Wednesday was on Change Base Row (CBR), so be sure to read it if you missed it the first time. Today’s tip will be on using PERIOD in the Column Formula.PERIOD is part of the formula that is found in the column definition. Using this as part of the formula will calculate an average rather than a sum.Column Definition: Formula = “B:MPERIODS”This report was run for period 4. The last column sums the displayed columns and divides by the base period.Result:This tip and more are covered in our Management Reporter training class held each month. If you are interested in more training, please contact us or visit our calendar to … [Read more...] about Management Reporter Tips and Tricks – 2. Using PERIOD in the Column Formula
The Account Structure in Dynamics SL – An Essential Building Block
A well designed management accounting system will communicate the significance of financial goals within the organization. The financial information provides a basis for assessing performance against targets and is often an important input to management decisions. The quality of this information depends on the policies and procedures used in its production, but also on a well-designed and maintained accounting structure. A badly designed structure, on the other hand, can often lead to inefficient and difficult processes, and potentially to poor financial information.So how does one go about designing the essential building blocks for financial information? While there is no standard answer, there are several things to consider when … [Read more...] about The Account Structure in Dynamics SL – An Essential Building Block
Management Reporter Tips and Tricks #1
Each week, I will be sharing a Management Reporter tip for Microsoft Dynamics ERP. If you are not familiar with Management Reporter, it is a real-time financial reporting application designed to empower information workers to quickly and easily create, generate, secure, and publish financial statements, such as Profit and Loss (P&L) statements, balance sheets, and cash flow reports. This first post is a calculations tip on Change Base Row. Change Base Row in Management Reporter Change Base Row (CBR) is a format code found in the row definition that allows the report to calculate a percentage of net sales or another row. Seeing a percentage of sales can be valuable if you want to compare your financials to another company or division to … [Read more...] about Management Reporter Tips and Tricks #1
Possible Values Lookup Feature in Dynamics SL 2015
For the past month, the Microsoft Dynamics SL team here at Boyer & Associates has been beta testing the new SL 2015. We have already posted on several new features and highlights of the program, which you can read here. We will continue to post regularly on our findings to inform you on what you can expect with the upgrade.Today, I am going to do a deep dive on one of the new features – the Possible Values Lookup or PV Lookup. This is the screen that pops up when you hit the F3 key or double right-click in a field that has a lookup associated with it. The PV Lookups have used the same functionality for many years, and that functionality was good. However, I must admit that I am pretty excited about the new PV Lookup … [Read more...] about Possible Values Lookup Feature in Dynamics SL 2015
