Sales price include VAT (Tax) amount

[Former Member]

Hi expert

Client requirement is

material sales price is include vat amount { (e.g. sale price is Rs 100 (but include 5% VAT Amount ) } client want to sale the product for Rs 100 only means they can create sales condition record for (PR00 --RS 100)

but how can i calculate tax { (condition type JLST (5%)} what should be the base value

and for some material VAT is 5%, 12.5%, 13.5% then

and if we offer discount then how calculation will happen

e.g.

Price -

---

100

discount -

---

10

net value----- 90

tax on net 5% - 4.5

Total -

---

94.5

But if that Price 100 has VAT amount include then how to handle this calculation part

[former_member550050 · Accepted solution]

Hi

Your calculation shoul be like this

Sales price is Rs 100

Discount is Rs 10

So the discounted price is Rs 90

This discounted price is incl of VAT say 5 %

So the nett price is 90/1.05 = 85.71

This is the mathematical calculation for include VAT (Tax) amount

If you apply 5 % tax on 85.71 then it will be Rs 90

To get this in SAP system your VAT (Tax) condition type should have calculation type as H in its config

Whether from Rs 100 then discount and then VAT

Or

Whether from Rs 100 then VATand then discount

Depends on the alignment condition types in your pricing procedure (steps sequence)

Regards

Raja

[Former Member · Accepted solution]

Dear Friend

Thanks a lot for reply

I did the VAT calculation type as "H"

but still calculation shows the same

100+ vat 4.76 (which is 5%)

total amount is 104.76

aliment of condition type in my pricing procedure is

Price

discount

net value

VAT

Total

like this

please guide

where i am missing

[Former Member · Accepted solution]

Hi

In your case kindly do the below settings for the condition type in configuration V/06

Cond. class D Taxes Plus/minus positive a

Calculat.type H Percentage included

Cond.category D Tax

Rounding rule Commercial

StrucCond.

In your case the net value will be 100 -4.76=95.24

net value ==95.24

tax ==4.76

Regards

Damu

[former_member550050 · Accepted solution]

Hi

I did the VAT calculation type as "H" 
but still calculation shows the same 
100+ vat 4.76 (which is 5%)
total amount is 104.76

Basic Logic

Whenever you touch or change the calculation type of a condition type then you need to create fresh condition records

Till then only old record will only apply ( based on old calculation type )

Create a fresh condition record and see

Regards

Raja

[Former Member · Accepted solution]

Dear Raja

yes i did that at the same time only but still it was

But i find some thing like

Price 100

discount (10%) 10

net value 90

VAT (5%) 4.29 { (this is Tax include in net value ("H iscalculation type ) }

rouding off 0.29

total 90 (here i use alternative calculation type routine "2" in V/08 (net value only )

this is what my requirement BUT

if i save the invoice then accounting document it shows

13100122 B1CC1-clg-Csh dep 94.00

31111100 Sal-Dom-Dir-TG 100.00-

45000010 Discount on sal 10.00

16622111 VAT pybl-BP 21 4.29-

45000010 Discount on sal 0.29

here system pass RS 94 to cas account actually income is Rs 90 which include vat 4.29 also so

here system should pass Rs 90 only or may be {(90-4.29) =85.71

what i have to do to achieve the above

which routine where i have to use

please guide

[Former Member · Accepted solution]

got solution

for tax condition

in alt cal type use routine is 80 then

its perfect

but

if any body knows

please tell me what ever i did is perfect or not

but as per calculation its perfect what i feel

please reply

[former_member550050 · Accepted solution]

Hi

Say

Step 10 condition type VKP0 say Rs 100

Step 20 condition type Tax is 4 % that is with H calculation key

so the tax value is 3.85

The balance 96.15 is to be brought

Then assign subtotal 1 against ster 10 condition type VKP0 in your pricing procedure

In step 30 create a Zee say ZPNT condition type ( you can copy the standard condition type PNET ) or create entirely new with the details mentioned below

config ZPNT condition type should be like this

Condition class as A

Calculation type as G

Plus/Minus --Blank

Manual entries as C

Item condition ticked

No access sequence

Rest every thing blank

Put this ZPNT condition type in step 30 and assign alternate calculation type as 25 against this in your pricing procedure

Create a full cycle and check the accounting entries and post back

+*There system pass RS 94 to cas account actually income is Rs 90 which*+
 +*Include vat 4.29 also so*+
 +*here system should pass Rs 90 only or may be {(90-4.29) =85.71*+

This can be achieved by my suggestion too

Try this too

Regards

Raja

[Former Member · Accepted solution]

Dear Raja

First of all thanks a lot for help

what you told that could be one method

but hence my previous reply i told i assign routine 80 to VAT condition type in ALT CALTYPE so it shows tax is include in net value

then system give me perfect entries as below

24000510 Csh on hand-51 85.71

31111100 Sal-Dom-Dir-TG 100.00-

45000010 Discount on sal 10.00

16622111 VAT pybl-BP 21 4.29

here 100 price the 10 discount net value 90 which include vat 5% so that is 4.29 and still total it will show 90

and accounting it will pass 85.71 as cash

i think its perfect