Working with Vendors (WVEN)

Vendors are companies who supply you with merchandise or services. A record must be established on the system for every vendor from whom you purchase merchandise.

In this chapter:

Work with Vendors Screen

First Create Vendor Screen

- Second Create Vendor Screen

- Email Address for Drop Ship Vendor Window

First Change Vendor Screen

First Display Vendor Screen

Display Vendor History Screen

Change Vendor Extended Screen

- Display Vendor Extended Screen

Work with Vendor Discounts Screen

- Combined Discount Calculation

- Tiered Discount Calculation

Work with Vendor Contacts Screen

- Create Vendor Contact Screen

Work with Vendor FOB Address Screen

- Create Vendor FOB Address Screen

Work with Vendor Notes Screen

Upload vendors: You can upload vendor information into Order Management System using the Load Vendor Upload menu option; see Working with Vendor Upload (LVUP).

Work with Vendors Screen

How to display this screen: Enter WVEN in the Fast path field at the top of any menu or select the Work with Vendors option from the menu.

Field

Description

Vendor #

A code that identifies a supplier who sells you goods or services.

Numeric, 7 positions; optional.

Name

The name of the vendor.

Alphanumeric, 30 positions; optional.

State

A code representing a state or province where a vendor's business is located.

State codes are defined in and validated against the State table, which is accessible through the Work with Countries menu option; see Setting Up the Country Table (WCTY).

Alphanumeric, 2 positions; optional.

Postal

The vendor's postal (zip) code.

Alphanumeric, 10 positions; optional.

Telephone #

The vendor’t telephone number.

Alphanumeric, 14 positions; optional.

Ext

The vendor’s telephone number extension.

Alphanumeric, 4 positions; optional.

Screen Option

Procedure

Create a new vendor

Select Create to advance to the First Create Vendor Screen.

Change vendor information

Select Change for a vendor to advance to the First Change Vendor Screen.

Delete vendor information

Select Delete for a vendor to delete it.

An error message displays if vendor items exist for the vendor: WARNING - VENDOR ITEMS EXIST. Press ENTER or Click OK to confirm delete of Vendor & Vendor’s Items.

Display vendor information

Select Display for a vendor to advance to the First Display Vendor Screen.

Create a vendor discount

Select Discounts for a vendor to advance to the Work with Vendor Discounts Screen.

Display vendor history

Select History for a vendor to advance to the Display Vendor History Screen.

Work with vendor contacts

Select Contacts for a vendor to advance to the Work with Vendor Contacts Screen.

Work with vendor FOB addresses

Select FOB for a vendor to advance to the Work with Vendor FOB Address Screen.

Display vendor notes

Select Notes for a vendor to advance to the Work with Vendor Notes Screen.

Work with user defined fields

Select User Field for a vendor to advance to the Work with User Fields Screen.

First Create Vendor Screen

Purpose: Use this screen to begin to create a vendor. This is the first of two Create Vendor screens; when you complete this screen, you advance to the Second Create Vendor Screen.

How to display this screen: Select Create at the Work with Vendors Screen.

Field

Description

Vendor

A code that identifies a supplier.

Numeric, 7 positions.

Create screen: required.

Change screen: display-only.

Name

The name of the vendor or the vendor's company.

Alphanumeric, 30 positions; required.

Address

The vendor's address, as it should appear on purchase orders.

Alphanumeric, 3 lines with 32 positions each line; required.

City/

State/

Postal/

Country

The city, state, postal zip code, and country associated with the vendor.

If the Require state field for the country in the vendor address is selected, the system requires a state code for the vendor address: State is required for this country.

Note: The system does not validate the vendor’s address in the same way it validates a customer’s address, as in order entry. For example, it does not validate that the state is associated with the SCF for the postal code.

City: alphanumeric, 25 positions; required.

State: alphanumeric, 2 positions; optional.

Postal code: alphanumeric, 10 positions; optional.

Country code: alphanumeric, 3 positions; required.

Contact name

The name of your primary contact at the vendor site. This name prints on purchase orders. You can create additional contacts for a vendor from the Work with Vendor Contacts Screen.

Alphanumeric, 30 positions; optional.

Phone #/Ext (Telephone number and extension)

The vendor's telephone number and extension. You can define a telephone number format to map to the phone numbers operators enter into the system. Telephone number formats are defined by arranging numbers and special characters such as hyphens and parenthesis in the same order and position as the numbers in a phone number would display. When an operator enters a phone number, the system compares the number of numeric characters in the phone number with the telephone number formats you have defined. In order to match a format, the phone number must have the same number of numeric positions as a telephone number format. If the system cannot find a match, the phone number does not map to a telephone number format and is saved as it was entered by the operator.

