C Alternate Tax Rate/Area Assignment Functionality - Impacted Objects

This appendix contains the following topics:

C.1 Understanding Objects Impacted by the Alternate Tax Rate/Area Assignment Functionality

Many programs and reports that include or calculate taxes are impacted by the alternate tax rate/area assignment functionality. This appendix includes a brief description of programs impacted when you have set up companies to use the alternate tax rate/area assignment functionality.

See Section 3.8, "Setting Up Alternate Tax Rate/Area Assignment Functionality (Release 9.1 Update)".

C.2 Financial Management: Accounts Payable

You can set up the company, the supplier address number and the business unit to use the alternate tax rate/area assignment functionality. When you work with vouchers using one of these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the business unit and the supplier.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the business unit and supplier country codes.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • Voucher JE Redistribution (P042002)

  • Update Store and Forward Records (R0041Z1)

  • Store and Forward Voucher Batch (R04110Z2)

  • Batch Voucher Processor (R04110ZA)

  • Inbound AP Claim Program (R04110ZB)

  • Calculate Withholding (R04580)

  • Recycle Recurring Vouchers (R48101)

This table describes how programs in the JD Edwards EnterpriseOne Accounts Payable system use the alternate tax rate/area assignment functionality:

Program Comments
Standard Voucher Entry (P0411) This program enables you to copy, add, or change vouchers.

When you add a new voucher or modify an existing one, the system completes the header with default values. When you work in the grid area, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for the vouchers added or modified, based on the combination of supplier and business unit countries.

If the alternate tax rate/area assignment functionality is enabled, the system does not allow modifications to the business unit.

Multi Company - Single Supplier (P041016) You can use this program to enter a voucher using different companies.

The system completes the account number based on the supplier entered on the header area, and completes the company and business unit based on the account.

Note: The system does not update the Tax Rate/Area field if you manually make changes in the form header.

If you modify the account number on a record in the grid, the systems checks if the company and the business unit changed and if the alternate tax rate/area assignment functionality constant is enabled for the company. If it is, the system overrides the tax rate/area value with the applicable alternate tax rate/area according to the new information.

Multi Voucher - Single/Multiple Supplier (P041017) With this program, you can enter several vouchers, either for a single supplier or for multiple suppliers.

When you modify a voucher or you enter a new voucher by adding a line to the grid, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system retrieves the applicable alternate tax rate/area based on the combination of supplier and business unit countries.

You can also override the tax area directly in the header area or in the grid using this program.

Speed Status Change (P0411S) You can update an individual voucher or a group of vouchers using this program.

If the alternate tax rate/area assignment functionality is enabled for the company, you cannot change the business unit of the transaction. If the alternate tax rate/area assignment company constant is enabled, the system disables the Business Unit field. Otherwise, the Business Unit field is enabled and you can change its value.

When updating a group of vouchers, if you change the value of the business unit, the system also checks if the company of the selected document has the alternate tax rate/area assignment functionality enabled. If it is disabled, the system updates the transaction with the business unit you enter. If it is enabled, the system displays a message indicating that the business unit cannot be changed.

AP Speed Voucher Entry (P0411SV) When entering vouchers using this application, you enter the supplier and the company on the header.

When you work in the grid area, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for the new voucher based on the combination of supplier and business unit countries, and shows the applicable tax rate/area on the header.

This program retrieves the tax rate/area value from the supplier, but when the alternate tax rate/area assignment functionality constant is enabled, the system retrieves the applicable alternate tax rate/area overriding the information from the supplier, regardless if the changes are entered in the header area or in the grid.

Batch Voucher Revisions (P0411Z1) When adding or modifying a batch of vouchers using this application, you enter the supplier and the company on the header. The system uses this information to retrieve the business unit.

When you work in the grid area, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, you cannot modify the business unit and the system assigns the tax rate/area for the voucher added or modified based on the combination of supplier and business unit countries.

Inbound EDI Voucher Edit/Create (R47041) This program processes inbound EDI invoices without matching the voucher to a purchase order.

When the tax rate/area is blank, the report completes the tax rate/area with the customer tax rate/area. However, if the alternate tax rate/area assignment functionality is enabled, the system replaces the default tax rate/area and applies the appropriate alternate tax rate/area for the records created or modified.



See Also:

For voucher processing, see "Alternate Tax Rate/Area Assignment Functionality" and "Understanding the Edit/Create Voucher Program" in the JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide.

For batch voucher processing, see "Alternate Tax Rate/Area Assignment Functionality" in the JD Edwards EnterpriseOne Applications Accounts Payable Implementation Guide.


C.3 Financial Management: Accounts Receivable

