I found out yesterday that I have been awarded with the Microsoft® Most Valuable Professional Award for Dynamics GP for another year. I first became a Dynamics GP MVP in 2005, so this will be my 6th year to receive the award and I could not have done it without the support of all of you reading […]
Continue reading
Archive by Author
SQL view for inventory items and dates
December 4, 2009 
45 Comments
This view is a little bit of a twist on my previous SQL view for inventory quantities on hand. The results of this view will give you a list of your Microsoft Dynamics GP inventory items, current quantities and the last sales and purchase dates along with the vendor. For other SQL views on Dynamics GP data, please visit […]
Continue readingRunning Totals in Crystal Reports
November 25, 2009 11 Comments
Here is a tip from the Flexible Solutions GP Reports October newsletter on how to create a running total in Crystal Reports. Running totals are a great way to show totals that have a different calculation than a subtotal without having to write additional formulas. Let’s look at an example: You have a list of unapplied […]
Continue reading SQL view for Payables payment apply detail in GP
October 22, 2009 108 Comments
I have published SQL views that return all posted Payables payments in Dynamics GP and Payables apply information to help identify what payments (or credits) paid off an invoice, however another frequent request is for a list of payments and their apply information. Below is a view that returns a list of all posted payments with details on how […]
Continue readingMicrosoft Dynamics Salary Survey 2009
October 13, 2009 1 Comment
Nigel Frank International is conducting the 2009 annual survey of Microsoft Dynamics salaries worldwide. Salaries are frequently a topic of conversation for many of us, whether we are hiring or looking to be hired, so I encourage everyone to participate in this survey. Better hurry, though, the survey will be closing middle of next week. As a thank you […]
Continue readingSQL view for all posted Payables transactions in Dynamics GP
October 12, 2009 37 Comments
Payables Transactions have been a popular request for reports lately. Below is a view that lists all posted Payables transactions in functional currency. Voided transactions are not excluded. For other SQL views on Dynamics GP data, please visit my GP Reports page. ~~~~~ CREATE VIEW view_PM_Transactions AS /*************************************************************** view_PM_Transactions Created Oct 12 2009 by Victoria Yudin – Flexible […]
Continue readingHistory of Dynamics GP
September 30, 2009 2 Comments
Do you still call it Great Plains because you’re so used to it? Or is Dynamics GP the only name you’ve ever used? In either case, you may find looking over the timeline of Dynamics GP that DynamicsWorld UK put together very educational and interesting. I have been working with GP as a customer since the DOS […]
Continue readingSQL view for all posted Payables payments in Dynamics GP
September 11, 2009 13 Comments
This view is in response to more than a few inquiries I have had for a vendor check report. This view brings in all payments, not just checks, so if only checks are needed, add the following to the end of the WHERE clause: AND P.PYENTTYP = 0 For other SQL code, please visit my […]
Continue readingWhat’s with all these dates?
September 8, 2009 21 Comments
There are many different dates stored in Dynamics GP. This is typically a good thing, my philosophy is that it is always better to have more data than you need and not the other way around. However, it can get confusing rather quickly since a lot of the labels for the dates sound very similar. I will attempt […]
Continue readingSQL view for all unapplied Receivables transactions in Dynamics GP
September 5, 2009 29 Comments
Here is a SQL view that will return all unapplied Receivables transactions in Dynamics GP. This will calculate how many days overdue unapplied transaction are. If something is not overdue, or if it is a credit transaction (payment, credit or return) the Days_Past_Due will be zero. For more SQL code like this, please visit my GP Reports and […]
Continue readingService Pack 4 for Dynamics GP 10
August 25, 2009 16 Comments
Service Pack 4 for Dynamics GP 10.0 has been released. There is quite a long list of fixes, you can see them all in the Service Pack 4 Installation Guide. Starting with GP 10.0 any service pack or hotfix now requires an update of modified forms and reports using GP Utilities. Detailed steps for doing this […]
Continue reading SQL view for all posted GL transactions in Dynamics GP
August 11, 2009 123 Comments
Below is a SQL script to create a view showing all posted General Ledger transactions in Dynamics GP. This has the common columns asked for on reports, but you can certainly add your own as needed. For additional SQL code, please visit my General Ledger SQL views page or the GP Reports page. A few notes on this view: Year-end […]
Continue readingDynamics GP Windows 7 and Server 2008 R2 compatibility announced
August 10, 2009 7 Comments
Just as the Windows 7 and Windows Server 2008 R2 are released, Microsoft announces that Dynamics GP 10.0 is already compatible with them. No service pack required. While my memory is not what it used to be, I do not recall any other new operating system that an existing version of GP was immediately compatible with. We have had […]
Continue readingHow to get next Monday’s date in Crystal Reports
July 29, 2009 4 Comments
From the Flexible Solutions’ GP Reports July 2009 Newsletter, here is a great new tip: how to calculate next Monday’s date in Crystal Reports. This comes up periodically when someone wants to have weekly columns on a report showing totals of something like sales, expenses or invoices due. So if you have a report parameter called […]
Continue reading Dynamics GP Trial Balance in Excel using FRx
July 17, 2009 43 Comments
While I work with SQL and Crystal Reports every day, there are some reports that are just easier created elsewhere. One example is a GL Trial Balance that you want to export to Excel. There are many ways of handling this requirement, I like using FRx for it. Below are steps by step instructions on how to […]
Continue readingSuppressing blank lines in Crystal Reports
July 15, 2009 14 Comments
Here is a Crystal Reports tip from the GP Reports Viewer newsletters that can help when you are working with addresses that are stored in multiple fields. Dynamics GP (and probably many other systems) stores address components in separate fields, so if we look at a customer address window there are many individual fields that make […]
Continue readingNew policy for Dynamics GP service pack support
June 26, 2009 1 Comment
Microsoft recently announced that the Dynamics products service packs will now be supported for 24 months after a new service pack is released. Previously service packs were supported for 12 months after a new service pack release. The new policy with key dates is outlined on Microsoft’s Longer Support Timelines for Key Microsoft Dynamics® Service Packs page. What this means to […]
Continue readingSQL view for inventory quantities on hand
June 18, 2009 27 Comments
I haven’t had much time to blog lately as we have added functionality to our GP Reports Viewer product that allows seamless replacement of SOP reports in Dynamics GP and the amount of interest has been overwhelming. However, I just needed to create a new SmartList to show current inventory quantities on hand with their costs and I […]
Continue readingMy Last Book
Dynamics GP 2013 Implementation
My Previous Book
Dynamics GP 2010 Implementation
-
Using credit cards to pay vendors in Dynamics GP
-
SQL view for Payables GL distributions in Dynamics GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
Sales Transaction Entry GL distributions in Dynamics GP
-
SQL view to show AP apply information in GP
-
Year end close in Dynamics GP
- SQL view with AR apply detail
-
Granting access to a new SmartList in Dynamics GP
-
SQL view with all SOP line items in Dynamics GP
-
SQL view for unposted checks in Dynamics GP
-
SQL view for rolling 12 months of sales by item by site in Dynamics GP
-
Dynamics GP sales amounts and quantities for rolling 12 months
-
Updating Dynamics GP data directly in SQL
-
Did you know you can change Void dates on Payables transactions?
-
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
-
SQL code to show top X percent of vendor data
-
Discount from Packt Publishing
-
Refreshable Excel report for historical GL trial balance in Dynamics GP
-
Refreshable Excel report for monthly GL budget in Dynamics GP
-
Victoria Yudin: Hi Matthew, This is a limitation in GP. "Why" is ...
-
Matthew: Why does "Sales" type distr...
-
-
Kevin Mackol: Does this still work on new...
-
-
Alex: Hi Victoria, Hi Victoria, Hi Victoria,Thank you so mu...
Victoria Yudin 
Recent Blog Comments