Loading the Item demand plan record didn't get all the line level details, but the saved search pulled all the data as required for all the demand years .

Hi @Richard James Uri-Oracle , Thanks for your feedback. Context: I would like to show all Demand Plan (including current year and next year) on a Suitelet. I have a saved search that gets the data from Demand Plan, however the results from the saved search doesn't show the demand for 2026. Script is run as Administrator.

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.