August 3, 2012

PeopleSoft HCM Fundamentals: Multi-Currency

PeopleSoft supports multi-currency environment. 
Currency from different countries tracks the currency amount up to 3 decimal positions based on their country rules.
For example; India & USA tracks the currency amount to 2 decimal places whereas Bahraini Dinar & Kuwaiti Dinar tracks the currency amount to 3 decimal places.



Country specific Currency information will be stored in the Currency code PS_CURRENCY_CD_TBL table. 

When the amount field is displayed on online pages, the currency amount will always be displayed to 3 decimal places. This is because field decimal position is set as 3.
We can override this property to display the amount to number of decimal positions based on the Currency code.

In order to display the amount based on the currency code, In the record field property of the amount information, under ‘Use’ tab, select the currency code field from the particular record in the ‘Currency Control Field’ drop down box. This helps the page to display the amount information to correct decimal places based on the currency code.

Note: If there is a scenario to display the number field to ‘n’ decimal places irrespective of the Currency code, then we can use ‘DecimalPosition’ Field property to display the number to ‘n’ decimal places in the page.
RecName.FieldName.DecimalPosition = 2;

No comments:

Post a Comment