This week’s Management Reporter tip for Microsoft Dynamics ERP is on Column Restriction for Rows.Column Restrictions for Rows – Restrict data and formats to specific columns on the report as illustrated below.Row 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 visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Acct Modifier.Update: Register now to get more helpful tips at our two-day Management Reporter training class Aug. 26-27. … [Read more...] about Management Reporter Tips and Tricks – 43. Column Restrictions for Rows
Management Reporter Tips and Tricks – 42. Dynamic Headers with CALC
This week’s Management Reporter tip for Microsoft Dynamics ERP is on Dynamic Headers with CALC.Dynamic Headers with CALC – If you want the auto text to populate in the column header for a calculated column, you will need to define the Fiscal Year and the Period, as highlighted in the illustration below.Column Definition:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Column Restrictions for Rows. … [Read more...] about Management Reporter Tips and Tricks – 42. Dynamic Headers with CALC
Management Reporter Tips and Tricks – 41. Calculations on Hidden Columns
This week’s Management Reporter tip for Microsoft Dynamics ERP is on calculations on hidden columns.Calculations on Hidden Columns – When using non-printing rows that you want to be included in the calculation you need to specify the columns individually B+C+D. When you want a total for only the rows displayed on the report use the range B:D as highlighted below.Column Definition: This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Dynamic Headers with CALC. … [Read more...] about Management Reporter Tips and Tricks – 41. Calculations on Hidden Columns
Boyer & Associates Hosts Microsoft Dynamics ERP Comparison Event on September 17, 2015
Register for Boyer & Associates Microsoft Dynamics ERP Comparison Event on September 17 September 10, 2015, Minneapolis, MN --- Boyer & Associates, a Minneapolis-based provider of Microsoft business management solutions, will be hosting a Microsoft Dynamics ERP Comparison Event on September 17, 2015 from 8:30 a.m. – 12:00 p.m. CT at the Microsoft Technology Center in Edina, MN. This free event is geared toward companies and organizations that are in the market for a better financial management solution.The event will provide an opportunity for attendees to learn and evaluate three leading Microsoft Dynamics ERP solutions including Microsoft Dynamics GP, Microsoft Dynamics NAV, and Microsoft Dynamics SL. “Finding the right … [Read more...] about Boyer & Associates Hosts Microsoft Dynamics ERP Comparison Event on September 17, 2015
Management Reporter Tips and Tricks – 40. IF THEN ELSE
This week’s Management Reporter tip for Microsoft Dynamics ERP is on IF THEN ELSE.IF THEN ELSE – This allows you to pull in data to other rows such as a negative asset account into the liability section of the balance sheet based on the value. Below is the formula for the asset section; copy the row to the liability section and reverse the sign in the formula.Row Definition:This tip, and many more, are covered in our Management Reporter training class held each month. If you are interested in more training, please visit our calendar to register for an event.Be sure to subscribe to our blog so you don’t miss next week’s tip – Calculations on Hidden Columns. … [Read more...] about Management Reporter Tips and Tricks – 40. IF THEN ELSE
Management Reporter Tips and Tricks – 39. Long Date Format
This week’s Management Reporter tip for Microsoft Dynamics ERP is on changing the long date format.Long Date Format - Follow the instructions illustrated below in order to remove the day from your report headers. This is not a setting in MR but is a default within the system that is generating the report.Change the date format on the system.Then, correct way for no day.This tip, and many more, are covered in our Management Reporter training classes held at Boyer & Associates. If you have questions regarding your Management Reporter software or any Dynamics ERP solution, please contact us at any time.Be sure to subscribe to our blog so you don’t miss next week’s tip – IF THEN ELSE. … [Read more...] about Management Reporter Tips and Tricks – 39. Long Date Format
Management Reporter Tips and Tricks – 38. Open Last Generated
This week’s Management Reporter tip for Microsoft Dynamics ERP is on the Open Last Generated feature.If you have large reports that take a long time to run, click the Last Generated pictured below. This will open the last generated report but will not calculate any new changes your accounting system.All of these tips and many more are covered in our Management Reporter training class held each month. If interested in more training contact us at www.boyerassoc.com.Be sure to subscribe to our blog so you don’t miss next week’s tip— Long Date Format. … [Read more...] about Management Reporter Tips and Tricks – 38. Open Last Generated
Management Reporter 2012 CU13 Released
Microsoft has released the latest Cumulative Update for Management Reporter 2012. The CU13 update contains quality fixes as well as a number of regulatory features.Here’s a summary of the new Management Reporter CU13 features:View a report in the web viewer in a grid view Display zero rounded values and zero actual values based on a report definition option Choose where the line number column displays on a report Display date formats in the report header based on regional settings Display calculated rows on the same line for different columns Report on closing transactions for Microsoft Dynamics AX 2012 Additional fixes for product defectsIn addition to the new features, there has also been a number of changes made … [Read more...] about Management Reporter 2012 CU13 Released
How to Back Up and Restore a Dynamics NAV 2015 Database Using SQL and PowerShell
Several weeks before our customer's go-live of Microsoft Dynamics NAV 2015, users were vigorously testing NAV as we were ironing out the specifics of the customer's desired configurations. During this process, we wanted to start with a clean testing environment (where we wanted to use the exact configurations of the production environment and there weren’t any posted transactions obfuscating our testing scenarios).Now, after the customer has gone live and has started using NAV, we wanted them to still have a good testing environment where they can test and practice transactions, but want them to use real life data. So how do you handle this? You simply use a back up and restore process to provide the proper testing environment for the … [Read more...] about How to Back Up and Restore a Dynamics NAV 2015 Database Using SQL and PowerShell
Boyer & Associates Named to 2015 Bob Scott’s Insights Top 100 VARs for the Sixth Year
Boyer & Associates Selected as 2015 Top 100 VAR for 6th Year from Bob Scott’s Insights July 8, 2015, Minneapolis, MN --- Boyer & Associates, (Boyer) a leading provider of Microsoft Dynamics ERP business management solutions for mid-sized businesses, has been selected as a member of Bob Scott’s Insights Top 100 VARs for 2015. The Top 100 resellers are chosen from organizations specializing in the sale, implementation and support of Enterprise Resource Planning (ERP) and accounting software.This is the sixth time Boyer & Associates was named to the list. Boyer & Associates sells and supports Microsoft Dynamics GP, Microsoft Dynamics SL and Microsoft Dynamics NAV financial management solutions to a variety of industries … [Read more...] about Boyer & Associates Named to 2015 Bob Scott’s Insights Top 100 VARs for the Sixth Year
