Every finance professional knows the importance of budgeting. A company can thrive or dive based on its ability to handle resources wisely. Recently, I’ve heard the term “forecasting” a lot. At first glance, one might dismiss it simply as a synonym for budgeting, but in reality the two represent very different ways of approaching your company’s financial welfare. Let’s take a closer look. Budgeting is a detailed, comprehensive look at how management envisions the business will perform in terms of results, financial positioning and cash flows for a specific period of time. Budgets are typically updated once a year, though managers might take remedial steps along the way to bring actual results back on track with the projected … [Read more...] about Budgeting Vs. Forecasting For Better Business
Exporting Dynamics Management Reporter Reports to XPS
What is XPS? XPS was designed as a replacement for the Enhanced Metafile (.EMF) format. It is similar to a .PDF file, but is based on XML instead of the PostScript language. Pros It is an electronic document that can’t be changed, true paperless document. The XPS viewer is usually installed on all newer windows operating systems. Cons There is no security around the information exported or who gets the report. The user is unable to drill into the details of the data. Improvements The ability to add comments directly to the report and have them show up on the export is a very nice feature that MR added over FRx. XPS – MR Viewer This method is similar to printing with a couple of differences. The first difference is that on the … [Read more...] about Exporting Dynamics Management Reporter Reports to XPS
Generating and Sharing Management Reporter Reports to UNC Locations
Pros There are no files to distribute to the users Allows the users to select different versions of the report, such as the previous month. Cons The user is not always aware of when the reports have been updated for the month. The link may have a different name but it always opens the current version. Improvements You don’t accidentally write over the previous months report, requiring you to recreate it. Generating Reports On the Output and Distribution tab in the Report definition select the Generate to Multiple library locations. Then select the Library location where the file will be generated to and then on the right hand side browse to the UNC path where a short cut will be placed for the report or click add and manually … [Read more...] about Generating and Sharing Management Reporter Reports to UNC Locations
Generating and Sharing Management Reporter Reports to SharePoint
Pros The users can be notified when the report is updated. Allows users not logged into the network to view the reports. Cons May require additional software and costs. The link may have a different name but it always opens the current version. Improvements This feature was not available with FRx. Generating Reports The first step is to configure Share Point to allow Management Reporter to generate reports. You will need to log into the server, open services, scroll to the MR Process Service and right click to go to properties to find the user id that generates the reports for MR. Now go to the SharePoint folder where the reports will be generated to and go to the library settings. Sharing Reports Now go to … [Read more...] about Generating and Sharing Management Reporter Reports to SharePoint
Is Data Warehouse the Best Tool for Nonprofits?
When you have decisions to make but an overabundance of data, how can you make the best decision? This is where data warehousing can be helpful particularly for nonprofit organizations that pull data from multiple data sources. This article explains how a data warehouse can improve management and analyses of your information from Microsoft Dynamics GP, Dynamics SL or Dynamics NAV. What Is a Data Warehouse? A data warehouse (DW) is a multi-dimensional database or a virtual storage unit that houses diverse transactional and operational data sets. Think of it this way: if you could add a third dimension to an Excel spreadsheet, you could organize all of your transactional and operational information. Management of DWs involves a technical … [Read more...] about Is Data Warehouse the Best Tool for Nonprofits?
Security Tips in Microsoft Dynamics GP
Since security has become more complicated in Dynamics GP, there are times when it becomes difficult to figure out what tasks a user needs assigned in order to access a certain window. In the beginning of this blog post, we will show you the detailed information and how we previously did this. In the later half of this post, we provide a new script that you can run that will help automate this process for you. Usually the main security issue is that a user tries to access a certain window and get an error saying they do not have permission to open that window. Initially, you could determine the requirements by creating a DEXSQL log of the permission error. Start this log just at the moment before you click the link or open the window, then … [Read more...] about Security Tips in Microsoft Dynamics GP
Management Reporter Tips and Tricks – 49. P&L Check Figure
This week’s Management Reporter tip for Microsoft Dynamics ERP is on P&L Check Figure. Ever wonder if you are pulling all the GL accounts and your formula is working correctly in your P&L row definitions? Add a check figure to validate and warn you if there are accounts missing, duplicated, or if the formulas are wrong. The first step is to add a non-printing check figure to add up all your P&L accounts. Now, add a row that subtracts the calculated net income from the check figure and make it non-printing if it is zero. Caution: If using a tree with the P&L, this will not check to make sure all departments are in the tree. This tip, and many more, are covered in our Management Reporter training class held each month. If … [Read more...] about Management Reporter Tips and Tricks – 49. P&L Check Figure
Management Reporter Tips and Tricks – 48. Web Viewer Default
Here's this week’s Management Reporter tip for Microsoft Dynamics ERP: Do your reports keep opening up in the web viewer like below? Change your default to the MR Report Viewer in the Reporter Designer under Tools. This will have a few more options available that the Web viewer does not have. 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 – P&L Check Figure. … [Read more...] about Management Reporter Tips and Tricks – 48. Web Viewer Default
Management Reporter Tips and Tricks – 47. Wrap Text
This week’s Management Reporter tip for Microsoft Dynamics ERP is on the Wrap Text feature. Wrap Text – This feature is in the column definition and prevents the row description from being cut off, as illustrated 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 – Web Viewer Default. … [Read more...] about Management Reporter Tips and Tricks – 47. Wrap Text
Management Reporter Tips and Tricks – 46. Renumber Row Option
This week’s Management Reporter tip for Microsoft Dynamics ERP is on the Renumber Row Option. Renumber Row Option – Found in the Row Definition Edit/Renumber rows. It will also renumber formulas. The Renumber Row Option is a very nice feature for those accountants that like good organization in their reports. Before: After: 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 – Wrap Text. … [Read more...] about Management Reporter Tips and Tricks – 46. Renumber Row Option
