FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

BM1711J
Customer Account GL Aging Report

The Customer Accounts GL Aging report provides information on the age of various receivables using data from the Customer Accounts subledger. Charges in the subledger that do not correspond to charges in Customer Accounts will have the charge date, invoice date and due date set to the first day of activity in the subledger.

This process uses the GL report group table (GA1099) to determine the information to be placed in each column. The report number is BM1711 and the following describes the report groups that may be specified.

Report groups 01, 02, 03, 04 and 05 identify the column titles to be printed on the report for columns 1, 2, 3, 4 and 5 respectively. The title is contained in the TITLE field and the GLs are ignored so '9999' should be placed in the first GL field. All columns do not need to be specified if they are not needed.

Report groups 10 through 19 identify the general ledgers that may be included in column 1 of the report. The TITLE field indicates when a general ledger will qualify for the column. For example, DUE+30 would indicate that the charge only qualifies thirty days following it's due date. DUE, CHRG or INV may be used and the day offset may be positive or negative. Use multiple report groups if the qualifying period is different by general ledger.

Report groups 20 through 29 identify the general ledgers that may be included in column 2 of the report. The specifications are identical as those for column 1.

Report groups 30 through 39 identify the general ledgers that may be included in column 3 of the report. The specifications are identical as those for column 1.

Report groups 40 through 49 identify the general ledgers that may be included in column 4 of the report. The specifications are identical as those for column 1.

Report groups 50 through 59 identify the general ledgers that may be included in column 5 of the report. The specifications are identical as those for column 1.


Report:
BM1711    Customer Accounts GL Aging Report
Special Instructions None
Frequency On-request
Scheduling Restrictions None
Execution Time Anytime (O, B, P or I)
Job Completion Status JOBFAIL
Job Groups None
Job Dependency None
Operator Instructions None
Estimated Run Time 20 minutes
Recovery/Restart This job is restartable.


Parameters

BM1711-CR-OPT Indicates how credit charges should be included on the report.
N = Exclude credit charges
Y = Include credit charges (Note: credit charges are never "DUE")
1 = Include credit charges in column 1
2 = Include credit charges in column 2
3 = Include credit charges in column 3
4 = Include credit charges in column 4
5 = Include credit charges in column 5
BM1711-DEBT-OPT Indicates whether the report should be sorted by debt type.
Y = Sort report by debt type
N = Do not sort report by debt type
BM1711-DEBT-TYP Indicates the debt type for which the report should be produced. One or more debt types may be specified seperated by commas. A range of debt types may be entered using a colon. If 'ALL' or blank, all debt types are included.
BM1711-RPT-OPT The report format to use in producing the report.
1 = Fund/GL
2 = Fund/GL/Customer ID
3 = Fund/GL/Customer Name
YR-MO The year-month to be processed (YYMM).

Distribution: FMS
Created: WED, JAN 04, 2012, 06:54 AM