You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
28 September 2012
Friday Fun: Best Big Bang Theory Skit Evaaaah
When they started chanting CPA, CPA, CPA! I teared up.
26 September 2012
Using the Named System Database Feature for Microsoft Dynamics GP 2013 - Developing for Dynamics GP - Site Home - MSDN Blogs
Aaron Donat clarifies Using the Named System Database Feature for Microsoft Dynamics GP 2013. If you're a partner you should read this.
25 September 2012
GPUG Summit 2012 Registrations Top Last Year’s Record-Setting Attendance
Since we're talking conferences, I see that the GPUG Summit 2012 Registrations Top Last Year’s Record-Setting Attendance. I'm going to be there. You can come too. Don't worry, your desk will still be there when you get back. You won't get any work done if you stay home because you'll be following us on Twitter and Facebook and blogs so you might as come and be part of the fun.
New Convergence 2013 Website Launched
Are your ready for Convergence 2013!?!...Wait that's in...ye but there is still a New Convergence 2013 Website.
Dynamics GP Land: Developer Gripe: "An unknown error has occurred"
Steve Endow goes on a mini-rant in Developer Gripe: "An unknown error has occurred". I love mini rants.
Introducing a New Program for Accounts Receivable Professionals
Here is the official announcement Introducing a New Program for Accounts Receivable Professionals
Dynamics GP Land: Dimension Filters in Columns in MR 2012
Christina Phillips breaks and fixes things around Dimension Filters in Columns in MR 2012
How GP 2013 will handle Unit Accounts | Dynamics University
Gina Hoener breaks the good news on How GP 2013 will handle Unit Accounts . I didn't even think to check my beta copy.
The State of Self-Service Reporting - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
SQL Server MVP Paul Turley has an incredibly well written piece on The State of Self-Service Reporting.
All of these apply to Dynamics GP and at I.B.I.S. we've used all of them with various clients (well, except for maybe Power View on Excel. 2013 since that technically hasn't been released yet. I'm playing with it for my next GP book).
Seriously, you need to read this.
All of these apply to Dynamics GP and at I.B.I.S. we've used all of them with various clients (well, except for maybe Power View on Excel. 2013 since that technically hasn't been released yet. I'm playing with it for my next GP book).
Seriously, you need to read this.
Dynamic Future - An Imagined Conversation Around GP 2013 New Features
I'm working through new stuff in GP 2013 as part of my joint session with Errol tomorrow and frankly, all of my favorite new features won't fit in the time that I have to present. I figured most users wouldn't mine if went a little long, by like 3 hours, but 'they' said no, I have to choose. It's not quite like choosing between my children because let's face it, buying Dynamics GP is way cheaper and less smelly than having a child, I mean a teenager but and infant could work too there I guess. But I digress.
I'm skipping the vote this week to reflect on all of the cool stuff we asked for that made it into GP 2013. Things like depreciation undo, printer selection, P.O. prepayments and clearing unit accounts at year end. Oh and there is better SSRS integration and tolerance handling and...there I go again. So I thought that I would leave you with a short tale (I mean story, tail is the thing that wags) that I'm certain, is probably not very true, mostly.
This conversation almost certainly didn't take place in a unnamed hallway in an out of way building on Microsoft's Fargo campus between an unnamed program manager and an generic Dexterity developer, when Dynamics GP 2013 was merely a gleam in Marketing's eye.
Program Manager: So the world is moving to the cloud and so are we. We need to make the future of Dynamics GP cloudy.
Developer: Um, you mean like MAS 90?
Program Manager: No, I mean that we have to build a web client for the next version of Dynamics GP.
Developer: Funny you should mention that. In what little work time I have left after reading all of Mark Polino's blog posts every day, I had lunch with a robot space alien that gave me a magical box that turns Dexterity into HTML...or maybe I wrote it myself and you're just not paying me enough. Either way, I live in Fargo so it's all good, eh.
Program Manager: That's great! But we can't just ship a web client. Users will want more than that. It's not like we're Oracle and we can keep raising enhancement fees without delivering any value. Besides, Polino already suspects that Musgrave uses alien technology for the Support Debugging Tool. We're going to need to add more features as a diversion. But where do we get them from?
Developer: Hey, what about Microsoft Connect? You know, that website where users can suggest and vote on new feature for the next release of Dynamics GP.
Program Manager: I keep talking about that but I didn't know that anyone actually uses it. Dust that off and see what you can find. I know that we need some Fixed Asset stuff. People whine at me about Fixed Assets all the time. Maybe some more reporting thingies. Reporting is like Chinese food. People want more 20 minutes after you give them something great. Oh and we need name for the new product. Something Marketing can't say no to. Maybe 'Dynamics GP Super ERP Software of Greatness...with Bacon'? You can never go wrong with bacon.
------------
This was definetly, assuredly not how Microsoft Dynamics GP 2013 probably got all of those great new features that we've been asking for.
I'm skipping the vote this week to reflect on all of the cool stuff we asked for that made it into GP 2013. Things like depreciation undo, printer selection, P.O. prepayments and clearing unit accounts at year end. Oh and there is better SSRS integration and tolerance handling and...there I go again. So I thought that I would leave you with a short tale (I mean story, tail is the thing that wags) that I'm certain, is probably not very true, mostly.
This conversation almost certainly didn't take place in a unnamed hallway in an out of way building on Microsoft's Fargo campus between an unnamed program manager and an generic Dexterity developer, when Dynamics GP 2013 was merely a gleam in Marketing's eye.
Program Manager: So the world is moving to the cloud and so are we. We need to make the future of Dynamics GP cloudy.
Developer: Um, you mean like MAS 90?
Program Manager: No, I mean that we have to build a web client for the next version of Dynamics GP.
Developer: Funny you should mention that. In what little work time I have left after reading all of Mark Polino's blog posts every day, I had lunch with a robot space alien that gave me a magical box that turns Dexterity into HTML...or maybe I wrote it myself and you're just not paying me enough. Either way, I live in Fargo so it's all good, eh.
Program Manager: That's great! But we can't just ship a web client. Users will want more than that. It's not like we're Oracle and we can keep raising enhancement fees without delivering any value. Besides, Polino already suspects that Musgrave uses alien technology for the Support Debugging Tool. We're going to need to add more features as a diversion. But where do we get them from?
Developer: Hey, what about Microsoft Connect? You know, that website where users can suggest and vote on new feature for the next release of Dynamics GP.
Program Manager: I keep talking about that but I didn't know that anyone actually uses it. Dust that off and see what you can find. I know that we need some Fixed Asset stuff. People whine at me about Fixed Assets all the time. Maybe some more reporting thingies. Reporting is like Chinese food. People want more 20 minutes after you give them something great. Oh and we need name for the new product. Something Marketing can't say no to. Maybe 'Dynamics GP Super ERP Software of Greatness...with Bacon'? You can never go wrong with bacon.
------------
This was definetly, assuredly not how Microsoft Dynamics GP 2013 probably got all of those great new features that we've been asking for.
24 September 2012
Feature of the Day: Update Item Allocation Inquiry in Field Service - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Microsoft's latest Dynamics GP 2013 Feature of the Day: Update Item Allocation Inquiry in Field Service is up now.
Mohammad R. Daoud: Web Client with Multiple GP Instances
Mohammad Daoud explains Web Client with Multiple GP Instances
Performance Issues with Microsoft Dynamics GP? Let’s Get You to the Right Technical Support Team!
From the GP Support Team: Performance Issues with Microsoft Dynamics GP? Let’s Get You to the Right Technical Support Team!
We've used both the white paper mentioned in the post and performance troubleshooting from Microsoft and I can highly recommend them both.
We've used both the white paper mentioned in the post and performance troubleshooting from Microsoft and I can highly recommend them both.
Weekly Dynamic: Prevent Posting
This has come up a couple of times recently so I thought I would cover it here.
The scenario is a company wants users to have the ability to enter journal entries but only allow certain users to post to the GL. One answer is to prevent transaction and series posting and require batch approval with a password. This works but requiring an approval requires approval for ALL GL posting including posting from subledgers.
Another way is to control posting through security. Security to posting is controlled via the "Series Posting Permission" type in Security Tasks. By default GL Posting is included in the TRX_FIN_003* and ADMIN_COMPANY_11* tasks. Yeah, you didn't see the ADMIN_COMPANY_11* task coming did you? It also includes batch recovery so more users may have this than you think.
This why I recommend that you don't rely on the default tasks and roles. You really need to know what in there.
[HT to David Musgrave when I brain farted with this. I missed the ADMIN_COMPANY_11* role]
The scenario is a company wants users to have the ability to enter journal entries but only allow certain users to post to the GL. One answer is to prevent transaction and series posting and require batch approval with a password. This works but requiring an approval requires approval for ALL GL posting including posting from subledgers.
Another way is to control posting through security. Security to posting is controlled via the "Series Posting Permission" type in Security Tasks. By default GL Posting is included in the TRX_FIN_003* and ADMIN_COMPANY_11* tasks. Yeah, you didn't see the ADMIN_COMPANY_11* task coming did you? It also includes batch recovery so more users may have this than you think.
This why I recommend that you don't rely on the default tasks and roles. You really need to know what in there.
[HT to David Musgrave when I brain farted with this. I missed the ADMIN_COMPANY_11* role]
21 September 2012
Expectations around iSight 2012
So are you sick of hearing about the GP 2013 web client yet? The buzz from the Technical Airlift has been like a chainsaw.
iSight 2012 is next week in Atlanta and Charlotte. Errol Schoenfish will be with showing off GP 2013 and we want to make sure that you see a pretty complete picture of what's coming in December. Errol is giving me the priviledge of demoing some of my favorite new features in GP 2013. I'm excited about the web client, but I don't want you to think that's all there is. So, we're going to look at a cross section of features that are coming and give you a good look at Dynamics GP 2013.
Then I get to present another set of all new 50 Tips for Dynamics GP in 50 Minutes. The day is going to be a great mix of what's coming and how to get the most out of what you have now. I'm looking forward to seeing everyone there.
iSight 2012 is next week in Atlanta and Charlotte. Errol Schoenfish will be with showing off GP 2013 and we want to make sure that you see a pretty complete picture of what's coming in December. Errol is giving me the priviledge of demoing some of my favorite new features in GP 2013. I'm excited about the web client, but I don't want you to think that's all there is. So, we're going to look at a cross section of features that are coming and give you a good look at Dynamics GP 2013.
Then I get to present another set of all new 50 Tips for Dynamics GP in 50 Minutes. The day is going to be a great mix of what's coming and how to get the most out of what you have now. I'm looking forward to seeing everyone there.
20 September 2012
Integration Manager–Importing over 255 characters
Francisco covers Integration Manager–Importing over 255 characters. Nicely done.
Feature of the Day: Update 1099 Information - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
1099's get a facelift in GP 2013. Learn more at Feature of the Day: Update 1099 Information
The Dynamics GP Blogster: Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 1
Mariano is hacking his way through Windows 8 and the GP web client in:
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 1
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 2a
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 2b
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 1
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 2a
Windows 8 and the Microsoft Dynamics GP Web Client Series - Part 2b
Weekly Review: POP Invoice Match Extended Price
Here’s the scenario: in POP you go to match an invoice but you can’t quite get quantity and unit price to equal the extended price you need to match too. Usually this is because there aren’t enough decimal places defined for quantity or unity price.
The fix for this is easy. Set the quantity and force the extended price field
to be what you want. GP will automatically adjust the Unit Price. This works
even if there aren’t enough decimal places defined, GP still forces the unit
price and deals with the decimal places behind the scenes.
This also works for P.O.’s, Receivings and SOP transactions. It’s also a great way to make sure integrations are right. Integrate the quantity and extended price and let GP figure out the unit price.
This also works for P.O.’s, Receivings and SOP transactions. It’s also a great way to make sure integrations are right. Integrate the quantity and extended price and let GP figure out the unit price.
19 September 2012
Feature of the Day: Edit Remit To Address - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
GP 2013 Will let you edit the Remit To address on a posted payable. Find out more at the Feature of the Day: Edit Remit To Address.
I love the idea of this feature but I makes my CFF (Certified in Financial Forensics) certification twitch. You're going to have to control this or risk having all of your payments remitted to my home address. (Let me know if this is what you really want, I can set it up today.) That's why vendor setup and vendor address setup are almost universal control points for auditing tools like Fastpath.
I love the idea of this feature but I makes my CFF (Certified in Financial Forensics) certification twitch. You're going to have to control this or risk having all of your payments remitted to my home address. (Let me know if this is what you really want, I can set it up today.) That's why vendor setup and vendor address setup are almost universal control points for auditing tools like Fastpath.
About Dynamics, Development and Life: Dynamics GP 2013 Web Client Beta Troubleshooting
For folks starting to play with the GP 2013 beta web client, Jivtesh offers some Dynamics GP 2013 Web Client Beta Troubleshooting tips. Keep in mind that this is beta software and performance optimization usually comes at the end of the cycle before release.
Celebrity Corporate Performance Management
I 'm working with a client using deFacto this week. deFacto is Corporate Performance Management software for businesses who are serious about reporting, budgeting and analytics. If you're choking on MR or FRx performance or if you want to actually integrate budgeting into the process look at deFacto.
Just for fun there is another benefit to working with deFacto. This weekend a movie was on co-staring Liev Shcreiber. Liev bears a striking resemblance to deFacto's Anthony D'Anna. Can you tell which one is which?
Just for fun there is another benefit to working with deFacto. This weekend a movie was on co-staring Liev Shcreiber. Liev bears a striking resemblance to deFacto's Anthony D'Anna. Can you tell which one is which?
 |
 |
