Feature Pack 1 for Microsoft Dynamics GP 10 added Cost Allocations to the Project Accounting module. I covered the basics in Part 1 so go there for the overview. I was a little stumped by the way unit based allocations worked so this post should provide at least the basics to get started with allocating project costs based on units.

We came across 2 bugs in The Budget Wizard for Excel function recently. Partnersource was being very unreliable so we finally had to give up and ask for help. This issue does occur even with SP2 in GP 10.

If you create an Excel budge file using the wizard and then try to import it back in an error message occurs indicating that the number of columns in the sheet doesn't match the…

The new Excel reports in Dynamics GP 10 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…

I've gotten questions from people over the years about long account numbers/lots of segments, so I thought I would put together a short list of the pitfalls of very large account numbers.

The longest GL account number I've worked with in GP is 27 digits, 8 segments. This is different from the account framework which may be large to accomodate changes but most companies have a much smaller…

One of the newer GP features is Auto Complete. Like many other MS apps, when you start to type, you get a suggestion of possible words to fill in without having to type the whole word. But what if you mistype a word, is it there forever? Are you stuck with the word…

I got the word from the publisher today, the Microsoft Dynamics GP Cookbook is now available!

You can get it from Amazon:

or directly from Packt Publishing at:

https://www.packtpub.com/microsoft-dynamics-gp-2010-cookbook/book

Barnes and Noble…

This didn't get properly credited originally. It came from http://xkcd.com/844/

Over the last day or so I’ve had a number of conversations with folks about people missing from the 100 Most Influential in Microsoft Dynamics list.
Some of the more prominent names that I think should be on the list are:

• David Musgrave – He a prolific Dynamics GP blogger, he answers questions in the forums, he wrote the incredible Support Debugging Tool, provides support for it and he’s a highly rated speaker at events like Convergence. Plus the GP…