to select, the beginning (From)
and ending (To)
project.Use this toolkit to update transaction currency amounts stored in the billing history tables to a new transaction currency. This toolkit was designed primarily for companies converting to the Euro; however, you can use it any time you change a project's transaction currency and you need the cumulative data shown in the new currency. The billing currency that you enter in this screen will be the currency to which the history tables will be converted. The toolkit will use the rate group entered in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) to find the correct conversion rate in the Exchange Rate tables. The functional currency stored in the billing history tables will be used as the basis to convert to the new transaction currency.
You must enter the new Billing Currency and Rate Group in the Other Info subtask of the Project Billing Info screen before running this toolkit. The application will process only projects whose billing currency in the Project Billing Info screen matches the one entered in this screen. If any records exist in the Edit Standard Bills screen (Projects » Billing » Edit Billings) for projects being processed, you should either post them or set them to unselected status before running this toolkit. If an unselected record is in the Edit Standard Bills screen when you run this toolkit, it will have to be recalculated
Use the drop-down list to select the currency to which you would like to convert. All currencies set up in the Maintain Currencies screen (Accounting » Multicurrency » Currencies) will be available in this drop-down list. The currency you select must be different from the currency in the billing history tables. If no difference exists, the system will display an error message. Only those projects that have this currency code assigned to them in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) will be available for processing. This is a required field.
Enter the conversion date you would like to use in this field. The system will use this date to determine which conversion rate should be selected in the Maintain Exchange Rates by Date screen (Accounting » Multicurrency » Exchange Rates). The default is the system date.
Select the projects you would like to process in this group box. Only those projects that have the same currency in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) and this screen will be available for processing.
Select this option to process all projects that meet the transaction currency criteria.
Select this option to process a range of projects as specified in the From and To fields in the Select Project group box.
Select this option to process a range of projects as specified in the From field in the Select Project group box.
After selecting the Range
or One option in
the Project Range group box, enter,
or use to select, the beginning (From)
and ending (To)
project.
Click this button to start the toolkit.
Click this button to exit this screen without running the toolkit.
The toolkit will convert BILLING_SUM, BILLING_DETL_HIST, and BILL_INVC_HDR_HS to the new transaction currency. The changes to the columns will be made based on the functional currency in the related column. For example, the BILLING_SUM table stores the functional currency amount in the BILLED_AMT column. The toolkit will use the amount in this column to restate the MU_BILLED_AMT in the BILLING_SUM table. The columns to be changed are shown by table:
The following columns will be updated in this table when this toolkit is executed:
MU_BILLED_AMT
MU_RTNGE_AMT
MU_OVRCST_CL_AMT
MU_ OVRFEE_CL _AMT
MU_ OVRTOT_CL _AMT
MU_SALES_TAX_AMT
The following columns will be updated in this table when this toolkit is executed:
MU_BILL_AMT
MU_PREV_BILLED_AMT
MU_BILL_RT_AMT_
MU_OVRCST_CL_AMT
MU_ OVRFEE_CL _AMT
MU_OVRTOT_CL_AMT
MU_RTNGE_AMT
MU_SALES_TAX_AMT
MU_UNIT_PRICE_AMT
The following columns will be updated in this table when this toolkit is executed:
MU_FND_VAL_AMT
MU_FND_VAL_FEE_AMT
MU_FND_VAL_CST_AMT
MU_CTR_VAL_AMT
MU_CTR_VAL_FEE_AMT
MU_CTR_VAL_CST_AMT
MUITD_BILLED_AMT
MUITD_OVRFEECL_AMT
MUITD_OVRCSTCL_AMT
MUITD_ OVRTOTCL _AMT
MUITD_RTNGE_AMT
S_CRNCY_CD
MU_INVC_AMT
MU_ RTNGE_AMT
MU_SALES_TAX_AMT
MU_OTH_CHG_AMT1
MU_OTH_CHG_AMT2
MU_OTH_CHG_AMT3
MU_OVRFEE_CL_AMT
MU_OVRCST_CL_AMT
MU_ OVRTOT_CL _AMT
MU_DISC_AMT
MUPROJ_LVL_INV_AMT
MUITD_SALES_TX_AMT