Collins Dynamics GP Blog: Management Reporter Tip

Over on the Collins Dynamics GP Blog, they've got a Management Reporter Tip around  the Missing Account Analysis Tool.

Feature of the Day: Track Serial and Lot Numbers on Drop Ship PO - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

In a new Feature of the Day: Microsoft shows Tracking Serial and Lot Numbers on Drop Ship PO

GPUG - Microsoft Dynamics GP User Group - Jacksonville 8/22/12

August 22nd is my birthday and I'm going to spend it in Jacksonville with the GPUG - Northern Florida Users Group. I have the priviledge of doing a 50 Tips in 50 Minutes presentation there so if you are anywhere in Northeast Florida or Southeash Georgia come by and spend some time with us.

Dynamic Future - Vote - Better Control of SmartList Visibility

This feature is my suggestion and it should be easy to implement. I want the ability to control the default visibility of a new SmartList Favorite. Today it defaults to System (all companies, all users). I want the ability to default that to "User" to help reduce SmartList sprawl. I've been recommending the use of "User" for a while now. Especially after a number of companies have asked if it's possible to just delete all the Favorites and start over.

If you want better control of the default SmartList Favorite visibility vote now.

Mohammad R. Daoud: Dynamics GP Excel Paste Updates

I love what Mohammad Daoud is doing with GP Excel Paste and now he has some GP Excel Paste Updates to show off.

I showed just the GL piece to someone the other day and they agreed that it's as cool as I think it is so check it out.

The eOne Dynamics GP and CRM Blog: Tech Tuesday - GP File Destination

eOne looks at why you would use a GP File Destination in SmartConnect.

Feature of the Day: Inactive Items - Inside Microsoft Dynamics GP

In a new Feature of the Day, Pam Misialek explains that all inventory item types can now be Inactive Items  with the upcoming release of GP 2013.

Report Wizard in Management Reporter - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Dynamics Corporate Performance Management explains how to use the Report Wizard in Management Reporter

Collections Management in Dynamics GP | Boyer & Associates

Jack Boyer shows off Collections Management in Dynamics GP 

Feature of the Day: Ship To Address Changes - Inside Microsoft Dynamics GP

Coming this year with the release of GP 2013 are some great Ship To Address Changes

Weekly Dynamic: Purchase Price Variance Information

Last week we talked about Inventory Purchase Price Variance and a Dex.ini switch that can make it easier to trace these transactions. But there are lots of people with questions about PPV and there is still plenty of confusion about how it works. For this week's Weekly Dynamic I'm going to point you to a Microsoft Support article that will tell you more than you ever wanted to know about how PPV works in Dynamics GP including details on the REVALJEINDETAIL=TRUE   Dex.ini switch.
.

Friday Fun: The Four Immutable Laws of Accounting

CPA Trendlines:

The Four Immutable Laws of Accounting:

1. Trial balances don’t.
2. Bank reconciliations never do.
3. Working Capital doesn’t.
4. Return on Investments never will.

Migration: Review FRx to Prepare for Upgrading to Management Reporter | FRxBuzz

Jan Harrigan tackles the upcoming Migration: Review FRx to Prepare for Upgrading to Management Reporter

Feature of the Day: 3 New Year End Close Features - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

The Dynamics GP team is showing off  3 New Year End Close Features coming in GP 2013.

Dynamics GP Land: Dynamics GP Window Opens Automatically When GP Is Launched

Steve Endow investigates what causes a Dynamics GP Window to Opens Automatically When GP Is Launched

Weekly Review: SmartList Sorting

When saving SmartList favorites, use a character like a tilde (~) or an asterisk (*) in front of the name to move that favorite toward the top. Prefixing the name with a “z” will move it to the bottom.

Strategies for Collections Management In Dynamics GP

Judy from Etelligent offers some Strategies for Collections Management In Dynamics GP

What does 'GS' or 'ME' stand for in an error related message within Microsoft Dynamics GP Payroll?

Terry Heley answer the questoin What does 'GS' or 'ME' stand for in an error related message within Microsoft Dynamics GP Payroll?

