2Monthly Processing
Option 7Print All GL Distributions
This job prints the Purchase, Disbursements, Adjustments, and Subsidiary Code GL Distributions reports. The following processing steps accomplish this job.
- Step 1This disposition type is used for all standard Accounts Payable reports.
- 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 the option to enter user-specified comparisons at run time.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In 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:16 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 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
============ ============ ============
— Account Total —> 19267.68
============ ============ ============- Step 5In 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:17 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
============ ============ ============- Step 6In 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 the option to enter user-specified comparisons at run time.
- Step 7According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 8In 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:18 LGG Page: 1
Disbursements GL Distributions
Op Ctrl Trx Vendor Invc/Chk Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
Account 1010001001 Cash, Sales Outlets
SRR 7 0001 00000010 Miscellaneous Supplier 303 PMT 08/13/89 sign .00 168.90-
SRR 8 0001 00000040 Albert Materials, Inc. 5500 PMT 08/16/89 Albert Materials, Inc. .00 11110.46-
SRR 7 0002 00000020 Pool and Associates 306 PMT 08/10/89 deposit on mailer prod .00 1500.00-
SRR 8 0002 00000050 Hardware Services, Inc. 5501 PMT 08/16/89 Hardware Services, Inc .00 2028.31-
SRR 7 0003 00000010 Miscellaneous Supplier 311 PMT 08/07/89 expenses for interview .00 1215.60-
SRR 8 0003 00000070 Insurances Unlimited 5502 PMT 08/16/89 Insurances Unlimited .00 254.80-
SRR 7 0004 00000040 Albert Materials, Inc. 312 PMT 08/11/89 packing materials .00 427.55-
SRR 8 0004 00000080 Sam Jones 5503 PMT 08/16/89 Sam Jones .00 4253.38-
SRR 8 0005 00000010 Miscellaneous Supplier 5504 PMT 08/16/89 binders .00 5641.22-
SRR 8 0006 00000010 Miscellaneous Supplier 5505 PMT 08/16/89 convention room .00 2212.25-
SRR 8 0007 00000030 Mountain Air Conditionin 5506 PMT 08/16/89 Mountain Air Condition .00 1457.00-
SRR 8 0008 00000090 George Peters 5507 PMT 08/16/89 George Peters .00 4034.16-
SRR 8 0009 00000020 Pool and Associates 5508 PMT 08/16/89 Pool and Associates .00 4514.91-
SRR 8 0010 00000060 Travel Planners 5509 PMT 08/16/89 Travel Planners .00 10134.33-
SRR 8 0011 00000100 Kris Williams 5510 PMT 08/16/89 Kris Williams .00 4350.68-
___________ ____________ ____________
— Current Month Totals —> .00 53303.55- 53303.55-
— Beginning GL Balance —> 2148193.22
——————
— Account Total —> 2094889.67
============ ============ ============- Step 9In 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:19 LGG Page: 1
Disbursements GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
1010001001 Cash, Sales Outlets .00 53303.55- 53303.55-
1061001000 Prepaids & Deposits 1500.00 .00 1500.00
2010001001 Accounts Payable, Sales 51344.14 1500.00- 49844.14
2030001001 Retention Payable, Sales .00 344.92- 344.92-
4010000001WH Cost of Goods Sold, Sales/Whls 427.55 .00 427.55
4070000000WH Discounts Lost, Wholesale 492.28 .00 492.28
4090000001WH Repairs and Maintnc, Wholesale 168.90 .00 168.90
4110000000 Travel and Entertainment 1215.60 .00 1215.60
____________ ____________ ___________
— Post Month/Year 08 89 Totals —> 55148.47 55148.47- .00
============ ============ ============
____________ ____________ ___________
— Grand Totals —> 55148.47 55148.47- .00
============ ============ ============- Step 10In 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 the option to enter user-specified comparisons at run time.
- Step 11According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 12In 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:19 LGG Page: 1
Adjustments GL Distributions
Op Ctrl Trx Vendor Invc/Chk Trx Date Description Debits Credits Net
Change
=================================================================================================================================
Post Month/Year 08 89
Account 2010001001 Accounts Payable, Sales
SRR 1 0001 00000090 George Peters ER1012 ADJ 08/15/89 correct invoice amount .00 100.00-
SRR 1 0002 00000040 Albert Materials, Inc. 34576 ADJ 08/15/89 write off retention 36.00 .00
SRR 1 0003 00000040 Albert Materials, Inc. 84700 ADJ 08/15/89 write off retention 88.00 .00
______ _______ ________
— Current Month Totals —> 124.00 100.00- 24.00
— Beginning GL Balance —> 133548.69-
__________
— Account Total —> 133524.69-
============ =========== ===========
Account 2030001001 Retention Payable, Sales
SRR 1 0002 00000040 Albert Materials, Inc. 34576 ADJ 08/15/89 write off retention .00 36.00-
SRR 1 0003 00000040 Albert Materials, Inc. 84700 ADJ 08/15/89 write off retention .00 88.00-
_____ ______ _______
— Current Month Totals —> .00 24.00- 124.00-
— Beginning GL Balance —> 1458.00-
________
— Account Total —> 1582.00-
========== ========== ==========
Account 4110000001MA Travel & Entertainment, Sales
SRR 1 0001 00000090 George Peters ER1012 ADJ 08/15/89 correct invoice amount 100.00 .00
______ _________ ________
— Current Month Totals —> 100.00 .00 100.00
— Beginning GL Balance —> 24530.41
________
— Account Total —> 24630.41
============ ============ ============
____________ ____________ ____________
— Post Month/Year 08 89 Totals —> 224.00 224.00- .00
============ ============ ============
____________ ____________ ____________
— Grand Totals —> 224.00 224.00- .00
============ ============ ============- Step 13In 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:19 LGG Page: 1
Adjustments GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
2010001001 Accounts Payable, Sales 124.00 100.00- 24.00
2030001001 Retention Payable, Sales .00 124.00- 124.00-
4110000001MA Travel & Entertainment, Sales 100.00 .00 100.00
____________ ___________ ____________
— Post Month/Year 08 89 Totals —> 224.00 224.00- .00
============ ============ ============
____________ ___________ ____________
— Grand Totals —> 224.00 224.00- .00
============ ============ ============- Step 14In preparation or performing a sort/selection process on the MTD Postings information, this step provides you with a default sequencing of data records by Subsidiary Type, Subsidiary Code and Account, with the option to change modifiable parameters at run time. Selection of data records is provided by Subsidiary Type, Subsidiary Code, and Account Component, with the option to enter user-specified comparisons at run time.
- Step 15According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 16In order to print the Accounts Payable Detail Subsidiary Distributions, this step formats the MTD Postings information. The following data items are shown: Transaction No, Vendor No, Vendor Name, Invoice/Check No, Transaction Type Abbreviation, Transaction Date, Description and Amount. As appropriate, group headings appear whenever a change occurs in Subsidiary Type or Subsidiary Code. If requested, totals appear whenever a change occurs in Subsidiary Code or Subsidiary Type. When totals are specified, the following items are accumulated: Amount Total. Grand totals print at the end.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 10:20 LGG Page: 1
Accounts Payable Detail Subsidiary Distributions
Trx Vendor Invc/Chk Trx Date Description Amount
=================================================================================================================================
Sub Type GL
Sub Code GENERAL
0003 00000050 Hardware Services, Inc. 03056 INV 08/05/89 equipment repair 625.88
0004 00000050 Hardware Services, Inc. 05981 INV 08/07/89 belt repair 432.81
0010 00000060 Travel Planners 11651-1 INV 08/09/89 VP to NY 1125.60
0003 00000010 Miscellaneous Supplier 311 PMT 08/07/89 1215.60
__________
— Sub Code Totals —> 3399.89
=================================================================================================================================
Sub Code JONES
0006 00000060 Travel Planners 11596-1 INV 08/01/89 Jones to DC 985.60
0008 00000060 Travel Planners 11598-1 INV 08/05/89 Jones to Columbus 742.50
0003 00000080 Sam Jones ER1005 INV 08/12/89 Aug. expenses thru 8/10 1216.90
__________
— Sub Code Totals —> 2945.00
=================================================================================================================================
Sub Code PETERS
0009 00000060 Travel Planners 11600-0 INV 08/09/89 Peters to Memphis 802.00
0002 00000090 George Peters ER1012 INV 08/12/89 Aug. expenses thru 8/10 1098.50
0001 00000090 George Peters ER1012 ADJ 08/15/89 correct invoice amount 100.00
__________
— Sub Code Totals —> 2000.50
=================================================================================================================================
Sub Code WILLIAMS
0007 00000060 Travel Planners 11562-0 INV 08/04/89 Williams to San Diego 487.00
0001 00000100 Kris Williams ER1009 INV 08/12/89 Aug. expenses thru 8/10 1156.33
0006 00000060 Travel Planners 11102-1 INV 08/14/89 Williams to Sacramento 386.10
___________
— Sub Code Totals —> 2029.43
=================================================================================================================================
___________
— Sub Type GL Totals —> 10374.82
=================================================================================================================================
___________
— Grand Totals —> 10374.82
============- Step 17In order to print the Accounts Payable Summary Subsidiary Distributions, this step formats the MTD Postings information. As appropriate, group headings appear whenever a change occurs in Subsidiary Type or Subsidiary Code. If requested, totals appear whenever a change occurs in Subsidiary Code or Subsidiary Type. 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:20 LGG Page: 1
Accounts Payable Summary Subsidiary Distributions
Sub Code Debits Credits Net Change
=================================================================================================================================
Sub Type GL
GENERAL 3399.89 .00 3399.89
JONES 2945.00 .00 2945.00
PETERS 2000.50 .00 2000.50
WILLIAMS 2029.43 .00 2029.43
____________ ____________ ____________
— Sub Type GL Totals —> 10374.82 .00 10374.82
____________ ____________ ____________
— Grand Totals —> 10374.82 .00 10374.82
============ ============ ============