1. Real Estate Management Implementation Guide
  2. Alternate Tax Rate/Area Assignments in Global Updates

Alternate Tax Rate/Area Assignments in Global Updates

The Lease Global Update program enables you to change the building, tenant, and other information in many of the tables used in the JD Edwards EnterpriseOne Real Estate Management system. The program, however, does not enable changes to the tax rate/area for the records in the tables.

The tax rate/areas assigned to transactions in the JD Edwards EnterpriseOne Real Estate Management system are determined, in part, by the building and tenant associated with the leases in the system. If you enable the alternate tax rate/area assignment functionality for the company of the building and work in a program that retrieves a tax rate/area based on the lease, tenant, and building, the system retrieves the alternate tax rate/area that you defined for the building and tenant. Because a change to the tenant or building during a global update can affect the tax rate/area assigned to a record, and changing the tax rate/area for a record is not allowed during a global update, the Lease Global Update program performs additional validations for tables that include the tax rate/area when the company of the building is set up to retrieve an alternate tax rate/area.

This list indicates the tables that you can update using the Lease Global Update program and which include the tax rate/area:

  • F15012B - Expense Participation Master.

  • F15013B - Sales Overage Master.

  • F15016B - Tenant Escalation Master.

  • F1502B - Recurring Billing Master.

  • F1511B - Tenant/Lease Billing Detail.

  • F1511HB - Tenant Billing Detail History.

  • F03B11 - Accounts Receivable Ledger.

  • F0411 - Accounts Payable Ledger.

When you set the processing options in the Lease Global Update program to update the building or tenant in the tables listed above, the Lease Global Update program determines whether the new values for the building or tenant are associated with a different tax rate/area than the tax rate/area already assigned in the tables. If the tax rate/area is the same for the existing and to-be-updated record, then the system allows the change to the table for the record. If the new tax rate/area associated with the new tenant or building is different from the existing tax rate/area saved to the table, then the system issues an error message and does not enable the change to the tenant or building for the record. If a validation fails, the process ends.

See also: