Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

PO150

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.