On the Load tab, you can upload the Excel sheets that have been created on the Download tab, sent to the bidders, modified, and finally returned by the bidders.
To upload the data, you must select the bidders, enter the directory and file name, and click the Load button. The files can only be loaded for bidders whose quote is not approved. If the approval process has already been started, the download functionality is no longer available.
The bidders assigned to the inquiry are listed with the name in the Bidder field, the company name in the Company Name field, and the company code in the Company field. The Buyer field displays the buyer who is assigned to the inquiry and bidder and thus responsible for the quote.
To load a file for a bidder, select the Load check box of that bidder and click the Load button. A browser window opens where you can click the Browse button to select the file from your file system.
Next, click the Submit Query button to continue. When the file is successfully uploaded, you can close the browser window and return to P.30.24.
A message appears, asking if you want to continue. Click Yes to continue.
The name of the loaded file is displayed in the File Name field.
The name of the directory where the file was loaded from is shown in the Directory field.
The Logfile field shows the name of the log file created during the file load with the directory where it’s stored. To view this log file, click the View Online Log button to open the A.60.72 Show Log File for Load Bids screen and display the content of the log file. If errors occurred, the error codes are shown in the log file. Below is a list of error codes and corresponding error reasons.
Error Code |
Error Reason |
---|---|
100 |
Att. Rate type does not exist |
101 |
The field is empty, although it is required |
102 |
The value is too large |
103 |
The value is too small |
104 |
A number value is not numeric |
105 |
A date value is invalid |
106 |
The value is not in the allowed list of values for this field |
107 |
A date value lies in the future |
109 |
Unknown column name |
111 |
Empty Rate Unit/Rate Value |
112 |
Invalid value for Rate Unit |
151 |
Inquiry type <> LS and RT_CODE = L |
201 |
Error when checking quote detail |
202 |
Given NLS does not exist |
211 |
Quote is already approved |
213 |
Order is already approved |
216 |
Order may only be changed if user has privilege ASSIGN_BUYER or has privilege BUYER and is the buyer of the order |
217 |
Higher supplement for quote is already existing |
501 |
ZJ_USE_AC is set to Y |
506 |
Eval Cost Ind is invalid |
507 |
Alternate number and split_qd_seq may not be set together |
511 |
First Ship > Last Ship |
513 |
Project default ZP_DEVATTR not set |
521 |
Creation of a detail tag is not allowed |
522 |
Update quantity of master tag is not allowed |
530 |
Alternates or splits cannot be created for master or detail tags |
531 |
Text and term is already attached |
539 |
Unit price and unit price type don't match |
540 |
Other cost%, cost value, and unit price type do not match |
702 |
Setting of login environment failed |
703 |
Quote does not belong to current login project |
1001 |
Import attribute which is not defined for quote summary |
The Approved Date field shows the date when the quote was approved.