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
Boyer & Associates to Host Event for Organizations Evaluating New Accounting/ERP Solutions on September 17, 2014
Boyer & Associates Hosts Microsoft Dynamics ERP Comparison Event on September 17, 2014 August 29, 2014, 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, 2014 from 8:30 a.m. – 12:00 p.m. CT at the Microsoft Technology Center in Edina, MN. The free event is geared toward companies and organizations that are in the market for a better financial management (ERP/accounting) 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.“We know that … [Read more...] about Boyer & Associates to Host Event for Organizations Evaluating New Accounting/ERP Solutions on September 17, 2014
How to Delete a Previously Printed Sales Order Processing Batch in Dynamics GP
Microsoft Dynamics GP users, have you ever wondered how to delete a Sales Order Processing (SOP) batch that has already been printed? Today, I will explain how to do just that, whether some or all of the documents in it have been printed.When you try to delete a batch of sales invoices where some or all have been printed, you will receive an error:This error occurs because documents in this batch have already been printed. By design, Dynamics GP will not allow you to delete a sales document once it has been printed. You can void the documents but not delete them.If you do not want to void the documents, you can also resolve this issue by manually updating the SOP10100 TIMESPRT column to equal zero for this batch in SQL Management … [Read more...] about How to Delete a Previously Printed Sales Order Processing Batch in Dynamics GP
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
Exciting, Free ERP Events in September with Boyer & Associates
Boyer & Associates will be hosting two exciting, informative events on Microsoft Dynamics ERP solutions in September. Both events, held at the Microsoft Technology Center in Edina, MN, are FREE and open to the public.The first event is our Microsoft Dynamics ERP Shootout, held Wednesday, September 17, from 8:30am - noon. This is the perfect opportunity for you and your team to see the industry-leading ERP solutions in one place, at the same time, and help jump start your enterprise software selection projects. We will dissect and compare the most popular Microsoft Dynamics ERP solutions on the market, including Microsoft Dynamics GP, Microsoft Dynamics NAV, and Microsoft Dynamics SL, to enable you to see, feel, and determine which … [Read more...] about Exciting, Free ERP Events in September with Boyer & Associates
Boyer & Associates Expands Microsoft Dynamics NAV Consulting Team
Fred Holst Joins Boyer & Associates Expanding Dynamics NAV Consulting Team as Practice Leader August 14, 2014, Minneapolis, MN --- Boyer & Associates (Boyer), a leading Minneapolis-based provider of Microsoft Dynamics ERP business management solutions for mid-sized businesses,announced that Fred Holst has joined Boyer & Associates as the Microsoft Dynamics NAV Practice Leader. With more than 30 years of experience in software consulting, he will be responsible for managing the Dynamics NAV practice including providing sales and pre/post-sales support to help identify, qualify and close solution opportunities; managing and mentoring the internal NAV team; ensuring project implementation success and client satisfaction, and … [Read more...] about Boyer & Associates Expands Microsoft Dynamics NAV Consulting Team
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
Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP
Microsoft SQL Server Reporting Services (SSRS) is a great tool for writing custom reports for Microsoft Dynamics GP users. One issue that caused a little frustration was having to create multiple reports to accommodate different databases in GP. When a customer would request a change to a report, I would have to modify the report and then redeploy the report three or four times. Finally, I decided, “Why not make the data source dynamic?”After a little searching on the web, I found a way to base the data source connection on a parameter. My first step was to create a parameter to allow the user to select the company they would like to run the report against. This is easy enough to accomplish by creating a dataset based on the following … [Read more...] about Dynamic Data Source in Microsoft SQL Server Reporting Services for Dynamics GP
