Friday Fun: Naming Conventions

I swear that I’ve been to this user and seen this naming convention, yes, evening including the squirrel part.

The Dynamics GP Blogster: Hybrid development for the Managed Code developer (cont.)

Mariano continues his look at at Hybrid development for the Managed Code developer.

Feature of the Day: Microsoft Dynamics GP and CRM Data Built In - Inside Microsoft Dynamics GP

Today’s Feature of the Day from Inside Microsoft Dynamics GP looks at combined GP and CRM metrics. These are SSRS metrics available via SSRS, Business Analyzer and from within GP.

Check it out at Dynamics GP and CRM Data Built In.

 

Quick Tip: Understanding the Dexterity Reject Script command - Developing for Dynamics GP

David Musgrave gives us a look at Understanding the Dexterity Reject Script command

Dynamics GP - Learn & Discuss: Microsoft Dynamics GP 2010 R2 - SRS Reports Deployment Error

New from Vaidy is a look at a Microsoft Dynamics GP 2010 R2 - SRS Reports Deployment Error that he had. Don’t worry, most of you won’t ever see this.

Dynamics GP Land: A Tragedy In Integration Land: How to Spot a Bad Dynamics GP Integration

Steve Endow digs into A Tragedy In Integration Land: How to Spot a Bad Dynamics GP Integration

I don’t completely agree, just mostly, but it does lead to some nice discussions.

Weekly Review: Use Tax, Landed Cost and Project Accounting

So you are running Project Accounting. You purchase materials for your project and you want to include use tax paid for those line items in the appropriate project. Well, with Dynamics GP 10 it's not all that hard to do. I'll be putting out Use Tax paper soon with every last detail but for those of you with a little experience, here are the steps.

• Run the Use Tax amount through AP
• Apply this amount to a PO receipt via Landed Cost
• Landed cost can be used to calculate the Use Tax amount and apply it to line items based on the value of the line item.
• If you apply the line items directly to a project, the landed cost total flows through to Project Accounting.
• If you simply post the amounts to inventory with landed cost applied, that cost flows through to Project Accounting when transferring inventory amounts to PA using the inventory transfer functionality.

The beauty of using the landed costs functionality is that it flows all the way through to whatever module is downstream and that included Project Accounting.

There are more Use Tax tips in my Best Practices Guide to Use Tax for Dynamics GP.

 

Posted by Mark at 3/16/2009 10:00:00 AM

In Touch with Dynamics (GP): How to create 32 bit ODBC data sources for Dynamics GP from a 64 bit server.

In Touch with Dynamics (GP) digs into at How to create 32 bit ODBC data sources for Dynamics GP from a 64 bit server.

Dynamics GP Land: Forecaster TRANSLATE -vs- TRANSLATEL

Christina Phillips digs into currency translation in Forecaster with Forecaster TRANSLATE -vs- TRANSLATEL.

Dynamics GP Land: Warning! Implementation Trauma Ahead

Christina Phillips digs into implementations with her post Warning! Implementation Trauma Ahead

In Touch with Dynamics (GP): Dynamics GP Bank Management - Checkbook [checkbook id] is already in user by user [username].

In Touch with Dynamics (GP) provides a solution for when Checkbook [checkbook id] is already in user by user [username].

The Dynamics GP Blogster: Hybrid development for the Managed Code developer

Mariano’s new post looks at Hybrid development for the Managed Code developer…and my kids call me a nerd!

Mohammad R. Daoud: Dynamics GP 2010 R2 Business Intelligence Installation Error maxRequestLength

Mohammad Daoud run into a problem and a fix with Dynamics GP 2010 R2 Business Intelligence Installation Error maxRequestLength

Find databases where SQL Server log file is too large

Have you ever faced a scenario where your log files weren’t getting properly backed up and truncated so they ate up all the free space on SQL Server? Yeah, most of us have. MSSQLTips has SQL code to Find databases where SQL Server log file is too large. This lets you prevent the locked up server embarrassment.

Mohammad R. Daoud: Why do I see empty charts in Fabrikam?

