Archive by Author

Crystal Reports is not going anywhere

June 2, 2010 by Victoria Yudin 1 Comment

Are you using Crystal Reports with Dynamics GP? Are you starting to hear rumors that Crystal Reports is not supported with GP anymore? Don’t worry, Crystal Reports is not going anywhere.  For more on this, take a look at my latest article for MSDynamicsWorld.com, The Good News for Users of Crystal Reports with Microsoft Dynamics GP. 

Continue reading →
Crystal Reports, Dynamics GP
, , , ,

Microsoft Dynamics Top 100 Most Influential People of 2010

May 26, 2010 by Victoria Yudin 2 Comments

Earlier this week DynamicsWorld.co.uk announced their annual Microsoft Dynamics Top 100 Most Influential People. Thanks to your votes I made it to # 51 on this list, joined by many names you will recognize. You can see a short bio for each person on the list by clicking on the heading for the section they are in. Thanks again […]

Continue reading →
Dynamics GP, Microsoft, Miscellaneous
, ,

Decisions, decisions

May 18, 2010 by Victoria Yudin 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 […]

Continue reading →
Dynamics GP, Events, GP Reports Viewer
,

Support Debugging Tool new build released

May 17, 2010 by Victoria Yudin 1 Comment

Developed by David Musgrave, known to the entire GP community as the king of all things Dexterity, the Support Debugging Tool for Dynamics GP has been around for quite a while, but I have only recently started to see the benefits of it and I wanted to share one cool feature in some detail. One of […]

Continue reading →
Dynamics GP, GP 2010
, ,

Spring cleaning

May 15, 2010 by Victoria Yudin 5 Comments

It’s been a long time coming. I have changed this blog around a bit in an attempt to freshen up the look and organize things better.  Of course in the short term that means it may be difficult to find things, so if you’re looking for something that was here and cannot find it, please let […]

Continue reading →
Miscellaneous

SQL view with security and SmartList details in GP

May 13, 2010 by Victoria Yudin 27 Comments

Robert Cavill from Emeco in Australia has sent me an amazing update to my Security Roles and Tasks in Dynamics GP SQL script that includes SmartList objects. This script was originally written for GP 10.0 and GP 2010, but will also work with GP 2013 and GP 2015. To get the most out of this script […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP Reports code, System/Setup SQL code
, , , , ,

GP 2010 Cookbook

May 6, 2010 by Victoria Yudin 1 Comment

Dynamics GP MVP Mark Polino has been an amazing contribution to the entire Dynamics GP community for many years now with his blog, advice on forums and fabulous presentations, like 50 Tips in 50 Minutes and  50 More Tips in 50 Minutes. Now we’ll be able to get even more of Mark’s great advice in his upcoming […]

Continue reading →
Dynamics GP, GP 2010
, ,

It’s here!

May 4, 2010 by Victoria Yudin 8 Comments

GP 2010 is now available for download on both CustomerSource and PartnerSource. According to the poll I have had on this blog for about two months, almost 60% of those who responded have plans to upgrade to GP 2010 and another 5% are already on it. 11% chose “What’s GP 2010?” – not sure if they’re joking, stumbled upon my blog […]

Continue reading →
Dynamics GP, GP 2010
, ,

How to find all SQL tables with a column name

April 23, 2010 by Victoria Yudin 8 Comments

Often I need to find all the tables in Dynamics GP that have a particular column or search for all columns where I only have a partial column name. Over the years I have seen lots of different code to accomplish this, so this is nothing new. But I am asked about this enough that […]

Continue reading →
GP Reports code, SQL coding, SQL Server
,

SQL view for Fixed Assets depreciation in Dynamics GP

April 7, 2010 by Victoria Yudin 21 Comments

Below is a view I have put together to get the monthly Fixed Assets depreciation amounts in Dynamics GP. For more detail on the Fixed Assets module, please visit my Fixed Assets Tables page. If you’re looking for more SQL code, you can find it on my GP Reports page. ~~~~~ CREATE VIEW view_FA_Depreciation AS /******************************************************************* view_FA_Depreciation Created on […]

Continue reading →
Dynamics GP, Fixed Assets SQL code, GP Reports code, GP SQL scripts
, , ,

Checkboxes in Crystal Reports

March 26, 2010 by Victoria Yudin 7 Comments

This Crystal Reports tip comes from the January edition of our GP Reports Viewer Newsletter. There are often times when a report is printed so that someone can go down the list and verify items or see where information may be missing. While it was a little more timely in January, at the time of the newsletter, confirming […]

Continue reading →
Crystal Reports, Crystal tips for GP, GP Reports code
,

There’s a new blog in town

March 24, 2010 by Victoria Yudin 5 Comments

Ron Wilson, who you may have seen posting on various Dynamics GP forums and newsgroups, has recently started a blog called Real Life Dynamics User. Ron has been busy posting tips and tricks, sharing his experiences with Dynamics GP and posting useful SQL scripts and views. Keep up the great work, Ron! For the Office Space fans out there, […]

Continue reading →
Dynamics GP, GP Reports code, Miscellaneous
, ,

When will you be upgrading to Dynamics GP 2010?

March 16, 2010 by Victoria Yudin 0 Comments

There are only 23 votes so far, but as of now the leading answer is a plan to upgrade to GP 2010 by the end of the year: And a special shout out to the person who took me up on my joke and answered ‘What’s GP 2010?’! If you are looking at GP 2010, […]

Continue reading →
Dynamics GP, GP 2010
, , ,

Dynamics GP polls

March 12, 2010 by Victoria Yudin 2 Comments

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 half.  And a total of 14% […]

Continue reading →
Dynamics GP, GP 2010
, ,

SQL view with AR apply detail

February 15, 2010 by Victoria Yudin 92 Comments

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 apply information in Dynamics GP. For more views like this, check out […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Receivables SQL code
, , ,

SQL view with all GL distributions for AR transactions

February 10, 2010 by Victoria Yudin 48 Comments

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 that are typically not needed and add underscores to the column names so […]

Continue reading →
Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts, Receivables SQL code
, , , ,

Maximizing Dynamics GP online resources

February 2, 2010 by Victoria Yudin 4 Comments

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 and talks  about how to get the most out of the many fabulous online resources available now for […]

Continue reading →
Dynamics GP
, ,

Selective highlighting in Crystal Reports

January 15, 2010 by Victoria Yudin 3 Comments

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 all customers with balances of $50,000 or higher more visible?  Here are the steps to […]

Continue reading →
Crystal Reports, Crystal tips for GP, GP Reports code
,
Newer Entries
Older Entries