## Updating the JD Edwards EnterpriseOne Enhanced Real Estate Management System

This chapter provides an overview of updating rent changes globally and discusses how to:

- Update bank base rates globally.

- Update payment profile statuses globally.

- Update accounting profile statuses globally.

- Purge unposted billing transactions.

### Understanding Updating Rent Changes Globally

The JD Edwards EnterpriseOne Enhanced Real Estate Management system provides several programs to assist you in managing changes that affect numerous records for the leases and billing activity.

The programs that you use to select and update records for rent changes in the JD Edwards EnterpriseOne Enhanced Real Estate system correspond to the programs that you use for the same purpose in the JD Edwards EnterpriseOne Real Estate Management system:

- Rent Change Global Selection program (R74U1521) corresponds to the Recurring Billing Global Selection program (R15021)

- Rent Change Global Update program (R74U1516) corresponds to the Recurring Billing Global Update program (R15116).

The only difference between the two sets of programs is the selection and update of the Payment Profile table (F74U0205) and the Recurring Billing Tag (F74U02BT). Otherwise, the process to select records and the process to update records is the same.

Note. When the system updates records to recurring billing, the payment and accounting profiles are created interactively.

### Updating Bank Base Rates Globally

This section provides an overview of updating bank base rates and discusses how to:

- Update bank base rates globally.

- Set processing options for Global Bank Rate Update (R74U0202).

#### Understanding Updating Bank Base Rates

You enter bank base rates to use to charge interest or fees. To update the rate, you must enter a new bank record. If you have many bank records to update, rather than reentering the information manually for each record, you can use this program to update one or more records simultaneously.

You specify which records to update using data selection. If you do not enter any data selection, the system selects all records. You use processing options to specify the percentage by which you want the rates to change, whether to increase or decrease the rate, and the date on which the new rate becomes effective. You can run the Bank Base Rate Global Update program (R74U0202) in either proof or final mode:

- In proof mode, the system generates a report of the records selected to update.

  The report includes the old interest rate and the new interest rate that would result from the change.

- In final mode, the system generates a report of the number of records changed, but it does not include the details of the old and new rates.

  Because the system generates new records, however, you can review the old and new records using the Bank Base Rate Maintenance program (P74U0202).

#### Update Bank Base Rates Globally

Select Global Updates (G74U15311), Bank Base Rate Global Update.

#### Setting Processing Options for Global Bank Rate Update (R74U0202)

Processing options enable you to specify the default processing for programs and reports.

Rate

1. Interest Rate Change | Specify the percentage by which you want the rent amount increased or decreased. Enter the percentage as a decimal value. For example, enter .050000 to specify five percent.
2. Type of Increase | Specify whether to use the percentage that you entered in the Interest Rate Charge processing option to increase the rent amount or decrease the rent amount. Values are: +: Increase. –: Decrease.

Proof/Final

1. Proof or Final | Specify whether to run the program in proof or final mode. Values are: 0: Proof mode. The system generates a report of the records selected to update. 1: Final mode. The system updates the Bank Base Rates (EPM) table (F74U0202) and generates a report of the number of records updated.

Date

1. Date - Beginning Effective | Specify the date to use as the beginning effective date for the bank base rate records that the system updates. If you leave this processing option blank, the system assigns today's date as the effective start date for the new rate.

Update

1. Interest Charging Update | Specify whether the system performs an update. This processing option should always be set to 1 unless advised otherwise by an Application Consultant. Values are: Blank or 0: Do not perform the update. 1: Perform the update.

### Updating Payment Profile Statuses Globally

This section provides an overview of updating payment profile statuses and discusses how to:

- Change payment profile statuses.

- Set processing options for Payment Profile Status Change (R74U0221).

#### Understanding Payment Profile Status Updates

When generating payment profile records, the system assigns an open status (blank). The Global Generation program selects payment profile records to generate billing records in the F1511B table. If you need to change the status on payment profile records to prevent them from being selected for billing, you can run the Payment Profile Status Change program (R74U0221) to update the records quickly. You might use this program when you:

- Manually suspend a recurring billing record.

  The system does not automatically update the status on the associated payment profile records when you suspend a recurring billing record; therefore, you must update the status to prevent the records from generating billing records. Depending on the number of payment profile records generated, this program can save you hours of time updating each record individually.

- Return payment profile records to open (blank) status.

  If you revise records after you have generated payment profile records, the system generates new records and assigns a status, such as Pending Cancellation or canceled to the old, obsolete records. If, however, you need to make additional changes that require you to clear the payment profile records, the system returns an error because it can clear only those records that have an open (blank) status. You must use this program to reset the status of the payment profile records back to blank so that you can revise the recurring billing record; you cannot reset the status to blank using the manual process.

The system stores records by line number and payment profile line number. The line number corresponds to the bill code and period for which the transaction is generated. Because multiple payment profile records are generated for each recurring billing record, the system assigns a payment profile line number (PPLN) to uniquely identify the records to update. The payment profile line number is a sequential number that the system assigns when the payment profile records are generated.

