Skip to Content
Author's profile photo Narayana N

Why Decimal Format in Purchase Order Print Preview Displays Incorrectly?

Hello SAP Practitioners,

Greetings for the day,

In my last project I’ve encountered an issue and I’ve noticed that many people are still finding difficulty in getting the exact answer for their question in SCN and Google as well. As I’ve identified the cause for the issue, thought of creating this document by intending it would help them to understand their issue and resolve the same.

Summary of the Issue:

When I click on print preview button for a particular purchase order, the currency format was displaying incorrectly but the other purchase orders were displaying accurately, as it is displayed in change/display mode of purchase order screen.

Example: For the purchase order 4500002417 I’ve entered amount as USD 1,000,000.00 and when I click on print preview it has displayed the same as in the purchase order change/display screen. But for the other purchase order 4500002416, I’ve entered amount as QAR 1,000,000.00 but when I click on print preview, it has displayed as 1.000.000,00. I wonder how come it is displaying differently from the change/display screen of the same purchase order! Decimal was getting separated by a ‘Comma’ (,) Instead of a ‘Dot’ (.).

Please find the below screen shots for your better understanding.

PO 4500002417.JPGPO 4500002416.JPG

From the functional point of view I’ve analyzed a lot to identify the cause for the issue but couldn’t succeed. Then I went Google’s help but I didn’t get a clear answer as I was seeing many responses were talking about only ‘Decimal Format Settings @ User Profile’ – SU3. Finally I took an ABAPer help to fix the issue as I did not find the right answer in Google.

Settings for Decimal Format in ‘User Profile’ (SU3): Before moving further I would like to make you clear that, decimal format which we are maintaining in ‘User Profilewouldn’t be having any impact on purchase order print preview, instead It would be having impact on only purchase order creation/change/display screen, so for the above issue, no need of checking the user profile-decimal format.

Cause for the Issue:

When I found the cause for the issue I came to know that, the actual system behavior is correct. You might ask me how the system is behaving correctly, when it is showing the decimals wrongly? The answer is, the currency format in the ‘PO Print Preview’ is derived with the combination of ‘Vendor’ & ‘Vendor Country’. Few countries are separating decimals with comma (,) and few are with period/dot (.).

Example: If we are raising a purchase order to a British Vendor, usually he reads his PO value in his local currency, so system would check the vendor & his country and based on that it would display the currency format in the print preview. As shown in the below table, the currency format for British vendor would be displayed like 1,234,567,890.00.

As per the above purchase order 4500002416, we are sending the PO to a German vendor, so his currency format is different than the other PO 4500002416, hence it is showing as 1.000.000,00 instead 1,000,000.00.

Note: Not all the countries in world are using the same decimal format, different countries officially designate different symbols for the decimal mark. Please see the below table as an example, how the decimal notations are different between the countries.

Excel 2.jpg.png

Please go through the below link to know more about the ‘Decimal Notation‘.

Decimal mark – Wikipedia, the free encyclopedia

Where can I see/maintain the currency format for the respective countries?

The standard SAP practice is, while implementing SAP, Finance Team and Business Team will have a discussion on maintaining the currency format for each countries. As it is having major impact on all the financial transaction, they will take a call at the time of implementation itself. Changing the currency format at the later stage is not advisable.

You can see the settings in OY01 as shown in the below screen shot.


How this functionality works only for the ‘PO Print Preview‘ not for the ‘PO Create/Change/Display Screen’?

As per the standard SAP, the purchase order forms contains a function called ‘Set Country’. This function will check the purchase order vendor and country of the vendor, then it goes to the table T005X (Countries – Decimal point and date format (SET COUNTRY)) –> pass the country name and gets the currency format for the country and updates the same in purchase order print preview.

This functionality works at the smart form program level not at the purchase order create/change/display program level, so we will not be facing any ‘Decimal Notation’ issue in the purchase order screen. PO screen works as we set the decimal notation in the user profile.

How to check whether my PO form has this function?

You can go to NACE settings find the smart form name–> and then go to smart form – Initialization tab–> search for term ‘set country’, if you find an entry as shown below, that means your PO form is calling this function and your decimal notation works based on this logic.

Smart Form 1.jpg


