APL |
APL Billvue Billing System Reference |
APL Billvue Billing System Reference
Tip: An Adobe AcrobatTM formatted version of this document (PDF) materials are available for sharing with your customer.
Account Master Database
Add the account to the system using EDITAC. As a helpful tool, a billing template can be created in EDITACFIELDS.
The fields most commonly used for billing are described below:
ADM |
Account Administrator. |
| ADVARR |
Billing type:
|
| ALLOC | Allocation agreement for allocation schedule. |
| AUTOD |
Auto Debit:
|
| AVGBIL |
Billable value:
|
| BEGDTE | Override the beginning date for billing for non month-end. |
| BILL NOTES | Special notes or instructions regarding bills or invoices. |
| BILTMP | Billing template name. |
| BLBGDT | Date to start billing. |
| BWNUM | Account number. |
| CLODT | Date to stop billing. |
| COMBON | Group account identifier for combined account billing. |
| COPY1-4 | SNAM for the recipients of the invoice. Up to 4. |
| DISCNT | Percentage discount off the invoice. |
| FEEAGR | Fee agreement for billing. |
| FIXED | Fixed dollar amount to be billed. |
| FREQCY |
Reporting / billing frequency:
|
| MGR | Manager code. |
| MINMUM | Minimum dollar amount of bill per billing period. |
| SNAM | Short name for the account. |
Basic Fee Calculations
Fixed
FEEAGR = FIXED
Client is billed a flat fee regardless of the value of the account.
Straight Line
PCT x MV = B
Client is billed a fixed percentage regardless of the value of the account.
| PCT | Fixed Percentage |
| MV | Total Market Value |
| B | Billing Fee |
Level Billing
Allows clients to bill accounts at different rates and at different levels.
FEEAGR = CALC plus TYPE = LEVEL
Example:
| FEEAGR | TYPE | AMT | RATE |
|---|---|---|---|
| CALC2 | LEVEL1 | 0.00 | 1.000% |
| CALC2 | LEVEL2 | 100,000 | 0.5000% |
Incremental
Allows clients to bill at different rates on different market value increments.
FEEAGR = CALC plus TYPE = INCR#
Example:
| FEEAGR | TYPE | AMT | RATE |
|---|---|---|---|
| CALC3 | INCR01 | 200,000 | 1.000% |
| CALC3 | INCR02 | 100,000 | 0.9000% |
| CALC3 | INCR03 | 999999 | 0.8000% |
Interval Billing
Accounts are billed at a flat rate, but that rate is determined by the size of the portfolio.
| FEEAGR | TYPE | AMT | RATE |
|---|---|---|---|
| CALC4 | INTV01 | 0.00 | 1.000% |
| CALC4 | INTV02 | 100,001 | 0.7500% |
| CALC4 | INTV03 | 300,001 | 0.5000% |
Billing Adjustments
| Minimum | Client pays a percentage fee of the total market value or a specified dollar amount, whichever is greater. |
| Surcharge | Account is charged a flat administrative fee. |
| Discount | Client gets a percent discount off the total billable market value. |
| Rebate | Client gets a dollar rebate off the total billable market value. |
| Maximum | Client pays a percentage fee of the total market value or a specified dollar amount, whichever is lower. |
Editing Screens
| View or Editing Fee Schedules | |
|---|---|
| FEE SCHEDULE | Edit and Define Fee Schedules. |
| Editing Account Information | |
|---|---|
| DEFAULT TABLE | Edit fields coded the same across a group of accounts. |
| BILLEDIT | Edit billing profile fields for a single account. |
| QKEDIT | Edit billing profile fields for a group of accounts. |
Establishing and Editing Billing Classes | |
|---|---|
| SCREENFEESECT | The Class Default Editor distinguishes assets classes and allows asset classes to be billed at different levels or excluded as needed. |
Billing Screens
| Posting Values | |
|---|---|
| BILLSCT | Post class values used in billing calculations. |
| BILLSECTNEW | Post class values used in billing calculations for new accounts. |
| EDITPM | View and edit billing market values. |
| Generating Charges | |
|---|---|
| MAKEJNL | Generate charges that should be applied to an account for billing. |
| EDITJNL |
View or edit charges that have been posted. Additional charges can be added using EDITJNL after MAKEJNL has been run. |
| Generating Invoices | |
|---|---|
| MAKEIVC | Create an invoice after all charges have been posted to an account. |
| EDITIVC | View or cancel an invoice after creation. |
| Generating Bills | |
|---|---|
| MAKEBILLS | Create a bill. |
Receivables System
The Receivables System allows user to track payments made to an account.
| MAKEPMT | Post a payment to an account. |
| EDITPMT | View or edit payments posted to an account. |
| MAKENOTE | Generate notices for an account that are more than a specified number of days past due. |
| MAKERBT | Generate rebates to accounts that are billed in advanced and are closed during a specific billing period. |
| General Ledger Postings |
|---|
| Post FEEADV and RCV entries to the general ledger using the function POSTIVCTOGL. |