GSL Blog

Back to Blog Homepage »

Posts Tagged ‘Dynamics GP 2010’

« Older Entries

U.S. 2012 Tax Tables have Released

Friday, December 23rd, 2011

Microsoft has released the 2012 U.S. Payroll Tax Update for Microsoft Dynamics GP 2010 and 10.0.* If you’ve been following the news, the extension on the payroll tax cut is still up in the air. The IRS has advised Microsoft to revert back to what is on the Notice 1036, which is 6.2% withholding and a $110,100 limit on Social Security. The IRS is not optimistic this will be decided before the end of the year, and it is better to over-withhold than under-withhold. If it changes back to 4.2%, Microsoft will re-release the tax update, and Gilchrist Scott will re-post instructions on how to correct any over-withholdings.

Since the 2012 tax tables include the change from 4.2% to 6.2%, it is important to install this update AFTER creating the year-end wage file for the 2011 year.

The tax update also contains changes for the following states:
California
District of Columbia
Hawaii
Kentucky
Maine
Maryland
Massachusetts
Minnesota
New Mexico
North Dakota
Oregon
Rhode Island
Vermont

Contact us with any questions regarding your year-end process. (207) 761-2133 or support@gilchristscott.com.

*Support for version 10 ends October, 2012.

Share/Save/Bookmark

Tags: , , , , ,
Posted in Dynamics GP, Specific GP Modules, Support |

Let the Countdown Begin: Convergence 2012 Houston

Monday, October 31st, 2011

Save the Date

The Microsoft Dynamics® Convergence® 2011 conference was a smashing success, and now is the time to look toward a new frontier. Start planning now to join us next year for Convergence 2012.

March 18 to 21, 2012
George R. Brown Convention Center
Houston, Texas

 

Convergence is the best opportunity for you to get a firsthand look at the latest innovations that will help you optimize your business and improve your bottom line.

A World of Reasons to Attend

Convergence 2012 is “A World of Opportunity.” It will be an experience rich with business value where you’ll learn, share, and establish new relationships. Since this Convergence is actively targeting a global audience, the opportunity for you to make new and valuable connections is greater than ever before.

 

We Hope to See You There

Contact us if you have any questions about Convergence 2012. We look forward to seeing you in Houston next March!  

Share/Save/Bookmark

Tags: , , , , ,
Posted in Convergence, GP User Group, Microsoft |

US Payroll Year End Update

Monday, October 17th, 2011

Mark your calendar - the US Payroll Year-end Update for Dynamics GP is scheduled to release November 17th. This update will be required for all U.S. customers to install.

Changes include:

  • W2 and W3
  • EFW2  (magentic media)
  • 1099 R  for pension payroll
  • 1099 payables Dividend
  • Fixed assets luxury depreciation
  • FICA Social Security

There are also changes to the SQL tables included in this update, to add the new EmployerKind data in the Dynamics and Company databases, in the following tables:

  • W2000006
  • UPR40100
  • UPR10100

There will also be several Bug Fixes for other modules, including Inventory, Manufacturing, Project Accounting, Sales, Field Service, eConnect and Extender.

As a reminder, the release schedule is tentatively scheduled as follows:

  • US Payroll 2011 Year End update will release mid-November 2011.
  • Canadian Payroll Year End Update will release mid-December 2011.
  • US Payroll 2012 Tax Round 1 will release mid-December 2011.
  • US Payroll 2012 Tax Round 2 will release in January 2012.

These updates are only available for supportedversions: Microsoft Dynamics GP 10 and GP 2010.  Click HERE for information on our 4th Quarter Upgrade Special.

Contact us to schedule assistance with these payroll updates, or to discuss an upgrade.

Share/Save/Bookmark

Tags: , , , , , , ,
Posted in Dynamics GP, Support, Technology |

Year-end Payroll Tax Updates

Monday, October 10th, 2011

Year-end is approaching quickly. If you are processing payroll using Dynamics GP, be ready for the following tentative schedule from Microsoft:

  • US Payroll 2011 Year End update will release mid-November 2011.
  • Canadian Payroll Year End Update will release mid-December 2011
  • US Payroll 2012 Tax Round 1 will release mid-Decmeber 2011
  • US Payroll 2012 Tax Round 2 wlil release in January 2012

Remember, supported versions include Microsoft Dynamics GP 10 and GP 2010 (version 11).  If you are currently using version 9.0, please contact us for an upgrade estimate.

 

Share/Save/Bookmark

Tags: , , , , , , ,
Posted in Dynamics GP, Microsoft, Specific GP Modules |

Dynamics GP 2010 Seminar

Thursday, September 15th, 2011

Looking for people and process improvements? Learn how to maximize your Dynamics GP investment: FREE Dynamics GP 2010 Seminar

dynamics-gp-2010-logo3

Dynamics GP 2010 Seminar

With the release of Microsoft Dynamics GP 2010 comes even more seamless integration to Office, reporting options, key performance indicators, shortcuts and reminders, and a new Management Reporting tool.

Gilchrist Scott is hosting a FREE seminar to offer insight to these productivity enhancements. Don’t miss out - seating is limited!

What: Microsoft Dynamics GP 2010 Seminar
When: Tuesday, October 18th, 9-11 a.m.
Where: Gilchrist Scott, 30 Milk Street, Portland, ME (Map)
Cost: FREE
RSVP: aberglund@gilchristscott.com or 207.761.2133 ext. 203

Gilchrist Scott is committed to helping you maximize your investment in GP. Please let us know if you have any questions in regard to the seminar. We look forward to hearing from you!

 

 

