Supplier Wise Aging Report As of Date

Hi,

We are on 12.1.3

I have wrote a query to find the Supplier Wise Aging Report .But it is not working for back date i.e if we applied Amount 1000  today, in report patameter if a pass the value from to yesterday date - report should display sum of all aging. If we gave till today.. the value should be 1000 less

My Query:

SELECT   yy.vendor_name, yy.vendor_id vendor_num, yy.segment1,

         yy.SUM remaining_advance_amount, yy.less30, yy.greater30,

         yy.greater60, yy.greater90, yy.greater120

FROM     (SELECT   xx.vendor_name, xx.vendor_id, xx.segment1,

                   SUM (NVL (xx.less_30, 0)) less30,