Mohammad Doaud digs into Why he sees empty charts in Fabrikam with Business Analyzer. Hint, Fabrikam lives back to the future in 2017.

Something You Missed While at Convergence

I told you that there was more to come and just before Convergence I released my newest Dynamics GP short story, Wanda’s Wicked Workshop.

In the rush of Convergence some of you missed it and frankly, its too much fun to ignore.

Wanda, the mistress of Wanda's Wicked Workshop is facing a visit from the health inspector. When the health inspector turns out to be a real ogre who is immune to her magic, she has to rely on Microsoft Dynamics GP and her Dynamics GP consultant to keep her shop open. FastPath’s Config AD and MetaViewer also make an appearance to help save the day.

Wanda’s Wicked Workshop is available as a PDF or Kindle version and there is a chance to win a copy of the upcoming Microsoft Dynamics GP 2010 LITE Cookbook at the end.

If you’re subscribed to the newsletter, there is a free code for the PDF version of Wanda’s Wicked Workshop in this month’s edition.

Don't miss the other titles in the Adventures in Accounting with Microsoft Dynamics GP series. If you're not have fun while reading these, you're doing something wrong.

Ray Wang and Errol on Dynamics GP 2010 BI

 

Ray and Errol talk GP 2010 BI

Check out the three new videos of analyst Ray Wang (@rwang0) and Errol Shoenfish talking Microsoft Dynamics GP. The highlighted one above covers Business Intelligence but there are also videos discussing Industry Trends and Business Processes.

Mohammad R. Daoud: Enhanced Inventory Item Reconciliation

Mohammad Daoud also digs in to the Enhanced Inventory Item Reconciliation available for free as part of the Professional Services Tools Library.

Using Item Reconciler

Item Reconciler allows you to reconcile Inventory. The Reconciler’s function is the same as the reconcile functions built into Microsoft Dynamics GP with one exception: only those items that need reconciling will be reconciled using Professional Services Tools Library. This can increase performance if all items don’t need to be reconciled.

We covered free tools in the PST Library at the 50 Tips session this year at Convergence. If you weren’t there, these are the kind of things you missed.

Mohammad R. Daoud: Microsoft Dynamics GP - Management Reporter Issues

Mohammad Daoud looks at some Microsoft Dynamics GP - Management Reporter Issues that he’s having, specifically:

“The operation could not be completed due to a failure on the server.”

He provides details and a fix.

Word Templates will not print to screen - Developing for Dynamics GP

Dave Dusek looks at what to do when Word Templates will not print to screen.

GP2themax - Helping users get the 'max' from Dynamics GP: How to do I recover the Administrator password in FRx?

Frank Hamelly looks at options to recover the Administrator password in FRx.

SQL Script – Standard Cost Less Than Valuation Cost « Real Life Dynamics User

Ron at Real Life Dynamics User gives us a SQL Script with Standard Cost Less Than Valuation Cost.

The idea is to find products where the standard cost is too high due to a price decrease.

Dynamics Confessor Blogspot: Upgrade to 2010 R2?

Leslie Vail did have an issue with the Upgrade to 2010 R2. A clean install went fine but she’s looking for help with an upgrade issue.

 

Feature of the Day: Date Effective Tax Rates - Inside Microsoft Dynamics GP

In a new Feature of the Day, Pam Misialek looks at Date Effective Tax Rates in Dynamics GP 2010. David Musgrave thinks that I incorrectly gave him credit for this feature but I did cover it in the 50 Tips session at Convergence.

Phew! I finally beat Pam to something!

Dynamics Confessor Blogspot: GP 2010 R2 – Ready to Download!

Leslie Vail is all excited about Business Analyzer in  GP 2010 R2 . She provides a great early look.

Microsoft Dynamics GP 2010 R2 is loose!

That pesky Dynamics GP 2010 R2 release snuck out early when no one was looking, well no one but Mariano. He has all the links at Microsoft Dynamics GP 2010 R2 is hot off the press

iSolutions - Import Journal Entries from Excel into Dynamics GP

