A Little Texas Background this Week

After GPUG in Orlando, my son and I headed off to Dallas to see the Cowboys play in Dallas. It was one of those father son trips and we had a total blast. In honor of that you get a little Texas style background this week.

The Next Dynamics GP Book…Maybe

Shane Hall of Reporting Central and I have this idea for the next Dynamics GP book. We think that there is room in the market for a book on true confessions of Dynamics GP consultants. We’re thinking of a collection of real world stories from road warriors, sales people, whatever.We’re looking for the stories that we all share around a hotel bar, late at night, at the end of a long conference.The idea is that we want funny and embarrassing stories. That story about missing the urinal and and flooding your pants right before a big sales presentation, we want that one. The story about the long walk of shame in your underwear from the Holiday Inn tower to the lobby in Fargo, we want that one. You know who you are. Send us the stories and we’ll figure out the rest.

Here is what we are thinking for a framework:

• We will collect, catalog and edit the stories.
• The best ones make it into the book.
• The stories will be published anonymously unless you specifically ask us to use your name. It should be more fun trying to figure who goes with what story.
• We know that many of these stories have been embellished over the years so we may technically publish this as fiction. That will also make some of the edits easier.
• No we are not sharing any royalties with you. Write you’re own $%^&*@ book!

Email your stories to mpolino@gmail.com and we’ll see if we can make the whole GP community laugh.

GPUG Day 3

After a very busy night, a lot of people were dragging for day 3 but there were plenty of folks in the 8am session. I spent some time helping users with Excel reports and Reminders in GP while they fought over who could steal the Microsoft Dynamics GP 2010 Cookbook that I had to give away later. The would be thieves were thwarted when they gave up and bought their own copies online.

The roundtable lunch with Microsoft went really well as did the security session with Andy Snook of FastPath. I wrapped up the day with a great 50 Tips session full of hardcore folks hanging on to the last session.

Thanks to everyone who helped make the GPUG Summit a huge success.

GPUG Day 2

So I had this great GPUG day 2 post covering yesterday and it crashed when I tried to save it so let’s try again.

After a busy night the morning 50 Tips session started a little slow. I fixed that by handing out Diet Dew. The session ended right on time and we had a lot of fun. After that I popped into a session on new budget tool Dynamic Budgets. It looks like a great release, give Zubin a call to find out more.

At lunch I had a great Microsoft discussion around the new light user licenses. I don’t think either of us changed the other’s mind but we may have moved toward the middle. I also got a look at the Metaviewer paperless system for Dynamics GP. If you’re looking for a document management solution make sure that they are on the list.

After lunch I caught a session on the new Navigation and Drill Down builders and those are both pretty slick. Later I was really impressed by the Microsoft Conduit session on the cloud.

What’s a Conduit session? Think 8-10 people, a Microsoft facilitator and more softies lurking in the background. You all sit around and talk about a particular topic, how it relates to GP and where MS is going and thinking about going. It’s a fantastic feedback session.

I’ve really been impressed with the level of engagement of the MS folks this week. They are not just listening, they are asking good questions, challenging us and working to understand.

After one last expo we all hit up Fat Fish Blue for the Rock – n – Rave party.We think we managed to talk a customer into doing a Field Service presentation next year. If your firm has an expertise in an area of GP consider leading a GPUG session!

Everyone had a blast and I was thrilled that I didn’t have to lead an 8am session the next day.

Weekly Review: Dynamics GP, Terminal Services, Cut/Copy/Paste

It's actually been a longstanding issue with Dynamics GP that when using it via Terminal Services users sometimes lose their Copy/Paste functionality within TS. The typical advice has been to logout and log back into TS and Copy/Paste is typically restored. On the Dynamics GP Newsgroup, Alicia W. has come up with a better option. Kill the RDPCLIP process and restart it. This reliably fixes the Copy/Paste issue. To make things easier for her users, she put the process in a batch file that looks like this:

