Hi,
I have built a saved search and tried to pull in the amount invoiced for Sales orders based on below criteria and results. However when I add in the formula for the amount, the lines are duplicated. I tried other formulas where lines were not duplicated i.e. {quantitybilled}*{fxrate} however this does not give correct values on Sales orders with header level discounts. Please can someone advise how this can be done? Thanks.