February 10, 2012

Microsoft Dynamics Mayhem!!

Packt Publishing is crowning February, Microsoft Dynamics Mayhem, and celebrating its range of Dynamics books/e-books with exciting discounts.

As the leading publisher of Microsoft Dynamics books/e-books and a multitude of bestsellers on NAV, AX, GP and Sure Step, not only do these titles excel in terms of quantity, but in quality, with each book garnering numerous positive reviews. 
To celebrate this achievement, Packt has slashed cover prices by up to 30%, so go mad, go crazy and make the most of this mayhem.
Recent Dynamics publications include:

  • Microsoft Dynamics CRM 2011 New Features
  • Microsoft Dynamics CRM 2011 Dashboards Cookbook
  • Microsoft Dynamics NAV 2009 Professional Reporting

Throughout 2012, Packt will continue to build-upon this success, with a focus on branching into different forms and formats such as a Dynamics Certification series.

For further information on Microsoft Dynamics Mayhem in February, visit:

February 5, 2012

What happens with Landed Cost when you perform a Returns Transaction in GP2010?

This question popped up on the Microsoft Dynamics Community today so I thought I'd share the answer here.  

The new functionality in GP2010 that edits the original PO for a purchase return (or creates a new one if the original is closed) is awesome.  Not sure why it took this long to add that functionality but it is what it is.  However, there is no facility in the Returns Transaction to reverse the Landed Cost on the original receipt, so GP writes the value of the Landed Cost to Purchase Price Variance.  Not the ideal way to handle it but at least it doesn't leave that cost sitting in inventory, if the return is an inventory item.

 *click image to enlarge

P.S. not sure what the image above is displayed washed-out but if you click on the image to enlarge it, it displays properly.

February 3, 2012

GL Trial Balance in FRx

For those of us on GP2010, Reporting Services reports provides a nice GL Trial Balance that is easy to export to Excel.  For the rest of us, we still have to print the Report Writer version to a text file, open it in Excel, then start the cleanup and reformatting.  There is an easier way using FRx.  Victoria Yudin has a great article on doing just this here - http://victoriayudin.com/2009/07/17/dynamics-gp-trial-balance-in-excel-using-frx/

 *click image to enlarge

Now, to take this one more step, if you need more of the transaction detail in your FRx GLTB, look at the additional Column Types available, such as TDESC, TJDESC, TDOC, TBAT, etc.  You can build a really sweet GLTB using FRx that easily exports to Excel.  That will make you and your auditors happy.