Problem Note 52575: Pink cells that are displayed in a SAS® Financial Management report might be due to an invalid exchange rate
 |  |  |  |
Pink cells might be displayed in a SAS Financial Management data-entry form or report if the exchange rate is invalid. This problem might occur in the following scenario.
- The exchange rate set was defined using multiple dimension types. To confirm this, in SAS Financial Management Studio, right-click on the exchange rate set and select Properties. Select Dimension Types to view the dimension types that are used in this exchange rate.
- The CURRENCY_COMPLEX_EXCH_RATE SAS table only defines dimension member IDs for a subset of the dimension types. This data is loaded into the Solutions data mart.
To correct this problem, delete the incorrect rates in the Exchange Rates in SAS Financial Management Studio.
Note that this problem only occurs when you are importing complex exchange rates (for example, Historic and Derived).
Follow these steps to prevent this problem from occurring:
- Make a backup copy of the cycdrate.sas and cycxrate.sas programs in the installation-drive:\Program Files\SASHome\SASFoundation\9.4\finance\sasmacro directory.
- Download the SN052575.zip file and extract the contents to the installation-drive:\Program Files\SASHome\SASFoundation\9.4\finance\sasmacro directory.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 |
| Microsoft Windows 8 Enterprise 32-bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 for x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows XP Professional | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Windows Vista | 5.3_M1 | 9.3 TS1M2 | ||||
| Windows Vista for x64 | 5.3_M1 | 9.3 TS1M2 | ||||
| 64-bit Enabled AIX | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| HP-UX IPF | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Solaris for x64 | 5.3_M1 | 5.5 | 9.3 TS1M2 | 9.4 TS1M2 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-03-18 11:56:57 |
| Date Created: | 2014-03-17 13:21:00 |