When you run the Payment Profile Status Change program, the system generates a report that lists each record and the change that was made to the status. The system selects the records to update from the Payment Profile Status History table (F74U207A).

Note. This program does not have an option to generate a report of the records selected before updating them.

#### Changing Payment Profile Statuses

Select Global Updates menu (G74U15311), Payment Profile Status Change.

#### Setting Processing Options for Payment Profile Status Change (R74U0221)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Lease Number | Specify the lease number of the payment profile records to select for updating. If you leave this processing option blank, the system does not select any records.
2. Source Batch Number | Specify the source batch number to use to select the payment profile records to update. If you leave this processing option blank, the system does not use the source batch number as selection criteria.
3. From Line Number and 4. To Line Number | Specify the beginning line number or the ending line number for the range of line numbers that the system uses to select the records to update. If you leave these processing options blank, the system selects records based on the value entered in the To Line Number processing option only. Note. The line number corresponds to the value that appears in the Line Number field (LNID) on the Work With Payment Profile form.
5. From Payment Profile Line Number and 6. To Payment Profile Line Number | Specify the beginning payment or the ending payment profile line number for the range of payment profile line numbers that the system uses to select the records to update. If you leave these processing options blank, the system selects records based on the value entered in the To Payment Profile Line Number processing option only. Note. The system does not display the payment profile line number (PPLN) on any form. The system uses this number to identify the payment profile status records that the system generates for each billing code.
7. Billing Code | Specify the billing code to use to select the payment profile records to update. If you leave this processing option blank, the system does not use the billing code as selection criteria.
8. Change to Status | Specify the status code from UDC table 74U/PP to assign to the payment profile records that the system selects.
9. Remark | Specify the text to assign to the Remark field on the Work With Payment Profile Status History form.

### Updating Accounting Profile Statuses Globally

This section provides an overview of updating accounting profile statuses globally and discusses how to:

- Change accounting profile statuses for periodic records.

- Set processing options for Periodic Accounting Profile Status Change (R74U0222).

- Change accounting profile statuses for weekly records.

- Set processing options for Weekly Accounting Profile Status Change (R74U0223).

#### Understanding Updating Accounting Profile Statuses Globally

When you run the Accounting Profile Journal Creation program, the system generates journal entries based on the status of the accounting profile records. If you do not want to generate journal entries on a subset of records for the lease or for the recurring billing line, you must update the status of the accounting profile record to prevent the program from selecting the records.

Because accounting profile records are stored in separate tables depending on whether you generate them periodically or weekly, the system provides separate programs to update the statuses.

Periodic Accounting Profile Status Change

You run the Periodic Accounting Profile Status Change program (R74U0222) to change the status of records that are stored in the Periodic Accounting Profile Status History table (F74U207B). You might need to run this program when you:

- Manually suspend a recurring billing record.

  The system does not automatically update the status on the associated accounting profile records when you suspend a recurring billing record; therefore, you must update the status to prevent the records from generating journal entries. This program can save you time because you don't have to update each record individually.

- Return accounting profile records to open (blank) status.

  If you revise records after you have generated accounting profile records, the system generates new records and assigns a status, such as Pending Cancellation or canceled to the old, obsolete records. If, however, you need to make additional changes that require you to clear the accounting profile records, the system returns an error because it can clear only those records that have an open (blank) status. You must use this program to reset the status of the accounting profile records to open so that you can revise the recurring billing record. You cannot reset the status to open using the manual process.

The system stores records by line number and accounting profile line number. The line number corresponds to the bill code and period for which the transaction is generated. Because multiple accounting profile records are generated for each recurring billing record, the system assigns an accounting profile line number to uniquely identify the records to update. The accounting profile line number is a sequential number that the system assigns when the accounting profile records are generating.

When you run the Periodic Accounting Profile Status Change program, the system generates a report that lists each record and the change that was made to the status.

Note. This program does not have an option to generate a report of the records selected before updating them.

Weekly Accounting Profile Status Change

You run the Weekly Accounting Profile Status Change program (R74U0223) to change the status of records that are stored in the Weekly Accounting Profile Status History table (F74U207C). The system stores records by line number and accounting profile line number. The line number corresponds to the bill code and period for which the transaction is generated. Because multiple accounting profile records are generated for each recurring billing record, the system assigns an accounting profile line number (ACPL) to uniquely identify the records to update. The accounting profile line number is a sequential number that the system assigns when the accounting profile status records are generated.

When you run the R74U0223 program, the system generates a report that lists each record and the change that was made to the status.

Note. This program does not have an option to generate a report of the records selected before updating them.

#### Changing Accounting Profile Statuses for Periodic Records

Select Global Updates (G74U15311), Periodic Accounting Profile Status Change.

#### Setting Processing Options for Periodic Accounting Profile Status Change (R74U0222)

Processing options enable you to specify the default processing for programs and reports.

Selection