You can set up the company, the customer and the business unit to use the alternate tax rate/area assignment functionality when the company, the customer and the business unit involved in a transaction are in the European Union. When you work with invoices using these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the business unit and the customer.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the business unit and customer country codes.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • A/R Finance Charge Journal (R03B22)

  • AR/AP Netting (P03B455)

  • Convert Unapplied Receipts to Credit Memos (R03B620)

  • Credit Reimbursement (R03B610)

  • Draft Entry (P03B602)

  • Invoice Batch Purge (R03B11Z1P)

  • Invoice Batch Revisions (R03B11Z1A)

  • Recycle Recurring Invoices (R03B8101)

  • Speed Invoice Entry (P03B11SI)

  • Standard Receipt Entry (P03B102)

This table describes how programs in the JD Edwards EnterpriseOne Accounts Receivable system use the alternate tax rate/area assignment functionality:

Program Comments
Speed Status Change (P03B114) You can update an individual invoice or a group of invoices using this program.

You can use the Global option to update multiple records. If you change the business unit, the system checks if the company of the selected documents have the alternate tax rate/area assignment functionality enabled. If it is disabled, the system updates the transaction with the business unit that you enter. If it is enabled, the system displays a message indicating that the business unit cannot be changed.

Batch Invoice Revisions (P03B11Z1) When adding or modifying a batch of invoices using this application, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for each invoice added or modified based on the combination of customer and business unit countries.
Batch Invoice Processor (R03B11Z1A) When processing a batch of invoices using this application, the system checks the Tax Area and Explanation Code processing options setup and whether the alternate tax rate/area assignment functionality is enabled for the company. After checking these variables, the tax rate/area that the system applies for each record is assigned according to the following rules:
  • If the processing option is defined, the system retrieves the default values for the tax rate/area and the tax explanation code from the processing options.

  • If the processing option is left blank and set to use the default tax rate/area and the alternate tax rate/area assignment functionality is disabled, the system retrieves the applicable tax rate/area based on the business unit and the customer countries.

  • If the processing option is left blank and set to use the default tax rate/area, and the alternate tax rate/area assignment functionality is enabled, the system retrieves the alternate tax rate/area.

A/R Finance Charge Journal (R03B22) You can set the Tax Rate/Area processing option for this program to enable the program to include tax information on the invoice records generated.

When working with this report, the system checks the processing option setup and also if the alternate tax rate/area assignment functionality is enabled for the company. After checking these variables, the system determines the tax rate/area according to the following rules:

  • If the Tax Rate/Area processing option is defined, the system retrieves the default values for the tax rate/area and the tax explanation code from the processing options.

  • If the processing options are blank and the alternate tax rate/area assignment functionality is disabled, the system retrieves the applicable tax rate/area based on the business unit and the customer countries.

  • If the PO is left blank and set to use the default tax area, and the alternate tax rate/area assignment functionality is enabled, the system retrieves the alternate tax rate/area.

Standard Invoice Entry (P03B11) When you add a new invoice or modify an existing one using this program, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for the invoices added or modified based on the combination of customer and business unit countries.
Speed Invoice Entry (P03B11SI) When you add a new invoice using this program, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for the invoice entered based on the combination of customer and business unit countries.

C.4 Financial Management: Expense Management

The programs in the JD Edwards EnterpriseOne Expense Management do not retrieve an alternate tax rate/area. Instead, programs in this system use the tax rate/areas from the Expense Report Detail table (F20112) or from the employee record.

C.5 Service Management

You can set up these entities to work with the alternate tax rate/area assignment functionality in the JD Edwards Service Management system:

  • Company (from Business Unit).

  • Business unit (as origin of transaction).

  • Site address number (as destination of the sale).

When you work with service transactions or modify entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the origin and destination entities.

  • Verifies that the country codes are valid.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the origin and destination country codes.

This table describes how programs in the JD Edwards EnterpriseOne Service Management system use the alternate tax rate/area assignment functionality:

Program Comments
Service Contract Revision (P1721) When adding, copying or modifying a service contract using this application, the system checks the setup information regarding the tax rate/area and also if the alternate tax rate/area assignment functionality is enabled for the company. If it is enabled and applicable based on the information entered either on the header or in the detailed grid for the entities used in this system. These entities are the business unit, the site number and the company (the system populates the company field based on the business unit).

If you change the tax rate/area value on the header area, the system recalculates the applicable tax for all the lines in the detail area.

When you work on the grid, the system checks if the alternate tax rate/area assignment functionality is enabled for the company.

When copying a service contract, if the functionality is enabled and the processing options are set to use the default tax rate/area, the system assigns the alternate tax rate/area if applicable, based on the business unit on header and the site address number.

Note: You can only change the business unit on header if the contract is not billed.

Service Contract Renewal (R1730)

and Service Contract Detail Renewal (R1735)