Phone #: alphanumeric, 14 positions; optional.

Extension: alphanumeric, 4 positions; optional.

Fax#

The telephone number for the vendor's fax machine.

Faxing purchase orders or drop ship picks to the vendor is not currently implemented.

Alphanumeric, 14 positions; optional.

Email

The vendor’s email address. See Email Address Validation for information on how the system verifies that your entry is formatted correctly.

Emailing Purchase Orders

If the Email Purchase Order (K80) system control value and the vendor’s Email P/O flag are selected, the system sends the purchase order to the vendor as an email attachment. See the Email Purchase Order (K80) system control value for more information.

Alphanumeric, 50 positions; optional.

Email P/O

Indicates whether to send the purchase order to the vendor’s email address as an attachment. Valid values are:

Selected = Email the purchase order to the vendor. The .PDF file is attached to a plain-text email that is sent to the vendor’s Email address.

Note: If this field is selected, then you need to specify a valid Email address for the vendor.

Unselected = Generate a .PDF file for printing.

Regardless of the setting of this flag, you cannot send purchase orders by email unless the Email Purchase Order (K80) system control value is selected. See that system control value and Purchase Order Emails for more information on sending purchase orders to the vendor by email.

Remit to

The name of the person or company you send payment to for vendor invoices.

The remit-to address prints on checks for the vendor.

Note: If any portion of a name or address appears in the Remit to fields, the system will bypass the vendor name and address and print the Remit to name and address on checks. If you enter any information in the Remit to fields, be sure that it is correct and complete.

Alphanumeric, 30 positions; optional.

Address

The address where you mail checks for the vendor.

Alphanumeric, 30 positions; optional.

City/State/Postal/Country

The city, state, postal zip code, and country where you should mail payment to the vendor.

If the Require state field for the country in the vendor address is selected, the system requires a state code for the vendor address: State is required for this country.

Alphanumeric, 25 positions; optional.

Email

The remit to vendor’s email address. Informational only. See Email Address Validation for information on how the system verifies that your entry is formatted correctly.

Alphanumeric, 50 positions; optional.

.

Screen Option

Procedure

Complete creation of a vendor

Select OK to advance to the Second Create Vendor Screen.

Create the Vendor Extended record

Select Create Vend Ext to advance to the Change Vendor Extended Screen.

Second Create Vendor Screen

Purpose: Use this screen to complete entry of a vendor.

How to display this screen: Select OK at the First Create Vendor Screen.

Field

Description

Print PO

Indicates whether purchase order forms print or are emailed for this vendor. If so, you order products on the purchase order, print it, then mail it to the vendor.

Selected = Print or email purchase orders for this vendor.

Unselected = Do not print or email purchase orders for this vendor.

Note: If the Email P/O flag is selected, then this flag also needs to be selected.

Drop ship output

Indicates whether to process drop ship orders by printing purchase orders, pick slips/invoices, or transmitting information through the Order Broker interface for internet-based drop ship processing. Drop ship merchandise is merchandise that you sell but do not stock. Only items flagged as Drop ship are eligible for drop ship processing.

Drop ship pick = Print drop ship pick slips/invoices for this vendor.

Drop ship purchase order = Print drop ship purchase orders for this vendor. When you print a drop ship purchase order, the system also prints a drop ship pick slip/invoice.

OROB drop shipping = Send drop ship purchase orders to Order Broker’s Supplier Direct Fulfillment module for internet-based processing.

See Selecting Vendors for Drop Ship Processing (MDSP) for information on generating drop ship pick slips or purchase orders.

Drop Ship integrations

The Order Broker Drop Ship Integration provide access to internet-based, collaborative environments for retailers and vendors to share and process information related to drop ship orders. If you use either of these integrations, your system generates drop ship purchase orders and automatically distributes them to the integrated application.

OROB drop shipping is a valid selection only if the Use OROB Drop Shipping (H13) system control value is selected. If this system control value is unselected when you try to select OROB drop shipping, a message indicates Collaborative shipping vendor is not allowed.

If you select OROB drop shipping, the Email Address for Drop Ship Vendor Window opens unless you have entered a vendor email address on the Create Vendor Contact Screen.

Generating CWPickOut messages: The system also creates pick download triggers (File code of PCH) in the IL Outbound Trigger table when you generate a drop ship invoice if the Create Generic Pick Download Triggers (I31) system control value is selected. The PICK_OUT process in Working with Integration Layer Processes (IJCT) generates the Pick Message from Order Management System (CWPickOut) for each of these trigger records.

 

Scheduling: See Process Drop Ship Orders to process drop ship picks or purchase orders using the periodic function DSHPROC.