iSolutions has a new solution to Import Journal Entries from Excel into Dynamics GP. It’s not free but I’m interested to see how it works. Often these are harder to get right than they look when you add in multicurrency and reversing entries.

7 Options for Replacing FRx | FRxBuzz

Jan Harrigan was kind enough to send me a free copy of her 7 Options for Replacing FRx. If you’re looking to replace FRx this is a fantastic resource. It’s scary how thorough this is.

Silverlight UI for Microsoft Dynamics GP 12 is Key for Cloud Credibility, Microsoft Believes | MSDynamicsWorld.com

MSDynamicsWorld look at why MS believes that the Silverlight UI for Microsoft Dynamics GP 12 is Key for Cloud Credibility.

I think that Silverlight is a great options but I worry that other parts of MS are already looking to HTML5 as a Silverlight replacement.

Convergence Leftovers

Mariano and Dave picked up on my speaking thoughts and posted their own view of speaking at Convergence. Check out both of them for a lot of fun.

Mariano

David

How to move your security settings from Test into Production - Dynamics GP Support and Services Blog

Terry Blazer has a nice follow up to his previous security post with a look at How to move your security settings from Test into Production.

Weekly Dynamic: Fuzzy Lookup Add-In for Excel

Have you ever needed to find duplicates in Dynamics GP? Maybe you want to corral duplicate vendors so that they can be combined into a single vendor using the Professional Service Tools.

Let’s say that you have vendors named “Home Depot”, “The Home Depot” and “Depot, The Home”. You might even have and entry for “Hom Depow” in there. Sorting these in Excel won’t get you there. You could search on on Home or Depot but that’s a hard way to do it. How do you make this work?

Use the Fuzzy Lookup Add-In for Excel. This free add in performs fuzzy lookups allowing you to find all the variations taking into account abbreviations, misspellings and variants. It also provides a confidence score to show you how close the variations are to the original.

GPUG Anyone?

Friday Fun

If you are not reading Nicholas Bate you should be.

Convergence 2011: A Peek Behind the Eval Curtain

In the past I’ve given some small looks at what goes on behind the scenes at Convergence. I’m not nearly involved enough for all the massive pieces around a keynote or scheduling but there are some fun things I can share. So let’s talk about speaker evaluations.

All the speakers get evaluated and then measured both within their track (GP, AX, CRM, etc.) and against the other tracks. Only sessions with 10 or more evaluations get compared. As speakers we get to see it all and yes, we’re competitive. This is really good for attendees because we always try to be better so you get better sessions.(I keep asking for a t-shirt cannon. Sigh…Maybe next year)

Yes, Dave and Mariano and I go at it, in fun, and often our scores are crazy close, 1/100th of point close over more than 100 evaluations each.

Going up against Dave and Mariano is great. They are great presenters and they deliver terrific sessions. It can be a little frustrating when you have more than 200 evaluations for a session and you get beaten by 1/100th of a point by someone with 11 evaluations. But hey, we know that’s the way it works going in. It’s also frustrating when someone gives you straight 1’s (extremely dissatisfied) without an explanation. Did they goof? Did you insult their mother? Were they expecting Lady Gaga? Who knows.

The most fun comes from the comments. I read every comment that people make and all comments are anonymous. That’s where enhancements like version numbers for the tips came from this year. Usually people make great comments like:

• Microsoft really needs to hire Mark Polino, he is hands down the best evangelist for the GP product. Got many time saving tips to put into production immediately.
• Mark Polino is simply the best presenter with his combination of impressive knowledge and his enthusiasm that takes a dull subject and injects fun into it.

These are the kinds of tips that I show to my wife…over and over again. She explains that I’m still lucky to have married her rather than the other way around. She’s right of course.

Sometimes you get some odd comments. I know that my sessions are fast. I present better that way. I try to make this very clear in the session names, descriptions and very early in the presentations. So I’m perplexed when I get comments like:

• Not enough details, too fast paced
• He talked way too fast and it all seemed to blend together.

In fairness these are rare comments, outliers and I rarely adjust the presentation for them. You can’t please everyone. Most comments are extremely complimentary. However, there are always a few that I just don’t understand like:

• session was not effective (and then gives 4 stars (satisfied) across the board.)
• i did NOT attend this session

So why did you comment again?

And then there is my absolute favorite from Convergence 2011:

• Presentor was very obnoxious

Yes! I’ve succeeded! I want to be obnoxious about Dynamics GP. I’m fine with that. Maybe if I’m obnoxious enough more folks will take GP to the next level!

So that’s what’s is like as a presenter, nervous about the presentation, relief that it’s done, then nervous about the evaluations. Relief when they look good, nervous that Dave and Mariano will beat you.

Right now, I’ve got a session in the top 10 overall sandwiched between 2 of David and Mariano’s sessions. I’m leading them in presenter effectiveness at number 3 overall by 1/100th of a point. In both cases we’re getting beaten on overall scores by sessions with much lower attendance and significantly fewer evaluations returned. Part of that is just the price of popular sessions.

It’s not too late to go to MSConvergence.com and rate the sessions that you attended. You’ve got about a week left. It is too late to get  your witty comments into this blog post.

Thank you to everyone who attended my sessions and an even bigger thank you to the almost 50% who have submitted evaluations. You make Convergence better.

---

To the guy who asked a support question in the comments: No, I don’t believe that there is a way to put a SOP line item on hold with putting the whole document on hold. See, I told you that I read all of the comments.

DynamicsBlogger: Management Reporter Failed reports Queue cleanup

Janakiram M.P. looks at how to manage Management Reporter Failed reports Queue cleanup in his new post.

Feature of the Day: Business Analyzer – Report Settings - Inside Microsoft Dynamics GP

Back with another Feature of the Day, Inside Microsoft Dynamics GP looks at Business Analyzer – Report Settings

Administering GP Security - Dynamics GP Support and Services Blog

From the new Dynamics GP Support and Services blog, Terry Blaser looks at Administering GP Security - Dynamics GP Support and Services Blog.

Weekly Review: Project Accounting GL Accounts

This week's Weekly Dynamic segment is a little different. I'm pointing you to my I.B.I.S. ERP Blog post on GL Accounts in Project Accounting where Ross Carlson and I have created an example of posting flows for Project Accounting.

This Excel based template includes examples, journal entries and T-Accounts to help people understand Project Accounting's posting flow. We've tackled both Time and Materials and Fixed Price projects. There's even a place to put in your own accounts to help figure out what accounts go where.

Our examples are complete but don't cover every possible scenario. The goal was to take the whiteboard work we do and make it a litte more permanent.

Originally Posted by Mark at 2/23/2009 09:30:00 AM

The eOne Dynamics GP and CRM Blog: Tech Tuesday: Text Data Source

eOne looks at using the Text Data Source  (non-CSV or no headers)  in Smart Connect. It works just fine but it does get in the way of using folder sources and it make tab delimited files tougher to use than they should be. Hopefully some improvements are coming.

Feature of the Day: Display Business Analyzer information in Office Communicator/Microsoft Lync - Inside Microsoft Dynamics GP

Anybody sick of seeing new GP 2010 features every day? Yeah, I’m not. Here’s another one from Inside Microsoft Dynamics GP.

Display Business Analyzer information in Office Communicator/Microsoft Lync

Microsoft Excel - Add the date, time, file name, and page numbers to your headers or footers

Just in case you don’t know how to add headers and footers in Excel, here’s a video on how to make it happen: Microsoft Excel - Add the date, time, file name, and page numbers to your headers or footers

Oh yeah, you can add pictures to a header and footer too.

Watch your user names in Analytical Accounting - Dynamics GP Blog | Dynamics GP Blog

The Dynamics GP Blog explains why it’s important to Watch your user names in Analytical Accounting

Microsoft Dynamics GP Upgrades Approaches and Techniques by pfeDynamics | Blog Talk Radio

Here is one more podcast covering Microsoft Dynamics GP Upgrades Approaches and Techniques

Security in Microsoft Dynamics GP by pfeDynamics | Blog Talk Radio

Here is a new podcast looking at Security in Microsoft Dynamics GP.

Also, the Support Debugging Tool makes a cameo appearance.