You can run the Service Contract Renewal program (R1730) to identify the contracts that require contract renewal and to generate those contracts. Use the Service Contract Detail Renewal (R1735) program to review and adjust detail line information for a contract.

Based on the business unit, the system checks the alternate tax rate/area assignment company constant for the corresponding company. If the functionality is enabled, the system retrieves the alternate tax rate/area based on the business unit and site country information. Otherwise, the system retrieves the tax rate/area from the default site setup.

When using the Copy Defaults processing options for these programs, the following rules apply:

  • For changes in the header area:

    • If the functionality is enabled for the company of the new business unit, the system retrieves the alternate tax area according to the new business unit and site on the header area.

    • If the functionality is disabled for the company of the new business unit, the system retrieves the tax rate/area for the site.

  • For changes in the detail area, for each contract line:

    The system uses the original Business Unit to determine the tax rate/area. The business unit is not updated. This means that:

    • If the functionality is enabled for the company of the original business unit, the system retrieves the alternate tax rate/area using the company according to the original business unit in the record and the site country.

    • If the functionality is disabled for the company of the original business unit, the system retrieves the site tax rate/area.

Work Order Revisions (P17714) You can set up these entities to work with the alternate tax rate/area assignment functionality in the JD Edwards EnterpriseOne Applications Capital Asset Management system:
  • Company from business unit

  • Business unit as origin of the transaction

  • Site address number as destination of the transaction

The system retrieves a default tax rate/area for only work orders with a document type of 05 (service).

You can set a processing option for the Work Orders Revision program (P17714) to specify whether the system verifies that the case number on the work order exists in the Case Master table (F1755). If you enable this option, the program uses the default tax rate/area from the case when the case number is completed. If you leave the processing option blank, then the system retrieves the tax rate/area from the customer or site of the service work order.

If you enable the alternate tax rate/area assignment functionality, the system retrieves values for fields on the Order Detail tab as described in this list:

  • Equipment: When you enter a value in the equipment field, the system retrieves the alternate tax rate area if the values for the site and the tax rate/area are blank. If the customer, site and, tax rate/area are blank, the system completes the site using the asset customer value. In this case the system will retrieve the alternate tax/rate area using the customer of the asset. The system will overwrite the tax rate/area will the alternate tax rate/area.

  • Site Number: If the Customer field is blank, the system retrieves the customer and tax rate/area based on the value in the Site field. If the Customer field is not blank, then the system retrieves the alternate tax rate/area based on the Site.

  • Customer number: If the Site is blank, the copies retrieve the site based on the customer ad default tax rate/area. If the Site is not blank, then the system does not change the tax rate/area.

  • Case Number: If the Site is blank, the system retrieves the alternate tax rate/area.

Work Order Revisions (P17714) (continued) On the Accounting tab, the system retrieves the alternate tax rate/area is you change the business unit or the subsidiary.

If you change the customer on the Update Customer Information form, the system retrieves the alternate tax/rate area if no errors occur.

If you enable Customer Self Service by setting the processing option in the Work with Work Order program (P48201) to do so, the system retrieves the alternate tax rate/area if the company is set up to use the alternate tax rate/area.

S&WM Work Order Workfile Generation (R1775) When you run the S&WM Work Order Workfile Generation program, the program retrieves the alternate tax/rate area for accounts payable entries if the company is set up to enable the alternate tax rate/area assignment functionality and the supplier and business unit are set up for the functionality.

If you set the Header Business Unit processing option in the Contract Revisions program (P1721) to use the original contract, the system retrieves the tax rate/area from the original contract header and detail lines. If you set the Header Business Unit processing option to use the site of the customer, then the system retrieves the value for the header business unit from the processing option value, retrieves the company from the business unit value, and retrieves the site from the contract header. For detail lines, the process retrieves the company from the business unit in the processing option, and retrieves the business unit and site from the detail line. For the header and detail information, the system uses the retrieved values to determine the tax rate/area to use.

Manage Service Orders (P90CD002) When you add a new service order or modify an existing one using this program, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system assigns the tax rate/area for the orders added or modified, based on the combination of site number and business unit countries.

C.6 CRM - Case Management

You can set up the company, the responsible business unit and the site address number to use the alternate tax rate/area assignment functionality.

When you work with cases to track the resolution of problems using these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the Business Unit and the Site.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the Business Unit/Site country codes.

This section describes how programs in the JD Edwards EnterpriseOne Case Management system use the alternate tax rate/area assignment functionality:

  • You use the Case Entry form (P90CG501) to add a case

  • You use Speed Case Entry (P90CG601) to add a case with the minimum amount of detail.

  • You use the Case Entry Add Mode (P90CG504) to modify a case.


    Note:

    The program Case Entry Add Mode (P90CG504) is affected by the alternate tax rate/area assignment functionality, but is not modified.

