Background / The Problem For many companies a long awaited new feature introduced with Dynamics GP 2010 was the ability to email SOP (Sales Order Processing) invoices directly from GP. Many of our customers have started to offer emailing of invoices to their customers and are seeing an increased number of requests for emailed invoices. However, [...]
Read more
Tag Archives: GP Reports Viewer
SQL view for SOP email setup in GP 2010
October 24, 2011
9 Comments
I am starting to work with emailing SOP documents using Dynamics GP 2010 and new functionality that we are going to be releasing in an upcoming build of GP Reports Viewer. It’s pretty cool stuff, however, as I am working with customers to set this up, we’re finding that out-of-the box GP does not have any [...]
Read more Sign up for Decisions Spring 2011
May 24, 2011
3 Comments
MSDynamicsWorld.com is putting on another virtual show in a few weeks called Decisions Spring 2011. My company, Flexible Solutions, has been a sponsor at the last few Decisions events and they just keep getting better. All the Dynamics products have their own day, Dynamics GP day is June 15. You can read all about the exciting [...]
Read more See you at Decisions Fall 2010
November 2, 2010
3 Comments
Today is Microsoft Dynamics GP day at the Decisions Fall 2010 virtual conference. I will be at the Flexible Solutions booth talking about our GP Reports Viewer add-on. For anyone not familiar with it, GP Reports Viewer is a solution to manage Crystal and SSRS reports inside Dynamics GP. Decisions Fall 2010 is free, so there is no reason not to [...]
Read moreRenaming tables in Crystal Reports
July 20, 2010
16 Comments
From the May 2010 GP Reports Viewer newsletter comes a tip for renaming the tables (or views or stored procedures) on Crystal Reports. Some may ask why this in needed – I actually use this quite a bit in the following scenario. I often find that I am using one report as a template for another [...]
Read moreDecisions, decisions
May 18, 2010
0 Comments
The new era of trade shows is here. Virtual trade shows. No more leaving the office for a week, trying to work from the road, all to see what’s happening with Dynamics GP. And no more paying for travel and registration fees. Decisions 2010, brought to us by MSDynamicsWorld.com, starts tomorrow and is free! There is a [...]
Read moreMy Book
-
SQL view for Payables GL distributions in Dynamics GP
-
Using credit cards to pay vendors in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
- Dynamics GP Trial Balance in Excel using FRx
-
Finding resources
-
SQL view for sales quantities by customer by item by year
-
Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
-
Microsoft Dynamics Mayhem
-
SQL view for current Receivables aging in Dynamics GP
-
SQL view for sales quantities by item by year
-
SQL view for customer yearly totals in Dynamics GP
-
SQL view for vendor yearly totals in Dynamics GP
-
Happy New Year – 2012
-
SQL view to show monthly totals for Dynamics GP Vendors
-
Victoria Yudin: Hi Khan, GP does not store information about who ...
- Dynamics Confessor Blogspot - GP Technical Blogs - Microsoft Dynamics Community: [...] each module. If you are creating reports, or...
-
I Khan: Hi Victoria, I created a SmartList using Segment ...
-
-
kyle: Victoria, you have some great AP payment/apply sql...
-
-
-
Bill Schulz: Victoria - Your site is awesome. Thanks for thi...
-
Debbie: Thanks Victoria! I ran the query and had no resul...
-
