Rolling YTD P.O. Total in P.O. Requisition Maintenance (and Vendor Maintenance)
It would be incredibly useful to have a field on the Requisition Maintenance that automatically pulls the YTD P.O. Total for the respective vendor. This would be a rolling 12-month total, so if it were 6/4/2021 at the time of viewing the requisition, it would display a total from 6/4/2020 to 6/4/2021. If it were 6/5/2021 at the time of viewing, it would display 6/5/2020 to 6/5/2021, etc.
This would assist all entities subject to NJ Contracts and Pay-to-Play Laws in monitoring for aggregation. If this were on the face of a requisition, Purchasing staff would be able to determine whether or not they'd exceed the Pay-to-Play or bid thresholds and be proactive in re-evaluating estimates during the contract year(s).
Currently, Page 2 of the Vendor Maintenance displays YTD Paid amounts on a calendar year basis, so it would seem the ability for the software to do this wouldn't be too heavy of a lift.