Clarified the cause of the issue to the business team and advised them to not to make any changes to the function as it working fine as per the standard practice. But based on the business requirement we have given them one more output type ‘ZNEU’, so that whenever they want to have a print with  country specific currency format they can use ‘NEU’ output type and whenever they want as per the normal currency format they can use ‘ZNEU’ output type.

In order to fulfill the customer requirement, we have created a new Z smart form, created ‘ZNEU’ output type and assigned the standard PO print program & Z-Smart Form in NACE settings–> and then maintained ‘Output-Condition Record for Purchase Order’ in MN04. Now whenever he clicks on print preview, he will get two output types, so that he can select whatever he wants.

Hope, I’ve clearly explained you the scenario to the best of my knowledge. Do let me know, if anything is not clear for u, so that I can explain in detail.

Thank you so much for reading the blog.


Narayana N

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mahesh Naik
      Mahesh Naik

      Good Document.

      Author's profile photo Mohan Ravi
      Mohan Ravi

      Very useful document.



      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Thank you Mahesh & Mohan 🙂


      Narayana N

      Author's profile photo Former Member
      Former Member

      Good Document... Thanks Mr.Narayana...



      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Thank you R Dhamotharan 🙂


      Narayana N

      Author's profile photo Former Member
      Former Member

      good document. keep it up.

      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Thank you Jay Jay 🙂

      Author's profile photo Binoy Vargis
      Binoy Vargis

      Good Document. it was really informative. Good narration. Thank you

      Author's profile photo Kavita S.
      Kavita S.

      Thank you for such a clear explanation.

      Author's profile photo Vick Patel
      Vick Patel

      Its really helpful..thanks for sharing...

      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Thank you Binoy Vargis, Kavita S, Vick Patel 🙂

      Author's profile photo Venkateswaran Krishnamurthy
      Venkateswaran Krishnamurthy

      Good document.  Thanks for the Efforts to make it available to all of us.



      Author's profile photo PRASOON AK

      Hi Narayana Nagaraju


          Good information and nicely presented. Thanks for sharing.



      Author's profile photo Mohan Ravi
      Mohan Ravi


      Thanks for your valuable time.

      Really nice document, keep posting.



      Author's profile photo kumar kumar
      kumar kumar

      Hi Nice Document.Thank u Regards Kumar

      Author's profile photo Ravikumar B
      Ravikumar B

      Hi Narayana,

      Good blog, Very good analysis on the problem and system behavior. Really helpful. 🙂

      Author's profile photo Akash Prekar
      Akash Prekar

      Wonderful. Helps a lot. I also faced the same thing and got to know this!



      Author's profile photo Former Member
      Former Member

      Very Clear.

      Author's profile photo Narayana N
      Narayana N
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Ver Nice and very Informative ..Thanks for sharing the Knowledge

      Author's profile photo B V Yadav
      B V Yadav

      Hi   Narayana Nagaraju,

      Thank you very much for sharing this document. I was also so confused why it is showing differently now it is clear.


      B V

      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Hi SATISH SAHOO & B V Yadav,

      Thank you for your comments.

      Best Regards,

      Narayana Nagaraju,

      Author's profile photo Sridhar Kumar Kommana
      Sridhar Kumar Kommana

      Wow... Good info.. thanks for sharing... 🙂

      Author's profile photo Narayana N
      Narayana N
      Blog Post Author

      Thank you Sridhar Kumar Kommana 🙂

      Author's profile photo Osvaldo Lopez
      Osvaldo Lopez

      Wow, this is a great doc. Thanks.

      I missed it, until I read it here: The specified item was not found. 🙂



      Author's profile photo Former Member
      Former Member

      Good stuff, it helps me a lot, thanks for sharing!

      Author's profile photo Arun Aravamudhan
      Arun Aravamudhan

      Nice document

      Author's profile photo Former Member
      Former Member

      It's very helpful. Thank you.

      Author's profile photo Santosh Mathew
      Santosh Mathew

      This one really helped. Thanks for taking pain to post such wonderful saves others time when in distress. Awesome work

      Author's profile photo Narayana Nagaraju
      Narayana Nagaraju
      Blog Post Author

      Thanks Santosh, its my pleasure 🙂