Depending on how tightly integrated your requisitioning, purchasing, planning, work flow, etc software is, it would seem that your best bet would be either 1. Use software from that vendor, or one of those vendors, or 2. Write your own, or hire a developer to write it. At first blush, this doesn't seem too formidable; however, I realize that whoever does the work has to understand how the pieces all fit together, and gaining that understanding can be harder than creating the new application.
If you can tell what other software you are using, someone else might be more helpful.
Then this information needs to be available to the developer in order to develop a system that will cope.
If there are that many NCRs then there is a management problem at the facility.
__________________
"Did you get my e-mail?" - "The biggest problem in communication is the illusion that it has taken place" - George Bernard Shaw, 1856
This database is also tied into incoming inspection and product travelers. We are now considering a network based program with a web interface. Probably won't find anything off the shelf that is even close to what we need.