unresolved NetSuite issues currently faced across the Group NetSuite OneWorld environment (India Localization / legacy tax). India localization SuiteTax bundle is already implemented.
Summary
When a Vendor Prepayment (VPP) on which TDS was deducted at the advance stage is applied against a Vendor Bill, NetSuite applies only the Basic + GST portion of the prepayment. The TDS leg already deducted at the advance stage is not reversed in the Vendor Prepayment Application, so the full prepayment value (Basic + GST + TDS) cannot be applied and a TDS balance remains stranded on the vendor account.
Consequence: the advance is never fully knocked off, the vendor sub-ledger does not tie to the trade payable, and TDS on the advance is effectively double-counted against TDS on the bill — a reconciliation and compliance exposure. The issue is consistent, reproduces in Production and Sandbox. no workaround exists.
Figure 2 — The TDS leg of the advance is not reversed on application and is left stranded.
3.2 Worked example (simplified full application)
Advance basic 100, TDS 10, bank-out 90; Bill expense 100, GST 18, TDS 10. Expected: applying the advance reverses the advance TDS leg so net payable on the Bill = 18 and the advance (incl. the TDS leg of 10) is fully knocked off. Actual: only the Basic + GST leg (90) is applied; the TDS leg (10) stays open on the vendor.
3.3 Expected TDS treatment by scenario
Scenario | Expected behavior |
|---|
Same TDS period (TDS on VPP and Bill) | Application must reverse the advance TDS leg, so TDS is not charged twice and the advance fully clears. |
Different period (advance TDS already deposited for a closed period) | Do NOT reverse in the application entry; the double deduction is handled outside the application. |
No TDS on the Bill | No reversal required. |
3.4 What we are asking
- Allow the full VPP value, including the advance-stage TDS, to be applied against the Vendor Bill (full and partial application).
- Reverse the advance TDS leg in the application per the scenario rules above, so TDS is not double-counted.
- Result in a clean vendor ledger with no stranded TDS, tying to the trade payable; reproducible in Sandbox before Production.
- Advise whether this is achievable via native SuiteTax/TDS configuration or requires changes to the existing prepayment/bill customizations, with effort and risk.
- Solution for Service as well as material items.