I have problems with adding a receive payment line to the existing payment
I have existing payment. So there is a record in ReceivePayment table and there is a record in the ReceivePaymentLine table. TxnID - '2F8-1182934315' AppliedToTxnTxnID - '15C-1182424526' AppliedToTxnAmount - 1 TotalAmount - 2.8 UnusedPayment - 1.8
I tried to enter new ReceivePaymentLine for the existing ReceivePayment using the following SQL command INSERT INTO ReceivePaymentLine (TxnID,AppliedToTxnTxnID,AppliedToTxnPaymentAmount,FQSaveToCache) VALUES ('2F8-1182934315','163-1182424527',0.2,0) The SQL query is executed successfully but instead of adding the new line it replaces the existing record in the ReceivePaymentLine table.
So I cannot add the second line to the existing payment.
Do I do something wrong? Please help.
I am using QODBC version - 7.00.00.214 QuickBooks version - 2007 Enterprise
|