When you work with these programs, the system checks the tax rate/area information in the Billing Information form. You can change the tax area from this form on the Pricing Info tab and you can change the entity Responsible Business Unit on the Customer Info tab.

When you use one of these programs to create or modify a case, the system checks if the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system retrieves the tax rate/area for the cases added or modified, based on the combination of business unit and site countries.

If you receive an error message, you can cancel the action and manually change the tax rate/area. If you manually change the tax rate/area, then the system does not overwrite the value you enter.

C.7 Contract Billing

You can set up the contract billing system to use the alternate tax rate/area assignment functionality by using the following entities:

  • Company of business unit

  • Project/Job (origin of the transaction)

  • Customer (destination of transaction)

When you enter a contract, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the origin and destination sites.

  • Verifies that the country codes are valid.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the origin and destination country codes.

This table describes how programs in the JD Edwards EnterpriseOne Contract Billing system use the alternate tax rate/area assignment functionality:

Program Comments
Contract Master Revisions (P5201) When you enter or modify contracts with this program, if the alternate tax rate/area assignment functionality is enabled, the system will retrieve the applicable alternate tax rate/area for the company in the contract considering the Project/Job and Customer countries.
Contract Billing Line Details (P5202) This program allows you to see in detail the contract entered. You can change the Project/Job field from this application.

If the alternate tax rate/area assignment functionality is enabled, the system will retrieve the applicable alternate tax rate/area for the records generated considering the project and customer countries.


C.8 Service Billing

You can set up the company, the business unit, and customer to use the alternate tax rate/area assignment functionality. When you add or modify a sales order with one of these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the Business Unit and the Customer.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the Business Unit/Customer country codes.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • Voucher generation (R48122)

  • Service Billing Invoice Generation (P48121)

  • Create AR Entries (R48199)

  • Journal Edit Register (R48300)

  • Invoice Generation (R48121)

  • Billing Vouchers AP/GL (R48197)

This table describes how programs in the JD Edwards EnterpriseOne Service Billing system use the alternate tax rate/area assignment functionality:

Program Comments
WorkFile Revisions (P4812) If the alternate tax rate/area assignment functionality is enabled, these features apply:
  • The system retrieves and uses the applicable alternate tax rate/area when adding new records to the Billing Workfile.

  • The system retrieves the applicable alternate tax rate/area when updating records.

    You can change the Business Unit entity by modifying the account number for any transaction that uses the Job/Amount Revision form (all transactions except for Services and Claims transactions). This form displays the tax area but does not allow editing it.

  • The system retrieves the applicable alternate tax rate/area when using the Transaction Re-extend functionality to update records in the Billing Detail Workfile table (F4812).

G/L Transaction Selection (P48124) You can access the G/L Transaction Selection form using the row menu Select in the Workfile Revisions form. This functionality allows users to insert records from Account Ledger into the Billing Workfile.

If the alternate tax rate/area assignment functionality is enabled, the system will retrieve the applicable alternate tax rate/area based on the business unit.

Billing Workfile Generation (R48120) This functionality allows users to insert records from Account Ledger into the Billing Detail Workfile.

If the alternate tax rate/area assignment functionality is enabled, the system will retrieve the applicable alternate tax rate/area for the records generated.

Billing Detail Transaction Re Extension (R481202) You can access the Billing Detail Transaction Re Extension program using the row menu Trans. Re-extend in the Billing Workfile Generation form.

This functionality allows users to update records in the Billing Detail Workfile table (F4812).

If the alternate tax rate/area assignment functionality is enabled, the system will retrieve the applicable alternate tax rate/area based for the records being updated.

Re Burdening Workfile Generation (R52G41) This functionality allows users to insert re burdening records into the Billing Detail Workfile.

If the alternate tax rate/area assignment functionality is enabled, the system replaces the default tax rate/area and applies the appropriate alternate tax rate/area for the inserted records.


C.9 Grower Management

You can set up the company, branch/plant, and supplier entities to use the alternate tax rate/area assignment functionality. When you add or modify records in the JD Edwards EnterpriseOne Grower Management system with one of these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the branch/plant and supplier entities.

  • Retrieves the tax rate/area from the alternate tax rate/area assignment setup based on the company, branch/plant, and supplier country codes.

(Release 9.1 Update) Some programs are affected by the alternate tax rate/area assignment functionality. Programs that are affected either display the tax amounts or include other amounts that include the tax amount.Affected programs are:

  • Grower Harvest and Weigh Tag Receipt (P40G30)

  • Final Settlement (P40G310A)

  • Proceed Payments (P40G95)

  • Price Review (P40G200)

  • Assessments/Donations Subform (P40G30SF)

  • Settlement by Contract (P40G310)

  • View Weigh Tags (P40G33)

  • Final Settlement Statement (R40G400)

