Skip to Content

I had a peculiar problem posed by one of my user and thanks for this.

As per the User, SAP is calculating wrong MWST for a perticular line item as in the inset

/wp-content/uploads/2013/11/scn1_333792.png

Here it shows for the Value 144.80 the tax is 23% means it should calculate = 33.30

But calculating 33.33 i.e. .03 pence more and then checked in item condition MWST where I didnt understand first what is this condition round diff .03

/wp-content/uploads/2013/11/scn1_333792.png

why should SAP calculate MWST wrong?

I posted the thread and scratched my head endlessly and then found a peculiar behaviour of SAP

SAP calculates the Net VAT (MWST) to the correct value at the  bottom line, but rounds up and adjust with the highest calculated priced line item. I have checked randomly few invoices and found rounding can be seen for the highest calculated priced line item.

For example: 

Line item 40 in the sales order had the highest value and there the SAP rounded up.

/wp-content/uploads/2013/11/scn1_333792.png

and the line item 40 is highest priced and now go to item condition select MWST, double click and see

/wp-content/uploads/2013/11/scn1_333792.png

But when you see for the less then this priced line item you would not see the condition round diff as in inset

/wp-content/uploads/2013/11/scn1_333792.png

Similarly I check for several orders and this is the same thing I seen on every order.

One can calculate the whole Sales Order and see if the MWST is wrong?

for each line item if you see might be confusing, but when you total it up, will be right.

So in a nutshell, I can say SAP is calculating MWST right at the bottom line, but when you see each individual lines, it will be sometime confusing.

Any comments and suggestions are welcome.

By the way I have a related thread which inspired me to write this for the SAP Community is

http://scn.sap.com/thread/3423707

__________________________________________________________________________________________

Addition:

04.12,2013

————————————————————————————————————————————————————–

Upon the request of a member adding screen shot of MWST Condition type from V/06

/wp-content/uploads/2013/11/scn1_336281.gif

Thanks,

Sridhar.

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. venu gopal

    Dear sridhar very good document You have shared .. thanks a lot

    But when you see for the less then this priced line item you would not see the condition round diff as in inset

    Plz make me clear on this … On whch amount is low and why That rounding option wont be diplayed

    Thanks a lot dear

    (0) 
    1. Sridhar Vijjhalwar Post author

      Hi Venu,

      First of thanks for liking it.

      Suppose there are 3 line items

      1.  Material 1  –  10 each –  10 Euro for 1 – 100 Euros

      2.  Material 2  –   5 each  –  45 Euro for 1 – 225 Euros

      3.  Material 3  –   3 each  –  90 Euro for 1 – 270 Euros

      in that case the line item 3 is having highest value  and the lowest value amonth 3 line items are for material 1.

      So if you put this on sales order and in item conditions, you will see the rounding will be on 3rd line item.

      So which ever line item have bigger net value.. will undergo the rounding on MWST.

      Check it.

      Thanks,

      Sridhar.

      (0) 
      1. Phanikumar Valiveti

        Can you please share the screen of V/06 for your MWST condition type-What has been assigned at your rounding rule in master data1 Tab?

        What was the Rounding difference comparison you maintained?

        -I may not be with you that this was SAP Peculiar behaviour…

        Pl let me see and understand.

        Phanikumar

        (0) 
        1. Sridhar Vijjhalwar Post author

          Hi Phanikumar,

          I highly appreciate your comment and for that valid reason I have enclosed the screen shot of MWST Condition type in my main body of work at the bottom.

          Now I want you to test and come back with screen shots and results and let me know why you felt so.

          Thanks,

          Sridhar.

          (0) 
  2. arnab sarkar

    This post is really helpful bcoz many times we come across this common transaction..So just thanks a lot for your “wow” presentation. 🙂

    (0) 

Leave a Reply