2 Replies Latest reply on Feb 27, 2017 7:12 PM by Srini Chavali-Oracle

    Supplier Open Balance Query

    1011751

      Hello Guru,

       

      I require supplier opening balance query. Parameter is vendor_id and from_date.

       

      Balance should display before the from_date of parameter. Eg: If i put '01-JAN-2017' then result of opening balance should be upto '31-DEC-2016'.

       

      Require only supplier opening balance, not the query for Calculate Balance Owed.

       

       

      Thanks in Advance.