SAP Knowledge Base Article - Public

1669826 - Multiple Decimal Places Needed for Maintaining Product Pricing in Purchase Orders

Symptom

You are creating new purchase order for Stock / Non-Stock items and it is necessary for you to maintain the multiple decimal places on product pricing as per the industry standards. Hence this leads to incorrect totals on your purchase orders.

For Example: This applies to price calculations between Quantity & Price. For high volume, low cost items, sometimes it's necessary to calculate the net value as multiple fractions. i. e Quantity 1000 * Price 0.0375 USD = 37.5 USD.

OR

You would like to enter price in which the euro amounts are displayed with more than 2 decimals.

When number of decimals exceeds the limit, error message 'Enter a value that matches the unit EUR and has a maximum of decimal places 2.' is raised.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Purchase Requests and Orders work center.
  2. Go to the Common Tasks section and select New Purchase Order.
  3. Fill the necessary details and pricing information's.
  4. Under the pricing information's put three decimal value digit. E. X: 0.0375 USD.
  5. System will round off the decimal places to two digits. 

Cause

This restriction of the decimal places comes from ISO 4217 which is standard for the rounding and available decimal for each currency.

https://en.wikipedia.org/wiki/ISO_4217

Resolution

The feature described will be available in a future release of SAP Business ByDesign. Until then you will have to maintain a price for a price unit of 10 each or 100 each in a list price or purchasing contract.
Alternatively you can create a quantity conversion on the product master with a unit of measure that corresponds to 10 each or 100 each. Then use this UoM on the purchase order.

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.

Alternatively you may check the Customer Influence Forum to submit an idea: https://influence.sap.com/sap/ino/#campaign/886

See Also

2250861 - Is it Possible to Change the Default Decimal Notation for Currencies?

Keywords

Increase decimals, more decimals, greater than 2 decimsls , KBA , AP-PRP , Purchase Request Processing , AP-SIP , Supplier Invoice Processing , AP-POP , Purchase Order Processing , How To

Product

SAP Business ByDesign all versions