This table describes the programs in which you can use the alternate tax rate/area assignment functionality in the JD Edwards EnterpriseOne Grower Management system.

Program Comments
Advance Voucher (P40G100)

Final Settlement (P40G300)

The Apply Tax processing option controls whether the system applies the supplier's tax explanation code and tax rate to the invoice amount when generating vouchers. If the processing option is set to apply tax, the alternate tax rate/area assignment functionality is enabled for the company, and no errors in the alternate tax rate/area assignment setup exists, then the system retrieves the alternate tax rate/area. If the alternate tax rate/area assignment set for the company is set to show a warning or not to show errors, then the system retrieves the tax rate/area from supplier. If no tax rate/area is set up for the supplier, then the system retrieves the tax rate/area associated with the business unit.

C.10 Homebuilder Management

You can set up these entities to work with the alternate tax rate/area assignment functionality in the JD Edwards EnterpriseOne Homebuilder Management

  • Company

  • Lot Number / Community (Entity 1)

  • Subcontractor / Supplier (Entity 2)

When you work with transactions for which the entities involved have the functionality enabled, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for entities 1 and 2.

  • Retrieves the tax rate/area for the transaction from the alternate tax rate/area assignment setup based on entities 1 and 2.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • Option Master Maintenance (P44H401)

  • Base House Cost by Plan (R44H6003)

  • Option Cost Analysis by Community (R44H6004)

  • Simulated Take Off List (R44H6005)

  • Option Cost Analysis by Option (R44H6006)

  • Lot Start Workfile Generation File (R44H700)

  • Sales Management (P44H500)

This table lists the programs in the JD Edwards EnterpriseOne Homebuilder Management system that use the alternate tax rate/area assignment functionality.

Program Comments
Work with Bids (P44H601) In the Bids Header Revisions form, the fields Subcontractor and Bid Job Number are entities 1 and 2. If the alternate tax rate/area assignment functionality is enabled, if you change the Subcontractor or Bid Job, the system clears the Tax Rate/Area field. Then, when you click OK, the system assigns the tax rate/area code. The system also copies the new tax rate/area to all detail lines. When you copy records, the system copies original bid tax rate/area.
Material Item Pricing (P44H603) On the Item Price Revisions form, the Community/Phase and Supplier are the entities affected by the alternate tax rate/area functionality. When the functionality is enabled, the system retrieves the alternate tax rate/area based on the company, community, and supplier setup.
Homebuilder Purchase Order (P44H703) On the After Start Purchasing Maintenance form, the Lot and Supplier are entities 1 and 2. If you modify one of these fields, the system retrieves the alternate tax rate/area if the functionality is enabled for the company and entities, unless you have manually entered a tax rate/area. When you add lines in the detail area, the system assigns the tax rate/area from the header.

The Lot Start Workfile Revisions form, the system retrieves the alternate tax rate/area assignment if the company, lot, and supplier are set up to use the functionality.

Supplier on the Fly (P44H704) If you enable the alternate tax rate/area assignment functionality, when you work with Takeoff records (Start Lot record type is T) and leave the Tax Rate/Area field blank for the item/price, the process retrieves the alternate tax rate/area assignment.

For bids, when the supplier is assigned and the Recalculate Cost flag is enabled, the system copies the tax rate/area from the existing bid. If the Recalculate Cost flag is not enabled or a bid is not found for the assigned supplier, the system copies the tax rate/area from the TBD bid. In this case, if the alternate tax rate/area assignment functionality is enabled, the system compares the copied tax rate/area with the one tax alternate rate/area that would be used by default and displays a new error message if they are different.

Bid Copy (R44H601C) When you run the Bid Copy program, the system populates the Bid Header (F44H601) and Bid Details (F44H611) tables. When you specify a bid job number for which the company and entities are set up to use the alternate tax rate/area assignment functionality, the system retrieves the alternate tax rate/area and writes it to the tables when the entities are set up in the 00/EC UDC table and no errors occur.
Item Price Copy (R44H603C) The Item Price Copy program updates the Material Item Pricing table (F44H603). When you enable the alternate tax rate/area assignment functionality for the From or To companies, and complete the Community and Supplier processing options with entities that are set up for the alternate tax rate/area assignment functionality, the system retrieves the alternate tax rate/area. The system retrieves the alternate tax rate/area when:
  • You enter a value in the Community processing option for a community that is set up to use the alternate tax rate/area assignment functionality; the Supplier processing option is blank or includes a supplier who is set up to use the alternate tax rate/area assignment functionality; the Company To is enabled to use the alternate tax rate/area assignment functionality.

  • You enter a value in the Supplier processing option for a supplier that is set up to use the alternate tax rate/area assignment functionality; the Community processing option is blank or includes a Community that is set up to use the alternate tax rate/area assignment functionality; and the Company From or Transaction Company is set up to use the alternate tax rate/area assignment functionality.


