GSL Blog
What to expect in the new release of Microsoft Dynamics Management Reporter 2012
Written by Alicia Berglund
April 26, 2012
Management Reporter 2012 (MR) for Microsoft Dynamics ERP is a powerful financial reporting solution paired with Microsoft Dynamics GP. In the past the go-to solution was FRx. Over time FRx will be phasing out as the developers continue to enhance MR. If you have used FRx, MR will feel very familiar. MR uses similar methodology of rows, columns, and trees. With the latest release there are some exciting new features!
Below are just a few of the many enhancements to take advantage of with this new release:
Design
- Quickly identify accounts/dimensions that have been omitted from report building blocks.
- Easily save and reuse dimension combinations when designing reports
Collaboration
- Schedule reports to generate automatically on a periodic basis
- Publish read-only reports
- E-mail reports via SharePoint alerts
Interactive Report Viewing
- Create graphical charts
- Add comments to rows in a report version
- Copy comments from one version of a report to another
- Use instant messenger to collaborate on a report
To schedule your conversion from FRx to Management Reporter or to update your current version of Management Reporter contact us at 207.761.2133.
Free Tools for Dynamics GP!
Written by Sandra Allin Wyman
April 2, 2012
FREE tools to change and/or merge Dynamics GP GL Accounts, Customers, Vendors, Inventory Items – and MORE!
Have you heard that Microsoft is now offering The Professional Services Tools Library (PSTL) at no charge? The PSTL contains several utilities that change, merge, update, check, and report on a variety of records that businesses need as they grow and change. Historically these powerful tools have been for purchase only, and require registration keys. Not any more….. the utilities needed to change and control critical data and processes are FREE and get installed with Dynamics GP automatically.
In order to use the new FREE PSTL for Microsoft Dynamics GP, you will need to download the most current version and install. You will need to be logged in as ‘sa”. When you open the Professional Services Tools Library window from your shortcut, you can click on Register and the correct registration key will default in!
The Tools are organized by Series, just like all other Dynamics GP add-ons, and there are tools for each:
1. Finance Series Tools
2. Purchase Series Tools
3. Sales Series Tools
4. Payroll Series Tools
5. Inventory Tools
6. System Tools
In addition to some of the most popular tools that change/merge records, there are tools to:
· Track changes to Employee records (remember… even if you don’t use Dynamics GP Payroll, you can still use the Employee Master tables to track employee data)
· Mass Apply posted RM Credit Documents to posted RM Debit Documents by selected ranges.
· Allows Drop Ship Sales Orders to be transferred to Invoice prior to invoicing the Purchase Order.
· Start Microsoft Dynamics GP and run one or more integrations or integration groups and then have Dynamics GP exit when integrations are complete.
Have you been wanting to update critical data in your Dynamics GP System? Do you want to simplify some of the processes that are taking longer than they should? Call us (207.761.2133) or email us at info@gilchristscott.com to find out if PSTL can save you time and money.
How to “fix” a Bank Deposit that Can’t be Voided
Written by Lindsay Walsh
March 20, 2012
What to do when a Bank Deposit has been reconciled, but includes incorrectly applied Cash Receipts in Dynamics GP
A GP User recently contacted me for support regarding a Bank Deposit that needed to be voided. The problem was that a Cash Receipt had been recorded for one customer, but actually included payments for multiple customers. (Note: This was not a true Parent:Child Customer relationship.)
Unfortunately, this Bank Deposit had been ‘cleared’ via Bank Reconciliation already, so there was no way to void it. Sorry - GP doesn’t allow that.
So, what to do? Her bank balance was correct. Her Accounts Receivable GL Balance was correct, but the individual customer balances were wrong.
Here is a detailed example of the problem and the work-around we used to fix it:
Problem: A $6,000 Bank Deposit on 1/16/2012 included the following Cash Receipts:
- $1,000 from customer ABC01
- $2,000 from customer DEF01
- $3,000 from customer GHI01
The total of $6,000 was correct, and the Bank Reconciliation process went smooth as can be.
The Cash Receipt from customer GHI01 was actually supposed to be split between two customers - $2,000 for GHI01 and $1,000 for JKL01.
The steps we took to correct are as follows:
- 1) Enter a Debit Memo for customer GHI01 for the amount that was incorrectly applied. In this example, the $1,000 intended for JKL01 is the amount used in the Debit Memo. This increases the amount GHI01 owes back to the correct amount. The GL Distributions are: DR Accounts Receivable, CR Sales
- 2) Enter a Credit Memo for customer JKL01 for the amount that was supposed to be applied to their account. Again, this is the $1,000 that inadvertently went to GHI01. This decreases the amount JKL01 owes, down to the correct amount. The GL Distributions are: DR Sales, CR Accounts Receivable.
- 3) The net GL Distributions are zeroed out. We debited then credited the A/R account for $1,000, and we credited then debited the Sales account for $1,000. Net effect: $0.00. The Receivables Bath Entry window will show 2 transactions with a Batch Total of $2,000 - the absolute value of the batch.
This process corrected the customer balances, did not touch the Checkbook, and had no effect on the GL balances.
What to do to correct an overpayment to an employee using Dynamics GP Payroll module.
Written by Alicia Berglund
March 15, 2012
I found excellent instructions written by David Hobbs of Evarsys,Inc.. Processing payroll can be very stressful. Add to it that you mistakenly overpay an employee who has direct deposit and the file has already been sent to the bank! Below is a blog I found to be very helpful in processing the correction which ensures that the employee’s wages are correct as well as FICA, Federal, and State taxes. It also corrects the company’s tax liabilities!
h) When you are done the front screen should mirror the precheck report exactly except with negatives. Negative gross and net should match exactly.
i) Post.
j) After the result of this you have fixed the employee and company liability. You will notice the Check Register will show all the taxes and company liability as negative.
6) Create a new payroll deduction code for the employee. It should be sheltered from all taxes as you want this deduction to come out first before any taxes are calculated on it. Enter the single amount of the deduction to be taken back from the employee for the overpayment.
7) In the new pay run make sure to include this new deduction.
He has outlined all the steps except for reversing the impact of the negative check. GP creates a negative check in bank reconciliation module and thus creates an entry to the payroll cash account.
Every Business Needs HR Software
Written by Sandra Allin Wyman
March 1, 2012
Did you know that Dynamics GP has a feature rich HR solution? You don’t have to use Dynamics GP Payroll to take advantage of the HR module.
With the inherent risks of managing your HR data stream, you can’t afford to be missing deadlines or keeping track of critical data in multiple places, or worse, on one computer that isn’t backed up adequately.
If you’re using spreadsheets or paying to outsource your HR to track applicants, benefit eligibility, OSHA log, or employee review dates, (to name a few), you should consider Dynamics GP HR. Check out the breadth of functionality – out of the box:
• Applicants & Interviews
• Benefits & Deductions
• FMLA and COBRA
• Employee Reviews and Property
• Grievances & OSHA Compliance
• Skills, Tests, Certifications, Licensing & Training
• Orientation and Termination
• Health & Wellness
Contact us to find out how our customers save time and lower their risk with Dynamics GP HR.
(800)-498-5474 or info@gilchristscott.com
Microsoft Dynamics GP 2010—The new way to do business
Written by admin
January 16, 2012
Today’s world demands a new way to do business. Organizations continue to wrestle with complexity in a difficult business environment. They face the dual challenge of reducing operating costs while responding to greater customer needs and ultimately increasing profitability. Microsoft Dynamics® GP 2010 strengthens the ability of people and organizations to face these ongoing challenges, so that their businesses can remain competitive and grow.
This latest release of Microsoft Dynamics GP extends the reach of insight, productivity, and collaboration across the entire business, helping to ensure that people—an organization’s most powerful asset—and the different ways they work continue to drive business success. New capabilities deliver faster access to personalized business intelligence, enhanced ways to streamline business processes, and new ways to build stronger business relationships.
Microsoft Dynamics GP 2010 makes it easier for people to work faster and smarter. Employees can make rapid, informed decisions and take action with enhanced insight that is personalized, simple to access, and extended across the organization through familiar Microsoft Office applications. In addition, this release continues to remove barriers that get in the way of working effectively to better connect people, information, and processes across applications and systems.
Microsoft Dynamics GP 2010 continues to deliver on the promise of a comprehensive ERP solution that goes beyond basic business management and extends easily to meet unique business needs. Simple to implement and use, the solution delivers innovation that enables all people in an organization to work with information in ways that are familiar to them—today and into the future. It’s the new way to do business.
________________________________________
The New Way to Do Business: Making it Easier with Microsoft Dynamics GP 2010
Written by admin
January 3, 2012
The term “business as usual” simply doesn’t apply in today’s marketplace. Organizations need systems that help their people orchestrate routine tasks and complex processes—all in the course of a day’s work. Microsoft Dynamics® GP 2010 offers capabilities that help people work faster and smarter. This latest release fuels efficient task management and teamwork, simplifies setup and IT administration, and offers built-in tools for meeting specific business needs.
Microsoft Dynamics GP is already well known for rich integration with Microsoft® Office system applications—without leaving the ERP solution, users can take full advantage of Microsoft Office Outlook®, Microsoft Office Excel®, and Microsoft Office Word. We’re enhancing that connection so that people can quickly create customer and vendor-facing documents using Word forms. They can also send batch and individual e-mail messages for invoices, orders, and check remittances. The result? People get more work done in less time—and the work looks more professional and polished.
There’s more. Teams can now work more efficiently, with precise tracking and accountability, by using new workflow approval processes and improved capabilities for documenting sign-offs. In addition, simplified system access includes default logon settings that can save users valuable time. Just as important, Microsoft Dynamics GP 2010 offers straightforward tools that ensure fast installation, setup, and data migration from applications such as QuickBooks and Peachtree.
The latest release also makes it easier to meet unique business needs with built-in personalization tools. For instance, people can stop juggling customer and vendor information stored in multiple sources such as Microsoft Office Access® and Excel. Without writing new code, administrators or users can create a mini business application in Microsoft Dynamics GP that consolidates the information for easier tracking and management by multiple people, for multiple tasks.
Finally, we’ve paid close attention to customer requests for enhancements that improve business efficiency and performance in highly specific areas—including analytical accounting, budget tracking, payables and receivables, payroll, field services, manufacturing, and distribution in a complex marketplace.
Microsoft Dynamics GP 2010. We’re making it easier to do business.
E-Learning in CustomerSource
Written by Lindsay Walsh
December 27, 2011
Do you know about the E-Learning content available on CustomerSource? If your company is enrolled in a service plan (enhancement plan) with Microsoft for Dynamics GP, you have free - yes, FREE! - unlimited access to:
•E-Learning: Provides detailed concepts on specific topic areas. The instruction covers content that is comparable to classroom training content
•Training materials: Can be used as a study tool or as a desktop reference
•Learning Plans: Learning Plans help individuals understand the training and certification options available, and develop a training plan to achieve their goals.
Some training materials are available in multiple languages. Learning Plans are currently available in English only.
If you do not currently have access to CustomerSource, we can help. Contact us at (207) 761-2133 and we can get you set up!