Alphanumeric, required.

Cutover date

The date when you switched a vendor’s Drop ship output to OROB drop shipping, indicating when the system sends all new drop ship purchase orders for the vendor to Order Broker’s Drop Ship Manager module.

No cutover date is indicated if you did not switch the vendor’s Drop ship output setting to OROB drop shipping: for example, if you assigned the vendor to OROB drop shipping at initial creation.

Included on the Change and Display screen only.

Numeric, 6 positions (in user date format); display only.

D/S batch size (drop ship batch size)

The number of picks to include in a drop ship batch when you are Processing Drop Ship Orders by Batch (MDSB) for this vendor. The drop ship batch size determines the number of pick slips that print in one batch before the system creates a new batch.

Example:

Batch size = 2

# of picks to release = 5

In this situation, the system generates 3 batches:

Batch 1 contains 2 pick slips

Batch 2 contains 2 pick slips

Batch 3 contains 1 pick slip

Numeric, 7 positions; optional.

PO ship via

A code that represents the shipper used for shipping merchandise to your company from this vendor.

Purchase order ship via codes are defined in and validated against the PO Ship Via table; see Working with Purchase Order Ship Via (WPSV).

Numeric, 2 positions; optional.

Terms

A code for the terms and conditions for payment to the vendor, such as 30 days after invoice date or at the end of the month.

Numeric, 2 positions; optional.

Discount % (Primary discount percentage)

The primary discount percentage applied towards items purchased from this vendor.

This discount is applied to the dollar value of merchandise and is taken during Purchase Order Maintenance. Any other discounts from the Vendor Discount table are applied after the primary discount has been calculated. See Work with Vendor Discounts Screen.

Numeric, 5 positions with a 2 place decimal; optional.

Surcharge %

A standing surcharge added to purchases from this vendor.

A surcharge is typically added to purchases from a broker. The percentage is based on the item price in Purchase Order Maintenance.

Numeric, 5 positions with a 2 place decimal; optional.

Quality rating

The vendor's quality rating, as calculated by the quality assurance database. Not currently implemented.

Numeric, 5 positions with a 2 place decimal; system-assigned.

A/P interface vendor

The vendor code on your third party Accounts Payable system. This code is used as a bridge between Order Management System and your own Accounts Payable system.

Alphanumeric, 10 positions; optional.

Parent vendor

A code for a company that is made up of one or more subsidiary vendors. If your unique interface program supports it, you can define a vendor as a parent vendor if you wish to pay the main (parent) vendor for the merchandise you received from each subsidiary (child) vendor.

• If the vendor code defined in this field matches the code you are creating, this vendor represents a parent vendor.

• If the vendor code defined in this field does not match the code you are creating, this vendor represents a child vendor.

 

Example: Vendors 101, 102, and 103 all report to vendor 10123. Instead of paying vendors 101, 102, and 103 separately for the merchandise you received, you can pay vendor 10123 for all of the merchandise you received from each of the subsidiary vendors.

If the Require Entry of Parent Vendor system control value is selected, you must enter a valid vendor code in this field or an error message indicates:

Parent Vendor number is required.

Note: Used only if your unique interface program supports it.

Numeric, 7 positions; optional.

Currency code

A code to identify a currency type. This code is used by the Purchase Order system to identify a vendor's currency and to perform currency conversion processing if the vendor's currency is different from yours. Currency codes are defined in and validated against the Currency Code table (fast path = WCUR). Defaults from the Local Currency Code (A55) system control value, but you can override it.

The currency code you enter here defaults when you enter purchase orders, but you can override it.

Note: The Supplier Direct Fulfillment integration does not support currency conversion.

Alphanumeric, 3 positions; required.

Vendor price currency

Indicates whether the prices from this vendor are in the system's currency or the vendor's own currency and controls how and when currency conversion takes place.

 

 

Note: If this field is set to N or V, you must define vendor items in the Vendor Item table for the system to calculate the cost at the time of receiving.

If you override the currency rate during Purchase Order Receiving, the system uses the following calculation:

Price from Purchase Order/current currency conversion rate.

Note: The Supplier Direct Fulfillment integration does not support currency conversion.

Alphanumeric, 1 position; required.

VAT number

A number used when calculating foreign currency.

Alphanumeric, 20 positions; optional.

Type of vendor

Identifies whether the vendor is an actual vendor or a manufacturer. Valid values are:

Manufacturer

Vendor

User fields

Use these fields to enter additional vendor information.

The system defaults the Vendor user field 3 to the Item user field 3 field in Work with Item/SKUs (see Performing Initial Item Entry (MITM)) when you create or change an item and the program name INR1156 has been defined in the User function field for the CHGITEM and ADDITMSKU user exit points. See Working with User Exit/Edit Point (WUEP).