Share/Save/Bookmark

Tags: , , , ,
Posted in Best Practices, Dynamics GP, GP User Group, Training |

SQL Server Power Pivot for Excel

Tuesday, August 30th, 2011

Power Pivot is an add-in to Microsoft Excel 2010 and is intended as a self-service Business Intelligence tool that allows power users to create their own models from just about any data source including Microsoft Dynamics GP.  Best of all, this add-in is free of charge and can be downloaded here.  Once installed, you will have a ribbon tab in Excel called ‘Power Pivot’

PivotTable Ribbon

To add data, simply click on the ‘PowerPivot Window’ button.  You can then import data from many different sources including SQL Server, RSS and flat text file among others.  Once you have the data imported that you want to use, simply click on the ‘PivotTable’ button and choose how you would like to view the data

PivotTable

You can then slice and dice the data any way that you like.  Here we display 2 charts, 1 for sales by salesperson and the other for sales by customer from GP.  This literally took 3 minutes to create.

 

PivotTable Charts

A few of the amazing things that PowerPivot allows you to do are:

1.       PowerPivot is not limited to 1 million rows as Excel is.  There is actually no limit on the amount of rows.  PowerPivot is able to work with very large sets of data because it stores the data in memory

2.       PowerPivot allows you to define relationships.  In Excel, if you need to join data from two separate sheets it requires you to use the VLOOKUP function.  PowerPivot uses relationships on columns and most of the time automatically recognizes such relationships

3.       DAX Function language – Not only are the 80 Excel functions included in this language, but over 60 new functions are defined, including a function that accommodates fiscal years.

4.       Easily create Pivot Tables and Charts using the PowerPivot field list.

 

PowerPivot is a powerful tool for the Excel Data Analyst taking pressure off the IT department to create reports.

 

 

 

Share/Save/Bookmark

Tags: , , , , , ,
Posted in Dynamics GP, FRx / Reporting, Technology, Tips 'n Tricks |

Saving Keystrokes in GP

Monday, August 22nd, 2011

Would you like to save keystrokes?  Mouse less?  Here are a couple of shortcuts you can use in Dynamics GP.  Some of them you may remember from one of my earlier blog posts.

 

Sales Order Processing Quick Print

When printing an invoice in Sales Order Processing, the typical key strokes are:

 

1)    Click printer icon

2)    Select which documents to include

3)    Click Print

4)    Select printer or screen

5)    Select number of copies

6)    Click ‘OK’

 

With Quick Print the key strokes are:

1)    Click ‘CNTRL’ and ‘Q’ buttons on your keyboard simultaneously and watch the clicks happen automatically!

 

How to setup Quick Print:

·         Open the Sales Transaction Entry window – Transactions>Sales>Sales Transaction Entry

·         Click on ‘Options’ from menu

·         Select ‘Quick Print Setup’

·         Mark options as applicable

·         Click ‘Save’

 

Quick Links

Quick Links are found on your home page in GP.  A quick link allows a user to access a window/web site/external program with one click rather than using the drop down menus.

 

How to setup a GP Window Quick Link:

·         Go to Home Page

·         Click on ‘Change Details’ in the Quick Links area

·         Click on ‘Add’ button

·         Select ‘Microsoft Dynamics GP Window’

·         Navigate through Menu group and Categories/commands to select the Quick Link destination

·         Click ‘Ok’

·         Click ‘OK’

·         Refresh Home page to see new Quick Link in your Quick Links list

 

Shortcuts

Shortcuts are similar to Quick Links, but they reside in the Navigation Pane in GP.  The functionality is the same as a Quick Link.  Once click on the shortcut and you arrive at your desired location!

 

How to setup a Shortcut

·         Click on ‘File’ in the window you would like to create a short cut for

·         Select ‘Add to Shortcuts’

·         Short cut will now show in your Navigation Pane

 

To remove a short cut simply right click on the shortcut and select ‘delete’ from the list.

Share/Save/Bookmark

Tags: , , ,
Posted in Best Practices, Dynamics GP, Tips 'n Tricks |

GP 2010 R2: Email and Word Templates

Monday, August 8th, 2011

We still love the Word Templates in GP 2010. The main issue, however, was that not all reports were available as a template.  Users spoke, and the developers listened!  With GP 2010 R2, a new tool called the MS Word Template Generator is available.  Any report available in Report Writer can now be processed through the Word Template Generator.  Here are the basic steps:

1) Report Writer generates a data file (an XML file)

2) The Word Template Generator creates a template based on the data file

3) The template is imported into GP and can be edited as necessary (there’s an add-in for WORD that allows you to view and select GP fields).

4) When you print the report, choose Template instead of Standard

 

A few of the benefits of Word Templates:

1) Users are able to re-format templates in a familiar environment (Word)

2) Templates can be assigned to specific customers

3) No more multiple reports dictionaries for multiple companies!  Reports can be assigned to specific companies.

 

GP2010 R2 has new email capabilities, as well.  Any report window that has a Print button now also has an Email button. Users can generate a custom message, add data fields from the transaction window, and send!  The report is static, in an HTM format, and can be viewed using a web browser by GP users and non-users.

Thinking about moving ahead to GP2010 R2?   Gilchrist Scott is offering discounted rates for upgrades scheduled in August. Contact us soon to talk about upgrading. (207) 761-2133.

Share/Save/Bookmark

Tags: , , , , , ,
Posted in Dynamics GP, Microsoft, Specific GP Modules, Tips 'n Tricks |

« Older Entries