Common Support Debugging Tool Myths - Fact or Fiction? - Developing for Dynamics GP

Check out Dave Musgrave’s new post on Common Support Debugging Tool Myths - Fact or Fiction?

I make a cameo appearance at the end.Try not to spit out your coffee.

Centralize or Decentralize Distribution Management? | I.B.I.S. Inc.

Distribution expert Brent Grover has a new guest post up at the I.B.I.S. blog with answering the question Centralize or Decentralize Distribution Management? .

The Dynamics GP Blogster: Resetting Security Roles and Task with the Support Debugging Tool

Mariano comes roaring out of Convergence with a look at Resetting Security Roles and Task with the Support Debugging Tool.

Convergence 2011 Review - Inside Microsoft Dynamics GP

Pam has her Convergence 2011 Review up. For those of you who missed it, Errol didn’t make it to Convergence. He was busy sandbagging…er…trying to save his house. You can see more here:

http://blogs.msdn.com/b/gp/archive/2011/04/11/where-s-errol-post2.aspx

Dynamics Small Business: My Review of the Microsoft Dynamics GP 2010 Cookbook: Tips You Can Use Now!

Blogger Matt Landis liked the Microsoft Dynamics GP 2010 Cookbook and gives a review at My Review of the Microsoft Dynamics GP 2010 Cookbook: Tips You Can Use Now!

The book sold out at Convergence 2011 in two days.Um…remind me again why you don’t have a copy?

Feature of the Day: Business Analyzer - Assign Contacts - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs

So you thought the features of the day would stop with Convergence? No chance. Inside Microsoft Dynamics GP looks at Business Analyzer - Assign Contacts as the newest feature of the day.

Microsoft Finalizes Roll-Out of New Dynamics Partner Standards, Prepares ERP VARs for the Cloud Economy | MSDynamicsWorld.com

MSDynamicsWorld looks at partner changes as Microsoft Finalizes Roll-Out of New Dynamics Partner Standards, Prepares ERP VARs for the Cloud Economy.

FUTA Rate Change

iSolutions has a look at how to change the FUTA Rate now that the fix is available.

The eOne Dynamics GP and CRM Blog: FeedBack Fantastic

I mentioned that I got a little time with eOne at Convergence. Well Martin from eOne has his Convergence wrap up at FeedBack Fantastic.

Convergence ISV Wrap Up

I didn’t get enough time with ISV’s at Convergence this year. Some of that was because they were busy selling and most of them are more than willing to talk to me outside of Convergence. I did manage to catch a few though and here are the highlights.

• eOne spent some time me with talking about SmartConnect. I shared some things that I would love to see in the product and they gave me some ideas on how to use it better. Everybody won. I’ve got to get some more time with Smart View. That’s on the list of things I missed.
• Mekorma showed off some nice improvements to MICR check printing including linking the check signature to the approver. This will work really well for some of our clients who switch check signatures based on which signers are in town.
• Rockton showed off new Payables Approvals that are coming soon. The beta was in great shape and provided lots of options for AP approval. SmartFill and the GP Toolbox continued to generate huge interest.
• Reporting Central debuted the Validator. The Validator is designed to apply setup best practices against a Dynamics GP database and provide recommended improvements to the system. Given the number of issues we all seem to find and fix there was a lot of interest among partners and end users.
• FastPath continues to make their products better with a cleaner interface and more template to support different flavors of compliance.

Mark Rockwell got high marks on DayONE showing off 100 ISV solutions in 50 minutes. This is an idea that I’ve toyed with too. I think it’s got the potential to grow into something big at future Convergence conferences.

MBS Guru: File not found: VBA6.DLL in Microsoft Dynamics GP 9 Visual Basic Editor

Michael Johnson, who got some nice shout outs in the 50 tips session at Convergence, looks at an error labeled File not found: VBA6.DLL in Microsoft Dynamics GP 9 Visual Basic Editor when working with Office 2010 and Dynamics GP. He points us to a solution.



Correction: Bryan Prince was the author of this article. Nice job Bryan.

My Big Convergence Wrap Up

