This chapter contains the following topics:
This section discusses considerations for:
Setting Up company options in JD Edwards EnterpriseOne Human Capital Management.
Setting Up JD Edwards EnterpriseOne General Accounting Constants.
Setting Up Currency Exchange Rates.
Setting Up UDC 48/MT (markup generation type).
Setting Up the Time Entry MBF Processing Options (P050002A).
Setting Up a billing rate and markup table.
Setting Up employee payroll transactions.
To enable multicurrency time accounting, you must complete these fields for the default company 00000 in the Company Options program (P05001C):
Enter Y in this field.
Enter T (for Time Accounting) in this field.
These settings ensure that the system updates the Employee Transaction History table (F0618).
To enable multicurrency time accounting, you must complete these fields in the General Accounting Constants program (P0000):
Enter either Y (use multicurrency account multiplier) or Z (use multicurrency account divisor).
Select this check box.
Enter 2 (flex-create intercompany settlements without a hub).
You must set up currency exchange rates between your company's base currency and the currencies of your customers and suppliers.
Verify that the generation type that you use to retrieve billing rates from the Billing Rate / Markup Table program (P48096) has a value of P (payroll recharge rate).
|
Note: You can define a value other than P (payroll recharge rate). If you use another value, verify that the value that you use is specified as the generation type for the markup rules in the Billing Rate / Markup Table program and that this value is specified in the Generation Type Payroll processing option in the Time Entry MBF Processing Options program (P050002A). |
Complete the Recharge tab in the processing options for a version of the Time Entry MBF Processing Options program (P050002A):
Enter 1 to enable multicurrency functionality.
Enter 1 to specify the recharge business unit currency or enter 0 to use the home business unit currency from the Employee Master Information table (F060116).
This processing option enables you to determine whether the billing rate or the foreign billing rate is considered the base rate and, therefore, enables you to determine which rate will be converted. Depending on your selection, certain multicurrency fields on the timecard are enabled. When you select 1 to designate using the currency of the recharge business unit as the fixed currency, the only multicurrency timecard field that is enabled is the Foreign Billing Rate field. When you leave this option blank (default), then the currency of the home business unit of the employee is considered the fixed currency, and the only multicurrency timecard field enabled to you is the Billing Rate field.
For example, suppose that the billing rate for an American employee who works in a Canadian company can be stated in either USD or CAD. If the billing rate is stated in USD, then this rate is converted into CAD to determine the foreign billing rate. In this scenario, the Business Unit Currency for Base Amount processing option should be set to 0 to use the home business unit currency from the Employee Master Information table as the fixed or base currency. If the foreign billing rate is stated in CAD, then this rate is converted into USD to determine the billing rate. In this scenario, the Business Unit Currency for Base Amount processing option should be set to 1 to use the recharge business unit currency as the fixed or base currency.
If the employee home business unit is 9, which is under USD Company 00001, the billing rate and markup table must be defined for USD currency.
If the recharge business unit is Business Unit 77 (for labor expenses) in a company that uses Canadian currency, you must define the billing rate and markup table for CAD currency.
Enter 1 to use the Billing Rate / Mark up Table (F48096) to retrieve rates.
Enter P (recharge rate).
Enter 1 to use the employee cost rate.
Enter ZJDE0001.
Enter 1 to use dynamic account creation. This processing option is optional.
The dynamic account creation process creates a valid account when you enter a timecard that includes an account number that is inactive in the system. However, the account number must exist in the model business unit. Dynamic account creation does not create records in the billing rate and markup table.
You can use either of these approaches to establish billing rates in billing rate and markup tables:
Rate override.
Markup amount or percentage.
To create a billing rate override, you define a specific billing rate that is higher than the normal employee rate. To define a cost markup, you enter a percentage value that the system adds to the normal rate.
Complete this information in the header:
Enter P (recharge rate).
Enter 6 (job or business unit), or any other valid key type.
Enter the recharge business unit, or any other valid table key.
Complete this information in the detail area:
Object From and Object Thru.
Markup Amount, Markup Percent, or Markup Rate Override, according to your business needs.
|
Note: Although you can access the Component Table program (P4860) from the Billing Rate/Markup table program (P48096), multicurrency time accounting does not use the Component Table program. |
Set up this employee payroll information for each selected employee:
Enter 2 (payroll and recharge processing) or 3 (recharge processing only) in the Record Type field.
|
Note: Setting this option in the employee record is optional. Instead, you can enter 2 for payroll and recharge processing or 3 for recharge processing only in the Record Type field during timecard entry. |
Add a distribution rate or verify that a rate exists on the record.
This section provides considerations for time entry for multicurrency time accounting.
Keep these considerations in mind when you enter multicurrency timecards:
In the processing options for Enter Time by Individual (P051121) or Speed Time Entry (P051121) program, enter the version that you set up for the Time Entry MBF Processing Options program (P050002A) in the Time Entry Version processing option on the Time Entry tab.
On the Speed Time Entry Revisions form, complete these required fields:
Date
Batch
To complete a recharge timecard, complete these fields:
Employee Number
Pay
Hours
Account Number
If you are uncertain about the account number, select Markup Table from the Form menu, enter P in the Gen Type (generation type) column of the QBE line, and click Find to locate accounts that are set up for recharge entries.
Work Date
Record Type
If you entered a record type of 2 for the employee record, you do not need to change the Record Type field on the timecard. If you did not enter a record type of 2, override the record type on the timecard with a 2 (payroll and recharge processing). You can use only record types 2 and 3 for recharge transactions.
Review these fields in the detail area:
Foreign Bill Rate
The system generates the billing rate from the rate information that you established in the billing rate and markup table, based on how you set the processing options for the Time Entry MBF Processing Options program (P050002A), and on the currencies of the home business unit from the employee master record and the business unit of the charges.
Base Curr (base currency)
The base currency is the currency of the employee's home business unit.
Cur Cod (currency code)
The transaction currency is the currency of the job to which time is charged.
Bill Rate
The system generates the billing rate from the rate information that you established in the billing rate and markup table based on how you set the processing options for the Time Entry MBF Processing Options program, and on the currencies of the home business unit from the employee master record and the business unit of the charges.
|
Note: If the recharge rate or the bill rate is incorrect, review the effective account dates in the billing rate and markup table. If the date on the timecard is not within the effective dates, the system uses the default rate information from the employee master record. |
Verify the bill rate.
In this example, the conversion is from CAD to USD. The Company Constant Multi Currency Conversion option is set to use the divisor of 0.66666667. The calculation is 250.00 ÷ 0.6666667 = 375.00.
| Bill Rate | Foreign Bill Rate | Base Cur Code | Rech Cur Code |
|---|---|---|---|
| 375.000 | 250.000 | USD | CA |
These fields appear only when multicurrency time accounting is activated:
Bill Rate
Foreign Bill Rate
Base Currency Code
Recharge Currency Code
Note the batch number.
The system creates entries in the Employee Transaction Detail File table (F06116) when you click OK.
Select Timecard Post/History Update (G05BT11), Generate Timecard Journals.
Complete these steps:
Verify the GL date in the processing options.
Specify the timecard batch number in the Batch Number (F06116) option for the data selection.
Review the report and note the GL batch number.
Posting the batch updates the Employee Transaction History table (F0618) and the Account Ledger table (F0911) and clears the Employee Transaction Detail File table (F06116).
This section provides considerations for workfile generation for multicurrency time accounting.
Specify the GL batch number in the Batch Number (F0911) (ICU) option for the data selection.
Search for the GL date, company, customer, or document type. The system updates the Billing Detail Workfile table (F4812) as described in this table:
| Data Item | Description |
|---|---|
| AA | The job cost of the transactions in foreign or domestic currency. |
| U | The number of units that were entered in time entry. |
| PRIC | The unit rate. This should match the rate that was set up in the billing rate and markup generation type P table. |
| CRCD | The currency code of the job. |
| CRCF | The currency code of the customer. |
| CRCE | The currency code of the employee's home business unit. |
| AA2 | The job cost of the transactions in the customer's currency. |
| PRIF | The unit price in the customer's currency. |
| BRT and BRTI | The markup rates in the mode currency. |
The system calculates invoice and revenue amounts as with any other type of multicurrency transaction.
|
Note: The system creates only one T4 transaction even though two lines appear in the Account Ledger table (F0911) journal entry. |
This section provides examples of multicurrency timecard entries.
This example is based on this employee information:
Hourly Rate (PHRT, hourly wage on employee's Compensation form) = 25.00
Distribution Rate (PBRT, on employee's Payroll form) = 45.00
Home Business Unit = 9, attached to Company 00001, United States currency (USD)
This example is based on these exchange rates to Canadian currency (CAD) from USD:
| Dates | Multiplier | Divisor |
|---|---|---|
| January 01, 2005 | 2.0 | .50 |
| February 01, 2005 | 1.50 | .6666667 |
| March 03, 2005 | 1.50 | .6666667 |
This example is based on these exchange rates to USD from CAD:
| Dates | Multiplier | Divisor |
|---|---|---|
| April 01, 2005 | 1.50 | .6666667 |
| May 01, 2005 | 1.50 | .6666667 |
| June 01, 2005 | 1.1764706 | .85 |
This example is based on this setup:
Multi-Currency Conversion = Y (multiply)
Foreign × Exchange Rate = Domestic
Domestic ÷ Exchange Rate = Foreign
Labor Account = 77.1341
Business unit 77 belongs to company 00077, which is set up in the Company Names & Numbers program (P0010) to use currency code CAD.
These test cases are based on using the home business unit of the employee (USD).
Time Entry MBF Processing Options (P050002A), Recharge tab, processing option 2 (Business Unit Currency for Base Amount) = 0 (Home BU of Employee)
The billing rate and markup table is set up as described in this table:
| Gen Type | Key Type | Table Key | Curr Code | Begin Date | End Date | Markup Rate Override | Markup Percent | Markup Amount |
|---|---|---|---|---|---|---|---|---|
| P | 6 | 9 | USD | January 01, 2005 | January 31, 2005 | 250.00 | ||
| P | 6 | 9 | USD | February 01, 2005 | February 28, 2005 | 150.00 | ||
| P | 6 | 9 | USD | March 01, 2005 | March 31, 2005 | 100.00 |
This example shows a timecard with an override rate:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| January 01, 2005 | 1 | 1 | 77.1341 | 500.00 | USD | CAD | 250.00 | 9 |
(Bill Rate) = (Markup rate override from the billing rate and markup table) (Foreign Bill Rate) = (Domestic Bill Rate) × (Exchange Rate Multiplier [USD to CAD])250.00 × 2.0 = 500.00
|
Note: The value of the exchange rate multiplier change when the GL date has a different exchange rate from the date worked. |
This example shows a timecard with a markup percentage:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| February 01, 2005 | 1 | 1 | 77.1341 | 93.75 | USD | CAD | 62.50 | 9 |
(Bill Rate) = (Hourly Rate [PHRT]) + (Markup)25 + 150 percent Markup = 62.50(Foreign Bill Rate) = (Domestic Bill Rate) × (Exchange Rate Multiplier [USD to CAD])62.50 ×1.50 = 93.75
|
Note: The value of the exchange rate multiplier changes when the GL date has a different exchange rate than the date worked. |
This example shows a timecard with a markup amount:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| March 01, 2005 | 1 | 1 | 77.1341 | 187.50 | USD | CAD | 125.00 | 9 |
(Bill Rate) = (Hourly Rate [PHRT]) + (Markup Amount)25 + 10 = 125.00(Foreign Bill Rate) = (Domestic Bill Rate) × (Exchange Rate Multiplier [USD to CAD])125.00 × 1.50 = 187.50
|
Note: The value of the exchange rate multiplier changes when the GL date has a different exchange rate than the date worked. |
These test cases are based on using the Recharge business unit.
Time Entry MBF Processing Options (P050002A), Recharge tab, processing option 2 (Business Unit Currency for Base Amount) = 1 (Recharge Business Unit)
The billing rate and markup table is set up as described in this table:
| Gen Type | Key Type | Table Key | Curr Code | Begin Date | End Date | Markup Rate Override | Markup Percent | Markup Amount |
|---|---|---|---|---|---|---|---|---|
| P | 6 | 77 | CAD | April 01, 2005 | April 30, 2005 | 250.00 | ||
| P | 6 | 77 | CAD | May 01, 2005 | May 31, 2005 | 150.00 | ||
| P | 6 | 77 | CAD | June 01, 2005 | June 31, 2005 | 100.00 |
This example shows a timecard with an override rate:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| April 01, 2005 | 1 | 1 | 77.1341 | 250.00 | USD | CAD | 375.00 | 9 |
The Foreign Bill Rate is fixed, and the bill rate is calculated based on the Time Entry MBF Processing Options (P050002A) setting.
(Bill Rate) = (Foreign Bill Rate) × (Exchange Rate Multiplier [CAD to USD])250.00 × 1.50 = 375.00
|
Note: The value of the exchange rate multiplier changes when the GL date has a different exchange rate than the date worked. |
This example shows a timecard with a markup percentage:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| May 01, 2005 | 1 | 1 | 77.1341 | 62.50 | USD | CAD | 93.75 | 9 |
(Foreign Bill Rate) = (Hourly Rate [PHRT]) + (Markup)25 + 150 percent Markup = 62.50(Bill Rate) = (Foreign Bill Rate) × (Exchange Rate Multiplier [CAD to USD])62.50 × 1.50 = 93.75
|
Note: The value of the exchange rate multiplier changes when the GL date has a different exchange rate than the date worked. |
This example shows a timecard with a markup amount:
| Date | Pay | Hours | Account Number | Foreign Bill Rate | Base Curr | Curr Code | Bill Rate | Home BU |
|---|---|---|---|---|---|---|---|---|
| June 01, 2005 | 1 | 1 | 77.1341 | 125.00 | USD | CAD | 147.059 | 9 |
(Foreign Bill Rate) = (Hourly Rate [PHRT]) + (MarkupAmount)25 + 10 = 125.00(Bill Rate) = (Foreign Bill Rate) × (Exchange Rate Multiplier [CAD to USD])125.00 × 1.1764706 = 147.06
|
Note: The value of the exchange rate multiplier changes when the GL date has a different exchange rate than the date worked. |