DynamicAccounting.net

More Microsoft Dynamics GP 10.0 Service Pack 5 releases

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 11:00:01 PDT

Amy Walsh beat David Musgrave to the punch with her coverage of additional GP 10 SP5 releases but David has full coverage in his post More Microsoft Dynamics GP 10.0 Service Pack 5 releases.

Recorded I.B.I.S. Webinars are now available

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 10:00:05 PDT

Many of the great I.B.I.S. webinar recordings for Dynamics GP are now available. We do these bi-weekly so make sure to catch some live too. Here is one with David Humphreys covering Inventory Returns – Dynamics GP Field Service to get you started.

Send Reports to Screen (Instead of Printer) in Dynamics GP

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 09:00:01 PDT

Tina expands on Mariano’s original post on sending all posting reports to screen with her post Send Reports to Screen (Instead of Printer) in Dynamics GP .

It’s a great post but I’m trying to track down where it originated (I found it on GP Window). Tina, if this didn’t originate on GP Window ping me so I can follow your posts.

Performance Benchmark Results for Microsoft Dynamics GP 2010

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 08:00:02 PDT

Inside Microsoft Dynamics GP has new Performance Benchmark Results for Microsoft Dynamics GP 2010. Can anyone say millions of transactions? It’s a good thing that we have PowerPivot to analyze all of these transactions with.

Microsoft Dynamics GP 10.0 Service Pack 5 Login Performance issue

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 07:00:06 PDT

David Musgrave and Mariano Gomez have coverage of a login performance issue related to Analytical Accounting and GP 10 SP 5.

David has coverage here: Microsoft Dynamics GP 10.0 Service Pack 5 Login Performance issue

and Mariano looks at the issue here: Service Pack 5 affects Microsoft Dynamics GP 10.0 logon performance

I’ve never been a big AA fan. Every time I think that it settles down something like this pops up.

Come to the GPUG Summit!

mpolino@gmail.com (Mark) — Wed, 08 Sep 2010 06:00:11 PDT

I’ve actually got a beagle not a pug but since GPUP has nothing to do with dogs and everything to do with Dynamics GP I’ll be at the GPUG Summit in Orlando, October 25-28. GPUG is the Great Plains User Group and the Summit is the place to learn more about Dynamics GP. This isn’t a fluffy conference. It’s nitty gritty deep in the application time.

I’ve got a brand new set of 50 Tips for Dynamics GP ready to be delivered in just 50 Minutes. Many of you remember how good the first 100 were, well these are 50 more things that I couldn’t stuff into the bag before. The tips are applicable from version 6 (you remember that right?) all way to Dynamics GP 2010.

The GPUG Summit is fun, accessible and inexpensive compared to the information you’ll walk out with.

Go, register now!

Fun facts:

This is not a pug or a GPUG. This is my beagle Gracie. She has almost a hundred twitter followers. Who knew!

A Dynamics GP Blast From The Past: Local Temp Tables

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 13:00:02 PDT

Somehow Steve Endow missed that some temp tables in Dynamics GP are c-tree files because they are faster than SQL temp tables. Well, he’s caught up now and in case you missed that too, here is Steve’s coverage: A Dynamics GP Blast From The Past: Local Temp Tables

Speed Certification Exams for Dynamics GP

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 12:00:02 PDT

Like many of us, Steve Endow is racing to finish certification exams. Four new GP 2010 exams were released mid August and we’re all racing to have them done before 10/1 when new certification requirements for partners goes into effect. Steve followed Christina’s advice and tried taking the actual exam quickly. My exams tend to work the same way. If I’m really prepared, they take about a 1/2 hour or so. I’ve four scheduled over the next two weeks to squeeze in around work, travel and presentations so I feel Steve’s pain.
Check out his experience in his post Dynamics GP Land: Speed Certification Exams!

What’s a Dictionary in Dynamics GP?

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 11:00:04 PDT

Belinda is back with a nice look at what a dictionary is in Dynamics GP along with some details on Reports dictionaries and dealing with corruption in her new post What’s up *.dic, Reports.dic that is.

How To Simplify FRx Catalogs

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 10:00:01 PDT

FRx Buzz continues their look at simplifying FRx with How To Simplify FRx Catalogs.

Throw out the calculator with Allocation Accounts in Dynamics GP

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 09:00:03 PDT

Chuck that calculator and let allocations accounts do the math for you is the theme of Belinda, the GP CSI’s new post Throw out the calculator

Sure Step Myths Debunked

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 08:00:03 PDT

Christina Phillips does a great job tackling Sure Step myths in her post Sure Step Myths Debunked.

GP Partner Connections Conference

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 07:00:05 PDT

If you’re a partner, it’s time to sign up for GP Partner Connections Conference. This event focuses specifically on topics squarely on partner’s radar. The event will be held in beautiful Orlando, FL on October 23-25, just before the GPUG Summit.
I’ll be at the Partner Connections Conference speaking on some Business Intelligence related topics and hashing through related issues with you in a workshop. I’ll also be speaking on the Support Debugging Tool.
At Convergence in April, users came out of sessions scolding their partners for not showing them the Support Debugging Tool. The partners had never seen it. Make sure you attend this session to see how you can leverage the Support Debugging Tool to better support your client.

Business Portal Webinar for Dynamics GP – TODAY!

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 06:15:00 PDT

Don’t miss Today’s I.B.I.S. webinar on Business Portal at 11am. Rob Mitchell has tons of experience in the nitty gritty of making Business Portal run. This will be a great session so register and pop on your headphones while digging out your desk from the long weekend. Register now at Business Portal Webinar .

