Cash Forecasting Programs for Multiple Currencies
This chapter provides an overview of multicurrency cash forecasting.
Cash Forecasting Programs for Multiple Currencies
The JD Edwards EnterpriseOne General Accounting cash forecasting programs can help your company project, or forecast, future cash requirements and effectively manage the cash accounts. With cash forecasting, you can analyze one or more bank accounts and forecast the cash position daily or periodically based on a date horizon.
The initial setup and routine processing for cash forecasting is the same regardless of whether you work in a multicurrency environment, with these exceptions:
To work with cash forecast amounts in a currency other than the domestic currency, you can assign a revaluation currency to cash type rules.
You enter the currency code in the Node Currency field on the Revise Cash Type Rule form.
When you run the Refresh Cash Forecast Data program (R00522), the system summarizes open amounts in the F09522 table by bank account, due date, and base (domestic) currency.
If more than one bank account, due date, and base currency meets the selection criteria for a cash type, the program produces multiple summarized amounts.
If you assigned a node (revaluation) currency to a cash type rule, the Refresh Cash Forecast Data program uses the summarized base currency amounts in the F09522 table, retrieves the exchange rate from the F0015 table, and calculates amounts in the node currency. It stores both the base currency and revaluated node amounts in the F09522 table. If an exchange rate does not exist, the Refresh Cash Forecast program sends a message to the work center and summarizes detail records for the cash type in the base currency instead of the node currency. The refresh program does this so that a missing exchange rate does not cause the process to completely fail. When this occurs, the base currency is substituted for the node currency and the base currency amount and node currency amount in the F09522 table are the same.
Before you view cash forecast amounts using the Cash Forecast Analysis program (P09522), you specify the currency code of the display (revaluation) currency and a based on date in the processing options.
The Cash Forecast Analysis program extracts the resulting node amounts from the F09522 table. An exchange rate must exist between the display currency and the node or base currency that is stored in the F09522 table to calculate correct cash forecast amounts. If an exchange rate does not exist, the Cash Forecast Analysis program issues a hard error that identifies the currency relationship that is missing the exchange rate. You must enter the exchange rate using the Currency Exchange Rates program (P0015A) and then click Find again on the Cash Forecast Analysis form to view the cash forecast amounts. You do not have to refresh the data in the F09522 table again.
If the display currency is the same as the node or base currency for a cash type rule, the performance on the Cash Forecast Analysis interactive form is improved because the program does not have to revalue amounts again.
If you do not specify a display currency in the processing option, the system displays amounts in the currency for company 00000.
See Also