Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Problem adding EmployeeEarnings to existing employees |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-03-09 08:20:55 |
If I execute the following two statements I am able to add a line in the EmployeeEarning table to an existing employee that was already in the EmployeeEarning table (I am using the sample company).
UPDATE "EmployeeEarning" SET PayrollInfoEarningsPayrollItemWageRefListID = '10000-933272656', PayrollInfoEarningsRate = 41500.0, FQSaveToCache = 1 WHERE "ListID" = '370000-933272659'
UPDATE "EmployeeEarning" SET PayrollInfoEarningsPayrollItemWageRefListID = '50000-933272657', PayrollInfoEarningsRate = 20.0, FQSaveToCache = 0 WHERE "ListID" = '370000-933272659'
The first UPDATE statement is the data that is already in the table and the second contains the data for the new line.
Why am I able to do add a line this way to the EmployeeEarning table and add a new employee to the EmployeeEarning table, but not be able to add a line to an existing employee that is not in the EmployeeEarning table?
I scanned through the QuickBooks SDK and online forum and it seems that this should be able to be done as long as I can provide the employees ListID.
This seems to be an issue with QODBC and not with QuickBooks.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-03-09 08:21:52 |
You are correct, there are currently some issues with QODBC v6.00.00150 with Inserts with TxnID and ListID as the first field. In the next update we think we will have them all fixed.
Once that's done you should be able to add a new rate to an employee with:
INSERT INTO EmployeeEarning (ListID, PayrollInfoEarningsPayrollItemWageRefListID, PayrollInfoEarningsRate) VALUES ('300000-934380930', '20000-934380928', 40000)
as originally documented. |
|
|
|
KofK |
|
Group | : Members |
Posts | : 43 |
Joined | : 2006-04-04 |
|
Profile |
|
Posted : 2006-04-04 05:15:31 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-04-04 09:19:44 |
Yes, we have corrected issues with using TxnID/ListID as the first field in an insert to append a line as part of the Release 6.0.0.155 Fixes
To download the latest release of QODBC, click on the download button here :-
|
|
|
|
|