Indian Tax price calculation.

[former_member267975]

Hi Team,

My requirement mentioned below.

Description:   Scrap Sales - Tax collected at Source

Calculation rule

S.No Description Condition % Base Amount

1 Basic Price ZPRO 9000

2 Excise duty ZEXD, ZECE, ZSHE 16% 1440

3 Sales tax ZCST 2% 1+2 209

4 Tax Collected at Source 1.14% 123 121

1-Can you please help in Pricing procedure where this condition type (Tax collected at source) needs to be put. And what are the value needs to be put in the fileds called- FROM,TO,SUB TOT,REQ,CALTY,BASTYP etc.

2-whether if any acces sequence is required for this condition type ?

3-Any condition record requred for this.

4- Client want it needs to be printed in excise invoice and needs to come in the report.

Appreciate if you can confirm at the earliest.

Regards

Sits

Edited by: Sitans on Dec 15, 2011 2:18 PM

[Former Member]

hi

"G" related with the alternative formula ,it should be manually entered and calculation type should be c because scrap has no value assigned

[Former Member]

hi

there should be all z fields because every country has its own tax procedure,the word itself means that tax collected at source will be calculated from step 100 and the amount is maintained in tcode vk11 based on percentage calculation type

100 ZPR0 Basic Price

110 ZEXD Basic Duty 100

120 ZECU Edu.Cess 110

130 ZSH HECEss 100

140 ZCST Tax 100 130

150 ZTCS TCS 100 140

[former_member267975]

Hi,

Do I need to maintain my ZTCS (Scrap sales )condition type in IMG-Tax on Goods movementBasic SettingDetermination of Excise Duty--Maintain Excise default. There I can see other condition type ZEXD,ZECE,ZSHE has maintained for tax procedure ZTXINN .

If ZTCS needs to be maintained then whcih coulumn and field it will be maintained and what is the significant of this. If we will not maitain what will happen ?

Appreciate if you can confirm at the earliest.

Regards

Sp

[former_member267975]

Hi Team,

When I am trying to post to Account through VF02 it throughs an error that Posting Keys for account determination for transaction ZTS does not exist ?

Anything needst to be done with account configuration ?

Please provide me the details.

Regards

Sp

[jpfriends079]

This error is due the account key assign aganist the Tax Condition Type in your pricing procedure.

Generally for Tax Cond Type the account key is define in TCode OBCN and there Account key ZTS is missing/not defined.

Finally, make sure you have TAX relevant GL account is assigned the account key ZTS in TCode OB40.

If problem persist, don't hesitate to contact FI team member in your team.

Regards

JP

[Former Member]

If condition class is tax for ZTCS condition type then amount will not get posted to respective GL.

It will get posted only through Tax code so you need to maintain the access sequence for ZTCS

Tax conditions can not be entered manually

[former_member267975]

I have copied from MWST outptut tax. where condition class is Tax and no access sequence. I have put conditon type can be entered manually. Client said they will enter manually into an order for ZTCS with % and it needs to post to account and it should print in output.

Regards

Sits

Edited by: Sitans on Jan 4, 2012 6:02 PM

[former_member267975]

I have configured ZTCS condition and it's manual entery but it's not picking into invoice but other condition is picking e.g ZEXD, ZECS. where I will check ?

[former_member267975]

Hi Guys,

Still now I have not received any input. My ZTCS condition is not picking into an invoice. This one is manual condition which I entered into an order. Please advise ?

Regards

Sp

[Former Member]

Dear sits,

plz check copy control vtfl from delivery to billing ,just see at item level what is the pricing type if its G then it will not take manual condition check it make it C so it will redetermine all the cond types including manual conditions just check once if it helps u.....

[Former Member]

Dear sits,

plz check copy control vtfl from delivery to billing ,just see at item level what is the pricing type if its G then it will not take manual condition check it make it C so it will redetermine all the cond types including manual conditions just check once if it helps u.....

[former_member267975]

