Tag: Dynamics GP
If you are looking to migrate from FRx to Management Reporter, There is an inbuilt migration wizard in Management Reporter to do the same. I don’t need to specify the steps involved in the migration process as it has been covered in much detail elsewhere on the blogosphere. Here is a perfect link to accomplish the same.
Matched Tables – Viewing Open & History Documents on the same SmartList in Builder (just like the default Lists!)
One of the features of the default Lists in SmartList, Excel Reports & Navigation Lists is that you can often see ALL GP transactions for a certain type on one list – Work (unposted), Open (unpaid or not moved to history), and History (moved to history). Now – don’t get me wrong - sometimes this feature is great, but a lot of my Builder Lists are to isolate just one status of GP transactions. (For example, most of my clients that use Sales Order Processing have separate Open & History Lists from builder…) What if you DO want more than one status on a Builder List? On first glance, it seems difficult or impossible – that data is in separate tables and you can’t just start with the open table and add the work table (there wouldn’t be matching records – so you won’t get anything!) Don’t worry – there is another way. For example, you want to build a SmartList for payables transactions for a certain period of time and all of the distributions of these documents. You really don’t care if the documents are paid or not (How they move to History in PM), you still want the documents to show on your list. Matched Tables First Start like normal and add your Transaction table for one status (I like to use open, but you could use history – it doesn’t matter).
When you are creating prices for different price levels in Dynamics GP, there is no easy way to see these, or to see all the prices for a particular price level. Below is a view that can help with this. ~~~~~ CREATE VIEW view_Inventory_Price_Levels AS /******************************************************************* view_Inventory_Price_Levels Created on Aug 9, 2010 by Victoria Yudin – Flexible Solutions, Inc.
I got to look at this wonderful site this morning www.gpwindow.com while trying to catch up myself to the latest developments in our GP blogging community of late. I must admit I’m very proud of my good friend Jivtesh work on the basic idea of this site and how it is structured to be a one-stop K-base for Dynamics GP resource shoppers.
Since I have posted a lot of Dynamics GP table information and SQL code, I often get asked the question “what table holds ____ “? Sometimes I just know the answer off the top of my head (yeah, I think that’s scary, too), but once in a while I have to look it up. I have various ways of doing this, sometimes it involves glancing through the list of tables, other times I have used the Support Debugging Tool created by David Musgrave . Now there is another great resource for this provided to us again by David Musgrave. You can read all about it in David’s post on Getting Table and Field Data out of Dexterity Dictionaries , however I thought I would take you through an example of how to use this. This example assumes that you have already installed the Support Debugging Tool - if you have not, that’s your first step. Now to our example (I am using GP 2010 for this, but it should work the same for GP 10.0): Log into GP as ‘sa’.
Mark Polino’s book, titled Microsoft Dynamics GP 2010 Cookbook , is out ahead of schedule! I think that’s the first time I have ever heard of something like that happening. I’ve already got my copy and as soon as I get a few minutes I am going to start reading it. In the meantime, you can read a sample chapter or get your own copy and start cookin’ with GP
Mark Polino , one of the very first Dynamics GP bloggers and someone who has personally inspired me often with his writing, has done some spring cleaning on his blog. There is a ton of great content, but I would like to point out these two great resources: SQL Scripts - one location with descriptions and links for many of the SQL scripts Mark has collected. I am very proud to say some of these are mine. The GP 2010 table reference - a really handy Excel listing of all the tables in GP 2010.