tskill rdpclip
start "" rdpclip

That's it. 2 lines in a batch file and problem solved. Thanks for digging that out Alicia and making it available to the rest of us!

This was supposed to be fixed with GP SP 3 but the problem still crops up occasionally in TS even when not using GP so this tip is still relevant. Every so often even this doesn’t work and you have you close and reconnect.

Originally Posted by Mark at 8/18/2008 09:00:00 AM

GPUG Summit 2010 Day 1

I’ve finally got a moment to reflect on yesterday’s #GPUG Summit. Tuesday was the first full day of the Summit and it was stuffed to overflowing. The opening session was heavy on GPUG with a much lighter Microsoft touch than we see at Convergence. The Microsoft presence is definitely here but it’s in the background and it feels like the right folks are here from MS. We’ve got support people, product people and even some marketing folks willing to go toe to toe with me over Light User Licenses. I didn’t feel the hard core call to upgrade that MSDynamicsWorld described. The keynote from Army General Luis Vasot was big hit with lots of positive responses from customers.
The first 50 Tips in 50 Minutes for Dynamics GP session was packed with people standing in the back and we had a great time. Everyone seemed to enjoy the new set of tips. I had some great conversations at lunch in the expo hall, spent some time with Mekorma and did an interview for Microsoft’s Community site..Mekorma has some nice updates coming for their MICR check printing product and the community team showed off some things I had missed in the new site like the ability to upload video.
After that Bob McAdam and I facilitated an Extender roundtable together that I think really helped people get the power of Extender. Some other I.B.I.S. found me and were really excited about the new online payment functionality available November 1 for Dynamics GP 2010.
At dinner I spent some time with the folks from Metafile who are seeing significant interest in their Metaviewer paperless solution for Dynamics GP. After dinner I spent time with clients and Reporting-Central. All I have to say is, don’t party with folks who build a product call The Closer.
That’s it for Day 1. There were lots of side conversations and great interaction with customers, ISV’s, Microsoft folks and even a few people cleaning up after us in the expo. Since I’m in my home town with lots of access to Diet Mountain Dew I think I’ll make it through the rest of the conference.

eConnect Error: Requested registry access is not allowed

Steve Endow shows us a solution for the eConnect 9 error Requested registry access is not allowed

Working with Temporary Files in Dexterity

Apparently David Musgrave is working as a temporary employee these, well, he’s focused on temporary things at least. First it was temporary tables and now it’s Working with Temporary Files in Dexterity .

Why you should care about Microsoft Dexterity in Dynamics GP

In his new Dynamics Community column Mariano Gomez looks at Why you should care about Microsoft Dexterity . For the medium and long term time frame I completely disagree with Mariano. The future of Dynamics GP is .net for on premise and cloud deployment. From conversations this week at GP PartnerConnections and the GPUG Summit, that has been a consistent message from partners and customers. I was also very clear in private conversations that Microsoft agree. MS has some great stuff in the pipeline so buckle up, it’s going to be a fun ride.

Microsoft Dynamics GP 2010 map buttons not drilling down to the street level

Mariano has coverage of an issue with Microsoft Dynamics GP 2010 map buttons not drilling down to the street level

Working with Temporary Tables in Dexterity with Dynamics GP

David Musgrave has a look at Working with Temporary Tables in Dexterity.

GPUG Summit and Diet Mountain Dew

If you’re at the GPUG Summit and you desperately need a Diet Mountain Dew come and find me. I have a secret stash. The password is caffeine.

Using PowerPivot with Excel 2010 to Mash Up Data

Microsoft Excel MVP Bill Jelen, that’s Mr. Excel for those in the know, take a great look at why you should be Using PowerPivot with Excel 2010 to Mash Up Data  including how to join data from different sources in PowerPivot. If you’re not using PowerPivot with Excel 2010 and Dynamics GP now is the time to start looking at it.

Missing HR Menu Items In Dynamics GP

