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
|
|
Help with inserting deposits |
Author |
Message |
|
Posted : 2007-05-01 08:24:08 |
We are attempting to insert a deposit transaction into QuickBooks 2007 Pro using QODBC 7.00.00.207 (evaluation version). By analyzing deposits entering into QB via its user interface, it appears we need to insert a row into the Deposit table and a row into the DepositLine table (we do not want to go through Undeposited Funds).
We have been successfully able to insert a row into DepositLine using an INSERT statement similar to the following:
INSERT into DepositLine ( TxnDate, DepositToAccountRefFullName, Memo, DepositLineEntityRefFullName, DepositLineAccountRefFullName, DepositLineMemo, DepositLineCheckNumber, DepositLineClassRefFullName, DepositLineAmount) VALUES ( {d '2007-04-20'}, 'Checking Account 1', 'Deposit Test', NULL, ' 'Income:Rent Income', 'Rent Batch Test', NULL, 'ABC123', 1234.56)
However, attempts to insert into Deposit using similar to:
INSERT into Deposit ( TxnDate, DepositToAccountRefFullName, Memo, DepositTotal) VALUES ( {d '2007-04-20'}, 'Checking Account 1', 'Deposit Test', 1234.56)
fail with the message
Child Record must be inserted before Header Record in BuildXMLHeader
This error occurs whether we try to insert into Deposit before or after inserting into DepositLine, so we're unsure what child record the message is referring to.
Does anyone know the proper way to insert a matching pair of Deposit and DepositLine rows? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-01 10:26:19 |
|
|
|
|
Posted : 2007-05-02 00:00:21 |
Thanks, Tom, that was exactly the information we needed. |
|
|
|
|