cancel
Showing results for 
Search instead for 
Did you mean: 

VAT calculated based on Net Price

sundancer
Explorer
0 Kudos

Dear all,

I have the following requirement, for B2C business:

In the shop, a customer buy one product 110 USD (Gross price = 100, VAT = 10).

Is there a standard SAP solution to calculate these 10 USD VAT amount,

based only on the 110 USD Net Price?

Kind regards,

Sebastien

Accepted Solutions (1)

Accepted Solutions (1)

sundancer
Explorer
0 Kudos

Thanks dear both,

Anyway it might be achieved with standard:

I have to test it, but it seems ok using Alt Cal Type 80, with Condition type MWI1:

A topic a few confuse, but a good basis:

http://scn.sap.com/message/11125782

Kind regards,

Sébastien

mahendra_jani3
Contributor
0 Kudos

Hi Sebastien,

I went through logic of Alt Cal Type 80 which is just assigning Minus sign to condition type Value.

Now, my point is, How do you know that how much is Tax amount.

Let's take a complicated example:

Product which you are currently selling is at 110 (Inclusive of Tax) so you know very well that 10 (Tax) and 100 (Base Price)

Assume your Product is being sold at 135.

Let us know logic, what will be the Tax amount. How you derive it in pricing?

What value will be going for Posting and to which account?

I will request you to give answer of above detail, because I have observe similar type of question multiple time, all are talking about reducing tax from Inclusive of Tax value but not about how they derive to Tax from above value.

Regards,

MJ.

sundancer
Explorer
0 Kudos

Hi MJ,

I tested the following solution, and it was OK.

Kind regards,

Sébastien

Pricing procedure

100ZJI1Net price incl. Taxes      X ERL
1000 Net including Taxes      A 2
2000ZJMITaxes      S 1080 MWS
3000 Gross Price      170

Sales document conditions:

ZJI11.050 USD1BTE1.050 USD
1.050 USD1BTE1.050 USD
ZJMI5%     50-USD
1.000 USD1BTE1.000 USD
Former Member
0 Kudos

Hi MJ,

We face a similar situation calculating back the tax amount from an amount inclusive of VAT.  It can be addressed in condition type.  In condition class, choose "D: Taxes"  Calculation type "H: Percentage Included" and Condition Category "D: Tax"  Pls see screen shot below:

This will give the ff result:

Amount inclusive of VAT:  112,000.00

VAT Amount:                         12,000.00

Base Amount:                    100,000.00

Regards,

Matt

Answers (3)

Answers (3)

Lakshmipathi
Active Contributor
0 Kudos

a customer buy one product 110 USD (Gross price = 100, VAT = 10).

Is there a standard SAP solution to calculate these 10 USD VAT amount, based only on the 110 USD Net Price?

Can you please reconfirm your above statement is correct ?  When you say system to calculate tax on USD 110 which is the gross price, then what is USD 100 (you say this is the gross price) ??

G. Lakshmipathi

sundancer
Explorer
0 Kudos

Sorry to be unclear,

Please find my example:

110 USD     (NEt price: include taxes: price that customer pay in the shop)

10  USD     (Tax amount)

100 USD     (Gross Price).

As my previous note, I have to test standard COndition type and Alt Cal type '80':

it might be the solution.

Kind regards,

Sébastien

mahendra_jani3
Contributor
0 Kudos

Hi Sebastien,

As correctly pointed by TW, AltCal type will have to be created.

Calculation Logic will be : (Gross Price /(1+VAT %) = (110 / (1+10%)) = 100 USD your Base price.

Store Main Price in Sub total D and above derived price in Sub total E.

Against, VAT condition type apply standard Atl Cal type 12 (XWORKD - XWORKE) which will derive VAT amount.

Regards,

MJ.

former_member182378
Active Contributor
0 Kudos

Sebastien,

I think this is not possible in standard SAP, you would have to create a routine (piece of code) and place it in your pricing procedure in field AltCal type, in order to calculate the VAT value.