Knowledgebase
[QODBC-Online] Troubleshooting - How to change status of Invoice in QuickBooks Online
Posted by Jack - QODBC Support on 26 October 2015 07:10 AM

Troubleshooting - How to change status of Invoice in QuickBooks Online

Problem Description:

I had inserted into table ReceivePaymentLine, but it not changes status to "Paid"? How do I do it?

I using InvoiceLine for insert Item sales, and ReceivePaymentLine for payment

Solutions:

You can change Invoice status to paid by receiving payment for that Invoice. Please refer below sample query for receiving payment.

Insert into ReceivePaymentLine (CustomerRefListID,CustomerRefFullName, TxnDate, RefNumber, TotalAmount, PaymentMethodRefFullName,memo, DepositToAccountRefFullName, AppliedToTxnTxnID, AppliedToTxnPaymentAmount) values ('YourCustomerRefListID','YourCustomerRefFullName', 'YourTxnDate',' RefNumber which you want to use', YourTotalAmount, 'YourPaymentMethodRefFullName','Yourmemo', 'YourDepositToAccountRefFullName', 'TxnID of Invoice', 'Invoice Amount')

AppliedToTxnTxnID = TxnID of Invoice

AppliedToTxnPaymentAmount = Invoice Amount

For Example:

Insert into ReceivePaymentLine (CustomerRefListID,CustomerRefFullName, TxnDate, TotalAmount, PaymentMethodRefFullName,memo, DepositToAccountRefFullName, AppliedToTxnTxnID, AppliedToTxnPaymentAmount) values ('1951','CSS Online',{d'2013-02-05'},'1044',40.00,'Cash','Payment 2914','Undeposited Funds','3994',40.00)





(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).