C.11 Procurement Management

You can set up the company, the branch/plant of the company, the ship-to, and supplier entities to use the alternate tax rate/area assignment functionality. When you add or modify a purchase order with one of these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company of the branch/plant.

  • Verifies that the VAT registration number (Tax ID) exists for the Ship To and Supplier entities.

  • Retrieves the purchase order tax rate/area from the alternate tax rate/area assignment setup based on the Branch/Plant, Ship To, and Supplier country codes.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • PO Generator (P43011)

  • Purchase Order Generator (P43032)

  • Quote Order Release (P43360)

  • Suggested Reorder Stock Items (P4371)

  • Requisition Expeditor (P43E060)

  • Voucher Match Automation Driver (R4304010)

  • Automation UBE for Automation Rule 01 (R4304016)

  • Inbound Batch Purchase Orders (R4311Z1)

  • Batch Requisition Consolidation (R43E0600)

This table describes how programs in the JD Edwards EnterpriseOne Procurement Management system use the alternate tax rate/area assignment functionality:

Program Comments
Purchase Order (P4310) On the Order Header form, the system:
  • Retrieves the alternate tax rate/area when the business unit that you enter in the Branch/Plant field corresponds to a company for which you have set up the alternate tax rate/area assignment functionality, and the ship-to and supplier specified are also set up to use the functionality. If the company of the branch/plant is not set up to use the alternate tax rate/area assignment functionality, then the system retrieves the tax rate/areas according to the value you set in the Default Tax/Rate Area processing option.

  • Updates the value in the Tax Rate/Area field if you change the Supplier or Ship To values. If you leave the Ship To field blank and then click OK, the system retrieves the ship to value from the branch/plant setup.

  • Recalculates the tax rate/area if you modify the Supplier or the Ship To fields after you manually change the Tax Rate/Area field.

    Does not update the Tax Rate/Area field if you manually change the Tax Rate/Area value after changing the Supplier or Ship To fields.

On the Order Detail form, the system:

  • Retrieves the alternate tax/rate area specified in the header, if you do not enter a tax rate/area for a detail line.

  • Changes the value in the Tax Rate/Area to blank when you change the branch/plant and the new value is associated with a different company. The system then retrieves the appropriate new tax rate/area for the changed value. The system also changes the tax rate/area to blank and retrieves the appropriate new value when you change the Ship To field.

  • Does not update the Tax Rate/Area field for changes in the Branch/Plant or Ship To fields if you manually change the Tax Rate/Area value.

Purchase Order (P4310) (continued) When you copy a purchase order and have set the Copy Header to Detail processing option to 1, the system shows changes to the Branch/Plant, Ship To, and Supplier header fields if you make changes, and retrieves the alternate tax rate/area if the company of the branch/plant, the ship-to address, and the supplier are set up to do so.

When you update header information to the detail, the system retrieves the appropriate tax rate/area if you copy to the detail line only the Ship To field. If you copy both the Ship To and Tax Rate/Area fields, then the system copies the existing values and does not change the tax rate/area.

Purchase Order Workbench (P43101) On the Purchase Order Workbench form, the system:
  • Retrieves the alternate tax rate/area when the business unit that you enter in the Branch/Plant field corresponds to a company for which you have set up the alternate tax rate/area assignment functionality, and the ship-to and supplier specified are also set up to use the functionality. If the company of the branch/plant is not set up to use the alternate tax rate/area assignment functionality, then the system retrieves the default value.

  • Updates the value in the Tax Rate/Area field if you change the Ship To value. If you leave the Ship To field blank and then click OK, the system retrieves the ship to value from the branch/plant setup.

  • Does not update the Tax Rate/Area field for changes in the Ship To field if you manually change the Tax Rate/Area value.

Note that in this application, you cannot change the supplier.

Blanket Order Release (P43060) On the Order Release form, if you change the values in the Branch/Plant, Ship To, or Supplier fields and the company of the branch/plant is set up to use the alternate tax rate/area assignment functionality, the system retrieves the alternate tax rate/area. If the entities are not set up for the functionality, then the system retrieves the default value.
Voucher Match (P4314) On the Voucher Match form, the system retrieves the alternate tax rate/area when you complete the Supplier and Branch/Plant fields and the supplier and branch plant are set up to use the alternate tax rate/area assignment functionality.

The system completes the Tax Rate/Area of the Line Defaults with the alternate tax rate/area if it is enabled. If the functionality is not enabled, then the system uses the tax rate/area associated with the supplier. The system uses the line default value when you enter additional lines. If no default value exists in the Line Defaults and the line that you enter requires a tax rate/area, the system uses the tax rate/area of the previous line.

