GSL Blog

Back to Blog Homepage »

Posts Tagged ‘Microsoft DynamicsGP’

Time-saving Tricks in Dynamics GP

Monday, June 20th, 2011

Grouping tasks into similar groups is a basic organizational tool.  For us bookkeepers, that means on any given day we will enter a pile of bills, record cash receipts, and generate sales invoices – each task requiring multiple entries with repetitive keystrokes and mouse-clicks.  I find any little trick to make these transactions go more quickly is a welcome addition to my toolbox.  Here are some of my favorite tips that increase efficiency:                    

1)       In any date field in Dynamics GP, users have the option of clicking on the calendar and navigating to the desired date or using the keyboard to manually enter the date.  If the desired date falls within the same month and year as your user date, you can just enter the DD portion of the MM/DD/YYYY format and the year and month will be completed by the system.  For example, if your user date is 06/20/2011, and you are entering a transaction dated 06/10/2011, all you need to type in the date field is 10, tab out of the field, and voila!  The date will read 06/10/2011. 

 

2)      Similar to tip #1, if the desired transaction date is within the same year as the current user date, all you need to type is the MMDD portion (skip the slashes!) and the YYYY will be completed by the system.  For example, if the user date is 06/20/2011 and your desired transaction date is 02/25/2011, all you need to type is 0225 and the date will read 02/25/2011. 

 

3)      Ever notice long it takes to load up the Checkbook Register Inquiry window?  Try this:  Enter the date range first, THEN select the Checkbook ID. 

 

4)      Keyboard shortcuts!  The less I have to move back-and-forth between keyboard and mouse, the faster every transaction gets entered. 

a.       Alt-R is the magic keystroke to open the Payables Transaction Entry window from the Payables Batch Entry window

b.      Alt-S opens the Cash Receipts Entry from the Receivables Batch Entry window, then use Alt-Y to open the Apply Sales documents window.

One of the best resources for new tips and tricks is from other users.  I highly recommend a GPUG (GP User Group) membership. GPUG’s community uses a variety of tools to share information, tips and tricks and best practices.  If you want to get the most out of Dynamics GP, GPUG is a great place to learn how.

Share/Save/Bookmark

How can Business Ready Licensing (BRL) for Dynamics GP save you money?

Monday, June 13th, 2011

At Gilchrist Scott, LTD, we know how important the relationship between clients and their Microsoft Dynamics Business Partner is.  You have made the wise decision to invest in Microsoft Dynamics GP. Now is the time to ensure that you are taking full advantage of all the Microsoft Dynamics features and capabilities to enable confident decision making, drive business productivity, and reduce operational costs.

 

BRL (Business Ready Licensing), was introduced in 2006 to help Dynamics customers get more value from their existing and new solution.  The bundle offers a wide range of functionality to support your business process.  Prior to 2006, customers purchased their solution using Module-based Licensing, adding new modules as needed.  This placed the value in the functionality, whereas BRL places the value in the number of users so customers don’t have to worry about which modules to buy initially.  You own the entire bundle, and may activate unused functionality as needed.  

 

With the special  promotional offers out there, many of our clients are able to move to BRL at a fraction of the cost that it was even a few short months ago. This will enable existing clients to access dozens and dozens of new modules, and freeze their annual enhancement at their current list price.

 

If your company is interested in a License Model Transition, now is the time to do it.  Microsoft’s year-end promotions offer this transition at a deeply discounted rate, but only until June 24th.  Please contact us now to discuss!

Share/Save/Bookmark

SmartList Export Solutions for Dynamics GP

Tuesday, May 31st, 2011

If you use SmartLists in Dynamics GP, you have most likely used the Excel button to export a SmartList to Excel.  What you may not know is that there is another option called SmartList Export Solutions that is available for you to use.

Examples of things you can use Smartlist Export Solutions for are to automate totaling and formatting of SmartList data in an existing Excel Spreadsheet.   And you can export SmartList Data to the same spreadsheet over and over again.  You also gain additional functionality by being able to use macros that automate various tasks like clearing data from an existing spreadsheet, creating a new sheet within a workbook before adding data, adding up columns etc..

To Setup a Smartlist Export Solution

1)      You’ll want to save a SmartList with the columns you want, as a Favorite

2)      Export your Favorite SmartList to Excel

3)      Save the Excel Spreadsheet to the location of your choosing  and close out of Excel

4)      View your Favorite SmartList in Dynamics GP

5)      Select Smartlist>>Export Solutions from the Menu

a.       Name:          Enter a Name to identify the Spreadsheet that you will be exporting to

b.      Document:                 Enter the Path or browse to where you previously exported and saved the SmartList in Number 3

c.       Preparation and Completion Macro:  If you added a macro to the Excel File enter those names here

d.      Visible To: Enter who you would like to be able to use/see this solution

e.      Application:  Select Excel

f.        Works for Favorites:  Check the box next to the Favorite that this solution is associated to

g.       Save and Close the Export Solutions window

Back at the SmartList window open your Favorite SmartList

