PO150 - Bid Load to Contract or Quote Use this program to take bid responses or catalog price lists that have been added to the system and load them as quotes, contracts, or overrides. Vendors provide information on what their prices will be for a set of items by responding to a request for quotation (bid) or by sending out a catalog price list. In either case, at some point it is determined that prices should be put in the system to be used for unit cost defaults on purchase orders. It must be determined whether the prices should be loaded as quotes or contract order lines. If loaded as quotes, the prices can have an effective date. If loaded as contract lines, the lines can accumulate statistics that show total dollars and quantities ordered. The contract order with which the lines are associated can be put on hold and carries an agreement period range. If loaded as lines to a contract order, the lines will be associated with a particular contract, and defaulting of costs to purchase order lines can be done based on a contract number. Reporting can also be done against the contract number showing contract compliance. For items where vendors did not provide enough information to create quote or contract records, the program report will list the items and errors. If it is desirable to designate the vendor associated with the bid data being loaded as the primary vendor for the item location, there is a flag to allow that. The program will also create vendor item records where vendor item numbers are provided, and no records currently exist. When creating quotes, this is done automatically. When creating a contract, select Y in the Create Vendor Item field to create vendor items. Updated Files CKPOINT - Used to determine if restart information exists. ICAUDIT - ITEMLOC - Used to validate Inventory Control item location for inventory items. POBIDITEM - Used to create bid item records. POITEMVEN - Used to create vendor item records when quotes are created. POQUOTES - Used to update vendor item quote records. STPOLINE - Used to edit if a standard order line already exists. STPURCHORD - Used to validate and default standard purchase order information. Referenced Files APCOMPANY - Used to validate the Accounts Payable company. APCPYVND - Used to retrieve company-specific defaults for a vendor. APHLDINV - Used to determine what invoices for a vendor are on hold. APVENCLASS - Used to validate vendor class or to default vendor class information. APVENGROUP - Used to validate vendor group or to default vendor group. APVENLOC - Used to validate and default Accounts Payable vendor location information. APVENMAST - Used to validate the vendor ID and obtain vendor display information. CUCODES - Used to validate currency codes. CUCONV - Used to access general ledger and currency information. CURELAT - Used to validate currency relationships. FOBCODE - Used to obtain and validate ship term information. GLSYSTEM - Used to validate the General Ledger company. ICCOMPANY - Used to validate the Inventory Control company. ICLOCATION - Used to validate Inventory Control item location for inventory items. ICMANFCODE - Used to validate the Inventory Control manufacturer's code and display the manufacturer's code description. ICVALUOM - Used to validate item unit of measure. ITEMMAST - Used to validate the item and to obtain item descriptive information. POBID - Used to validate bid information. POCOMPANY - Used to validate the purchase order company information. POVENDOR - Used to default and display purchase order vendor information. |