****** Displaying Quantity & Amount issue in smartforms **************

[Former Member]

From below PO output out of 6 line items only first line-item got displayed in correct format and remaining items displayed in wrong format it means comma (,) displayed instead of dot (.) and dot displayed instead of comma. Data is being displayed using field-symbols.

Material No Qty Unit Price Net Amount

RXLPX90XX0 2,000.000 5.00 / KG 10,000.00

MBXXLPXX1 100,000 7,00 / KG 700,00

RMBXXLPX2 100,000 7,00 / KG 700,00

RMBXXLPX3 100,000 7,00 / KG 700,00

RMBXXLPX4 100,000 7,00 / KG 700,00

Please help me How can I resolve this issue ?

[Former Member · Accepted solution]

Hi Achanta,

Please check the settings in the user defaults, In SU01 go to the DEFAULTS tab,there you can select the decimal notations.

And through smartforms you can control it with

SET COUNTRY 'IN' .The country specifica data is stored in T005X table.check out what is store against IN in your table and if neccessary change it according to your requirement

Reward if useful.

Cheers,

Deepthee Kasal

[Former Member]

Hi Deepthee Kasal

I got solution.

Before displaying Quantity and Amount field I created Program nodes and SET COUNTRY ' ' .

Thank you very much

[former_member195383]

Hi,

the format of displaying amounts depends on the settings of SU3.Go to

SU3>Defaults>Decimal Notation.There u can check the radio button,to get the proper format of printing amounts.Reward if useful.

Regards

Rudra

[Former Member]

Hi DVNS

It's displayed like below

without thousand separator

Material No Qty Unit Price Net Amount

RXLPX90XX0 2000.000 5.00 / KG 10000.00

MBXXLPXX1 100.000 7.00 / KG 700.00

RMBXXLPX2 100.000 7.00 / KG 700.00

RMBXXLPX3 100.000 7.00 / KG 700.00

RMBXXLPX4 100.000 7.00 / KG 700.00

But I want thousand separator

Please help me

Best regards

Satya

achantasatya@yahoo.com

achantasatya@hotmail.com

[Former Member]

Hi Satya,

Try like this for quantiy and unit price I think it will have numeric data type you check that first. If it is numeric type means move this field symbol value to numeric value (Declare a numeric WA) and try to display. I think u will get correct out put.

Regards,

DVNS

[Former Member]

Hi Satya,

Please try to move that field symbol to a character field and try to display.

Regards,

DVNS