Using Supplier Catalog Mass Update (Release 9.2 Update)

The system processes an order based on the items you purchase and the supplier from whom you purchase. You can define purchasing instructions for a supplier so that each time you enter an order the system retrieves the default values for that supplier.

The Supplier Catalog Mass Update report (R41061M) enables you to update the Unit Price, Effective From, and Effective Thru values for the records in the Supplier Price/Catalog File table (F41061). The R41061M program also allows you to insert new supplier catalog records in the F41061 table.

(Release 9.2 Update) When you enter the values for the key fields—Supplier, Catalog, Item Number, Currency Code, Quantity Break, UOM, and Branch/Plant for supplier catalog records in the R41061M program, the system processes the records from the flat file. Based on the key field values, if there is an existing record, then in the respective supplier catalog record in the F41061 table, the R41061 program updates the values for Effective Date, Effective Thru, and Unit Price to the flat file values. If there is no existing record, then the R41061 program inserts a new supplier catalog record in the F41061 table on the basis of the values given in the flat file.