Transactions by Account Report | General Subsidiary User Manual

This function prints the information stored in the Subsidiary Code Postings file, sorted by subsidiary code within account number. The following processing steps accomplish this job.

Step 1In preparation for performing a sort/selection process on the Subsidiary Code Postings information, this step provides sequencing of data records by Account and Subsidiary Code, with no option to change the sequence at run time. Selection of data records is provided by Account Component and Subsidiary Code, with the option to enter user-specified comparisons at run time.
Step 2This disposition type is used for all standard General Subsidiary reports.
Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
Step 4In order to print the Transactions by Account Report, this step formats the Subsidiary Code Postings information. The following data items are shown: Journal Code, Operator ID, Control No, Source Trx No, Reference, Fiscal Month, Fiscal Year, Transaction Date, Description, and Amount. As appropriate, group headings and totals appear whenever a change occurs in Account or Subsidiary Code.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 16:26                                                                                                       LGG Page:  1
                                                   Transactions by Account Report


          Jrnl   Oper/Cntrl    Trx   Ref      Mo/Yr   Trx Date   Description                              Amount
=================================================================================================================================



Account 4190000001MA  Freight Out, Sales/Mfg.


Subsidiary Code JONES  Salesperson Sam Jones

                 SRR / 0000   0000   EOM      02 90   07/13/89   Balance Forward                  3,157
          GL1    SRR / 0157   0004   JE       03 90   08/31/89   August Expenses                  1,485
                                                                                                  ———
                                                             — Subsidiary Code Subtotals —>       4,642
                                                                                                  ======


Subsidiary Code PETERS  Salesperson George Peters

                 SRR / 0000   0000   EOM      02 90   07/13/89   Balance Forward                  2,277
          GL1    SRR / 0157   0004   JE       03 90   08/31/89   August Expenses                  1,239
                                                                                                  ———
                                                             — Subsidiary Code Subtotals —>       3,516
                                                                                                  ======


Subsidiary Code WILLIAMS  Salesperson Kris Williams

                 SRR / 0000   0000   EOM      02 90   07/13/89   Balance Forward                  2,984
          GL1    SRR / 0157   0004   JE       03 90   08/31/89   August Expenses                  1,371
                                                                                                  ———
                                                             — Subsidiary Code Subtotals —>       4,355
                                                                                                  ======

                                                                                                  ———
                                                                     — Account Subtotals —>      12,513
                                                                                                  ======

                                                                                                  ———
                                                                          — Grand Totals —>      12,513
                                                                                                  ======

Option 1Transactions by Account Report