Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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 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
Tip
titleProjector

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

Tip
titleQuickBooks 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
    Image Removed 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.

 

 

 

Tip
titleQuickBooks Desktop

 Go To add an Item to QuickBooks desktop edition. 

  • Go to Lists | Item Lists
    Image Modified
 
  • Add
an Item that points at the appropriate QuickBooks account
  • a new Item. Make sure that the Name matches Projector and that it is mapped to the proper account number.
    Image Modified