cancel
Showing results for 
Search instead for 
Did you mean: 
ilan_workiz
Level 2

Excluding items from discount on invoice created by API

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?

5 Comments 5
RogelioL
QuickBooks Team

Excluding items from discount on invoice created by API

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.

ilan_workiz
Level 2

Excluding items from discount on invoice created by API

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

ilan_workiz
Level 2

Excluding items from discount on invoice created by API

that wont work because Im setting the discount on the invoice level using the specific field for discount and its in percentage.

ChristineJoieR
QuickBooks Team

Excluding items from discount on invoice created by API

I understand you need to exclude one item for a discount, ilan. The relevance of this feature might be helpful in your daily tasks within QuickBooks Online. Let me share some pointers regarding this matter.

 

The discount function within the invoice is applied to all items. Having that said, applying a discount for certain items within an invoice isn't supported by QuickBooks. As an alternative, we can create discount items as suggested by my colleague above.

 

I also suggest you send a request to our product developer. This way, they'll see your recommendation and consider counting it in the subsequent schedule update.

 

Follow the steps below:

 

  1. You can go to the Gear icon.
  2. Under the Profile column, press the Feedback button.
  3. Write your product suggestion, then click Next.

11 (1).png

Furthermore, our Product Development team receives your thoughtful comments (QBO) through the feature request tracking QuickBooks Online Feature Requests website.

 

Additionally, we also recommend reaching out to our Intuit developer to seek guidance or ask for some workaround on how to exclude items from discounts on invoices while using API. 

 

Please feel free to add your reply if you have any further questions or if there's anything else I can assist you with. We are continuously here to help you with any inquiries you may have. Remain safe!

BigRedConsulting
Community Champion

Excluding items from discount on invoice created by API

@ChristineJoieR  RE: The discount function within the invoice is applied to all items. Having that said, applying a discount for certain items within an invoice isn't supported by QuickBooks.

 

That's unfortunate, as that is a very, very common thing to do. Which is why QuickBooks Desktop has been able to do that for about 30 years.

 

It's unfortunate that QuickBooks Online is such a weak substitute for Desktop, even as Intuit's had 20 years or so to get it right.

 

RE: I also suggest you send a request to our product developer.

 

You have one product developer? Well perhaps that explains it. Maybe hire a couple more. Just a thought.

Need to get in touch?

Contact us