SQL view for last sale date of item | Victoria Yudin

Victoria expands on her previous SQL view and now gives us a SQL view for last sale date of item .

Dynamics GP Land: Breaking It Down- New Budgets in Forecaster

Christina Phillips takes us through Breaking It Down- New Budgets in Forecaster.

The eOne Dynamics GP and CRM Blog: Have you heard about Node Builder

Apparently I touched a nerve with my MSDynamicsWorld.com article on Integration Frustration.There have been lots of great comments and a number of people mentioned Node Builder from eOne. I’ve seen the pre-release version of Node Builder and I’m looking forward to an updated look at Convergence.

Have you heard about Node Builder? If you haven’t, Martin at eOne has a new post to fill you in.

Dynamics GP Land: Where Oh Where Is My Integration Manager?

It must be integration week in the world of Dynamics GP. Christina Phillips helps you find your missing Integration Manager in Where Oh Where Is My Integration Manager?

The Future of Microsoft Dynamics GP: 5 Cool Technologies You Should Watch For (and Learn) in the Coming Years | MSDynamicsWorld.com

Mariano has a new article up at MSDynamicsWorld.com. In it he tackles The Future of Microsoft Dynamics GP: 5 Cool Technologies You Should Watch For (and Learn) in the Coming Years.

The Dynamics GP Blogster: Customizations for the View Indented Bill (bmViewIndentedBillInquiry) window failing for GP 2010

Mariano digs into an issue where Customizations for the View Indented Bill (bmViewIndentedBillInquiry) window are failing for GP 2010.

Microsoft Dynamics GP 2010 R2 Feature of the Day: Add Unified Communications Functionality in Extender

In a new Feature of the Day, Inside Microsoft Dynamics GP looks at new Unified Communications Functionality in Extender.

Weekly Review: Killing a Hung Integration

If you use Integration Manager with the Dynamics GP Destination adapters, at some point, you’ll end up with a hung session. Typically this happens when a when an integration fails but Dynamics GP does not return to availability.

The symptom of this is often a message about closing all windows prior to running the integration, even though all windows are closed.
When you run an integration with the Dynamics GP adapter (versus the econnect IM adapter) Dynamics GP must be open. When you click Run, GP disappears and reappears when the integration is complete.  What happens in the background is that Integration Manager writes to GP through the interface. The interface is hidden to improve speed and prevent interference. If the integration fails and GP does not reappear, GP may still be open in the background. If you open GP again, you actually have 2 GP sessions running and this is really confusing to Integration Manager.

There is a simple fix for this. Simply open up the Task Manager and kill the Dynamics task. Then reopen Dynamics GP and reintegrate. In very rare cases where this has not worked for me, rebooting always fixes the issue.

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

Microsoft Dynamics GP 2010 R2 Feature of the Day: Business Portal Migration Utility

The latest feature of the day from Inside Microsoft Dynamics GP is the Business Portal Migration Utility. The updates to the migration utility will enable customers to move their Business Portal customizations directly from Business Portal 3.0 to Business Portal for Microsoft Dynamics GP 2010. Checkout the whole post at Microsoft Dynamics GP 2010 R2 Feature of the Day: Business Portal Migration Utility - Inside Microsoft Dynamics GP .

The eOne Dynamics GP and CRM Blog: Ever Forgotten you wrote something?

Check out Martin's link to an Extender white paper. He was having a good day when he wrote it.

The eOne Dynamics GP and CRM Blog: Ever Forgotten you wrote something?

SQL view for last sale by customer and item | Victoria Yudin

Victoria Yudin delivers a new SQL view for last sale by customer and item. This got me thinking. With this as a base, I could figure out an average time between orders and then flag customers for followup if they haven't ordered recently. hmmm…

GP2themax - Helping users get the 'max' from Dynamics GP: How much of your ERP system do you actually use?

Frank Hamelly wants to know How much of your ERP system do you actually use?

Integration Frustration: Why Microsoft Dynamics GP Integration Tools Need a Kickstart | MSDynamicsWorld.com

