Feeds:
Posts
Comments

Posts Tagged ‘Receivables’

SQL view with AR apply detail

Posted in GP Reports, GP SQL scripts, tagged , , , on February 15, 2010 | 4 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 my [...]

Read Full Post »

SQL view with all GL distributions for AR transactions

Posted in GP Reports, GP SQL scripts, tagged , , , , on February 10, 2010 | 5 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 [...]

Read Full Post »

What’s with all these dates?

Posted in Dynamics GP, tagged , , , , , , on September 8, 2009 | 6 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 [...]

Read Full Post »

SQL view for all unapplied Receivables transactions in Dynamics GP

Posted in GP Reports, GP SQL scripts, tagged , , , on September 5, 2009 | 2 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 other SQL code, please visit my GP Reports page.
~~~~~
CREATE VIEW [...]

Read Full Post »

SQL view with all posted Receivables transactions

Posted in GP Reports, GP SQL scripts, tagged , , , on April 24, 2009 | 8 Comments »

Below is code to create a SQL view that returns all the posted Receivables transactions in Dynamics GP. I have had an abbreviated version of this view on my GP Reports page for a while, but I cleaned it up a bit and gave it some more friendly column names. I also added values for the commonly used [...]

Read Full Post »

Older Posts »