I am creating a saved search to report on transaction discounts. Not even touching the item line discounts and I am running into issues. I selected a discount Item on the body of my sales order (Body Field: DISCOUNT ITEM [discountitem]) and set the rate as -50% (Body Field: RATE [discountrate]) Both fields are standard. I cannot pull this information into my saved search. I looked for the field and it is not available. I tried adding the internal id of the field in formula text and get

ERROR: Field Not Found

which is BS because @michoel's NSFE shows the value in these 2 fields. NS Schema Browser had the internal ids with camel case

discountItem

and

discountRate

. These did not work either. Am I missing something? I really do not want to create 2 custom fields to handle this.

the record model is different than the soap model, which is different than the search model

I completely understand that. My frustration is that the record model is different from the search model. Am I incorrect in wanting these 2 to be the same?

which has an item column that should match the discountitem you would see on the record

That is also correct. I am using Item Any Line and it brings sales orders where I have the discount on the header. I added the item column yet it does not show the discount item.

what are your other filters?

you wont get the transaction discount line and the mainline on the same line without using summaries

Yea, I think I need to strugle through this some more. My goal is to show the line as normal but add a column that shows which discount item was applied to the line.

you can probably put the discount item in a custom body field if you are desperate

Item Amount Discount Percentage Discount Amount Total After Discount Dicount Item Basketball $50 10% $5 $45 Customer Discount