Victoria Yudin

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 […]

General Ledger, GP Reports code, 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 […]

General Ledger, GP Reports code, SQL code

SQL view for all GL transactions in Dynamics GP

April 27, 2011 by Victoria Yudin 13 Comments

I have been asked a few times now to add unposted General Ledger transactions to my Posted GL Transactions view. Here it is. This view also excludes voided transactions and introduces new columns for transaction status and source doc. To see more information about GL tables in Dynamics GP, visit my GL Tables page. For more Dynamics […]

General Ledger, GP Reports code, SQL code

SQL view for Payables invoices originating from POP in Dynamics GP

September 1, 2010 by Victoria Yudin 27 Comments

This Dynamics GP SQL view originated from a request on the Dynamics GP customer forum, but is also something that I can see being useful in a variety of situations. It returns all posted Payables invoices that came from the Purchase Order Processing module with details of the items that were received on each invoice as well […]

General Ledger, GP Reports code, GP SQL view, Payables, Purchase Order Processing, SQL code

Updates to SQL view to show all GL distributions for AP transactions

June 25, 2010 by Victoria Yudin 8 Comments

I have made a number of updates to my SQL view to show all GL distributions for AP transactions since I first published it. Some of these were in response to comments asking for additional fields, others were added when I came across new data to test with. Rather than publish another post with the latest revisions, I have updated the […]

General Ledger, GP Reports code, GP SQL view, Payables, SQL code

SQL view with all GL distributions for AR transactions

February 10, 2010 by Victoria Yudin 22 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 […]

General Ledger, GP Reports code, GP SQL view, Receivables, SQL code

What’s with all these dates?

September 8, 2009 by Victoria Yudin 11 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 […]

Dynamics GP

Bank Reconciliation, Dynamics GP, General Ledger, Payables, Purchase Order Processing, Receivables, Sales Order Processing

SQL view for all posted GL transactions in Dynamics GP

August 11, 2009 by Victoria Yudin 58 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 GP Reports page. A few notes on this view: Year-end close transactions are excluded Only functional […]

General Ledger, GP Reports code, GP SQL view, 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, featured, FRx, General Ledger

Where did my transaction go?

April 11, 2009 by Victoria Yudin 5 Comments

This is a common question, especially with new users of Dynamics GP, and I was recently reminded of it by a post in the Microsoft Dynamics GP Newsgroup. While every transaction type will be slightly different, there is a basic lesson that is important for all GP users: beware of the Delete button. Most GP actions are updated automatically […]

Dynamics GP

Dynamics GP, General Ledger, Payables, Sales Order Processing

Sales Transaction Entry GL distributions in Dynamics GP

December 8, 2008 by Victoria Yudin 47 Comments

The topic of General Ledger distributions for Sales Order Processing transactions has been known to cause a fair amount of confusion for Dynamics GP users. I would like to address some of the typical questions we receive on this. Please click on the screen shots to see them larger/clearer. Just to set the stage, I am talking about the […]

Dynamics GP, General Ledger, Sales Order Processing

SQL view for Payables GL distributions in Dynamics GP

November 28, 2008 by Victoria Yudin 83 Comments

Here is a view that will return the General Ledger distributions for all posted or unposted payables transactions. Unposted is also called ‘work’ and posted includes any open or historical transactions. If you’re going to use this with SmartList Buidler, make sure to include the section at the end to grant permissions to DYNGRP. Disclaimer: I […]

General Ledger, GP Reports code, GP SQL view, Payables, SQL code

Year end close in Dynamics GP

November 14, 2008 by Victoria Yudin 70 Comments

Every year we get a slew of phone calls about closing the year in GP. Usually these start in December and I thought I would beat the rush this year. Here are some resources and notes I have compiled over the years on the year end close. I will add to this post as I find more […]

Dynamics GP, Fixed Assets, General Ledger, Inventory, Payables, Payroll, Receivables, year end close

SQL view for Fixed Allocation Accounts in Dynamics GP

SQL view for Variable Allocation Accounts in Dynamics GP

SQL view for all GL transactions in Dynamics GP

SQL view for Payables invoices originating from POP in Dynamics GP

Updates to SQL view to show all GL distributions for AP transactions

SQL view with all GL distributions for AR transactions

What’s with all these dates?

SQL view for all posted GL transactions in Dynamics GP

Dynamics GP Trial Balance in Excel using FRx

Where did my transaction go?

Sales Transaction Entry GL distributions in Dynamics GP

SQL view for Payables GL distributions in Dynamics GP

Year end close 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”