Topic: ‘Dynamics GP’

Learn to leverage your Dynamics GP with Excel Report Builder.  In this webinar we will explore how to create a basic excel report in Excel Report Builder, set a report to use pivot table functionality and create a report based on a SQL view.  Join us as we show you just one more way Dynamics GP and Microsoft Excel can work together.

Title: Excel Report Builder for Microsoft Dynamics® GP

Speaker: Robert Sawyer, I.B.I.S. Consultant

While setting up an integration for a client, it became apparent that there is a problem with the MSGP Publisher that will only allow you to publish messages to the scribepublisherqueue for specific tables. After adding a table to the publisher and choosing options, I tried to save the publisher and it threw the error “Error when setting up GP Publisher: Sequence contains more than one matching element”. I never did figure out what that meant. After doing my diligence and checking the knowledgebase and forums on Open Mind to no avail, Scribe support was contacted for some assistance. They informed me that there is a known issue with many tables not being accounted for by the publisher and that it is a defect and there is no fix at this time. This left me with no resolution or workaround (thanks Scribe!) While Scribe gave us what they considered an acceptable answer to the problem, it didn’t solve anything for our client’s integration which left us to figure out one on our own. Here is what I came up with: Read the rest of this entry »

Thought I’d share this 2 minute 36 second video from Microsoft with you today on shortcuts in the everyday Microsoft applications you use, Outlook, Excel etc… Watch the video clip first, then right click in different areas of Dynamics GP to see the shortcuts available to you.

But watch the video first. MICROSOFT RIGHT CLICK VIDEO

And….Happy Right-Clicking!!!!

it happens from time to time…you receive items and match receipts and invoice to the wrong Purchase Order in Dynamics GP.   Then only to discover that mistake right after you have posted the Receipts, Invoices, everything, Ops!  If you have ever done this you are not alone. Read the rest of this entry »

Curious about the Year-End close process.  Well, look no further.  Microsoft has a very well done video… follow the below link.

http://www.microsoft.com/en-us/showcase/details.aspx?uuid=91697dc7-4926-4144-8626-ca0eb8e284da

A recent CFO.com headline asked us to Imagine there is No Excel. The article goes on to discuss how companies are dealing with analytics and the rise of big data.The beauty of Excel is not just it’s power and ease of use but it’s ubiquity. You can’t throw a rock in a Finance or Accounting department without hitting an Excel spreadsheet so it’s not going to go quietly into the night.

The CFO.com article touches on analysis products for big companies (Hyperion, Cognos) and for startups (QuickBooks users) but curiously leave out mid-sized companies.

I’ve been spending time lately with deFacto Performance Management and frankly, it does a great job of tackling many of the items discussed in the article for mid-sized firms. Read the rest of this entry »

Learn how to improve your cash flow while monitoring customers credit limits, send out invoices, statements and letters via e-mail and much, much more.  Join us as we explore the advantages of using Collections Management for Dynamics GP.

Title: Collections Management in Microsoft Dynamics® GP

Speaker: Matt Trotzuk, I.B.I.S. Consultant

It’s a new year and what better way to start it off by attending our Dynamics GP Free Webinar Series.

Check it out!

http://www.dynamicscare.com/gpwebinars

As we have said before the Year End close process is a bit  different from the Month End close.  There are routines that will need to be run on each sub-module before you close out  the General Ledger module.  Microsoft posted a really informative site on the subject.  See below link.

http://blogs.msdn.com/b/dynamicsgp/default.aspx?wa=wsignin1.0

But before you begin closing Dynamics GP here is what I call  the “First Important Step”

Read the rest of this entry »

Join us to learn about the flexibility provided by Accountable Software. Forms Printer allows you to customize the documents that come out of GP and the delivery method in which you send them.

Title: ISV Spotlight: Accountable Software - Forms Printer

Speakers: Lisa Frank, Accountable Software