Here's an example report, I've included two spec files that will extract only posted transactions and skip account 210241, it will output the following information: Company Name, Report Date, Acct Number, Acct Name, Journal Number, Trans Number, Trans Date, Trans Desc, Amount, Report Ref This is only included as an example so that you can see how Extract It works REPORTSS.SPC only outputs headers and footers once. REPORTDB.SPC contains two detail lines to combine the Debit/CR amount into one field, it also exports the field names, which in this case the (detail) field names could vary. The detail field names used depends on which detail area is output first. Date : 10/15/95 XYZ Company Page no. 1 Time : 9:53 AM 1234 Main Street Anytown, USA G/L Account Activity Detail Report From : 01/01/95 To : 10/31/95 Journal Tran Code No. Date Acct.# Account Name Description Debits Credits Posted? ------ ----- -------- ---------- -------------------------- ------------------------ ----------- ----------- ------- 2101 Accounts Payable Module BEGINNING BALANCE 2729.86 AP 00081 01/04/95 Summary AP Post 1181.82 Yes CH 00099 01/15/95 Summary Cash Post 1009.00 Yes CH 00100 01/15/95 Summary Cash Post 1032.00 Yes PO 00073 01/15/95 Purchase Order Summary 1148.58 Yes AP 00087 01/19/95 Summary AP Post 82.18 Yes AP 00084 01/24/95 Summary AP Post 122.16 Yes AP 00085 01/24/95 Summary AP Post 181.35 Yes CH 00102 01/24/95 Summary Cash Post 2121.32 Yes PO 00074 01/24/95 Purchase Order Summary 162.66 Yes PO 00075 01/24/95 Purchase Order Summary 552.55 Yes CH 00103 01/31/95 Summary Cash Post 900.00 Yes PO 00077 01/31/95 Purchase Order Summary 102.82 Yes AP 00089 02/12/95 Summary AP Post 303.25 Yes AP 00088 02/27/95 Summary AP Post 16.31 Yes CH 00105 02/27/95 Summary Cash Post 466.59 Yes AP 00092 02/28/95 Summary AP Post 20.70 Yes AP 00090 03/01/95 Summary AP Post 110.26 Yes AP 00093 03/16/95 Summary AP Post 443.59 Yes AP 00091 03/30/95 Summary AP Post 17.67 Yes CH 00108 03/30/95 Summary Cash Post 60.08 Yes AP 00095 04/19/95 Summary AP Post 1805.87 Yes AP 00094 04/23/95 Summary AP Post 163.95 Yes CH 00109 04/23/95 Summary Cash Post 665.20 Yes AP 00096 05/15/95 Summary AP Post 48.79 Yes AP 00097 05/15/95 Summary AP Post 16.45 Yes AP 00101 05/15/95 Summary AP Post 123.55 Yes PO 00078 05/21/95 Purchase Order Summary 170.00 Yes AP 00098 05/29/95 Summary AP Post 48.79 Yes AP 00099 05/29/95 Summary AP Post 48.97 Yes AP 00100 05/29/95 Summary AP Post 0.18 Yes CH 00112 05/29/95 Summary Cash Post 1854.66 Yes CURRENT BALANCE 1813.20 210421 State Sales Tax Payable BEGINNING BALANCE 1031.84 BI 00075 01/15/95 Billing Summary - Tax 41.34 Yes AP 00081 01/16/95 Summary AP Post 1032.00 Yes BI 00076 01/24/95 Billing Summary - Tax 10.08 Yes BI 00077 02/12/95 Billing Summary - Tax 24.33 Yes BI 00078 02/28/95 Billing Summary - Tax 1.40 Yes BI 00082 04/30/95 Billing Summary - Tax 1.73 Yes BI 00081 05/02/95 Billing Summary - Tax 17.90 Yes BI 00083 05/15/95 Billing Summary - Tax 24.81 Yes BI 00084 05/21/95 Billing Summary - Tax 19.57 Yes BI 00085 06/11/95 Billing Summary - Tax 12.12 Yes Date : 10/15/95 XYZ Company Page no. 2 Time : 9:53 AM 1234 Main Street Anytown, USA G/L Account Activity Detail Report From : 01/01/95 To : 10/31/95 Journal Tran Code No. Date Acct.# Account Name Description Debits Credits Posted? ------ ----- -------- ---------- -------------------------- ------------------------ ----------- ----------- ------- CURRENT BALANCE 153.12 21051 Account xyz BEGINNING BALANCE 0.00 AP 00084 01/24/95 Summary AP Post 181.35 Yes AP 00085 01/24/95 Summary AP Post 181.35 Yes AP 00088 02/27/95 Summary AP Post 0.00 Yes AP 00090 03/30/95 Summary AP Post 0.00 Yes AP 00095 04/26/95 Summary AP Post 0.00 Yes CURRENT BALANCE 0.00 TOTAL TRANSACTION 9162.33 7366.95 REPORT REF: 387420