Skip to Content
avatar image
Former Member

Subtotal in pricing....

Hi SD Gurus,

I have a scenario as under in Pricing..

StepNo Cond Type Unit Price Qty Condition value

1 pr00 88.95 215 19124.25

2 K007 - 3.85% -736.28

3 Subtotal(1+2) 85.53 18387.97

The client requirement was to pring the Unit Price of Step No 3 i.e 85.53 , Qty i.e. 215 as well as Condition Value i.e. 18387.97...

But when we manually calculate the condition value from the unit price i.e. (Unit Price * Qty) = Condition Value, in this case the value would be ( 85.53 * 215 = 18388.95)..

There is a difference of Rs 0.87 between the system calculated condition value and when calculated manually..

Can anybody throw some light on this wherein the (unit price * Qty should be = Condition Value)....

Points will definitely be rewarded for valuable suggestions..

Regards

Bhushan

Edited by: NAGABHUSHAN THIPPANNA on Jan 20, 2009 6:13 AM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jan 20, 2009 at 05:31 AM

    Dear,

    There is nothing to do with configuration.

    It is just because of rounding of amount to 2 decimal point.

    Try calculation in Excel and u will get answer

    Regards

    Happy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I hv chcked it already... All i am expecting is a way out in such a way that the Unti price is in line with the Condition Value...

      Regards

      Nagabhushan.T

  • avatar image
    Former Member
    Jan 20, 2009 at 07:05 AM

    Hi,

    Contact the ABAPer to debugg the issue and to make decimal changes in the program of concerned routine(VOFM) to get the accurate condition value.

    Jagan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2009 at 09:16 PM

    I solved this same issue by doing the following.

    You had this:

    1 pr00 88.95 215 19124.25

    2 K007 - 3.85% -736.28

    3 Subtotal(1+2) 85.53 18387.97

    When determining KD07, create a Condition formula for alternative calculation type in VOFM.

    calculate the 3.85% off of the PR00 each price and round this result to 2 decimals. In your example you would get 88.95 * .0385 = 3.424575 commercial rounded to 3.42, then multiply this rounded result with qty to get your extended amount 3.42 * 215 = 735.30 and put the result in XKWERT for KD07.

    Your net result 3 Subtotal(1+2) would be 19124.25 - 735.30 = 18388.95, your net each price would result in 85.53. With this type of calcualtion you will always get consistant pricing regardless of qty. When you are finished with your formula assign it within config of the pricing procedure on your KD07

    line. Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Matthew,

      Thanks for replying.. But i got one doubt and that is when we are multiplying 0.0385 * 88.95, we get 3.424575. If in some other case say if i get the value as 3.42756,should we round off to 3.43 or should we retain the value to 3.42 by ignoring the third decimal place whether it is equal to or more than 5..

      Our technical person is working on the code... But mean time do u hv the code by any chance..

      Thanks and Regards

      Bhushan

  • avatar image
    Former Member
    Jan 22, 2009 at 12:50 PM

    check the rounding rule in Condition type for pricingPR00 and other condition types it should be commercial and should not be rounded up or round down

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2009 at 02:29 PM

    Resolved

    Add comment
    10|10000 characters needed characters exceeded