Invalid Reference Id : Product/Service assigned to this transaction has been deleted.
This article helps Webgility Online users resolve the ‘Invalid Reference Id: Product/Service Assigned to This Transaction Has Been Deleted’ error, which occurs when the product or service item linked to the transaction has been deleted, marked inactive, or is no longer recognized by the QuickBooks Online system.
Overview:
The error “Invalid Reference Id: Product/Service Assigned to This Transaction Has Been Deleted” occurs when attempting to remove or roll back a transaction in QuickBooks Online. This issue arises because the product or service item tied to the transaction is no longer available, it may have been deleted, marked inactive, or its reference ID no longer matches any current records in QuickBooks Online.
When this happens, QuickBooks Online cannot recognize the item associated with the transaction, leading to a failed operation of Unpost in Webgility Online.
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 in Quickbooks Online.
-
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 Online
-
Log in to Webgility Online:
Access your Webgility Online 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 in QuickBooks Online. This could be causing the invalid reference error.
Step 2: Activate 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 inactive item. Mark it active again.
-
Create New:
If item is not there, proceed to recreate it. 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: Download latest items from QuickBooks by following the article: Download the Latest Data from QuickBooks in Webgility Online
Step 5: Now try to perform undo sync on the order in Webgility Online.