[QODBC-Desktop] How to apply discounts to existing invoices
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 02:03 PM

How to apply discounts to existing Invoices

Problem Description:

We have a set of hundreds of invoices that we want to apply a 10% discount to, as the customer is going into bankruptcy and is giving us the choice of accepting a commitment to accept 10% of the invoice amount.


There is a "discount" item Type in QuickBooks which is used to apply a discount to transactions. You can find it via QuickBooks UI -> Item List. We first create a 10% discount item in QuickBooks. There is a special item type "Discount" when you creating the item. You can set the item to account for the separate loss account.

When a discount item is created, please find it in QODBC "Item" table and note down its ListID.
select * from Item


Note:  VB DEMO is to be used for testing of QODBC SQL queries only and is not a development tool.


Find out the invoice you want to apply the discount in QODBC "Invoice" table and note down its TxnID.

Here is an example of adding one discount item (160000-934380927) to an existing invoice "EF0-1071503378" in our test company file:
INSERT INTO InvoiceLine (TxnID, InvoiceLineItemRefListID, InvoiceLineDesc) VALUES (‘EF0-1071503378', ‘160000-934380927, 'discount')

And this is the Discount Item in QuickBooks:

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).