Service Tax & Excise in TAXINN

former_member256837 · ‎04-30-2012

Hello Experts,

We have service tax and recently i have customized excise on goods.

We are using procedure TAXINN.

When i customized excise(diff tax code), service tax calulations got disturbed.

If i give service tax code in my PO, it makes calculations as below:

Base Amount 100

Service tax 12
ECess 2

HEcess 1

Excise 12

ED Ecess 2

ED HECess 1

Total

Where im making mistake?

Thanks

brinda_r · ‎04-30-2012

Hi,

For the tax code which you have customised check if service tax conditions are also active.

Check in FV13 for tax classification option.

Regards,

Brinda

former_member256837 · ‎04-30-2012

Thanks Brinda!

service tax conditionas are active

Regards,

prabhu_sundararaman2 · ‎04-30-2012

Hi,

How come there is service tax and excise duty for the same PO item.

Can you please explain the business scenario?

Regards

Prabhu

tejyadav · ‎04-30-2012

I think you have mixed up the conditions within the Tax code, In PO click on Taxes Tab, then click on Analysis & then the condition to check what 'Key Combination' is used, After that go to T-code FV12 & Put a deletion indicator to this extra conditions & Values coming for the Particular Tax code,

former_member256837 · ‎04-30-2012

Thanks Tej Yadav!

key combition is used only for excise - plant and material group.

For service tax - rate is given in FV12

Regards,

tejyadav · ‎04-30-2012

If the Tax code is meant for Service then you should remove the Excise conditions maintained in the Tax code,

Former Member · ‎04-30-2012

Hi,

Please check tax codes in FTXP.

Thanks,

Amit Karanjkar

former_member256837 · ‎05-02-2012

Hi,

I think i have created some confusion.

I have 2 separate tax codes. 1.Service tax 2. Excise

In TAXINN, i had conditions for service tax and now i have added excise condtions

FV11 is maintained separately for both tax code and respective rates

When i choose service tax code in PO, it shows me picture as below, service tax & excise both.

Base Amount 100

Service tax 12
ECess 2

HEcess 1

Excise 12

ED Ecess 2

ED HECess 1

Which i don't want.

Regards,

Former Member · ‎05-02-2012

HI,

This is because you have maintained the excise conditions for the combination of Plant/Material group.

Since valid condition record exists for your PO Plant and Material group, as per TAXINN settings system is triggering both Excise as well as Service tax condition.

Normally for Services we will use material group - services, so excise condition records should not be maintained for the same.

Please correct the condition records to resolve this issue.

Please check n let me know if you have any queries.

Thanks & Regards,

former_member256837 · ‎05-02-2012

Thanks for the reply!

What should be corrected in conditions, could you please guide me?

Thanks

kailas_ugale · ‎05-02-2012

Hi,
When i choose service tax code in PO, it shows me picture as below, service tax & excise both.
Base Amount                              100
Service tax                                   12
ECess                                            2
HEcess                                          1
Excise                                           12
ED Ecess                                       2
ED HECess                                   1
Which i don't want.

As per me above is correct because you have maintain condition record for both excise and service tax in Fv11

now display your condition for excise and service tax in Fv13 and correct it

or make it for combination of plat and tax code

Kailas Ugale

former_member256837 · ‎05-02-2012

Thanks Kailas!

I don't have key combination as Plant and tax code.

Regards,

Former Member · ‎05-02-2012

Hi,

As I already mentioned in my last thread, Please check the material group in your service PO document where excise is triggered wrongly.

Since excise condition records are maintained for the Plant/material group (Service Material group) excise is calculated. Hence please maintain deletion indicator for the same using FV12 transaction.

Thanks & Regards,

former_member256837 · ‎05-16-2012

Thanks SAP FC!

I have created new key combination - Country & Tax code

And now service tax calculations are correct!

But when i tried to maintain rate in FV11 with this new key combination - country & tax code for excise tax code, it gives me one error message

Tax indicator E1 has percentage rate 12.500

Message no. VK154

12.5% is for VAT which i have defined in tax code E1

My excise is with 12%

Do you know why i get this message

Regards,

brinda_r · ‎05-17-2012

Hi,

If the access sequence is JTAX then you will have to set the deletion indicator for the recod having 12.5% and then create a new entry with 12%

Regards

Brinda

former_member256837 · ‎05-17-2012

HI Brinda,

12.5% is my VAT rate.

As you can read in my first thread, i have mentioned that on basic amount, excise of 12.36% is applicable and onthe total amont (basic = excise) VAT 12.5% is applicable