Management Reporter—An Unknown Error Has Occurred | FRxBuzz

Jan Harrigan tackles Management Reporter—An Unknown Error Has Occurred with some suggestions.

Feature of the Day: Tolerance Handling - Inside Microsoft Dynamics GP

Coming soon in GP 2013,  Tolerance Handling . Now the Microsoft folks already pretty tolerant. They must be to put up with me, but that's not what we mean. Tolerance handling allows closing a P.O. even if an item has been under or over received within certain tolerances. It's great for items like printing or fabric that are sold in runs. Hit the link for more.

Feature of the Day: User Defined Fields on Customer Address - Inside Microsoft Dynamics GP

In a new Feature of the Day for GP 2013, Inside Microsoft Dynamics GP looks at User Defined Fields on Customer Address

Error When Granting User Access to a New Company | Dynamics GP Insights

Matt Look tackles an Error When Granting User Access to a New Company | Dynamics GP Insights

How to Configure Microsoft SharePoint with Management Reporter 2012 - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Dynamics Corporate Performance Management shows How to Configure Microsoft SharePoint with Management Reporter 2012

CPM Shootout Today at 11am

Join us today for a Corporate Performance Management shootout with Management Reporter 2012 and deFacto. Find your FRx replacement here.

Dynamic Future - Vote - Roll Down Account Segment Description Changes to the Chart

Just to make sure that everyone is clear. You don't have to like these suggestions. If you don't like them, don't vote. However, If you do like a suggestion and you don't vote, you lose your right to complain about that issue.

The goal is to get you thinking, and voting, about what you want in Dynamics GP in the future.

This week's suggestion revolves around the chart of accounts. If you use segment descriptions and allow them to populate the chart descriptions you can get a really clean chart of accounts. But what happens if something changes? For example, you thought that a main segment description of "Receivables, Accounts" was a good idea until you realized that now no one can ever find the account by description. Users are disgruntled, the natives have pitchforks in their cubes. Today you have to go to each account and fix it or use SQL to clean things up. It would be pretty cool if you could change the segment description and have it roll down to the chart.

Andy Vabulas to MS: Pitch MPN Competencies to Partners

I.B.I.S. CEO Andy Vabulas is back in the news. He took advantage of an on stage opportunity at WPC to encourage Microsoft to better communicate the value and investment that partners make to achieve gold and silver certifications.

I couldn't agree more. Microsoft blew up their old certifications because it seemed that everyone was gold certified. It's important for folks to understand that this is no longer the case. It takes a lot of work to achieve certifications.

Dynamics GP Land: Management Reporter and Analytical Accounting

Christina Phillips examines some issues with Management Reporter and Analytical Accounting

Feature of the Day: Print and Picklist Shortage Inquiry - Inside Microsoft Dynamics GP

Continuing their look at upcoming GP 2013 features, Inside Microsoft Dynamics GP looks at  Print and Picklist Shortage Inquiry

Resizing SmartList TreeView and ListView panes using the Support Debugging Tool - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave shows off one of the new Support Debugging Tool features, Resizing SmartList TreeView and ListView panes

This is one of the more requested features for Dynamics GP.

SQL view for commissions details in Dynamics GP | Victoria Yudin

Victoria Yudin shows off a SQL view for commissions details in Dynamics GP

Weekly Dynamic: Tracing Purchase Price Variance

Purchase Pice Variances can occur when the purchase invoice cost is different from the cost recognized on the receipt (usually the same as the P.O.).

GP properly adjusts for these cost difference but they can be a real bear to trace. When you find the GL side of one of these transactions they don't link back to the source except with a reference. You have to go to SmartLists or the tables to figure out that they started in Inventory.

However, there is a Dex.ini switch that can make this easier. Adding:

REVALJEINDETAIL=TRUE  

to the Dex.ini file populates the ORCTRNUM, ORMSTRID, ORMSTRNM and ORDOCNUM fields in the GL10001 (GL Transaction Amounts Work) and GL20000 (GL Year-to-Date Transaction Open) tables making it much easier to trace these transactions back in SmartLists.