Patrick Roth spend some time explaining  a recent case with Missing HR Menu Items In Dynamics  on Developing for Dynamics GP.

Making a new Navigation List in Builder for GP 2010 in Dynamics GP

Devon Southall has a great look at Making a new Navigation List in Builder for GP 2010. If you’ve wanted to get started with Navigation List Builder here is your chance.

Weekly Dynamic: 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.

This Week’s Theme Revolves Around GPUG and Sea World

I’m at the GPUG Summit this week and we are right across from Sea World in Orlando so you get a nice peaceful ocean theme this week on the blog.

Dynamics GP Fully applied payments stuck in Open

In Touch with Dynamics (GP) looks at dealing with Fully applied payments stuck in Open.

Troubleshooting "General Error" when using Drill-Down Builder - Part 2

Mariano finishes off the solution to my little Drill Down Builder issue in Troubleshooting "General Error" when using Drill-Down Builder.

Guerilla Social Media Lunch at #GPUG Summit

Anybody up for an unofficial, guerilla blogger/Twitter/Facebook lunch at #GPUG Summit? Something with secret Twitter only invites? If so, comment, reply or DM me.

Cross-Docking with Dynamics GP

Todd McDaniel is back with a great look at Cross-Docking with GP.

GP 2010 SP1 Installation Package doesn’t apply SP1

Andy Nifong looks at why the GP 2010 SP1 Installation Package doesn’t apply SP1 and what to do about it.

Solving Illegal Address Errors on Alternate Windows after installing a Service Pack

David Musgrave looks at Solving Illegal Address Errors on Alternate Windows after installing a Service Pack  over at  Developing for Dynamics GP

PartnerConnections, GPUG Summit and Social Media

