I would like to receive a partial payment for an invoice. I do a receivepaymentline for the invoice and everything looks good. However,  When I need to receive another payment for the same invoice. What do I need to do. The driver does not allow another insert with the same 'AppliedToTxnTxnID' or does not allow me to update the record.

Please help.

You currently cannot add a receive payment line to the existing payment using QODBC. However, using QuickBooks 2007 you can now modify payments. This support is for QuickBooks 2007 or higher only.

The normal procedure would be to create a new invoice, say for $200:

INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber",
"InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate",
"InvoiceLineAmount", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache")
VALUES ('800000AC-1197769434', 'QODBCcip1', '250000-933272656', 'Bin Permit Renovations',
200.00000, 200.00, '20000-999022286', 0)

Get the TxnID for the invoice:  Invoice TxnID: 5C9A-1197769588

RECEIVE THE PARTIAL PAYMENT of $100 using the AppliedToTxnTxnID as the Invoice TxnID.

INSERT INTO ReceivePaymentLine (CustomerRefListID, DepositToAccountRefListID, TotalAmount,
AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, Memo)
Values ('800000AC-1197769434', '80000-933270541', 100.00, '5C9A-1197769588', 100.00,
{d'2007-12-15'}, 'Payment Line 1 for Invoice #QODBCcip1')

After the payment is received, get the TnxID: ReceivePayment TxnID: 5C9E-1197769962

Add a second payment line for the remaining $200 using the ReceivePayment TxnID as the TxnID:

INSERT INTO ReceivePaymentLine (TxnID, CustomerRefListID, DepositToAccountRefListID, TotalAmount,
AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, Memo)
Values ('5C9E-1197769962', '800000AC-1197769434', '80000-933270541', 200.00, '5C9A-1197769588', 100.00,
{d'2007-12-15'}, 'Payment Line 2 for Invoice #QODBCcip1')

And instead of adding a second line the second insert replaced the first insert instead. In other words this insert is doing an update operation with QODBC v7.10.00.231.

This is bug and it has been posted to the QODBC Software Engineer's bug list for correction on QSupport Ticket ID: BR00000063 Dated: 28 Jun 2007 12:40:34. I don't have a time frame or release rev for the fix. I will advise when the fix is avaliable. But if your using QuickBooks 2007 you can currently simply overwrite the payment amount if you want to.

I posted this question how do I receive a second partial payment.

It was explained from the abouve reply that a bug existed and I needed to recreate an insert command which will overwrite the original. That it will only work on Quickbooks 2007 or greator.

I am using the Quickbooks-Premier Accountant Editiona 2008 and the second insert will not take.

I tried both the below inserts the ID's are correct the original payment was for 2120 and the amount due is for 2125. The below inserts did not change the TotalAmount from 2120 to 2125.
Please explain.

INSERT INTO ReceivePaymentLine (TxnID, CustomerRefListID, DepositToAccountRefListID, TotalAmount, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, Memo) Values ('5-1208979737', '80000001-1208979721', '80000009-1208979163', 2125, '1-1208979730', 5, {d'2008-02-09'}, 'Payment 2')

INSERT INTO ReceivePaymentLine (TxnID, CustomerRefListID, DepositToAccountRefListID, TotalAmount, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, Memo) Values ('5-1208979737', '80000001-1208979721', '80000009-1208979163', 2125, '1-1208979730', 2125, {d'2008-02-09'}, 'Payment 2')     

Thanks

Richard Boyd  

What I am trying to say is that the second insert did not replace the first. Nothing happened to the first insert. In fact, after running the second insert all sorts of wierd error messages occured and the server needed to be rebooted on both tries.

Any suggestions

Richard Boyd

The QODBC Software Engineer's response is: "This has never worked for ReceivePaymentLine and I question the need for it (I guess if the check amount was entered wrong). I tried to turn on the flag that should allow it to work but it has some issues that I have to debug through. Even if I get it working in new build you would not be able to apply two payments to the same invoice on same receive payment record. But changing the total amount and adding a second invoice to pay should be possible after the fix."