Alphanumeric, three 10-position fields; optional.

Screen Option

Procedure

Create the Vendor Extended record

Select Create Vendor Ext to advance to the Change Vendor Extended Screen.

Email Address for Drop Ship Vendor Window

Purpose: Use this window to enter an email address for a vendor when you use the interface with Order Broker’s Drop Ship Manager to process drop ship orders for the vendor.

Order Broker automatically sends email notification to vendors when you create and send drop ship purchase orders or when you request cancellation of an order line or change an order’s shipping address.

How to display this screen: Select OROB Drop Shipping in the Drop ship output field on the Second Create Vendor Screen. If you have not entered an email address for the vendor in the Create Vendor Contact Screen, this pop-up window opens.

Field

Description

Email address

The vendor contact's email address. See Email Address Validation for information on how the system verifies that your entry is formatted correctly.

Alphanumeric, 50 positions; optional.

First Change Vendor Screen

To change: Select Change for a vendor at the Work with Vendors Screen to advance to the first Change Vendor screen. At this screen you can change any information except the vendor code. Select OK to advance to the Second Change Vendor Screen.

See First Create Vendor Screen and Second Create Vendor Screen for field descriptions.

Second Change Vendor Screen

How to display this screen: Select OK at the First Change Vendor Screen.

See Second Create Vendor Screen for field descriptions.

Screen Option

Procedure

Display vendor history

Select Display Vendor Hist to advance to the Display Vendor History Screen.

Display vendor extended information

Select Change Vendor Ext to advance to the Display Vendor Extended Screen.

Work with vendor contacts

Select Vendor Contacts to advance to the Work with Vendor Contacts Screen.

Display vendor notes

Select Notes/comments to advance to the Work with Vendor Notes Screen.

First Display Vendor Screen

To display: Select Display for a vendor at the Work with Vendors Screen to advance to the first Display Vendor screen. You cannot update any information on this screen. Select OK to advance to the Second Display Vendor Screen.

See First Create Vendor Screen for field descriptions.

Second Display Vendor Screen

How to display this screen: Select OK at the First Display Vendor Screen.

See Second Create Vendor Screen for field descriptions.

Screen Option

Procedure

Display vendor history

Select Display Vendor Hist to advance to the Display Vendor History Screen.

Display vendor extended information

Select Display Vendor Ext to advance to the Display Vendor Extended Screen.

Work with vendor contacts

Select Vendor Contacts to advance to the Work with Vendor Contacts Screen.

Display vendor notes

Select Notes/comments to advance to the Work with Vendor Notes Screen.

Display Vendor History Screen

Purpose: Use this screen to review performance statistics for this vendor. The OTHR_ASYNC job updates this information.

Note: Purchase orders that you unlock through the Unlock Purchase Order (MUPO) option are not submitted (or resubmitted) to the OTHR_ASYNC job. As a result, there is no mechanism to Vendor History based on activity that occurred during the creation or maintenance session that resulted in the lock.

How to display this screen: Select History for a vendor at the Work with Vendors Screen or select Display Vendor Hist at the First Display Vendor Screen or the Second Display Vendor Screen.

Field

Description

Vendor

A code for the supplier of a product or service you purchase.

Numeric, 7 positions; display-only.

Number POs

The number of purchase orders to date, since adding the vendor to the system. This information is also broken out into open POs (not received or partially received), held POs, and canceled POs. The fields are updated appropriately if you purge purchase orders.

Numeric, 7 positions; display-only.

Value POs

The value of the purchase orders to date. This information is also broken out into open POs (unreceived or partially received), held POs, and canceled POs. These fields are updated appropriately if you purge purchase orders.

Numeric, 7 positions; display-only.

Year

The current fiscal year.

Numeric, 2 positions (YY format); optional.

Period

The current period. A period is user-defined, but usually refers to an accounting month.

Accounting periods are defined in and validated against the Accounting Periods table.

Numeric, 2 positions; optional.

# POs

The number of purchase orders for the year and period. These fields are not updated when you purge purchase orders, and contain true historical (life-to-date) information.

Numeric, 7 positions; display-only.

Value POs

The value of the purchase orders for the year and period. These fields are not updated when you purge purchase orders and contain true historical (life-to-date) information.

Numeric, 7 positions; display-only.

Change Vendor Extended Screen

Purpose: Use this screen to:

• review the dollar value of outstanding (unreceived or partially received) purchase orders for the vendor

• review or define the discount calculation method used for discounts in the Vendor Discount table

How to display this screen: Select Change Vendor Ext at the First Change Vendor Screen or the Second Change Vendor Screen.

