Invalid Reference Id : Product/Service assigned to this transaction has been deleted.
Intro:
If you encounter the "Invalid Reference Id: Product/Service Assigned to This Transaction Has Been Deleted" error, it usually means that a product or service item linked to your transaction no longer exists. This typically occurs when an item has been deleted or if the reference ID in the transaction does not match any current entries. Learn how to resolve this issue by re-adding the missing item, ensuring that your transactions are processed smoothly and without interruption.
Causes of Issues:
Deleted Product/Service Item: The error typically occurs when a product or service item assigned to a transaction has been deleted from your inventory or service list.
Incorrect Reference ID: If the reference ID in the transaction does not match any existing items, it may result in this error.
Steps to Resolve the Issue:
Step 1: Verify Item Details in Webgility
Log in to Webgility:
Access your Webgility account.Review Order Details:
Go to the order that is showing the error. Check the details of the items listed in the order to identify which product or service is causing the issue.Check for Canceled Items or Accounts:
Determine if the item or associated account has been canceled or deleted. This could be causing the invalid reference error.
Step 2: Recreate the Deleted Item in QuickBooks Online
Open QuickBooks Online:
Log in to your QuickBooks Online account.Navigate to the Sales Section:
Click on "Sales" in the left-hand menu.Go to Products & Services:
Select "Products & Services" from the Sales menu to see your list of items.Search for the Deleted Item:
Look through your list of items or use the search bar to locate the missing item. If it’s not there, proceed to recreate it.Click New:
In the Products & Services list, click on "New" to add a new item.Select Item Type:
Choose "Non-inventory" or "Service" based on the type of item that was deleted.Enter Item Details:
Name: Enter the name of the item as it was before.
SKU: Add the SKU if applicable.
Category: Select the appropriate category for the item.
Description: Provide a description for the item.
Sales Price/Rate: Enter the price or leave it blank if it varies.
Income Account: Choose the income account you were using for this item.
Set Sales Tax:
Configure the sales tax settings:Nontaxable: If the item is tax-exempt, select "Nontaxable."
Special Tax Rate: Choose a specific tax rate if applicable.
Save the Item:
Click "Save and Close" to add the item back to your list.
Refer to the following article for any help in this regard:
Step 3: Update Affected Transactions
Locate the Transaction:
Go to the transaction (invoice, sales receipt, etc.) where the deleted item was used. You can find this under "Sales" or "Expenses" depending on the transaction type.Edit the Transaction:
Open the transaction and find the section where the deleted item was listed.Replace or Re-add the Item:
If the item has been recreated, select it from the dropdown list. If not, you may need to add a new item or update the transaction with a different item.Save the Transaction:
After updating, click "Save and Close" to save the changes.
Step 4: Verify and Test
Check for Errors:
Ensure that there are no more errors related to the deleted item in your transactions.
By following these steps, you should be able to address the "Invalid Reference ID" issue and ensure your transactions are properly updated and posted in QuickBooks Online.
Please contact our support team if you have any questions or need more help.