TDS and WCT to be deducted on different amount of Prepayment Invoice

@10%

 Hi Experts,

Can you please provide me solution on this issue.

Say : Prepayment Invoice is made of Rs 100000, now TDS is to be deducted on this @10% on Rs. 100000 and WCT is to be deducted on Rs. 80000 @4%

Prepayment Invoice = 100000,  

TDS on 100000 @10%= 10000

WCT on 80000 @4% = 3200

Total payment will be 100000-10000-3200 = 86,800.00

Now this advance is to be applied to Standard Invoice of Rs. 500000

Now when TDS is deducted and applied to Invoice, this is coming as 50000, should be less by 10000 already paid and wcT is coming as 20000 should be less by 3200 already paid.

Please help how can i achieve this situation.

Regards

sachin