2Monthly Processing
Option 5YTD General Ledger Report
This report prints monthly detail for the accounts identified as keeping YTD detail in the Chart of Accounts file, at the level of detail defined for each account. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the YTD Postings information, this step provides you with a default sequencing of data records by Fiscal Year, Account, Fiscal Month, and Currency Code, with the option to change modifiable parameters at run time. Selection of data records is provided by Fiscal Year, Fiscal Month, Account Component, and Currency Code, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Ledger reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the YTD General Ledger Report, this step formats the YTD 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, Currency Code, Home Amount, and Amount. As appropriate, group headings appear whenever a change occurs in Account. If requested, totals appear whenever a change occurs in Account or Fiscal Year. When totals are specified, the following items are accumulated: Total Amount and Total Home Amount. Total Current Earnings is also shown.
A sample output is shown below.
APPX Demonstration Company
12/12/94 16:45 LGG Page: 1
YTD General Ledger Report
Fiscal Year 89
Control Description Jrnl Trx Trx Date Mo/Yr Ref Rev Adj S/U/N Interco Curr Home Amount Amount
=================================================================================================================================
Account 1020002000 Cash, Canadian Corporate 552309.00
LGG SUMMARY POSTING GL1 01 89 N N CANADA 77672.29 93524.77
LGG SUMMARY POSTING GL1 01 89 N N CANADA 66440.00- 80000.00-
LGG SUMMARY POSTING GL1 02 89 N N CANADA 11572.68 13934.60
LGG SUMMARY POSTING GL 03 89 N N CANADA 42448.59-
LGG SUMMARY POSTING GL2 03 89 N N CANADA 280040.07 286082.46
LGG SUMMARY POSTING GL2 04 89 N N CANADA 163932.55 197390.20
LGG SUMMARY POSTING GL1 05 89 N N CANADA 108352.53 130466.63
LGG SUMMARY POSTING GL1 06 89 N N CANADA 70803.20 85253.70
LGG SUMMARY POSTING GL2 06 89 N N CANADA 14351.49- 17280.54-
LGG SUMMARY POSTING GL1 07 89 N N CANADA 99909.46 120300.36
LGG SUMMARY POSTING GL1 08 89 N N CANADA 97750.91 117701.27
LGG SUMMARY POSTING GL1 09 89 N N CANADA 89276.24 107496.97
LGG SUMMARY POSTING GL1 10 89 N N CANADA 51277.79 61743.27
LGG SUMMARY POSTING GL1 11 89 N N CANADA 80219.85 96592.24
LGG SUMMARY POSTING CURR 12 89 N N CANADA 506.24-
LGG SUMMARY POSTING GL1 11 89 N N CANADA 70916.76 85390.41
____________ ____________
— Account Totals —> 1673241.84 1255641.51
============ ============
=================================================================================================================================
Account 1020002001 Cash, Canadian Sales Outlets 385158.00
LGG SUMMARY POSTING GL1 01 89 N N CANADA 40174.77 48374.20
LGG SUMMARY POSTING GL1 01 89 N N CANADA 41525.00- 50000.00-
LGG SUMMARY POSTING GL1 02 89 N N CANADA 5328.82- 6416.39-
LGG SUMMARY POSTING GL 03 89 N N CANADA 23971.64-
LGG SUMMARY POSTING GL2 03 89 N N CANADA 171679.48 177854.11
LGG SUMMARY POSTING GL2 04 89 N N CANADA 78305.20 94286.81
LGG SUMMARY POSTING GL1 05 89 N N CANADA 22656.04 27279.99
LGG SUMMARY POSTING GL1 06 89 N N CANADA 65831.41 79267.19
LGG SUMMARY POSTING GL2 06 89 N N CANADA 11384.08- 13707.50-
LGG SUMMARY POSTING GL1 07 89 N N CANADA 12368.83 14893.23
LGG SUMMARY POSTING GL1 08 89 N N CANADA 50366.88 60646.47
LGG SUMMARY POSTING GL1 09 89 N N CANADA 47711.07 57448.60
LGG SUMMARY POSTING GL1 10 89 N N CANADA 50880.18 61264.51
LGG SUMMARY POSTING GL1 11 89 N N CANADA 54468.30 65584.95
LGG SUMMARY POSTING CURR 12 89 N N CANADA 2236.28-
LGG SUMMARY POSTING GL1 11 89 N N CANADA 41880.85 50428.48
____________ ____________
— Account Totals —> 963243.11 640996.73
============ ============
=================================================================================================================================