Bad Debt and Recovered Bad Debt Checkboxes: Bulk Update via CSV Import or Mass Update

What changed

Two body-level checkboxes are available on transaction records to support Philippines VAT Form 2550Q reporting:

• Bad Debt — available on journal entries. Select this when writing off an uncollectible receivable so the amount flows into Box 35 (Output VAT on Uncollected Receivables).
• Recovered Bad Debt — available on journal entries and customer payments. Select this to reverse a prior write-off, feeding Box 36 (Output VAT on Recovered Uncollected Receivables).

Transactions with these boxes correctly set are captured by the Philippines Recovered Uncollected Receivables saved search, which drives the 2550Q output. If existing journal entries or customer payments were created before these fields were exposed—or were simply never flagged—the search results and the quarterly VAT return will be incomplete.

What to do

1. Audit existing transactions. Run the Philippines Recovered Uncollected Receivables saved search and compare results against your GL to identify journal entries and customer payments that should carry the flag but do not.
2. Bulk-update via CSV Import. Export the affected transactions, add columns for the Bad Debt and/or Recovered Bad Debt fields set to T, and re-import using the standard CSV Import tool. Map to the journal entry or customer payment record type accordingly.
3. Bulk-update via Mass Update. Navigate to Lists > Mass Update > Mass Updates, select the relevant transaction type (Journal or Customer Payment), filter to the target population, and set the checkbox field value.
4. Validate. Re-run the saved search after the update and confirm that Boxes 35 and 36 on the 2550Q reflect the corrected totals.

Technical notes

• The source documentation does not specify internal field IDs for these checkboxes. Before scripting against them (e.g., via N/record setValue), inspect the journal entry and customer payment records in the Records Browser or use record.getFields() at runtime to confirm the IDs. Likely candidates are custbody_bad_debt or a similar custbody_ / native field—verify in your account.
• If you are programmatically creating journal entries or customer payments via SuiteScript or REST/SOAP web services, add the checkbox field to your create/update payloads to avoid manual backfills.
• This feature is specific to the Philippines localization. It has no effect on accounts that do not use Philippines tax reporting.