Tax percentage logic in report

[former_member431487]

Hello experts,

We are developing a new report for tax purpose. In the report we have a field Tax percentage. At present we are passing Tax type, Tax code and country in A003 table for getting condition record number. Then we are passing this condition record number and tax code in KONP table and picking the rate.

But there are few limitations in this logic - If one tax code is having two condition types and two condition records then we are picking only first condition record since in our report tax percentage field is a single value field. Secondly, when we are passing tax code and condition record in KONP table if we get multiple tax rates under one condition record then we are picking only first condition tax rate. Here we are not passing sequence number since it is not available anywhere.

Any suggestions on how to overcome these limitations would be highly appreciated.

Regards,

Karan

[phanikumar_v3]

Dear

You will check the Condition record number in KONP only to see tax percentage used?

Then Go to V/06--Select your Tax condition type--Go to Records Tab(Under Access sequence field)--Enter the required Details--then you can see all the Percentages maintained.

Hope this helps.

Phanikumar

[former_member431487]

Hi Phanikumar,

In the Records tab it will show all the condition records that have been maintained for that particular condition type. We cannot uniquely identify tax percentage unless we know which condition record to pick. That is the reason we are passing condition number in KONP. But problem there is that we do not get sequence no. value anywhere so if we get multiple entries in KONP for a particular condition no. then again we cannot uniquely identify tax percentage.

Regards,

Karan

[Lakshmipathi]

Pass that condition record number in KONH where you have validity dates.  Check whether this helps you.

G. Lakshmipathi

[former_member431487]

Hi Lakshmipathi,

Thanks for the quick reply.

In KONH we don't get the tax rate field. It only gives the date when the condition record was created. In KONP we have a field Sequence number. If we can find out from where to pick that value then we would be able to identify multiple tax rates for same condition record.

Regards,

Karan