Skip to main content
May 1, 2024
Question

Excluding items from discount on invoice created by API

  • May 1, 2024
  • 1 reply
  • 0 views

Im creating invoices in QBO via the API and using the DiscountLineDetail line item to set a discount in percentage or in amount

 

I know searching for away to exclude certain items from the discount when creating the invoice through the API

 

for example I have an invoice of 3 items

item a - $100

item b - $100

item c- 100$

 

and a discount of 10%

 

i want to exclude item c from the discount so the totall will be

$280 instead of $270

 

what will be the best practice for that?

1 reply

May 1, 2024

Hello @ilan_workiz, I'm here to guide you through creating a discount.

 

Normally, when creating an invoice with discounts in QuickBooks Online, this is what we're going to do: 

 

• To begin with, let's create a service item for the discount: 

  1.  Navigate to Sales, then go to Products and Services
  2. Click New, then select Service.
  3. Name it Discount.
  4. From the Income Account, choose Discount Given.
  5. Scroll down to Sales Tax, then click Edit Sales Tax.
  6. Make it Non-taxable, then click Done
  7. Save and Close.

• After this, let's create the invoice: 

  1. Click the +New, then choose Invoice.
  2. Add items A and B, then add the service item we made. 
  3. Enter the Discount amount (ex.-20)
  4. Click Add Subtotal, then add item C.
  5. Save and Close.

 

Here's a screenshot for your visual reference: 










 

However, since you're using an API, I recommend contacting our Intuit Developers for better advice:

  1. Go to this link: Intuit Developer Support.
  2. Log in to your Intuit Developer Account or Create a new one.
  3. Below the What you need help with, choose QuickBooks Online.
  4. Click Ask a question.
  5. Hit Ask.
     

Also, I've added this article to help you personalize your invoices: Customize invoices, estimates, and sales receipts in QuickBooks Online.

 

Let me know if you need further assistance managing your invoice or QuickBooks. Keep safe.

May 1, 2024

That wont work because my discount is in percentage and its on the invoice level utilising the specific field you got for discount