Victoria Yudin

Assign sequential numbers in SQL Server Here is a cool little SQL Server tip from the April GP Reports Viewer...
Dynamics GP Trial Balance in Excel using FRx While I work with SQL and Crystal Reports every day, there are some reports...
Using credit cards to pay vendors in Dynamics GP There are a number of different ways to record paying vendors with credit...
SQL view to show AP apply information in GP Here is a corollary to the view I posted last week. The view below will show...

Assign sequential numbers in SQL Server

May 7, 2013 by Victoria Yudin 2 Comments

Here is a cool little SQL Server tip from the April GP Reports Viewer newsletter. Say you have a list of rows and you want to assign sequential numbers to them, so that you always know which one is first, second, etc. Or so that you can display line numbers. This is often a need […]

Dynamics GP, GP Reports code, GP Reports Viewer, SOP SQL code, SQL Server

Dynamics GP, featured, GP Reports code, GP Reports Viewer, Sales Order Processing, SQL code

Dynamics GP Trial Balance in Excel using FRx

July 17, 2009 by Victoria Yudin 40 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 […]

Dynamics GP, FRx, GP 10.0, GP 2010, GP 8.0, GP 9.0

Dynamics GP, featured, FRx, General Ledger

Using credit cards to pay vendors in Dynamics GP

January 4, 2009 by Victoria Yudin 104 Comments

There are a number of different ways to record paying vendors with credit cards in GP. This is a topic that comes up periodically in newsgroups and I would like to share what I have personally found to be the most straightforward and comprehensive way. This is a long one but at least there will be […]

Dynamics GP, GP 10.0, GP 2010, GP 8.0, GP 9.0

Dynamics GP, featured, Payables

SQL view to show AP apply information in GP

October 22, 2008 by Victoria Yudin 60 Comments

