The specified record does not exist in the list

How to create the necessary items

QuickBooks has many fields that are drop down lists. The error means the value you entered is not in the drop down list of values. 

There is an invalid reference to the QuickBooks item.

It is possible the item does exist, but it is inactive or the item is beneath a parent. For more info, read this guide.

There is an invalid reference the InventorySiteRef "Boston"

Inventory site is on the line item of each sale:

1. In QuickBooks Enterprise, go to lists > inventory site list.
2. Click inventory site > new on the bottom.
3. Enter Boston as the name.
4. Click OK.

There is an invalid reference to QuickBooks Account "Sales" in the Item Non-Inventory.

Take a look at "How do I adjust the chart of accounts." This means you are missing an income account:

1. In QuickBooks Enterprise, go to lists > chart of accounts.
2. Click account > new.
3. Choose income.
4. Enter sales as the account name.

There is an invalid reference to QuickBooks AR Account "Accounts Receivable - USD"

Take a look at "How do I adjust the chart of accounts." This means you are missing an A/R:

1. In QuickBooks Enterprise, go to lists > chart of accounts.
2. Click account > new.
3. Choose other account type.
4. Choose accounts receivable.
5. Enter Accounts Receivable - USD as the account name.

There is an invalid reference to QuickBooks Customer "Retail Store - USD"

This means there is no customer by the name you are matching:

1. In QuickBooks Enterprise, go to customers > customer center on the top menu.
2. Click new customer.
3. In the name field, enter Retail Store - USD.

There is an invalid reference to QuickBooks InvoiceLineItem SalesTaxCode "E"

Sales tax code is the field tax on each order:

The error means no tax code called E exists:

1. Read this guide to enable QuickBooks sales tax.
2. On the top menu, go to lists > sales tax item list.
3. Click new.
4. In enter E.
5. Click OK.

There is an invalid reference to QuickBooks Item Sales Tax "G" in the Invoice

Item sales tax is the field on the bottom of QuickBooks. The error means no code called G exists:

1. In QuickBooks Enterprise, go to lists > item list.
2. Click new.
3. Choose sales tax item as the type.
4. Enter G.
5. Click OK.