Tax determination .

[former_member330517]

Hello Gurus,

Goodmorning,

There is a problem in determining the region in the tax dtermination.

For determining the VAT or CST , i maintained a condition table with combination like this:

Country/delivering plant region/region/customer/customer Taxclassification/material/material tax classification.

Here system should take the region based on ship to party location ,but system by default taking region as '01( AP), but i maintained it as 11(kerala) in my ship to party , looking for your inputs.

Note-Tax determination should be done based on ship to party location , Delivery plant region.

Thanks in advance

Regards

Venkat

[Former Member · Accepted solution]

Dear,

Please check your customer master XD02. Is there maintained right region in XD02 for your customer and plant ?

Regards,

Sandip

[former_member330517 · Accepted solution]

Hi ,

One typical thing,

customer doesn't want maintain delivering plant in master data,

they produce same material from diffrent plant in the same region, so they want to give plant manually at the time of sales order,

based on product availability .

Thanks

Regards

Venkat

[Former Member · Accepted solution]

Dear,

Please check your customer tax classification in XD02 --> Sales Area Data --> Billing Document --> Taxes (Is there VAT 1) ?

Regards,

Sandip

[former_member330517 · Accepted solution]

Hi

Sandip

India ZCST IN-CST-VKS 0 Tax Exempt

India ZVAT IN -VAT -VKS 1 Liable for Taxes

this how i mainined in customer master.

Regards

Venkat

[Former Member · Accepted solution]

Dear,

you can maintain VAT in XD02 ---> that i mention letter.. like it is Tax Exempt or Taxable or other...

Regards,

Sandip

[former_member330517 · Accepted solution]

Hi Sandip,

I maintained it is as Taxable customer under VAT

Note-VAt liable for customer -1

Thank you

Regards ,

Venkat

[former_member330517 · Accepted solution]

Hi ALL.

This is how system is reponding to condition record maintained for the condition type

Access Message Description

01 109 Condition record is missing

Access (complete)

Field in condition table Field in document Value in doc.

A740-ALAND KOMK-ALAND IN

A740-WKREG KOMK-WKREG 11

A740-REGIO KOMK-REGIO 11

A740-MATNR KOMP-PMATN 000000000020000148

A740-TAXM1 KOMP-TAXM1 0

A740-HIENR KOMK-KUNWE 0000350037

A740-TAXK1 KOMK-TAXK1 0

KOMK-FBUDA 13.07.2010

I maintained tax classification 1 for both customer and material classification , don't understand why it is not picking.

Thank you

Regards

Venkat

[Former Member · Accepted solution]

Dear,

Please try this type,

1) Please delete your sales order line item and enter again same product.

OR

2) Access (complete)

Field in condition table Field in document Value in doc.

A740-ALAND KOMK-ALAND IN

A740-WKREG KOMK-WKREG 11

A740-REGIO KOMK-REGIO 11

A740-MATNR KOMP-PMATN 000000000020000148

A740-TAXM1 KOMP-TAXM1 1 (Instead of 0)

A740-HIENR KOMK-KUNWE 0000350037

A740-TAXK1 KOMK-TAXK1 1 (Instead of 0)

Regards,

Sandip

[Former Member · Accepted solution]

Hi Venkat,

Just try this, If your condition type of Vat in any master data not in 1st position, and some other condition type is in 1st position means what ever value is maintained for that condition type that value only will applicable.

Ex: In Customer master - Billing Tab - 1st condition type is ZFR0 -0

2d Condition type is ur ZLST -1

means it will consider 0 only.

I have faced this one. Try and revert back. If ur probs same to mine meant it will be solve.

Thanks and Regards,

Kumaran.K

[former_member330517 · Accepted solution]

Hi Kumaran

I am facing the same problem what you have mentioned ,.

This is how the conditions are maintained inmaster datas

Material master: ZCST -0( Not liable for Tax)

ZVAT-1( Liable for Tax)

Customer master: ZCST-0 ( Not liable for Tax)

ZVAT-1( Liable for Tax)

As you mentioned in both master datas ZCST is mentioned Ist and ZVATmention 2nd,when i maintained condition record it is not considering the ZVAT condition type value given in master data , its condition Considering ZCST condition type value mentioned in master datas.

The explanation what you gave is 100% correct , i'm facing same problem.

Now looking for your input

Thank you

Regards

Venkat

Edited by: K.Venkata Chalapathi on Jul 13, 2010 3:41 PM

[former_member330517 · Accepted solution]

Hi Sandip

I maintained what suggested ,

Field in condition table Field in document Value in doc.

A740-ALAND KOMK-ALAND IN

A740-WKREG KOMK-WKREG 11

A740-REGIO KOMK-REGIO 11

A740-MATNR KOMP-PMATN 000000000020000148

A740-TAXM1 KOMP-TAXM1 1 (Instead of 0)

A740-HIENR KOMK-KUNWE 0000350037

A740-TAXK1 KOMK-TAXK1 1 (Instead of 0)

But system not considering what we are mataing, system is giving like following way:

Field in condition table Field in document Value in doc.

A740-ALAND KOMK-ALAND IN

A740-WKREG KOMK-WKREG 11

A740-REGIO KOMK-REGIO 11

A740-MATNR KOMP-PMATN 000000000020000148

A740-TAXM1 KOMP-TAXM1

A740-HIENR KOMK-KUNWE 0000350037

A740-TAXK1 KOMK-TAXK1

