Skip to Content
avatar image
Former Member

SAP by Design maximum of 2 decimal places

When trying to create a List Price with more than 2 decimals places in SAP by Design, I receive this error. "Enter a value that matches the unit USD and has a maximum of 2 decimal places". Is it possible to use more than 2 decimal places in SAP? If so, how is this issue corrected?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Feb 15, 2014 at 07:05 AM

    The data type used for Price field is 'Amount' and it supports up to 6 decimal places. But this is limited to 2 display decimals for many currencies in the system.

    You can check the display decimal used for each currency in "Business Configuration --> Open Activity List --> Currencies". Unfortunately, the display decimal is not editable in this activity. Not sure about the reason. Also I am not sure if this is editable before go live.

    You can raise an "How to" incident in the system.

    Best regards,

    Hari

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 17, 2014 at 04:50 PM

    Kari,

    We've run into this requirement a few times.

    The working way to address this is to adjust your Pricing Quantity - so, for example:

    If you had a Product that you wanted to price at $12.3456 per 1 each, you would set it up as $1234.56 per 100 each

    This ends up calculating to an equivalent value, but allows entry of more detailed decimals places without encountering maximum decimal places limits.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15 at 01:59 PM

    Hello everyone,

    Can someone tell me if there is a way to do this for sourcing from purchasing contracts?

    I have created a purchasing contract with the item's target value set as £1,234.56 for 100kg. Based on this working solution, I would expect a Purchase Order for 1kg of this product to generate a price for £12.35 (rounded up from £12.345).

    However when I change the price unit to 1kg, the gross price does not change, it remains at £1234.56. I would appreciate your comments on a working solution for this scenario.

    Thanks in advance,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Anish,

    As discussed on chat, when you change the price unit to 1kg, the net value changes to 12.35 and not the gross price. Please mark this thread as answered.

    Best Regards,
    Arun

    Add comment
    10|10000 characters needed characters exceeded