Field

Description

Vendor

A code that identifies the supplier from whom you purchase goods or services.

Numeric, 7 positions; display-only.

Vendor description (Unlabeled field to the right of the Vendor field)

The name of the vendor.

Alphanumeric, 30 positions; display-only.

On order

The total dollar value of purchase orders which are outstanding (unreceived or partially received) for this vendor.

Numeric, 13 positions with a 2-place decimal; display-only.

Priority

The Cash Disbursement priority, in a range from 9 (highest priority) to 0 (lowest priority).

Numeric, 1 position; optional.

Discount calculation method

A code that defines the calculation method used for the three discounts from the Vendor Discounts table.

Valid values are:

Combined = This discount method combines the total dollar amount of all 3 discounts to determine the net cost.

Tiered = This discount method calculates the largest discount against the purchase order's gross cost, then the second largest discount is calculated against the net result of the first discount, and the third largest discount is calculated against the net result of the second discount.

• Blank = No discount is applied.

Note:

• If you leave this field blank, you will not be able to apply any discounts when working with a purchase order, regardless of your entries in the discount fields.

• These discounts do not apply to drop ship purchase orders.

See Combined Discount Calculation and Tiered Discount Calculation for examples of each discount calculation.

Required if using vendor discounts.

Display Vendor Extended Screen

Purpose: Use this screen to review:

• the dollar value of outstanding (unreceived or partially received) purchase orders for the vendor

• the discount calculation method used for discounts in the Vendor Discount table

• the dollar amount of cash that should be paid against outstanding invoices for the vendor and the weeks on which these payments should be disbursed

How to display this screen: Select Display Vendor Ext at the First Display Vendor Screen or the Second Display Vendor Screen.

For more information: See Change Vendor Extended Screen for a screen sample and field descriptions. You cannot change any information on this screen.

Work with Vendor Discounts Screen

Purpose: Use this screen to create vendor discounts to apply against the gross cost of the purchase order in Purchase Order Maintenance (see Purchase Order Line Discount Screen), and receiving.

Note: These discounts do not apply to drop ship purchase orders.

How to display this screen: Select Discounts for a vendor on the Work with Vendors Screen.

The following message indicates that you have not defined a Discount calculation method in the Vendor Extended table:

Discount Calculation Method not defined for Vendor.

Field

Description

Vendor #

A user-defined code to identify the supplier of an item. Vendor codes are defined in and validated against the Vendor table. See

Numeric, 7 positions; display-only.

Vendor description (Unlabeled field to the right of the Vendor field)

The name of the vendor.

Alphanumeric, 30 positions; display-only.

Discount (Discount fields)

The names of the three discount fields. These fields are controlled by the Discount 1 Field (D97), Discount 2 Field (D98), and Discount 3 Field (D99) values in the System Control table. The discount fields are blank if values have not been defined.

Note: The system calculates the primary discount on a purchase order before calculating any discounts from the Vendor Discount table.

Alphanumeric, 11 positions; display-only.

Percent

The percentage the system applies against the unit cost of an item on the purchase order. If you enter a discount percentage, you cannot enter a unit discount for the same discount field. The system calculates discount percentages before subtracting any dollar discounts.

Note: The system calculates percentage discounts based on the method from the Discount calculation method field in the Vendor Extended table. See Combined Discount Calculation and Tiered Discount Calculation for examples of each.

Numeric, 11 positions with a 4-place decimal; optional.

Unit discount

The dollar amount the system subtracts from the unit cost of an item on the purchase order. If you enter a unit discount amount, you cannot enter a discount percentage for the same discount field.

Note: The system calculates percentage discounts based on the method from the Discount calculation method field in the Vendor Extended table. See Combined Discount Calculation and Tiered Discount Calculation for examples of each.

Numeric, 11 positions with a 4-place decimal; optional.

Instructions: Use the following steps to create a vendor discount:

1. Complete the Percent or Unit discount field for each discount field label. If you leave both the Percent and Unit discount fields blank, no discount will apply for this label.

2. Select OK. The system validates your entries and highlights any fields you need to correct. Correct any fields again.

3. The discounts you have entered will apply to all purchase orders entered for this vendor. These discounts are calculated based on the method you have entered in the Discount calculation method field in the Vendor Extended table.

See Combined Discount Calculation and Tiered Discount Calculation.

Note: The calculation of discounts in a foreign currency is not currently implemented.

Combined Discount Calculation

The combined discount calculation method combines the values of all 3 discounts to determine the net cost. Any discount percentages defined for the discounts are calculated before the unit discounts are applied.

The Combined Discount Calculation does not apply to drop ship purchase orders.

