This chapter contains the following topics:
Processing fees and interest is the same for the JD Edwards EnterpriseOne Enhanced Real Estate Management system as it is for the JD Edwards EnterpriseOne Real Estate Management system:
You enter fee and interest information in tables.
You calculate fee and interest amounts.
You generate fee and interest billing records, which you post.
|
Note: All of the programs that the JD Edwards EnterpriseOne Enhanced Real Estate Management system uses to process fees and interest are located on the G74U1527 menu. |
|
Caution: Do not use the Fee and Interest programs from the G1527 menu because these programs will not update the correct tables. |
Use the Enhanced Fee and Interest Information program (P74U1525) to set up the fee and interest values that the system uses to generate calculations with the Fee & Interest Calculation program (R74U5160) and the Global Generation program (R74U0210).
The process to enter the fee and interest information and to generate fee and interest records is the same for the JD Edwards EnterpriseOne Enhanced Real Estate Management system as it is for the JD Edwards EnterpriseOne Real Estate Management system, with these exceptions:
You can use a bank code to assess the fee or interest instead of setting up amounts or percentages.
The system retrieves the tax information from the unit or property, not from the customer master record.
You cannot enter a currency code.
The system generates the fee and interest records in the currency that is assigned to the lease.
The system updates the Interest Tag table (F74U25BT) in addition to the A/R Fee Interest table (F1525B).
|
Note: You cannot revise the tax information on the fee and interest records unless you select the Allow Interest Tax Code Change check box in the Additional Company Constants. |
This section provides an overview of fee and interest records and discusses how to:
Calculate fee and interest.
Set processing options for Fee and Interest Calculation (R74U5160).
The JD Edwards EnterpriseOne Enhanced Real Estate Management system uses these programs to generate fee and interest records:
Fee & Interest Calculation program (R74U5160). This program processes the fee calculations and generates records in the Payment Profile table (F74U0205).
Global Generation program (R74U0210). This program generates records in the Lease Billings Master table (F1511B).
The Fee & Interest Calculation program (R74U5160) processes fees and interest records like Fee & Interest Generation program (R15160) from the JD Edwards EnterpriseOne Real Estate Management system, with these exceptions:
The R74U5160 program generates payment profile records only.
The R74U5160 program uses the rate associated with the bank code, if specified.
If you use a bank code and complete the Interest Adjustment Pct (interest adjustment percent) field that is set up on the Maintain Lease Master Additional Information form, the system adds the percentage that you specify to the rate entered for the bank code.
If the bank rate changes during the period in which you generate fees and interest, the system calculates the fee and interest based on each effective date only when you select the Allow Interest Date Change check box using the Additional Company Constants. Otherwise, the system uses the bank record with the most recent effective date, regardless of whether it is set up for the period during which processing occurs.
|
Note: You can override the interest adjustment percent on the recurring bill code line, if desired. |
The R74U5160 program generates one fee or interest record per bill code; there is no processing option to specify a File Update Method to generate the fee or interest by invoice number.
Select Fees & Interest (G74U1527), Fee & Interest Calculation.
Set these processing options before calculating fee and interest records.
Specify the company to process.
Specify a user-defined code (UDC) from UDC table 15/FY that specifies the type of fee to process.
Specify the lease currency code.
Specify the date the system uses to select the invoice records for which are generating fees or interest. The system selects only those invoice records with an open amount that have a due date that is on or before the date that you enter. If you leave this processing option blank, the system uses the current date.
Specify the general ledger date to assign to the fee or interest invoice records that the system generates.
Specify the date to assign to the fee or interest records that the system generates. If you leave this processing option blank, the system assigns the current date as the invoice date.
Specify whether the report selects records that are open or paid. Values are:
Blank: Open records.
1: Paid records.
Specify whether the program runs in proof or final mode. Values are:
Blank: Proof mode. The system generates only a report.
1: Final mode. The system generates the fee or interest record, updates the appropriate tables, and generates a report.
Specify whether the system verifies that the Subject to Late Fees option (LTFE) is selected in the Bill Codes / Adjustment Reasons program (P1512) for the bill code for which the late fee is processed. Values are:
Blank: Verify that the option is selected.
The system does not generate late fees for bill codes that do not have the Subject to Late Fees option selected.
1: Do not verify that the option is selected.
The system generates late fees for all of the bill codes specified, regardless of the setting of the Subject to Late Fees option.
Specify the reason code used to retrieve the offset account for the Receipts Detail record (F03B14) that the system generates for the compounded interest on security deposits. The system retrieves the account from the AAI item RAxx, where xx is the reason code.
The system uses this processing option only when you specify to generate compounded interest on security deposits. If the Compound Flag field (COPF) is set to blank, the system ignores this processing option.
Specify up to four rates that the system uses to calculate the fee or interest when the value in the Rate Indicator Code field (RAIF) in the Fee and Interest table (F1525B) is equal to 1,2,3, or 4. The system uses the rate from this processing option that corresponds to the value in the Rate Indicator field. If the value of the Rate Indicator field is%, the system ignores this processing option.
Enter the rate in decimal format. For example, type 0.05 to specify five percent.
Select the report summarization by lease number or by bill code. Values are:
Blank: Bill code.
1: Lease number.