AD191 – Cost of Funds
- System
- Avg Daily Balance (AD)
- Type
- Batch program
- Updates
- 9 tables
- References
- 18 tables
AD191 (Cost of Funds) is a Lawson Avg Daily Balance batch program. It updates ADBALANCE, ADCFBAL, ADCOMPANY, ADCONSOL, ADDRDATA, CKPOINT, GLSYSTEM, RATOTALS and 1 more and references ADAVGBAL, ADMASTER, GLADDRESS, GLAMOUNTS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM and 10 more.
About AD191
Run Cost of Funds (AD191) to calculate the cost of funds (deposits) or yield(funds on loan) for the company. This program uses the average daily balances calculated in Transaction Posting (AD190). Only ADB accounts with an interest account or ratio total name specified in Accounts (AD20) are included.The formula used to calculate the cost of funds or yield is: (interest / principle) divided by (period / year). Where: Interest is the accumulation of all interest account amounts for all ADB accounts; principle is the accumulation of all average daily balance amounts for all ADB accounts, and period/year is the period and year values (number of days) from AD20. This program creates a report which displays summary information for each ADB account for the period, quarter-to-date, and year-to-date selected.
Updated files (9)
| Table | Description | System |
|---|---|---|
| ADBALANCE | ADB and COF by Period | AD |
| ADCFBAL | Cost of Funds by Date | AD |
| ADCOMPANY | Average Daily Balance Company | AD |
| ADCONSOL | ADB and COF Consolidation | AD |
| ADDRDATA | Address Code | IF |
| CKPOINT | No description in the Lawson data dictionary | — |
| GLSYSTEM | General Ledger Company | IF |
| RATOTALS | Ratio Totals | GL |
| ULTOTALS | No description in the Lawson data dictionary | GL |
Referenced files (18)
| Table | Description | System |
|---|---|---|
| ADAVGBAL | Average Daily Balance by Date | AD |
| ADMASTER | Average Daily Bal Acct Master | AD |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| INSTCTRYCD | Intrastat Country Codes | TX |
| MLCALMAP | Multi-Book Ledger Calendar Map | ML |
| MLCOLEDGER | Multi Book Ledger Co Ledger | ML |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| RWGRPDET | Report Writer Group Detail | GL |
| RWROWDET | RW Row File Detail | GL |
| ULPOST | This file is used to store the last posting date and time. | IF |
Program calls
Invoked programs (7)
GLAC, GLBL, GLRV, IFOB, IFSG, IFUP, MLRV