My new article is up at MSDynamicsWorld.com. In Integration Frustration: Why Microsoft Dynamics GP Integration Tools Need a Kickstart I do a little venting on some recent integration frustration.

Microsoft Dynamics GP 2010 R2 Feature of the Day: Microsoft Dynamics Security Synchronization Utility

The latest Feature of the Day is the Microsoft Dynamics Security Synchronization Utility. This allows the synchronizing of roles across GP, Business Portal and Web Services.

SSRS Reports Performance Debugging and Analysis

MSSQLTips looks at SSRS Reports Performance Debugging and Analysis. If you’re supporting SSRS with Dynamics GP this is worth a look.

Microsoft Dynamics GP 2010 R2 Feature of the Day: ELS Elimination of Modal Forms

I’m catching up with Friday’s feature of the day. Inside Microsoft Dynamics GP took a look at ELS Elimination of Modal Forms. What does that mean for you? It allows the end-user to continue to work on, or close a form pending approval of an Electronic Signature. Pretty cool, read the whole thing for details.

Mohammad R. Daoud: 2011 MVP Certificate

Congratulations to Mohammad Daoud on the renewal of his MVP Certificate for Dynamics GP for another year.

Dynamics Confessor Blogspot: The Vendor ID is Missing or Invalid

Leslie Vail is posting about an error that shows The Vendor ID is Missing or Invalid in Ethotec’s Commission Plan product. She is kind enough to provide a resolution.

 

Integrating with Dynamics GP - Part II

Duke del Prado continues his look at a current integration project with Integrating with Dynamics GP with Part II.

Analysis Cubes and GP2010: More Retained Earnings Problems | DynamicsCare

Dwight Specht digs into Analysis Cubes and GP2010: More Retained Earnings Problems over at DynamicsCare.

The Dynamics GP Blogster: Opening a Microsoft Dynamics GP Extender window conditionally

Mariano looks at conditionally Opening a Microsoft Dynamics GP Extender window in a new post.

GP 2010 R2 Feature of the Day: List View Performance Enhancements - Inside Microsoft Dynamics GP

The latest Feature of the Day from Inside Microsoft Dynamics GP covers List View Performance Enhancements. I have to say, even from a 50 tips demo standpoint, I’m looking forward to improved List View performance.

Weekly Dynamic: Picking Your Cue

I love the new Cue’s in Dynamics GP 2010’s To Do list. It’s important not to forget that you have control over whether items appear as a Cue or a list.

From the Home Page, pick New Reminder. Check or uncheck the Cue box next to a prebuilt or custom reminder. Checking the box uses a cue, unchecking it displays a list.

A Space Alien’s Guide to Microsoft Convergence

Today I’m launching A Space Alien’s Guide to Microsoft Convergence as a way to present the upcoming Microsoft Dynamics Convergence customer conference in a different light. This short guide is just as the title describes, a Convergence primer for beings from other planets.

I’ve been experimenting with some very different ways to present usage cases for Microsoft Dynamics GP. You’ll see some of those in the very near future. They aren’t just out of the box, I burned the box.
Frankly I think that my brain is rebelling from writing articles, blog posts, best practices guides and whatever else. It’s now insisting on writing fiction. In this particular case I’m bored with all of the guides to Convergence, including my own, so I decided to push the envelope.

The PDF version is a free download but you’ll need to register. Don’t worry, I won’t spam you or sell your name. I’m trying to collect information to better understand who might be interested in more of this type of thing.

I’ve also been wanting to play with publishing to Amazon’s Kindle and this looked like an opportunity to experiment. As a result, there is a native Kindle version of this very short document available on Amazon. For my U.K. friends, don't worry, there's a U.K. Kindle store version as well. Unfortunately, Amazon won’t let me publish a free Kindle story. So if you want the native Kindle experience you’ll have to drop 99 cents.

