Note: This help system contains standard information only. Click the Help button on the relevant form or menu to display any manufacturer-specific help. Alternatively, a help file may exist in the Table of Contents specific to your manufacturer.
Some smaller parts suppliers issue single price files that contain parts for different manufacturers. A facility is available that enables you to update the price file in the Autoline standard MS-00 company with this data.
In order to perform an update, ensure that you:
Save the file in csv format, if necessary, and split the file so that it contains parts for one franchise only.
Carry out system maintenance to identify the location of the source file, and location of data in the source file.
Set up the Stock Management, franchise table, correctly. Enter 00 in the Price file code field of the franchise code record used by the parts supplier.
To update the price file in the MS-00 company:
Note: The following routine adds or changes records in the existing price file before it converts the new files. Ensure that the new files are in place, and that a backup has been taken recently.
From the ADP STANDARD OPERATIONS menu, select the Price file menu option.
The MASTER PARTS PRICE FILE MENU is displayed.
Select the Generic price file import option.
The system displays the following message:
This function updates the master parts price file in the Autoline Standard MS-00 company.
Click OK.
The Generic price file conversion form is displayed.
Enter the Franchise code of the parts supplier.
Tip: A list of valid franchise codes is available from the drop-down menu.
Click Import data.
The system starts to transfer the file. On completion, the following message is displayed:
File transfer complete
Click OK.
Note: If the transfer fails, check that the source file is named correctly on the File Transfer tab of the Price File Upload and Convert Record Form. If it is, there may be a problem with your computer cabling. Contact your System Administrator.
The system displays the Update generic price file form which shows the first ten records contained in the source file.
The system displays a progress of the update.
Warning: If there is a problem with the source data, the system identifies what the problem is and asks you how you want to proceed. For further details, see Troubleshooting.
This form is displayed when you select the Generic price file import option from the MASTER PARTS PRICE FILE MENU. From this form, you can upload and convert a generic parts file in csv format, and access records that contain details about the source data.
Franchise code: Franchise code of the parts supplier.
Import data: Imports data to the Autoline system.
Update price file: Updates the price file in the Autoline standard MS-00 company.
System maintenance: Enables you to identify the location of the source file and where data is held within the file.
PUSH BUTTONS:
Exit: Returns you to the MASTER PARTS PRICE FILE MENU.
Help: Displays help on the current application using the default browser.
If there is a problem with any of the records in the csv file, the system displays up to four options. Following is a description of what the system does when you select an option, and a list of some of the errors that can occur:
Ignore Updates the record with a price of 0 (zero). Skip Ignores the part and goes to the next record. Skip-all Skips every record with problem data in the field. Cancel Aborts the routine. Alpha character in # field - row number # Cause: There is an alpha character in a field which should be a numeric. The system identifies the field and row number in which the error occurs. Not enough columns on source data Cause: The number of columns in the source file is less than the columns specified within the Price file upload and convert record.
Updating the Stock File from the Price File
