Knowledgebase: Data & Table
[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?

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

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