There is also a set of downloadable reports that improve on the default posting reports. However, neither the default reports nor the downloadable reports can be reprinted so if you want that detail you'll have to print or save the posting reports.

More on this next week.

Friday Fun: Is this taking the cloud too far?

Feature of the Day: Bin History - Inside Microsoft Dynamics GP

Coming Soon in Microsoft Dynamics GP 2013:  Bin History

Alerts: 401 Setup

John Lowther shows off Alerts for 401k Setup.

Feature of the Day: EFT Format Enhancements

In a new Feature of the Day Microsoft shows off EFT Format Enhancements

Using SOP Document Types in GP 2010 | onza blog

Amanda Wong explains Using SOP Document Types in GP 2010

Weekly Review: PowerPivot and Multiple Cubes

Last week we looked at PowerPivot for analyzing Dynamics GP data. This week someone asked if you can connect to multiple cubes with PowerPivot. Yes you can. For testing I connected to the GP Financial Cube and Sales Cube and then was able to join them in PowerPivot. These cubes were both on the same server but given the way that PowerPivot connects that there is no reason that you couldn’t join cubes across servers assuming that the you have the right access.

Adding Window Size and Position Memory using the Support Debugging Tool - Developing for Dynamics GP

David Musgrave adds to his SDT Non-Logging Triggers post with Adding Window Size and Position Memory using the Support Debugging Tool

Management Reporter Use a Hidden Setting to Sort Drilldowns by Account | FRxBuzz

Jan Harrigan demonstratesManagement Reporter Use a Hidden Setting to Sort Drilldowns by Account

National Accounts for Receivables in Dynamics GP

Sheldon digs into National Accounts for Receivables in Dynamics GP

Feature of the Day: Reason Codes - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

And so the build up to GP 2013 begins with a new Feature of the Day: Reason Codes.  Reason Codes provide a way to indicate why a particular Inventory transaction was done.

I have a confession to make. I've been playing with the preview of Windows 8 quite a bit lately. Windows 8 is going to be a great OS but I'm more excited about GP 2013 than about Windows 8.

Dynamic Business: Kicking It All the Way to Awesome

Check out the new Microsoft Dynamics video Dynamic Business: kicking it all the way to awesome.

Make sure to follow up with more at http://dynamicbusiness.microsoft.com.

Creating Custom Desktop Alerts in Dynamics GP | Aaron Berquist - High Dynamic Range

Aaron Berquist demonstrates Creating Custom Desktop Alerts in Dynamics GP  using VBA/VBA.net.

The Dynamics GP Blogster: Installing 64-bit Microsoft Access on a 64-bit environment running 32-bit Microsoft Office

Mariano looks at Installing 64-bit Microsoft Access on a 64-bit environment running 32-bit Microsoft Office No he's not trying to be an Access MVP, this can be an issue when working with Management Reporter.

Using Support Debugging Tool Non-Logging Triggers - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave continues his SDT series with a look at Using Support Debugging Tool Non-Logging Triggers

Account Maintenance Options: The Forgotten Fields | Dynamics GP Insights

Christina Phillips covers some of my favorite fields in Account Maintenance Options: The Forgotten Fields

Dynamic Future - Vote - Multiple Company Support in a Single GP Database

This week's GP suggestion is a big one...Adding Multiple Company Support to a Single GP Database. This request seems to be coming up more often lately. There are third party solutions that can effectively accomplish this but they often change the way that Dynamics GP works. This suggestion is to add Multiple Company support natively in a single GP database.

Support Debugging Tool Build 16 Hotfix released - Developing for Dynamics GP - Site Home - MSDN Blogs

From David Musgrave, the Support Debugging Tool Build 16 Hotfix has been released

Advanced Lookups Feature in SmartList

Nicole Albertson shows off Advanced Lookups Feature in SmartList

GP2themax - Helping users get the 'max' from Dynamics GP: The 'Microsoft.ACE.OLDB.12.0' provider is not registered on the local machine

Frank Hamelly delivers 2 possible solutions for  The 'Microsoft.ACE.OLDB.12.0' provider is not registered on the local machine

