Knowledgebase: Syntax
[QODBC-Desktop] Troubleshooting - How can we select Invoices for payment from BillToPay table using QODBC
Posted by Jack - QODBC Support on 14 October 2016 06:52 AM

Troubleshooting - How can we select Invoices for payment from BillToPay table using QODBC

Problem Description:

In the BillToPay Table - How can we select invoices for payment using QODBC?

We would like to have the Checkmark Selected for the respective invoice.

Solution:

You will have to insert BillPaymentCheckLine marking the Bill as Paid.

First, You need to query BillToPay table for Bill which you want to pay.

For Example:

SELECT * FROM BillToPay where BillToPayRefNumber='7893'



Bill in QuickBooks UI.



You need to use below query to marking the Bill as Paid.

INSERT INTO BillPaymentCheckLine (PayeeEntityRefListID,APAccountRefListID, BankAccountRefListID, RefNumber, AppliedToTxnTxnID, AppliedToTxnPaymentAmount) VALUES('90000-933272656','C0000-933270541', '20000-933270541','7893','DF4-933785047', 1250)



Related Data Description

PayeeEntityRefListID = '90000-933272656' (Required) VendorRefListID from Bill table.

APAccountRefListID = 'C0000-933270541' (Required) APAccountRefListID from Bill table.

BankAccountRefListID = '20000-933270541' (Required)

RefNumber = '7893' (RefNumber of Bill)

AppliedToTxnTxnID = 'DF4-933785047' (TxnID from Bill Table)

AppliedToTxnPaymentAmount = 1250 (AmountDue from Bill Table)

Bill paid in QuickBooks.



(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).