I found out today that I am going to be a Microsoft Dynamics GP MVP for another year! This makes the 10th year in a row for me. :-) I am very honored to get this award again and would like to thank everyone reading this – I could not do it without you! For those curious, the Microsoft MVP program has been in place since the early 1990′s and currently recognizes more than 4,000 MVPs worldwide. Here is to a happy, healthy and prosperous 2014! Filed under: Dynamics GP , Microsoft Tagged: awards , featured , Microsoft MVP
In some instances, GP will split a receipt of inventory into 2 receipt lines. Why does this happen? There is a great explanation of this in Microsoft Knowledge Base Article 2741489 .
I recently read Ian Grieve’s book – Microsoft Dynamics GP 2013 Financial Management. This was an interesting read in that it covers GP functionality that is rarely covered in any materials that I’ve seen previously. When was the last time you saw any discussion about Analytical Accounting, Cash Flow Management, Purchase Order Commitments , or Encumbrance Management ? Plus, all these features have been part of GP for a number of years, so the book’s applicability is not limited to just GP 2013.
Client with multiple price sheets per customer, each with different End Dates in the Price Sheet Date Range, was at a loss as to why incorrect pricing was pulling into their sales orders. Turns out they had a later End Date on the Price Sheets they wanted pricing to pull from than on the other Price Sheets that they didn’t want pricing to pull from. When setting up multiple Price Sheets per customer, remember that the Price Sheet with the earliest End Date rules.
Here is a new view created by request for one of my blog readers. This view combines my Sales by Item by Month and Sales Quantities by Item by Site by Month views. It will return columns for each month with the quantity and sales amount side by side. The year is hard-coded to be the current year (when the view is run), but can be changed as needed
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
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.