When syncing an AR item to QuickBooks you may encounter the following failure: Error for InvoiceAddRs: Status Code = 3140: There is an invalid reference to QuickBooks Item "XXX" in the Invoice line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.
This will occur for taxes that do not have a corresponding item mapped to an account in QuickBooks. In this example, we are mapping:
- VAT-UK in Projector -> VAT-UK Item in QuickBooks -> Account 2050 in QuickBooks
Projector
If QuickBooks already has an item ready for Projector, then you'll need to make the correction in Projector.
- Go to Administration tab | Job accounting subsection | Tax Types blue dot.
- Edit your tax type and in the accounting section correct the mapping
- Reapply mappings on your failed transaction and resend it
QuickBooks Online
If you need to prepare an Item in QuickBooks, follow these steps.
- Go to Gear icon | Products and Services
- New or Edit an Existing Item
- There are several categories, but Non-Inventory seems to make the most sense.
QuickBooks Desktop
Go to Lists | Item Lists
Add an Item that points at the appropriate QuickBooks account.
