Tag: miscellaneous

Originating Invoice Cost not Populating on PO

Standard GP functionality calls for the Originating Invoice Cost from the Item Vendor window to automatically populate on a new PO.  *click image to enlarge   In a GP 2013 implementation, I was unable to get the cost to default on the PO.  After checking and re-checking a number of settings, I discovered that the ‘POP Cost Defaulter’ was turned on in PSTL (Professional Services Tools Library).  POP Cost Defaulter disables the standard functionality and allows you to default the PO cost from either the Standard or Current Cost fields in the Item Card.  Apparently, someone had enabled this feature and selected ‘Standard Cost’ as the default option, even though we’re not using Standard Cost in this environment.   Thanks to my colleague Chris Liley of IBIS, Inc

Continue Reading

SQL stored procedure to search an entire database

| 07/22/2013 | 0 Comments

I don’t often re-post things from other blogs, but this is just too good not to share. David Musgrave recently published an update to his spSearchOnAllDB stored procedure  on his blog, Developing for Dynamics GP . Simply run the script to create the stored procedure and you can search all the tables in a database for a particular string or value.

Continue Reading

SQL view for SOP sales by customer by month

| 06/07/2013 | 0 Comments

Someone asked me for code to get monthly SOP sales and I could have sworn I already had that. But I searched and didn’t come up with anything, so here is a new view to show SOP sales (the total of SOP invoices less returns) by month

Continue Reading

Book Review – Building Dashboards with GP 2013 and Excel 2013

Well, our friend Mark Polino has hit another one out of the ball park with his latest release – Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 , affectionately known as BDaMDGP13aE13 :) Yes the book’s title is a mouthful but my, oh my, the content of the book is a library full.  If there’s anything you want or need to know about leveraging the BI capabilities that GP 2013 and Excel 2013 bring to the table, you need this book.   From creating refreshable Excel reports to drilling back to source data in GP to utilizing PowerPivot, this book has it all.   I’ve just completed my first read of this awesome reference and am applying my new-found knowledge already.    I highly recommend Mark’s new book to anyone who has a desire to create and publish extremely powerful, interactive BI tools for GP 2013

Continue Reading

Convergence 2013 is here

With the sun setting over the city of New Orleans last night, we wrapped up our first day here, which was filled with getting out and about, seeing the sights on a perfect, sun-filled, 80 degree day.  The real fun starts tomorrow with the kickoff of the GPUG-hosted GP Partner Connection events and then some partying later in the evening to celebrate St. Patty’s day.  Green beer for all!

Continue Reading

Prevent Users from changing User Date

Some companies have a need to disable the ability to change the User Date in GP.  Out of the box, there isn’t a great way to handle this requirement but Ian Grieve, over at Azurecurve in the UK, has a simple, yet elegant solution for this.  Check out Ian’s blog post here – User Date . Wishing everyone a Happy and Prosperous 2013!    

Continue Reading

Upgrading to GP 2013 in the near future? Read this first . . .

Upgrading to GP 2013 in the near future? Read this first . . .

If you’re planning a GP 2013 upgrade anytime soon, take a look at this excellent article at MSDynamicsWorld for some upgrade Tips n Tricks – GP 2013 Upgrade .

Continue Reading