Search code examples
quickbooksqbxml

Cannot add Invoice in QBXML request due to the Customer FullName

When sending a CustomerQueryRq in qbxml, it returns:

    500: The query request has not been fully completed. 
There was a required element ("Client Name") that could not be found in QuickBooks.

So then I send a CustomerAddRq that returns:

3100: The name "Client Name" of the list element is already in use.

And the InvoiceAddRq fails saying:

            3140: There is an invalid reference to QuickBooks Customer "Client Name" 
    in the Invoice.  QuickBooks error message: The specified name is either 
invalid or of the wrong type.

How could the Customer with FullName "Client Name" already be in use, but then it is not found when trying to add an Invoice for that Customer?

Am I misinterpreting these error messages?

Solution

  • This is your answer right here:

    • The specified name is either invalid or of the wrong type.

    This tells me that there is NOT a customer with that exact name, but that there's a VENDOR or an EMPLOYEE or a OTHER NAME entry with the same name.

    The Name field in QuickBooks is a UNIQUE key across Vendors, Employees, Other Name entries, and Customers.