Create Purchase Orders - BQUTCP

Once you've assigned all Product Codes to selected Vendors, based upon the Bid Number you are currently working with, this utility will make all the necessary Purchasing System adjustments.  This utility launches the process to update/modify the Purchasing System with the information stored in Bid Project Tracking. Once you've completed the process of selecting/assigning/awarding a specific vendor to the Bid/Product Code, you'll run this utility to update the Purchasing System. All Purchase Requests that have this bid assigned to them will get updated.

This process will:

• Select all Purchase Requests (and all corresponding items) that have this Bid Number assigned to it.
• Step through them, verifying each Item, and if need be, create a secondary Purchase Request Number, with the correct Vendor ID, and assign the item to it.
• Link all Purchase Requests with this Bid Number and matching PEIDs so as to combine all matching Purchase Request/PEID combinations to produce one PO for each combination.

When run, the utility will prompt for a Bid Number. The number entered here will be validated against those created on the Formal Bid Screen (BQUPBD). The prerequisite for running this utility is to have entered a bid number on the purchase request screen and entered a product code on the item screen. The system will step through the purchasing system, looking for all purchase Requests that have a matching bid number. Once they've been tagged, a second search of all items associated with each purchase request will be looked at. Each item that has a product code on it will be verified that it has the proper vendor ID associated with it. If the item requires a different vendor, then a secondary purchase request will be created, using the original purchase request, the last two characters (7-8) will be changed to AA, AB, AC, AD, etc. This will happen for a maximum of 50 items per purchase request. This will allow the user the ability to track any changes to their original purchase request. Searches will show sequentially the additional Purchase Requests that were created. Once all this has occurred, the system will then join all like purchase requests, based upon Vendor ID, giving a sequential, numeric join code to all items that occur within the purchase requests with the selected bid number. Once this is done, you may print the purchase request in the normal fashion.