When you match receipts on the Receipt to Match or Order to Match forms, the system retrieves the tax rate/area from the original lines.

Stocked Item Reorder Point Batch Purchase Order Generator (R437002) This program retrieves the alternate tax rate/area if the company is set up to use the alternate tax rate/area assignment functionality.

C.12 Project and Government Contract Accounting

You can work with the Project and Government Contract Revisions program (P52G01M) to enter and edit contracts for government projects.

When you change the project/job or customer for a contract, or when you add or change an invoice for a contract when the company of the project is set up to use the alternate tax rate/area assignment functionality:

  • If the project number is blank, the system retrieves the tax rate/area associated with the customer.

  • If the project number is not blank, the system retrieves the alternate tax rate/area.

If you manually change the value for the tax rate/area for a contract or invoice, then the system does not update the tax rate/area when you update fields that affect the tax rate/area.

If the alternate tax rate/area assignment functionality is not enabled for the company of the contract and invoice, then the system retrieves the tax rate/area associated with the customer.

When you add or change a funding level, you cannot change the company. If the alternate tax rate/area assignment functionality is enabled for the company, the system retrieves the alternate tax rate/area. If the alternate tax rate/area assignment functionality is not enabled for the company, then the system retrieves the tax rate/area associated with the customer. If you manually change the value for the tax rate/area, then the system does not update the tax rate/area when you update fields that affect the tax rate/area.

C.13 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:

  • 2. F15012B - Expense Participation Master

  • 3. F15013B - Sales Overage Master

  • 6. F15016B - Tenant Escalation Master

  • 7. F1502B - Recurring Billing Master

  • 9. F1511B - Tenant/Lease Billing Detail

  • 10. F1511HB - Tenant Billing Detail History

  • 17. F03B11 - Account Receivable Ledger

  • 18. F0411 - Accounts Payable Ledger

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.


C.14 Sales Order Management

You can set up the company, the branch/plant, and ship-to entities to use the alternate tax rate/area assignment functionality. When you add or modify a sales order with one of these entities, the system:

  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the Branch/Plant and Ship To entities.

  • Retrieves the sales order tax rate/area from the alternate tax rate/area assignment setup based on the Branch/Plant and Ship To country codes.

Some programs are affected by the alternate tax rate/area assignment functionality, but are not modified. Those programs are:

  • Recurring Orders (P4004Z)

  • Sales Blanket Order Release (P420111)

  • Self Service - Sales Order Inquiry (P4210SS)

  • Print Invoices (R42565)

  • Sales Update (R42800)

  • Generate Rebate Claims (R42770)

  • EDI Inbound Purchase Order Chance (R47131)

  • EDI Inbound Purchase Order Edit/Create (R47011)

  • EDI Request for Quote Edit/Create (R47091)

  • Recurring Orders Edit and Creation (R40211Z)

  • Create Intercompany Sales Order (R4210IC)

  • Inbound EDI P.O. Change Inquiry (P47130)

  • Inbound EDI Request for Quote Inquiry and Create (P47091)

  • EDI Inbound Order Inquiry (P47010)

This table describes how programs in the JD Edwards EnterpriseOne Sales Order Processing system use the alternate tax rate/area assignment functionality:

Program Comments
Sales Order Entry (P4210) If the alternate tax rate/area assignment functionality is enabled, these features apply:
  • In the Sales Order Header, the system completes the Tax Area/Code field with the alternate tax rate/area when you click OK if you did not manually enter a value.

    If you change the value in the Branch/Plant or Ship To fields in the Sales Order Headers the system changes the value in the Tax Area/Code field to blank.

    When you work with a detail line, the system retrieves the alternate tax rate/area for the Ship To address and branch/plant when you add or copy a detail line. If you do not change the Ship To address or branch/plant, the system uses the tax rate/area from the sales order header when you add a detail line. The system uses the tax rate/area of the line that you copy when you copy a detail line.

  • If at least one company is set up to use the alternate tax rate/area assignment functionality, then the system includes the Branch/Plant field on the Sale Order Entry – Additional Information form. If you change the value in the Branch/Plant or Ship To fields, then the system updates the Tax Rate/Area field. If you manually change the Tax Rate/Area field, the system uses the value that you enter and does not update it if you change the Branch/Plant or Ship To fields.

  • When you copy header to detail information, the system copies the Ship To and Tax Rate/Area if the Ship to field is selected and the alternate tax rate/area assignment functionality is enabled. If you select the Tax Rate/Area to copy and do not select the Ship To field, the system copies the Tax Rate/Area. If you select only the Ship To field to copy and do not select the Tax Rate/Area, the system updates the Ship To information only when the alternate tax rate/area assignment functionality is not enabled.

