QODBC Desktop - How to Link Invoice to Deposit using QODBC?

Problem Description 1:

I want to apply the Payment to a particular Invoice using Deposits.

How can I do so using the QODBC?

Solutions: 

Refer to the screenshot of the QuickBooks UI Invoice created.

You can use this 'Invoice No.' or 'RefNumber' to search for a specific Invoice.

Note the ref number of the Invoice, i.e., '7777777-124.'

You can find this Invoice created using QODBC Test Tool using the below SQL query:

SELECT * FROM InvoiceLine where RefNumber='7777777-124.'

Note the value of the field 'TxnID' - '8DF3-1481796954' from the 'InvoiceLine' table.

Use this value of the field 'TxnID' in the 'ReceivePaymentLine' table.

SELECT * FROM ReceivePaymentLine where AppliedToTxnTxnID='8DF3-1481796954'

The value in the field 'AppliedToTxnTxnID' from the ReceivePaymentLine table and 'TxnID' in the InvoiceLine table are equal.

i.e., ReceivePaymentLine.AppliedToTxnTxnID = InvoiceLine.TxnID

Note the value of the field 'TxnID' - '8DF7-1481797010' from the 'ReceivePaymentLine' table.

Use this value of the field 'TxnID' in the 'DepositLine' table.

SELECT * FROM DepositLine where DepositLineTxnID='8DF7-1481797010'

The value in the field 'TxnID' from the ReceivePaymentLine table and 'DepositLineTxnID' in the DepositLine table are equal.

i.e., DepositLine.DepositlineTxnID = ReceivePaymentLine.TxnID

Search for the field 'DepositLineCheckNumber' in the 'DepositLine' table.

In this example, the value is '20181225-0222'.

Search for this specific reference number in QuickBooks UI in 'Deposit.'

Below is the screenshot of the QuickBooks application of 'Customer Payment' or 'ReceivePayment.'

Tags: Link invoice to deposit, Deposit, Invoice