Version 7.5.103f MS SQL - comparing the OEORDHDR tot_sls_amt and tot_dollars fields against the corresponding OEORDLIN qty_ordered * unit_price revealed discrepancies where either/both the tot_sls_amt or tot_dollars field = 0 on about 5% of our open sales orders. There is nothing unique about these orders that I can discern. Can anyone explain the use of the tot_sls_amt and tot_dollars fields and what can cause this discrepancy?

Are the items that have 0 in the tot_sls_amt field backordered? Its been my experience that this field is not 100% until the order is selected

Thanks for the reply - you were close. The formula for tot_sls_amt is actually qty_to_ship*unit_price and not qty_ordered*unit_price. Problem solved.

Almost all of our parts are entered with Qty Ordered = x and Qty to Ship = 0 so that's why it doesn't fill in the dollars until selected. At that time, they designate the qty that was shipped. Glad you found the problem.