search

consolibyte / quickbooks-php

QuickBooks Integration for PHP
Eclipse Public License 1.0
457 stars 338 forks source link

3140: Invalid Reference to QuickBooks Customer #256

Closed leech-coder closed 5 years ago

leech-coder commented 5 years ago

QBWebConnector_NR8iyNa4kB

The queuing order of our data to QuickBooks is:

  1. CustomerAdd
  2. ItemNonInventoryAdd
  3. InvoiceAdd

For some reason, the Web Connector syncs the Invoice before the Customer which returns the invalid reference error.

chrome_5Y3M2KIYI6

The leftmost column is the quickbooks_queue_id.

leech-coder commented 5 years ago

The same thing happens with ItemNonInventoryAdd; the Web Connector syncs the InvoiceAdd before the ItemNonInventoryAdd.

3140: There is an invalid reference to QuickBooks Item in the Invoice line. The specified record does not exist in the list.

This seems to be random. Some Invoice appear successfully on QuickBooks Desktop.

consolibyte commented 5 years ago

To me it looks like the priority on each of those is 0, correct?

Which means the order that things process in is essentially random.

Did you set priorities for each of those queued items?

leech-coder commented 5 years ago

To me it looks like the priority on each of those is 0, correct?

Thanks for pointing that out. I was solely relying on the quickbooks_queue_id.