Update
Items from Vendor Price List
Program/Screen: SAIPDC/SAIPDC10
Description:
Use this screen to set the parameters for uploading a vendor's price list flat file to RentalMan. Before running this program, create the definition to use during the upload via the Price Definition Maintenance program.
After running this upload program, perform Run Price/Cost Update without updating files to verify that all information is correct. Then perform Run Price/Cost Update again and update the master files.
Click a link to advance to that section of the topic.
Navigation
Enter the number of the vendor price list definition to use for the upload, and enter when you want the list prices to go into effect. If you also want to create a catalog file from the vendor's price list flat file, you can optionally enter a prefix to append to all items in the catalog to make it easier to search for them. Finally, enter the file name or PC folder where the vendor's flat file is located.
Fields
Enter the number of the price list definition you want to use to upload the vendor's flat file.
Enter the date at which the vendor's list prices become effective.
Indicate whether you also want to create a vendor catalog file in addition to updating items with the vendor's list prices. You can use this catalog file to search for vendor items (ones you do and do not stock) via the Parts/Merchandise Search by Catalog Items program.
The Effective Date field is not used when this field is set to Y.
If you are also creating a catalog file during this upload process, optionally enter a prefix to append to the item numbers in the catalog. For example, if you are uploading a vendor price list for NAPA parts, you could enter a prefix of NAP to append to all of the item numbers in the price list. This groups all of the items together in the search results screen when you search by catalog items.
Back to top
Enter the name of the physical file on the AS/400 (System i) server that contains the information to upload. If you use this field, you must enter a library name.
If you entered a file name, enter the name of the library where the file is located.
If you did not enter a file name and library, enter the name of the folder on your PC or shared network drive that contains the information for the upload. If you use this field, you must enter a PC document name.
If you entered a PC folder, enter the name of the file in the folder that is to be uploaded.
Function Keys
|
Function Key |
Description |
|
F1 |
Help. Place your cursor in a field and press F1 to access online help for that field. Place your cursor outside of any field, and press F1 to access online help at the program level. |
|
F3 |
Exit. Exit the page or program. |
|
F4 |
Search. Place your cursor in a searchable field and press F4 to access a lookup window or more advanced search screen. |
|
F5 |
Output. Advance to the Work with all Spooled Files screen where you can view a list of all of your spooled print jobs. |
|
F6 |
Messages. Advance to the Display Messages screen where you can view all of your system messages. |
|
F9 |
Delete. Advance to the Delete Item Catalog Records screen where you can enter the number of the vendor price list definition that created the catalog you want to delete. |
|
F12 |
Cancel/Previous. Exit the program or move back a screen. |
|
F14 (Shift + F2) |
Submitted Jobs. Advance to the Work with Submitted Jobs screen where you can view a list of all of your submitted jobs. |
Related Programs
Back to top