InvoiceAddRs 3140 - There is an invalid reference to QuickBooks Item in the invoice line
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 Item - There are several categories, but Non-Inventory seems to make the most sense. Make sure the name matches Projector and that an account is set.
QuickBooks Desktop
To add an Item to QuickBooks desktop edition.
- Go to Lists | Item Lists
- Add a new Item. Make sure that the Name matches Projector and that it is mapped to the proper account number.