Background: Vendor Price Maintenance

Use the Vendor Price Maintenance (VMM) program to enter and change a vendor's pricing, landed costs and surcharges for an item and request a quote. See Road Map for work flow.

This topic has these sub-topics:

Vendor Items, Pricing and Additional Charges

Request for Quote

Price Breaks

Audit Trail

Consignment Items

 

Vendor-Items, Pricing and Additional Charges

The Vendor Price Maintenance (VMM) program performs multiple functions. For any item and vendor, you can enter:

  • A price for each minimum order quantity for one or more vendors.

  • Multiple records for each vendor's item to differentiate revision levels and other factors. Each record includes the purchasing unit of measure, the vendor's item number, and whether the item is QA approved or requires inspection.

  • Landed costs. Shipments received from certain locations may incur landed costs, such as import duties and broker, trailer, freight, and storage fees. You can track these costs separately and include them in the cost of purchased items. The Vendor Price Maintenance program lets you set up landed costs for any item and vendor. See Overview: Landed Costs.

  • If your vendors add energy and other surcharges to goods you purchase from them, you can add these surcharges to your purchase orders and calculate the amount owed. First you need to set up codes in the Surcharge Codes Maintenance (TSCM). For vendor surcharges, only the code and description are required; the surcharge amount or percentage is entered by item and vendor in VMM. If you select the Incl in actl? field, the system adds the surcharge to the actual cost of the item when you enter the invoice (if you have you selected the Update average/actual costs? option in the System Options Maintenance (XM) program (Inventory Control Options)).

  • The PO Maintenance (VOE) program displays the surcharges for the item and adds the total estimated surcharge to the total PO cost. The total estimated surcharge prints on the purchase order. If you select the Print surcharge detail? Program option in the PO Print (VOP) program, surcharge codes and amounts print on the PO.

Price Breaks

You can use the Vendor Price Maintenance program to set a price for one unit or price breaks based on minimum order quantities. Each pricing record has an effective date range. You can set up multiple structures, each with a different effective date for one item. The Percent button lets you quickly adjust all prices by a percent change.

To compare different vendor prices for an item, run the Vendor Price Listing (VML) program and enter the item number as a Selection option.

If a vendor pricing exists for an item, the PO Maintenance (VOE) program uses the pricing information when you enter a purchase order. You can use the quantity and price you select or enter change the quantity and price if necessary.

Consignment Items

If you have a consignment inventory item, you selected the Consignment? field in an item's record in the Branch Item Maintenance (IMB) program. You need to enter a record for the item's Preferred vendor (specified in Branch Item Maintenance). When you click Pricing, you see the record the system creates with your login date as the effective date, 12/31/9999 as the expiration date, and the minimum order quantity of 1. Select the record to enter the pricing for this item.

You can change the unit price at anytime, but you cannot change the minimum quantity, and you cannot delete the price record for the item's preferred vendor.

Surcharges

 

Request for Quote

You can output a request for quote for one or more vendors. When click Request quote, you can enter quantities of the item you wanted quoted. The quote request includes the current quantities in addition to the quantities you enter. If you do not enter quantities, the quote request is for the current minimum order quantities.

The Request for Quote contains this information:

  • Branch address, phone number, and fax number or your logo if you entered a filename in the Header image name field for this document in the Document Output Parameters Maintenance (TDOC) program

  • Vendor number

  • Vendor address

  • Page number

  • RFQ (Request for Quote) number

  • RFQ date

  • Vendor item no

  • Your item number

  • Item Description

  • Quantity of item

  • Space for the vendor to write their quote for each quantity

Audit Trail

To activate an audit trail, select one of the files listed below in the Audit Trail Maintenance (XAT) program. The system records all transactions. You can then run the Audit Trails (ATR) program and select that file to print a report of these transactions.

  • V1A: Vendor Price

  • V1AP: Vendor Item Pricing