Victoria Yudin

Dynamics GP polls

Victoria Yudin — Fri, 12 Mar 2010 22:03:53 GMT

I had a poll on the sidebar of this blog for about a year asking what version of Dynamics GP my visitors were using. Here are the results: I admit to being a little surprised by this, I thought that GP 9.0 would be much closer to GP 10.0, not less than...(read more)

SQL view with AR apply detail

Victoria Yudin — Mon, 15 Feb 2010 13:24:52 GMT

This has been a hot topic in the newsgroups lately and several people have asked me if I have any code for Receivables (AR) apply information in Dynamics GP. Below is a view that should help you get started if you’re building a report to show AR...(read more)

SQL view with all GL distributions for AR transactions

Victoria Yudin — Wed, 10 Feb 2010 12:24:50 GMT

As a corollary to my SQL view with all posted Receivables transactions , below is a view that will add all the General Ledger distributions to the AR transactions. I made a few changes to the original AR transactions view, primarily to remove some columns...(read more)

Maximizing Dynamics GP online resources

Victoria Yudin — Tue, 02 Feb 2010 15:48:11 GMT

I have joined the ranks of many fellow Dynamics GP MVP’s and experts and got an article published on MSDynamicsWorld.com . It’s called The “Right” Way to Maximize the Growing Number of Online Resources for Microsoft Dynamics GP...(read more)

Selective highlighting in Crystal Reports

Victoria Yudin — Fri, 15 Jan 2010 14:06:11 GMT

The Crystal Reports tip from Flexible Solutions GP Reports November newsletter shows how to selectively highlight values in a list without having to write a formula. Let’s say you have a customer list with balances: Now what if you wanted to make...(read more)

Happy New Year

Victoria Yudin — Sat, 02 Jan 2010 15:23:25 GMT

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...(read more)

SQL view for inventory items and dates

Victoria Yudin — Fri, 04 Dec 2009 12:09:02 GMT

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...(read more)

Running Totals in Crystal Reports

Victoria Yudin — Wed, 25 Nov 2009 10:52:25 GMT

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...(read more)

SQL view for Payables payment apply detail in Dynamics GP

Victoria Yudin — Thu, 22 Oct 2009 19:37:21 GMT

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...(read more)

Microsoft Dynamics Salary Survey 2009

Victoria Yudin — Tue, 13 Oct 2009 14:40:20 GMT

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...(read more)

SQL view for all posted Payables transactions in Dynamics GP

Victoria Yudin — Mon, 12 Oct 2009 08:59:19 GMT

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...(read more)

History of Dynamics GP

Victoria Yudin — Wed, 30 Sep 2009 11:25:28 GMT

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...(read more)

SQL view for all posted Payables payments in Dynamics GP

Victoria Yudin — Fri, 11 Sep 2009 09:21:11 GMT

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...(read more)

What’s with all these dates?

Victoria Yudin — Tue, 08 Sep 2009 12:59:20 GMT

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...(read more)

SQL view for all unapplied Receivables transactions in Dynamics GP

Victoria Yudin — Sat, 05 Sep 2009 15:38:20 GMT

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...(read more)

Service Pack 4 for Dynamics GP 10

Victoria Yudin — Tue, 25 Aug 2009 11:51:15 GMT

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...(read more)

SQL view for all posted GL transactions in Dynamics GP

Victoria Yudin — Tue, 11 Aug 2009 15:10:48 GMT

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 GP Reports page...(read more)

Dynamics GP Windows 7 and Server 2008 R2 compatibility announced

Victoria Yudin — Mon, 10 Aug 2009 17:41:42 GMT

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...(read more)

How to get next Monday’s date in Crystal Reports

Victoria Yudin — Wed, 29 Jul 2009 16:37:57 GMT

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...(read more)

Dynamics GP Trial Balance in Excel using FRx

Victoria Yudin — Fri, 17 Jul 2009 18:16:19 GMT

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...(read more)

Suppressing blank lines in Crystal Reports

Victoria Yudin — Wed, 15 Jul 2009 12:24:39 GMT

Here is the latest Crystal Reports tip from the Flexible Solutions GP Reports June 2009 newsletter : how to work with addresses. Dynamics GP (and probably many other systems) stores address components in separate fields, so if we look at a customer address...(read more)

New policy for Dynamics GP service pack support

Victoria Yudin — Fri, 26 Jun 2009 10:27:00 GMT

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...(read more)

SQL view for inventory quantities on hand

Victoria Yudin — Thu, 18 Jun 2009 12:50:56 GMT

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...(read more)

Dynamically change decimal places in Crystal Reports

Victoria Yudin — Tue, 02 Jun 2009 12:16:07 GMT

The May 2009 Flexible Solutions GP Reports Newsletter brings us a tip for dynamically changing decimal places in Crystal Reports. This can be really useful for creating Sales Order Processing (SOP) reports for Dynamics GP, where GP stores the number of...(read more)

Crystal Reports service packs and versions

Victoria Yudin — Mon, 25 May 2009 13:15:57 GMT

Here is a handy list for determining what version and service pack of Crystal Reports you are running: Crystal Reports 2008 XI R2 XI R1 RTM 12.0.0.549 11.5.0.313 11.0.0.895 SP 0 12.0.0.683 SP 1 12.1.0.892 11.5.3.417 SP 2 11.5.8.826 SP 3 11.5.9.1076 11...(read more)