topic Re: Show the line item unit net/effective price after discount in Sales Hub Tools

Show the line item unit net/effective price after discount

acowpy — Thu, 18 Sep 2025 06:01:21 GMT

Hi,

We would like to show each line item's net/effective price after applying the unit discount.

There is a field called 'Effective Unit Price' that we assumed to be

[Unit Price] x [Unit Discount]

but this does not seem to be it (see screenshot - always seems to be blank).

Any suggestions here?

Re: Show the line item unit net/effective price after discount

Anonymous — Thu, 18 Sep 2025 11:07:45 GMT

Hi @acowpy ,

Sounds like you're looking for the Net price option which is reflected when adding Amount as a column to the line item table on my end. Am I missing something here?

Or are you perhaps looking to get Unit price * Unit discount regardless of the quantity? From my own troubleshooting, I believe that Effective Unit Price only applies to tiered pricing (part of the new AI-Powered CPQ offering that HubSpot launched at Inbound).

Let me know your thoughts!

Re: Show the line item unit net/effective price after discount

acowpy — Fri, 19 Sep 2025 01:33:57 GMT

Thanks for the quick response!

Net Price gives me:

Quantity x Unit Price x Unit Discount

but I'm looking for just

Unit Price x Unit Discount

If its not a standard field is there a way to create a calculated field to provide this?

Re: Show the line item unit net/effective price after discount

STierney — Fri, 19 Sep 2025 01:46:55 GMT

Hey @acowpy - thanks for posting in the Community!

@Anonymous - and follow-up context to this inquiry?

Shane, Community Manager

Re: Show the line item unit net/effective price after discount

Anonymous — Fri, 19 Sep 2025 05:02:54 GMT

Hi @acowpy ,

Thanks for clarifying! Calculated properties aren't supported on product objects, sadly. I've checked most of the out of the box properties that HubSpot offers and there isn't one that strictly returns the per unit value of Unit price x Unit discount. One recourse here would be a custom quote template whereby you adjust the line item table module slightly to perform the calculation you're after (and display this within the line item table).

Past that, per this thread: https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/Calculated-field-in-Product-properties/m-p/977532 , quote hapily does offer some form of calculated property support on their end although you may need to explore this option with them!

Let me know if you run into any questions attempting to implement the custom quote template path and I'd be happy to assist via DM!

Re: Show the line item unit net/effective price after discount

JHumphreys1 — Wed, 26 Nov 2025 10:24:06 GMT

Calculated Line Items are now available in HubSpot. This has been a game changer for us!

Take a look at Org > Product Updates, and look for 'Line Item Custom Properties'

Here is the article "Create and edit properties" to learn how to create custom line item properties.

Re: Show the line item unit net/effective price after discount

BérangèreL — Wed, 26 Nov 2025 10:25:52 GMT

Hi @JHumphreys1, that’s great to hear, thanks for sharing with the HubSpot Community!

Calculated Line Items are a fantastic update. If you have any tips on using them, feel free to let us know.

Wishing you continued success with HubSpot!
Bérangère