I see some folks at this week’s AXUG conference are using Twitter, Facebook and Foursquare to communicate with attendees and losers those who couldn’t make it. I’ll be doing the same thing for PartnerConnections (#gppartners) and the GPUG Summit (#GPUG). Feel free to follow me if you want to know more or find me during the conference. I’ll be remote blogging as well as posting to these sites.

http://twitter.com/mpolino
http://twitter.com/DynAcctNet
http://facebook.com/mpolino
http://www.facebook.com/DynAcctNet
http://foursquare/mpolino
http://www.google.com/profiles/mpolino#buzz

A couple of people have actually asked about speaker prep so I thought that I would tackle a question I get. Yes, I listen to music to get pumped up to speak. It’s usually the same song over and over again but it’s rarely the same song from one venue to another. For Convergence it was Skillet’s Awake and Alive. For the GPUG Summit it’s looking like it’s going to be BarlowGirl’s Come Alive. Fortunately for all of the attendees I don’t sing.

Weekly Review: Another AP Balancing Technique

There are a number of techniques for balancing the AP sub ledger to the GL in Microsoft Dynamics GP. If you are using GP 10 you can start with the GL Balancing utility in GP. If you are already balanced you can use the balancing code on DynamicAccounting.net to help keep you in balance on a daily basis. But what if you don't fit into either of these categories?
Well, courtesy of fellow MVP Leslie Vail and her newsgroup post, I though that I would pass along her technique. The usefulness of this depends on how many AP transactions you have, how many vendors have open invoices and whether you are posting in detail.

1. Create a GL based SmartList that includes only the Accounts Payable account(s) and excludes any source document that equals 'BF'. Be sure to include the discount account if you are keeping track of it in a separate GL account.
2. Add the Originating Master ID to the SmartList. One thing you'll notice right away is that if there is no vendor ID, there's a possible trx that's trouble.
3. Export the list to Excel. Subtotal the excel spreadsheet by Master ID.
4. Add another column in Excel to net the Dr and Cr columns.
5. Now, the balance by vendor ID should be equal to the Balance on your AP trial balance.
6. Check each vendor and for the ones that don't match you'll need to take a look at the detail transactions and compare.

There's a lot more advice on this topic from experienced people in this newsgroup thread, so don't give up. You can get it balanced.

Originally Posted by Mark at 8/04/2008 08:00:00 AM

Troubleshooting "General Error" when using Drill-Down Builder in Dynamics GP

Mariano takes a look at an issue I had with Drill Down builder throwing a General Error. He tackles it in two parts, part one is up now at Troubleshooting "General Error" when using Drill-Down Builder - Part 1. Now my Drill Down Builder demo will work at the GPUG Summit. Whew!

Dynamics GP – Electronic Banking- EFT (CTX file)

Amy Walsh of I.B.I.S. has a great look at options for using a CTX file for EFT in Dynamics GP.

Management Reporter: Migrating Account Sets and Using Dimension Sets

The Dynamics Corporate Performance Management site has a nice look at Migrating Account Sets and Using Dimension Sets  in Management Reporter

GPUG Summit and the Microsoft Dynamics GP 2010 Cookbook

The GPUG Summit is so close I can taste it. If you haven’t registered stop what you’re doing and go register now. I’ll wait…

Speaking of taste it, now that you’re registered, run over to Amazon.com and pick up a copy of the Microsoft Dynamics GP 2010 Cookbook. Have it sent to you overnight. Ok, do that now…

Bring your Cookbook to the GPUG Summit and I’ll sign it for you. That’s the only way it will happen. I won’t have copies there for you to buy. You have to buy them beforehand.

Phew! Don’t you feel better now. I know that I do.

Excel Tip: Count the Number of Occurrences of a Single Character in One Cell

From Steve Endow at Dynamics GP land comes an Excel Tip on how to Count the Number of Occurrences of a Single Character in One Cell. This can be very useful for data transformation as part of an import.

Impressions from Convergence 2010, Prague

Vjekoslav provides his Impressions from Convergence 2010, Prague. The European version of Convergence is currently more of a traveling road show than a large conference and it’s more focused on Dynamics NAV and AX than GP. Read Vjekoslav’s article to get a feel for the differences.

Dynamics GP and switching it off and on again (that fixes everything..doesn’t it?)

In Touch with Dynamics (GP) has a fun look at when switching it off and on again is the right answer for Dynamics GP.

Quick Tip: Solving "Do you want to Save?" dialog appearing after VBA customization in Dynamics GP

David Musgrave provides a Quick Tip: For Solving "Do you want to Save?" dialog appearing after VBA customization in Dynamics GP

Significance of Fixed Assets REQUIRE ACCOUNT Setup Option

Vaidy dug up a useful old Fixed Assets post and it helped him solve an issue. That’s why I do the Weekly Review segment to bring some of the posts you may have missed back to light. Check out Vaidy’s issue in Significance of Fixed Assets REQUIRE ACCOUNT Setup Option

Refund Cash to customer in Dynamics GP

With a look at Refund Checks functionality in Dynamics GP, Sandip shows how to Refund Cash to customer.

Copy a basic SmartList from GP into SmartList Builder

Devon Southall does what was once thought impossible by Copying a basic SmartList from GP into SmartList Builder.

SQL Roles for DYNSA in Dynamics GP

Vaidy looks at SQL Roles for DYNSA and how they can affect the Support Debugging Tool.

Best Practices “Series” – Receivables Management Webinar

Don’t miss tomorrow’s Best Practices “Series” webinar on Receivables Management Webinar. I’m presenting and I’m really psyched about this webinar. It’s really come together well.

How Not to Design an Integration: Interface Follies

Steve Endow looks at How Not to Design an Integration: Interface Follies. All I can say is, been there, done that, bought the T-Shirt.

Weekly Dynamic: 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/.

Baseball Theme at DynamicAccounting.net This Week

This week is a baseball theme. We’re at the point now where teams are giving their all hoping to win. We’re going to be giving it our all at PartnerConnections and the GPUG Summit and we hope that you’ll come out so that we can all win together. It’s not too late and if you don’t come, I’ll be forced to call you a LOSER.

Save Money Cooking at Home with Dynamics GP

A client emailed recently with a straightforward question. Before I could answer, she emailed back “never mind, I found it in your book.” Don’t waste support incidents, save them support incidents for real issues and pick up the the Microsoft Dynamics GP 2010 Cookbook instead. The client who emailed isn’t even running Dynamics GP 2010, she’s running version 10 but the answer was still in in there.

Why won’t my modified Word template in Dynamics GP email.

In Touch with Dynamics (GP) looks at why won’t my modified word template email?

SQL view for Dynamics GP Checkbook Register

Victoria Yudin is back with a new SQL view for Dynamics GP Checkbook Register.

IntelliSense for Dexterity - DexSense 1.8 released

The Dynamics GP blogosphere is all a twitter (mixed metaphor pun intended) over the new release of DexSense 1.8. DexSense brings Intellisense functionality to Dexterity development and oh yeah, it’s free. Mariano weighs in with his thoughts as well.

New Facebook Poll: Are you going to the GPUG Summit 2010 in Orlando on Oct 25-28th?

I’ve got a new Facebook Poll up at http://www.facebook.com/DynAcctNet?v=app_20678178440. I want to know if you are going to join me at the GPUG Summit this year in Orlando. It’s not too late, the weather and the weather will be beautiful, just be careful of the large, pants-wearing mice.

Weekly Review: Invoice Reprints

If you try to print an invoice batch and nothing happens there's a pretty good chance that the invoice has been printed before. Especially if process monitor doesn't show anything running. Remember printing to the screen counts as printing.
To fix this, simply pick the "Reprint Previously Printed" checkbox on the batch printing menu and your invoices will come out.

Originally Posted by Mark at 7/22/2008 08:00:00 AM

Changing Dexterity Script Debugger Context for Dynamics GP

David Musgrave gives us a quick tip on Changing the Dexterity Script Debugger Context when developing for Dynamics GP.

What Contributes More to the Success of an ERP Project: the Right Software or the Right Implementation Approach?

In one of those, “I wish I had written that article” moments I read Tim Hourigan’s MSDynamicsWorld article on What Contributes More to the Success of an ERP Project: the Right Software or the Right Implementation Approach? It’s a fantastic article. I confess to professional jealousy. You should read it too.

How to avoid blank address lines in Dynamics GP report writer.

Do you want to know How to avoid blank address lines in Dynamics GP report writer? In Touch with Dynamics (GP) tells you how.

IMHO With The Dynamics GP Blogster

Speaking of Mariano, he also has a new column up on the Dynamics Community site. Check out his first article at Welcome to IMHO with The Dynamics GP Blogster.

Installing, Troubleshooting Dynamics GP Smart Tag

Mariano Gomez has a great look at Troubleshooting Dynamics GP Smart Tag up now at the Dynamics GP Blogster.

How to Reconcile RM to GL in Dynamics GP using SmartLists.

If you don’t have GP 10 or higher and need to reconcile AR to GL, In Touch with Dynamics (GP) provides an option in their post How to Reconcile RM to GL in Dynamics GP using smartlists.

The only caveat is the assumption that you were balanced last month. If that’s a generous assumption, look at The Closer from Reporting-Central.com. Everyone I know who has used it loves it. Tell them you heard about it from DynamicAccounting.net so they so they can charge you double for it. That way they can afford to buy me lunch. ;)

