Open bills report showing tax withholding lines (ISR / IVA) as open even though bill is marked "Paid in Full" — how do I clear the AP subledger?
Running NetSuite for a Mexico subsidiary. We have a large number of vendor bills from 2023 where the main AP line (account 20200002) has been paid and the bill shows Paid in Full, but the withholding tax lines on accounts 20520003 (ISR 10%) and 20510006 (IVA 2/3 partes) still appear as open on our Open Bills aging report.
Background on what happened: when we originally paid the withholding taxes to SAT, the JE that debited those accounts was posted without a vendor tag. So the GL balance is correct, but the AP subledger still sees the original bill credits on those accounts as open because there's no vendor-tagged debit to match against them.
I tried posting a correcting JE with the following structure:
Debit 20520003 / 20510006 [with vendor] → line ID 0
Credit 20520003 / 20510006 [no vendor] → line ID 1
The JE uploaded successfully but I still can't close the bill. Since the bill shows "Paid in Full" I can't apply anything directly to it through the normal payment flow.
Any idea how to handle this?