Option 1Purchase Price By Product

This function is used to change purchase prices for a product from a specific vendor. The system displays the following information from the Products By Vendor record:

• Product description
• Stockkeeping unit of measure
• Current price and last purchase price
• Date the product was last purchased
• Date the price was last changed

The system changes the current price and last price online when the user presses RETURN to go on to the next price change entry. It also updates any reorder records for this product/vendor.

Select “Purchase Price By Product” from the Utilities and Special Edits menu. Here is a sample Price Changes By Product screen:

Purchase Price By Product screen

Certain entries on this screen will be automatically displayed. In most cases, the displayed entry can be changed. If an asterisk (*) appears next to one of the fields listed below, it indicates a “display only” field, which cannot be changed.

When the key value for a particular record is requested, you can review all the records in the file by selecting the Scan option. The records will be presented on an “Access” screen, and you will be allowed to scan the available data until you find the record you want. Then, position the cursor by that record and press RETURN; the record will be displayed for editing.

Data items for the preceding screen are described below:

Product

Enter the number of the product for which the price is being changed. You can use the Scan option to find an appropriate entry. This product must be on file in the Products file.

Vendor

Enter the number of the vendor supplying the product. You can use the Scan option to find an appropriate entry. The combination of this number and the product number must be on file in the Products By Vendor file. Also, if the Accounts Payable application is part of the system, this number must be on file in the Vendors file. The system displays the vendor name so that you can verify your entry.

Press RETURN to enter the New Price.

New Price

Once the product and vendor numbers have been entered, the system displays the current price. You may enter up to 6 digits and 3 decimals for the new unit price of the product. Press RETURN and the new price you enter automatically updates the Current Price field below.

Product Description*

The system displays the product description from the Products record.

Unit of Measure*

The system displays the product’s stockkeeping unit of measure from the Products file.

Current Price*

The system displays the vendor’s current unit price for the product from the Products By Vendor file.

Last Price*

The system displays the unit price used on the last order placed with the vendor from the Products By Vendor file.

Last Purchased*

The system displays the date of the last order for this product placed with this vendor from the Products By Vendor file.

Last Price Change*

The system displays the date of the last price change for the product. This date reflects the last time either the Purchase Price By Product or the Purchase Price By Percentage utility was run; or the price was changed in Products By Vendor File Maintenance.

Press RETURN to save the information on this screen and update the Products By Vendor file.

Select Next Record to go to the next Purchase Price By Product record.

At this screen, use of the MODE keys — CHG, or INQ — pertain to those records in the Purchase Price By Product file.