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.

Open

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

Open

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.

• Open

  

QuickBooks Desktop

To add an Item to QuickBooks desktop edition. 

• Go to Lists | Item Lists

  Open

  

• Add a new Item. Make sure that the Name matches Projector and that it is mapped to the proper account number.

  Open