Example: Billing Rate and Markup Table Currency Processing
The markup table that the system selects when you run the Workfile Generation (R48120) and Workfile Re-extension (R481202) programs is determined by the mode that you set up in these programs, as well as by the key fields of the billing rate and markup table:
Service Billing Constants (P48091).
G/L Offset and Retainage Table (P48128) (for Service Billing).
Contract Master Revisions (P5201) (for Contract Billing).
Because Currency is a key field, they system uses it to search for a match between the cost transaction and the billing rate and markup table. This process is illustrated in this example.
Business unit 1234 belongs to company 00062 with a currency code of BEF.
Customer number 3333 is set up with a currency of FRF.
Customer number 3333 is properly attached to business unit 1234 as the owner.
A transaction was posted to the billable account 1234.1350.02200 for 300 BEF.
This list describes the setup of billing rate and markup table 1:
Generation Type: 1 - Invoice
Key Type: 5 - Customer
Table Key: 3333
Currency Code: FRF
Date Range: January 01, 2005 to December 31, 2005
Object Account Range: 1340 to 1399
Markup Percentage: 150
This list describes the setup of billing rate and markup table 2:
Generation Type: 1 - Invoice
Key Type: 6 - Job
Table Key: 1234
Currency Code: BEF
Date Range: January 01, 2005 to December 31, 2005
Object Account Range: 1340 to 1399
Markup Percentage: 150
When the Multi-Currency Conversion option on the General Accounting Constants form has a value of N and currency codes are not entered, table 1 is used as the markup because the currency code is not part of the search key. Therefore, key type 5 is found first in the hierarchical ordering of the remaining major keys.
When the Multi-Currency Conversion option on the General Accounting Constants form has a value of Y or Z and the system constants are set to foreign mode, then the Workfile Generation program calculates the billable amount of the transaction using table 1, which is set up in the foreign, or customer, currency.
When the system constants are set to domestic mode, the Workfile Generation program calculates the billable amount of the transaction using table 2, which is set up in the domestic, or company, currency.
For Service Billing, when the currency for the table does not match the fixed currency that is defined by the system constants, or the currency mode is overridden in G/L Offset and Retainage Table program, the system uses the default markup percentage that you set up in the constants.
For Contract Billing, when the currency for the table does not match the fixed currency that you set up in the system constants or in the Contract Master Revisions program, the system uses the default markup percentage that you set up in the constants.
When the Multi-Currency Conversion option on the General Accounting Constants form has a value of N, the Currency Code field does not appear on the Billing Rate / Markup Revisions form. Any tables that you add will have blank values in the Currency Code field. If you subsequently change the Multi-Currency Conversion option to a value of Y or Z and enter a transaction that has a valid currency code attached to it, the Workfile Generation program will not find a valid match to a billing rate and markup table with a blank value.
The opposite is also true. When you create a billing rate and markup table with a valid currency code while the Multi-Currency Conversion option is Y or Z and then you change the option to N before entering transactions, the Transaction Currency field is blank and the markup tables are not blank. Again, the system will not find a match. For this reason, you should not alternate Multi-Currency Conversion values.