More Microsoft Dynamics GP 2010 Service Pack 1 Links

David Musgrave is back from vacation, or “holiday” as they say in commonwealth countries, with More Microsoft Dynamics GP 2010 Service Pack 1 Links

Users Created by Dynamics GP assigned automatically to “db_owner” role - not

Mohammad Daoud has a nice post up covering how a user goofed and setup DYNGRP so that Users Created by Dynamics GP were assigned automatically to the “db_owner” role.

Asset groups do not shown up for another user in Dynamics GP.

Mohammad Daoud looks at why Asset groups don’t shown up when logged in as another user in Dynamics GP. It’s because they aren’t supposed to. Mohammad explains why.

Get the most out of Dynamics GP

Victoria Yudin has a great new post on the Microsoft Dynamics GP 2010 Cookbook titled Get the most out of Dynamics GP. If you’ve  been thinking about ordering the cookbook give Victoria’s post a read.

What she hasn’t announced yet is that Victoria is also releasing a Dynamics GP book titled Microsoft Dynamics GP 2010 Implementation due out in November. Right now you can pre-order her book when you order mine and get 50% off of both books. Details are available at Packt Publishing.

Sure Step Mis-Steps

Richard Whaley looks at some work he has done cleaning up after Sure Step Mis-Steps. I think that figuring out how to adapt Sure Step to the implementation size is important. The problem is that many smaller clients don’t want to pay for the time it takes to document an implementation. From the partner side those are often the implementations with the greatest risk and therefore the ones in need of the most documentation.

