Blanket PO Releases

You can use the Part Step Pricing view which is an RMB from the Supplier Agreement Lines.  Or you can use that view as a part of quick report depending on how you want to construct the total.

The PO Lines view should hold all of the information for the used lines against an agreement, though you need some joins of the two pieces of info depending on how you want to present it.

We look for the total remaining as the trigger to create a new one or re-evaluate.

We have a quick report for remaining balance, Supplier Agreement Balances (replace &AO with your instance):

SELECT
   sal.contract                                                   AS sa_line_site, 
   sal.state                                                        AS sa_line_status, 
   sal.blanket_order                                           AS sa_number,
   sal.blanket_line                                               AS sa_line_no,
   sal.part_no,
   sal.description,
   sal.maximum_line_qty,
   sac.current_qty,
   sal.maximum_line_qty - sac.current_qty        AS balance_qty
   

   FROM &AO.supplier_blanket sah

   LEFT JOIN &AO.supplier_blanket_line_all_cfv sal
   ON sah.blanket_order = sal.blanket_order

   LEFT JOIN &AO.supp_blk_part_cum sac
   ON sah.blanket_order = sac.blanket_order 
   AND sal.blanket_line = sac.blanket_line

   WHERE sah.contract LIKE NVL('&[-C-BL]Owning_Site','%')
   AND sah.state LIKE NVL('&[-C-BL]Header_Status','%')
   AND sah.blanket_order LIKE NVL('&[-C-BL]SA_Number','%')
   AND sah.vendor_no LIKE NVL('&[-C-BL]Supplier_ID','%')

Hello- 

I was wondering if there might be a solution to this. We are trying to solve the same issue