Wrong Decimal Notation in PO

How to Change the decimal format in purchase order?
My client is facing a formatting problem in total fields.
If the value is 100000.25 it is printing this as 10.000,25  
Client want it to be printed as 10,000.25.
Any default setting of decimal in SU01 does not help this.

Solution:

Just go to T.code SU3

There you can find Defaults tab,

Under the Decimal Notation, you can change the format,

Save.

After that you need to logged off  and logged in again to SAP after you have changed the decimal settings.   A change in user settings does not immediately effect the transactions.
 

Check tcode for country decimal notation:  Tcode OY01 

Tcode for country decimal notation

Notes for Abap developer:

The decimal format can also be set by the SET COUNTRY command which uses the values stored in table T005X for the country.

Check to see what the settings are for the country of the Customer/Vendor you are processing.

For example:

Use SET COUNTRY cntry. 

Refer this code.

DATA: dat       TYPE sy-datum VALUE '20120127',
            num       TYPE p  LENGTH 8 DECIMALS 2 VALUE '1234567.89',
        t005x_wa  TYPE t005x,
        t005x_tab TYPE SORTED TABLE OF t005x
                WITH NON-UNIQUE KEY xdezp datfm.

SELECT *
       FROM t005x
       INTO TABLE t005x_tab.

DELETE ADJACENT DUPLICATES FROM t005x_tab.

LOOP AT t005x_tab INTO t005x_wa.

  SET COUNTRY t005x_wa-land.

  WRITE: / num, dat.

ENDLOOP.

---

Call a routine in the sapscript or smartform passing the field name and value.

For example

PERFORM GET_UNIT_PRICE IN PROGRAM ZSROINVOICE
   USING     &KOMVD-KWERT(T)&
   USING     &FKLMG(T)&
CHANGING  &PRICE_P_U&

ENDPERFORM

FORM get_unit_price    TABLES i_intpar STRUCTURE itcsy
                                                      i_outpar STRUCTURE itcsy.

DATA : ws_price     TYPE p DECIMALS 2,
              ws_fkimg     TYPE p DECIMALS 2,
              ws_netwr     TYPE p DECIMALS 2,
              ws_c_netwr(20)                ,
              ws_c_fkimg(20)                ,
              ws_c_price(15)                .

REFRESH i_outpar.

CLEAR i_outpar.

READ TABLE i_intpar WITH KEY name = 'KOMVD-KWERT'.

CHECK sy-subrc EQ 0.

    ws_c_netwr = i_intpar-value.

READ TABLE i_intpar WITH KEY name = 'FKLMG'.

CHECK sy-subrc EQ 0.

  ws_c_fkimg = i_intpar-value.

    TRANSLATE ws_c_netwr USING '. '.
    TRANSLATE ws_c_netwr USING ',.'.
    TRANSLATE ws_c_fkimg USING '. '.
    TRANSLATE ws_c_fkimg USING ',.'.

     CONDENSE  ws_c_netwr NO-GAPS.
     CONDENSE  ws_c_fkimg NO-GAPS.

MOVE: ws_c_fkimg TO ws_fkimg,
              ws_c_netwr TO ws_netwr.

IF NOT ws_fkimg IS INITIAL.

    ws_price = ( ws_netwr / ws_fkimg ).

ENDIF.

WRITE ws_price TO ws_c_price.

  i_outpar-name = 'PRICE_P_U'.
  i_outpar-value = ws_c_price.

APPEND i_outpar.

CLEAR i_outpar.

ENDFORM.     

*-- This routine is used calculate the unit price based on total amount and no of delivered pieces.

See also
Blocking The Purchase Order

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.