topic Re: Amount displayed incorrectly in SAPScript in Application Development and Automation Discussions

Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 10:47:45 GMT

Hi All,

We are facing a strange issue in our production environment. The total amount in the FI invoice layout which was expected to display as 50 471,20 is displayed as 504,71 in the output .

I checked in debug mode and the calculation is done correctly. I could also see that in debug mode the amount output from the layout is 50 471,20

. But in the output it appears as 504,71. When we tried to replicate the scenario in test environment, the amount is displayed correctly as 50 471,20 .

I am not able to figure out the cause.We are having this issue only in production environment.

If anybody came across similiar scenario or have any thoughts on this, please share with us.

Many Thanks !

Achana

Re: Amount displayed incorrectly in SAPScript

former_member201275 — Fri, 20 Sep 2013 10:56:29 GMT

Go to SU01, under 'Defaults' tab and check what you have there for Decimal Notation for the user that is running the program.

Re: Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 11:10:21 GMT

Hi Glen,

Even i am facing the same issue in production while i try to display the invoice with my user. But in test system i am not facing the issue. The decimal notation is maintained as 1.234.567,89 in both production and test system.

Thanks,

Archana

Re: Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 11:17:10 GMT

Hi,

The value is rounding. if you do not use any rounding option,check with functional and basis configuration to respective person.

Regards,

Venkat.

Re: Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 11:28:49 GMT

Hi Venkat,

The values are not rounding, rather they apear as if they are divided by 100. Amount 50 471,20 is displayed as 504,71 .

Regards,

Archana.

Re: Amount displayed incorrectly in SAPScript

RaymondGiuseppi — Fri, 20 Sep 2013 11:36:01 GMT

Check and compare in both systems those parameters which can influence the issue

User definition : decimal options (defaults table) and language.
Currency definitions : number of decimals
Customer definitions : language.

Of course insure your form uses correctly the currency code, user options and output language, else results will appear incoherent.

Regards,

Raymond

Re: Amount displayed incorrectly in SAPScript

hiriyappa_myageri — Fri, 20 Sep 2013 11:38:00 GMT

Hi Archana,

Check the data type of field in invoice output.

May be the output field of type I.

Thanks and Regards,

Hiriyappa

Re: Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 11:38:14 GMT

Hi Archana,

Have you checked whether enough space is there are not to display the value.If space is not there

it wont display properly.

Regards.

Ashok P

Re: Amount displayed incorrectly in SAPScript

Former Member — Fri, 20 Sep 2013 11:42:10 GMT

Are u facing this issue for any particular currency or for amount in any currency?

Re: Amount displayed incorrectly in SAPScript

former_member201275 — Fri, 20 Sep 2013 12:05:37 GMT

Might be a silly question, but have you checked that the Sapscript you are using has been transported all the way through to Production?

Maybe compare the 2, in particular for the window where this is happening, and the subsequent numeric options.

Re: Amount displayed incorrectly in SAPScript

Former Member — Mon, 23 Sep 2013 10:54:05 GMT

Hi Archana,

I think not enough space in layout for particular field or may be configuration problem in production system.

Better to check user level settings.

Regards,

Venkat.

Re: Amount displayed incorrectly in SAPScript

Former Member — Mon, 23 Sep 2013 11:19:53 GMT

HI,

can share the screenshot of your sapscript code.

Regards

Tejas