how can apply line item wise TDS in purchase invoice
Does TDS RATE differs on each Line? if not there is no need to go and tabulate Withholding tax on line line.
If yes, then customization is needed.
Hey, I face a similar issue. To customize it, this is the idea which I have in my mind:
- Create a new-field in Item line called
TDS Rate. - Then, when the invoice is submitted, invoke a script to calculate net tds payable.
But before implementing, I would like to validate my idea. Is this approach a correct one? Or is there a better approach?
Hi @rish4ck
The item tax template can serve the purpose if you could use them with negative rates which then can deduct respective percentage of each item line and book in respective TDS accounts defined in each item tax template on purchase invoice doctype automatically.
knowing the fact item tax template can be set on items and item group level as well.