BL140 - Base List Worksheet Creation Run this program to create worksheet prices that can be updated by BL41.1 (Worksheet) or downloaded to a personal computer for updating. An existing item price source, it's issue cost, last cost, or other price base can be modified to become a new price base. See the Billing Procedures Manual for more information on the worksheet process. Run this report to print the worksheet price base and use the worksheet effective date as the next effective date for this new base. The program prints error messages stating why an item cannot be priced, if appropriate. If you select the spreadsheet format, the program flags this worksheet for personal computer updating and you cannot maintain it using BL42.1 (Worksheet Items). Also, you cannot delete unwanted worksheets processed by this program. You can purge these worksheets by running BL340 (Base List Worksheet Purge). Reprint worksheets by running BL240 (Worksheet Reprint). Updated Files CKPOINT - Used to control program restart logic. OEWKPRICE - Temporary file created that carries the item's price. OEWKSHEET - Worksheet parameters used to create work price files. Status is updated. Referenced Files APCOMPANY - Used in the vendor Master edit. APCPYVND - Used in the vendor Master edit. APHLDINV - Used in the vendor Master edit. APVENCLASS - Used in the vendor Master edit. APVENGROUP - Used in the vendor Master edit. APVENMAST - Used to validate vendor selection. CUCONV - Used in converting monetary amounts between currencies. CURELAT - Used in converting monetary amounts between currencies. GLSYSTEM - Used in the General Ledger company edit routine. ICCOMPANY - Used to edit item locations. ICLOCATION - Used to edit item locations. ITEMLOC - Optional source for item work prices. ITEMMAST - Used to edit item numbers. OEBASE - Optional source for item work prices. OECOMPANY - Used to validate the Billing company. INVOKED Programs IFCC IFCR IFSG |