Archive for May, 2011

EFT for Payables

Dynamics GP has included for a long time, the ability to easily create EFT payments in conjunction with the normal payables check writing process.  The setup is pretty straight forward, and actually creating the EFT file is easy.

These are the general setup steps:

  • Setup the EFT file format:  Financial >> Cards >> EFT Setup
  • Set up EFT for specific banks:  Financial >> Cards >> Checkbooks
  • Set up EFT for Specific vendors:  Purchasing >> Cards >> Vendors

The biggest challenge here is defining the correct EFT file format.  Hopefully your bank will use one of the standard file formats that are available in Dynamics GP.  If not, you will have to request the specific format instructions from your bank and use the configurator functionality in EFT for Payables to create a customized file format.

These are the general steps for creating the EFT file:

  • Create a check batch; being sure to select the ‘EFT’ option on the Payables Batch Entry screen
  • Build your batch as you normally would
  • Process the payments
  • Print the remittance forms (select to send via e-mail if you wish)
  • Post the batch
  • Generate EFT file:  Purchasing >> Transactions >> Generate EFT File

Once you’ve done this you can send the EFT file to your bank in the manner prescribed by your bank.

Here is a short video about EFT for Payables with Dynamics GP.

Credit Card Batch Processing

If you need to quickly create credit card payments for a large batch of sales documents in Dynamics GP, take a look at the Credit Card Extension module from Azox

A client recently was looking for a solution that could create invoices and credit card payments, and process the credit card payments with a minimal amount of manual attention.  I proposed a solution including Integration Manager and the Azox Credit Card Extension. 

I use Integration Manager to create the SOP invoices in GP from a source file from

The Azox solution allows me to easily handle a large number of documents and monitor the authorization and settlement process for the credit card transactions.  The approved credit card transactions show up as deposits on the SOP invoice screen.

I created this short video to show this in action:

Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2011

headshot of Doug blog

Once again I was snubbed on the 100 most influential list. I was so ticked. Maybe not as ticked as David Musgrave or Frank Hamelly but I certainly think the refs should have look at the replay to even see if it was close. I’m not sure if being snubbed is the right term in my case as I wasn’t even nominated nor do I really have any influence over Dynamics as a whole.

But every year when the results come out I think it would be so cool to see my name in lights. So in an effort to avenge the wrongly omitted and blatantly offended I’m making up my own famous people list.

There is no analytical merit to the people selected so if you feel like you belong on this list I think things can be arranged in exchanged for a little chocolate or underground dance videos of your favorite bloggers.

So without further ado here is Doug Pitcher’s 100, 50, 37 Most Famous, Awesome, and Totally Influential Dynamics People List for 2011. (Hey, creating a 100 person list is harder than it seems and I have to get back to some real work. How else am I going to become famous on a real top 100 list.)

  1. Doug Pitcher – It’s my dang list so I’m putting my name at the top
  2. Linda Rose – A pioneer and trend setter in the hosting world. One of the brightest, most forward thinking persons I’ve ever worked with.
  3. David Musgrave – Hosed out of being a top 100 most influential person on a slightly more formal list I’m giving you top billing here David.
  4. Mariano Gomez – Famous to the point I feel bad for even putting him #4. I’ll try to do better next year Mariano.
  5. Frank Hamelly – Another one who was wrongfully mistreated in the 100 most influential poll. Hope you consider this placement as consolation.
  6. Mark Polino – Mr. Cookbook himself. Anyone that can write an entertaining book about Dynamics must be doing something right. Mark lists off some missing people from the top 100 list. I wonder if I buy 50 cookbooks Mark would put me on the list.
  7. Leslie Vail – Keep putting secretly recorded dance moves out on YouTube and you’ll be on this list year after year.
  8. Victoria Yudin – Great blog that has SQL scripts galore on anything you need in Dynamics.
  9. Mohammad Daoud – Got to give some shout outs to my fellow blogging buddies. Not that Daoud needs any more credit as he’s on the list himself and graciously accepts his nomination.
  10. Christina Philips – Another Blogger extraordinaire.
  11. Kirill Tatarinov – OK, the head of MBS Dynamics should get some love.
  12. Terry Heley – Payroll guru at Microsoft that gives us all the inside scoop via an underground email system. She’d be even more famous I’m sure if she’d put her stuff out on a blog.
  13. Patrick Roth – Pretty smart cookie on the Developing for Dynamics blog. I always filter on the site for his articles as they are usually pretty good.
  14. Steve Chapman – YouTube video king. I love walking around with Steve as people ask for my autograph just because they think I must be famous if Steve will hang out with me.
  15. Rebecca Bunas – Even bigger rock star than Steve Chapman. I now refuse to walk any where with Rebecca as it usually turns into a two hour journey as we have to stop and talk to everyone she knows.
  16. Errol Schoenfish – I don’t know Errol personally but hear he’s a good guy. At least we all know where he lives and what his house looks like from Convergence in case you wanted to stalk him.
  17. Mark Rockwell – Who doesn’t like the crazy outfits and personalities of all the Rockton folk.
  18. Nick Hoban – Microsoft Dynamics Community guy. I asked if he could pull some strings and make me an MVP but he said I had to be more useful and not post so many silly blog articles. How am I doing Nick?
  19. Don Morton – Football coach, mentor and site leader over the Dynamics Academic Alliance (DYNAA)
  20. Bethany Eighmy – Part of the DYNAA team that brought myGPcloud to universities
  21. Lyndsey Creamer – the other part of the DYNAA team that brought myGPcloud to universities
  22. Jesse Byam – Canadian guy that walks around in shorts. If you don’t know Jesse you ain’t having any fun.
  23. Anya Ciecierski – I couldn’t spell her name so had to wait until I looked it up to put her on the list.
  24. Chris Dew – I’m most familiar with the back of Chris’s head as that’s all I usually see on our annual sunrise scramble foray at the Partner Event. eOne guy.
  25. Francisco Garcia Hillyer – Breaking into the top 100, 50, 37 list for the first time is F.G.H. He’s been a Microsoft guy for many years and now is an active blogger. One of the smartest support person I know so am glad he’s there to bail me out from time to time.
  26. Terry Carlton – I just like Terry so I’m putting him on the list.
  27. Donte Kim – Nodus founder
  28. Asher Mathew – Used to work for Nodus but I think has moved to Avalara. At least that’s what the 100 emails I got announcing the event said.
  29. Vaidy Mohan – Another blogging buddy.
  30. Cheryl Mortvedt – Fellow support person whom I usually team up with to beat up on unsuspecting Microsoft support people at the annual partner advantage meetings.
  31. John Stulak – Ethotech founder. Went to Costa Rico to bring sales commissions to the monkeys.
  32. Richard Whaley – That professor guy that has all those training books.
  33. Jennie Davis – The partner channel head hauncho
  34. Mike Feori – Famous tomato harvester and application consultant
  35. Liane McIlraith – If Liane doesn’t know it no one knows it. Every client I know loves Liane.
  36. Doug White – Grumpiest guy I know but one heck of a systems architect.
  37. Dwight Specht – Late entry. I met Dwight at a DYNAA event thing but didn’t really get to talk to him much. But love his style especially in his follow up to being included in the 100 list.

