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
|
|
Error: 3120 - Applying payments causes error |
Author |
Message |
|
Posted : 2007-03-06 02:52:14 |
This set of queries has been in place and working for almost two years. Last week a portion stopped working. This was designed using QODBC V3 and Quickbooks 2005 Pro. We have since upgraded to V7, but this still does not work. We have also applied all Quickbooks updates.
Process:
This Customer already exists.
Insert Invoice: Insert into InvoiceLine (CustomerRefFullName, InvoiceLineItemRefListID, InvoiceLineRate, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) Values ('TEST', '3A0000-1105028332', 425, 425, '20000-1057000111', 0)
Status: Working
Lookup transaction ID: select * from invoice where CustomerRefFullName='TEST' AND isPaid=0
Status: Working
Apply Payment: Insert into ReceivePaymentLine (CustomerRefFullName, DepositToAccountRefListID, TotalAmount, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, PaymentMethodRefFullName, TxnDate, FQSaveToCache) Values ('TEST', '360000-969038865', 425, '42C21-1173109418', 425, 'visa', {d'2007-02-23'}, 0)
Status: Throws error.
Error Details: ERROR [00000] [QODBC] Error: 3120 - Object "42C21-1173109418" specified in the request cannot be found.
Any thoughts? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-03-06 09:44:16 |
Providing you are using QuickBooks R9 and '42C21-1173109418' is a valid TxnID when you run:
select TxnID from invoice unoptimized where CustomerRefFullName='TEST' AND isPaid=0
The only reasons for the error is that the invoice is actually paid, the paid amounts don't match, or you have added another Accounts Receivable account to your company file. If that's the case, you will need to tell QuickBooks which Accounts Receivable account to use in: ARAccountRefFullName
|
|
|
|
|
Posted : 2007-03-07 04:07:34 |
I just wanted to let you know that our accountant did add another account without informing me. I have manually specified the account and it is working great again.
Thank you very much for your assistance. |
|
|
|
|