Tax Category not sequence in Customer Master record in billing Tab page

[Former Member]

Hi friends

Tax Categories appearing alphabetically manner in CMR of Billing tab page While in Material Master Record Tax Category is appearing in sequence manner what we have assigned in Tax Determination Rule OVK1.

Defining Tax Determination Rules [OVK1]

Tax Ctry Seq Tax Category

IN India 1 JIVC IN A/R CST Payable

IN India 2 JIVP IN A/R VAT Payable

IN India 3 JSVD IN Servic Tax Payab

IN India 4 JEC3 IN Ecess on Serv tax

In Material Master Record it Appearing same As above

But in Customer master Record it Appearing alphabetically

Tax Ctry Tax Category

IN India JEC3 IN Ecess on Serv tax

IN India JIVC IN A/R CST Payable

IN India JIVP IN A/R VAT Payable

IN India JSVD IN Servic Tax Payab

This is appearing with my system or it standard process?

if it error then how i will make in sequence manner in CMR as per Tax determination rule

Regards

Arun

Edited by: arun biswal on Jul 20, 2011 9:20 PM

Edited by: arun biswal on Jul 20, 2011 9:21 PM

[Shiva_Ram]

This is appearing with my system or it standard process?

This looks standard process. Why you want to change the order? I would not recommend spending too much time on changing the sequence similar to material master, unless it really provides any benefit.

I further checked the include MF02DFX0 (for customer master) and in this include, after pulling the value from table TSTL into structure XKNVI, the values are sorted. So it is hard coded in the standard program.

Regards,

Edited by: Shiva Ram on Jul 20, 2011 3:01 PM

[Former Member]

Hi Arun,

I am facing the same issue, could you please tell me what is the solution.

Thank you

[Former Member]

Hi,

I had the same problem in my previous implementation. If the tax condition types in your customer master and material master are not in the same sequence, then your condition records would not behave properly. They would either throw out some junk values or multiple condition types may appear in your sales order.

To over come this, I have made the sequence of the condition types in material master through OVK1 T.code as the same order as the customer master condition types.

This resolved my problem and the condition records were correctly picked.

By doing this your issue also would be resolved. Please update the forum if you still face issues or if you use a different method to over ride this.

Regards,

Rohan Gudavalli

[Former Member]

Hi Rohan Gudavalli,

In My first message I v mentioned that in OVK1 it is in sequence manner it is appearing in Material master record properly but not in Customer Master record.

Thank you

Arun

[Former Member]

Hi Arun,

What I was saying is that, make the order of the condition types in Material Master same as in Customer MAster.

For ex: If the order in Customer Master is 1. JIVC, 2. JIVP, 3. JLSR; then in material master also maintain the same order through OVK1.

Please let me know if it still is not clear.

Regards,

Rohan Gudavalli