6 Processing Expense Participation Billings

This chapter contains the following topics:

6.1 Understanding the Expense Participation Process

The process that generates expense participation billings 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 set up expense classes.

  • You enter expense participation information.

  • You generate expense participation calculations.

  • You review and revise calculations, if necessary.

  • You generate expense participation billing records.

The differences between the two systems are discussed in these sections:

  • Entering Expense Participation Information.

  • Generating, Reviewing, and Revising Expense Participation Calculations.

  • Generating Expense Participation Billings.

  • Deleting Expense Participation Batches.

  • Generating Estimated Expense Participation Billings.

6.1.1 Program Navigations

All of the programs that the JD Edwards EnterpriseOne Enhanced Real Estate Management system uses to process expense participation are located on the G74U1523 menu. Even if you use the corresponding program for JD Edwards EnterpriseOne Real Estate Management, the system launches the program for JD Edwards EnterpriseOne Enhanced Real Estate Management because of the value in the Localization Country Code field on the User Profile Revisions form.

6.1.2 Entering Expense Participation Information

The process to enter expense participation information using the E.P. Information program (P74U5012) 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, which uses the E.P. Information program (P15012), with these exceptions:

  • The system uses billing patterns instead of billing frequencies.

    The billing pattern that you enter must be a fiscal link, which enables you to process expense participation information according to the fiscal date pattern instead of solely by calendar year. You can still process expense participation by calendar year as long as the fiscal date pattern that you use for the billing pattern is based on a calendar year.

  • The system enables you to specify a payment method to bill in advance, as well as in arrears.

  • The system retrieves the tax information from the Lease Master Tag File (F74U01BT), instead of the customer or supplier master record.

    If you do not set up tax information for the unit, the system uses the tax information that is set up for the building.

  • The system does not use tenant exclusion rules.

  • The system does not use share factor denominators.


Note:

(Release 9.1 Update) For UK, with the alternate tax rate/area functionality, when you enter expense participation information using the E.P. Information program, the system assigns the alternative tax rate/area based on the building and tenant country information or it retrieves the tax rate/area from the tenant of the lease.

When you complete the grid line and do not enter a value in the Tax Rate/Area field, the system retrieves the alternate tax rate/area if the EU Tax/Rate Constant is enabled for the company of the building that you enter. If the company is not set up for the building, the system retreives the company information from the Lease Master Detail table (F15017). The system assigns the alternate tax rate/area based on the building, tenant, and company information.

If you change the building on the grid, the system rectrieves the tax rate/area based on the new building and tenant. However, when you enter a value in the Tax Rate/Area field, the system does not change this value even if you change the building information.


6.1.2.1 Processing Options for E.P. Information (P74U5012)

The processing options for the E.P. Information program (P74U5012) are a subset of the processing options for the E.P. Information program (P15012) in the JD Edwards EnterpriseOne Real Estate Management system. The following processing options from the P15012 program are not available in the P74U5012 program:

  • Allow Overrides to Billed Lines

  • Default Area Calculation Method

  • Transaction Currency Override

  • Exchange Rate Override

See "Setting Up Expense Participation Information" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide

6.1.3 Generating, Reviewing, and Revising Expense Participation Calculations

The system generates calculations using the same formulas that the E.P. Calculation Generation program (R74U5110) uses in the JD Edwards EnterpriseOne Real Estate Management system. The process to review and revise calculations and the programs on the menu are the same.

6.1.3.1 Processing Options for E.P. Calculation Generation (R74U5110)

The processing options for the E.P. Calculation Generation program (R74U5110) are a subset of the processing options for the E.P. Calculation Generation program (R15110) in the JD Edwards EnterpriseOne Real Estate Management system. The following processing options from the R15110 program are not available in the R74U5110 program:

  • Account Range Inclusion

    The E.P Information Revisions form has no fields in which to specify objects and subsidiaries, so no information is available for inclusions.

  • For the Occupied Area Option processing option, the value 2(occupancy refresh results) is not valid in the JD Edwards EnterpriseOne Enhanced Real Estate Management system since the system does not use tenant exclusion or share factor denominator rules.

  • Occupancy Refresh (R15141) Version 1

  • Occupancy Refresh (R15141) Version 2

  • Occupancy Refresh (R15141) Version 3

  • Version Override

    You cannot override the dates to retrieve estimated billings for lease versioning.