New Licensing Guide available for SharePoint and Dynamics GP

The Dynamics User Group blog points us to a New Licensing Guide available for SharePoint and Dynamics GP

Leslie Vail Says Come to the GPUG 2010 Summit!

Fellow MVP Leslie Vail wants you to Come to the GPUG 2010 Summit! I do too. I’ll be there as will a number of my clients. I’m bringing 50 brand new tips. In the past folks have said that the 50 tips presentation was worth the price of the conference,  it will be this time too.

Payables HATB Report for Dynamics GP

veeyeskay has new SQL code to create a Payables HATB Report (Using GL Posting Date) and Payables HATB Report (Using Document Date). I’ll add these to the SQL Reference as well.

Dex.ini file reference has been updated for Dynamics GP

Leslie Vail’s Dex.ini file reference has been updated. If you’re looking for Dex.ini settings to improve your Dynamics GP implementation grab Leslie’s reference. You won’t be disappointed.

GPTip42day - Emailing Documents in GP2010

Frank Hamelly is back with more daily GP Tips. Check out his latest at GP2themax.

Exciting Additions to Analysis Cubes for Dynamics GP

It’s nice to see new Analysis Cubes available for Analytical Accounting and the removal of password protection for SSIS packages. Both of these are huge. AA can create large numbers of transactions so cubes are great for analyzing them. Now that the SSIS packages are no longer protected, partners and customers can make changes without a lot of hassle. Inside Microsoft Dynamics GP has the full scoop in their post Exciting Additions to Analysis Cubes! - Inside Microsoft Dynamics GP.

I’m doing  a session on Analysis Cubes at PartnerConnections. You won’t want to miss it.

Security for SmartList Builder and the other Builders in Dynamics GP

Devon Southall tackles Security for SmartList Builder and the other Builders in Dynamics GP.

Weekly Dynamic: 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.

This Week’s Theme: Community

The GPUG Summit is coming up with and everyone is excited so this week’s theme is a huge crowd of GP lovers. Well, at least they look like GP lovers to me. Come to Orlando at the end of October and have some GP fun with the rest of us.

Ship Happens, for Sales Tax Calculations in Dynamics GP

Here with a timely look at how shipping method affects sales tax calculations in Dynamics GP is Belinda, the GP CSI with Ship Happens, for Sales Tax Calculations of Course.

How to free a marked batch without SQL in Dynamics GP

The In Touch with Dynamics  (GP) site looks at an option to free a marked batch without SQL in Dynamics GP.

Import / Export in the Builders for Dynamics GP

Devon Southall has a nice look at Importing and  Exporting items in the Builders (Smartlist Builder, Excel Report Builder, etc.)

GPUG now integrated with the Microsoft Dynamics Community site!

It nice to see that as part of the Microsoft Community 2.0 launch that GPUG now integrated with the Microsoft Dynamics Community site. I’m working hard on my presentations for GPUG Summit 2010 and it’s nice to see a tighter connection between the official Microsoft community and the GP User Group.

Welcome to Microsoft Dynamics Community 2.0!

I mentioned recently on MSDynamicsWorld that the Dynamics Community site was alive and well and now it’s getting an upgrade. Make sure to visit the new Microsoft Dynamics Community 2.0. It looks great.

David Musgrave has his own take on the new community site.

Dynamics GP 2010 and Outlook 2010

Andy Nifong looks at issues sending a report to PDF or TXT with Outlook 2010 and GP 2010. Fortunately, it’s an easy fix.

.

Weekly Review: Account Security

I got bit by an old bug recently. To be fair, it's not a bug, it really is a feature, but that didn't make the bite feel any better and "bit by a feature" is a confusing metaphor.

If you accidentally turn on "Account Security" in the Company->Company setup window all kinds of mayhem ensues.
See, account security is designed to work with the Organizational Structure feature to limit access to certain accounts. The idea behind this is that some organizations have a very complex account structure and it makes picking the right account easier if you limit a department to only be able to see their own accounts. But if you haven't setup Organizational Structures (a pretty common occurrence), turning on Account Security will wipe out everyone's ability to see and interact with the chart of accounts.

Oops. It sounds like a good thing to turn on. I had this happen at a client recently and was stumped as to what had changed. I remember this scenario but it had been a long time. The client is new to GP and so they are not sophisticated enough to have found and turned off security to the Chart tables in GP10. Heck, I'm not sure if I could find that without some digging in Version 10, I certainly couldn't stumble across that accidentally.

A quick trip to Partnersource reminded me of this issue and a checkbox later, we were good to go. We didn't have audit trails on yet so I'm not sure (nor do I really care) who turned it on but we'll be adding that to the audit trail list.

Originally Posted by Mark at 7/15/2008 09:40:00 AM

How to reverse Revenue Recognition transactions in Dynamics GP Project Accounting

Janakiram M.P. has a nice new post up on How to reverse Revenue Recognition transactions in Project Accounting.

From the Newsgroups: "The input tax for this range hasn't been entered. Do you want to continue calculating?" error when running VAT Return on Microsoft Dynamics GP v10

Mariano Gomez continues his “From the Newsgroups” series with a look at "The input tax for this range hasn't been entered. Do you want to continue calculating?" error when running VAT Return on Microsoft Dynamics GP v10.

Online Services for Microsoft Dynamics GP

Developing for Dynamics GP and Inside Microsoft Dynamics GP have coverage of new Online Services for Microsoft Dynamics GP. New online Payment and Commerce services will be available to customer current on their enhancement plan starting November 1. Customers will need to be on GP 2010 SP1 or GP 10 SP5. Here is Inside Microsoft Dynamics GP post with more details.

Review the Microsoft Dynamics GP 2010 Cookbook

If you’ve gotten a copy of the Microsoft Dynamics GP 2010 Cookbook I would really appreciate it if you would review the book on Amazon.com. You don’t have to have purchased the book from Amazon to provide a review but your comments can really help others trying to make a decision.

New Dynamics for Distribution Blog for Dynamics GP

Todd McDaniel has a new Dynamics GP focused blog up at http://dynamicsfordistribution.blogspot.com/ and it looks great so far. A dirty little secret of blogging is that some of the best articles are the first ones written by new bloggers. Why? Because they tackle all of the issues that they feel compelled to write about. These are the things that gnaw at them. The items that others aren’t tackling.

Todd’s blog has some great first articles up including:

• A look at P.O. Commitments and Historical Sales
• Dead Stock Walking
• Effective Inventory Item Ranking
• Special Orders

Check out Todd’s blog for more GP distribution related posts.

Microsoft Dynamics Sure Step 2010

