BL41.1 - Worksheet

Use this form to define worksheets. Worksheets let you precalculate and
massage price bases before you actually update them. Price bases are created
from worksheet prices by using an existing item price source: issue cost, last
received cost, or another base's current base.

In the worksheet pricing procedure, you select which items will be affected
by a specific worksheet (for example, which items will be selected for price
base manipulation). You can use selection criteria to choose items from a
certain vendor, items from certain sales classes, or specific item numbers.

Note: A single worksheet can include parameters from only the first form, the
second form, or both. The selection is inclusive and the most restrictive
multiplier will be used. That is, if an item range multiplier applies, it will
be used. If no item range applies, the system uses the sales class range
multiplier. If no sales class multiplier is used, the vendor multiplier will
be used.

See the Billing Procedures Manual for more information on the worksheet
process.

Updated Files

    CKPOINT    - Not used.

    OEWKSHEET  - Primary file updated by this program.


Referenced Files

    APCOMPANY  - Used in the Accounts Payable vendor edit routine.

    APCPYVND   - Used in the vendor edit routine.

    APHLDINV   - Used in the vendor edit routine.

    APVENCLASS - Used in the vendor edit routine.

    APVENGROUP - Used in the vendor edit routine.

    APVENMAST  - Used in the vendor edit routine.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the Inventory Control location.

    MAJORCL    - Used to validate major sales class.

    OEBASE     - Used to validate the price base name.

    OECOMPANY  - Used to validate the Billing company.

    OEWKPRICE  - Used in delete edit.  Worksheets with existing work prices may
                 not be deleted.


INVOKED Programs

    IFCC