Morning everyone. We use discount items with our transactions and we need to output some basic reporting. I was able to use the AMOUNT DISCOUNT field to isolate the lines/items where the discount was applied. (Discount to Line) I am not seeing the reverse relationship (Line to Discount) I want to add the name of the discount item that was applied to the line. Ex: line 1: Keyboard and Mouse - $100 line 2: DiscountABC - 50% In saved search: I can bring up line 1 with all necessary information including the discounted amount ($50) However, I cannot bring up the discount percentage (50%) nor the discount item name (DiscountABC) Any ideas? NS Support has marked this as an enhancement and SuiteAnswers resorts to scripting to get the discount item internal id sourced onto custom column field on line 1.

@Aria Ghahari have you tried using the "Amount Discount" field on the saved search? On each line, you should be able to see the net amount, gross amount, and amount discount

Hi @AK47. Yes, I have. I do get all that information. What I do not get is the name of the discount item that was applied. That is the last piece of information I need.

hey @Aria Ghahari, the discount item would show up as a separate line on the search for an order, but depending on your filters, you may be filtering it out. If you are showing only a specific account, or only inventory items or something it would filter the discount item. If you just make a simple saved search filter on one specific SO that has a discount and set main line = false, you should see the discount item as a separate line item in the result.

Hi @AK47 Yes, I am trying to have it show up on one line. That is the issue