Example: An example of the combined discount calculation method is:

Cost of item = $100.00

Primary discount (defined in Vendor table) = 10%

Discount 1 = $10.00 (unit discount)

Discount 2 = 20% (percentage discount)

Discount 3 = 10% (percentage discount)

Step 1: Calculate the primary discount percentage

cost ($100.00) x primary discount (10%) = unit discount amount for primary discount ($10.00)

Step 2: Subtract the primary discount amount from the cost

cost ($100.00) - primary discount ($10.00) = cost after primary discount ($90.00)

Step 3: Calculate discount 2 percentage

cost ($90.00) x discount 2 (20%) = unit discount amount for discount 2 ($18.00)

Step 4: Calculate discount 3 percentage

cost (90.00) x discount 3 (10%) = unit discount amount for discount 3 ($9.00)

Step 5: Add discount amounts 1, 2 and 3 together

discount 2 ($18.00) + discount 3 ($9.00) + discount 1 ($10.00) = combined discount ($37.00)

Step 6: Subtract the total combined discount amount from the cost

cost ($90.00)- total combined discount (37.00) = net cost ($53.00)

Tiered Discount Calculation

The tiered discount calculation method calculates:

• the largest discount against the item's cost, then

• the second largest discount is calculated against the net result of the first discount, then

• the third largest discount is calculated against the net result of the second discount

Any discount percentages defined for the discount fields are calculated before the unit discounts are applied.

Note: The Tiered Discount Calculation does not apply to drop ship purchase orders.

Example: An example of the tiered discount calculation method is:

Cost of item = $100.00

Primary discount (defined in Vendor table) = 10%

Discount 1 = $10.00 (unit discount)

Discount 2 = 20% (percentage discount)

Discount 3 = 10% (percentage discount)

Step 1: Calculate the primary discount percentage

cost ($100.00) x primary discount (10%) = unit discount amount for primary discount ($10.00)

Step 2: Subtract the primary discount amount from the cost

cost ($100.00) - primary discount ($10.00) = cost after primary discount ($90.00)

Step 3: Calculate the largest discount percentage

cost ($90.00) x discount 2 (20%) = largest discount amount ($18.00)

Step 4: Subtract the largest discount amount from cost

gross cost ($90.00) - largest discount ($18.00) = net of first calculation ($72.00)

Step 5: Calculate the 2nd largest discount percentage

net of first calculation ($72.00) x discount 3 (10%) = second largest discount amount ($7.20)

Step 6: Subtract the 2nd largest discount amount from cost

net of first calculation ($72.00) - second largest discount amount ($7.20) = net of second calculation ($64.80)

Step 7: Subtract the 3rd largest discount amount from cost

net of second calculation ($64.80) - third largest discount amount ($10.00) = net of third calculation ($54.80)

Work with Vendor Contacts Screen

Purpose: Use this screen to create, change, delete or display contacts for a specific vendor.

How to display this screen: Select Contacts for a vendor on the Work with Vendors Screen, or select WW vend cntct on the First Change Vendor Screen, First Display Vendor Screen, Second Change Vendor Screen, or Second Display Vendor Screen.

Field

Description

Vendor

The vendor number and description associated with the vendor contacts.

Vendor number: numeric, 7 positions; display-only.

Vendor description: alphanumeric, 30 positions; display-only.

Seq # (Sort sequence number)

The sort sequence number assigned to this vendor contact. This number determines how the vendor contacts display on the screen and on the Vendor Contact Listing (Print List to print). If you do not define a sort sequence number, the system assigns a sequence number of 0 to the vendor contact.

Note: If you are using Order Broker Drop Ship Integration to automatically process drop ship orders for this vendor, you must enter the sequence number 999 to insure that email notifications are automatically sent to the vendor when you create drop ship purchase orders for this vendor. See Email Address for Drop Ship Vendor Window for more information.

 

You can select Resequence to resequence each vendor contact that displays on the screen in increments of 2. For example

contact 1 = sequence # 0

contact 2 = sequence # 0

contact 3 = sequence # 5

contact 4 = sequence # 8

When you select Resequence, the system resequences the vendor contacts in the following order:

contact 1 = sequence # 1

contact 2 = sequence # 3

contact 3 = sequence # 5

contact 4 = sequence # 7

Numeric, 3 positions; optional.

Contact name

The name of the vendor contact.

Alphanumeric, 30 positions; optional.

Title

The contact's title within the organization.

Alphanumeric, 30 positions; display-only.

Type

A user-defined field to identify the address type. Informational only.

Alphanumeric, 1 position; optional.

Screen Option

Procedure

Create a vendor contact

Select Create to advance to the Create Vendor Contact Screen.

Change a vendor contact

Select Change for a vendor contact to advance to the Change Vendor Contact screen. You can change any information on this screen except the vendor. See Create Vendor Contact Screen.

Delete a vendor contact

Select Delete for a vendor contact to delete it.

Display a vendor contact

Select Display for a vendor contact to advance to the Display Vendor Contact screen. You cannot change any information on this screen. See Create Vendor Contact Screen.

Resequence the sequence number for each vendor contact

Select Resequence. The system assigns sequence numbers to each vendor contact in increments of 2.

Create Vendor Contact Screen

Purpose: Use this screen to create a vendor contact.

How to display this screen: Select Create on the Work with Vendor Contacts Screen.

Field

Description

Vendor

The vendor number and description associated with the vendor contact you are creating.

Vendor number: numeric, 7 positions; display-only.

Vendor description: alphanumeric, 30 positions; display-only.

Contact name

The name of the vendor contact.

Alphanumeric, 30 positions; required.

Contact title

The contact's title within the company.

Alphanumeric, 30 positions; optional.

Address

Address lines 1, 2 and 3 for the vendor contact. The vendor's address defaults.

Alphanumeric, 32 positions; address line 1 required, address lines 2 and 3 optional.

City/

State/

Postal/

Country

The city, state, postal zip code and country associated with the vendor contact. The vendor's city, state, postal code and country defaults.

If the Require state field for the country in the vendor contact address is selected, the system requires a state code for the vendor address: State is required for this country.

Note: The system does not validate the contact’s address in the same way it validates a customer’s address, as in order entry. For example, it does not validate that the state is associated with the SCF for the postal code.

City: alphanumeric, 25 positions; required.

State: alphanumeric, 2 positions; optional.

Postal code: numeric, 10 positions; optional.

Country: alphanumeric, 3 positions; required.

Phone #/Ext (Telephone number and extension)

The vendor contact's telephone number and extension. You can define a telephone number format to map to the phone numbers operators enter into the system.

See Setting Up the Country Table (WCTY) for information on telephone number formats.

Phone #: alphanumeric, 14 positions; optional.

Extension: alphanumeric, 4 positions; optional.

Fax #/Ext

The telephone number for the vendor's fax machine. Faxing purchase orders is not currently implemented.

Fax number: alphanumeric, 14 positions; optional.

Extension: alphanumeric, 4 positions; optional.

Email address

The vendor contact's email address. See Email Address Validation for information on how the system verifies that your entry is formatted correctly.

Alphanumeric, 50 positions; optional.

Address type

A user-defined field to identify the address type. Informational only.

Alphanumeric, 1 position; optional.

Sort sequence #

The sort sequence number assigned to this vendor contact. This number determines how the vendor contacts display on the screen and on the Vendor Contact Listing (Print List to print). If you do not define a sort sequence number, the system assigns a sequence number of 0 to the vendor contact.

Note: If you are using Order Broker Drop Ship Integration to automatically process drop ship orders for this vendor, you must enter the sequence number 999 to insure that email notifications are automatically sent to the vendor when you create drop ship purchase orders for this vendor. See Email Address for Drop Ship Vendor Window for more information.

 

You can select Resequence on the Work with Vendor Contacts Screen to resequence each vendor contact that displays on the screen in increments of 2. For example

contact 1 = sequence # 0

contact 2 = sequence # 0

contact 3 = sequence # 5

contact 4 = sequence # 8

When you select Resequence, the system resequences the vendor contacts in the following order:

contact 1 = sequence # 1

contact 2 = sequence # 3

contact 3 = sequence # 5

contact 4 = sequence # 7

Numeric, 3 positions; optional.

Work with Vendor FOB Address Screen

Purpose: Use this screen to create, change, delete or display multiple FOB addresses for a specific vendor.

FOB (freight on board) address is the location where title to merchandise being shipped passes from the seller to the buyer. If the FOB address is an Origin type, ownership of the merchandise passes from seller to buyer at the origin of the shipping route, and the buyer is responsible for transportation costs and risk of loss or damage from that point. If the FOB address is a Destination type, ownership of the merchandise passes from seller to buyer at the receiving point for the merchandise, and the seller is responsible for transportation costs and risk of loss or damage until the merchandise reaches its destination.

How to display this screen: Select FOB for a vendor on the Work with Vendors Screen.

Field

Description

Vendor

The vendor number and description associated with the vendor.

Vendor number: numeric, 7 positions; display-only.

Vendor description: alphanumeric, 30 positions; display-only.

Type

This code identifies the address as an Origin (O) or Destination (D) type.