Microsoft Dynamics GP and Schrödinger’s Cat | azurecurve

Ian Grieve goes all Big Bang Theory with a look at Microsoft Dynamics GP and Schrödinger’s Cat

Dynamics GP Starter Pack and Extended Pack Modules | Dynamics University

Eric Gjerdevig looks at the new Dynamics GP Starter Pack and Extended Pack Modules

Weekly Dynamic:Delete Inventory Site ID Association

Associating an Inventory item with a site is pretty easy. Removing that association is trickier. Here is one method.

• Select the Inventory Area Page
• Select Quantities/Sites under Inventory Cards
• Enter or Lookup the Item
• Click Assigned
• Click Site ID
• Scroll, Lookup or Enter the Site ID that you want to disconnect
• Click Delete

This removes the association, it doesn't delete the item.

Friday Fun: Why Cloud Providers Cringe

Other than the hype I'm fine with The Cloud, especially when people are making rational choices about it. Love the cloud or hate it, it's still funny.

iSolutions’ Blog ~ an Indianapolis Indiana based Microsoft Dynamics GP Great Plains Consultant - Dynamics GP Multi-Currency Exchange function to convert to USD

iSolutions has a Dynamics GP Multi-Currency Exchange function to convert to USD

Big Changes Coming to Microsoft Dynamics GP Licensing | Dynamics University

Over at Dynamics University, Eric Gjerdevig starts coverage of Big Changes Coming to Microsoft Dynamics GP Licensing

Receivables Management Period-End Closing In Dynamics GP | Dynamics GP Insights

Sean Burleson explains Receivables Management Period-End Closing In Dynamics GP

Email Functionality in Dynamics GP - Some Table Definitions

Sivakumar looks at Some Table Definitions around Email Functionality in Dynamics GP

The eOne Dynamics GP and CRM Blog: GP and Phone Numbers

Chris Hanson  tackles SmartConnect and GP and Phone Numbers

Napkin Pricing - Inside Microsoft Dynamics GP

Microsoft has reduced the pricing complexity around Dynamics GP for GP 2013. They've reduced ti to Napkin Pricing

Dynamics GP Land: New Windows Service Posts Dynamics GP Batches Automatically

Steve Endow examines a New Windows Service Posts Dynamics GP Batches Automatically without the need for GP to be running.

New Pricing for Microsoft Dynamics GP 2013 Announced Today - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

From Inside Microsoft Dynamics GP comes New Pricing for Microsoft Dynamics GP 2013 Announced

Weekly Review: PowerPivot

If you are not already looking at PowerPivot from Microsoft for Business Intelligence now is the time to start. PowerPivot is designed to support end user/power user BI, including millions of records, from inside of Microsoft Excel. It works great with Dynamics GP tables, views or analysis cubes as a data source. Even better, it’s free.

PowerPivot required Microsoft Excel 2010 at a minimum and gains even more power with SQL Server 2008 R2 and Sharepoint PerformancePoint Services. If you need a compelling reason to start upgrading to Excel 2010, this is it.

You can find out more about PowerPivot and Dynamics GP here. The main PowerPivot page to download from is http://powerpivot.com/.

The Top 5 Word Defaults to Change for Dynamics GP Users

Judy Hirst explains The Top 5 Word Defaults to Change for Dynamics GP Users

Transferring Multiple Orders to Invoices in GP 2010 | onza blog

Amanda Wong looks at Transferring Multiple Orders to Invoices in GP 2010

Moving Analytical Accounting Data to History in Dynamics GP

Sivakumar examines Moving Analytical Accounting Data to History in Dynamics GP

Why would I use Main Account in a Reporting Tree? - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

Over at Dynamics Corporate Performance Management Char Gust asks Why would I use Main Account in a Reporting Tree?

Hotfix 2731285 for Microsoft Dynamics GP 2010 is now available!

If the drillback functionality from Management Reporter into Microsoft Dynamics GP no longer works after installing Service Pack 3 for Microsoft Dynamics GP 2010, check out the newly available Hotfix 2731285 to resolve the problem.

