Actual Rate Labor - How to total non-service (product) lines only
Tamela Abboud
started a topic
5 days ago
We are selling more actual rate labor projects and need to be able to capture the estimate of labor on a quote to sync into ConnectWise opps, but not print on the quote or show in QuoteValet.
I've figured out how to update the print layout so that it doesn't show, but don't know how to make the QV template calculate based on product lines (item type) vs subtotal which does include the estimated labor line.
I can't exclude the labor line as then it won't sync to the CW opportunity, where we pull forecasting.
I don't see a field to swap in document headers that totals product, only the subtotal one that exists in our QV template now.
Any thoughts on this? Or how do others handle forecasting and actual rate labor projects?
Best Answer
S
Steve Siggs
said
5 days ago
If you have QuoteWerks Corporate edition, then you could use scripting to total the amount on the Labor and/or Product Line Items into a Document Header field, then use that field on the QuoteValet HTML Template.
If you have QuoteWerks Corporate edition, then you could use scripting to total the amount on the Labor and/or Product Line Items into a Document Header field, then use that field on the QuoteValet HTML Template.
Or perhaps use a Summary Line Item on the Quote?
1 person likes this
Tamela Abboud
said
4 days ago
Thanks Steve! I suspect we do and we already have custom html for our layouts (done prior to taking over managing this) so I'll see if I can find someone in our company that can help me with the things you said.
Tamela Abboud
said
about 11 hours ago
Steve - you are awesome! After some playing around with scripting (and texting with copilot) I was able to get this to write to a field that I could use on the QV html template and get updates made that were needed. I made it work on my own, thanks to your reply!
Tamela Abboud
We are selling more actual rate labor projects and need to be able to capture the estimate of labor on a quote to sync into ConnectWise opps, but not print on the quote or show in QuoteValet.
I've figured out how to update the print layout so that it doesn't show, but don't know how to make the QV template calculate based on product lines (item type) vs subtotal which does include the estimated labor line.
I can't exclude the labor line as then it won't sync to the CW opportunity, where we pull forecasting.
I don't see a field to swap in document headers that totals product, only the subtotal one that exists in our QV template now.
Any thoughts on this? Or how do others handle forecasting and actual rate labor projects?
If you have QuoteWerks Corporate edition, then you could use scripting to total the amount on the Labor and/or Product Line Items into a Document Header field, then use that field on the QuoteValet HTML Template.
Or perhaps use a Summary Line Item on the Quote?
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstSteve Siggs
If you have QuoteWerks Corporate edition, then you could use scripting to total the amount on the Labor and/or Product Line Items into a Document Header field, then use that field on the QuoteValet HTML Template.
Or perhaps use a Summary Line Item on the Quote?
1 person likes this
Tamela Abboud
Thanks Steve! I suspect we do and we already have custom html for our layouts (done prior to taking over managing this) so I'll see if I can find someone in our company that can help me with the things you said.
Tamela Abboud
Steve - you are awesome! After some playing around with scripting (and texting with copilot) I was able to get this to write to a field that I could use on the QV html template and get updates made that were needed. I made it work on my own, thanks to your reply!
Steve Siggs
Glad I could help!
-
No PDF's please
-
Optional item Selected or Not Selected
-
Using Javascript to display different language acceptance templates
-
change quantity in quote vallet
-
Creating a Dropdown List for Quantity
-
Payment Option Descriptions on Template
-
Youtube Videos Not Attaching to Line Items in QV
-
Hiding the shipping amount if 0
-
Javascript to hide shipping on QV template if 0
-
QuoteValet Template - Get Selected Value from Selected Dropdown not working..
See all 38 topics