Knowledgebase
[QODBC Desktop] Troubleshooting - There was an error saving an Employee List
Posted by Ricky - QODBC Support on 23 January 2020 02:09 PM

[QODBC Desktop] Troubleshooting - There was an error saving an Employees List. The address is invalid

Problem Description:

We have searched the wiki, internet and tried endlessly to 'Insert an Employee'.

Below is our latest effort all to no avail-

Insert into Employee (FirstName, LastName, EmployeeAddressAddr1, EmployeeAddressAddr2,EmployeeAddressState,EmployeeAddressPostalCode) Values ('Jake','Wrestl','123 Main','456 stand','FL','12345')

I do not know what is wrong.

Can you shed some light on the error below and 'More Simply' provide a Sample to 'Insert an Employee'?

 

Solutions: 

The solution is to include the field 'EmployeeAddressCity' in your SQL statement.

For Example:

Insert into Employee (FirstName, LastName, EmployeeAddressAddr1, EmployeeAddressAddr2,EmployeeAddressState,EmployeeAddressCity,EmployeeAddressPostalCode) Values ('Jake','Wrestl','123 Main','456 stand','FL','Coral','12345')

You will be able to view newly added Employee record in QuickBooks application.

 

Go to QuickBooks, and you will see the Employee has been added.

 

In the "Address & Contact" tab, you will see the city information added in QuickBooks.

 

"EmployeeAddressCity" field is not mandatory to use when Inserting an Employee record, but there are specific fields that are conditionally required.

For Example:

If you specify FirstName, the Last name is optional. Either FirstName or LastName is required.

 

 

Tags: Employees, Employee insert

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).