Understanding the Recurring Billing Process

If you bill the tenants or pay landlords or lessors the same amount on a regular basis, you can enter recurring billing information and generate billings automatically by billing frequency. Additionally, if you use other processes such as escalations, expense participation, and straight-line rent, the system updates the recurring billings table so that invoices or vouchers can be generated automatically when the recurring billing process is completed. The system can also generate prorated billings for partial billing periods and catch-up billings for unbilled periods.

Note: The system bills the full amount for the current period based on the billing frequency and date pattern, regardless of the number of days the unit or building is occupied. Ensure the proration option is set correctly.

This table describes the steps in the recurring billing process:

Step

Description

Enter recurring billing information.

You enter recurring billing information, such as the bill codes and billing frequencies, start and end dates, payment terms, and so forth, that the system uses to generate billing records.

(Release 9.2 Update) When you enter recurring billing information, you can view the Straight-line Rent Generation flag to determine whether the bill code you are using will be included in straight-line rent processing. Processing option settings in the P1501 control whether you can update this flag.

(Release 9.2 Update) If you are entering recurring billing information for a lessee accounting lease, you can specify information about those billing records that the system uses when creating amortization schedules for the associated assets.

Generate recurring billings.

You generate the billing records that you process into invoices or vouchers. The system creates a batch record in the Batch Control Records table (F0011) and records in the Lease Billings Master table (F1511B).

(Release 9.2 Update) If balance sheet lessee accounting is turned on, the entries generated will use the lease accounting AAIs rather than the standard real estate billing AAIs.

Generate Billing Edit/Register report.

After you generate recurring billings, you must run version XJDE0001 of the Billing Edit/Register program (R15300) to validate the transactions in the batch and to change the batch status.

(Release 9.2 Update) The R15300 has been updated to determine if billing records should be included in the revenue recognition process. The program compares the information on the billing transaction to the revenue recognition trigger configuration, and if the record should be included in the revenue recognition process, the system validates that the appropriate AAIs and accounts are set up.

See Generating the Billing Edit/Register Report.

Review transaction batches.

You use the Real Estate Journal Review program (P150011) to review, revise, and delete transactions, such as billings or fees, from a batch

If no errors occur when you run the R15300 program, the system changes the batch status to either Pending or Approved, depending on the setting of the Management Approval of Input option in the Accounts Receivable or Accounts Payable constants. If you select the Management Approval of Input option, the system changes the batch status to pending and you must approve batches before posting them. If you do not select the Management Approval of Input option, the system changes the batch status to approved and the batches are ready to post.

Review recurring billings. (optional)

You can review the batch of recurring billing records in the Recurring Billing Information report (R154011) before you post them. You can also revise or delete billing transactions as necessary.

See JD Edwards EnterpriseOne Real Estate Management ReportsJD Edwards EnterpriseOne Real Estate Management Reports.

Post invoices and vouchers

After you generate the billing edit register, you must run the R15199 program to generate the invoices or vouchers.

For payable leases, the system creates vouchers with a Supplier Invoice Number (VINV) as a combination of doc type, doc number (for the voucher) and company.

(Release 9.2 Update) The R15199 has been updated to determine if billing records should be included in the revenue recognition process by comparing the information on the billing transaction to the Real Estate trigger configuration. If at least one pay item from the billing invoice is included in revenue recognition processing, the system writes journal entries to the performance liability accounts instead of writing to the billing accounts and creates the corresponding entries for revenue recognition in these tables:

  • Revenue Recognition Invoice (F03B116)

  • Revenue Recognition GL Info (F03B117)

  • Customer Ledger Tag Table (F03B11T)

See Posting Invoices and Vouchers.

Print invoices (optional)

After you post invoices, you can print and send them to the tenants.

See Printing Invoices.

Print statements (optional)

After you post invoices, you can print statements and send them to the tenants.

See Printing Statements.

Review billing, invoice, and voucher transactions (optional)

You can review recurring billing transactions in detail using the Billings Transaction Inquiry program (P15211).

See Reviewing Billing Transactions.

Review tenant invoice transactions (optional)

You can review the invoices generated from recurring billing transactions by using the Tenant Ledger Inquiry program (P15222).

See Reviewing Applied Receipts.

Review tenant voucher transactions (optional)

You can review the vouchers generated from recurring billing transactions by using the Supplier Ledger Inquiry program (P0411).

See "Entering Standard Vouchers" in the JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide.