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.