Product: Intuit QuickBooks (On-Premise)

Article Link: http://help.truecommerce.com/en/articles/6584020-intuit-quickbooks-error-there-is-an-invalid-reference-to-quickbooks-item-xxxxx-in-the-salesorder-line-quickbooks-error-message-invalid-argument-the-specified-record-does-not-exist-in-the-list

Error: There is an invalid reference to QuickBooks Item "xxxxx" in the SalesOrder line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.

Issue: When exporting an inbound Purchase Order (850) from your Trading Partner you receive the error 'There is an invalid reference to QuickBooks Item "xxxxx" in the SalesOrder line. QuickBooks error message: Invalid argument. The specified record does not exist in the list.'

Reason: The Item Code sent by your Trading Partner does not match your QuickBooks item code, or the Item Translation within your Item Catalog is not properly filled out.

Navigate (TM): Trading Parnters → (Partner) → Translations → Item Catalog

Navigate (QB): Lists → Item List

Add/Correct: the item list to properly match your Transaction's codes being sent by ensuring your QuickBooks item code is located in the Item Translation field while your Partner's item code is listed in the 2nd column (see below for more info)

Note: Make sure your Primary Item Field is properly selected in the dropdown list (bottom right) - if you do not see proper option within the dropdown or you've never configured the Primary Item Field for this partner - see Configuring Primary Item Field

Your Item Translation is referenced by the Primary Item Field which will always be the 2nd column within your Item Catalog - so whatever is in the 2nd column will always be referenced to try and perform a translation on an export.

rev 9/23/22