AnsweredAssumed Answered

Subtotals in portal based invoice

Question asked by JoeSand on Nov 7, 2017
Latest reply on Nov 9, 2017 by JoeSand

I have a portal based form for automotive repair orders, like invoices, with line items that have either parts or labor items.  I'd like to be able to include subtotals that sum up a portion of the line items.  For example, a customer might have a brake job as part of a larger job, which could include a number of separate parts and labor items.  I would like to include a single line item that might be labeled "brake job" that totals that section.

The first thing that comes to mind is to include a "job" field for each line item, and a summary field that is normally hidden, that sums the line items with a particular job number via the appropriate relationship,  Not sure how I would automate this to make it user friendly...

I'm just tossing this out there in case someone had already done something like this and has a better idea.