I thought about sending a few notes on some of these items privately but frankly, the good so far outweighs any bad that I’ve decided to make it all public.
Convergence 2011
The Good

• Much of the keynote was devoted to Dynamics AX. Put your conspiracy theories away. Last year it was all GP with the release of GP 2010. This year it was AX’s turn with the upcoming release of AX 2012. The focus was completely reasonable.
• It was very cool to see Pam Misialek, my co-presenter from two years ago, on the big stage showing off GP 2010 R2. You rocked Pam.
• It was also nice to know that Errol’s house didn’t flood. I’m sure there are some GP 6 manuals lying around that could be used as makeshift sandbags.
• Business Analyzer is a new stand alone app for GP R2 that allows personalized Business intelligence without requiring a full blown GP license. Business Analyzer generated a ton of interest at Convergence.
• GP 12. The next release is deep in development with Chad Sogge showing off an upcoming web client for GP. I had heard that the team found a way to separate the business logic in GP from Dexterity and it looks like that rumor was not only true, but is being used to create web forms. This is what I want more than the cloud. I want the Outlook or OneNote model with rich clients, rich web clients and options for local or off premise server hosting. I owe Chad and the Dev team several drinks once this gets delivered. If anyone believes that GP isn’t getting dev resources you’re full of hooey.
• Everything is going to the cloud with NAV first, maybe as early as the end of the year, followed quickly by GP and AX.This is just in time for folks who went to GP 10 and held off on 2010 to get all excited about upgrading.
• We started a little Twitter based drinking game during the conference based on how often the word “Cloud” was said. It was not pretty.
• Surprisingly there was still huge buzz over GP 2010 and R2. Folks were in good spirits and engaged. There is always a risk of letdown when you’re showing a minor release and the event is in the same location but there was no evidence of that this year.
• Folks were very engaged. Sessions were full, Expo booths were packed. By packed I mean regularly 4 people deep waiting to talk to someone and in some cases, you couldn’t get down an aisle.
• Another example of engagement was the number of people in my sessions. Almost 800 people saw the 50 tips session and it’s repeat. But even my new Excel based sessions saw nearly 700 people come learn about ways to connect Dynamics GP and Excel.
• Mariano and Dave rocked the house as usual. It seems that they are looking to take their act to Vegas for the GPUG Summit in November. I hear that Caesar's is considering giving them a regular show.
• The event at I.B.I.S. customer Georgia Aquarium and the World of Coke was terrific. There was plenty of room to move around and see the exhibits. This was a problem at Universal Studios the last time Convergence was in Orlando so it was nice to have some breathing room.
• Rock N Rave and The Spot continue to get bigger each time. Both events were huge this year with glow in the dark partying and U2 tribute band Elevation.
• The venue was again terrific. Atlanta did a nice job of not making us walk too far, except maybe for the keynote. Our feet hurt by the end but not like they did in Dallas.
• The Microsoft Dynamics GP 2010 Cookbook sold out early Tuesday morning forcing people into withdrawal for nearly two days.

The Bad
Nothing is perfect and there were a places for improvement when Convergence moves to Houston in 2012.

• They wouldn’t play in and out music for my sessions like they did last year. Um, when you have 500+ peeps in an auditorium it really helps to get people pumped before you speak. Please, please, please give me some Metallica or Lady Gaga or something upbeat next year. When I sing, my evaluation scores crash.
• The food didn’t seem as good this year. The snacks between sessions seemed thinner. One lunch, I got in the line, looked at the food and left. If you’ve met me, you know that I don’t walk away from many buffets.

• Some of the speakers scores this year were crazy good. The competition at the top for people’s attention get’s better every year. But I heard more complaints about unenthusiastic speakers this year. I don’t know if things are actually worse or if the contrast is just starting to show. I also heard from the speaker coach that of the 25 conferences that they help MS with each year, Convergence has the fewest number of speakers who take advantage of a coach. I do it every year and I have the scores to prove that it works.

The Wrap Up
This was a phenomenal conference all around. Booth activity and book sales seem to indicate increased confidence in the economy. Folks were energized and ready for all of the cool stuff coming in GP 12. I’m looking forward to seeing everyone in Houston, unless of course you come to the GPUG Summit in Vegas first!