See "Generating Expense Participation Calculations" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide

6.1.4 Generating Expense Participation Billings

The JD Edwards EnterpriseOne Enhanced Real Estate Management system uses these programs to generate expense participation billing records:

  • E.P. Billing Generation (R74U5101)

    This program generates records in the Payment Profile table (F74U0205).

  • Global Generation (R74U0210)

    This program generates records in the Lease Billings Master table (F1511B).

The process to generate expense participation billings 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:

  • The system generates records in the Payment Profile table (F74U0205) only.

  • The system assigns the currency of the building as the currency in which it generates billing amounts, not the currency of the lease.

After you generate expense participation records in the F74U0205 table, you must run additional programs to complete the billing process.

6.1.4.1 Processing Options for E.P. Billing Generation (R74U5101)

The processing options for the E.P. Billing Generation program (R74U5101) in the JD Edwards EnterpriseOne Enhanced Real Estate Management system are the same as those for the E.P. Billing Generation program (R15101) in the JD Edwards EnterpriseOne Real Estate Management system with this exception; R74U5101 does not include a processing option to specify a version of the Billing Edit/Register program (R15300). This processing option is included on the Global Generation program (R74U5101), which you must run to generate F1511B records.

See "Generating Expense Participation Billings" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide

6.1.5 Deleting Expense Participation Batches

The JD Edwards EnterpriseOne Enhanced Real Estate Management system does not provide a separate program for deleting expense participation batches. Do not use the E.P. Batch Delete program (R158061) from the JD Edwards EnterpriseOne Real Estate Management system because it will not delete the associated payment profile records. Instead, use the Batch Delete program (R74U5806) for JD Edwards EnterpriseOne Enhanced Real Estate Management.

6.1.6 Generating Estimated Expense Participation Billings

The process to generate estimated expense participation billings 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 run the Estimated E.P. Billing Generation program (R74U5102), unless you use the calculations that were generated for actual expense participation billings.

  • You run the Estimated E.P. Edit/Update program (R74U5113).

    You can specify to run this program in proof mode by setting a processing option in the E.P. Billing Generation program (R74U5101).

When you run E.P. Edit/Update (R74U5113), the system updates the Payment Profile table (F74U0205) and the Accounting Billing Profile table (F74U0212) in addition to the Recurring Billings Master table (F1502B) and the Recurring Billing Tag table (F74U02BT).

After you run the E.P. Edit/Update program, you must run additional programs to complete the billing process.

6.1.6.1 Processing Options for Estimated E.P. Billing Generation

The processing options for Estimated E.P. Billing Generation (R74U5102) in the JD Edwards EnterpriseOne Enhanced Real Estate Management system are the same as the processing options for Estimated E.P. Billing Generation (R15102) in the JD Edwards EnterpriseOne Real Estate Management system.

See 'Generating Estimated Expense Participation Billings" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide

6.1.6.2 Processing Options for Estimated E.P. Edit/Update

The processing options for the Estimated E.P. Edit/Update (R74U5113) are a subset of the processing options for the Estimated E.P. Edit/Update (R15113) in the JD Edwards EnterpriseOne Real Estate Management system.

The following processing options in the R15113 program are not available in the R74U5113 program:

  • Proof or Final

  • Display of Tax Fields

The following processing options are unique to the R74U5113 program:

  • Print Edit Report

  • Bill Pattern Code

  • Catch Up Bill Pattern

See "Understanding Estimated Expense Participation Billings Update" in the JD Edwards EnterpriseOne Applications Real Estate Management Implementation Guide