In FV11, i 'm trying to maintain rate for excise which is 12%(JMOP), 2%(JEC1) and 1%(JSEP)

And here i get error message

Regards,

brinda_r · ‎05-17-2012

Hi,

Are you trying to change the existing tax rate for JMOP, JEc1 or JSEP?

Regards,

Brinda

former_member256837 · ‎05-17-2012

Hi Brinda,

No, i do not wish to change the rate but the key combination

Earlier i had maintained the rates with key combination "plant & material group" which i'm changing to "country and tax code"

Regards,

Former Member · ‎05-17-2012

Hi,

Please check whether the condition table you have used for the access country/tax code is 3 (A003) - tax classification only.

Also check whether you have maintained any rates for excise with the above combination.

Thanks & Regards,

former_member256837 · ‎05-23-2012

Thanks!

I got it resolved!

But now i have another issue.

IN PO, taxes button show me correct calculations.

When im trying to post MIRO, it doesn't show me JMOP i.e. 12%

Entry looks as below

Base Amount 100

ED Ecess 0.24

ED HECess 0.12
VAT 12.5 14.05

Excise 12% is missing.

What can be the reason?

I have maintained the rate in FV11 with country & tax code

Regards,

brinda_r · ‎05-23-2012

Hi Simi,

Check whether JMOP and JMX1 conditions are classified correctly in J_1IEXCDEFN table

for TAXINN

Regards,

Brinda

former_member256837 · ‎05-23-2012

Thanks Brinda!

Conditions are defined correctly.

Before i got this error, it was showing me JMOP and now it is missing

I had deleted the tax code and created onece again and also FV11 maintained again

But still no help

Regards,

ajitkumar · ‎05-23-2012

what is the access sequence you are using in service tax and excise?

former_member256837 · ‎05-23-2012

Im using JTAX - IN:Excise access

Regards,

former_member186100 · ‎05-23-2012

hi simi,

wat about total tax amount in basic data tab of MIRO , does that include excise? ( if yes may be ur excise is getting inventorized , did u post excise invoice with proper BED? or u have maintained wrong accounting key in OBQ3 in front of JMOP.

please post accounting entry at GR and J1IEX posting too .. that might help in resolution

cheers

Avinash

ajitkumar · ‎05-23-2012

and which table in Jtax?

former_member256837 · ‎05-23-2012

Hi Avinash,

Tax amount doesn't include JMOP 12%

When i simulate the picture is like this

Vendor 114.41

GR/IR 100

Edu cess 0.24

HEdu cess 0.12

VAT 12.5 14.05

GR entry is smilple

Expense a/c Dr 100

GR/IR Cr 100

Regards,

former_member186100 · ‎05-23-2012

excise invoice posting entries.. the J1IEX posting?

former_member256837 · ‎05-23-2012

Hi Avinash,

I don't know what is J1IEX, could you please tell me?

Regards,

former_member186100 · ‎05-23-2012

in india we keep excise registers rg23 a and c as required by central excise tax laws. to insert entries in those registers we use J1IEX transaction , SAP is programmed to bring in same values in MIRO as posted in J1IEX. and do check if u have maintained 100% for condition JMX1 in tax codes

former_member186100 · ‎05-23-2012

and check if there is any error message in MIRO , sometime when u have not maintained GL code in OB40 for accounting key in OBQ3 , system is not able to find where to post tax amount and it does not show tax line item

ajitkumar · ‎05-23-2012

i think in your original error, system was finding 2 valid conditon records. for e.g if the records were maintained in material group, excise and service tax condition record exist for the same material group..

former_member256837 · ‎05-23-2012

Hi,

I have maintained the account in OB40, rechecked it

Also, i have deleted the rates which were maintained in material group and put new in country and tax code

Regards,

former_member186100 · ‎05-23-2012

there is no error message in MIRO??? it is allowing u to post miro with the values u have mentioned above ... do check if u have maintained 100% for condition JMX1 in tax codes

check following screenshot

former_member256837 · ‎05-23-2012

Hi Avinash,

There is no error message! I could post the MIRO without JMOP

Regards,

former_member186100 · ‎05-23-2012

do check if u have maintained 100% for condition JMX1 in tax code

former_member256837 · ‎05-28-2012

Hi,

I have checked all the settings 2-3 times and still don't find anything

When i post invoice thru Finance i.e. FB60, it shows me JMOP and all conditions correctly calculating excise & vat.

But in MIRO, JMOP is missing

Regards,