OK, so there you have it. I’m sure there are many deserving candidates but the vote was unanimous for the above on the first annual Pitcher Top 100 list.

Maybe next year I’ll actually get 100 people on the list. Ping me if you want to see your name on the above list and I’ll do a recount and adjust accordingly.

User Stories–Thinking outside the box

Hello all, a few days ago, I was helping my friend Doug Pitcher covering support while he avatarwas spending the dollars, so I answered a call from one of our customers, she was not able to change her password used to access the server where Dynamics GP lives on her company.

It was a nice call so far, she was giving a thought on what her password should be and finally she says “I know which one I am going to use” and then I say “please do not use your home address” she replied with a laugh saying “how did you knew?” so I just said well it’s common on users to do that, then she kept thinking a bit more when I saw her enter her password, but again she was receiving errors, so I asked her “remember do not use a password that was previously used before, it should not contain parts of your name or last name it should include a Capital letter and at least one number” when I was frozen by the question “Should I enter uppercase or lowercase numbers?”.

What?…. wait a second did I heard it right? so I asked “can you repeat that?” and she said it again “uppercase or lowercase numbers?” at first I must say I was at the point to break in a laugh but I do respect our customers and try to understand them so for a few nanoseconds my mind went into a spiral when all of the sudden I had a revelation!!!!.

So I asked “Could you please tell me, are you using a laptop or a desktop?”

she replied “A desktop…” then my mind workflow was in the correct path then I asked

“How are your uppercase numbers organized"?” when she replied “They are above QWERTYUIOP” and then I asked “how are your lowercase numbers organized “ when she said “on the right part of my keyboard right next to the arrows….” so I said “use your lowercase numbers” after a few moments she replied “my lowercase numbers are not working…” this is an easy fix I said “press the Num Lock” on your lowercase number area and they will work”


Finally I was able to help her reset her password but I kept thinking on it as I have a laptop with regular keyboard not the extended version I saw that sometimes you have numbers on the letters M,J,K,L,U,I,O that are smaller than the key letter, so should that have been the case I know that I can find lowercase numbers on my laptop.


Now I have shared this true story behind the Customer Service Desk and I hope you like it, and I would like you to share one of your memories while working with users and Dynamics GP.

Have a great Day!!

Intercompany Processing with Dynamics GP

Intercompany Processing is a standard feature of Dynamics GP.  It allows you to create transactions in one company and simultaneously create corresponding entries in one or more other company databases.  This functionality ensures that company databases are kept properly balanced, corresponding transactions in all companies are recorded, and maintains accurate related party balances.  The setup is really simple, and transactions can be processed in the general ledger and accounts payable modules.

In the setup screen you identify the “Due to” and “Due From” accounts that will be used when intercompany transactions are posted.  This helps you identify intercompany balances.  Here’s an example of the setup screen:

When you enter an intercompany transaction, you will need to specify that it is an intercompany transaction, and the transaction will need to be posted in a batch.  Transactional posting is not allowed.  You will specify which company or companies will be used in the transaction.  If you look-up account numbers for the distribution, you will be looking at the chart of accounts for the pertinent company.

This edit list shows the original distributions that were entered into the transaction and the “Due to” and “Due From” distributions that are automatically created based on the Intercompany Setup.

Once you post the batch, the appropriate transactions will be created in the specified company datababases, and will be held in a general ledger batch awaiting your review and posting.

Note:  If you’re using Integration Manager to create Intercompany Transactions, you will need to omit the segment separators from your account number strings.

Here is a simple demo I made to show this in action:

Subscription Options:
Subscribe via RSS
Articles Categories