Here is a corollary to the view I posted last week. The view below will show you what payments/credit memos were applied to payables transactions in GP. If you have SmartList Builder you can easily incorporate this SQL view into a new SmartList. [Update: You can also use this in Crystal with the changes I made on […]

Dynamics GP, GP Reports code, GP SQL scripts, Payables SQL code

featured, GP Reports code, GP SQL view, Payables, SQL code

SQL view for current Receivables aging detail in Dynamics GP

May 1, 2013 by Victoria Yudin 2 Comments

Another reader request brings us this new script. Below is a view for current Receivables aging in detail. This code is only looking at functional currency and will return one row per open (unpaid) receivables transaction. I am hard-coding the aging using the following buckets and aging by due date: Current 31 to 60 Days 61 to […]

Dynamics GP, GP Reports code, GP SQL scripts, Receivables SQL code

GP Reports code, GP SQL view, Receivables, SQL code

SQL view for current Payables aging detail in Dynamics GP

April 24, 2013 by Victoria Yudin 10 Comments

I have received a few requests for a detailed version my Current Payables Aging Summary view. Here it is. This code is only looking at functional currency and will return one row per open (unpaid) payables transaction. I am hard-coding the aging using the default aging setup installed with GP, which is aging by due date and using the […]

Dynamics GP, GP Reports code, GP SQL scripts, Payables SQL code

GP Reports code, GP SQL view, Payables, SQL code

Changing part of a string in SQL Server using REPLACE

March 11, 2013 by Victoria Yudin 3 Comments

This latest SQL Server tip comes from the Feb/March 2013 GP Reports Viewer newsletter. Have you ever needed to change part of a string in SQL Server? I have seen this come up in a variety of situations, like needing to change account names in the General Ledger or needing to show something differently when […]

Dynamics GP, GP Reports code, GP Reports Viewer, SQL coding, SQL Server

GP Reports code, GP Reports Viewer, SQL code

SQL view for sales quantities by item by site by year

February 28, 2013 by Victoria Yudin 2 Comments

Below is another variation on my view for sales by item by year and view for sales quantities by item by year. This one shows the total item quantity sold by site by year. The view below makes a number of assumptions (listed in the view comments in green), and I am hard coding years from 2006 through 2013 […]

Dynamics GP, GP Reports code, GP SQL scripts, SOP SQL code

GP Reports code, Sales Order Processing, SQL code

SQL view for Fixed Allocation Accounts in Dynamics GP

January 23, 2013 by Victoria Yudin 4 Comments

Below is a view that will return a list of the distribution accounts and percentages for all active fixed allocation accounts in your Dynamics GP. Nothing fancy, but sometimes it is easier to have a report of these rather than have to look at them on the screen, especially when you have a lot of […]

Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts

General Ledger, GP Reports code, SQL code

Happy New Year – 2013

January 1, 2013 by Victoria Yudin 22 Comments

It’s now become a little tradition of mine to sit in front of the computer when I get up on New Year’s Day, sipping coffee and checking my email…hoping that I once again can write a little blog post like this one. I just got that email I was waiting for, letting me know that […]

Dynamics GP, Microsoft

awards, Dynamics GP, Microsoft MVP

How to add a sparkline to a report in SSRS

November 27, 2012 by Victoria Yudin 3 Comments

Introduction: This blog post is written by my friend and colleague Mickie Stamm. Mickie is a fabulous Dexterity, SQL and application developer and is one of the great minds behind GP Reports Viewer. By Mickie Stamm: In the last GP Reports Viewer newsletter I wrote about using rectangles as containers in SQL Server Reporting Services […]

Dynamics GP, GP Reports Viewer, SSRS

Dynamics GP, GP Reports Viewer, SQL Server, SSRS

Voiding a partially applied Payables transaction in Dynamics GP

October 11, 2012 by Victoria Yudin 4 Comments

Periodically I get calls or see questions online about how to void a partially applied Payables transaction in Dynamics GP. This is one area where the Payables module differs drastically from the Receivables module and you have to jump through some hoops to actually accomplish this. The issue is that when you go to void […]

Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 8.0, GP 9.0

Dynamics GP, Payables

Big announcement for Microsoft Dynamics GP’s Extender module

October 8, 2012 by Victoria Yudin 19 Comments

Last week, while searching for something on Microsoft’s PartnerSource, I came across an announcement that Microsoft is discontinuing sales of the Extender module and that both sales and support of Extender will revert back to eOne Solutions, the original developer of Extender, starting February 1, 2013. Please note that eOne has always sold a more […]

Dynamics GP, Extender, Microsoft

Coding for specific dates in Crystal Reports

September 18, 2012 by Victoria Yudin 2 Comments

Below is an old tip from one of the GP Reports Viewer monthly newsletters. In the past few months I have had to look this up several times, because I just cannot seem to remember the syntax, so I thought I would put it on my blog, where it will be easier for to find […]

Crystal Reports, Crystal tips for GP, GP Reports Viewer

Crystal Reports, GP Reports code, GP Reports Viewer

SQL view for rolling 12 months of sales by item in Dynamics GP

August 27, 2012 by Victoria Yudin 4 Comments

Rolling twelve month reports are not always very easy to create, and I have been seeing more requests for them, so I thought I would show an example of one way to do this. The view below is a variation of my sales by item by month view, however instead of specifying all months in […]

Dynamics GP, GP Reports code, GP SQL scripts, Inventory SQL code, SOP SQL code

GP Reports code, Inventory, Sales Order Processing, SQL code

SQL view for Variable Allocation Accounts in Dynamics GP

August 23, 2012 by Victoria Yudin 7 Comments

Below is a view that will return a list of the distribution and breakdown accounts for all active variable allocation accounts in your Dynamics GP. Nothing fancy, but sometimes it is easier to have a report of these rather than have to look at them on the screen, specially since you have to click on […]

Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts

General Ledger, GP Reports code, SQL code

SQL view for commissions details in Dynamics GP

July 19, 2012 by Victoria Yudin 3 Comments

Commissions are typically difficult to create generic reports for, as many companies have unique commission structures. We find that out-of-the-box functionality in GP does not really work for most companies and often the commissions are recorded in ways other than what was intended. That said, if you find that you are using the commissions functionality […]

Dynamics GP, GP Reports code, GP SQL scripts, Receivables SQL code, SOP SQL code

GP Reports code, Receivables, Sales Order Processing, SQL code

Older Entries

Victoria Yudin

Assign sequential numbers in SQL Server

Dynamics GP Trial Balance in Excel using FRx

Using credit cards to pay vendors in Dynamics GP

SQL view to show AP apply information in GP

SQL view for current Receivables aging detail in Dynamics GP

SQL view for current Payables aging detail in Dynamics GP

Changing part of a string in SQL Server using REPLACE

SQL view for sales quantities by item by site by year

SQL view for Fixed Allocation Accounts in Dynamics GP

Happy New Year – 2013

How to add a sparkline to a report in SSRS

Voiding a partially applied Payables transaction in Dynamics GP

Big announcement for Microsoft Dynamics GP’s Extender module

Coding for specific dates in Crystal Reports

SQL view for rolling 12 months of sales by item in Dynamics GP

SQL view for Variable Allocation Accounts in Dynamics GP

SQL view for commissions details in Dynamics GP

Search this blog:

My Book

Email Subscription

GP Reports Viewer Newsletter

RSS Feeds

Latest Tweets

Links

Forums

Blogroll

Pages

Categories

Hits since 9.17.2008

Archives

Follow “Victoria Yudin”