|
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
|
|
| Insert into DepositLine revisted |
| Author |
Message |
| EdB |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2006-07-08 |
|
| Profile |
|
| Posted : 2006-07-09 21:03:40 |
I am getting an error when inserting a line into an existing Deposit.
I have been able to successfully deposit from undeposited funds using your example
elsewhere in this forum.
However, after I do some other processing I need to add a few line items to the deposit I made earlier.
I have followed your examples and think my syntax is right. the tail of the message dump is listed below.
Scanning to the red highlighted text, it appears to me that DepositLine will not allow insert of TxnID (much like the InvoiceLine bug in a previous version).
I have checked my INSERT statement and think all is well there. Has anyone been able to insert a line into an existing deposit (through DepositLine NOT Deposit, naturally)?
I know QB will fuss if there is no "Received From" given when doing multi-line deposits -- I have taken care to check that. Also, I am able to retrieve the proper TxnID for the Deposit I wish to append to, so I don't think the error is there.
Any ideas?
Message Dump Follows
====================
SetParameterValue
Char Parameter Id: 1 Value: [1D9A-1152440658]
SetParameterValue
Date Parameter Id: 2 Value: [2006-01-23]
SetParameterValue
Char Parameter Id: 3 Value: [480000-1150806320]
SetParameterValue
Char Parameter Id: 4 Value: [3C0000-1152130128]
SetParameterValue
Char Parameter Id: 5 Value: [990002-1151094943]
SetParameterValue
Numeric Parameter Id: 7 Value: [-42.00]
SetParameterValue
Integer Parameter Id: 8 Value: [0]
SetParameterValue
Char Parameter Id: 6 Value: [Cash Payout]
ISAMInsertRecord
0x0A44EBA0 [ISAM]
0x0A91CFF8 [DepositLine]
NO_ISAM_ERR 00000 00000
ISAMPutData
0x0A44EBA0 [ISAM]
0x0A91CFF8 [DepositLine]
COLUMN: 0 [TxnID]
SQL_C_CHAR
1D9A-1152440658
ISAM_FIELD_NOT_ON_INS S0000 00000 [QODBC] Field not allowed in insert.
ISAMGetErrorMessage
0x0A44EBA0 [ISAM]
S0000 00000 [QODBC] Field not allowed in insert.
ISAMClearUpdateRecord
0x0A44EBA0 [ISAM]
0x0A91CFF8 [DepositLine]
NO_ISAM_ERR 00000 00000
ISAMCloseTable
0x0A44EBA0 [ISAM]
0x0A91CFF8 [DepositLine]
NO_ISAM_ERR 00000 00000
ISAMCloseTable
0x0A44EBA0 [ISAM]
0x0B59E0E8 [CreditMemoLine]
NO_ISAM_ERR 00000 00000
ISAMClose
0x0A44EBA0 [ISAM]
NO_ISAM_ERR 00000 00000
ISAMClose
0x00176B58 [ISAM]
NO_ISAM_ERR 00000 00000 |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2006-07-10 08:52:25 |
The process of inserting into the DepositLine table normally applies an exising ReceivePaymentToDeposit.TxnID. For multiple lines you will need to perform all the inserts together applying a different ReceivePaymentToDeposit.TxnID for each line and using the FQSaveToCache caching flag set true (1) until the last line where it's set false (0).
Currently there is no DepositMod (or TxnMod) available in SDK5.0 used by USA versions of QuickBooks 2006 and DepositMod doesn't appear to have made the SDK6.0 new features list used by USA versions of QuickBooks 2007.
This means that you cannot use QODBC to add lines to an existing Deposit. One workaround is to DELETE the Deposit first (using the TxnID) and then re-create the whole deposit using the new values. |
|
|
|
|