APPX Software Library

2Monthly Processing

Option 11GL Distributions Inquiry

This inquiry shows the monthly Accounts Payable postings integrated with General Ledger. The GL Distributions records are maintained in the MTD postings file. When you close the accounting period that is equal to the post month and post year of the distributions record, the record is deleted. The following processing steps accomplish this job.

  1. Step 1This function cancels the GL Distributions Inquiry if GL does not exist.
  2. Step 2In order to print the General Ledger Distributions Inquiry, this step formats the Chart of Accounts and MTD Postings information. The following data items are shown: Account Number, Description, Operator ID, Vendor No, Invoice/Check No, Transaction Type Abbreviation, Transaction Date, Amount and Amount Total.

A sample output is shown below.

*************************  GL Distributions Inquiry  **************************

Account  2010001001  Accounts Payable, Sales

OpID Vendor  Invc/Chck Trx Date     Description                        Amount

SRR  00000020 9852-6   INV 08/02/89 brochure                          2410.00-
SRR  00000030 10256    INV 07/30/89 misc. materials                    291.60-
SRR  00000050 03056    INV 08/05/89 equipment repair                   625.88-
SRR  00000050 05981    INV 08/07/89 belt repair                        432.81-
SRR  00000030 2215AC   INV 07/30/89 AC repair                          604.79-
SRR  00000060 11596-1  INV 08/01/89 Jones to DC                        985.60-
SRR  00000060 11562-0  INV 08/04/89 Williams to San Diego              487.00-
SRR  00000060 11598-1  INV 08/05/89 Jones to Columbus                  742.50-
SRR  00000060 11600-0  INV 08/09/89 Peters to Memphis                  802.00-
SRR  00000060 11651-1  INV 08/09/89 VP to New York                    1125.60-
SRR  00000040 1006     INV 08/06/89 materials                         2597.00-
SRR  00000100 ER1009   INV 08/12/89 Aug. expenses thru 8/10           1156.33-
SRR  00000090 ER1012   INV 08/12/89 Aug. expenses thru 8/10           1098.50-
SRR  00000080 ER1005   INV 08/12/89 Aug. expenses thru 8/10           1216.90-
SRR  00000010 L9980    INV 08/14/89 Office landscaping                 620.00-
SRR  00000010 221      INV 08/14/90 New lobby plants                   305.00-
SRR  00000060 11102-1  INV 08/14/89 Williams to Sacramento             386.10-
SRR  00000040 96215    INV 08/14/89 Materials                         2058.00-
SRR  00000010 P09844   INV 08/14/89 Yellow page ad                     250.00-
SRR  00000090 ER1012   ADJ 08/15/89 correct invoice amount             100.00-
SRR  00000040 34576    ADJ 08/15/89 write off retention                 36.00
SRR  00000040 84700    ADJ 08/15/89 write off retention                 88.00
MRC  00000080 12345678 INV 08/12/94 Invoice Description               1000.00-
SRR  00000040 5500     PMT 08/16/89 materials                         2597.00
SRR  00000040 5500     PMT 08/16/89 stock                             4128.15
SRR  00000040 5500     PMT 08/16/89 stock                             2491.70
SRR  00000040 5500     PMT 08/16/89 Materials                         2058.00
SRR  00000050 5501     PMT 08/16/89 belt repair                        432.81
SRR  00000050 5501     PMT 08/16/89 Drive repair                       626.87
SRR  00000050 5501     PMT 08/16/89 new hardware installation         2200.00
SRR  00000050 5501     PMT 08/16/89 New hardware installation         1500.00-
SRR  00000070 5502     PMT 08/16/89 Monthly Policy Payment             254.80
SRR  00000080 5503     PMT 08/16/89 travel expenses through 7/5       2357.98
SRR  00000080 5503     PMT 08/16/89 July travel expenses              1895.40
SRR  00000010 5504     PMT 08/16/89 binders                           5641.22
SRR  00000010 5505     PMT 08/16/89 convention room                   2212.25
SRR  00000030 5506     PMT 08/16/89 misc. materials                    291.60
SRR  00000030 5506     PMT 08/16/89 AC repair                          604.79
SRR  00000030 5506     PMT 08/16/89 July maintenance                   517.49
SRR  00000090 5507     PMT 08/16/89 travel expenses through 7/8       1984.56
SRR  00000090 5507     PMT 08/16/89 July travel expenses              2049.60
SRR  00000020 5508     PMT 08/16/89 catalog layout                    1895.62
SRR  00000020 5508     PMT 08/16/89 Summer promotion                  1248.29
SRR  00000020 5508     PMT 08/16/89 Press release                      871.00
SRR  00000020 5508     PMT 08/16/89 Advertising Retainer               500.00
SRR  00000060 5509     PMT 08/16/89 Jones to Detroit                   896.52
SRR  00000060 5509     PMT 08/16/89 Williams to Montreal              1354.89
SRR  00000060 5509     PMT 08/16/89 Williams to Boston                 740.25
SRR  00000060 5509     PMT 08/16/89 Jones to Atlanta                   802.55
SRR  00000060 5509     PMT 08/16/89 tickets                           6340.12
SRR  00000100 5510     PMT 08/16/89 July travel expenses              2203.63
SRR  00000100 5510     PMT 08/16/89 travel expenses through 7/5       2147.05
                                                                      ——————
                                        — Account Total —>           30672.53
                                                                 ============