Enter Vendor Pricing

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 Background and Road Map for more information.

  1. Enter the item number or click the Lookup icon and use the standard lookup options to select the item from a list.

    OR

    Enter * to set up a default record that contains the most likely choices for fields. See Create a Default Record for a Maintenance Program.

The program displays these fields listing existing vendor/item :

Field Name

Displays

Vendor no

The number of the vendor from whom you can purchase this item

Seq

The sequence number assigned to this vendor and item

Vendor item no

The vendor's number for this item

QA apprd?

A check mark indicates that quality assurance has approved this item

Pref?

A check mark indicates that this is the preferred vendor for this item

Insp?

A check mark indicates that this item requires inspection

M/L

Whether the item is material or labor

Pur UOM

The unit of measure used to purchase this item

Stk UOM

The unit of measure in which the item is stocked

UOM conv

The factor to convert purchasing to stocking units of measure

Vendor name

The name of the vendor

Act L/C?

A check mark indicates that you enter invoices for actual landed costs associated with procuring this item

Land cst 1-4

Up to four landed cost codes associated with procuring this item

LT

The vendor's lead time for the item

Surcharge?

A check mark indicates there is a surcharge code

  1. Choose the appropriate options:

To

Do This

Add a vendor-item pricing/surcharge record

Click Add. See step 3.

Delete a vendor-item pricing/surcharge record

Highlight a line a click Delete. See Delete.

Copy a vendor-item pricing/surcharge record

Highlight a line a click Copy. See Copy.

Display or change a vendor's pricing

Highlight a line a click Select or double click the line. See step 3.

Print the list of vendors

Click Print. See Print.

Output a request for quote

Click Request quote. See Request a Vendor Quote.

Control which price records are displayed

Click Prog opts.

Select Display current pricing only? to limit the display to prices that are currently in effect when you select a vendor and click Pricing. Select Save options if you want to save the setting for future runs of the program.

Specify a different item

Click OK. See step 1.

Exit the program

Click Exit.

  1. Enter or change data in these fields:

Field Name

Type / Max Length

Action / Description

Item  number

Display only

The item number you specified followed by its description.

Vendor number

Required
3 alphanumeric

The program prompts Vendor number. Enter the vendor number or click the Lookup icon and use the standard lookup options to select the vendor from a list. The program displays the vendor's name and currency code.

Note
The vendor number cannot be changed once a record has been created.

Sequence number

Required
3 alphanumeric

Accept the displayed unique sequence number or enter a different one.
Note
The sequence number cannot be changed once a record has been created.

Vendor item no

Optional
30 alphanumeric

Enter the vendor's number for this item or a description of the item that identifies this item from this vendor. You can associate up to 999 different vendor item numbers with an inventory item and vendor.

QA approved?

Optional 

Select if quality assurance has approved this item or leave blank if QA has not approved this item.

If you leave blank, when you enter a PO for this item and vendor, the PO Maintenance (VOE) program displays an advisory message and allows the operator to continue.

If the QA Approved? field is not selected when a PO line for this item and vendor is received, the receiver line will be marked as requiring inspection.

You must select this field if you are creating pricing for a consignment item.

Preferred item?

Optional

Select if this item is preferred over other equivalent items from this vendor or leave blank if this item is not preferred.

Though a vendor's item can be set up multiple times, only one can be preferred. If you previously selected another preferred item, the program displays the message Do you want this to be the preferred item? Click Yes to confirm or click No to exit this vendor record.

You must select this field if you are creating pricing for a consignment item.

Inspection?

Optional

Select if you want this item to be inspected when you receive it from this vendor or leave blank if you do not.

Note
If you selected the Inspection? field for this item in the Branch Item Maintenance (IMB) program, this field is selected and you cannot clear it.

Material/Labor

Required

Select M Material or L Labor (an outside service).

If L is selected, Purchasing UOM is set to the item's stocking UOM and UOM conversion is set to 1.

Stocking UOM

