RuthO
4Penny.net
Points: 7933

9/26/2011 2:16:32 PM

SQL Query: Sales by Month, with a Running Total

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

This simple query is a starter for an AR report, it displays data by month (sales, payments, net) and adds a running total

The final output looks like this:

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3