Oracle NetSuite sync error: Invalid reference of item, XXXX in the Invoice

Why the sync error occurs

The following are possible causes for this sync error:

  • An object (Vendor, account, item, etc…) on the bill or invoice is not shared with the proper subsidiary
  • The item is either inactive or has been deleted
  • The account type of the GL is incorrect
    • The account selected is a Cost of Goods Sold (COGS) type and Oracle NetSuite is configured to prevent bills from being coded to COGS
  • If using the Oracle NetSuite AR sync feature, the item selected on the invoice is a shipping item

How to fix the sync error

The Subsidiary doesn't match

There are four potential solutions based on the situation:

  • Make sure the object is shared with the subsidiary you are syncing with in Oracle NetSuite
    • If the object is shared with the appropriate subsidiary, contact Customer Support to resync the object
  • Reactivate the inactive object
  • If the object is deleted in Oracle NetSuite, contact Customer Support to resync the object to Oracle NetSuite
  • Select the appropriate active object that's associated with the subsidiary you are syncing with

The item is inactive or delete

There are two potential solutions based on the situation:

  • Reactivate the item in Oracle NetSuite
  • Select the appropriate active item in PayMaker

The account type is incorrect

There are two potential solutions based on the situation:

  • Change the account
  • Change the configuration in Oracle NetSuite to allow bills coded to COGS
    • If you need assistance with this, please contact Oracle NetSuite Support

The item selected is a shipping item

  • Remove the shipping item from the invoice in PayMaker to allow the invoice to sync to Oracle NetSuite. Once the invoice has synced, select the shipping item on the invoice in Oracle NetSuite.