Skip to Content
0
Former Member
Mar 11, 2009 at 08:57 AM

Formula Based TDS/WHT

22 Views

Hi Team

In our scenario, the slab for TDS/WHT is as below:

Amount Rate

<100,000 - Nil

100,000 u2013 500,000 - 1% of total amount (incl first 100,000)

500,000 u2013 15,00,000 - 2.5%

15,00,000 u2013 25,00,000 - 3.5%

Above 25,00,000 - 4.0%

Have maintained the below in Formula calculation and min base of 100,000.

500,000.00 1.00 -

1,500,000.00 2.50 500,000.00

2,500,000.00 3.50 1,500,000.00

999,999,999,.00 4.00 2,500,000.00

But the requirement is that if the Vendor total value reaches the next slab, then for the earlier invoices also the current slab rate should be charged and adjusted

For e.g.: First invoice of 500,000 the TDS/WHT would be 5,000 at 1%. For the next 10,000, since the total amount exceeds 500,000 the rate has to be 2.5 of entire invoice (incl earlier) of 510,000 = 12,750 less earlier deducted of 5,000 and current TDS = 7,750

How to address this in SAP

Thank You,