I am inserting a record using the query below.  I get an error 3120 - object "24D63-1056992623" specified in the request cannot be found.  The object in question is the TxnId for an invoice.  When I query the invoice table for that invoice, it does exist and there are already rows existing in the receivePaymentLine table that have this ID in the appliedToTxnTxnID column. 

Can you help me determine why I am getting this error?

Thanks.

Insert into receivePaymentLine
 (customerRefListId, customerRefFullName,  appliedToTxnTxnID, TxnDate, TotalAmount,   RefNumber,   paymentMethodRefListId,   depositToAccountRefListId,   Memo)
values
 ('45F0000-1025192820','ART Co,'24D63-1056992623', {d'2006-06-06'},  10, '123', '20000-916432954', 'F70000-920993005', 'Memodata')

See also: How to I handle Customer credits on account? for more information on the procedure for receiving the payment before the Invoice.

I see.  The invoice I am referencing has isPaid = true.  That is why the error message says that it is not found.  Can't post a payment to a paid invoice.

Thank you for you help.

It's kind of hard to work out what's wrong with this complex method. Try stripping it back to the basics:

INSERT INTO ReceivePaymentLine (CustomerRefListID, DepositToAccountRefListID, TotalAmount, AppliedToTxnTxnID, AppliedToTxnPaymentAmount, TxnDate, FQSaveToCache) Values ('80001171-1228276005', '2D0000-1182395224', 100.00,
'8A6A1-1222137381', 100.00, {d'2008-11-03'} ,0)

and go from there. The "IsPaid" really applies to Invoice headers only.

What does:

Select * from Invoice where TxnID='8A6A1-1222137381'

return?

I need a screen dump of:

sp_columns invoice

and

sp_columns invoiceline

using VB Demo showing the columns of the table. (See: How do I upload images to my forum post? )