Origin = An Origin type FOB address specifies the location from which merchandise is being shipped, and indicates that ownership of merchandise being shipped transfers to the buyer when it leaves the vendor's warehouse (at the point of its shipping origin).

Destination = A Destination type FOB address specifies the location to which merchandise is being shipped, and indicates that ownership of the merchandise transfers to the buyer when it arrives at its destination.

Alphanumeric, display-only.

City

The city of the FOB address.

Alphanumeric, 25 positions; display-only.

State

The state of the FOB address. The system validates that the state you enter is assigned to the SCF in the first three positions of the postal code.

Alphanumeric, 2 postions; display-only.

Postal code

The zip code of the FOB address.

Alphanumeric, 10 postions; display-only.

Freight Terms

The freight terms for this vendor and this FOB address.

Alphanumeric, 10 postions; display-only.

.

Screen Option

Procedure

Create a vendor FOB address

Select Create to advance to the Create Vendor FOB Address Screen.

Change a vendor FOB address

Select Change for a Vendor FOB address to advance to the Change Vendor FOB Address screen. You can change any information on this screen except vendor number and vendor name. See Create Vendor FOB Address Screen for field descriptions.

Delete a vendor FOB address

Select Delete for a vendor FOB address to delete it.

Display a vendor FOB address

Select Display for a vendor FOB address to advance to the Display Vendor FOB Address screen. You cannot change any information on this screen. See Create Vendor FOB Address Screen for field descriptions.

Create Vendor FOB Address Screen

Purpose: Use this screen to create a vendor FOB address.

How to display this screen: Select Create on the Work with Vendor FOB Address Screen.

Field

Description

Vendor

The vendor number and description of the vendor for whom you are creating an FOB address.

Vendor number: numeric, 7 positions; display-only.

Vendor description: alphanumeric, 30 postions; display-only.

Postal code

The zip code of the Vendor FOB address.

Alphanumeric, 10 postions; required.

City

The city of the vendor FOB address.

Alphanumeric, 25 positions; required.

State

The state of the vendor FOB address.

If the Require state field for the country in the vendor FOB address is selected, the system requires a state code for the vendor address: State is required for this country.

Alphanumeric, 2 postions; required.

Country

The country of the vendor FOB address

Note: If the system control value Use Zip/City/State Defaulting? (B13) is selected, the City, State and Country fields will automatically display the correct address information when you enter a zip code in the Postal Code field.

Alphanumeric, 3 postions; required.

Freight terms

A brief description of the freight terms for this vendor FOB address.

Alphanumeric, 10 positions; required.

FOB type

Identifies the FOB type for this address. Valid types are Destination (D) and Origin (O).

Destination = the FOB address is the location to which merchandise is being shipped; this indicates that title to the merchandise passes from the seller to the buyer when the merchandise reaches its destination.

Origin = the FOB address is the location from which merchandise is being shipped; this indicates that title to the merchandise passes from the seller to the buyer as soon as the merchandise leaves the seller's dock (its shipping origin).

Alphanumeric, required.

Work with Vendor Notes Screen

Purpose: Messages that apply to the vendor from whom the merchandise was purchased can be added, changed or viewed during Purchase Order Receipts. The Vendor table is updated with any changes made to the vendor notes during Purchase Order Receipts.

Optionally, you can choose whether to print the vendor notes on the purchase order form and the receiver's worksheet.

Vendor notes can also be entered, changed, or viewed using Maintaining Purchase Orders (MPOE) and Receiving Purchase Orders (PORC).

How to display this screen: At the Work with Vendors Screen, select Notes for a vendor; or select Notes from the:

First Create Vendor Screen

First Change Vendor Screen

Second Create Vendor Screen

Second Change Vendor Screen

Work with Purchase Order (Header) Screen

PO Maintenance - Maintain Detail Screen

First Display Purchase Order Detail Screen (PO inquiry)

Field

Description

Message

The message text for this vendor. Previously entered messages display when you access the screen. Additional lines are available to enter new messages. Scroll or Page Down to view additional messages or to access additional lines.

Alphanumeric, 60 positions each line; optional.

Print

Indicates whether this message text on the line will print on the purchase order. You can choose which lines you want to print.

The valid values are:

Unselected = Do not print the line information

Selected = Print the line text on the purchase order

Adding a new vendor note:

1. Enter the information you want on the first available line in the message section.

2. Use Tab to move to or click on the Print field. Enter a print code, if applicable.

3. When you finish the note, select OK. The system accepts the entry and updates the Vendor table.

Changing a vendor note:

1. Select Add/Change. The existing messages can now be changed.

2. Enter the changes as needed. The system accepts the entry and updated the Vendor table.

WVEN OMSCS 19.0 December 2019 OHC