Welcome, Guest. Please Login.
05/15/25 at 07:28:51
News:
Home Help Search Login


Pages: 1
Send Topic Print
report listing ea customers total sales for period (Read 488 times)
Laura  D. Oliver
Active Member
*****




Posts: 985
Gender: female
report listing ea customers total sales for period
10/09/13 at 11:49:31
 
I am looking for a report that will give a one line summary for each customers sales during a certain time period.  
Example"  
  customer              date period                  sales total  
   Acme Co.         1/1/2012 thru   3/31/2012          $5413.00  
   Bad  Co.           1/1/2012 thru   3/31/2012          $6299.00  
   Doall Co          1/1/2012 thru   3/31/2012              $52.00  
   You Co.           1/1/2012 thru   3/31/2012         $12367.00  
   Zebra Co         1/1/2012 thru   3/31/2012            $613.00  
  
 I don't want detail I just want each customers total for the chosen time period.  
 I need to look at all our customers and get a quarterly sales total for each customer so that  I can compare.  
  
 Thanks,
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: report listing ea customers total sales for pe
Reply #1 - 10/09/13 at 13:24:54
 
SA-N and change the RTM name to T6OPSALE.RTM (Evo) or TOPSALE.RTM (DBA).  Sort by customer and enter the date range desired.  One line per customer of total Sales, COGS, Margin and Margin %.
 
SA-M sorted by Item gives the same thing for inventory - 1 line per item with Qty, Sales, COGS, Margin
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print