Skip to main content
Answer

Checkbox "Optional" – Display sum of optional items separately Sales Quote screen

  • April 22, 2025
  • 1 reply
  • 48 views

FinnSystemAG
Freshman II
Forum|alt.badge.img

Hi everyone,

I’ve added a checkbox called UsrOptional to mark certain line items as optional. When checked, the item is displayed as “optional” in the Sales Quote screen

Now, the customer wants the total of these optional items to be excluded from the regular “Total Net” amount. Instead, this total should be displayed separately under a label like “Total Optional Items Net”.
Does anyone have an idea how to implement this?

Or other ways to handle it ?

Thanks in advance!

 

 

Best answer by aiwan

@FinnSystemAG 

 

I believe if you strip the ExtPrice fields [PXFormula] with a cache attached, and update it with something like this:

[PXFormula(typeof(Mult<YourDAC.Qtyfield, YourDAC.UnitPrice>), typeof(Switch<Case<Where<YourDACExt.yourCustomField.IsEqual<True>>, SumCalc<YourHeaderDac.ExtPrice>>>))]

it might work

1 reply

Forum|alt.badge.img+8
  • Captain II
  • Answer
  • April 23, 2025

@FinnSystemAG 

 

I believe if you strip the ExtPrice fields [PXFormula] with a cache attached, and update it with something like this:

[PXFormula(typeof(Mult<YourDAC.Qtyfield, YourDAC.UnitPrice>), typeof(Switch<Case<Where<YourDACExt.yourCustomField.IsEqual<True>>, SumCalc<YourHeaderDac.ExtPrice>>>))]

it might work