Dwight is Blogging WPC at The Death of Reason

Dwight is blogging Dynamics and general IT pieces at The Death of Reason.

WPC 2012 – Andy Vabulas on Stage « The Death of Reason

Congrats to I.B.I.S. CEO Andy Vabulas on Stage   at WPC.

Product Suggestion: eConnect POP Tax Engine - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave is highlighting a Product Suggestion of his own: eConnect POP Tax Engine

Dynamics GP SmartList Builder and Negative Amounts | Boyer & Associates

Jack Boyer demonstrated Dynamics GP SmartList Builder and Negative Amounts

Dynamic Future - Vote - See Checkbook on Cash Receipts Inquiry

Go to Inquiry >> Sales >> Transactions by Customer. Call up a customer who has a cash receipt transaction. Select that cash receipt transaction and drill back to see the original transaction.

No where on this enquiry window can you see the Checkbook ID that this cash receipt was posted to.
Having this information can be very helpful for reasearching an issue. If you want to vote for this feature, go to:

https://connect.microsoft.com/dynamicssuggestions/feedback/details/661917/gp-see-checkbook-id-on-cash-receipts-enquiry-window

Should You Post in Summary or Detail Within Dynamics GP?

Sheldon from Etelligent asks Should You Post in Summary or Detail Within Dynamics GP?

I have some strong thoughts on this. Posting in summary makes matching the subledger to the GL incredibly cumbersome if you get out of balance. It makes it impossible to use tools like The Closer to assist with balancing. I have yet to see a scenario where the benefits of posting in summary outweigh the negatives for most accounts.

1099s can be a breeze! | Dynamics University

Chris Hadden tells us that 1099s can be a breeze!

Microsoft Dynamics GP 2010 Service Pack 3 - A Closer Look at System Fixes

Kelly Youells takes us deeper into the Microsoft Dynamics GP 2010 Service Pack 3 with A Closer Look at System Fixes

Kelly answers the SP3 questions that I had when I saw the release, namely, what's in it?

About Dynamics, Development and Life: Re-awarded Microsoft MVP

Congratulations to Jivtesh on being Re-awarded as a Microsoft MVP. I understand that congratulations are in order for Mariano too but he hasn't posted anything on his site.

Execupundit.com: What Consultants Learn

The fantastic Michael Wade lists  What Consultants Learn. If you're a consultant, new, experienced, etc this is worth the read.

Weekly Dynamic: Fixed Asset GL Account Transfer

A lot people don't use Fixed Asset transfers because they think in terms of the physical movement of assets but transfers can be used for more than that. For example, if an asset has been going to a wrong account or if you decide to reorganize fixed assets and change accounts a fixed asset transfer can be used to move the GL accounts.

To transfer GL accounts for Fixed Assets in GP open the Financial Area Page. Under Fixed Assets pick Transfer. Select an asset and transfer date. Click the blue arrow next to G/L Accounts. Change the accounts that need adjustment and click transfer.

Friday Fun: More Cloud

SQL Script for Account Level Security - Developing for Dynamics GP - Site Home - MSDN Blogs

In his first article as a Microsoft employee, Sivakumar shows off a SQL Script for Account Level Security

Security Settings are not working for a Company - Developing for Dynamics GP - Site Home - MSDN Blogs

David Musgrave explores why Security Settings are not working for a Company . Hint, it's a lot like making sure the computer is plugged in.

Creating a Management Reporter report to import data into Microsoft Forecaster - Dynamics Corporate Performance Management - Site Home - MSDN Blogs

April Olson covers Creating a Management Reporter report to import data into Microsoft Forecaster

Dynamics GP Land: Are You An Advocate?

Christina Phillips asks Are You An Advocate?

Error Posting to Table POP30390. Restore from a backup if possible

Francisco Hillyer examines Error Posting to Table POP30390. Restore from a backup if possible

Dynamics GP Land: Report Builder 3.0 WITHOUT SQL Reporting Services?

Writing at Dynamics GP Land, Christina Phillips looks at Report Builder 3.0 WITHOUT SQL Reporting Services?

