The specified name is either invalid or of the wrong type

Error Message

Error 3140 : While trying to Add a(n) SalesOrder with key value of 28672, QuickBooks responded There is an invalid reference to QuickBooks Customer "Mark Plummer" in the SalesOrder. QuickBooks error message: The specified name is either invalid or of the wrong type.

Problem

QuickBooks customers, vendors, and employees exist in the same database table. When you look at vendors, you're looking at a filtered list of records where the customer type is vendor. Customers can have a type of other. Our system cannot locate customers if their type is other.

Steps

You must change the customer type. Here are the steps:

  1. In QuickBooks' top menu, click lists > other names list.
  2. Locate the customer record.
  3. Double click the row.
  4. Click the change type button:change_type.jpg
  5. Select customer: 
    type.jpg
  6. When promoted that the change cannot be undone, click OK.

Vendor or Employee

You cannot have a customer who is an employee and a vendor. This happens when you buy something from a customer who bought something from you. To check if you have a vendor with the same name, follow these steps:

  1. In QuickBooks, go to vendor > vendor center.
  2. From the drop down, choose all vendors.
  3. Search for a vendor.
  4. If you find a match, rename the vendor: vendor.jpg

For employees the steps are the same. This error happens when you place test orders using an employee of your company.

Can I use the rules engine to change the company name?

You could say if the company was Windsor, then map the sale to Windsor orders. Here are the steps:

  1. Go to the Connex rules engine.
  2. Click action and add new rule.
  3. As the action, choose replace billing company name.
  4. As the comparison, choose matches.
  5. Enter a map from and a map to value.

Can I sync the order under another customer name?

Yes, you can sync the order under a customer called web store:

  1. Login to Connex.
  2. Click manage.
  3. Expand the first area.
  4. Enter the order number into the order number list field.
  5. Expand customer.
  6. Choose single name.
  7. Click save.
  8. Run the web connector.
  9. Return to Connex and change the customer setting.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.