home *** CD-ROM | disk | FTP | other *** search
/ terabyteunlimited.com / 2014.06.terabyteunlimited.com.tar / terabyteunlimited.com / EXTRIT.ZIP / REPORT.TXT < prev    next >
Text File  |  2000-10-17  |  9KB  |  102 lines
  1.  Here's an example report, I've included two spec files that will extract only
  2.  posted transactions and skip account 210241, it will output the following
  3.  information:
  4.  
  5.    Company Name, Report Date, Acct Number, Acct Name, Journal Number,
  6.    Trans Number, Trans Date, Trans Desc, Amount, Report Ref
  7.  
  8.  This is only included as an example so that you can see how Extract It
  9.  works
  10.  
  11.  REPORTSS.SPC only outputs headers and footers once.
  12.  REPORTDB.SPC contains two detail lines to combine the Debit/CR amount into
  13.  one field, it also exports the field names, which in this case the (detail)
  14.  field names could vary.  The detail field names used depends on which detail
  15.  area is output first.
  16.  
  17.  Date : 10/15/95                                          XYZ Company                                            Page no. 1
  18.  Time :  9:53 AM                                        1234 Main Street
  19.                                                           Anytown, USA
  20.  
  21.  
  22.  
  23.                                                  G/L Account Activity Detail Report
  24.                                                    From : 01/01/95 To : 10/31/95
  25.  
  26.  
  27.  Journal  Tran
  28.  Code     No.       Date      Acct.#          Account Name               Description            Debits       Credits     Posted?
  29.   ------   -----   --------  ----------  --------------------------  ------------------------  -----------  -----------  -------
  30.                              2101        Accounts Payable Module     BEGINNING BALANCE                          2729.86
  31.   AP       00081   01/04/95                                          Summary AP Post                            1181.82  Yes
  32.   CH       00099   01/15/95                                          Summary Cash Post             1009.00               Yes
  33.   CH       00100   01/15/95                                          Summary Cash Post             1032.00               Yes
  34.   PO       00073   01/15/95                                          Purchase Order Summary                     1148.58  Yes
  35.   AP       00087   01/19/95                                          Summary AP Post                              82.18  Yes
  36.   AP       00084   01/24/95                                          Summary AP Post                122.16               Yes
  37.   AP       00085   01/24/95                                          Summary AP Post                             181.35  Yes
  38.   CH       00102   01/24/95                                          Summary Cash Post             2121.32               Yes
  39.   PO       00074   01/24/95                                          Purchase Order Summary                      162.66  Yes
  40.   PO       00075   01/24/95                                          Purchase Order Summary         552.55               Yes
  41.   CH       00103   01/31/95                                          Summary Cash Post                           900.00  Yes
  42.   PO       00077   01/31/95                                          Purchase Order Summary                      102.82  Yes
  43.   AP       00089   02/12/95                                          Summary AP Post                             303.25  Yes
  44.   AP       00088   02/27/95                                          Summary AP Post                              16.31  Yes
  45.   CH       00105   02/27/95                                          Summary Cash Post              466.59               Yes
  46.   AP       00092   02/28/95                                          Summary AP Post                              20.70  Yes
  47.   AP       00090   03/01/95                                          Summary AP Post                             110.26  Yes
  48.   AP       00093   03/16/95                                          Summary AP Post                             443.59  Yes
  49.   AP       00091   03/30/95                                          Summary AP Post                              17.67  Yes
  50.   CH       00108   03/30/95                                          Summary Cash Post               60.08               Yes
  51.   AP       00095   04/19/95                                          Summary AP Post                            1805.87  Yes
  52.   AP       00094   04/23/95                                          Summary AP Post                             163.95  Yes
  53.   CH       00109   04/23/95                                          Summary Cash Post              665.20               Yes
  54.   AP       00096   05/15/95                                          Summary AP Post                              48.79  Yes
  55.   AP       00097   05/15/95                                          Summary AP Post                 16.45               Yes
  56.   AP       00101   05/15/95                                          Summary AP Post                             123.55  Yes
  57.   PO       00078   05/21/95                                          Purchase Order Summary                      170.00  Yes
  58.   AP       00098   05/29/95                                          Summary AP Post                              48.79  Yes
  59.   AP       00099   05/29/95                                          Summary AP Post                 48.97               Yes
  60.   AP       00100   05/29/95                                          Summary AP Post                               0.18  Yes
  61.   CH       00112   05/29/95                                          Summary Cash Post             1854.66               Yes
  62.                                                                      CURRENT BALANCE                            1813.20
  63.  
  64.                              210421      State Sales Tax Payable     BEGINNING BALANCE                          1031.84
  65.   BI       00075   01/15/95                                          Billing Summary  - Tax                       41.34  Yes
  66.   AP       00081   01/16/95                                          Summary AP Post               1032.00               Yes
  67.   BI       00076   01/24/95                                          Billing Summary  - Tax                       10.08  Yes
  68.   BI       00077   02/12/95                                          Billing Summary  - Tax                       24.33  Yes        
  69.   BI       00078   02/28/95                                          Billing Summary  - Tax                        1.40  Yes        
  70.   BI       00082   04/30/95                                          Billing Summary  - Tax                        1.73  Yes        
  71.   BI       00081   05/02/95                                          Billing Summary  - Tax                       17.90  Yes
  72.   BI       00083   05/15/95                                          Billing Summary  - Tax                       24.81  Yes        
  73.   BI       00084   05/21/95                                          Billing Summary  - Tax                       19.57  Yes        
  74.   BI       00085   06/11/95                                          Billing Summary  - Tax                       12.12  Yes
  75.  Date : 10/15/95                                          XYZ Company                                            Page no. 2
  76.  Time :  9:53 AM                                        1234 Main Street                                                            
  77.                                                           Anytown, USA
  78.  
  79.  
  80.  
  81.                                                  G/L Account Activity Detail Report                                                 
  82.                                                    From : 01/01/95 To : 10/31/95
  83.  
  84.  
  85.  Journal  Tran                                                                                                                      
  86.  Code     No.       Date      Acct.#          Account Name               Description            Debits       Credits     Posted?    
  87.   ------   -----   --------  ----------  --------------------------  ------------------------  -----------  -----------  -------    
  88.                                                                      CURRENT BALANCE                             153.12             
  89.  
  90.                              21051       Account xyz                 BEGINNING BALANCE                             0.00             
  91.   AP       00084   01/24/95                                          Summary AP Post                             181.35  Yes        
  92.   AP       00085   01/24/95                                          Summary AP Post                181.35               Yes        
  93.   AP       00088   02/27/95                                          Summary AP Post                               0.00  Yes
  94.   AP       00090   03/30/95                                          Summary AP Post                  0.00               Yes        
  95.   AP       00095   04/26/95                                          Summary AP Post                               0.00  Yes        
  96.                                                                      CURRENT BALANCE                               0.00
  97.  
  98.                                                                      TOTAL TRANSACTION             9162.33      7366.95             
  99.  
  100.                                                                      REPORT REF: 387420
  101.  
  102.