1)      Click the Excel Button

a.       You will now have an additional choice of Export Solution (Quick Export is the usual way of exporting a SmartList)

b.      Click Export Solution and your spreadsheet will open

                                                               i.      If you created a before and/or an after macro these will run ahead of and/or after your is exported

It can be that simple, or you can design macros for different tasks like creating pivot tables etc..  This gives you quite a few more options when exporting SmartLists to Excel, especially when you do the same type of export month after month, and this should save you lots of time once the solution is in place.  Happy Exporting!

Share/Save/Bookmark

Microsoft Dynamics GP Payroll Tax Update Round 2 is now Available

Wednesday, January 26th, 2011

We are pleased to inform you that Microsoft has released the US English version 10 FICA changes round 2 tax update.  Versions 9.0 and GP 2010 to follow this week.

This is a 2 part install, the code (.exe file) and the tax table update.  This is all noted in the documentation as well, you will need both.Once you install the code update, the new Dynamics version is 10.0.1685 

Also under Tools | Setup | System | Payroll Tax, the last tax update and code update should be 1/20/2011 once both are installed.

After further testing, there are no changes to Payroll integration to Payables, so no extra install.

PDK will still be releasing a chunk file shortly.  Integration manager and eConnect should work and will be included this field in the next service pack.  However, the 941 report is still not calculating properly for line 6e.  This is scheduled to be fixed in the next round due out in mid-February.

The 941 Prep report and the 941 Schedule B Prep report should all print correct numbers after the update (excluding line 63).  Those are two areas besides posting journals (and check history if you drag out new fields) that customers can verify numbers against.  The actual 941 form, due to it not being final, will be updated in a later code release.  Waiting for the final form at this point from IRS, still in draft format.

·         Install location
U.S. Payroll Tax Update for Microsoft Dynamics GP 10.0 (Round 2) 
This page contains the latest U.S. Payroll Tax Update for Microsoft Dynamics GP 10.0.
https://mbs.microsoft.com/customersource/downloads/taxupdates/usgptu10.htm?printpage=false
  

Round 3 targeting for mid – February is looking at the following changes

Illinois, Maine, Maryland

Please give us a call at 207.761.2133 ext 302 if you have any questions or are in need of assistance with this update.

 

Share/Save/Bookmark

Dynamics GP Payroll Year End Update - 2010

Tuesday, November 16th, 2010

Watch for Dynamics GP (Great Plains) - US Payroll year end update tentatively scheduled for 11/18/10.

Form Changes included in the year end update will include W-2, Hire Act (ends 12/31/10), W-3, and Payables 1099-INT.

Microsoft Payroll and Technical Support experts are recommending all Dynamics GP Payroll users install the year end update. We recommend you do this before the year-end crunch. It’s best to get the year-end update out of the way rather than waiting until you’re ready to process W-2’s.

GP Update Target Release Dates for Version 9,  10 SP 5,  GP 2010 SP 1
US Payroll Year End - 11/18/2010
Canadian Payroll Year End - 12/16/2010
US Payroll Round 1 2011 tax update - 12/16/2010
Business Portal W4 form change – 12/16/2010

Watch for the 2011 Tax update with the following changes (known so far):
Earned Income Credit phased out
Social Security limit remains unchanged from 2010
State changes: California, Kentucky, Minnesota, New York City

Share/Save/Bookmark

What’s New in Microsoft Dynamics GP 2010 - Financial Enhancements

Tuesday, May 4th, 2010

With the release of Dynamics GP 2010 a few long-awaited features arrive.  It’s obvious that Microsoft took the time to listen to customers’ requests for features with their latest GP version.  I’ve noted a few of my favorite Financial enhancement below:

Exclude inactive records from lookup menus!

No more searching through your inactive customers, vendors, inventory items, and GL accounts! 

Clear recurring GL batch amounts!

You can now clear the distribution amounts for all transactions on recurring batches after you post a batch.

Combine multiple budgets into a single master budget!

Create separate departmental budgets and easily combine into one.

Enter negative Cash Receipts in Accounts Receivable!

You can enter a negative cash receipt for the purpose of decreasing a deposit.

Select multiple ranges when building a check batch!

Have you planned for your upgrade to Microsoft Dynamics GP 2010 yet to ensure you benefit from all of these enhancements?

 

Share/Save/Bookmark

GP 2010 Release 5/1 Creates FREE software Promo

Wednesday, April 14th, 2010

With the new release of Microsoft Dynamics GP 2010 next month we wanted to let you know about some of the changes around licensing and pricing.  A few important points we wanted to bring to your attention:

The price of Smartlist Builder will be going up effective May 1st.  If you’ve been considering this purchase now would be a great time to take advantage of the lower rate.

Free additional Dynamics Business Portal users for customers who currently own Business Portal. 

Free additional Dynamics MOSS clients for customers who currently own Microsoft Office Sharepoint Server.

For more information or to place your order for free additional BP users or MOSS clients please call our office at 207.761.2133.

Share/Save/Bookmark