Weekly Dynamic: Speed Date Entry with only the Day

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 06:00:06 PDT

Todd McDaniel reminded me of a little tip recently. In any date field in Dynamics GP, simply enter the day and tab off. the system will fill in with the month and year from the current system date in Dynamics GP. This is one of those tips that is so simple that it's easy to forget that it's there.

Enter This:

GP Creates This:

Five Years of Covering Dynamics GP

mpolino@gmail.com (Mark) — Tue, 07 Sep 2010 05:30:00 PDT

Over the weekend DynamicAccounting.net hit it’s five year anniversary covering Microsoft Dynamics GP.

All I can say is thank you to everyone who has read, contributed and put to use the tips listed here as we try to push Dynamics GP to the limit together.

Happy Labor Day!

mpolino@gmail.com (Mark) — Mon, 06 Sep 2010 06:00:01 PDT

I’m taking Labor Day off. Posting will resume tomorrow with a new Weekly Dynamic tip.

Microsoft Dynamics GP 2010 RTM "CoreMR" VPC is NOW AVAILABLE!!

mpolino@gmail.com (Mark) — Fri, 03 Sep 2010 14:00:01 PDT

For partners a new VPC image for GP 2010 is now available. This includes Management Reporter and should make basic demoing and testing easier than trying to figure out how to run Hyper V on your laptop. Inside Microsoft Dynamics GP has the full announcement in their post Microsoft Dynamics GP 2010 RTM "CoreMR" VPC is NOW AVAILABLE!!

Dynamics GP Service Pack 5 for Advanced HR, Payroll, Integration Manager and PDK

mpolino@gmail.com (Mark) — Fri, 03 Sep 2010 13:00:00 PDT

Amy Walsh looks at new additions to Service Pack 5 beyond the core that are now available. Specifically:

Dynamics GP SDT Essential Series

mpolino@gmail.com (Mark) — Fri, 03 Sep 2010 12:00:05 PDT

Jivtesh gets in on Support Debugging Tool week with a look at changing the colors of company backgrounds in his Dynamics GP SDT Essential Series post.

Using the Support Debugging Tool to automatically start logging

mpolino@gmail.com (Mark) — Fri, 03 Sep 2010 11:07:57 PDT

When I formalized Mariano’s declaring this Support Debugging Tool week I didn’t realize what power I had. It’s actually become Support Debugging Tool week. In support of that, David Musgrave has a new post up on Using the Support Debugging Tool to automatically start logging - Developing for Dynamics GP.

I’m trying to figure out how to use my newfound powers for good. Maybe next I should declare, “Free ice cream for everyone week”. Hmm… I’ll have to think about this.

SQL view for Payables invoices originating from POP in Dynamics GP

mpolino@gmail.com (Mark) — Thu, 02 Sep 2010 07:00:05 PDT

Victoria Yudin has a new SQL view for Payables invoices originating from POP in Dynamics GP up on her website

Weekly Review: Excel Reports

mpolino@gmail.com (Mark) — Thu, 02 Sep 2010 06:00:06 PDT

The new Excel reports in Dynamics GP are really pretty cool and you don't need MOSS 2007 to play with them. You can use a network share to let your organization do a little Excel reporting.

To setup the default reports you need to do 2 things, deploy the connector and deploy the reports. Here's how:
In GP 10 pick Microsoft Dynamics GP-Tools-Setup-System-Reporting Tools Setup. Enter the system password if required.
Pick the Data Connections Tab

In the System Level Data connections box enter a shared network location to deploy the connectors to.
Do the same thing for the User Level Data connections. This can be a local directory.

Check Enable Data Connection Deployment. Check Deploy Data Connections for all existing companies if you want to run Excel reports off all your companies. Otherwise, when you deploy, you'll have to pick a company.

Click Run Deployment

Print or Cancel any reports and move to the Reports Library Tab.

Fill out the same type of information, Network location to deploy shared reports, local location for user reports, check the enable box and if you want to deploy for all companies, check the Deploy box.

Click the Run Deployment button. Print or cancel any reports.

You're done, now what?

You can navigate to the shared location from the Reports Library Tab and open one of the Excel reports. Even better from within Dynamics GP, go to the Navigation Pane on the lower left and pick Administration or the Administration tab. Click on Other Reports and wait for them to load.

Pick a report and double click it. The report opens nicely (and quickly in Excel). You may need to enable data connections. If a box pops up, enable data connections and go on.

In Excel 2007 the report shades every other row and provides filter handles on each column.

That's enough to let you play with it a little. I'll have more on GP 10's Excel reports and the cool things you can do with the connectors later.

Originally Posted by Mark at 3/25/2008 08:43:00 PM

Blog Background Change – Teal to fight Ovarian Cancer

mpolino@gmail.com (Mark) — Wed, 01 Sep 2010 17:29:14 PDT

I’m changing the blog background early this week. The background is going teal in support of my sister in law who is fighting ovarian cancer. Friday, September 3 is National Tea Time in support of the fight against ovarian cancer so the blog will be wearing teal for the next 10 days or so. To find out more about my sister in law Melissa and her fight, visit her Facebook page.

August Newsletter

mpolino@gmail.com (Mark) — Wed, 01 Sep 2010 10:00:04 PDT

The August DynamicAccounting.net newsletter went out last week. If you missed it you can see it, follow the link to catch it on the web. If you didn’t get yours, check your spam filter or sign up on the main page at DynamicAccounting.net.