The Summit Group finds Where the GL Distribution Account Info is Stored for a Payroll Posting in Microsoft Dynamics GP
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
29 September 2011
Weekly Review: Proper P.O. Closing
An awful lot of folks close Purchase Orders the wrong way. The scenario is this: A P.O. remains partially open due to a vendor's inability to deliver goods in a timely manner. The firm finds an alternate supplier and cancels the P.O. with the vendor. To cancel the P.O. out of GP, they change the quantity on the P.O. line to match the quantity delivered and close the P.O. The problem with this scenario is that it removes visibility into the vendor's performance.
A better way to accomplish this is to put the remaining amounts in the Quantity Cancelled line. This will enable closing the P.O. and provide a history that the vendor didn't deliver. Now Smartlists or other reporting can be used to compare the delivery performance of various vendors and allow businesses to make intelligent sourcing decisions.
Originally Posted by Mark at 10/12/2009 09:00:00 AM
Microsoft Dynamics GP Partner Connections Conference 2011 - Microsoft Dynamics Partner Community Blog
If you’re a partner, join me and other partners in Las Vegas for GP Partner Connections where can all learn together how to get more out of Dynamics GP for our businesses and our clients.
Check out Kevin Machayya’s post Microsoft Dynamics GP Partner Connections Conference 2011 for more.
28 September 2011
ERP Knowledge Base Articles made public - Microsoft Dynamics AX UK Blog
Yeah, you saw that headline right, I read AX blogs too. I need some humor in my life. In this case though, the Microsoft Dynamics AX UK Blog beat everyone to the punch. It seems that Microsoft has chosen to make all of the Dynamics ERP Knowledge Base Articles public on http://support.microsoft.com.
This change will allow search engine indexing of Knowledge Base content making it easier for everyone. I’ve already added http://support.microsoft.com into the MyGPSearch custom engine for Dynamics GP. Now when you use MyGPSearch you’ll get blog results, newgroup results and official support answers.
I’m hoping this means that we can quit complaining about CustomerSource search features and move on to complaining about more important things…like why they don’t serve Diet Mountain Dew at Convergence.
Email option is unavailable for SOP transactions - Dynamics GP Support and Services Blog
I’m catching up on a few things I marked to blog about but haven’t yet. Up first is a post from the Dynamics GP Support and Services blog on Email option is unavailable for SOP transactions
You, Me and GPUG Academy
My friend, competitor and lover of a football team who once wore creamsicle uniforms, Bob McAdam has been doing some great guest blogging here at DynamicAccounting.net.
As much as it pains me to admit that Bob is right about anything, he is absolutely right about the GPUG Summit and GPUG Academy.
For those of you thinking about going to the GPUG Summit take a look at the GPUG Academy too. Sometimes, a conference session just isn’t enough to adequately cover a particular topic. Sometimes people don’t learn well without being about to try things for themselves. That’s what GPUG Academy is all about.
GPUG Academy is providing classroom learning options immediately before the GPUG Summit. For example, I’m teaching a 4 hour class on Administration Made Easy for Dynamics GP. No this is not a 1/2 hour of handing out business cards and saying call me followed by 3 1/2 hours of beer. That’s what parties are for after the sessions. This class has serious, hands on tips for administering GP using your laptop and a virtual GP environment. It’s hands on, down and dirty.
There are a bunch of sessions available but enrollment is capped to ensure appropriate personal attention. You’ll need to hurry to get the class you want. If you want personal attention in Bob’s class, wear an ugly orange jersey with “Williams” on the back.
Add Item option in POP and SOP | | Interesting Findings & Knowledge Sharing
Sivakumar looks at the Add Item option in POP and SOP in his latest post.
NFL team winning with Management Reporter - Dynamics Corporate Performance Management
Over at Dynamics Corporate Performance Management they look at an NFL team winning with Management Reporter.
Weekly billing frequency in Contract Administration for Microsoft Dynamics GP 2010 - Dynamics GP Support and Services Blog
The Dynamics GP Support and Services blog takes a look at Weekly billing frequency in Contract Administration for Microsoft Dynamics GP 2010
27 September 2011
Excel 2010 Financials Cookbook Book & eBook
I just wanted to remind folks that Packt Publishing is offering buy 2 books get one free through October 3, 2011.
There are a pile of books from Packt that apply to Dynamics GP including:
- Microsoft Dynamics GP 2010 Cookbook
- Microsoft Dynamics GP 2010 Reporting
- Microsoft Dynamics GP 2010 Implementation
- Microsoft Sure Step 2010
- Excel 2010 Financials Cookbook Book & eBook
Feature Explained: Reporting Ledgers | azurecurve
Ian Grieve explains Reporting Ledgers in Dynamics GP 2010
GPUG Academy offering classroom training in Las Vegas this November
Did you know that the GPUG Academy is hosting live classroom events at Caesar’s Palace in Las Vegas just prior to GPUG Summit 2011? Have you seen the long list of GPUG Academy classes being offered this time around?!This year’s GPUG Summit 2011 will be the largest one ever, but the GPUG Academy is growing fast, too, and if you or your colleagues are behind on GP training or simply want to become proficient with a new module or tool, signing up for live classroom training is an excellent way to make the most out of your trip to Las Vegas this November. This year there are over 20 classroom events being offered, such as:
- Introduction to Management Reporter (MR) – more & more users are looking to learn about FRx’s successor and the GPUG Academy is ready to assist. Find out where MR is similar to FRx and more importantly, where it differs.
- The Dynamics GP Smorgasbord - taught by yours truly, Bob McAdam, Mark’s former colleague from a few years back. This class is aimed at newer users to help speed up their acclimation to Dynamics GP. We'll discuss & review lots of different areas in GP, not just one or two, so you’ll be ‘fully integrated’ in no time!
Extend your trip to Las Vegas today (you deserve it, after all) by checking out these classes along with all the other Academy offerings at http://www.dynamiccommunities.com/Summit2011/GPUG/training.html and begin the process of getting you & your colleagues smarter on Microsoft Dynamics GP today!
Jumping on the Windows 8 van wagon - IMHO With The Dynamics GP Blogster
Mariano digs into some of the questions around Dynamics GP and Jumping on the Windows 8 van wagon
26 September 2011
Blog - General Ledger Posting Setup - Post To vs Post Through
iSolutions looks at General Ledger Posting Setup - Post To vs Post Through. No matter how many times this gets covered it’s always worth reading again.
GPUG Summit 2011 registration price break ending soon!
This is the final week to save on registration for GPUG Summit 2011, which is now only 6 weeks away! Make plans now and save some dough as pricing increases kick in this Saturday, October 1st.
Visit http://www.gpugsummit.com/ to see the lengthy list of breakout sessions, Academy offerings, and everything else going on in Las Vegas this November! Meet Me There!!
The Dynamics GP Blogster: Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL
Mariano has a new post with a look at Year-to-year Inventory Margin Report using the PIVOT operator in T-SQL
He then updates it with follow up post that makes it work even better.
Weekly Dynamic: Update User Date
In the past we’ve talked about what happens when GP is open after midnight. By default, a window opens asking if you want to change the date to tomorrow. You can turn that off with a Dex.ini switch:
SuppressDateChangeDialog=TRUE
This suppresses the date dialog but doesn’t update the date. If you want to update the date silently instead you need the Update User Date utility, a free utility that is part of the Professional Service Tools Library from Microsoft.
Activating this tool will update the date silently after midnight. You do need to have SuppressDateChangeDialog=TRUE set in the Dex.ini file too.
23 September 2011
Dynamics GP Land: Serializing eConnect XML - Properly
Steve also reminds himself (and us) about Serializing eConnect XML – Properly.
Dynamics GP Land: eConnect 2010 Error: The transaction has aborted
Steve Endow jumps on the econnect train with a look at eConnect 2010 Error: The transaction has aborted.
Integrations Via eConnect Disappearing | azurecurve
Ian Grieve doesn’t feel like a magician with Integrations Via eConnect Disappearing.
Leveraging the changes in eConnect for Microsoft Dynamics GP 2010 - Developing for Dynamics GP - Site Home - MSDN Blogs
Somehow it turned into eConnect Day. Let’s start with Chris Roehrich (sorry Chris but that last name sounds like something I Scooby Do would say 
) at Developing for Dynamics GP with a look at Leveraging the changes in eConnect for Microsoft Dynamics GP 2010
iSight 2011 Recap
We wrapped up iSight 2011, I.B.I.S.’ annual conference, yesterday in Atlanta. Both Atlanta and Charlotte were again big hits and I was reminded of how many great clients we have.
The Best of 50 Tips in 50 Minutes for Dynamics GP was big hit with some of the tips reinforced by recent CFO.com and Journal of Accountancy articles. Frankly some of these tips can put you way ahead of where the average accountant is.
A few comments I overheard while eavesdropping:
“I’ve seen every 50 tips presentation and I still came away with about 20 tips”
“That was the best tip ever”
The 50 Tips go on the road to Las Vegas in November at the GPUG Summit. Now is the time to sign up.
The Best of 50 Tips in 50 Minutes for Dynamics GP was big hit with some of the tips reinforced by recent CFO.com and Journal of Accountancy articles. Frankly some of these tips can put you way ahead of where the average accountant is.
A few comments I overheard while eavesdropping:
“I’ve seen every 50 tips presentation and I still came away with about 20 tips”
“That was the best tip ever”
The 50 Tips go on the road to Las Vegas in November at the GPUG Summit. Now is the time to sign up.
Microsoft Dynamics GP 12 and Silverlight
I was deeply embedded at iSight, our customer conference, over the last two and that gave me opportunity to get some perspective on a little GP 12/Silverlight controversy that popped up without posting rashly.
First MSDynamicsWorld chimed in with Microsoft Dynamics GP 12's Silverlight Plans Unchanged Despite Windows 8 Plug-In Limitations
Then Microsoft clarified with Microsoft Dynamics GP 12 Our Windows 8 Vision.
Here are my thoughts:
- It’s not unusual for the Windows team to be way ahead of everyone else. Even the Office team has gotten caught in the past.
- There is a lot of confusion in the marketplace around what will run on a Windows 8 Desktop vs. a Windows 8 Metro UI interface and what will run on an Intel tables vs. an ARM Tablet (and possibly a phone).
- If every team at MS changed course mid stream every time a new direction was announced nothing would ever ship and to quote Robert Scoble “Shipping is a feature”. The classic example of this is of course the video game Duke Nukem Forever which took a whopping 14 years to release because they were “Forever” chasing the latest and greatest game engine only to see the release immediately panned.
- I think Silverlight is a good choice for GP 12. It’s also kind of funny that after years of picking on Dexterity for being old we now see folks picking on Silverlight for not being new enough.
Frankly, with what I have seen of GP 12 so far, it’s going to do 2 things:
- Totally rock when released
- Well position the product to move forward
21 September 2011
Aged Debtors Report Problem | azurecurve
Ian Grieve digs into an Aged Debtors Report Problem. That’s aged AR for those of you on my side of the pond.
Dynamics GP Land: Little Tricks With Report Writer Package Files
Christina Phillips has a great post up on Little Tricks With Report Writer Package Files
20 September 2011
Custom Splash in Microsoft Dynamics GP | azurecurve
Ian Grieve of azurecurve looks at creating a Custom Splash in Microsoft Dynamics GP.
19 September 2011
Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview | azurecurve
azurecurve pushes the envelope by installing Microsoft Dynamics GP 2010 R2 On Windows 8 Developer Preview
Weekly Dynamic: SOP GL Reference
Previously we’ve looked at where the GL Reference comes from for POP transactions. Today we’ll look at where the GL Reference comes from for SOP transactions. Unlike POP where the GL Reference is on the Distribution window, for SOP transactions, it’s hidden behind the expansion button next to the Document Number.
16 September 2011
Join Us at GPUG Summit 2011 (Nov 8-11 in Las Vegas) - GPUG Events & News - GPUG - Microsoft Dynamics Community
As a ramp up to the GPUG Summit 2011 I’ve created “A Yeti’s Guide to the GPUG Summit 2011”. It’s a free download that makes it easy for you to see all of the great stuff that’s going to happen at the GPUG Summit. If you register before the end of September you can get a $100 off of the cost of the conference. There is more information on the post Join Us at GPUG Summit 2011 (Nov 8-11 in Las Vegas)
When it comes to reaching your summit, there’s nothing like a yeti to guide you there.
15 September 2011
Collins Dynamics GP Blog: Fix It Solutions for Microsoft Dynamics
Collins Computing reminds us how cool the Fix It Solutions for Microsoft Dynamics really are.
Congrats to the Accounting Today VAR 100
Congrats to all of the members of the Accounting Today VAR 100. In particular, congrats to I.B.I.S. who came in at #16.
SQL Scripts–Vendor Invoice Pricing Discrepancy « Real Life Dynamics User
Real Life Dynamics User is back with a SQL Script looking at Vendor Invoice Pricing Discrepancy
“…all Payables invoices that have been entered into your system where the price your vendor is charging does not match the price of your purchase order. “
Mythbusting: Yes MACRS depreciation works just fine in Dynamics GP - Mad Mark, the GP Road Warrior
I’ve got a new article up in my Mad Mark, the GP Road Warrior column at the Dynamics Community sit. It’s Mythbusting time and while, sadly, I don’t get to blow things up like the TV show, I do get smash some preconceptions.around MACRS depreciation. Yes MACRS depreciation works just fine in Dynamics GP.
Weekly Review: Force Shortcuts on Users
f you're a forceful, take charge kind of person this tip is for you. When logged in as SA an extra item, User Classes, appears on the Shortcut Bar. Adding a shortcut to a User Class automatically makes that Shortcut available to that User Class. Even better, users can't remove these special Shortcuts. This is a great way to ensure that a class of users has a consistent set of GP windows, smartlists, web pages and external shortcuts at their fingertips.
Originally posted by Mark at 10/05/2009 09:00:00 AM
14 September 2011
State of the Online Accounting Industry : Executive Roundtable
Over at SoftwareAdvice they’ve got an interview with 3 CEO’s heavily involved with ERP talking the State of the Online Accounting Industry : Executive Roundtable.
Dan's Corner for Dynamics GP: More free bullets for PSTL
Dan reloads Dynamics GP with More free bullets for PSTL.
There are so many puns here that I’m just going to leave it alone.
Manually changing SysData location » Summit Group Software Blog
The Summit Group looks at Manually changing SysData location » Summit Group Software Blog.
This has always been an exciting thing to do. Some days its Indiana Jones exciting.
SQL Scripts–SOP to POP Freight Analysis « Real Life Dynamics User
Ron at Real Life Dynamics User is back with SQL code for SOP to POP Freight Analysis.
“…analyze the freight you charged to a customer versus the freight you were billed from you vendor provided there is a SOP to POP link between the sales order and purchase order.”
Sweet
Field List button missing in Word Templates - Dynamics GP Support and Services Blog
From the official Dynamics GP Support and Services Blog comes a fix for the Field List button missing in Word Templates.
SQL view for user activity in Dynamics GP | Victoria Yudin
Victoria brings us a new SQL view for user activity in Dynamics GP.
“…view to show all the users logged in and a count of the batches, resources and tables each user has locked or open. Please note that this code will not show details of what the users have locked or open, just the counts.”
Very Nice.
Wiseguy now available on Kindle!
For Kindle lovers, Wiseguy is now available on Amazon for your Kindle. Amazon won’t let me provide it for free so if you want it on Kindle it will cost you 99 cents. For those of you who asked for an iBook version for your iPad, it’s in the works.
Wiseguy is a new twist on a classic mob tale. Wannabe mobster Joey is stunned to learn that his mob family has gone legit due to the power of Microsoft Dynamics GP. With the help of Jersey girl Isabella, Joey must learn to collect cash using Dynamics GP instead of a baseball bat.
For Wiseguy, I’ve partnered with the folks at Reporting Central, home of the The Closer and The ValidatorGP to give you a opportunity to download a free PDF version. All you have to do is hit up the Reporting Central website for a free download code.
Wiseguy is a new twist on a classic mob tale. Wannabe mobster Joey is stunned to learn that his mob family has gone legit due to the power of Microsoft Dynamics GP. With the help of Jersey girl Isabella, Joey must learn to collect cash using Dynamics GP instead of a baseball bat.
For Wiseguy, I’ve partnered with the folks at Reporting Central, home of the The Closer and The ValidatorGP to give you a opportunity to download a free PDF version. All you have to do is hit up the Reporting Central website for a free download code.
SQL Scripts–Invoices Coming Due Next Week « Real Life Dynamics User
Ron at Real Life Dynamics User deliver a SQL Script to show Invoices Coming Due Next Week.
They use it to notify customers that their invoices are coming due, much like the Library reminds me that I’m going to owe them a boat load of money if I don’t return my books on time. Sort a pre-Dunning notification. I like it.
13 September 2011
Management Reporter: “Cannot connect to the Management Reporter Server. Do you want to specify a different server address?” | Microsoft Dynamics AX, CRM & GP Blog
Our own Dani Richardson tackles a “Cannot connect to the Management Reporter Server. Do you want to specify a different server address?” error with Management Reporter over at DynamicsCare.
Creating a Support Debugging Tool Non-Logging Trigger to run after login - Developing for Dynamics GP
David Musgrave demonstrates Creating a Support Debugging Tool Non-Logging Trigger to run after login over at Developing for Dynamics GP.
New Look for DynamicAccounting.net
DynamicAccounting.net has been updated with a new, cleaner look. If you normally follow via RSS, visit the site for a change.
Pivotal Advance Boosts Excel's Power
Journal of Accountancy has a great look at PowerPivot in the September 2011 article Pivotal Advance Boosts Excel's Power.
I’m seeing more and more accountants embracing PowerPivot as a natural extension of their Excel skill.
Buy 2 get 1 free | Packt Publishing Technical & IT Book and eBook Store
Packt Publishing, the publisher of the Microsoft Dynamics GP 2010 Cookbook and other great Dynamics GP titles is offering Buy 2 get 1 free in the month of September. That means that you can:
Buy the Microsoft Dynamics GP 2010 Cookbook and Microsoft Dynamics GP 2010 Reporting and get Victoria’s Microsoft Dynamics GP 2010 Implementation for free.
or you can:
Buy the Microsoft Dynamics GP 2010 Cookbook and Microsoft Dynamics GP 2010 Reporting and get Microsoft Dynamics Sure Step for free.
September is going to go quick to take advantage of this now.
12 September 2011
Lend a Hand: Reviewer Delegation in ReQlogic | Microsoft Dynamics AX, CRM & GP Blog
My colleague Kelsey Andrich covers Reviewer Delegation in ReQlogic over at DynamicsCare.
Seth's Blog: "Do it tomorrow"
Take Seth's Blog: "Do it tomorrow" and apply it to my MSDynamicsWorld article “We’re not charging enough for Microsoft Dynamics GP”
Key Keyboard Shortcuts for Dynamics GP | Dynamics GP Insights
If you’re into clickety-clack check out Key Keyboard Shortcuts for Dynamics GP from Dynamics GP Insights.
For a round up of keyboard shortcuts for GP checkout our Keyboard Shortcuts tag
For a round up of keyboard shortcuts for GP checkout our Keyboard Shortcuts tag
Microsoft Dynamics GP, the next generation of end-user customization tools? - IMHO With The Dynamics GP Blogster - GP Non-Technical Blogs - Microsoft Dynamics Community
Over at the Dynamics Community site, Mariano is back with a look at Microsoft Dynamics GP, the next generation of end-user customization tools?
How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool - Developing for Dynamics GP
Over at Developing for Dynamics GP David Musgrave shows How to display more than 80 characters of an Extender Long String field in reports using the Support Debugging Tool.
Earlier Version of Dynamics.dic Than Installed | azurecurve
azurecurve wrestles with an Earlier Version of Dynamics.dic Than Installed error.
Weekly Dynamic: POP Reference
In the POP windows with distributions (Shipment, Ship/Invoice, Enter/Match Invoice) there is a Reference field. This defaults to the transaction type but it can be changed. This reference passes through to be the reference field in the GL Transaction and can help provide additional information for folks starting with the GL.
According to the help documentation, this is also supposed to flow down to the distribution reference field in the GL if the distribution reference is blank, but it doesn’t. From the help:
Purchasing Invoice Distribution Entry window: Fields
Reference
Displays the reference that will post to General Ledger as the reference for the receipt. Purchasing Invoice Entry is the default reference for this field. If the Distribution Reference field for an account is left blank, the reference entered in the Reference field will post as the distribution reference. If you change the reference in the Reference field, that change will only affect those accounts that don't have distribution reference entered for them when the invoice is posted.
What actually happens is that the account category rolls down as the reference. I’ve submitted a request via Microsoft Connect to have GP work as documented. You can vote for this request to move it up the priority chain and put it on Microsoft’s radar at: http://bit.ly/rnVYwM.
[Big Hat Tip to Chaz Vann of I.B.I.S. for this.]
According to the help documentation, this is also supposed to flow down to the distribution reference field in the GL if the distribution reference is blank, but it doesn’t. From the help:
Purchasing Invoice Distribution Entry window: Fields
Reference
Displays the reference that will post to General Ledger as the reference for the receipt. Purchasing Invoice Entry is the default reference for this field. If the Distribution Reference field for an account is left blank, the reference entered in the Reference field will post as the distribution reference. If you change the reference in the Reference field, that change will only affect those accounts that don't have distribution reference entered for them when the invoice is posted.
What actually happens is that the account category rolls down as the reference. I’ve submitted a request via Microsoft Connect to have GP work as documented. You can vote for this request to move it up the priority chain and put it on Microsoft’s radar at: http://bit.ly/rnVYwM.
[Big Hat Tip to Chaz Vann of I.B.I.S. for this.]
08 September 2011
Packt Publishing–Dynamics GP 2010 Reporting « Real Life Dynamics User
Real Life Dynamics User likes David and Chris’ book Dynamics GP 2010 Reporting.
I’m betting you will too.
Using Derived Tables to Create SRS Reports for Dynamics GP | Dynamics GP Insights
Charles Allen tackles Using Derived Tables to Create SRS Reports for Dynamics GP at Dynamics GP Insights.
The Dynamics GP Blogster: Getting the Next Voucher Number for a Payables Transaction Integration
Mariano looks at options for Getting the Next Voucher Number for a Payables Transaction Integration in his new post.
We’re Not Charging Enough for Microsoft Dynamics GP | MSDynamicsWorld.com
My contention is that, especially in the enterprise space, We’re Not Charging Enough for Microsoft Dynamics GP. My arguments are up at MSDynamicsWorld.
Let the comments begin.
Weekly Review: Internet User Defined Fields
The Internet fields in Dynamics GP are actually user defined fields located in company setup. This makes it easy to change say the Image field to be a second web address.
Select Tools-Setup-Company-Company, Internet User Defined and simply change the labels to fit the needs of your business.
Originally Posted by Mark at 9/28/2009 09:00:00 AM
07 September 2011
Quick Tip: Best practice for using sum range table command - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave finishes things off today with a Quick Tip: Best practice for using sum range table command.
Sure Step Online Now Available - Inside Microsoft Dynamics GP - Site Home - MSDN Blogs
I see from Pam that Sure Step Online Now Available. That really should make it more convenient for everyone.
Subscribe to:
Posts (Atom)
