Report Totals are Double the Expected Value

Often times, reports based on order details return twice the expected value. This is usually because the report is using the Order Details table (ER101) and both Ordered and Actual records are being returned.  To resolve this, in the Report Selection Criteria filter ER101_PHASE to either Ordered (1) or Actuals (5) depending on which value you would like to view.