Custom report for annual sales

[clicker666]

I am looking to create a report that will list all customer account numbers, names, address, total sales amount per invoice, and invoice date for all customers since Jan 1, 2004.

Looking at table info it suggests using SOP10100, SOP10106, and SOP10200. I didn't find a complete history here though, only part of the year. Any ideas which tables I need to query to actually put together this report? I'll whip up a quick VB report based on a SQL statement.

 

[Luvsql]

YOu could just use Smartlist > Receivables, enter date restriction, using Orig Trx Amount for invoice total. You could then just export to excel < format and choose quick pivot table. No programming needed. Make sure to restrict out voids though.

 

[clicker666]

I'll try that once I get back into work and post up, thanks!