How to remove currency code on report

[Former Member]

Dear all,

On PLD report, I don't want to show currency code on amount field , for example :

USD 1,000 => I would like to show only 1,000

How can I do?

Thanks you.

Angnam

[VamcParimisetti · Accepted solution]

Hi angnam,

Just create a new formula filed and in the content tab(Properties window) insert the AMOUNT(required Field) then save and see the preview. it will displays only as 1000 instead of USD 1000.

Regards,

PV

[Former Member]

Hi Angnam,

Just create new field in PLD choose source type : database / select table : ORDR / Column : Document Total.

Thanks,

Srujal Patel