Packt Publishing has announced the preorder availability of a new book covering Microsoft Dynamics Sure Step 2010. Congrats to Chandru Shankar, Vincent Bellefroid. I’m looking forward to getting a copy.

Looking Beyond Dynamics GP 2010, Microsoft Aims to Extend Footprint, Integration, and Usability

Linda Rosencrance has a new article up at MSDynamicsWorld Looking Beyond Dynamics GP 2010, Microsoft Aims to Extend Footprint, Integration, and Usability.

I’m still deep in GP 2010 so it’s nice to see that someone is looking ahead.

Top 5 Ways PowerPivot Helps Excel Pros

The Excel team has a great new post on the Top 5 Ways PowerPivot Helps Excel Pros . These tips work really well for Excel pros who use Dynamics GP too!

How to copy SmartList to Excel Report Builder in Dynamics GP

Janakiram M.P. looks at How to copy Smart list to Excel Report Builder

Microsoft Dynamics GP 2010 Word Templates summary

Mariano has a nice wrap up of his recent work with Word Templates in Dynamics GP. Make sure to take a look at his Microsoft Dynamics GP 2010 Word Templates summary.

Security Task/Role associated with a Dynamics GP Window

New to GPWindow.com, Jivtesh has a added a way to find the Security Task/Role associated with a Dynamics GP Window

Finding Command Forms and Commands to use with Menus for Visual Studio Tools or Dexterity

Patrick Roth has a nice look at figuring out the name of a command list and command form to use when integration to Dynamics GP.

Congratulations to New Dynamics GP MVP Sivakumar Venkataraman!

Congratulations to Sivakumar Venkataraman on being named a new Microsoft MVP for Dynamics GP. Sivakumar Venkataraman runs the Interesting Findings & Knowledge Sharing site dedicated to Dynamics GP and is the moderator of the Dynamics GP Google Group. We appreciate all of Sivakumar hard work on behalf of Dynamics GP users.

Do you print a lot of monthly reports in Dynamics GP?

Belinda, the GP CSI takes a look at great feature that is rarely used in Dynamics GP, Report Groups.

How to resize logo in Microsoft Dynamics GP Word Templates

From Mariano Gomez and his recent work with Word Templates comes a look at How to resize logo in Microsoft Dynamics GP Word Templates.

Dynamics GP Collections Management Webinar

Don’t miss Tuesday’s Dynamics GP Collections Management Webinar. My friend and milkshake buddy Ross Carlson will be covering Collections Management in Dynamics GP. In the tough times, this is webinar is an absolute must see.

Weekly Dynamic: Copy/Move SSRS Reports Between Servers

If you need to copy or move SSRS reports between servers there is a great, free utility called Reporting Services Scripter. It allows you automate the deployment of SSRS reports, grab RDL files off of an existing server, including the datasource and directory structure, and transfer the reports to a new server. All of this without requiring BIDS or Visual Studio.

This tip was courtesy of Dwight Specht. Feel free to tell him that he rocks.

Autumn Theme This Week

Here in the southeastern U.S. we’re seeing the first cracks in the heat and humidity that signal the arrival of fall. That’s close enough for me to make this week’s theme a preview of autumn to come.

Microsoft at the Top

Mary Jo Foley has some interesting tidbits on realignment going on at MS. Kurt DelBene is taking over as the head of Microsoft Business Division for Steven Elop who left to run Nokia. Here is the twist, Kiril Tatarinov, the head of Microsoft Business Solutions, where all of the Dynamics products live, will continue to report directly to Balmer. I have no idea what it means. Let the conspiracy theories begin.

MVP Award Renewal

So today is the day that Microsoft is supposed to tell me if my MVP award has been renewed for another year. Unfortunately the email from MS was not what I had hoped for. I found out that my MVP lead is changing and Melissa Travers will no longer be supporting the Dynamics MVP’s. On the plus side, they did renew my MVP status for another year. ;)

I would do this with or without the MVP but award but I still look forward to that email each year and it is still a lot of fun.