Price
Definition Maintenance Price
Definition MaintenanceUse this screen to set up the definition for uploading prices from a vendor file. Use the Update Items from Vendor Price List program to actually upload the vendor file.
Next, 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.
Access this screen by entering a price list definition number on the Price Definition Maintenance - Launch screen. Enter a description, vendor, and currency for the price definition. Make other settings such as the type of item number (item, manufacturer, or vendor) that the vendor is sending in their price list file and the freight factor to apply to the list prices.
In the lower section of the screen, indicate the fields that the vendor has in their flat file by entering a starting position and field length. For fields that are monetary amounts or other numerical figures, enter the number of decimal places the vendor used.
After setting up the price list definition, you will run the Update Items from Vendor Price List program to upload the vendor's list prices to the sales item master file. Next, 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.
Price Definition Maintenance - Launch
Price Definition Maintenance - Copy
Price Definition Maintenance
Displays the number of the price list definition you are creating or maintaining.
Enter a brief description of the price list definition.
If applicable, enter the number of the vendor with which you want to update the sales item master and location files for the items where prices are uploaded.
If applicable, enter the stock class with which you want to update the sales item master and location files for the items where prices are uploaded.
Enter the currency in which the prices are listed.
Indicate which type of item number the vendor used in their price list. For example, if you enter M=Manufacturer Number, the system matches the item numbers in the vendor price list file to the number you have in the Manufacturer's Item Number field in the sales item master records.
Back to top
Enter the percentage to multiply against the item's vendor list price to arrive at the Adjusted list price as displayed in the Price/Cost Update program.
Indicate whether to update the item's UPC code while updating cost and pricing information.
Calculate Cost as a Percentage of the List Price
Indicate whether you want to calculate an item's cost as a percentage of the its list price. Use the Discounts fields to enter the percentages to use in the calculation.
Enter one or more discounts for the system to use when calculating item costs from the list prices. For example, the vendor may give 10% and 2% discounts. In this case, if an item's list price is $100, the system first calculates a 10% discount to arrive at $90. It then calculates a 2% discount on the $90 to arrive at a cost of $88.20.
Enter the code that represents the link between the items in the vendor's price list file and the G/L sales revenue distribution file. This information is needed only if you plan to build a catalog file from the vendor price list, and you want to be able to order items from that catalog that you do not normally carry in stock. When you order one of those items, the system automatically creates an item master record for it and uses this G/L category in the record.
If you plan to build a catalog file from the vendor price list, enter the code to assign to items that you order from the vendor's catalog that you do not normally stock. When you order one of those items, the system automatically creates an item master record for it and uses this PME code in the record . Valid codes are:
P - Part
M - Merchandise
E - Equipment
Field
Displays the name of the field that the vendor might have in their price list file. At minimum the vendor should have the Item Number and the List Price fields in their file.
Fields marked with an asterisk (*) are written to a catalog file only. 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.
For any field that the vendor has in their price list flat file, enter the starting position for that field. For example, if the Item Number field is the first field in the file, it starts at position 1. If the Description is the second field, and it starts right after the item number, which is 30 characters long, the starting position for Description is 31.
For any field that the vendor has in their price list flat file, enter the total character length of that field. For example, if the Description field is 25 characters long in the file, enter 25.
For any field that the vendor has in their price list flat file that is an amount, enter a digit that represents how many decimal places are displayed for the amount.
|
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. |
|
F12 |
Cancel/Previous. Exit the program or move back a screen. |
Update Items from Vendor Price List
Back to top