Error: Input must be in the format __.___.___.__~ when input nett price in PO

[Former Member]

Dear expert,

I am new in SAP world. I want to learn in MM module

I have problem when creating PO (ME21N). when I input nett price in decimal for example 2.2 EUR, there was an error 'Input must be in the format __.___.___.__~'. But when i changed the nett price value with 2 EUR, it seems okay.

I have already read some tips via google, and they said about using Tcode CUNI, but i still do not understand.

I hope someone can guide me what step by step should i run.

thx in advance before

[former_member213924 · Accepted solution]

Hi,

Go to System-> user profile -> own data under default tab change decimal notation.

[matsikun]

System>>User profile>>User Data

Or

SU3 -> Defaults -> Decimal Notation

Change the Decimal notation to: X 1,234,567.89 and save.

Make sure you sign out and log in to SAP to make the change effective.

Thank you,

Samaun

[JL23]

Please use SE16 and check table V_CURX

Do you see there an entry for EUR?

do you get the same problem for any other currency?

[Former Member]

Dear all experts,

i have tried to change decimal notation. here is results i got:

if i use X 1,234,567.89

in PO i enter nett price 2,2 -> Input must be in the format __.___.___.__~

in PO i enter nett price 2.2 -> Decimal places are not permitted

if i use  1.234.567,89

in PO i enter nett price 2,2 -> Decimal places are not permitted

in PO i enter nett price 2.2 -> Input must be in the format __.___.___.__~

if i use Y 1 234 567,89

in PO i enter nett price 2,2 -> Decimal places are not permitted

in PO i enter nett price 2.2 -> Enter a numeric value

what should i do? still confuse with this problem

regards,

ruben

[priyaranjan_gupta]

Hi Ruben,

After changing the default setting for decimal notation, you have to log off the system and login again..did you try that?

Thanks.

Priyaranjan

[JL23]

your personal settings will not effect this error,

the message tells you what is expected

a) it shows you a template how it input shuold be:  __.___.___.__~

look at the dots, there are only dots, which means it does not expect decimal entries

b) Decimal places are not permitted 

this confirms it as well, you must not enter decimals

The weird thing is that you say it is with EUR currency, as EUR has 2 decimals, I would expect such messages for Korean and Japan currency as they do not have decimals.

So I assume it has something to do with your decimal settings at the currency.

please check your settings made in SPRO > IMG > SAP Netviewer > General Setting > Set Countries > Define Countries in my SAPsystem

[Former Member]

Hi Priyaranjan Gupta,

Yes, i did that of course.. Any more ideas?

[Former Member]

Hi Jurgen, happy new year . . .

Unfortunately i don't understand with your explanation "The weird thing is that you say it is with EUR currency, as EUR has 2 decimals, I would expect such messages for Korean and Japan currency as they do not have decimals." because i live in southeast asia and do not know about EUR, Korean, and japan currency.

by the way, i have tried checking SPRO > IMG > SAP Netviewer > General Setting > Set Countries > Define Countries in my SAPsystem, but i still can't solve. I can give you printscreen settings i had if you need. More detail step explanation please if you don't mind, because i am really new in SAP world.

Thx in advance

[Former Member]

Please provide print-screen of your input with currency.

[Former Member]

Hi,

Goto Tcode: SU3 -> Defaults -> Decimal Notation

Change the Decimal notation to:  X 1,234,567.89 and save.

[Former Member]

Hi rajshree srivastava,

if i use X 1,234,567.89 i got this message:

in PO i enter nett price 2,2 -> Input must be in the format __.___.___.__~

in PO i enter nett price 2.2 -> Decimal places are not permitted

[Former Member]

Hi,

On SAP screan main Manu bar  System -->User-->Own data in that click defalts tab--> dacimal notificationcahnge

  Bettre to you maintain rounding profiles

[Former Member]

Dear Samir Rana, Priyaranjan Gupta, Veeraprathap kankanala

I still can't solve this problem. I have already tried change decimal notation. Maybe you can take a look the results i got (i have posted the results in this thread)

thx in advance

[priyaranjan_gupta]

How value will be accepted by amount field depends on default decimal notation maintain in default tab of SYSTEM->USER Profiile->Own data .

Change the default decimal notation and login again than try.

[Former Member]

Hi,

Try 2,2 and check if the system is accepting the value.

Regards

[Former Member]

Dear Thomas,

The system still is not accepting the value