Chapter 15. Vendors
Vendors are the suppliers from whom you order the merchandise that stocks your store. The vendor record includes contact information and can include the payment terms you have arranged with the vendor. Each vendor is identified by a unique Vendor Code that can be from three to six characters in length. Assigning a Vendor Code to items enables Prism to track vendor performance as merchandise is ordered, received, transferred, and sold.
In addition, the Vendors module enables retailers to:
- Assign a specific currency to a vendor
- Control employee access to selected vendor features
- Use notes fields to capture vendor details, discounts for purchasing in certain quantities, payment terms, etc.
Payees vs. Vendors
Users will notice a Payee Code field on Vendor Invoices. The Payee Code indicates the company to whom payment is being sent. The payee is often the vendor's own company, but it can be a third party. Add a vendor record for any such payees and then you can reference the record in fields like the Payee Code field.
Node Preferences - Merchandise - Vendors - UDF
Vendor user-defined fields enable retailers to capture vendor information that is not available in the many predefined vendor fields that come with Prism. With UDF fields, you define a field label and a list of field values that will be available for selection. Prism provides 14 user-defined fields for vendor records: one date field and 13 text fields.
To add a UDF field entry, in the UDFs Naming area, navigate to the desired UDF field and type a label. Click the Save UDFs button. The UDF label is now available in the UDF Options drop down.
Click the Edit button for the desired UDF field option.
Type the text for the UDF field option and then click the check mark button.
Maximum number of UDFs
The UI allows users to create more than 14 vendor UDF fields; however, only the first 14 UDF fields will be available for use in Prism.
Maximum Number of UDF Values per UDF field
Users can define as many UDF values per UDF field as needed; however, during replication of UDFs, the server checks how many UDF values belongs to eac UDF. If more than 500, the UDF values are not replicated at all. This applies to UDF values assigned to customer/inventory/vendor/employee.
Sample Node Preferences > Merchandise > Vendors > UDF Fields:
|Vendor - Access||If the "Allow" option is selected, group members can access the Vendors area.|
|Vendor - Activate/Deactivate||If the "Allow" option is selected, group members can activate and delete Vendors.|
|Vendor - Allow Manual Entry of UDF Values||If selected, allow group members to make edits to UDF values in the vendor record. If disabled, users are restricted to selecting one of the UDF values defined in preferences.|
|Vendor - Change Subsidiary||If selected, allow group members to change the Subsidiary. This can be used to add or edit a vendor for a different subsidiary.|
|Vendor - Create/Copy||If the "Allow" option is selected, group members can create (using New Vendor button) and/or copy Vendors.|
|Vendor - Edit||If the "Allow" option is selected, group members can edit Vendors.|
|Vendor - Edit Regional Flag||If selected, group members can edit the Regional flag on vendor records. When the Regional Inventory feature is enabled, vendors that have the Regional flag selected will be under control of the master subsidiary.|
Add New Vendor
Select Store Operations from the Prism menu. Click the Merchandise button. Click Vendors.
Click the New button on the bottom menu of the Vendor Search form. A new vendor form is displayed, ready for editing.
Enter the required Vendor Code (three to six characters). Enter information in the other fields as needed (refer to the Vendor fields table).
Save the changes.
Sample New Vendor
|Vendor Code||The unique code to identify the vendor (three to six characters).|
|Vendor Name||The name of the vendor.|
|Title||Title of the vendor contact person (e.g. Mr., Ms., Mrs.)|
|First Name||First name of the vendor contact person.|
|Last Name||Last name of the vendor contact person.|
|Phone Type 1||The type of the primary phone number (e.g. Home, Work, Cell)|
|Phone 1||Primary phone number.|
|Phone Type 2||The type of the secondary phone number.|
|Phone 2||Secondary phone number.|
|Email Type||Email Type (e.g. Home, Work, Other)|
|The vendor's email address.|
|Address Type||Address Type (e.g. home, office, or warehouse).|
|Street||The street address for the vendor's address (e.g. 123 Main St.).|
|Unite/Suite||The apartment, unit, or suite number for the street address.|
|City||The city where the vendor's address is located.|
|State/Province||The state, province, or prefecture of the vendor's address.|
|Country||The country of the vendor's address.|
|Postal Code||The ZIP or Postal Code for the Vendor's address.|
Vendor Account and Terms
|Account Number||Enter your (the retailer's) account number with the vendor.|
|Accounts Payable|| Accounts Payable status for the vendor:
Export: Flag the vendor record for export to accounting program (Default).
Yes: Export vouchers for this vendor.
No: Do not include this vendor in the accounting program.
|Payment Terms||The default payment terms entered in the vendor record of the vendor entered in the Payee field.|
|Trade Discount %||(future release) A discount given by a vendor. The Trade Discount % is applied to any new inventory items from that vendor. The Trade Discount % is applied to each applicable item's List Cost to calculate Order Cost. If using trade discounts, Order Cost is automatically used on purchase orders and vouchers, and vouchers are unable to update an item's Order Cost.|
|Currency||The currency assigned to the vendor|
|Regional Vendor||If selected, indicates the vendor is a regional vendor.|
|Notes||Use this field if you need to add text notes regarding the vendor. For example, the vendor may have special instructions for placing orders that can be recorded here.|
Select Store Operations from the Prism menu. Tap or click the Merchandise button. Click the Vendors button.
The Vendor Lookup form is displayed.
You can search by Vendor Code, Vendor Name or Account Number. To select a search element, click in the Search By drop-down and select the desired search field. In the example below, the user is search by Vendor Code. The operator is set to "Contains." The letter "G" is followed by the wildcard character (*), so this search will return vendors that start with the letter G.
Tap or click the Search button to start the search. By default, only Active Vendors are searched. You can click the Inactive or All button to change.
From the displayed results, select the check mark for the desired vendor and click Details to view the record or Edit to open the record in edit mode.
Vendor Codes and Specific Search
Please note that when using the Specific Search option to search by Vendor Code, you MUST include any spaces in the Vendor Code. For example, if the Vendor Code is "MZC" with a Department of "M", Class of "Z" and Subclass of "C", then users must enter two spaces after the M and the Z (not necessary to enter spaces after the C).
Vendor Detail/Vendor List
When in non-edit mode, you can view the entire vendor list by clicking the Vendor List button. If in edit mode, the button is not available.
Vendor Contact Information
Retailers will often have one or more contact persons at the vendor's company who can answer questions related to merchandise and orders. You can add information for the contact persons to the vendor record. The Contact Types, Phone Types and Address Types that are available for selection are those defined in Admin Console > Node Preferences > Data Types. Click the Add button in the Contacts area of the vendor record. Enter details for the contact person. (Optional) To make this contact the primary contact person, select the Primary check box. Click the OK button when finished. The record is added to the list of contacts.
Vendor Account Number, Payment Terms
You can define default payment terms for a vendor. The default terms that you specify will be suggested on POs and vouchers addressed to that vendor. The only exception to this is if a voucher references a PO with different terms than the vendor file states. In such a case, the PO's terms will override the vendor default terms.
- Click Open Payment Terms (click the Edit button first, if necessary).
- Select a Payment Term Type from the drop-down.
- Enter details for the selected term type. For example, if you selected Days as the term type, enter the percentage discount to be received if payment is made within the specified number of days.
- Save the changes.
|Payment Term Type||Description|
|Days||Enables you to specify the days from the invoice date when payment is due. Optionally you can enter a discount percentage if payment is made within the specified number of days.|
|COD||Cash on delivery|
|Credit||Payment on credit.|
|Replace||Replace the merchandise.|
|Prepaid||Payment in advance|
|Due||Payment due immediately.|
|Payment||Set up payment in stages.|
|EOM||The abbreviation "EOM" means that the payer must issue payment within a certain number of days following the end of the month. Thus, terms of "net 10 EOM" mean that payment must be made in full within 10 days following the end of the month.|
Common Payment Terms
|Term||Description||Effective Interest rate|
|net 10||Payment 10 days after invoice date.||None|
|net 30||Payment 30 days after invoice date.||None|
|net 60||Payment 60 days after invoice date.||None|
|1% 10, net 30||1% discount if payment received within ten days otherwise payment 30 days after invoice date||18.2%|
|2% 10, net 30||Take 2% discount if pay in 10 days, otherwise pay in 30 days.||36.7%|
|1% 10, net 60||Take 1% discount if pay in 10 days, otherwise pay in 60 days||7.3%|
|2% 10, net 60||Take 2% discount if pay in 10 days, otherwise pay in 60 days||14.7%|
|Net EOM 10||Pay within 10 days of month end||None|
Trade Discounts (future release scheduled for Prism 2.1)
A trade discount in Prism is a reduction in price a vendor gives a retailer when the retailer buys an item or group of items.
Trade discounts are different from Vendor payment terms:
- Trade discounts are usually given to retailers that order large quantities of a product and/or retailers with a good relationship with the manufacturer.
- Vendor payment terms are defined in the vendor record and are based on payment plans with the vendor with no relation to order quantities.
To use trade discounts, in Admin Console > Node Preferences > Purchasing > General: Cost to use on POs and Vouchers, select "Trade Discount." The Trade Discount % is applied to each applicable item's List Cost to calculate Order Cost. If using trade discounts, Order Cost is automatically used on purchase orders and vouchers, and vouchers are unable to update an item's Order Cost. The amount of the trade discount varies depending on the item and vendor. By adjusting the "Minimum Order Quantity" the trade discount can be tied to quantity ordered. For instance, a retailer might order 1000 t-shirts from a vendor and receive a 20 percent discount.
The Trade Discount % entered in the vendor record, if present, is automatically entered for new items for that vendor. When you edit the Trade Discount % field for a vendor record, it has no effect on existing items.
Vendor Currency and Foreign Currency Orders
The items in a retailer's store might include items purchased from a vendor located in a foreign country. In most cases, payment for the items must be made in the vendor's local currency, rather than the retailer's Base Currency. To facilitate these foreign-currency orders, assign a Currency to a vendor record. Select a currency from the drop-down. Tip: Enter an Order Rate for each currency that is separate from the rates used on point of sale transactions.
Add the Foreign Order Cost field to your inventory, purchase order, and voucher screen layouts. Add the Currency field to your inventory, purchase order, vendor, and voucher screen layouts. Assign a currency to vendors and items as needed.
Vendor UDF and Info Fields
Prism provides a number of user-defined fields that can be used to store various information related to the vendor. Define labels and field entries for the fields in Admin Console > Node Preferences > Merchandise > Vendors > UDF. vUDF1 and vUDF2 are date fields and therefore these fields will not be available in the "Select UDF" dropdown when defining field entries. When the vUDF1 and vUDF2 fields are used at POS, the user makes a field entry by selecting a date on a pop-up calendar.
- In the Admin Console, navigate to Node Preferences > Merchandise > Vendors > UDF.
- In the UDFs Naming area, type a label for each UDF field you want to use.
- Click the Save UDFs button.
- In the Select UDF dropdown, select one of the labels you defined.
- Click the Edit button next to the field entry.
- Type the UDF field entry and then click the check mark icon.
- Additional field entries as needed.
Copy a Vendor
When you copy a vendor record, all information except the Vendor Code is copied to the new record. The Vendor Code field will be blank and you must make an entry to save the new vendor.
- Search for the vendor.
- Tap or click the check mark on the side of the desired vendor.
- Tap or click the Copy button.
- Enter a Vendor Code and make any other needed changes. When finished, save the record.
When you deactivate a vendor, that vendor cannot be listed on purchase orders or other documents or assigned to items and styles.
- Search for the vendor.
- Tap or click the check mark on the side of the desired vendor.
- Tap or click the Deactivate button. The button is a toggle button. When viewing a deactivated record, the label changes to "Activate."
Replication of Vendors
There are two resources that control the replication of vendor information: