4 Replies Latest reply on Feb 16, 2007 2:38 PM by Idit Frydman Saguey

    Open Items Amount vs XL Reporter Amount

    Vicki Mitchell

      I am trying to build a weekly flash report in XL Reporter to include my open Sales Order amount. When I set up XL Reporter and filter by open documents, the total of the document is returned in the open amount field. If we have delivered part of the order, the delivered amount is still considered in the open amount. I do not want to include the delivered amounts. I then thought if I were to take the Row unit price and remaining open quantity in the row and multiply, this would give me the amount I am looking for. It did not match the open sales order amount (from Open Items List) either. Does anyone have any ideas how to get the Open Items Amount to XL Reporter? Thanks for your help, Vicki