Real Estate Management
You can set up the building company, tenant, and building entities to use the alternate tax rate/area assignment functionality in the JD Edwards EnterpriseOne Real Estate Management system. When you add or modify a transaction with one of these entities, the system:
Checks whether the alternate tax rate/area assignment functionality is enabled for the company of the building.
Verifies that the VAT registration number (Tax ID) exists for the tenant and building entities.
Retrieves the tax rate/area for the transaction from the alternate tax rate/area assignment setup based on the tenant and building country codes.
If you receive a warning message because the alternate tax rate/area is not set up correctly, the system retrieves tax rate/area based on the tenant. If an error message appears, the system does not retrieve any tax rate/area. For both warning and error messages, you can manually enter a tax rate/area to override the warning or errors. If you manually enter a tax rate/area, then the system does not validate the tax rate/area and will not overwrite it.
Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:
Revenue Fee Generation (R15105)
Fee and Interest Generation (R15160)
Security Deposit Maintenance (P1565)
Fee and Interest Generation (R15160)
Security Deposit Refund Generation (R15655)
G/L Transaction Generation (R15199)
Edit Register (R15300)
This table describes how programs in the JD Edwards EnterpriseOne Real Estate Management system that use the alternate tax rate/area assignment functionality:
Program |
Comments |
|---|---|
Expense Participation (P15012) |
In the header area of the E.P. Information Revisions form, the system checks if the alternate tax rate/area assignment functionality is enabled for the company of first building. If so, it retrieves alternate tax rate/area using the first building, company of the building, and tenant setup. The detail grid does not include the company of the building, so the system retrieves the information from the Lease Master Detail table (F15017). If the company of the building is set up to use the alternate tax rate/area assignment functionality, then the system retrieves the alternate tax rate/area base on the setup for the company of the building, building, and tenant. If you change the value for the building, the system retrieves the company associated with the building to determine if the alternate tax rate/area assignment functionality is enabled. If it is enabled, then the system retrieves the alternate tax rate/area again. If you manually change the value for the tax rate/area, the system does not retrieve the alternate tax rate/area. |
Sales Overage Information (P15013) |
The Taxes tab of the Sales Overage Information form is not modified to use the alternate tax rate/area assignment functionality. Instead, the Tax Rate/Area field on the Lease Defaults tab is used to show the alternate tax rate/area if the functionality is enabled. The system determines the tax rate/area based on the lease specified in the header area. Each building in the grid must have the same tax rate/area or the system issues a warning message. If you manually override the value in the Tax Rate/Area field on the Taxes tab, then the system does not validate that the lines in the grid have the same tax rate/area value. |
Escalation Information (P15016) |
The system checks if the alternate tax rate/area assignment functionality is enabled for the company of first building. If so, it retrieves alternate tax rate/area using the first building, company of the building, and tenant setup. If you change the building on the grid and do not manually change the tax rate/area, then the system retrieves the alternate tax rate/area for the new building based on the company of the building, the building, and the tenant. |
Recurring Billing Revisions (P1502) |
In the header area of the Recurring Billing Revisions form, the system checks if the alternate tax rate/area assignment functionality is enabled for the company of first building. If so, it retrieves alternate tax rate/area using the first building, company of the building, and tenant setup. The detail grid does not include the company of the building, so the system retrieves the information from the Lease Master Detail table (F15017). In the grid area, the system uses the lessee to determine if the transaction if for an invoice or a voucher. If it is an invoice, the system retrieves the alternate tax rate/area set up for sales transactions. If it is a voucher, then the system retrieves the alternate tax rate/area that is set up for purchase transactions. If you change the Building on the grid, the system retrieves the alternate tax rate/area of the new building, using the values for the building, company of the building and the tenant in the header area to determine which alternate tax rate/area to retrieve. If you change the value for the building, the system retrieves the company associated with the building to determine if the alternate tax rate/area assignment functionality is enabled. If it is enabled, then the system retrieves the alternate tax rate/area again. If you manually change the value for the tax rate/area, the system does not retrieve the alternate tax rate/area. |
Manual Billing (P1511) |
When you add or modify transactions, the system uses the company building value to check if the alternate tax rate/area assignment functionality is enabled. If the functionality is enabled for the company, the system retrieves the alternate tax rate/area. When you add a manual billing, the system completes the lease number on the header of the Manual Billing Revisions form and retrieves the alternate tax rate/area if the functionality is enabled for the company (for instance, of the first building). The system retrieves the alternate tax rate/area for a purchase or a sales transaction depending on whether you indicate that the transaction is a sale or purchase. When you completes a grid line, the system retrieves the alternate tax rate/area if one is set up. If you change the Building on the grid, the system retrieves the alternate tax rate/area of the new building, using the values for the building, company of the building and the tenant in the header area to determine which alternate tax rate/area to retrieve. If you manually change the value for the tax rate/area, the system does not update the Tax Rate/Area field when you make changes in other the fields. |
Lease Global Update (R15117) |
The Lease Global Update program completes validations differently for companies for which you set up the alternate tax rate/area assignment functionality and those that do not use the alternate tax rate/area assignment functionality. You can set processing options to specify which tables to update. The following list includes the processing options for tables that include the tax rate/area for a transaction:
You can also set processing options on the Field Updates tab to specify the building and tenant. If the alternate tax rate/area assignment functionality is enabled, the system uses the building and tenant specified in the processing options to retrieve the alternate tax rate/area and compare it to the values currently in the tax rate/area field of the tables you select to update. If they are equal, then the report updates the specified tables. The system issues an error message if the tax rate/area values do not match. If you leave the Building or Tenant processing options blank, the system updates the tax rate/area values in the tables for all building or tenants. |