APPX Software Library

2Monthly Processing

Option 2Purchases GL Distributions Report

This function prints two reports, one detailed and one summary, of the General Ledger distributions resulting from the current month’s invoice postings. The following processing steps accomplish this job.

  1. Step 1This function is used to select the “summary only” option option for the Purchase GL Distributions Report.

On the following pages, the screen displayed by this function is shown.

The screen shown below allows you to choose to print the detail and summary reports or the summary report only.

Purchases GL Distributions screen

The Accounts Payable Purchases GL Distributions Screen
Figure 31

Data items for the preceding screen are described below:

Print Summary?

Y or N Default N Required

Enter ‘Y’ to print only the summary report. Enter ‘N’ to include the detail.

Press ENTER to save the information on this screen.

  1. Step 2In preparation for performing a sort/selection process on the MTD Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account, Operator ID and Transaction No, giving additional sort order choice by Account component, with the option to change modifiable parameters at run time. Selection of data records is provided by Post Year, Post Month, Account, and Account Component, with option to enter user-specified comparisons at run time.
  2. Step 3This disposition type is used for all standard Accounts Payable reports.
  3. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 5In order to print the report requested, this step formats the MTD Postings information. The following data items are shown: Operator ID, Control Number, Transaction No, Vendor No, Vendor name, Invoice/Check No, Transaction Type Abbreviation, Transaction Date, Description, Debit Amount and Credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account, or Account Component. If requested, totals appear whenever a change occurs in Account, Account Component, or Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, Net Change Amount Total, Amount, and Amount Total. Grand totals print at the end.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 10:10                                                                                                       LGG Page:  1


                                                    Purchases GL Distributions

Op  Ctrl Trx  Vendor                            Invc/Chk Trx Date     Description                Debits       Credits    Net
Change
=================================================================================================================================

Post Month/Year 08 89


Account 1030002000WH  Accts Rec, Canadian Corp/Whls

MRC   15 0001 00000080 Sam Jones                12345678 INV 08/12/94 This is a test          1000.00           .00
                                                                                           ____________  ___________ ____________
                                                           — Current Month Totals —>          1000.00           .00       1000.00
                                                           — Beginning GL Balance —>                                    117433.40
                                                                                                                     ____________
                                                                  — Account Total —>                                    118433.40
                                                                                           ============  =========== ============


Account 2010001001  Accounts Payable, Sales

MRC   15 0001 00000080 Sam Jones                12345678 INV 08/12/94 Invoice Description           .00      1000.00-
SRR    7 0001 00000020 Pool and Associates      9852-6   INV 08/02/89 brochure                      .00      2410.00-
SRR    8 0001 00000100 Kris Williams            ER1009   INV 08/12/89 Aug. expenses thru 8/1        .00      1156.33-
SRR    7 0002 00000030 Mountain Air Conditionin 10256    INV 07/30/89 misc. materials               .00       291.60-
SRR    8 0002 00000090 George Peters            ER1012   INV 08/12/89 Aug. expenses thru 8/1        .00      1098.50-
SRR    7 0003 00000050 Hardware Services, Inc.  03056    INV 08/05/89 equipment repair              .00       625.88-
SRR    8 0003 00000080 Sam Jones                ER1005   INV 08/12/89 Aug. expenses thru 8/1        .00      1216.90-
SRR    7 0004 00000050 Hardware Services, Inc.  05981    INV 08/07/89 belt repair                   .00       432.81-
SRR    8 0004 00000010 Evergreen Landscaping    L9980    INV 08/14/89 Office landscaping            .00       620.00-
SRR    7 0005 00000030 Mountain Air Conditionin 2215AC   INV 07/30/89 AC repair                     .00       604.79-
SRR    8 0005 00000010 Northwest Interiors      221      INV 08/14/90 New lobby plants              .00       305.00-
SRR    7 0006 00000060 Travel Planners          11596-1  INV 08/01/89 Jones to DC                   .00        985.60-
SRR    8 0006 00000060 Travel Planners          11102-1  INV 08/14/89 Williams to Sacramento        .00       386.10-
SRR    7 0007 00000060 Travel Planners          11562-0  INV 08/04/89 Williams to San Diego         .00       487.00-
SRR    8 0007 00000040 Albert Materials, Inc.   96215    INV 08/14/89 Materials                     .00      2058.00-
SRR    7 0008 00000060 Travel Planners          11598-1  INV 08/05/89 Jones to Columbus             .00       742.50-
SRR    8 0008 00000010 Neighborhood Directory   P09844   INV 08/14/89 Yellow page ad                .00       250.00-
SRR    7 0009 00000060 Travel Planners          11600-0  INV 08/09/89 Peters to Memphis             .00       802.00-
SRR    7 0010 00000060 Travel Planners          11651-1  INV 08/09/89 VP to New York                .00      1125.60-
SRR    7 0011 00000040 Albert Materials, Inc.   1006     INV 08/06/89 materials                     .00      2597.00-
                                                                                          ____________  ___________  ___________
                                                           — Current Month Totals —>             .00       19195.61-    19195.61-
                                                           — Beginning GL Balance —>                                   133548.69-
                                                                                                                       __________
                                                                  — Account Total —>                                   152744.30-
                                                                                          ============  ===========  ============


