My second book as reviewer is Microsoft Dynamics GP 2013 Reporting – Second Edition written by David Duncan and Chris Liley. This book is second edition to their famous Microsoft Dynamics GP 2010 Reporting . So those who have read this book before would see the new book as an upgrade
One of the challenges that I been trying to achieve is having my reports graphically designed to show data on “Maps” and that always been the toughest part customers might request. Few days back I been researching with my colleagues on how the “Sales By States” KPI works in Dynamics GP that dynamically pulls the sales of each state on the US map and discovered the “Map” feature in SSRS! We have been able to download the “.shp” file for Jordan map from one of the online free GIS providers and integrated this will SSRS, and then created the following report in SSRS in few minutes, saved this report in SSRS and been able to print this report from GP business analyzer: This article is just to show that this is doable for users to give it a try.
This morning I enjoyed reading a book by Ian Grieve discussing Dynamics GP Financials – Related modules, it contains all the information needed to to cover your financial needs using Microsoft Dynamics GP, it starts with Analytical Accounting module, moving to Cashflow Management, Budgeting and finally PO Commitment and Encumbrance Management. For those who would like to learn more about the mentioned modules, I would recommend purchasing and reading this book from the below link, it worth every buck! http://bit.ly/16n4oO2 Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
Error: This document has been removed from Sales Order Processing history Or Sales Transaction Inquiry drill down show different Invoice No.
When I goto –> Inquiry–> Sales–> Transaction by Document or Customer and try to lookup that invoice it was showing me different invoice and on some invoice it was throwing “This Document has been removed from Sales Order Process history” even though invoice is open. I have tried everything but it didn’t resolve issue and at last open support request with Microsoft and found very strange issue that if in Transactions–> Sales–> Edit Transaction Information “Description field” was not same as Invoice No e.g. if your Invoice # is : INV000324354 Description must match INV000324354 otherwise you get same error.
I got an interesting question from one of the community followers and I saw that it should be published for community, the question was a request to have a special mask for the item number field, the user wanted to have the item number automatically has Dashes “-“ for each 3 letters to look like this > > “AAA-AAA-AAA” so the user will fill only 9 “A”s and the system to automatically add the “-“ in between and below how I covered this: 1. Go to Cards> > Inventory> > Item 2