Thanks for the response. Yes pricing type is G. But do you think that if I will change to C it will work. Because my tax condition is ZTCS(Which is scrap sales) and category is Tax , in manualy entry field I have put blant(No limitation). No acces sequence is maintain. It's calculation total of ZPROZEXDZECE+ZSHE=ZTCS %.

What you suggest.

[jignesh_mehta3]

Hello,

Have you tried with option "C"?

In your case ZTDS is a % manually entered & that need to be a copied from Sales Order to Invoice. for tthis we have suggested setting of C in Pricing in copy control records.

Just try this once & then let us know the outcome.

Thanks,

Jignesh Mehta

[former_member267975]

Hi Team,

I have assigned new account key to scrap sales condition. But while releasing to accounting I am gettiang an error message that" Posting keys for account determination for transaction ZTS do not exist"

What are the areas we need to look ? Anything needs to be maintained in FTXP with newly created condition(scrap sales) and new account key ?

Appreciate if you can confirm at the earliest.

Regards

Sp

[Former Member]

In OB40 for 'ZTS' put posting key values (confirm with FI what those should be).

[Lakshmipathi]

Your pricing procedure should be as follows:-

100   ZPR0     Basic Price
110   ZEXD     Basic Duty     100
120   ZECE     Edu.Cess       110
130   ZSHE     HECEss         100
140   ZCST     Tax            100    130
150   ZTCS     TCS            100    140

On your other queries,

2. yes unless you maintain access sequence, how will you maintain condition record in VK11

4. for output, ask your ABAPer to include this condition type also in the report.

G. Lakshmipathi

[former_member267975]

Thanks Lakshmipati,

For your quick response. But in Access sequece what are the tables needs to be included. And while creating this condition type to which condition type I should refer. Because in condition type lots of filelds are there so which filed needs be activated or not etc. And what value needs to be put in requirement field ?

Please provide the details. Because I am new to CIN.

My procedure like this.

125 0 ZDI2 DisctSrchValHead/Ite 2 ERS

200 0 Discount/Surcharge Amount 101 199

210 0 Net Value 1 X 2 2

450 0 HM00 Order value S 6 ERL

460 0 Net value 3 D 2

500 0 ZEAS Ex-Duty Ass Value 351

505 0 ZEXD IN:Excise Duty 460 500 17 963 EXD

510 0 ZECE IN:Ecess on ED 505 505 17 ECS

515 0 ZSHE IN:SEcess on ED 505 505 17 SEC

517 0 ZEXR IN: A/R BED % Govt 505 515 ZXB

518 0 ZEXM IN:Ex.Duty Reimburse X ZXM

520 0 Total Excise duty 505 519

530 0 ZEWC IN:ED-Warranty Cost 520 520 55 ZWC

540 0 Total Taxable Amount X 2

Regards

Sits

Edited by: Sitans on Dec 16, 2011 6:57 AM

[jpfriends079]

Access sequece what are the tables needs to be included

This definitly based on your client requirement.

General rule for that you can find them in following SDN threads:

-

-

-

-

Just a thought,if your are new, don't hesitate to search & learn. Thats a fexibility, just explorer its power.

ALL THE BEST.

Regards

JP

FYI - you can refer following SAP Notes for your reference/understanding:
Note 535616 - FAQ: Country Version India (CIN) General SD queries
Note 950977 - Country Version India (CIN) Master note for SD FAQs
Note 63805 - FAQ: Country-specific Customizing settings
Note 594219 - VAT implementation in India
Note 532557 - FAQ: Country Version India (CIN) General queries
Note 1434100 - RG1 - Daily Stock Account

[former_member267975]

Hi,

Can you tell this ZTCS condition type while creating which condition type I should copy.

Regards

Sits

[jpfriends079]

Copy TAX condition type MWST.

Regards

JP

[former_member267975]

Hi,

1-My user want ZTCS condition type needs to be enter manually with percentage amount. I think accequence is not required.

2-Second think calulation rule also not apllicatble.

3-ZTCS should be calculated Total of Basic priceexcise dutySales tax.

What u suggest ?

Regards

Sits