Currency display format problem in check printing.

[Former Member]

hi experts.

I had done script for check printing. i had used the structure REGUD ,REGUP.

Through Tcode <b>F-48</b> Functional People had entered amount as 550000.00, but in the structure <b>REGUD</b> all the fields (<b>Swnes, Swnet, Snett,Snets</b>) are storing as <b>550.000,00.</b>

(Chek the <b>comma</b>(,) and <b>dot</b>(.) positions.).

I had checked the user Profile-->Own data also but everything is ok... even in defaults i had given to decimal notation as <b>1,234,567.89</b>.

I dont know why in the output its not showing the correct value.

Please help.

I will reward points for every help.

Thanks.

[former_member196280]

Try to use this simple logic it will solve your problem.

write SWNES to CHAR right-justified.

REPLACE '.' WITH ',' INTO CHAR.

if char+13(1) = ','.

char+13(1) = '.'.

endif.

Reward points if useful.

Regards,

SaiRam

[former_member150733]

Try to logout and login again to the system and check again.

[Former Member]

Hi...,

After changing the user profile... u have to login again .. then only those will be applicable..

Once log out and login again..

if the problem still persists then it is with the country command...

Use this command in your script..

<b>

/: SET COUNTRY country_key</b>

Check the country key values in the table T005T table...

regards,

sai ramesh

Message was edited by:

Sai ramesh

[Pawan_Kesari]

In sapscript if your are printing any currency field then system automatically take currency value from field specified in dictionary. For example if you check table REGUD in se11, ref field for currency for field SWNET is specified as REGUH-WAERS.

So if you print field &REGUD-SWNET& in sapscript it will format it according to currency stored in field REGUH-WAERS at that time.

To change the formatting you need to change the value of REGUH-WAERS in this particular case.

[Former Member]

Hi,

Please note that in chq printing, format will be as per the format defined for the 'country' of the vendor. So please check that particular format & take corrective action as necesay.

I hope this helps,

Regards

Raju Chitale