Customer Transaction Activity Report sample

01/21/99 Thu 15:56 Co: 4 H & H Distributing- NxTrend Technology arra Oper: sld Page: 2				  
                                            Accounts Receivable Transaction Activity Report	
			  
Inv # Type St Seq# Inv Dt Due Dt Disc Dt Jrnl # Per Orig Amt Tot Amt Paid Amt Disc Taken Amt Due			  
-----------------------------------------------------------------------------------------------				  
Customer #: 7 Hitchcock Hardw Current Balance: 6422.99				  
1-99 CM  I  01/21/99 02/20/99 01/31/99 2606  299     1.00- 1.00-     0.00     0.00  0.00 
Reference: Overcharged                     IN#        1-99 01/21/99 
1-99 IN  A  01/21/99 02/20/99 01/31/99 2606  299     10.00 10.50 
Reference: Invoice for postage 				  
CM  I  01/21/99                   2606  299      1.00- 				  
Reference:  				  
SP  I  001 01/21/99 02/20/99 01/31/99 2606       10.00 (CR Applied) 1.00 				  
Reference:                                 CM# 1-99 01/21/99 				  
SP  A  002 01/21/99 02/20/99 01/31/99 Period 1    9.00					    9.00				
Reference: Invoice for postage 
SP  A  003 01/21/99 02/20/99 01/31/99 Period 1    0.50					    0.50 
Reference: Correct surcharge               DM# 2-99 01/21/99
2-99 DM  I  01/21/99 02/20/99 01/31/99 2606 299        0.50     0.50     0.00   0.00    0.00 
Reference: Correct surcharge               IN# 1-99 01/21/99 
870-00 IN  A  01/21/99 02/20/99 01/31/99 2605 299      6112.05    6112.05
SP  A  001 01/21/99 02/20/99 01/31/99 Period 1  3056.03					   3056.03 
SP  A  002 01/21/99 03/07/99 03/07/99 Period 1  3056.02					   3056.02 
871-00 IN  A  01/21/99 02/20/99 01/31/99 2604 299       337.49     337.49
SP  I  001 01/21/99 02/20/99      2604           200.00 (CK 0)  200.00      0.00 
SP  A  002 01/21/99 02/20/99 01/31/99 Period 1    68.75					    68.75 
SP  A  003 01/21/99 03/07/99 03/07/99 Period 1    68.74					    68.74
872-00 IN  A  01/21/99 02/20/99 01/31/99  2605 299      128.95      128.95
SP  A  001 01/21/99 02/20/99 01/31/99 Period 1    64.48					    64.48 
SP  A  002 01/21/99 03/07/99 03/07/99 Period 1    64.47					    64.47 
219-99 SC  I  01/21/99 01/21/99 01/21/99   2606 299      11.00      11.00
Reference: Restock for special order 
RV  I  01/21/99                     2606 299      11.00 
Reference: Per salesrep llr 
SP  I  001 01/21/99 01/21/99 01/21/99 2606        11.00 (Reversed) 
Reference: Restock for special order 
SP  A  001 01/21/99 01/21/99 01/21/99 Svc Chg 299 50.00					    50.00 
Reference: Expedite for #1870 
219-99 SC  A  01/21/99 01/21/99 01/21/99 2609 299        50.00     50.00
Reference: Expedite for #1870 
RV  I  01/21/99                   2606 299        11.00 
Reference: Per salesrep llr 
SP  I  001 01/21/99 01/21/99 01/21/99 2606        11.00 (Reversed) 
Reference: ervice charge 
SP  A  001 01/21/99 01/21/99 01/21/99 Svc Chg     50.00                               50.00 
Reference: Expedite for #1870 
9-99 CD  I  01/21/99 01/21/99 01/21/99 2606 299          14.00     14.00
Reference: cod 
SP  I  01/21/99 01/21/99 01/21/99 2606 299        14.00 (Reversed) 
Reference: cod 
RV  I  01/21/99			   2607 299        14.00 
Reference:					 Per Salesrep 349 
-------------------------------------------------------------- 
Total Invoice Records: 10					         7262.99    7263.49   201.00   0.00   
  6437.99
Misc Cred:
5-99 MC  A  001 01/21/99                 2606 299           15.00-
					 15.00- 
Reference:Check #23984 
-------------					                            ------------- 
Total Active Misc Credits:                                  15.00-					                               
                           15.00-
Rebates:
RB     01/21/99			  2606 299        12.00 
Reference: Inv. 1870 
------------- 
Total Rebates:                                              12.00
Checks:
CK     01/21/99		        2603 299      100.00 Ck 21-394830 
Reference: OE 1871-00 Downpayment 
CK     01/21/99                  2603 299       100.00 Ck: MO-3984 
Reference: Additional deposit 
Total					 Checks:                200.00
------------- 
Total Due:
					                                                              6422.99
Total Invoice Records: 10					     7262.99      7263.49   201.00   0.00    
   6437.99
Total Active Misc Credits:                              15.00-	
				             15.00-Total Due:					             6422.99
Tran (Transaction):
IN=Invoice RB=Rebate SP=Sched. Pay SC=Svc. Charge
MC=Misc.Credit CM=Credit Memo CK=Check DM=Debit Memo
RV=Reversal CD=C.O.D. UC=Unapplied Cash 
Scheduled Payments Show Sequence Number