Hi @Judith Culanding-Oracle , The copy pasting the formula worked perfectly and produced the right output. Not sure why it didn't work previously. Thanks for your support on resolving this. Appreciate your effort in solving this. Best Regards, Rizwan

Hi @Judith Culanding-Oracle , I have added the following formula: However, I'm getting ERROR: Invalid Expression:

Hi @Judith Culanding-Oracle , Sure, please see both below. Criteria: Results:

Hi @Judith Culanding-Oracle , I tried the invoice search, but it didn't work as expected. Amount Paid pulls the sum of all transactions against that invoice which includes Payment and Credit Memo. Report pulls the same amount: Payment applied amount is different:

Hi @Judith Culanding-Oracle, Thanks for your response. I have referred to both articles you have shared, however I couldn't find anything regarding adding payment amount applied per invoice. I want the highlighted payment column on the saved search.

@Trixie Amora-Oracle thanks for the response. You mentioned the enhancement is for the error on Sales Order. Will that be the same for Work Order as well?

@Jam Amper-Oracle thanks for sharing the enhancement number and alternative solution. However, we have same customer having different discount % for different items.

@Jam Amper-Oracle: I'm looking for customer level % discounts for each item. I couldn't find that on the link provided.

False

Created my own Schedule script to delete all planned orders from saved search results.