Sales Order Workbench (P42101) If the alternate tax rate/area assignment functionality is enabled, these features apply:
  • In the Order Header Revisions form, the system assigns the alternate tax rate/area according to the values of the Branch/Plant, Ship To and the Company defined by the Branch/Plant. If you manually change the tax rate/area, the system does not assign or update the tax rate/area.

  • When you work with a detail line, the system retrieves the alternate tax rate/area for the Ship To address and branch/plant when you add or copy a detail line. If you do not change the Ship To address or the branch/plant, the system uses the tax rate/area from the sales order header when you add a detail line. The system uses the tax rate/area of the line that you copy when you copy a detail line.

  • When you copy header to detail information, the system copies the Ship To and Tax Rate/Area if the Ship to field is selected and the alternate tax rate/area assignment functionality is enabled. If you select the Tax Rate/Area to copy and do not select the Ship To field, the system copies the Tax Rate/Area from the header. If you select only the Ship To field to copy and do not select the Tax Rate/Area, the system updates the Tax Rate/Area of the line with the alternate tax rate/area if the functionality is enabled.

Manual Fulfillment (P4277701/05) If the alternate tax rate/area assignment functionality is enabled for the Company and you change u the Branch/Plant on the grid or by using the Change Branch Plant button, the process recalculates the tax.

If the tax rate/area changes and the order has taxed unit prices enabled, the system recalculates the tax based on the new tax rate/area.

Ship and Debit Claims (P4576) This program uses the alternate tax rate/area assignment functionality if the Apply Tax to Voucher processing options is set to 1 and the item for the selected document is taxable.

If the alternate tax rate/area assignment functionality is enabled for the Company, the documents to be generated will use the alternate tax rate/area assignment for the Branch/Plant and Supplier.


C.15 Transportation Management

You can set up the company, the branch/plant, and carrier entities to use the alternate tax rate/area assignment functionality.

This table lists the programs in the JD Edwards EnterpriseOne Transportation Management system that use the alternate tax rate/area assignment functionality.

Program Comments
Shipment Confirmation (P4205) When you run the Shipment Confirmation program and modify the ship-to or branch/plant value, the system checks whether the alternate tax rate/area assignment functionality is enabled for the entities. If the functionality is enabled, the system:
  • Checks whether the alternate tax rate/area assignment functionality is enabled for the company.

  • Verifies that the VAT registration number (Tax ID) exists for the Branch/Plant and Ship To entities.

  • Retrieves the sales order tax rate/area from the alternate tax rate/area assignment setup based on the Branch/Plant and Ship To country codes.

The Shipment Confirmation form includes a field for the tax rate area. If you modify a record for which the alternate tax rate/area assignment functionality is active, the system updates the tax rate/area. The system also recalculates the taxed unit price if the tax rate/area changes.

Shipment/Load Charges Revision (P4945) If the alternate tax rate/area assignment functionality is enabled, the system retrieves the tax rate/area using this hierarchy:
  1. Route tax rate/area

  2. Alternate tax rate/area

  3. Carrier

The entities used by the alternate tax/rate area assignment functionality are:

  • Company for the A/P Cost Center

  • County 1, as specified in the A/P Cost Center processing option. If you leave the processing option blank, then the system uses the value from F4215.MCU or F4215.NMCU.

  • Country 2 (carrier number)

Freight Update and Report (R4981) The alternate tax rate/area assignment functionality is used for only payable freight. The billable freight process does not use the alternate tax rate/area assignment functionality.

If the alternate tax rate/area assignment functionality is enabled, the system retrieves the tax rate/area using this hierarchy:

  1. Route tax rate/area

  2. Alternate tax rate/area

  3. Carrier

The entities used by the alternate tax/rate area assignment functionality are:

  • Company for the A/P Cost Center

  • County 1, as specified in the A/P Cost Center processing option. If you leave the processing option blank, then the system uses the value from F4215.MCU or F4215.NMCU.

  • Country 2 (carrier number)


C.16 Work Orders

You can set up the company, the site, or both the company and site to use the alternate tax rate/area assignment functionality. You can also use the alternate tax rate/area assignment functionality for work orders in the JD Edwards EnterpriseOne Capital Asset Management system.

Program Comments
Work Order Mass Update (R48714) When you run the Work Order Mass Update program, the system checks whether the alternate tax rate/area assignment functionality is enabled for the company. If the functionality is enabled, the system:
  • Retrieves the alternate tax rate/area for the business unit and site countries when the countries are set up in the 00/EC UDC table and no errors exist.

  • Retrieves the tax rate/area from the F4008 table when the business unit and site countries are not set up in the 00/EC UDC table.

  • Skips the work order if there is an error.



See Also:

"Alternate Tax Rate/Area Assignment Functionality in Work Order Mass Updates" in the JD Edwards EnterpriseOne Applications Work Orders Implementation Guide.