Account 4010000000MA  Cost of Goods Sold, Corp./Mfg.

SRR    8 0007 00000040 Albert Materials, Inc.   96215    INV 08/14/89 materials                 2058.00           .00
SRR    7 0011 00000040 Albert Materials, Inc.   1006     INV 08/06/89 materials                 2597.00           .00
                                                                                           ____________  ___________  ___________
                                                           — Current Month Totals —>          4655.00           .00       4655.00
                                                           — Beginning GL Balance —>                                     38709.39
                                                                                                                      ___________
                                                                  — Account Total —>                                     43364.39
                                                                                         ============  ============  ============


Account 4090000000MA  Repairs and Maintenance, Mfg.

SRR    7 0003 00000050 Hardware Services, Inc.  03056    INV 08/05/89 equipment repair           625.88           .00
SRR    7 0004 00000050 Hardware Services, Inc.  05981    INV 08/07/89 belt repair                432.81           .00
                                                                                           ____________  ___________  ___________
                                                           — Current Month Totals —>          1058.69           .00       1058.69
                                                           — Beginning GL Balance —>                                     42903.89
                                                                                                                      ___________
                                                                  — Account Total —>                                     43962.58
                                                                                          ============  ===========  ============
  1. Step 6In order to print the report requested, this step formats the MTD Postings information. As appropriate, group headings appear whenever a change occurs in Post Month or Account. If requested, totals appear whenever a change occurs in Account or Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end.

A sample output is shown below.

                                                       Expert Computing, Inc.
11/08/94 10:11                                                                                                       LGG Page:  1


                                                    Purchases GL Distributions

Account                     Account Name                                   Debits                 Credits              Net Change
=================================================================================================================================

Post Month/Year 08 89

1030002000WH                Accts Rec, Canadian Corp/Whls                 1000.00                     .00                 1000.00
2010001001                  Accounts Payable, Sales                           .00                19195.61-              19195.61-
4010000000MA                Cost of Goods Sold, Corp./Mfg.                4655.00                     .00                 4655.00
4090000000MA                Repairs and Maintenance, Mfg.                 1058.69                     .00                 1058.69
4090000001WH                Repairs and Maintnc, Wholesale                1821.39                     .00                 1821.39
4100000001WH                Promotion/Advertising, Wholesl                2660.00                     .00                 2660.00
4110000000                  Travel and Entertainment                      1125.60                     .00                 1125.60
4110000001MA                Travel & Entertainment, Sales                 6874.93                     .00                 6874.93
                                                                     ____________            ____________            ____________
                             — Post Month/Year 08 89 Totals —>         19195.61                19195.61-                    .00
                                                                     ============            ============            ============

                                                                     ____________            ____________            ____________
                                             — Grand Totals —>         19195.61                19195.61-                    .00
                                                                     ============            ============            ============