|
|
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.
|