Tag: miscellaneous

Happy New Year – 2014

| 01/01/2014 | 0 Comments

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

Continue Reading

Inventory Receiving Transactions – Why is my Receipt Split?

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 .

Continue Reading

Book Review – Microsoft Dynamics GP 2013 Financial Management

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.

Continue Reading

Extended Pricing – which Price Sheet Rules?

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.    

Continue Reading

SQL view for Dynamics GP sales quantities and amounts by item by site by month

| 10/15/2013 | 0 Comments

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

Continue Reading

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