NetSuite: “Invalid incomeaccount reference key 119” on Product Create — How to Diagnose & Fix

Summary

Creating/syncing a Product (Item) from Ordway to NetSuite fails with:

INVALID_KEY_OR_REF: Invalid incomeaccount reference key 119.

This indicates the Income Account referenced in the payload cannot be resolved by NetSuite (wrong/invalid internal ID, restricted, or inactive). Fix the account reference and re‑sync.



How to Diagnose (NetSuite)

1. Show Internal IDs
   • Home → Set Preferences → General → Defaults → Show Internal IDs = ✓.
2. Locate Account 119
   • Lists → Accounting → Accounts and filter Internal ID = 119, or use Global Search account:119.
3. Validate the Account
   • Type: Income (e.g., Income, Sales, Other Income).
   • Posting: Must be posting (not a summary).
   • Active: Not inactive.
   • Subsidiaries: Includes the item’s subsidiary (OneWorld).
   • Permissions: Visible to the integration role.
4. Audit Mapping Source
   • In Ordway, confirm where the Income Account is sourced (product default, plan mapping, or custom field). Ensure it passes the internalId that exists and is permitted in NetSuite.
      

Re‑Sync

1. In Ordway, open the failed item sync in Logs → Webhooks or the Product page.
2. Click Retry once account fixes are in place.
3. Verify the item is created/updated successfully in NetSuite.