(Not being able to publish free stuff actually makes sense. Amazon pays Sprint for wireless delivery to Kindle devices but they don’t charge customers a monthly fee for the service. Amazon has to pay for it somehow and not filling up the Kindle store with free stuff is one way. There is free stuff for the Kindle but Amazon controls what’s free.)

There are more tales ready to launch. Frankly, I've had so much fun writing them that I'll probably keep at it regardless of the feedback but I'd love to hear what you think. Feel free to leave a comment on the blog, drop a tweet, Like this post on Facebook or email me.

Mohammad R. Daoud: Receivables Management Return Account

Mohammad Daoud looks at the lack of options for multiple Receivables Management Default Return Accounts.

Make Your Accounting Department More Efficient

I’m finally digging through some articles that I had marked to blog about. In the December 2010 issue of the Journal of Accountancy, CPA Tom Sonde looks at ways to Make Your Accounting Department More Efficient.
I was struck by how many of the points we’ve already covered with respect to Dynamics GP. In short, if you’re looking to make your Accounting Department more efficient with Dynamics GP, you’re already using one of the best resources available, DynamicAccounting.net
From Tom’s article:

• Conduct process walk-throughs.
• We’ve looked at a number of different processes ripe for improvement in Dynamics GP including:
• Vendor 1099’s
• Daily Bank Reconciliations
• Partial Month End Closing
• And lot’s more
• Use best practices.
• We’ve seen best practices around
• Partial Month Closing
• Use Tax
• Plus others
• Take advantage of unused system functionality.
• I’ve covered so many of these items in Weekly Dynamic’s that it’s silly.
• Plus, Frank and I are doing a session (UBGP11) on exactly this on DayONE at Convergence. 
• Conduct process training.
• Our webinars can help with this.
• Develop system “super users.”
• Why you need a champion
• Establish process metrics.
• Yep, we’ve got those too 
• Reward success.
• Maybe with a Convergence pass?
• or some Friday Fun?

Make sure to read the whole article for details.

Weekly Review: Two Way Match as a Best Practice

A three way match of PO+Receipt+Invoice is the typical process for PO processing. However, in some scenarios, a two way match is preferred because it's more efficient. Essentially the company chooses to pay from the receiving not waiting for an invoice. This is really efficient when price agreements between the company and vendor are consistent. Also in a high turnover environment, invoice differences will never make it to the product because the product will be gone long before the invoice arrives so the vendor may agree to forgive price differences in exchange for faster payment. After all, by paying from the receipt, the company eliminates a lot of time and effort chasing down small variances.

It is incredibly simple to accomplish a two way match in GP. When processing a Receiving simply pick Shipment/Invoice as the Receiving Type. This processes a receiving and invoice as one transaction thus completing the two way match.

If you're looking to do two way matching, it doesn't get easier than this.

Originally Posted by Mark at 1/26/2009 09:00:00 AM

Top 100 Most Influential Microsoft Dynamics People for 2011 (New Links)

The links are moving around for the voting for the 100 Most Influential People in Microsoft Dynamics for 2011. John Lowther thankfully compiled a new list of link over at Top 100 Most Influential Microsoft Dynamics People for 2011 (New Links).

I don’t pretend to understand the idea behind moving all of these round but now I’m at the bottom of poll 4. You can keep voting!

GP 2010 R2 Feature of the Day: Business Portal External Lists

In a new Feature of the Day, Inside Microsoft Dynamics GP looks at Business Portal External Lists.

Dynamics GP Land: More Payroll Troubleshooting Scripts, Enjoy!

Christina Phillips is also popping out More Payroll Troubleshooting Scripts, Enjoy!

WAQAS BUTT : Dynamics GP Project Accounting Reports - Project Analysis Budget Vs Actual By Cost Categories

Waqas Butt is still churning out Project Accounting reports. His latest is Project Analysis Budget Vs Actual By Cost Categories

The eOne Dynamics GP and CRM Blog: GP for $195 per month

eOne digs into cloud computing for ERP and how the economics change things for partners, ISVs and customers. Check out GP for $195 per month for more.

WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Dynamics GP Project Accounting Reports

