Hello Team,
We are working on a NetSuite reporting and notification requirement related to TAR items within Item Groups on invoices.
Requirement:
- Identify TAR items (item name contains
.TAR) on invoices only when the payment for those items is completed. - Trigger an email notification when the payment is done, indicating that the paid amount relates to TAR items.
Current Setup:
- We have created an Invoice (Transaction) saved search that correctly lists TAR items where quantity is greater than zero. below I have attached screenshot
- TAR items are part of Item Groups on the invoice.
- We are working on a workflow to trigger an email when payment is received.
- Payments in our account are recorded as Payment records (not Customer Payments).
Issue / Limitation Observed:
While a payment is linked to the invoice, NetSuite does not provide visibility into which specific invoice items the payment applies to. Payment information is available only at the invoice header level, not at the item (line) level.
Because of this limitation:
- We cannot reliably identify which TAR items are paid within a partially paid invoice.
- We cannot accurately trigger an email specifically for paid TAR item amounts using standard saved searches or workflows.
Question to the Community:
- Is there any standard NetSuite approach (saved search, workflow, or configuration) to determine payment status at the invoice item level?
- Is it possible to trigger an email notification specifically when a TAR item amount is paid?
- If this is not supported natively, is customization (custom fields/scripts) or process redesign (separate invoices, billing structure changes) the only recommended solution?
Any guidance or best practices would be greatly appreciated.
Thank you,