Display only

The item's stocking unit of measure code followed its description

Purchasing UOM

Required
4 alphanumeric

Select the unit of measure in which you purchase this item from this vendor.

UOM conversion

Required
11 numeric in the format 999999.99999

Accept 1.0000 if you purchase and stock this item in the same unit or enter the conversion factor if you purchase the item in a different unit than you stock it.

The system multiplies the quantity ordered by this conversion factor prior to updating the inventory. For example, if there are 500 sheets in a ream of paper and 10 reams in a box, the conversion factors are:

Stocking UOM

Purchasing UOM

Conversion factor

sheet

ream

500

ream

box

10

box

box

1

Vendor LT

Optional
5 numeric in the format 999.99

Enter the number of days that elapse between placing a purchase order and the receipt of the goods at your dock.

This field is not used by the system, but you can use it in custom reports.

Landed costs 1-4

Optional

Select a landed cost code or leave blank if landed costs do not apply to this vendor and item. See Overview: Landed Costs.

Note
These fields may have different labels based on the Landed cost type 1 - 4 option in the System Options Maintenance (XM) program (Accounts Payable Options). Use Landed Cost Codes Maintenance (TMM) to set up landed cost codes and percentages.

Use actual landed costs

Optional

Select if you want to track actual landed cost invoices to the purchase order/receiver to reflect the actual cost of obtaining this item.

Leave blank if you have entered landed cost codes and want the system to apply a standard percentage to the item’s purchased cost when the item is received.

Surcharge codes 1-4

Optional

Select a code that you set up in the Surcharge Codes Maintenance (TSCM) program. Up to four surcharge codes can be associated with a pricing record.

Amount

Optional
14 numeric in the format 999999999.99999

Enter a fixed amount to be applied per unit in this vendor's currency. For example, enter 1.85 if the surcharge is 1.85 per purchased unit ordered.

Percent

Optional
5 numeric in the format 999.99

Enter the percent of unit cost to be applied to each unit ordered. If the rate is 1.5%, enter 1.50.

Note
If you enter both an amount and a percent, the program calculates: (Unit cost x Percent) + Amount.

Incl in actl?

Optional

Select if you want this surcharge to be included in the item's actual cost or leave blank if you do not.

If you select this field and you selected the Update average/actual costs? option in System Options Maintenance (XM) - Inventory Control Options, the system updates this item's actual cost when you receive it.

  1. Choose the appropriate options:

To

Do This

Change a field

Move the cursor to the field and make changes. Click Apply to accept your changes or click Cancel to abandon them.

Delete a saved record

Click Delete.

Enter notes for this vendor and item

Click Notes. A green check mark on the button indicates there are notes for the displayed vendor price record. See Enter Notes.

Enter data in custom fields your company uses

Click User. See Enter Data in User or Shadow File Fields.

Note
This button displays only if you have set up user fields for this program in the User Fields Maintenance (XMO) program.

Go to a related program

Click Jump. See Jump.

Change the sequence number

Click Change no.

Note
This button displays only when you add a new vendor.

Display changes to this pricing record

Click Audit. See Display an Audit Trail.

Note
This button displays if audit trail logging is activated for the Vendor Item (V1A) file.

Enter this vendor's price breaks or a unit price for a consignment item

Click Pricing. See Enter Price Breaks.

View related information

Click View. See The View Button.

Add a compliant manufacturer for this item

Click Compliance. See Enter Compliant Manufacturers for an Item.

View or import documents associated with this vendor pricing record

Click Documents.

  • Click View to view archived and imported documents, See Display Document Archive. The View button is active only if archived documents are available.

  • Click Import to import a document for this invoice.

See Document Archiving and Document Import for more information.

Note
This button displays only if the document import feature is active. When the feature is active, the button is disabled for sequence numbers greater than 9.

Accept the data and return to the list of vendors

Click OK. The program prompts Vendor number. See step 2.

Exit to the menu Click Exit.