Skip to Content
avatar image
Former Member

Rounding differences in pricing when billed in different UoM

I'm trying to find out does anyone has this rounding problem or know how to fix it when the sales quantity is in gallon and customer wants it bill in barrels. For example, a customer picks up 3 loads of heating oil from our terminal on the same day. Two of the loads are of the same quantity, said 6000 gallons. The third load is 6500 gallons. When we invoiced this customer in a different unit of measure (barrels), the unit price ($/bbl) for the first 2 loads is the same and the third is off by a penny even though it should be the same. It looks like SAP does not convert the quantity to enough decimal places to get more accurracy.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 04, 2007 at 10:44 PM

    Hi Bill,

    I have a similar issue, can u tell me about your issue, is it solved.

    waiting for your reply.

    Thanks & Regards,

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hai all,

      probably u can go to the invoice background and check if the rounding permitted option is checked r not..

      just in case i doubt

      spro-le-shipping-billind-billing doc someething like that i am not sure of the path and even u can round the wuantity in the material master creation

      hope this helps u

  • avatar image
    Former Member
    Jan 17, 2007 at 03:58 AM

    HiBill,

    Check whether the conversion UOM is correctly set in the material master.

    Ask ur MM guys so that the UOM does not afect while creating Sales order.

    Mohan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17, 2007 at 08:32 AM

    Bill, the rounding is managed at pricing and condition level.

    1) in the condition type in control data 2, there is a flag calle Qty Conversion that works as follows:

    Quantity conversion (from SAP help)

    This field controls the quantity conversion during determination of the

    condition basis.

    The field is only relevant for calculation rule 'C' (quantity-

    dependent.

    It is relevant if the sales quantity unit and the condition quantity

    unit are identical (and is different to the basis quantity unit).

    o Deactivated: The condition basis quantity is converted via the

    quantity to the stockkeeping unit. This means that the condition

    quantity is determined for planned factors. This means that a change

    to the conversion factors in the delivery or the order are not taken

    into account.

    Rounding errors can occur during quantity conversion.

    o Activated: If the sales quantity unit and the condition quantity

    unit are identical, the quantity of the document item is used, i.e.

    the actual quantity.

    2) the system manage the roundings up to 5 decimal places, so you can write your own routine to round the conditions.

    3) have a look to the unit conversion in the material master data.(MM03, basic data->additional data) Here is managed the accuracy of the conversion.

    reward points if helpful, pls.

    regards

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 17, 2007 at 04:32 PM

    In pricing procedure try using routine 16 or routine 17 in requirement. This should serve the purpose.

    Regards,

    Rajesh Banka

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2007 at 04:04 PM

    Check these OSS Notes that deal with this problem: 22963, 50794, 91767

    😉

    Add comment
    10|10000 characters needed characters exceeded