APPX Software Library

1Transaction Processing

Option 3Journal Entries Journal

This function prints a journal of transactions entered through the Journal Entries function. The following processing steps accomplish this job.

  1. Step 1In preparation for performing a sort/selection process on the Journal Entries information, this step provides sequencing of data records by Post Now?, Currency Code, Operator ID, Control No, Post Year, and Post Month, with no option to change the sequence at run time. Selection of data records is provided by Currency Code, Operator ID, Control No, Print Journal?, and Journal OK?, with the option to enter user-specified comparisons at run time.
  2. Step 2This disposition type is used for all transaction file journals.
  3. Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 4In order to print the Journal Entries Journal, this step formats the Journal Entries and Journal Entry Items information. The following data items are shown: Transaction No, Description, Journal Code, Reference, Date, Auto Reverse?, Intercompany, Intercompany Reference, Currency Rate, Line Item, Account, Sub Type, Subsidiary Code, Adj?, Sources/Uses/Neither (S/U/N), Home Amount, and Amount. As appropriate, group headings appear whenever a change occurs in Control No or Post Month. If requested, totals appear whenever a change occurs in Post Month, Control No, or Currency Code. When totals are specified, the following items are accumulated: Total Home Amount, Total Amount, Control Total, Remaining control, Account Hash total, Current Hash Total, and Remaining Hash Amount. Grand totals print at the end, showing Number of Journal Errors and Journal Warnings.

A sample output is shown below:

                                                     APPX Demonstration Company
11/30/94 10:41                                                                                                       LGG Page:  1
                                                      Journal Entries Journal


Trx   Description                     Jrnl  Refernc   Date     Rev?  Interco   Currency Rate
=================================================================================================================================

Control Group SRR / 0159  August 1989 Monthly Entries

Post Month/Year  08 / 89

0001  August Pyaments on A/P          GL2   JE      08/31/89   N

      Line    Account                                          Subsidiary Code         Adj  SUN    Home Amount            Amount

      0001    2010001000    Accounts Payable, Corporate                                N                               109370.10
      0002    2010001001    Accounts Payable, Sales                                    N                                96585.31
      0003    1010001000    Cash, Corporate                                            N                               109370.10-
      0004    1010001001    Cash, Sales Outlets                                        N                                96585.31-
                                                                                                ______________    ______________
                                                                    — Line Items Total —>                                   0.00
                                                                                                ==============    ==============

0002  August Mortgage Payment         GL2   JE      08/31/89   N

      Line    Account                                          Subsidiary Code         Adj  SUN    Home Amount            Amount

      0001    2060100000    Mortgages Payable                                          N                                27758.00
      0002    4140000000    Interest Expense                                           N                                12242.00
      0003    1010001000    Cash, Corporate                                            N                                40000.00-
                                                                                                ______________    ______________
                                                                    — Line Items Total —>                                 0.00
                                                                                                ==============    ==============

0003  August Sales Commissions        GL2   JE      08/31/89   N

      Line    Account                                          Subsidiary Code         Adj  SUN    Home Amount            Amount

      0001    4020000001MA  Sales Commissions, Mfg.            GL JONES                N                                13674.22
      0002    4020000001MA  Sales Commissions, Mfg.            GL PETERS               N                                12502.14
      0003    4020000001MA  Sales Commissions, Mfg.            GL WILLIAMS             N                                12892.83
      0004    4020000001WH  Sales Commissions, Wholesale                               N                                19522.64
      0005    2040000000    Accrued Payroll                                            N                                58591.83-
                                                                                                ______________    ______________
                                                                    — Line Items Total —>                                 0.00
                                                                                                ==============    ==============

0004  Tax Accrual                     GL2   JE      08/31/89   N

      Line    Account                                          Subsidiary Code         Adj  SUN    Home Amount            Amount

      0001    4120000001    Tax Expense, Sales Outlets                                 N                                40327.60
      0002    2020001001    Sales Tax Payable, Sales                                   N                                40327.60-
                                                                                                ______________    ______________
                                                                    — Line Items Total —>                                 0.00
                                                                                                ==============    ==============


                                                                                                ______________    ______________
                                                        — Post Month/Year 08 89 Totals —>                                 0.00
                                                                                                ==============    ==============

                                                                                                ______________    ______________
                                                                — Control Group Totals —>                                 0.00
                                                                                                ==============    ==============

Control Group: SRR / 0159  August 1989 Monthly Entries                                  Entered       Calculated       Difference
Currency:                                                        Control Totals:                             .00
Exclusive?     N                                                 Hash Totals:                     37510106008
Post Now?      N
=================================================================================================================================

                                                                                                ______________    ______________
                                                              —   Home Currency Totals —>                                 0.00
                                                                                                ==============    ==============
=================================================================================================================================
  1. Step 5In order to print the General Ledger Journal Summary, this step formats the Distributions information. The following data items are shown: Post Year, Post Month, Account, Description, Journal Code, Operator Id, Auto Reverse?, Transaction Date, Debits, and Credits.

A sample output is shown below.

                                                     APPX Demonstration Company
11/30/94 10:42                                                                                                       LGG Page:  1
                                                   General Ledger Journal Summary


st Post                                                       Op        Trx
Yr   Mo   Account       Account Name                    Jrnl  ID    R?  Date            Debits        Credits
=================================================================================================================================
89   08   1010001000    Cash, Corporate                 GL2   SRR   N   08/31/89                    149370.10-
89   08   1010001001    Cash, Sales Outlets             GL2   SRR   N   08/31/89                     96585.31-
89   08   1020002000    Cash, Canadian Corporate        GL2   SRR   N   08/31/89      42946.52
89   08   1020002001    Cash, Canadian Sales Outlets    GL2   SRR   N   08/31/89      17109.26
89   08   1030002000MA  Accts Rec, Canadian Corp/Mfg    GL2   SRR   N   08/31/89                     42166.02-
89   08   1030002000WH  Accts Rec, Canadian Corp/Whls   GL2   SRR   N   08/31/89                     34405.07-
89   08   1030002001MA  Accts Rec, Canadian Sales/Mfg.  GL2   SRR   N   08/31/89                     27774.61-
89   08   1030002001WH  Accts Rec, Canadian Sales/Whls  GL2   SRR   N   08/31/89                     22875.16-
89   08   1040002000MA  Retent Rec, Canadian Corp/Mfg   GL2   SRR   N   08/31/89                       283.05-
89   08   1040002000WH  Retent Rec, Canadian Corp/Whls  GL2   SRR   N   08/31/89                       371.70-
89   08   1040002001MA  Retent Rec, Canadian Sales/Mfg  GL2   SRR   N   08/31/89                      1125.89-
89   08   1040002001WH  Retent Rec, Canadian Sales/Whl  GL2   SRR   N   08/31/89                       681.08-
89   08   1070002000MA  Inventory, Canadian Corp./Mfg.  GL2   SRR   N   08/31/89      11955.58
89   08   1080002000MA  Work in Proc, Canada Corp/Mfg   GL2   SRR   N   08/31/89                     11955.58-
89   08   1090002000MA  Finished Goods, Canadian        GL2   SRR   N   08/31/89                     19391.35-
89   08   1100002000WH  Resale Inventory, Canadian      GL2   SRR   N   08/31/89      19391.35
89   08   2010001000    Accounts Payable, Corporate     GL2   SRR   N   08/31/89     109370.10
89   08   2010001001    Accounts Payable, Sales         GL2   SRR   N   08/31/89      96585.31
89   08   2010002000    Accts Payable, Canadian Corp.   GL2   SRR   N   08/31/89      34279.33
89   08   2010002001    Accts Payable, Canadian Sales   GL2   SRR   N   08/31/89      35347.47
89   08   2020001001    Sales Tax Payable, Sales        GL2   SRR   N   08/31/89                     40327.60-
89   08   2040000000    Accrued Payroll                 GL2   SRR   N   08/31/89                     58591.83-
89   08   2060100000    Mortgages Payable               GL2   SRR   N   08/31/89      27758.00
89   08   4020000001MA  Sales Commissions, Mfg.         GL2   SRR   N   08/31/89      39069.19
89   08   4020000001WH  Sales Commissions, Wholesale    GL2   SRR   N   08/31/89      19522.64
89   08   4120000001    Tax Expense, Sales Outlets      GL2   SRR   N   08/31/89      40327.60
89   08   4140000000    Interest Expense                GL2   SRR   N   08/31/89      12242.00
                                                                                  _____________  _____________
                                                          — Grand Totals —>        505904.35      505904.35-
                                                                                  =============  =============