Topic: ‘Dynamics GP’

DynamicsCare: Expert Dynamics GP Advice & Tips Webinar Series. 

Click Here to Sign Up

GP Fixed Assets – I.B.I.S. Analysis Cube for Excel
Date: 3/2/2010 11:00-12:00 EST
Speaker: Amy Walsh, I.B.I.S. Senior Consultant and David Duncan, I.B.I.S. Consultant
I.B.I.S. has developed a custom Excel Analysis Cube around Dynamics GP Fixed Assets. This webinar will demonstrate utilizing the Cube to better report on Fixed Assets data in Dynamics GP.

Dynamics GP 2010 Receivables Management Cash Receipts Batch Entry window will allow reoccuring batches for cash reciepts.   This functionality is designed to speed data entry for those cash receipts that are  similiar payments from your customers.

Compared below Dynamics GP 10 to Dynamics GP 2010

Dynamics GP 10

Dynamics GP 2010

Major make-over for the Payables Management “Select Payables Checks”  Build Batch Window….

Allowing users to select multiple ranges.  See for yourself.

Read the rest of this entry »

More New features in Dynamics GP 2010.  Receivables Management allows you to enter “Negative Cash Receipts.” 

This could be useful for those who encounter the need to process Customer Charge Backs.

In the example below open the Cash Receipts window (Transactions>>Sales>>Cash Receipts).  Select the customer information and when you arrive at the amount field type in negative the amount. 

On the apply window below circled is the orginal invoice before any amount is applied.

On the apply window below circled is the orginal invoice after the amount is applied.  You will see the “Amount Remaining” field increase.

Continuing on the Dynamics GP 2010 adventure the home page has a few new items but this one really stood out.  It is called Connect.  This area of the homepage scrolls through a series of 8 updated windows linked to Dynamics GP and Accounting related information.   As the next window is highlighted in  a 5 second interval titles from RSS feeds, blogs, websites, training and community forums appear allowing convenient access to users.   Access to the Connect page is Free.  Click here to view the Dynamics GP Connect Page and learn more.

Connect

This area displays a series of slides that allow you to perform self-help support, get information, and perform training from the home page. Connect is available to all users on the home page and is specific to each user’s home page role. CustomerSource access is based on your Business Ready Enhancement Plan. To enable Connect, use the Customize Home Page window.  If you are using Internet Explorer Enhanced Security Configuration, be sure to add the Microsoft Dynamics Online Connect Web site as a trusted site.

Every 5 second the Connect page scrolls…

Every 5 second the Connect page scrolls…

A few months ago there was this discussion revolving around  Dynamics GP EFT (Electronic Funds Transfer).  The conculsion of this discussion identified a need…a need to create a custom EFT template for Receivables, which unfortunatly is not available in Dynamics GP 10.   Well, readers here it is…but it’s in Dynamics GP 2010. 

(Finance>>Cards>>EFT File Format)

With all of the excitement and buzz surrounding Dynamics GP 2010, I too, finally got a copy.  It feels a little like Christmas.  Dynamics GP 2010 has some really…can I say, “Cool” new and revamped features.  However, there is one functionality that I would like to address and that would be the log in windows.  Not that it is not “Cool” but it may be a little food for thought for those entities that have to be SOX compliant for system security audits or have a less liberal security policy. 

Read the rest of this entry »

By Rob Mitchell

Microsoft Dynamics GP offers a way to incorporate service packs into the Dynamics GP 10 client installation package. To do this:

1) Navigate out to your client installation package and find the Updates folder. This is the client install package that can be created during initial install to simply future client setup

2) Delete any msp file in the Updates folder and copy the latest service pack in.

3) The next time you install the client it will include the service pack.  It’s that easy!!

Note that the service pack needs to have been applied to the server before adding clients with the same service pack level.

Mark Polino came up with a handy Excel spreadsheet for referencing SQL tables in Dynamics GP 10.  To download your own copy click tables in Dynamics GP 10. 

Thank You!  Mark for providing this spreadsheet.  I have already used it several times.

Being from an accounting background and after years of mannually reconciling AP/ AR in an Excel spreadsheet Microsoft finally developed the “Reconcile to GL” function in Dynamics GP.  Introduced in version 10,  automatic reconciliation capability has long been an idea of novelty for most accountants.  Wouldn’t you agree?  Now, it has arrived.    Read the rest of this entry »