This is all about how I use GP, based on what I learned in my investigations with clients...

Microsoft Dynamics GP (local) user Group meeting (GPUG) June 2013

Posted by Belinda Allen on May 21, 2013 10:09:00 AM

Microsoft Dynamics (GP User Group) GPUG New York/New Jersey Regional Chapter Meeting (Jun 2013)

Join us for the next New York/New Jersey Regional Chapter meeting on June 12 from 9:00am to 12:30pm!
We want to make sure you're taking advantage of everything you can to help you use your Dynamics GP application better. Not a GPUG Member? Join us to see what all the excitement is about.


Register Here


Meeting date and time: Wednesday, June 12, 2013 from 9:00am to 12:30pm EST. (Please note that event registration defaults to EST. Please adjust your calendars accordingly.)


  • 9:00 - 9:15: Welcome & Introductions
  • 9:15 - 9:30: GPUG Collaborate
  • 9:30 - 10:30: 10 GP 2013 cool new features worth upgrading for (Anne-Claire McAlister, Accountnet)
  • 10:30 - 10:45: Break & Networking
  • 10:45 - 11:30: Intro to BI and GP (Belinda Allen, Smith & Allen Consulting, Inc.)
  • 11:30 - 12:15: Regional Chapter Leadership: Why, How, Who
  • 12:15 - 12:30: Wrap-up and discussion of desired Quarter 3 meeting topics

Audience: All Dynamics GP users and prospects are welcome and encouraged to attend. Members of the GPUG Partner Program are also welcome to attend provided they are accompanied by a customer. Partners please bear in mind that the objective of Regional Chapters is to exchange knowledge and Dynamics GP experience. Partner personnel should possess deep GP expertise and refrain from sales activities.

About Regional Chapters: Regional Chapters enhance your membership in GPUG by offering face-to-face interaction and knowledge-sharing with other Microsoft Dynamics GP users in your region. By having meetings centrally located within your region, users from all job roles and levels in your company can participate by only driving a short distance. Join us so you can optimize the functionality, flexibility, performance and return on investment offered by GP and get better results from your GP implementation back home. Feel free to invite GP colleagues and other users within the region. Remember, a membership in GPUG includes ALL employees at your company. For more information about GPUG, visit

Don't miss being a part of this exciting meeting established solely for the purpose of face-to-face networking and knowledge sharing of GP Users in our area!

Belinda presents at the June 2013 local Microsoft Dynamics GP User Group Meeting.

Location Details

Microsoft Office

1290 Avenue of the Americas  6th floor

New York, NY 10104

Registration Costs

Basic Membership Cost: $20.00
Premium Membership Cost: FREE

Tags: GPUG

Microsoft Dynamics GP User Group (GPUG) Tech Tips Exert

Posted by Belinda Allen on Jan 22, 2013 10:20:00 AM

Microsoft Dynamics GP User Group (GPUG) Tech Tip from Belinda, the GP CSI Allen

Below is an exert from a future "Tech Tips" that I wrote for the Microsoft Dynamics GP User Group (GPUG) to send to it's members.  If you are not a member, you should review membership. 

What are Excel Data Limitations?

Which version of Excel should you use?

You’ll want to be on Excel Version 2007 or 2010. Why? Column and row capacities in older versions cannot accommodate some of the files. Below is a table that shows size limitations of various versions of Excel. You’ll see that Excel 2007 and Excel 2010 have much larger row and column maximums than the older versions.

You should always work with supported versions of software; this includes both GP AND Excel.


 Max. Rows

Max. Columns

Max Columns by letter

Excel 2010




Excel 2007




Excel 2003




Excel 2002 (XP)




Excel 2000




Excel 97




Excel 95




Excel 5





Over a million records sounds like a lot, but it still might not be able to handle your needs, so you’ll need to address your Excel needs differently. Let’s review some options:

What is the difference between an Excel Table and an Excel Worksheet

Think of a table as being an “Excel Database.” In an Excel worksheet, you can put a single record on many lines if you like (like the following).

 Example of Microsoft Excel Worksheet.  See how you can use Excel as your Microsoft Dynamics GP report writer.

A table will be setup so each row is one complete record and each record is only on 1 row (like the following.)

 Microsoft Excel Table, see how to use Excel as your Microsoft Dynamics GP report writer.

Both of the above examples provide the same information, but by placing the data in a table rather than a worksheet:

  • Excel will apply default formatting to any new data added.
  • Excel will automatically apply the Filter setting. The headings for filters will remain when you scroll down.
  • You can easily add totals to the bottom with the check box in the Table Tools Design tab.  Using the Microsoft Excel Table Tools tab on the ribbon for writing reports for Microsoft Dynamics GP.
  • If you create a formula in a column, new data rows will have the formulas automatically copied to the new record. (This is a powerful feature if you use a calculated column in a Pivot Table.) This also means Pivot Tables will automatically capture the new data as well.

Understanding and using Tables is an important and necessary element to Excel Reporting.

Tags: Miscellaneous, GPUG, Excel

Microsoft Dynamics GP - GPUG NY / NJ meeting

Posted by Belinda Allen on Nov 21, 2012 1:45:00 PM

Come see me in person discuss SmarList Builder and Excel Builder at the (Microsoft Dynamics GP) GPUG regional meeting Tuesday, 11/27/12 at the Microsoft Office in Manhattan, New York.

GPUG NY NJ Meeting with Belinda, the Microsoft Dynamics GP CSI.

Please join us for the next meeting of the GPUG NY/NJ Regional Chapter on

Tuesday, November 27, 2012 from 8:30am - 12:00pm EST. We're planning a great

meeting at the Microsoft office in Manhattan. Don't miss this exciting opportunity

for face-to-face networking with your peers and fellow GP users in your area.

To register for the event, click here.




Meeting Agenda:                                                                                                                    

8:30 - 9:00am    

Welcome & Introductions 

9:00 - 10:00am    

SmartList Builder

10:00 - 10:20am    

Break & Networking

10:20 - 10:40am     

SmartList Builder - Customer Examples

10:40 - 11:45am

Excel Builder & Navigation Builder

11:45 - 12:00pm

Planning of Next Meeting

Meeting Location: 
Microsoft Office
1290 Avenue of the Americas - 6th Floor
Room: Belasco  
New York, NY 10104

Registration Costs: 
Basic Members: $20.00
Premium Members: FREE

Tags: GPUG, SmartList, Excel, Event