2Monthly Processing
Option 7Print All GL Distributions
Use this function to print the Sales, Cash Receipts, Adjustments, and Subsidiary Code General Ledger Distributions reports. The following processing steps accomplish this job.
- Step 1This is the standard disposition used for all reports not printed on special forms.
- Step 2In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Post year, Post Month, Account Number, 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 Number, 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 Month To Date Postings information. The following data items are shown: Operator ID, Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction date, Apply Type, Debit Amount, and Credit Amount. As appropriate, Group headings appear whenever a change occurs in Post Month, Account Number, or account component. If requested, totals appear whenever a change occurs in Account Number, account component, or Post Mont. 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:32 LGG Page: 1
Sales Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 06 89
Account 1030001001WH Accts Receiv, Sales/Wholesale
0000 0000 00000010 Alexander's 401 SVC 06/30/89 Svc Charge Write Off .00 20.26-
0000 0000 00000020 Master Sellers Company 333 SVC 06/30/89 Svc Charge Write Off .00 2.00-
0000 0000 00000040 Burlington Enterprises 404 SVC 06/10/89 Svc Charge Write Off .00 22.22-
0000 0000 00000040 Burlington Enterprises 604 SVC 06/10/89 Svc Charge Write Off .00 101.90-
—————— —————— ——————
— Current Month Totals —> .00 146.38- 146.38-
— Beginning GL Balance —> 141659.39
——————
— Account Total —> 141513.01
============ ============ ============
Account 3060000000 Miscellaneous Income
0000 0000 00000010 Alexander's, Inc. 401 SVC 06/30/89 Svc Charge Write Off 20.26 .00
0000 0000 00000020 Master Sellers Company 333 SVC 06/30/89 Svc Charge Write Off 2.00 .00
0000 0000 00000040 Burlington Enterprises 404 SVC 06/10/89 Svc Charge Write Off 22.22 .00
0000 0000 00000040 Burlington Enterprises 604 SVC 06/10/89 Svc Charge Write Off 101.90 .00
—————— —————— ——————
— Current Month Totals —> 146.38 .00 146.38
— Beginning GL Balance —> .00
——————
— Account Total —> 146.38
============ ============ ============
—————— —————— ——————
— Post Month/Year 06 89 Totals —> 146.38 146.38- .00
============ ============ ============
Post Month/Year 07 89
Account 1030001001WH Accts Receiv, Sales/Wholesale
0000 0000 00000010 Alexander's, Inc. 401 SVC 07/31/89 Svc Charge Write Off .00 20.56-
0000 0000 00000020 Master Sellers Company 333 SVC 07/31/89 Svc Charge Write Off .00 2.02-
—————— —————— ——————
— Current Month Totals —> .00 22.58- 22.58-
— Beginning GL Balance —> 110596.07
——————
— Account Total —> 110573.49
============ ============ ============- Step 5In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post Month. If requested, totals appear whenever a change occurs in 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:33 LGG Page: 1
Sales Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 06 89
1030001001WH Accts Receiv, Sales/Wholesale .00 146.38- 146.38-
3060000000 Miscellaneous Income 146.38 .00 146.38
—————— —————— ——————
— Post Month/Year 06 89 Totals —> 146.38 146.38- .00
============ ============ ============
Post Month/Year 07 89
1030001001WH Accts Receiv, Sales/Wholesale .00 22.58- 22.58-
3060000000 Miscellaneous Income 22.58 .00 22.58
—————— —————— ——————
— Post Month/Year 07 89 Totals —> 22.58 22.58- .00
============ ============ ============
Post Month/Year 08 89
1030001001WH Accts Receiv, Sales/Wholesale 18721.44 .00 18721.44
1050001000 Service Charges Receivable .00 140.96- 140.96-
2020001001 Sales Tax Payable, Sales .00 1069.12- 1069.12-
2051000000 Sales Deposits 2050.00 .00 2050.00
3010001001MA Sales, Manufacturing .00 10134.75- 10134.75-
3010001001WH Sales, Wholesale .00 8879.10- 8879.10-
4190000001WH Freight Out, Sales/Wholesale .00 547.51- 547.51-
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 20771.44 20771.44- .00
============ ============ ============
Post Month/Year 09 89
1030001000MA Accts Receiv, Corp./Mfg. 185210.68 .00 185210.68
1030001001MA Accts Receiv, Sales/Mfg. 954.50 .00 954.50
1030001001WH Accts Receiv, Sales/Wholesale 831.05 .00 831.05
1100001000WH Resale Inventory .00 73500.60- 73500.60-
1100001001WH Resale Inventory, Sales Outlet .00 18995.50- 18995.50-
2020001001 Sales Tax Payable, Sales .00 136.62- 136.62-
2051000000 Sales Deposits 100.00 .00 100.00
3010001001MA Sales, Manufacturing .00 650.00- 650.00-
3010001001WH Sales, Wholesale .00 199629.13- 199629.13-
3060000000 Miscellaneous Income .00 275.00- 275.00-
4010000001WH Cost of Goods Sold, Sales/Whls 92496.10 .00 92496.10
4070000000MA Discounts Lost, Mfg. 50.00 .00 50.00
4071000001WH Customer Disct, Sales/Wholesal 19.52 .00 19.52
4190000001WH Freight Out, Sales/Wholesale .00 1150.00- 1150.00-- Step 6In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account Number, 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 Number, 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 Month To Date Postings information. The following data items are shown: Operator ID, Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Apply Type, Debit Amount, and Credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account Number, or account component. If requested, totals appear whenever a change occurs in Account Number, account component, 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:33 LGG Page: 1
Cash Receipts Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net
Change
=================================================================================================================================
Post Month/Year 08 89
Account 1010001000 Cash, Corporate
MRC 0010 0001 00000080 Dominion Business Machin 9988765 PAY 08/09/94 Cash 14675.00 .00
—————— —————— ——————
— Current Month Totals —> 14675.00 .00 14675.00
— Beginning GL Balance —> 776673.21
——————
— Account Total —> 791348.21
============ ============ ============
Account 1010001001 Cash, Sales Outlets
SRR 0008 0001 00000010 Alexander's, Inc 6130 PAY 08/11/89 payment 2170.28 .00
SRR 0008 0002 00000040 Burlington Enterprises 11603 PAY 08/11/89 payment 3111.95 .00
SRR 0008 0003 00000060 Hale’s Interiors 817 PAY 08/11/89 payment 2600.00 .00
SRR 0008 0004 00000020 Master Sellers Company 1278 PAY 08/11/89 payment 600.40 .00
SRR 0008 0005 00000050 Miscellaneous Customer 3121 PAY 08/11/89 payment 2789.56 .00
SRR 0008 0006 00000030 Pool and Associates 4421 PAY 08/11/89 payment 3000.00 .00
SRR 0008 0007 00000020 Master Sellers Company 1279 PAY 08/11/89 deposit 1500.00 .00
SRR 0008 0008 00000050 Miscellaneous Customer 3144 PAY 08/11/89 deposit 2000.00 .00
—————— —————— ——————
— Current Month Totals —> 17772.19 .00 17772.19
— Beginning GL Balance —> 2148193.22
——————
— Account Total —> 2165965.41
============ ============ ============- Step 9In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post Mont. If requested, totals appear whenever a change occurs in 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 a the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:33 LGG Page: 1
Cash Receipts Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
1010001000 Cash, Corporate 14675.00 .00 14675.00
1010001001 Cash, Sales Outlets 17772.19 .00 17772.19
1030001000MA Accts Receiv, Corp./Mfg. .00 14675.00- 14675.00-
1030001001WH Accts Receiv, Sales/Wholesale .00 14272.19- 14272.19-
2051000000 Sales Deposits .00 3500.00- 3500.00-
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 32447.19 32447.19- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 32447.19 32447.19- .00
============ ============ ============- Step 10In preparation for performing a sort/selection process on the month To Date Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account Number, 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 Number, 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 Month To Date Postings information. The following data items are shown: Operator ID, transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Apply Type, Debit Amount, and Credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account Number, or account component. If requested, totals appear whenever a change occurs in Account Number, account component, 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:33 LGG Page: 1
Adjustments Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
Account 1030001001WH Accts Receiv, Sales/Wholesale
SRR 0000 0001 00000040 Burlington Enterprises 111 ADJ 08/12/89 order cancelled-apply 900.00 .00
SRR 0000 0002 00000040 Burlington Enterprises 1023 ADJ 08/12/89 order cancelled-apply .00 900.00-
SRR 0000 0003 00000060 Hale’s Interiors 1018 ADJ 08/12/89 wrong customer invoic .00 275.98-
SRR 0000 0004 00000010 Alexander's, Inc. 1018 ADJ 08/12/89 correction 275.98 .00
SRR 0000 0005 00000020 Master Sellers Company 333 ADJ 08/12/89 write off service cha .00 4.02-
—————— —————— ——————
— Current Month Totals —> 1175.98 1180.00- 4.02-
— Beginning GL Balance —> 131936.81
——————
— Account Total —> 131932.79
============ ============ ============
Account 3010001001WH Sales, Wholesale
SRR 0000 0001 00000040 Burlington Enterprises 111 ADJ 08/12/89 order cancelled-apply .00 900.00-
SRR 0000 0002 00000040 Burlington Enterprises 1023 ADJ 08/12/89 order cancelled-apply 900.00 .00
SRR 0000 0003 00000060 Hale’s Interiors 1018 ADJ 08/12/89 wrong customer invoic 275.98 .00
SRR 0000 0004 00000010 Alexander's, Inc. 1018 ADJ 08/12/89 correction .00 275.98-
—————— —————— ——————
— Current Month Totals —> 1175.98 1175.98- .00
— Beginning GL Balance —> 560855.13-
——————
— Account Total —> 560855.13-
============ ============ ============
Account 3060000000 Miscellaneous Income
SRR 0000 0005 00000020 Master Sellers Company 333 ADJ 08/12/89 write off service cha 4.02 .00
—————— —————— ——————
— Current Month Totals —> 4.02 .00 4.02
— Beginning GL Balance —> 168.96
——————
— Account Total —> 172.98
============ ============ ============
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 2355.98 2355.98- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 2355.98 2355.98- .00
============ ============ ============- Step 13In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post Month. If requested, totals appear whenever a change occurs in 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:34 LGG Page: 1
Adjustments Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
1030001001WH Accts Receiv, Sales/Wholesale 1175.98 1180.00- 4.02-
3010001001WH Sales, Wholesale 1175.98 1175.98- .00
3060000000 Miscellaneous Income 4.02 .00 4.02
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 2355.98 2355.98- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 2355.98 2355.98- .00
============ ============ ============- Step 14In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Subsidiary Type, Subsidiary Code, and Account Number, 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 Subsidiary Code Detail GL Distributions, this step formats the Month To Date Postings information. The following data items are shown: Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Description, and Amount.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:34 LGG Page: 1
Subsidiary Code Detail GL Distributions
Trx Customer Invc/Chk Trx Date Description Amount
=================================================================================================================================
Subsidiary Type GL
Subsidiary Code JONES 2 Salesperson Sam Jones JONES
0001 00000010 Alexander's, Inc. 3001 INV 08/11/89 special order desk 900.00-
0001 00000010 Alexander's, Inc. 3001 INV 08/11/89 special order chairs 600.00-
—————
— Subsidiary Code Subtotals —> 1500.00-
===========
Subsidiary Code PETERS 2 Salesperson George Peters PETERS
0005 00000020 Master Sellers Company 3005 INV 08/11/89 special order table 2704.00-
—————
— Subsidiary Code Subtotals —> 2704.00-
===========
Subsidiary Code WILLIAMS 2 Salesperson Kris Williams WILLIAMS
0006 00000050 Deno’s Inc. 3006 INV 08/11/89 shelving unit 5401.60-
0006 00000050 Deno’s Inc. 3006 INV 08/11/89 shelving unit 529.15-
—————
— Subsidiary Code Subtotals —> 5930.75-
===========
—————
— Subsidiary Type Subtotals —> 10134.75-
===========
—————
— Grand Totals —> 10134.75-
===========- Step 17In order to print the Subsidiary Code Summary GL Distributions, this step formats the Month To Date 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, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:35 LGG Page: 1
Subsidiary Code Summary GL Distributions
Subsidiary Code Debits Credits Net Change
=================================================================================================================================
Sub Type GL
JONES .00 1500.00- 1500.00-
PETERS .00 2704.00- 2704.00-
WILLIAMS .00 5930.75- 5930.75-
—————— —————— ——————
— Sub Type GL Totals —> .00 10134.75- 10134.75-
============ ============ ============
—————— —————— ——————
— Grand Totals —> .00 10134.75- 10134.75-
============ ============ ============