How to show Amount without INR in PLD

[Former Member]

Dear All,

I have created one PLD. And in that PLD i am showing the amount for that i choose indian formatt.

When i run the PLD that time before amount it shows INR also.

Can anybody suggest me how to remove INR from amount while showing the amount.

Thanks and Regards

Swapnil Patil

Edited by: SWAPNIL PATIL on Mar 19, 2009 8:35 AM

[Former Member · Accepted solution]

Hi,

If I understood you correctly please try below steps.

For eg:

you want to get only the price amount in sales order:

1 Add a database field under repetitive area as:

+Table:Sales Order-Rows

+Column:Unit Price

2 Add a formula field_A under repetitive area:

DecimalLeft(Field_024)

Add a formula field_B under repetitive area

DecimalRight(Field_024)

+Concat field_A and field_B to get the price

++Hide the fields which you dont want to display by unticking visible

check box under general tab and make it as :

Left 0 Width 0

Height 0 Right 0

Regards,

Tulika Bhatt

[Former Member · Accepted solution]

Dear Freind,

Thnks for the reply. U sending me write answer but in this suppose amount is INR 115.86 and when i use DecimalLeft() that time it shows only amount 115. It is not showing amount after decimal. Means i want to show amount 115.86.

Can u plz suggest me how to do that ?

Thanks and Regards

Swapnil Patil

[gagan_thareja · Accepted solution]

Hi Swapnil,

Can you please refer to the NOTE 864686.

Regards,

Gagan Thareja

SAP Business One Forums Team

[Former Member · Accepted solution]

Please do the following to hide currency symbols in the PLD:

Case 1 (document is using variable, e.g. as in Invoice):

Save the System print template via Report Editor -> Save As.

In all the fields that display currency you can see under its object properties(doubleclick) that the data is pulled by means of a variable. What this variable does is select the numeric data and add the currency display.

Remove the Variable number and name.

Select the tab "Data".

Under the field File select the appropriate table (e.g. Invoice).

Under the field Field select the appropriate data field.

Now the print out will no longer contain the currency added to your amounts.

Case 2 (document is not using a variable, e.g. as in Ageing report):

The field in the System template that displays the amount with the currency should is set invisible and a new calculation field has to becreated.

In content/calculation tab, choose type "Formula", in Field 1 select the field that displays the value incl. the curr. symbol,and as Operation set "$Number".

Place the calculation field at the required position.

Make the original field behind it invisible.

[Former Member]

thnks

[Former Member]

just add new label with formula tag.....in formula (tonumber(that field no))

eg.

field_334 is yr colsum(..)

then in new label->formaula->edit formula->tonumber(field_334)

Thanks,

Kevin

[Former Member]

Hi Swapnil,

The suggestion given by sridharan in case 2 in nice .

U should follow it .

rgds,

Premraj

[Former Member]

HI,

U have to fetch database field inspite of system variable then inr will not come.

Rgds,

Premraj

[Former Member]

Hi Swapnil,

You have to put another foumula field as well with decimal right and concat left and right.

Its clear now?

Regards,

Tulika Bhatt