Neither can I! This means that with deFacto you get you're own celebrity look alike!
Just to thoroughly embarrass Anthony (who by the way is a genuinely nice guy and pretty smart, in addition to looking like a celebrity) IMDB says that Liev's upcoming project, Fading Gigolo, is in pre-production. I'm just going to leave it at that. Anything else I say will get me in trouble.
Actually, I feel bad for Anthony. Liev got to work with Angelina Jolie in Salt. Anthony gets to work with me...and Dwight, clearly he is underpaid.
GP PowerPack — WilloWare
The good folks at WilloWare continue to be ahead of the curve with their GP PowerPack . Updates to the GP PowerPack include a number of items that we've highlighted as suggestions for Dynamics GP. You can get them now, without waiting for MS. Some of the new items include:
- Auto Filling the Distribution reference
- Resizing the SmartList window
- Locking SmartList Favorites
- Copying User Defined fields during mass modify
GPUG – Inside the New GPUG A/R Program (Sep 2012)
Previously, the good folks at GPUG had a certification for AP end users. This was a great way to ensure that end users had the skills they needed to properly process payables. Now they are launching a Professional Certificate in Accounts Receivable (PCAR) providing similar knowledge and training for AR users.
I've recommended the PCAP to clients as a great resource and I'm sure that the PCAR will be fantastic as well. Follow the link to learn more.
I've recommended the PCAP to clients as a great resource and I'm sure that the PCAR will be fantastic as well. Follow the link to learn more.
18 September 2012
Dynamics Confessor Blogspot: When things go Wrong - I need to delete a printed SOP document
From Leslie Vail, When things go Wrong - I need to delete a printed SOP document. You can also turn on Delete Documents in Sales Document Setup and then turn it off when you are done.
Dynamics Confessor Blogspot: When things go wrong - Batches cannot be posted
Dynamics Confessor Blogspot: When things go wrong - Batches cannot be posted - Another scenario where GP thinks the year is still being closed.
Dynamics Confessor Blogspot: When things go wrong - This batch is being posted by another user
Leslie Vail blew up her blog yesterday with a pile of Dynamics GP feature suggestions and short posts on When Things Go Wrong. We'll look at some of her feature suggestions in upcoming Dynamic Future posts but I'm going to cluster her other posts now. Up first:
When things go wrong - This batch is being posted by another user
When things go wrong - This batch is being posted by another user
Top Tips: Limited User - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Pam Misialek has some licensing Top Tips: Limited User around Dynamics GP.
Feature of the Day: Journal Entry History Inquiry - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
This new GP 2013 feature will warm some hearts: Feature of the Day: Journal Entry History Inquiry
How To Install Connector for Microsoft Dynamics GP – Integrate Data | azurecurve
Like the Energizer Bunny, Ian Grive is still going strong with How To Install Connector for Microsoft Dynamics GP – Integrate Data
iSight is Next Week
The fantastic I.B.I.S customer conference, iSight 2012, is set for next week, September 25th in Atlanta at the Georgia Aquarium and September 26th in Charlotte at Microsoft's offices.
For 2012 we are thrilled to add Data Masons as a new sponsor and they seem to be pretty happy about it too.
For each of the last 4 years we've debuted a new '50 Tips in 50 Minutes for Dynamics GP' presentations culminating in last year's 'Best of' presenation. There have been many imitators and there are lot's of people stuck in reruns still trying to imitate the first set of tips from way back in 2008.
This year we're looking to spice things up with another set of 50 brand new tips for Dynamics GP in 50 new minutes. So register now, come on down, strap yourself in and hold on! We're going to have some fun.
For 2012 we are thrilled to add Data Masons as a new sponsor and they seem to be pretty happy about it too.
For each of the last 4 years we've debuted a new '50 Tips in 50 Minutes for Dynamics GP' presentations culminating in last year's 'Best of' presenation. There have been many imitators and there are lot's of people stuck in reruns still trying to imitate the first set of tips from way back in 2008.
This year we're looking to spice things up with another set of 50 brand new tips for Dynamics GP in 50 new minutes. So register now, come on down, strap yourself in and hold on! We're going to have some fun.
Dynamic Future - Vote - Assign an item to all Sites
Leslie Vail has a new suggestion for Dynamics GP and I like it well enough to hop on the bandwagon. As she explains:
Microsoft Dynamics GP is supposed to support multi-site operations, yet it's distribution module doesn't allow for it. One example is that I can assign all items to a single site, but I cannot assign all sites to an item.
I want to be able to assign all sites to an item. If you want this too, go vote at:
https://connect.microsoft.com/dynamicssuggestions/feedback/details/763003/assign-an-item-to-all-sites#tabs
Microsoft Dynamics GP is supposed to support multi-site operations, yet it's distribution module doesn't allow for it. One example is that I can assign all items to a single site, but I cannot assign all sites to an item.
I want to be able to assign all sites to an item. If you want this too, go vote at:
https://connect.microsoft.com/dynamicssuggestions/feedback/details/763003/assign-an-item-to-all-sites#tabs
17 September 2012
Feature of the Day: Pay Code, Benefit & Deduction - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
With everything going on at the Technical Airlift, it's easy to miss thi sFeature of the Day: Pay Code, Benefit & Deduction
The Dynamics GP Blogster: Microsoft Dynamics GP Technical Airlift 2012: Getting Home
Mariano covers Microsoft Dynamics GP Technical Airlift 2012: Getting Home. We're glad he made it.
Dynamics GP Technical Airlift 2012 - Web Client - Blog - Kuntz Consulting
Kuntz Consulting digs into the web client with Web Client part 1 and Web Client Part 2
Supporting Microsoft Dynamics GP 2013 Web Client | Dynamics University
There are a ton of blog entries coming out of the technical airlift. I thought about trying to lump some of them together and then I just gave up so...buckle up and enjoy.
Dynamics University starts us out with info on Supporting Microsoft Dynamics GP 2013 Web Client
Dynamics University starts us out with info on Supporting Microsoft Dynamics GP 2013 Web Client
Weekly Dynamic: POP Over Receipt Tolerance
We've covered a bunch of the now free PSTL tools. When Microsoft made the PSTL tools free they also made some other tools free including POP Over Receipt Tolerance.
This tool allows a receipt tolerance percentage for quantities. A setup window allows the user to enter a tolerance percentage, that percentage is then used when a Purchase Order is received. The highest quantity that can be received is the original quantity ordered plus the percentage amount. I think that this is going native in GP 2013 but if you need it now you can get it.
These tools are available through your partner. I've always found them to be a pain to find so I'm putting up the link here.
The link to the Professional Service Tools Library AND the additional tools is https://mbs.microsoft.com/partnersource/downloads/releases/noam_pstl.htm
This tool allows a receipt tolerance percentage for quantities. A setup window allows the user to enter a tolerance percentage, that percentage is then used when a Purchase Order is received. The highest quantity that can be received is the original quantity ordered plus the percentage amount. I think that this is going native in GP 2013 but if you need it now you can get it.
These tools are available through your partner. I've always found them to be a pain to find so I'm putting up the link here.
The link to the Professional Service Tools Library AND the additional tools is https://mbs.microsoft.com/partnersource/downloads/releases/noam_pstl.htm
13 September 2012
How To Install Microsoft Dynamics GP 2013 (Beta)
Ian Grieve has multiple posts on How To Install Microsoft Dynamics GP 2013 (Beta) including:
Server Configuration
Client
Demo Company
Server Configuration
Client
Demo Company
Web-based Report Viewer debuts today - Dynamics Corporate Performance Management - Site Home - MSDN Blogs
News out of Fargo from Dynamics Corporate Performance Management: Web-based Report Viewer debuts.
New SmartList Resource!
I've got a new SmartList resource available. This is a front and back quick reference guide to SmartLists in Dynamics GP.
It’s similar to ones you've seen at office supply stores for applications like
Word and Excel. The format is designed to print front and back and is perfect
for heavy card stock or laminating.
The folks who have gotten advanced copies keep coming back for more. I've decided to make it available via the website. It's $5 to download a PDF version and you can get it on the Best Practices tab.
I don't care if you distribute copies to your co-workers but this is a copyrighted product. Please don't put on the web for free. Enjoy!
The folks who have gotten advanced copies keep coming back for more. I've decided to make it available via the website. It's $5 to download a PDF version and you can get it on the Best Practices tab.
I don't care if you distribute copies to your co-workers but this is a copyrighted product. Please don't put on the web for free. Enjoy!
Weekly Review: Undo Depreciation
It’s not unheard of for someone to make a mistake with depreciation. Maybe an
asset was put into service early for example. Well if you need to undo
depreciation for a single asset in Dynamics GP it’s very easy. Simply go to the
Routine for Depreciate One Asset, select the asset to undo depreciation for and
set a new depreciation date. So if an asset was depreciated through 2/28/11 and
you need to put it back to 1/31/11 set the depreciation date to 1/31/11. GP will
warn you that the depreciation date is earlier than the depreciated through date
and this will back out depreciation in GP. Once depreciation is processed the
subledger is updated and a reverse GL transaction is created when the GL
Transaction routine is run.
This works great for a single asset and is really easy to do. So what happens if you accidently mess up a complete depreciation run? Microsoft support has a script that can undo a depreciation posting. I’m working on getting permission to post the script. Until that happens you can contact Microsoft support and they’ll send you the script.
This works great for a single asset and is really easy to do. So what happens if you accidently mess up a complete depreciation run? Microsoft support has a script that can undo a depreciation posting. I’m working on getting permission to post the script. Until that happens you can contact Microsoft support and they’ll send you the script.
12 September 2012
How To Install Connector for Microsoft Dynamics GP – Preparing Data for Integration | azurecurve
Continuing his deep dive into the CRM Connector for GP , Ian Grieve looks at Preparing Data for Integration
Feature of the Day: Unapply Credit Documents when Voiding a Check - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
In GP 2013, when a customer payment is voided, any credit associated with that invoice will also be voided. Details at Feature of the Day: Unapply Credit Documents when Voiding a Check
GP2themax - Helping users get the 'max' from Dynamics GP: Field Service Business Alerts
Frank Hamelly explains how to create Field Service Business Alerts
How to display more than four line item comments in the SOP Blank Invoice Word Template
From the Microsoft Dynamics GP Support and Services Blog comes information on How to display more than four line item comments in the SOP Blank Invoice Word Template
Microsoft Dynamics GP 2013 Beta release available for download - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Microsoft Dynamics GP 2013 Beta release available for download - do I really have to add anything to this announcement?
The Dynamics GP Blogster: Microsoft Dynamics GP Technical Airlift 2012: Getting here
Keep your eyes open for more GP2013 news coming out of the Technical Airlift going in Fargo this week. Mariano has a look at the Microsoft Dynamics GP Technical Airlift 2012: Getting here so far.
Dexterity Training in Orlando, Florida, USA (8th to 12th October 2012) - Developing for Dynamics GP - Site Home - MSDN Blogs
Dex is more important than ever with the upcoming web client. Now you can attend Dexterity Training in Orlando, Florida, USA (8th to 12th October 2012)
How To Install Connector for Microsoft Dynamics GP – Create A New Integration | azurecurve
Continuing his look at How To Install Connector for Microsoft Dynamics GP – Create A New Integration is Ian Grieve of azurecurve.
Feature of the Day: Saved Batch Approval - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Coming in GP 2013: Saved Batch Approval .
Batch Approver and Approval Date will now be saved in the GL20000 and GL30000 tables.
Batch Approver and Approval Date will now be saved in the GL20000 and GL30000 tables.
11 September 2012
How To Install Connector for Microsoft Dynamics GP – Configure Adapters | azurecurve
Over at azurecurve Ian Grieve continues with How To Install Connector for Microsoft Dynamics GP – Configure Adapters
You Don't Have to Like It, But You Have to Understand It | MSDynamicsWorld.com
My new article is up at MSDynamicsWorld.com You Don't Have to Like It, But You Have to Understand It
Dynamic Future - Vote - Payroll Sorting
How would you like some better sorting on the Payroll Transaction Entry Window? That's the subject of this week's suggested improvement to Dynamics GP. If you like this, vote at: https://connect.microsoft.com/dynamicssuggestions/feedback/details/480852/gp-implementer
10 September 2012
Trend Alert: Dynamics GP Users Changing Course in How They Manage EDI Requirements
This is a guest post by EDI Expert Glenn McPeak
I’ve been keeping my eye on it and given the uptick of questions I’ve been receiving and discussions I’m having, I’m now going to call it a “trend” - the Microsoft GP user community is changing the way they want to manage EDI. Until now, it seemed that companies were selecting one of numerous options to meet their EDI mandates, but after hearing a lot about what EDI is not doing for their company, I’m seeing a shift in what they are looking for when it comes to Dynamics GP EDI, especially now that we’re on the cusp of the Microsoft Dynamics GP 2013 release. With pending future upgrades in consideration, companies are also thinking about how they can best manage EDI now, while also setting themselves up for a potential upgrade down the road, cost-effectively killing two birds with one stone.
From the discussions I’m having out in the community, I understand that GP customers are discovering more and more about what EDI should be delivering to their business. What was once acceptable is no longer the case, as technology has changed to support evolving business needs and Microsoft’s development strategies.
Here are the latest trends in what GP users are looking for when it comes to EDI:
Here are the latest trends in what GP users are looking for when it comes to EDI:
#1 – End to end automation
Pushing a button to integrate a transaction used to be great as it saved time over manual entry. But now users are asking, “Why do I have to push a button and who is going to do it at 2am?” They want automation of key EDI process that gives them the flexibility and security they’re looking for.
Pushing a button to integrate a transaction used to be great as it saved time over manual entry. But now users are asking, “Why do I have to push a button and who is going to do it at 2am?” They want automation of key EDI process that gives them the flexibility and security they’re looking for.
#2 – Manage EDI by exception
GP users don’t want to deal with every transaction, only the issues that need attention. Managing by exception lets the transactions without discrepancies continue without interruption and eliminates unnecessary manual touch points.
GP users don’t want to deal with every transaction, only the issues that need attention. Managing by exception lets the transactions without discrepancies continue without interruption and eliminates unnecessary manual touch points.
#3 – Leverage standard Microsoft integration framework
Writing directly to tables and bypassing business logic is not best practice. By leveraging integration tools such as Microsoft’s e-Connect, users can avoid custom routines that populate data and bypass standard business logic.
Writing directly to tables and bypassing business logic is not best practice. By leveraging integration tools such as Microsoft’s e-Connect, users can avoid custom routines that populate data and bypass standard business logic.
#4 – Deeper and broader integrations
Users need more advanced logic, such as touching specific values in a sales order or handling advanced three-way matching logic. They also need broader document integrations so they can get new documents integrated quickly and easily to avoid jeopardizing trading partners relationships.
Users need more advanced logic, such as touching specific values in a sales order or handling advanced three-way matching logic. They also need broader document integrations so they can get new documents integrated quickly and easily to avoid jeopardizing trading partners relationships.
#5 – Avoid transaction fees
EDI data is a lot like email – would you pay to send an email? Right, then why pay for transactions when you don’t need to, especially when your trading partners support direct connect?
EDI data is a lot like email – would you pay to send an email? Right, then why pay for transactions when you don’t need to, especially when your trading partners support direct connect?
#6 – Audit the transactions
Too many companies complain about the lack of tools available that can identify issues before they become problems. They wonder why they can’t find out that an invoice was not transmitted and/or received by a partner before it is overdue. They would rather receive an email alerting them when a document has failed.
#7 – Guaranteed support turn-around times:
In the world of EDI where delays and errors can result in unnecessary and costly expense, organizations don’t have the flexibility of waiting for support responses.
Responding to these trends is an innovative EDI technology model that GP users are rapidly adopting. Users are looking to an EDI solution that is based on leveraging the native integration framework of the GP platform while providing all of the EDI transaction functionality outside the application¸ an alternative to other EDI technologies that provide similar functionality inside the application. With this approach, companies can:
1. Implement a single, plug-and-play, truly integrated solution that doesn’t utilize 3rd party translator tools;
2. Leverage a fully-automated EDI solution with predictable ownership costs; and
3. Benefit from a non-embedded design and XML data storage within SQL that avoids ERP requirements and customizations, simplifying daily use and providing flexibility when managing ERP update/upgrade projects
Learn more about this growing trend in Dynamics GP EDI and what you can gain by expecting more out of an EDI solution. Take a look at how other GP-based companies have successfully implemented a new strategy to increase the impact EDI has on their business and how they have exceeded their expectations in simplifying EDI integration and compliance.
[Glenn McPeak, Jon Rivers and the rest of the folks at Data Masons do a great job at being the go to EDI experts for the GP community. They are also sponsoring the upcoming GP Technical Airlift this week in Fargo, N.D. If you're going, make sure to say Hi and bring your EDI questions. - Mark]
Using Microsoft Dynamics GP Source Documents to identify GL entries
Belinda looks at Using Microsoft Dynamics GP Source Documents to identify GL entries. This is a great option to avoid the dreaded 13th period just for adjustments. Use a different source document.
Feature of the Day: Multi-User Editing in Returns Management - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
In a new Feature of the Day, Microsoft shows off Multi-User Editing in Returns Management
'Microsoft Dynamics GP 2013 Returns Management will now allow 2 or more users to edit different lines of the same RMA. This will allow to speed up processing of RMA’s. Currently only a single user may be editing an RMA.'
'Microsoft Dynamics GP 2013 Returns Management will now allow 2 or more users to edit different lines of the same RMA. This will allow to speed up processing of RMA’s. Currently only a single user may be editing an RMA.'
The SmartList Builder Reminders fix is now available
The SmartList Builder Reminders fix is now available. I'm not sure that I have to explain more than that.
Weekly Dynamic: PSTL IV Reconcile
The now free PSTL Tools (I know PSTL Tools is technically redundant, Professional Services Tools Library Tools, but that's how it is commonly referred to) includes an improved Inventory Reconcile tool that only reconciles items that need it. In most cases this is significantly faster than the base tool. How much faster?
I have an example from a client. It's not a perfect benchmark but but in their admittedly slow test environment, it took 24 hours to run the base reconcile and 5 hours to run the PSTL based reconcile. The PSTL reconcile has more volatility in how long it runs because it depends on how many items need to be reconciled.
If you're running in to long IV reconcile times, check out the PSTL based IV reconcile.
I have an example from a client. It's not a perfect benchmark but but in their admittedly slow test environment, it took 24 hours to run the base reconcile and 5 hours to run the PSTL based reconcile. The PSTL reconcile has more volatility in how long it runs because it depends on how many items need to be reconciled.
If you're running in to long IV reconcile times, check out the PSTL based IV reconcile.
06 September 2012
8 More Reasons to Attend the UG’s in October « The Death of Reason
Dwight responds to my gentle prodding in his typical, uplifting way with 8 More Reasons to Attend the UG’s in October « The Death of Reason
How To Install Connector for Microsoft Dynamics GP – Prerequisites | azurecurve
Ian Greive moves from Web Services to How To Install Connector for Microsoft Dynamics GP – Prerequisites.
I'm sensing a series!
I'm sensing a series!
How to modify a field value in a line when generating the EFT file? - Developing for Dynamics GP - Site Home - MSDN Blogs
Writing at Developing for Dynamics GP, Viswanathan Neelakantan shows How to modify a field value in a line when generating the EFT file?
8 Great Reasons to Attend GPUG Summit 2012 this Oct. in Seattle + 8 Bonus Reasons!
Michelle Spitzer has 8 Great Reasons to Attend GPUG Summit 2012 this Oct. in Seattle.
While these are 8 great reasons, I'm forced to ask 'only eight?'. Clearly we are missing a few like:
While these are 8 great reasons, I'm forced to ask 'only eight?'. Clearly we are missing a few like:
- The opportunity to refer to me as "Mr. Sexy Pants" in public. MVP Frank Hamelly is already on board and does this frequently. Dwight isn't ready for this yet, he's still working through hair issues.
- The chance to be publicly humiliated by new presenter, Huber Cooney. Huber and I go way back. He only gets to present this year because the conference is within range of his ankle monitor. Don't worry, he'll be fine in sessions, but at the bar after...well...you know that scene from Roxanne with the nose insults, Huber can, and regularly does, put that to shame. [This is the YouTube link for the young uns in the room.]
- 50 more tips for Dynamics GP. Yes, I dug up 50 new ones just for you. Bring a napkin, some of these will make you drool. In all seriousness, folks regularly say "this presentation was worth the cost of the conference." If its not, Huber will give you your money back.
- The fun of calling Andy Snook of Fasthpath "Snooki" and then buying him a Jack Daniels as an apology.
- The opportunity to learn a lot more about Dynamics GP, Microsoft Excel and how they both fit together as slices of an awsome pie.
- The chance to build relationships that help you get your questions answered after you go back home. It's much easier to get John Lowther, Mariano or me to answer your question when we can put a face to a name.
- The chance to hang with Bob McAdam who is a genuinely nice guy, despite being a Bucs fan.
- Seeing what Huber (and probably Dwight) will do to me as payback for this post.
Feature of the Day: Multi-Tenant - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
The ability to have muliple "Dynamics" databases logic leads to this Feature of the Day: Multi-Tenant
Feature of the Day: Fixed Assets to General Ledger - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
I told you that Fixed Assets was getting some nice features in 2013 including Fixed Assets to General Ledger Batches
Weekly Review: Increase the number of password tries
Weekly Dynamic: Increase the number of password tries
By default in Dynamics GP, if you type your password wrong 3 times GP closes.
This setting can be controlled in the Dex.ini file.
The setting is:
SQLNumLoginTries = number
The default is 3, setting this to –1 allows an unlimited number of tries. This doesn’t change any SQL based lockout parameters, it simply keeps GP from closing after 3 tries.
The setting is:
SQLNumLoginTries = number
The default is 3, setting this to –1 allows an unlimited number of tries. This doesn’t change any SQL based lockout parameters, it simply keeps GP from closing after 3 tries.
05 September 2012
Not-For-Profit GST Calculation in Dynamics GP - Etelligent Solutions
Judy Hirst explains Not-For-Profit GST Calculation in Dynamics GP for the Canadians in the room.
Dynamics AX and Enterprise Agreements–What Next? « The Death of Reason
Dwight explores Dynamics AX and Enterprise Agreements–What Next? for partners.
Future Dynamic-Vote-Batch Approval for POP Batches
So I've gone to something straightforward this week. I think that POP batches, Receiving, Shipment Invoice and Invoice batches should have batch approval functionality similar to AP. In the case of Shipment Invoices and Invoices in particular, these actually create AP batches and sometimes AP wants/needs to control the posting.
I know, the approval should really be at the P.O. level but since you can over/under receive and change the cost (depending on settings) some companies want a double check before sending this to payroll. If you'd like to vote for this go to:
https://connect.microsoft.com/dynamicssuggestions/feedback/details/760005/pop-invoice-match-batch-approval
I know, the approval should really be at the P.O. level but since you can over/under receive and change the cost (depending on settings) some companies want a double check before sending this to payroll. If you'd like to vote for this go to:
https://connect.microsoft.com/dynamicssuggestions/feedback/details/760005/pop-invoice-match-batch-approval
7 Years of Failure
Today is the 7th anniversary of DynamicAccounting.net. In 7 years I've failed a lot.
- By the end of the day this blog will have over 4,870 posts on Dynamics GP, but I didn't make 5,000 posts in 7 years. I Failed.
- At this point my Twitter followers are stuck in the low 900's. I failed to hit 1,000.
- I've failed to change the behavior of any number of people who continue to do dumb things with Dynamics GP. I Failed
- I've failed to make a million dollars with this blog. (Not that there was ever much hope in that.) I failed.
- I'm happy that though I haven't yet hit 5,000 posts, it will happen before year end and I added more than 1,300 new posts this year.
- While I haven't fixed everything in Dynamics GP (I'll get right on that) we all made strides together this year by highlighting Microsoft Connect items that we would like to see in future versions. I also think more and more of the basics of how to setup GP effectively are spreading through the community. We're building a body of knowledge that helps everyone.
- I have made a little dough through some great blog sponsors and those of you who were kind enough to buy my book. I'm writing another so start saving now.
04 September 2012
Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave has additional coverage and technical details for Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix
Connector for Microsoft Dynamics GP | azurecurve
Ian Grieve covers the CRM Connector for Microsoft Dynamics GP
Feature of the Day: Named System Database - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
Microsoft's newest Feature of the Day: Named System Database Also the sample DB can be named something other than TWO to accomodate a sample DB per system DB. This is great for hosted environments but it could also be useful in other scenarios.
Importing PSTL Data
Now that the GP Professional Service Tools Library (PSTL) is free, I wanted to highlight that you can import the settings for many of the tools. For example, in Account Modifier/Combiner you can select Import to import files to be modified/combined.
The PSTL manual indicates that you should use a Tab Delimitted file and that worked in my testing but I have had some users indicated that Tab Delimitted doesn't always work. In those cases using a CSV file did work.
The ability to import changes makes using PSTL for large changes much easier.
- Select Validate to pick the file. PSTL will validate that the information is formatted correctly.
- Click Modify to actually import the information.
The PSTL manual indicates that you should use a Tab Delimitted file and that worked in my testing but I have had some users indicated that Tab Delimitted doesn't always work. In those cases using a CSV file did work.
The ability to import changes makes using PSTL for large changes much easier.
Subscribe to:
Posts (Atom)