Its considering only tax classification givento ZCST in material , customer masters , but not considering tax classification given to ZVATin customer , material master .

Note-ZCST maintained as 1sT classification condition type in both master datas, ZVAT as 2nd classification tye in both master datas

Thanks

Regards

Venkat

[Former Member · Accepted solution]

Hi Venkat,

For Temporarly u put Full Tax i.e 1 for ZCST in VAT customer master also. So for local customer u have to pur ZCST - 1 and ZLST - 1 .

Now check in SO, it will update the condition record.

For Permanant you have to change the present Access sequence.

Thanks and Regards,

Kumaran.K

[former_member330517 · Accepted solution]

Hi Kumaran,

This is the combination i took in the ZCST AND ZVAT,

combination: Contry/delivery plant region/region/material/material classification/customer/customerclassification.

Suggest me what are the changes required in this combination.

looking for your inputs

Regards

Venkat

[Former Member · Accepted solution]

Dear,

You just enter 100 in amount column (In VK12 --> Contry/delivery plant region/region/material/material classification/customer/customerclassification ---> Amount) . I think it should work.

Regards,

Sandip

[Former Member · Accepted solution]

Dear Venkat,

You have to use TAXK2 ( Tax classification2 customer ) and TAXM2 ( Tax classification2 material ).

Create access sequence with this combination only for VAT condition type. I hope u r facing this probs only for VAT.

Check & revert back.

Thanks and Regards,

Kumaran.K

[Former Member · Accepted solution]

i.e.

Contry/delivery plant region/region/material/material classification2/customer/customerclassification2

Instead of TAXM1 and TAXK1.

Kumaran.

[former_member330517]

Problem solved ,

I would like thank Kumaran Ist for his inputs

The table combinstion in Access sequence for both CST and VATshould be different .

Thank you all for your wonderful support

Regards

Venkat

Edited by: K.Venkata Chalapathi on Jul 14, 2010 1:02 PM

[Lakshmipathi]

I have a feeling that both your customer master and material master tax classifications itself are wrong.

In customer master, under sales area data tab, select the sub tab Billing Documents where you can see different tax classifications. It should have been JTX1 to JTX4. For JTX1, it should have been 1. The same case for material master also.

Let me know if you are able to see the tax categories in your respective masters.

thanks

G. Lakshmipathi

[former_member330517]

Hi Lakshmipathi,

I have the condition types in both the master datas

For customer master sales: Billing tab:

Tax classifications

ZCST, ZVAT

AND In material master

IN Sales org 1 tab

Classification

ZCST,

ZVAT

only problem now is system considering ZCST classification value but not the ZVAT classification , for condition record of ZVAT also.

I need ZCST, ZVAT condition types , as client using these two taxes here.

Regards

Venkat

[Former Member]

Dear,

I think you can maintain only one condition in condition. You can maintain condition VAT neither CST. Because VAT maintain 4 + 1 % and CST is maintain like 3 + 1 % or 4 + 1 % etc...

Regards,

Sandip

[Lakshmipathi]

You have to once again check in two places

1) In customer master, what region code and tax classification are maintained

2) In VK12, for tax condition type, as you said, tax code should have been maintained for the combination of

a) India

b) Delivering Plant region

c) Ship To Party region (11)

d) Ship to party code

e) Ship to Party tax classification (say 1)

f) Material code

g) Material master tax classification (say 1)

I have a strong feeling that you would not have maintained with the correct combination in VK11 and that is why the error.

thanks

G. Lakshmipathi

[former_member330517]

Hi Lakshmipathi,

I have maintained all those combination in condition record

But when i go analysis , those are not reflecting,

EX: country ( IN)

Delivery plant Region( 11)-Kerala

Region-11

customer region-XYZ

Customer classification-1( VAT)

Material-XYZ

Material tax classification- VAT-1

These are not reflecting

instead system taking tax classification as zero for both customer and material

Note-Customer tax classification -1

Material tax classification-1 in both master datas

Regards

'venkat

Edited by: K.Venkata Chalapathi on Jul 13, 2010 12:27 PM

[jpfriends079]

Yes, the region should come from SHIP-TO PARTY master.

Check in your access - condition table, you are referring to which region.

- Region with field J_1AREGIO

or

- Region with field REGIO..

To do so, check field attribute for Region.

Thanks & Regards

JP

[former_member330517]

Hi Prakesh

Region is taken as in the following combination

ALAND KOMK ALAND Country

WKREG KOMK WKREG Region of dlv.plant

REGIO KOMK REGIO Region

MATNR KOMP PMATN Pricing Ref. Matl

TAXM1 KOMP TAXM1 Tax class. material

HIENR KOMK KUNWE Ship-to party

TAXK1 KOMK TAXK1 TaxClass1-Cust.

KFRST Release status

KBSTAT Processing status

Regards

venkat

[jpfriends079]

If I'm not mistaken,

there are 2 fields in Region in condition table's field catalog.

Check which Region you are using?

Regards

JP

[former_member330517]

Hi JP,

REGIO KOMK REGIO Region

this table i'm using

system by default taking classification as zero for both customer and material not considering what we are giving , i'm just struck up.

Thank you,

Regards

Venkat

[former_member330517]

Hi JP,

REGIO KOMK REGIO Region

this table i'm using

system by default taking classification as zero for both customer and material not considering what we are giving , i'm just struck up.

Thank you,

Regards

Venkat