1. Lease Number | Specify the lease number of the accounting profile records to select to update. If you leave this processing option blank, the system does not select any records.
2. Line Number | Specify the line number to use to select the records to update.
3. Accounting Profile Line Number | Specify the accounting profile line number to use to select the records to update. The system does not display the accounting profile line number (ACPL) on any form. The system uses this number to identify the accounting profile status records that the system generates for each billing code.
4. Change to Status | Specify the status code from UDC table 74U/PP to assign to the payment profile records that the system selects.
5. Remark | Specify the text to assign to the Remark field. This text will appear on the Periodic Accounting Profile History form.

#### Changing Accounting Profile Statuses for Weekly Records

Select Global Updates (G74U15311), Weekly Accounting Profile Status Change.

#### Setting Processing Options for Weekly Accounting Profile Status Change (R74U0223)

These processing options are identical to those for the Periodic Accounting Profile Status Change program (R74U0222).

See Setting Processing Options for Periodic Accounting Profile Status Change (R74U0222).

### Purging Unposted Billing Transactions

This section provides an overview of the Batch Delete program (R74U5806) and discusses how to:

- Purge unposted billing batches.

- Set processing options for the Batch Delete program (R74U5806).

See Purging JD Edwards EnterpriseOne Real Estate Management Tables.

#### Understanding the Batch Delete Program (R74U5806)

You can use the Batch Delete program (R74U5806) when you have processed records in error. Be cautious when using this program because it deletes transactions based on the batch number that you enter from JD Edwards EnterpriseOne Enhanced Real Estate Management, JD Edwards EnterpriseOne Real Estate Management, JD Edwards EnterpriseOne Accounts Payable, JD Edwards EnterpriseOne Accounts Receivable, and JD Edwards EnterpriseOne General Accounting systems. The R74U5806 program ensures that all related transactions are purged from all systems and minimizes integrity problems that could result when you have to purge records from tables separately.

The R74U5806 program removes records that remain unposted in the Account Ledger table. These records include any transaction that posts from the Lease Billings Master (F1511B) table to the Customer Ledger (F03B11) or Accounts Payable Ledger (F0411) tables, but fails to post to the Account Ledger table (F0911). In this case, all of the associated records (F1511B, F03B11, F0411, and F0911) are considered unposted.

You cannot use the Batch Delete program to delete batches of receipts, revenue fees, or security deposits, or accounting profile records, because the system does not write records to the Lease Billings Master table, which is the source table used to retrieve the batch number; the Batch Delete program deletes batches only when records exist in table F1511B.

Note. The R74U5806 program can also be used for unposted EP Calculation (R74U5110) batches where only F1532B and F1538B records exist.

The R74U5806 program removes records from these tables based on the batch number that you enter:

- Batch Control Records table (F0011)

- Customer Ledger table (F03B11)

- Accounts Payable Ledger table (F0411)

- Account Ledger table (F0911)

- Estimated EP Recurring Billings table (F1502WB)

- Lease Billings Master table (F1511B)

- Expense Participation Audit File table (F1532B)

- EP Billing Register table (F1538B)

- Payment Profile table (F74U0205)

  Note. Only those payment profile records created for actual Expense Participation billings are deleted; otherwise, the payment profile status is changed from generated to open (blank).

Note. Records do not necessarily exist in all of the tables for the batch number specified.

When you run the R74U5806 program, the system:

- Removes all transactions that exist in the tables for the batch number entered.

- Resets the billing control ID for the related period from G (generated) or B (billed) for generation types 2 and 6 to blank in the Billings Generation Control table (F15011B) so that you can generate billings again for that period.

- Returns the status of the payment profile records to open.

Important! Because this program deletes records and updates tables, run the program in proof (edit) mode to verify that the records selected are correct, and then run the program in final (update) mode.

#### Purging Unposted Billing Batches

Select Purges (G74U15312), Batch Delete.

#### Setting Processing Options for the Batch Delete Program (R74U5806)

Processing options enable you to specify the default processing for programs and reports.

Select

1. Batch Number | Specify the batch number of the records to delete. Warning! This program deletes the Property Management batch value in the Batch Number field. The batch may not be recovered. Do not use this program to delete cash receipts or security deposit refund batches.
2. File Deletion Selection | Specify whether the system deletes records for the batch from the Accounts Payable Ledger table (F0411) or the Customer Ledger table (F03B11). Values are: Blank: Customer Ledger table. 1: Accounts Payable Ledger table.

Process

1. Posted Tenant Invoice Delete | Specify whether to delete the posted Lease Billings Master records (F1511B) that do not have corresponding Customer Ledger (F03B11), Accounts Payable Ledger (F0411), or Account Ledger (F0911) records. For example, invoices that have a zero amount and carry-forward pending and carry-forward taken records generated from sales overage. Values are: Blank: Do not delete. 1: Delete.

Print

1. Audit Trail Report | Specify whether the system prints an audit report of the records deleted by this program. Values are: Blank: Do not print. 1: Print.
2. Edit or Update | Specify whether to process records in proof or final mode. Use this processing option in conjunction with the Audit Trail Report processing option to print a report of the batches to process for deletion. Values are: Blank: Edit mode only. The system does not delete the records for the batch number specified. 1: Delete the records. The system deletes the records for the batch number specified. The system generates a report of the deleted batches only if you enter 1 in the Audit Trail Report processing option.