AD50.1 – Average Daily Balance-Cost of Funds Report Setup
- System
- Avg Daily Balance (AD)
- Type
- Online screen — form 50
- Updates
- 3 tables
- References
- 14 tables
AD50.1 (Average Daily Balance-Cost of Funds Report Setup) is a Lawson Avg Daily Balance online screen (form 50, subform 1). It updates ADDRDATA, REPORTINFO and RWGRPDET and references ADCOMPANY, GLADDRESS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCPYGRP, GLNAMES and 6 more.
About AD50.1
Use ADB-Cost of Funds Report Setup (AD50.1) to create customized average daily balance reports that list ADB balances for accounts and dates youspecify. Reports can include actuals, ADB calculation results, or cost of fundcalculation results for the current or prior period, quarter, or year. **Processing Effect Select either an effective date or period. If you choose the effective date, the report will include the calculated values for the same relative date in other periods. If you choose a period and year, the report willinclude the calculated values for the period ending date. To define a report layout, select from the pre-defined values available in each column. Then, type the headings for each column. After you define a report, you can run it at any time using ADB-Cost of Funds Report (AD290). For example, if your quarter ends on March 31 and you choose an effective date of March 15, you can customize your report to include comparisons of the balances as of December 15. If you choose period 3 of last year, you can customize your report to compare the balances for the period end dates. NOTE Before you run a report for an effective date, you must run TransactionPOsting (AD190) for that date.
Updated files (3)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| REPORTINFO | No description in the Lawson data dictionary | AD |
| RWGRPDET | Report Writer Group Detail | GL |
Referenced files (14)
| Table | Description | System |
|---|---|---|
| ADCOMPANY | Average Daily Balance Company | AD |
| GLADDRESS | General Ledger Company Address | IF |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCPYGRP | General Ledger Company Group | IF |
| GLNAMES | General Ledger Names | IF |
| GLSYSTEM | General Ledger Company | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWHEADER | Report Writer Header | GL |
Program calls
Invoked programs (6)
GLAC, GLBL, IFAU, IFOB, IFSG, IFUP