Changing FRx Menu Option To Open Management Reporter | azurecurve

Continuing a theme, Ian Grieve explains Changing FRx Menu Option To Open Management Reporter

Unknown Error Logging Into Microsoft Dynamics GP | azurecurve

Ian Grieve venturs into the unknown, specifically Unknown Error Logging Into Microsoft Dynamics GP

Interview with Jon Rivers | WebSan Solutions Blog

Websan has an interview with Jon Rivers

FRx — Back to Basics…. | onza blog

Amanda Wong goes Back to Basics with FRx

Understanding SOP Quantity Shortages in GP 2010 | onza blog

The Onza blog helps with Understanding SOP Quantity Shortages in GP 2010 | onza blog

Five Things to Know About XPS Writer and Viewer for Dynamics Users

Judy Hirst has Five Things to Know About XPS Writer and Viewer for Dynamics Users

Dynamics GP Land: The Tedious Details of Dynamics GP Integrations

Steve Endow examines  The Tedious Details of Dynamics GP Integrations

Doctors, Dinner and Dynamics GP in Kenya

For the last eleven days we (me, my wife, both kids and about 40 others) have been doing missions work in and around Nairobi, Kenya. We worked with a  local church and school founded by World Hope at the edge of the Kawangware slum. Our work included a three day medical clinic where we provided exams and medication to more than 900 people. We did a one day feeding program where we fed roughly 600 folks. We also brought electricity to the two buildings at Hope Academy. I want to offer a huge thanks to everyone who contributed to make this trip possible. You helped us make a difference.

 

But this is a Dynamics GP blog so let me bring this back to Dynamics GP and accounting skills. On the trip we had doctors, nurses, school teachers and a veteran utility lineman (he climbs electrical poles for a living). All of these folks have skills perfect for this trip. I'm an accountant. I can't tell malaria from a runny nose. Fortunately I'm a Dynamic Accountant so there were plenty of places to apply my skills, even if they weren't obvious.

 

• Inventory - at every stage of the trip we were counting things. We counted people, luggage, money, you name it. I can count.

• More Inventory - before we could setup a makeshift pharmacy to support the doctors, we had to separate and count the various medications that we had brought. I think you can see where this is going. Accountants rock at counting and labeling things.

• Forms - During intake, we took basic information from everyone going through the clinic. Things like name, symptoms,  weight, pregnancy status, etc. We were primarily concerned with factors that affect medication dosing.  I worked intake for two days and if you've ever done any tax work (personal, corporate, sales and use, tangible personal property, etc.) you quickly become an expert at filling out forms.  Intake was a blast. I got to ask men if they were pregnant. The joke of having to completely fill out the form, even if the question is irrelevant,  is funny in both English and Swahili. Some of the Kenyans were still laughing about it at the end of the trip.

• Feeding - We didn't run people through a soup kitchen line. People in our group (with direction from our Kenyan friends) cooked high nutrition meals based on specially fortified rice. We hand cut potatoes, carrots and cabbage and turned the whole thing into a sort of Kenyan stew to layer over the rice. We then individually served every person who came in and sat down. Finally we picked up each  plate  and did it all again. There was a pretty significant distance between the kitchen and where we were serving and an unusual rain the night before left much of the grassy areas under water. While it wasn't a global supply chain, I certainly got to use plenty of my logistics experience overseeing the chain from the kitchen to the diners and back.

I also got to encourage some accountants. Kenya has CPA's . The church's finance director , Action Jackson as he's known to us mzungu,  is a CPA. The church administrator, Fred, and one of the security teams members, Amos, are both studying to be CPA's. They had lots of questions and we got to bond over accounting.

We were on the bus one day reviewing what medications we had remaining when I got a glimpse of the invoice from across the bus. It looked familiar. They passed it over to me and I realized that the charity we had gotten our medication through was using Dynamics GP. There is something about that Report Writer based invoice. After looking at it for more than 10 years I can spot one from across room or a across a bus, even 8,000 miles from home.

