{"id":22865,"date":"2021-07-30T13:30:59","date_gmt":"2021-07-30T13:30:59","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=22865"},"modified":"2021-07-30T13:36:00","modified_gmt":"2021-07-30T13:36:00","slug":"how-to-add-dynamic-currency-symbol-in-sage-x3-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/07\/30\/how-to-add-dynamic-currency-symbol-in-sage-x3-report\/","title":{"rendered":"How to add dynamic currency symbol in Sage X3 report"},"content":{"rendered":"\n

In Sage X3<\/a>, one of our client requested to add the currency symbol before the amount in the Purchase Order report according to the currency field in Purchase Order screen.<\/p>\n\n\n\n

New Stuff: <\/strong>H<\/a>ow to print a field once which is repeating in Sage X3 report<\/a><\/p>\n\n\n\n

\"Currency<\/a><\/center>\n
Currency Field<\/center><\/font>\n\n\n\n

Follow the below steps to achieve the above requirement :<\/p>\n\n\n\n

Step 1:<\/strong>
Place the number field you’re adding the currency symbol to on your report,
Right-click on the number field and select “Format Object”.<\/p>\n\n\n\n

\"Format<\/a><\/center>\n
Format Field<\/center><\/font>\n\n\n\n

Step 2:<\/strong>
Select the “Number” tab in the “Format Editor” window, if it’s not already selected.<\/p>\n\n\n\n

Step 3:<\/strong>
Click on the “Customize” button.<\/p>\n\n\n\n

\"Customize\"<\/a><\/center>\n
Customize<\/center><\/font>\n\n\n\n

Step 4:<\/strong>
Select the “Currency Symbol” tab in the popup window.<\/p>\n\n\n\n

\"Currency<\/a><\/center>\n
Currency Symbol<\/center><\/font>\n\n\n\n

Step 5:<\/strong>
Check the “Enable Currency Symbol” check box.<\/p>\n\n\n\n

There are two options as Fixed & Floating:<\/p>\n\n\n\n