2Monthly Processing
Option 4Print All Reports
This job queues all required end-of-month reports to be run at the same time. The following processing steps accomplish this job.
- Step 1This disposition type is used for all standard General Ledger reports.
- Step 2In preparation for performing a sort/selection process on the Account Balances information, this step provides you with a default sequencing of data records by Fiscal Year, Account, Currency, and Sub Type, with the option to change modifiable parameters at run time. Selection of data records is provided by Fiscal Year, Account Component, Revenue/Expense?, Currency, and Sub Type, 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 General Ledger Report, this step formats the Account Balances and MTD Postings information. The following data items are shown: Account, Description, Operator ID, Control No, Journal Code, Source Transaction no, Transaction Date, Fiscal Month, Fiscal Year, Reference, Reversing?, Adjustment?, S/U/N Override, Intercompany, Intercompany Reference, Currency Code, prior Period Amount, Debits, Credits, and Balance. If requested, totals appear whenever a change occurs in Account or Fiscal Year. When totals are specified, the following items are accumulated: Prior Period, Debits, Credits, and Balance.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 17:13 LGG Page: 1
General Ledger Report
Fiscal Year 90
Control Group Description
Jrnl Trx Trx Date Mo/Yr Ref Rev? Adj? S/U/N Interco Curr Prior Period Debits Credits Balance
=================================================================================================================================
Account 10100010 Cash (Posting Account) .00
=================================================================================================================================
Account 1010001000 Cash, Corporate 776673.21
MRC / 0000 SUMMARY POSTING
ARCR 0000 03 90 N N 14675.00
SRR / 0157 August Payroll
GL1 0001 08/31/89 03 90 JE N N 125835.57-
SRR / 0157 August A/R Receipts
GL1 0005 08/31/89 03 90 JE N N 178626.70
SRR / 0157 August Revenue
GL1 0006 08/31/89 03 90 JE N N 133899.90
____________ ____________ ____________ ____________
— Account Totals —> .00 327201.60 125835.57- 978039.24
============ ============ ============ ============
=================================================================================================================================
Account 1010001001 Cash, Sales Outlets 2148193.22
SRR / 0000 SUMMARY POSTING
APCD 0000 03 90 N N 3312.05-
SRR / 0000 SUMMARY POSTING
APCD 0000 03 90 N N 49991.50-
SRR / 0000 SUMMARY POSTING
ARCR 0000 03 90 N N 17772.19
SRR / 0157 August A/R Receipts
GL1 0005 08/31/89 03 90 JE N N 153721.53
SRR / 0157 August Revenue
GL1 0006 08/31/89 03 90 JE N N 98160.49
____________ ____________ ____________ ____________
— Account Totals —> .00 269654.21 53303.55- 2364543.88
============ ============ ============ ============
=================================================================================================================================
Account 10200020 Cash, Canadian (Posting Acct) .00
=================================================================================================================================
Account 1020002000 Cash, Canadian Corporate 1739345.94
SRR / 0158 August Reveue
GL1 0001 08/31/89 03 90 JE N N CANADA 60637.85
SRR / 0158 August Expenses
GL1 0002 08/31/89 03 90 JE N N CANADA 42260.26-
____________ ____________ ____________ ____________
— Account Totals —> .00 60637.85 42260.26- 1757723.53
============ ============ ============ ============
=================================================================================================================================
Account 1020002001 Cash, Canadian Sales Outlets 984348.27
SRR / 0158 August Reveue
GL1 0001 08/31/89 03 90 JE N N CANADA 39699.41
SRR / 0158 August Expenses
GL1 0002 08/31/89 03 90 JE N N CANADA 34510.94-
____________ ____________ ____________ ____________
— Account Totals —> .00 39699.41 34510.94- 989536.74
============ ============ ============ ============
=================================================================================================================================- Step 5In preparation for performing a sort/selection process on the Future Postings information, this step provides you with a default sequencing of data records by Fiscal Year, Fiscal Month, and Account, with the option to change modifiable parameters at run time. Selection of data records is provided by Fiscal Year, Fiscal Month, and Account Component, with the option to enter user-specified comparisons at run time.
- Step 6According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 7In order to print the Future Postings Report, this step formats the Future Postings information. The following data items are shown: Operator ID, Control No, Description, Journal Code, Source Transaction No, Transaction Date, Fiscal Month, Fiscal Year, Reference, Reversing?, Adjustment?, S/U/N Override, Intercompany, Intercompany Reference, Sub Type, Sub Code, Amount, Currency Code, and Home Amount. As appropriate, group headings appear whenever a change occurs in Fiscal Month or Account. If requested, totals appear whenever a change occurs in Account or Fiscal Month. When totals are specified, the Total Amount is printed. Grand totals print at the end, showing Total Amount.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 17:14 LGG Page: 1
Future Postings Report
Control Description Jrnl Trx Trx Date Mo/Yr Ref Rev Adj S/U/N Interco Sub Code Amount
Currency Home Amount
=================================================================================================================================
Fiscal Month/Year 04 90
Account 1 1
MRC 0017 OEIV 0001 08/09/94 04 90 000080 N N 14675.00
____________
— Account Totals —> 14675.00
============
Account 1030001000MA Accts Receiv, Corp./Mfg.
MRC 0000 Summary Posting OEIV 0000 04 90 N N 185210.68
____________
— Account Totals —> 185210.68
============
Account 1030001001MA Accts Receiv, Sales/Mfg.
MRC 0000 Summary Posting OEIV 0000 04 90 N N 954.50
____________
— Account Totals —> 954.50
============
Account 1030001001WH Accts Receiv, Sales/Wholesale
MRC 0000 Summary Posting OEIV 0000 04 90 N N 831.05
____________
— Account Totals —> 831.05
============
Account 1100001000WH Resale Inventory
MRC 0017 P10982 OEIV 0002 08/12/89 04 90 000040 N N .10-
MRC 0017 P3050 OEIV 0003 08/15/89 04 90 000020 N N .50-
MRC 0018 OEIV 0001 09/20/94 04 90 000444 N N 73500.00-
___________
— Account Totals —> 73500.60-
============
Account 1100001001WH Resale Inventory, Sales Outlet
MRC 0017 P10982 OEIV 0002 08/12/89 04 90 000040 N N 150.00-
MRC 0017 P10982 OEIV 0002 08/12/89 04 90 000040 N N 95.00-- Step 8This function checks to see whether you have chosen to use the Transaction Control option, before running a function that requires the file.
- Step 9In preparation for performing a sort/selection process on the Transaction Control information, this step provides you with a default sequencing of data records by Application, File Posted, Operator ID, and Control No, with the option to change modifiable parameters at run time. Selection of data records is provided by Application, File Posted, Operator ID, Control No, Journal Code, and Currency Code, with the option to enter user-specified comparisons at run time.
- Step 10According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 11In order to print the General Ledger Transaction Control Report, this step formats the Transaction Control information. The following data items are shown: Application, File Posted, Operator ID, Control No, Amount Posted, Last Transaction Posted, Date/Time, Journal Code, Currency Code, Description, Operator Exclusive?, Control Total, Hash Total, Number of Transaction, Number of Errors, and Number of Warnings.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 17:16 LGG Page: 1
General Ledger Transaction Control Report
Appl/File Control Group Amt Posted Last Tx
Date/Time Jrnl Curr Description Op Exc? Ctrl Total Hash Total Trx Errors
Warnings
=================================================================================================================================
TAP ADJUSTMENTS SRR / 0001 24.00- 3
APAJ Aug adjustments thru 8/15 N .00 0 3 0 0
TAP DISBURSEMENTS SRR / 0007 3312.05 4
APCD Aug. checks thru 8/15 N 3312.05 0 4 0 0
TAP DISBURSEMENTS SRR / 0008 49991.50 11
08/09/94 APCD Aug. 1st check run N .00 0 11 1 0
TAP INVOICES MRC / 0015 1000.00 1
08/09/94 APIV Invoice entry N 1000.00 0 1 0 0
TAP INVOICES SRR / 0007 11302.52 11
APIV Aug. invoices thru 8/10 N .00 520 11 0 0
TAP INVOICES SRR / 0008 7132.83 8
APIV Aug. invoices 8/10-8/15 N 7132.83 400 8 0 0
TAR ADJUSTMENTS SRR / 0000 4.02- 5
ARAJ August - group 1 N .00 0 5 1 0
TAR ADJUSTMENTS SRR / 0002 120.00 2
ARAJ CUSTOMER REFUNDS N .00 0 2 0 0
TAR CASH RECEIPTS MRC / 0010 14675.00 1
08/09/94 ARCR Cash Receipts N 14675.00 0 1 0 0- Step 12This function checks to see if General Subsidiary exists; and if so, checks to see if the General Subsidiary month should be closed at the same time as General Ledger. If that is the case, the “Print All Required Reports” and “Close Month” jobs will also include the corresponding functions in General Subsidiary.