CIN requirement In a fiscal year Upto 30000 at 2% More than 30000 at 10%

[former_member183078]

Hi Experts,

our client has requirement .its about cin. Client needs  calculate tds upto 30000 3% more than 30000 percentage would be 10.

In a fiscal year

Upto 30000 at 2%

More than 30000 at 10%

can any one tell me configuration for this requirement how i want processed further .

Regards

Diwa

[former_member214973 · Accepted solution]

Hi Diwa

Step 1 : tax type.  In tax type select appropriate Accumulation type:

If your company use calender year, accumulation type will be "per calender years"

otherwise select "per year, starting with month" and enter starting month.

Step 2:  tax code. don't put any tax rate in calculation area. select w. tax from.

Step 3: enter tax formula for the tax code like:

To base amount          whldtax              Redrt        Redu. Base amt

30000                             2                            

999999999999               10                                        30000

save

http://scn.sap.com/community/erp/financials/blog/2013/07/14/withholding-tax-india-cin

Regards

Nakul

[former_member183078]

hi

can you please explain me how to reach out  above requirement without creating tax code. because we have number of vendors where they are having different tax exemptions so its not possible to create tax codes vendor wise. so please help me on this

Thanks&Regards

Diwa

[former_member183078]

Hi Nakul,

Please let me know how to deduct tax without creating tax code.waiting for reply

Regards

Diwa

[former_member214973]

Hi

it is not possible, to deduct tax without tax code

Regards

Nakul

[former_member183078]

Hi all,

we have number of vendors where they are having exemption percentages.it is not possible to create vendor wise tax codes is there any other way to overcome this requirement.

Regards

Diwa

[former_member214973]

Hi

to deduct tax, a tax code must be define for a percentage or formula.

It is possible to deduct tax with out tax code.

Reghards

Nakula

[former_member183078]

hi nakul

can you please explain me how to reach out  above requirement without creating tax code. because we have number of vendors where they are having different tax exemptions so its not possible to create tax codes vendor wise. so please help me on this

Thanks&Regards

Diwa

[Former Member]

Hi,

The Tax Code you would define would be standard rated, this tax code assign in the Vendor master data.

Based on the percentage provided for each vendor , you can specify the exemption certificate number, date effective and save it.

The process the invoice for the vendor. That should work.

Let me know if this resolves your question.

Note-

======================

You have the following options for clearing documents despite these warnings:

• Change the posting date for clearing, so that the relevant withholding tax types are the same on the posting date and on document entry.
• Change individual documents using the document change function: To do this, you delete the withholding tax code in withholding tax types that are no longer relevant, and then save new withholding tax types.

• Start report RFWT0010.
  Once you have changed the relevant withholding tax types, this report adjusts the open items to take account of the current relevant withholding tax types. It either creates new withholding tax information, or changes existing information.

===================

Remember these steps before you process new documents.

Regards

K.R

[former_member183078]

Hi Nakul,

i followed your configuration its working fine.here  we have one scenario we had set limit for

up to 1000000 3 % more than 100000 tax rate will be 10%. here we have posted invoice for 200000 entry will be  expenses a/c.....Dr   200000

                                   vendor a/c..Cr  187000

                                   Tds payable Cr 13000

here user wants two tds gl account one tds gl account for exemption  amount that is  3000 another gl account with 10000  how to do it Please help me on this.

Thanks&Regards

Diwa

[Former Member]

Hi,

According to me, for your requirement of other GL for 3000 & other GL for 10000, what you can do is create two Withholding Tax Code and then asssign both to the Vendor Master. Then in formulas for both tax Code mention for one tax code:

To base amount          whldtax              Redrt        Redu. Base amt

30000                             3                         

999999999999             0                                              30000

For other Tax Code you mention in formula:

To base amount          whldtax              Redrt        Redu. Base amt

30000                                0                           

999999999999               10                                        30000

And then assign the GL accordingly.

Regards,

Malhar.

[former_member183078]

Hi Nakul,

i followed your configuration its working fine.here  we have one scenario we had set limit for

up to 1000000 3 % more than 100000 tax rate will be 10%. here we have posted invoice for 200000 entry will be  expenses a/c.....Dr   200000

                                   vendor a/c..Cr  187000

                                   Tds payable Cr 13000

here user wants two tds gl account one tds gl account for exemption  amount that is  3000 another gl account with 10000  how to do it Please help me on this.

Thanks&Regards

Diwa

[former_member183078]

Hi Nakul,

i followed your configuration its working fine.here  we have one scenario we had set limit for

up to 1000000 3 % more than 100000 tax rate will be 10%. here we have posted invoice for 200000 entry will be  expenses a/c.....Dr   200000

                                   vendor a/c..Cr  187000

                                   Tds payable Cr 13000

here user wants two tds gl account one tds gl account for exemption  amount that is  3000 another gl account with 10000  how to do it Please help me on this.

Thanks&Regards

Diwa