[QODBC-Desktop] How to Link Invoice to Deposit using QODBC?
Posted by Ricky - QODBC Support on 04 October 2019 01:35 PM
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?
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