1. Procurement Management Implementation Guide
  2. Update the Records in Supplier Price/Catalog File Table (F41061)

Update the Records in Supplier Price/Catalog File Table (F41061)

You can update the supplier catalog records using two methods:

  • Update the supplier catalog records using data selection .

  • Update the supplier catalog records using the flat file.

    You can also insert new supplier catalog records using the flat file.

Update the Supplier Catalog Records Using Data Selection

You can update the Unit Price, Effective From, and Effective Thru values for the supplier catalog records using the data selection method. You can select the records that you want to update by using the data selection option in this report. For the selected records, the Unit Price, Effective From, and Effective Thru values are updated using the values from the processing options. You do not need to enter the flat file name in the processing option of this report.

Update or Insert Supplier Catalog Records Using Flat File

You can update the Unit Price, Effective From, and Effective Thru values for the supplier catalog records from the flat file. You can also insert new supplier catalog records from the flat file. You must provide the flat file in CSV format.

The flat file looks like this:

Flat File.

In the flat file, you must set the Currency Code field as blank if the Currency field value is set to N (Non-Currency Environment). If the Unit of Measure (UOM) field is blank, then the system will set the unit of measure on the basis of the Item Master pricing policy specified in the Distribution constant. The system updates the Branch Plant field as blank when the price level is set to 1 for an item.

Note: The system will not consider the processing option values in the Update tab and the Adjustment tab except the value in the Mode of Process processing option which is in the Update tab when you process the report using flat file.The flat file must not contain a header field.
Supplier Catalog Update Error Report (R41061E)

When new supplier catalog records are inserted using the flat file, if the system finds any invalid records during the flat file validation, the Supplier Catalog Mass Update Report sets the processed flag value as N and enters the corresponding error code value in the Supplier Catalog Work File (F43061W). The Supplier Catalog Update Error Report checks for unprocessed records in F43061W. If any unprocessed record is found, the report prints the details of that record and the corresponding error message.