David and Mariano Wrap up Convergence 2011

David and Mariano have some Convergence wrap up posts:

End of Day 4 from David

End of Day 4 from Mariano

David made it home safely, though not necessarily sanely as you can see in this video of Dave busting moves at Convergence courtesy of Leslie Vail

Weekly Dynamic: Microsoft Connect

Often we want features in the next release of Microsoft Dynamics GP or there’s an annoying bug that just hasn’t gotten fixed.. How do you make sure that the features and bug fixes that are important to you become important to Microsoft? The answer is MS Connect.

The MS team kept reminding me of how much they use Connect to determine the need and the passion around a feature or fix. So I’m committed this year to leveraging Connect myself and working to help others use Connect to get our needs in front of MS.

The beauty of Connect is that we can not only add new issues, but we can vote as a community on existing items. I’m hoping to do some mob votes were we all pick something that we agree needs to be fixed and we’ll all vote on it.

It’s time to Connect.

Dynamics GP Land: Lesson Learned- Importing Tax Details

Christina Phillips looks at a Lesson Learned- Importing Tax Details. It’s not quite as easy as it sounds.

Negative Deduction in Microsoft Dynamics GP 10 and GP 2010 Not Calculating on Checks After 3/25/2011 Service Pack Applied » Summit Group Software Blog

The Summit Group has run into an issue where the Negative Deduction in Microsoft Dynamics GP 10 and GP 2010 is Not Calculating on Checks After 3/25/2011 Service Pack Applied.

They have a recommended workaround.

Why Some Dynamics Projects Fail, and How the Problems Can Be Anticipated Early On | MSDynamicsWorld.com

MSDynamicsWorld looks at the Microsoft Dynamics Project Readiness Assessment project, Why Some Dynamics Projects Fail, and How the Problems Can Be Anticipated Early On

Don’t Dance At Convergence « The Death of Reason

Dwight Specht reminds Partners of all the things that they can do to screw up at Convergence. He was kind enough to leave out “wear a pink sash that says ‘bachelorette’ on stage in front of almost 600 people” like I did but I’ll tell that story later. Check out Dwight’s post at Don’t Dance At Convergence .

Control C, Control V: Search and Duplicate in ReQlogic | DynamicsCare

My colleague, and all around really nice person, Kelsey Andrich has a new post up at DynamicsCare looking at Search and Duplicate in ReQlogic.

Dynamics Confessor Blogspot: SOP order and POP document in the same order

From a Convergence reminder, Leslie Vail looks at how to get the SOP order and POP document in the same order.

Cookbook Sold Out at Convergence 2011

The Microsoft Dynamics GP 2010 Cookbook sold out at Convergence very early on Tuesday. For two days people hounded me for books that I couldn’t give them.

If you’re looking for the Cookbook, check out this page from the publisher to get your copy.

President Signs Repeal of Expanded 1099 Requirements

The repeal of the onerous 1099 requirements coming out of the healthcare bill has been signed by the President. Some parts remain however, including the increased penalties for improper filing.

Journal of Accountancy has the nitty gritty.

The Convergence 2011 Presentations are Up

If you’re looking for Convergence 2011 presentations, they are easy to find. All you have to do is:

• Log in to MSConvergence.com for Atlanta 2011
• Go to Schedule Builder and find the session
• Immediately below the session title is the download link.

If you just want my slide, they are up in their usual place, top right, on DynamicAccounting.net.

Convergence 2011 50 Tips Update

Just a couple of updates from the 50 Tips for Dynamics GP in 50 Minutes presentation from Convergence.

• It looks like the free Separation of Duties Evaluator has been removed from the link listed in the presentation. I’m reluctant to post the file since I don’t own it but if you really want it, drop me an email.
• If you want more PowerPivot info, check out Bill Jelen’s new post on CFO.com
• If you liked the Professional Services Tools, Microsoft is running a promotion on the paid tools through June 24, 2011. Buy the full suite and get 25% off or get 10% off of 3 pack of tools.
• You can get the book at this Amazon Link. The ebook version is available at Packt Publishing.

