Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - How to give refund to existing CreditMemo using QODBC
Posted by Jack - QODBC Support on 28 August 2015 08:31 AM

Troubleshooting - How to give refund to existing CreditMemo using QODBC

Problem Description:

How can I apply a refund check to an existing credit memo using QODBC?

In QuickBooks, I can refund by opening the Create Credit Memos/Refunds dialogue box using the QuickBooks UI and find the credit memo for that customer. In the dialogue box icon bar, click on the "Use credit to give a refund".



Solutions:

You can use CheckApplyCheckToTxn table which is Insert Only table to create a check to pay off a credit memo. You can give refunds to an existing credit memo by using below queries:

INSERT INTO CheckExpenseLine (AccountRefListID,ExpenseLineAccountRefListID,ExpenseLineAmount, ExpenseLineMemo,ExpenseLineCustomerRefListID, ExpenseLineBillableStatus, FQSaveToCache) Values ('20000-933270541','40000-933270541',80,'Test Memo','800000E2-1513333899',null,1)



Insert into CheckApplyCheckToTxn ( AccountRefListID,PayeeEntityRefListID,TxnDate,ApplyCheckToTxnTxnID,ApplyCheckToTxnAmount) values ('20000-933270541','800000E2-1513333899',{d'2017-12-18'},'1B3C0-1513338090',80)



After executing above queries, you can see CreditMemo as Refunded in QuickBooks.



You can get ApplyCheckToTxnTxnID from TxnID field of CreditMemo table for that particular Transaction by using below query.

SELECT TxnID,RefNumber FROM CreditMemo where RefNumber='1268'



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