Waqas Butt continues delivering Project Accounting SQL with Project Gross Margin and Projects Summaries Budget Vs Actual.

Management Reporter – Did you know…? (#3) - Dynamics Corporate Performance Management

Dynamics Corporate Performance Management shows off some new thoughts around Building Blocks in Did you know…? (#3).

Dynamics GP 2010 R2 Feature of the Day: Ability to Copy Email Messages - Inside Microsoft Dynamics GP

Adding to the growing pile of Features of the Day, Inside Microsoft Dynamics GP shows off the Ability to Copy Email Messages

What to do about Accounts that won’t show up in FRx | FRxBuzz

FRx Buzz looks at What to do about Accounts that won’t show up in FRx.

Available to Promise. Helps you keep your promises! - Dynamics GP Blog

Dynamics GP Blog has a new look at how Available to Promise. Helps you keep your promises.

Customizations to the Cash Receipts (RM_Cash_Receipts) window failing for GP 2010

Over at Developing for Dynamics GP, David Musgrave looks at Customizations to the Cash Receipts (RM_Cash_Receipts) window  and why they may be breaking in GP 2010.

Feature of the Day: Substitute Fields for Email - Inside Microsoft Dynamics GP

Catching up with Inside Microsoft Dynamics GP, I see a new Feature of the Day: Substitute Fields for Email .

WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Dynamics GP Project Accounting Reports - Project Summaries Sheet

Waqas Butt adds to his Dynamics GP Project Accounting reports with Project Summaries Sheet.

Weekly Dynamic: Control the Sale of Discontinued Items with a Password

In pas 50 Tips in 50 Minutes presentations I’ve shown off the ability to prevent the sale of discontinued items. But the setting is all or nothing. You can’t control it by Item. However, you can control it with a password.

On the Sales Area Page under Setup pick Sales Order Processing and Options. Find Allow the Sale of Discontinued Items and check the box to allow the sale. Next to the setting enter a password. Now when you pick a discontinued item to sell, a password box will pop up. This gives you the choice at the time of the transaction to decide whether or not to allow the sale of discontinued items.

Dynamics GP Land: Update to "File Not Found: VBA6.dll" with GP 2010 and Office 2010

Dynamics GP Land lets us know that Beth Gardner has updated her posts on the VBA6.dll issue with GP 2010 and Office 2010.

Microsoft Dynamics Top 100 Most Influential People for 2011 voting is open - Developing for Dynamics GP

David Musgrave has kindly listed out the GP people in each of the various Microsoft Dynamics Top 100 Most Influential People for 2011 polls. I’ve sent him a few he missed so expect and update but this is a great list. Stuff the votes for Dynamics GP.

WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Dynamics GP Project Accounting Reports - Project Analysis % of Completion

Waqas Butt delivers some new project accounting reports in the form of SQL code and Crystal Reports at Dynamics GP Project Accounting Reports - Project Analysis % of Completion

I.B.I.S., Inc. Will Unveil the Latest Version of Field Service Anywhere at Microsoft Convergence 2011

Via DynamicsCare (and Jack giving me a little demo today) I.B.I.S., Inc. Will Unveil the Latest Version of Field Service Anywhere at Microsoft Convergence 2011.

Hint, there’s ribbons involved.

Ability to Create Email Messages - Inside Microsoft Dynamics GP

In a new Feature of the Day, Inside Microsoft Dynamics GP looks at GP’s Ability to Create Email Messages.

Weekly Review: Assign AP Staff to Specific Suppliers

A Purchasing best practice is to assign AP staff responsibility for certain vendors. This provides point of contact service for the vendors and helps balance the workload in a large AP environment. One easy way to accomplish this in Dynamics GP is to use the Payment Priority field. (Cards-Purchasing-Vendor, Options) This is a 3 digit, alpha-numeric field and it's easy to use an AP clerk's initials or employee number in here.

There are advantages to using the Payment Priority field over other available fields like User Defined 1 or Vendor Class. Payment Priority is one of the options for selecting checks to print. This means that it's possible to print a batch of checks just for a single clerk's vendors. If the clerk has responsibility for attaching backup prior to signing or stuffing and mailing checks after signing this can be a big help, especially if the vendor assignments are non-contiguous. You can accomplish the same thing with Vendor Classes but Vendor Classes drive so many other settings that confining it to just this use is wasteful.

If assigned vendor ranges are contiguous based on vendor name or number(A-D goes to one person, E-G another, etc.) then User Defined 1 will also work since checks could be controlled by the vendor name or ID. But when there are a couple large vendors and many small ones contiguous ranges can be very difficult to maintain.
The point is that assigning vendors to individual AP clerks is a best practice and there are several ways to accomplish that. I prefer Payment Priority but there are lots of options to choose from.

Originally Posted by Mark at 1/19/2009 09:00:00 AM

Dynamics GP Land: Forgot the FUTA? Slacking on SUTA? Fix it now!

Christina Phillips delivers a couple of SQL Scripts for working with payroll in her new post Forgot the FUTA? Slacking on SUTA? Fix it now!

Unknown identifier 'DYNAMICS' or other Constant with GP 2010 SP1 - Developing for Dynamics GP

David Musgrave digs into an Unknown identifier 'DYNAMICS' or other Constant error with GP 2010 SP1

Feature of the Day: Ability to Email Reports - Inside Microsoft Dynamics GP

New Ability to Email Reports is the Feature of the Day at Inside Microsoft Dynamics GP.

Dynamics GP2010 Word Templates and Activating the Developer Tab in Word

Amy Walsh look at Dynamics GP2010 Word Templates and Activating the Developer Tab in Word over at DynamicsCare.

Tips for Using the Control Panel Applet and Service for Dexterity Source Code Control - Developing for Dynamics GP

Alice Newsam give us Tips for Using the Control Panel Applet and Service for Dexterity Source Code Control  over at Developing for Dynamics GP

Feature of the Day: Word Template Generator - Inside Microsoft Dynamics GP

In a new Feature of the Day, Inside Microsoft Dynamics GP looks at the new Word Template Generator.

Vote! Vote! Vote!

DynamicsWorld.co.uk is back with the 2011 edition of the 100 Most Influential People in Microsoft Dynamics. The nominations are closed and now it’s YOUR TURN to vote.

All your favorites are up there, Mariano, Leslie Vail, Dwight Specht, David Musgrave and on and on and on. And on and on and still on. The nominees are broken up into groups so you’ll have to hunt for your favorites.

I’m in the back in Poll 13. Last year I was number 28 on the list, which frankly, seemed high to me, but I would still love to see you vote for me or any of the other nominees. Especially the Dynamics GP nominees. Let’s load the the final list with GP people.

I’ve already voted for every GP person that I can find on the list and I’ve voted for Andy Vabulas, Dwight Specht and Clinton Weldon twice since they influence not only Microsoft but my own work with Dynamics GP.

All of the nominees and voting polls are available and it looks like each poll will be highlighted over the next six weeks as well. As the saying goes in Chicago politics, vote early and vote often!

Dynamics GP – Field Level Security | DynamicsCare

Amy Walsh has a very detailed look at using Field Level Security in Dynamics GP. This is definitely worth a look.

Management Reporter Installation - Lessons Learned Part II - iSolutions

iSolutions follows up with part 2 of their Management Reporter Installation - Lessons Learned

Feature of the Day: Script Editor Names Window - Inside Microsoft Dynamics GP

More Dexterity improvement are here as a part of the Feature of the Day: Script Editor Names Window

MBS Guru: Ooops! I marked a SOP Line as Drop Ship after I fulfilled it

Michael Johnson tackles accidentally marking a SOP Line as Drop Ship after its been fulfilled

New Features for Dexterity for GP 2010 R2 - Developing for Dynamics GP

David Musgrave rounds up all of the New Features for Dexterity for GP 2010 R2 in his new post. You've seen some of these as Daily Features but Dave has them all in one place.