The 50 Tips Presentation is available at:

 http://www.box.net/shared/x4zui0ahi9

The Big Convergence Coverage Wrap Up

I was swamped this year with presentation sessions (6 Total), meetings and a little booth time so I stuck to Twitter as the fastest way to get stuff out. As did Matt Landis, Jon Rivers, Ray Wang, Japheth Nolt and a host of others.  I’ll have my Convergence 2011 thoughts out tomorrow, so for now, here is some blog stuff from others.

• DayONE hosted by GPUG (Sunday)
• Dynamics Community
• Dynamics GP Blogster
• Developing for Dynamics GP
• Part 2
• Day 2 (Monday)
• Dynamics GP Blogster
• Part 2
• Developing for Dynamics GP
• Part 2
• MSDynamicsWorld
• Part 2
• gp2themax
• Day 3 (Tuesday)
• Dynamics GP Blogster
• Developing for Dynamics GP
• Dynamics GP Land
• Dynamics Corporate Performance Management
• MSDynamicsWorld
• Day 4 (Wednesday)
• Dynamics GP Blogster
• Developing for Dynamics GP
• MSDynamicsWorld
• Belinda, the Dynamics GP CSI

Business Analyzer in GP 2010 R2

Of the items shipping in R2 for Microsoft Dynamics GP 2010, Business Analyzer got the most buzz at Convergence 2011 in Atlanta.

There are two new Features of the Day around Business Analyzer so you can start with those to see what all the buzz is about.

• http://blogs.msdn.com/b/gp/archive/2011/04/11/microsoft-dynamics-gp-2010-r2-feature-of-the-day-business-analyzer-desktop-application.aspx
• http://blogs.msdn.com/b/gp/archive/2011/04/13/microsoft-dynamics-gp-2010-r2-feature-of-the-day-business-analyzer-dynamics-gp-client.aspx

Weekly Review: Project Accounting Reference Transaction

There is no way to do a negative transaction in Dynamics GP Project Accounting for transaction types other than Misc. Log transactions. Or is there?
For Timesheets, Equipment Logs and Employee Expense you are stuck making adjusting transactions to reverse the original entry. Or are you?

Are you intrigued yet? Many people don't know that you can create a "Referenced" transaction in Project Accounting that allows you adjust a posted transaction.

For example, in a PA Timesheet transaction (Transactions->Project->Timesheet Entry), instead of leaving Transaction Type as STANDARD, click the drop down and change it to REFERENCED.

In Reference Doc Number, enter or lookup the timesheet transaction to adjust. In each line, select the project and cost category id to adjust. You can process negative amounts for this line but you can't subtract an amount that is greater than the original amount.

Adjustments can go both ways. You can subtract time from one project and add it to another for example. The original transaction does need to be posted, otherwise, just adjust the unposted original.
Referenced Transactions are available in Timesheet, Equipment and Employee Expense transactions. Inventory transactions have Return functionality instead and Miscellaneous logs allow negative.
Originally posted by Mark at 2/16/2009 09:00:00 AM

The Dynamics GP Blogster: How to schedule Dynamics GP to automatically log in and run an Integration Manager integration - revisited

Mariano revisits his post on How to schedule Dynamics GP to automatically log in and run an Integration Manager integration.

Security in Microsoft Dynamics GP 04/06 by pfeDynamics | Blog Talk Radio

Check out this podcast on Security in Microsoft Dynamics GP.

Supporting Online Systems with Dynamics GP - Mad Mark, the GP Road Warrior

My new article is up on the Dynamics Community site. It take a look at some options for Supporting Online Systems with Dynamics GP.

I know that you’re probably at Convergence but take a break and check it out anyway.

More Convergence Resources

Christina Phillips looks at specific Convergence reources in her new post Dynamics GP Land: Monday. Convergence. Atlanta.

Dynamics GP Land: Error Importing Custom VBA Windows on GP 2010

Steve Endow looks at an Error Importing Custom VBA Windows on GP 2010