Hi Amit

Thanks for using the Sage Business Community. 

• Select the Outstanding Sales Orders report and select Edit to open it in the Report Designer.

• Go to the Report menu > Filters and amend what's already there from ((SALES_ORDER.DESPATCH_STATUS_CODE <> 2) AND (SALES_ORDER.ALLOCATED_STATUS_CODE <> 3)) to: ((SALES_ORDER.DESPATCH_STATUS_CODE <> 2) AND (SALES_ORDER.ALLOCATED_STATUS_CODE <> 3) and (SALES_ORDER.ORDER_OR_QUOTE NOT LIKE "QUOTATION"))
• Click OK, then go back to Report > Report Properties and change the name
• File > Save As > Leave the window as it is and Save 
• The report will be saved into the My SOP reports folder in Sales Orders > Reports. 

Dear Fiona,

Thank you for the support. I have changed it to following as when I was not doing remain <> 0, the list was showing all orders where the Quantity Remaining to Deliver were "0". Do you confirm this?

remain <> 0 AND ((SALES_ORDER.DESPATCH_STATUS_CODE <> 2) AND (SALES_ORDER.ALLOCATED_STATUS_CODE <> 3) AND (SALES_ORDER.ORDER_OR_QUOTE NOT LIKE "QUOTATION"))

Regards,
Amit

Dear Fiona,

I am touching again on this subject. My Report is giving inaccurate Data. After your suggestions, I changed the filter to as below:

 

If I remove the "remain <> 0", the list shows all items on the Sales Order including the ones which are no longer outstanding to ship. This makes the list go longer. Please advise if what I have done is correct or not. 

The concern is that this report now shows a total of open sales orders which does not match with the standard Outstanding Sales Order Report provided by Sage. There is a difference in values. How to solve this?

Thanks!

Amit