Changing Tax Code rule in OB40 impact other countries

[Former Member]

In all 5 Countries use same Chart of Accounts. Till now the requirement for all Countries was to have single GL for all Output tax codes . Thus currently in OB40 for Tranasaction key MWS there is no rule activated. Now out of 5 only 1 Country want to define different GL accounts Tax codes wise.

If we activate the rule for Tax Code & define different GL for different tax codes of that single country only & not for other countries tax codes , then GL assignment for tax codes for other Countries are overwritten & thus they don't have any GL assigned . Thus table T030K for remaining 4 countries become blank

In such scenario will I have to update all the tax codes for all the 5 countries? There are in all 150 tax codes combining all 5 countries

Is there any workaround for same

[former_member191939]

Hi Gauri,

In OB40 either you can assign the GL on COA basis or on the basis of Tax code, In your scenario you need to assign the GL according to Tax code only.

Yes you need to update all the tax codes for all 5 countries with GL. You can make the file in excel and then just copy and paste in OB40,there is little bit of work in this but you can't have any other work around for the same I suppose.

Hope this makes the things clear.

Regards

Eugene

[Former Member]

Hi Eugene

Thnx for ur input. But its not fisible to manually enter all the tax codes for all the countires.. Also in which table I will get detail about Tax code,country/ co.code, account key & GL account.

There must be some workaround for this...

Could anyone provide their valuable inputs

[sanilbhandari]

Hi Gauri

The only option is to assign GL Accounts based on tax codes. So you will have to use the below steps:

1. Use seperate tax codes for each country. The tax codes must be specific to a country. You can get the tax codes for a country from T007V table

2. Now in OB40 change the tax rules to assign GL Accounts based on tax codes for the same operating chart of accounts.

If you cannot work with the above standard configuration, than you can also write a substitution through an user exit. In such a case, read the Country of the company code. Now in a custom table maintain the GL Accounts based on Country and tax code combination. Make sure you allow HKONT field to be substituted in Maintenance view of Table GB01 for substitution class 9. You may refer to the below link to write a substitution rule using an user exit.

Creating user exits for substitutions - ERP Financials - SCN Wiki

I still feel that option 1 through configuration is a much easier and proper way to tackle this. I am supporting a project, which uses the same Operation chart of accounts for almost 45+ countries in Europe, Asia and Americas. So i really do not see much of a issue here.

Regards

Sanil Bhandari

[Former Member]

Hello Sanil

Thanks for your inputs.

So I will have to extract all the existing tax codes for all countries & maintain them in OB40..

There are some countries which use the same COA but are no more live...

In case of such countries will there be any need to update the changes ?

Regards

Gauri Ranade

[former_member191939]

Hi Gauri,

If the countries are not operational then there is no need of updating the same in OB40 and if it becomes live in near future then you can definitely add them in OB40 at any point of time.

Regards,

Eugene