Running Order Edit List based on Qty Ordered
When running List, Edit List from COP Order Entry there is no option to run the report based on "qty ordered" instead of "qty to ship". Companies that default the "qty to ship" to zero get misleading information, on the total value of the opened orders.
The order total area for the order detail and the summary total page have been changed to show the Order Amount, the Cost, Margin and Margin Percentage (if the user is allowed to see cost information) based on the quantity ordered for “O” and “I” type orders. See http://support.elliott.com/knowledgebase/articles/1834066-feature-order-edit-list-with-order-totals-includ for more information on the changes made to the report.
There are several solution to this: (1) Export the order edit list to CSV and calculate total in Excel with a Macro; (2) Use Crystal Report; (3) Use Export Processor.