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('&a-C-BL]Header_Status','%')
AND sah.blanket_order LIKE NVL('&L-C-BL]SA_Number','%')
AND sah.vendor_no LIKE NVL('&L-C-BL]Supplier_ID','%')
One of the things I mentioned above was referring to “Blanket Contract Agreement.” I just want to be clear, we are not as concerned about using “Supplier Agreements” as much a we just need our Purchase Orders to reflect the correct information for the supplier and visibility of total commitment, received, open and balance left to be released.
- Total Blanket Quantity committed
- Each Release quantity and date
- Which releases are closed/received
- Which releases are released pending receipt
- Total Quantity not released (balance of commitment to be released)
The notes above are more complex that we are looking for. Is there any other recommendations?
Thank you, Michelle
Hello-
I was wondering if there might be a solution to this. We are trying to solve the same issue
Hello,
Has anyone been able to solve this issue? We have the same situation as well.
We still have this open question regarding blanket POs, does someone have any recommendations?