I wrote this for you to understand that accounting is a profession. The skills you develop are useful in scenarios that you can't imagine today. Dynamics GP is a global product. You never know where you are going to find it. I want to encourage you to develop both your accounting and Dynamics GP skills. You never know when you might get to do something really special with those skills.

[For the curious, I couldn't find Diet Mountain Dew at/in: JFK (NY), Heathrow (London), the entire city of Nairobi,  Charles deGaulle (Paris) or Miami International. I also didn't pack any in my suitcase due to weight constraints. No, my 11 day stint in Diet Dew rehab didn't do a thing for my addiction.]

Weekly Review: Integration Manager and Excel

Often users save Excel files to CSV or Tab delimited files for use with Integration Manager. IM provides a way to skip the conversion and just import an Excel file. To make this work you simply need to define a range in the Excel file first. Then create a simple ODBC data source and pick the Excel driver. Select the Excel file and the range.

Now you can skip the middle man and integrate directly from Excel.

Microsoft Dynamics GP 2010 Service Pack 3 - Developing for Dynamics GP - Site Home - MSDN Blogs

Microsoft Dynamics GP 2010 Service Pack 3 has been release. As usual, Developing for Dynamics GP has more details and links than you ever wanted to know about.

How to remove the Connect section on the HomePage in Dynamics GP (via SQL)

Franciso Hillyer explains How to remove the Connect section on the HomePage in Dynamics GP (via SQL)

iSolutions’ Blog ~ an Indianapolis Indiana based Microsoft Dynamics GP Great Plains Consultant - Management Reporter 2012 Issue

iSolutions looks at a Management Reporter 2012 Issue with the error message "An error occurred while retrieving company information..."

New Productivity Pack for Microsoft Dynamics Connector - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

Error Shoenfish introduces the New Productivity Pack for Microsoft Dynamics Connector for connecting GP and CRM.

The Dynamics GP Blogster: Extracting data from Microsoft Dynamics GP company databases using SQL Server FOR XML and XMLNAMESPACES

Mariano looks at  Extracting data from Microsoft Dynamics GP company databases using SQL Server FOR XML and XMLNAMESPACES over at The Dynamics GP Blogster.

Replicate FRx To Management Reporter Command Customisation To Other Users | azurecurve

Ian Grieve shows how to Replicate FRx To Management Reporter Command Customisation To Other Users

Troubleshooting Microsoft Dynamics GP Service Pack Installs

The Dynamics GP Support and Services blog has nice coverage of  Troubleshooting Microsoft Dynamics GP Service Pack Installs

Belinda Allen is a Microsoft Dynamics GP MVP

Congratulations to Belinda Allen on her recognitiona as a Microsoft Dynamics GP MVP . She announced it in her blog post I'm an Microsoft Dynamics GP MVP!

Mohammad R. Daoud: Microsoft Dynamics GP Excel Paste is now Online

Mohammad Daoud's Microsoft Dynamics GP Excel Paste is now available. Check out the post for details.

Dynamic Future - Vote - MR Row Linking

Row Linking is one of those FRx features that didn't make into Management Reporter. At every MR 2012 event I've been to so far, someone brings up Row Linking so it's time to link to that as a suggested feature.

The vote for this are very fragmented with multiple suggestions for this feature. In some cases, the request is buried with other feature requests making it hard to find. I've picked one so that we can concentrate our votes and hopefully make a difference.

Suggestion 685548 covers adding FRx style Row Linking to Management Reporter

The GP team provides some options for MR at http://blogs.msdn.com/b/dynamicscpm/archive/2011/08/09/management-reporter-advanced-reporting-scenarios-and-features.aspx

Weekly Dynamic: Professional Service Tools 1099 Modifer

One of the cooler tools in the now free Professional Services Tools Library is the 1099 Modifier. The common scenario is that a vendor was not properly setup as a 1099 vendor and now there are transctions not marked as 1099 transactions.

The 1099 Modifier tool allows you to fix this by updating vendor 1099 amounts after setting the vendor 1099 flag.

You can also choose to just print a report showing what changes the 1099 Modifier will make when you run it.