Hi All, we are having an issue regarding Sales Order closed items.
I’m hoping someone else has a workaround for this?
We have a report that we use to calculate commissions based on Sales Order net amount.
The sales rep get paid based on this value but the sales order can later be reduced through the line item being marked as closed. However the overall sales order net amount remains the same.
I want to create a search to run in parallel i.e closed line item amount vs sales order amount.
I have tried to create a saved search to display the closed line item and line item amount un billed but currently unavailable as per suite answer #47914
Any advice how to get this info?