Calculated field for NET UNIT PRICE

Is there a way to create a NET UNIT PRICE field to use in Line Items and also in reporting

NET PRICE / QUANTITY = NET UNIT PRICE

Hi @enniszd

Thank you for reaching out.

I want to tag some of our experts on this - @BNGUYEN @Dan1 @Mike_Eastwood @JonPayne do you have any thought for @enniszd on this?

Thank you!

Best

Tiphaine

Hi,

The price in the catalog should ALREADY be the ‘UNIT PRICE’.

Or your problem is related to NET price with tax?

Please tell me more about ur problem. ill try to help.

Best regards

@enniszd @TitiCuisset

Correct Unit Price. What I am looking for is NET UNIT PRICE - the calculation is NET PRICE / QUANITY = NET UNIT PRICE.

For example if you purchase quanity 50 and the unit price is $1000 and unit discount is 20% then the Net Price = $40,000 which means the Net Unit Price is $800. (tax is after the fact).

The reason to get the Net Unit Price is determine what the actual avg sale price of a unit is.

In my opinion - Unit Price aka List price, should remain a consent and should not have the ability to be edited in the Line Item section

Let me know if that makes sense?

@enniszd @TitiCuisset

Ok thanks for the explanation, how it’s currently not possible to create calculated properties on Line Item ‘object’.

Your net unit price us also = unit price - discount but we can’t make calculations

You can upvote this functionnality here.

Wish i helped. Best regards

https://community.hubspot.com/t5/HubSpot-Ideas/Calculated-properties-for-Products/idi-p/342943