Management Reporter provides the flexibility of consolidating financial data across one or multiple organizations in one single report. This report includes a summary (consolidated) report for all companies as well as the option to view a report for each of the companies that you are using on the consolidation.
The simplest method to create a consolidation of all companies is by using a reporting tree. A reporting tree is an optional “building block” that allows you to list all companies to be consolidated. Once the report is generated you will have the option to select any company from the reporting node on the consolidated report.
Viewing Companies Side by Side
The second option for consolidated reports is to show each company side by side. This can also be achieved by defining a reporting tree with all companies and using that reporting tree to assign each company on separate columns.
Consolidated currency translation
Management Reporter also offers the ability to consolidate different currencies in on the report, where users can select at real-time any currency previously setup in each Dynamics GP company. The following items must be set up to achieve currency translation:
The Professional Services Tools Library (PSTL) can be implemented in your Microsoft Dynamics GP environment very quickly. This add-on contains a large assortment of 25+ free tools for any business wanting to increase their business productivity. These modules are listed below;
- Database Disabler – Allows the administrator to block users from logging into a company. The company will not appear in the list of companies when logging in to Microsoft Dynamics GP until the administrator unblocks the database.
- Shortcuts Copy – Use this tool to copy the shortcuts options from one user to another user.
- Update User Date – The Update User Date utility automatically updates the user data in Microsoft Dynamics GP to the next date at midnight each day. This is useful if Microsoft Dynamics GP is left running overnight.
- Menu Inquiry Utility – Shows windows that are enabled and visible in Microsoft Dynamics GP.
- Account Modifier / Combiner – Change a single or multiple account number(s) into new account numbers. Combine all of the open and historical data from two account numbers into one number or combine a range of numbers.
- Checkbook Modifier – Allows the change of an existing checkbook ID to a new checkbook ID.
- Fiscal Period Modifier – Use the Fiscal Period Modifier to change fiscal year definitions and reset data in the open and history tables. See detailed instructions before using this tool. Clicking on Setup Periods button removes previous year’s definitions.
- GL Master Triggers – Keep the account numbers in sync between company databases. Add an account number to one database and it automatically replicates to other assigned databases.
- 1099 Modifier – If the vendor was not set up as a 1099 vendor, can be used to update the records.
- PM Master Triggers – Adds new vendors to additional selected company databases.
- Vendor Combiner – Use the Vendor Combiner tool to combine a current vendor ID with another existing vendor ID.
- Vendor Modifier – Use the Modifier tool to change an existing vendor ID or range of vendors to a new vendor ID. All work, open and history transactions are moved to the vendor ID.
- Vendor Name Modifier – Use this tool to change the vendor name.
- Minimum PO\Receipt Number – Stops Microsoft Dynamics GP from looking backward for unused document numbers.
- POP Cost Defaulter – Defaults the current cost or the standard cost from the item master card instead of from the Item Vendors record.
- Customer Combiner – Use this tool to change or combine customer numbers without any loss of work, open or historical records.
- Customer Modifier – Change the customer name on all work, open and historical records.
- Customer Name Modifier – The Update User Date utility automatically updates the user data in Microsoft Dynamics GP to the next date at midnight each day. This is useful if Microsoft Dynamics GP is left running overnight.
- Receivables Transaction Unapply – Reverses the effect of applying payments, credit memos or returns, even if there are discounts and/or write-offs associated with the document.
- Customer Item Lookup – See prior purchases made by a customer during the sales order entry process.
- SOP PO Number Check – Checks to see if a Customer PO number has already been entered on a sales transaction.
- Inventory Site Modifier / Combiner – Change or combine the current Site / Location Code to a new code without losing any data.
- Item Number Combiner – Combine two items number that were setup for the same item and both were used.
- Item Description Modifier – Change item descriptions on all previously created transactions – including sales orders and purchase orders.
- Item Number Modifier – Change an item number to a new item number.
- Certified Payroll Report – Use the Certified Payroll Report with US Payroll to add a project number to employees’ hourly transactions and track them on a per project basis. This tool will also capture information posted from the Timesheet Entry window in Project Accounting Timesheet Entry. Print these transactions on a weekly report and view employees, departments, job titles and pay codes by project.
- Employee Modifier – This tool allows the user to change an existing employee ID to a new employee ID.
- Fixed Asset Modifier – Change or combine the current Site / Location Code to a new code without losing any data.
- Doc Date Verify – Prevents entry into an undefined fiscal period.
- Default Add Item POP / SOP – Forces new items in the Sales Transaction Entry, Purchase Order Entry, Receivings Transaction Entry and Purchasing Invoice Entry windows to be added as items and not as non-inventory items
- Company Copy – This tool allows the setup and report option information from one company to be copied to another company.
In today’s digital banking system, transferring EFT or ACH files to/from your bank has become a key element of any modern business. The EFT for Payables module for Dynamics GP will give your company the ability to automate this process entirely within your existing Dynamics GP environment. Proper utilization of the EFT for Payables module will increase productivity and reduce manual cheque processing.
- Learn more about the EFT for Payables module for Microsoft Dynamics GP.
- Eliminate costs associated with postage
- Stakeholder has grown accustomed to-the convenience of this immediate payment method.
- Further, it is more environmentally friendly.
- More secure than a cheque payment.
The menu bar in Microsoft Dynamics GP helps a user to easily manoeuvre around Great Plains. To optimize this feature, you can benefit from modifying and adding commonly used buttons in the menu bar. You can add buttons that fall under a variety of categories such as Financial, Sales, Purchasing, Inventory and Manufacturing.
In the menu bar, right click to add buttons:
Users are not limited to the default buttons presented in Great Plains. Buttons can be customized depending on the features that your business will need.
To customize a button, right click on “Customize,” then choose the “Main” option and click “Add” to follow along the menu path to select which button you’d like to add.
To learn more about Microsoft Dynamics GP’s capabilities, download our FREE interactive demo!
Linz Tan, Web Marketing Assistant, WebSan Solutions Inc. a 2014 Ontario Business Achievement Award Winner for Service Excellence
A common issue in Dynamics GP processing is determining whether transactions originating in your sub-ledger (Sales/Purchasing Modules) have actually created a subsequent Journal Entry in financials for the specified distributions. Clients often will post a transaction in purchasing not belonging to a batch and assume it has posted to their General Ledger. Since transactions are only posted through to the GL when belonging to a batch that has been posted, confusion often follows as to whether the correct accounts have been posted to. Perform the following steps to help reconcile and trace transaction account entries.
1) Depending on the transaction (Sales or Purchasing) document, navigate to the appropriate module in GP. For this example we will use the Sales Module
2) Upon entering the Sales module, select the Transaction by Customer option to open the Receivables Transaction Inquiry – Customer window as shown below:
3) Enter the Customer ID for the transaction which will bring up a listing of all transactions for the customer. Alternatively, you can then filter for a specific document number to narrow down your search results:
4) Once you find the document in question, select the document line such that it is highlighted and click the Document Number hyperlink (Column Title) to bring up the Sales Transaction Inquiry Zoom as shown below. Here you can view further information relating to the document (Note the date of the document for reference purposes).Once you have this window open, select Distributions:
5) The Sales Distribution Inquiry Zoom window will open and provide further details as to what accounts were hit for the specific documents. You should make note of these account numbers for the next step in the tracing process (In the example below, 00-1200-00 and 00-1300-00 are the two accounts affected):
6) Once you have noted down the account numbers, you can verify these accounts were affected by checking the specific account entry details within the Financial Module. Select Financial from the left navigation pane and click Summary within the Inquiry window and enter one of the account numbers previously noted:
7) You will now be presented with a summary of entries for this specific account by month. Select the month in which the document was posted (For this example, the document was posted in November). Once the month is highlighted, select any of the four hyperlinks (Debit, Credit, New Change or Period Balance) to drill further into that month and view specific entries:
8) From here, you will notice the $300 that was debited to 00-1200-00 on November 20th, 2013 based on the original sales document being posted. This is confirmation the appropriate amounts were affected for the specific transaction