VEMM - Vendor Master Maintenance

New features added, version 7.5.2, 7.5.3, 8.1, 7.5.4, 8.4, 8.5.2

See Also Programs

Program VEMM, Vendor Master Maintenance, is used to add and maintain vendor master records. Vendor master records include the distribution accounts for the vendor, variance checking, and variance tolerance percentages for vendors. Vendors can be set up as 1099 vendors, and temporary vendors can be set up in this program.

In program VEMM, Vendor Master Maintenance, you can indicate whether you will be required to enter a purchase order number in program APVM, Voucher Entry/Maintenance. Program APVM, Voucher Entry/Maintenance, cannot check the variance tolerances established in this program if a purchase order number is not entered.

You can enable variance checking and set variance tolerance percentages for vendors in this program. The variance checking parameters set in this program will be overridden by specific parameters established for items in program VEQM, Vendor Quote Maintenance. Variance parameters are set up with the [Variance Tolerances] button.

Comments for vendors can be entered in this program with the comment types POR - purchase orders and receiving, RE - receiving, and PO - purchase orders only. When the vendor is used on a purchase order or a receiver, the comments will be displayed, depending upon the comment type.

The VEMM_HIDDEN_FIELDS parameter in program MURM, Initialization Parameter Maintenance, determines whether the fields containing sensitive information are displayed in program VEMM, Vendor Master Maintenance, for the user. These fields include Bank Routing No, Vendor (Bank), Acct No. and Vendor Acct Ref. When the parameter is set to Y, the user will be able to see the values in the fields. When it is set to N, the data will be concealed as asterisks ****.

The VEMM_ INTERNAL_CONTROL_MODE parameter in program MURM, Initialization Parameter Maintenance, determines what fields are updateable. If MURM is set to Y, then the only updates allowed are to the return address, contacts and mail/fax screens. Default is N, which allows updates and inserts to all fields.

 

See Also

Third Party Shipping Accounts for Clippership

Vendor/Purchase Order Comments

ACH Payments for Vendors

Entering Vendors

Entering Vendor Details for Financial Enterprise

Entering Vendor Contacts

Printing Reports for Vendors to Email

Printing Reports for Vendors to Fax

VEMM Action Buttons

Vendor/Purchase Order Comments

Comments are accessed with the [Comments] image\ebx_1202995823.gif button.

Vendor comments differ somewhat from the standard comment functionality in NDS. When vendor comments are entered in this program, you can define a target comment type to be used when the comment is copied to the purchase order programs.

Comments with comment type POR or PO can be set up for vendors so that they are always displayed when a purchase order is entered for the vendor in program POEM, P.O. Entry/Maintenance. On the comments page, there is a flag with three settings: Silent (Normal), Show Indicator, and User must read.

ACH Payments for Vendors

ACH electronic payments can be set up for vendors, however some custom programming is required. If you wish to use ACH electronic payments, contact your NDS Project Manager for more information about the custom programming required.

Vendors are set up with the payment type CCK, and the ACH Flag set to on. In addition, the bank information must be entered in the lower block of program VEMM, Vendor Master Maintenance.

When program APCP, Check Printing, is run, checks are not written for ACH Payments, but the payment record is created with an ACH prefix followed by the number assigned from the from the ACH_CHECK_NO sequence in program SPAN, Auto Number Control.

Entering Vendors

1. In the Vendor No field, enter the vendor number.

2. In the Vendor Name field, enter the vendor name.

3. In the Address fields, enter the vendor's address, if desired.

Modifications to the vendor address do not change the remit to address. To apply a change to the vendor address, press the [Make Remit To the Same] button.

To enter a remit to address that is different from the vendor address, press the [Remit To Address] button.

Modifications to the vendor address do not change the return to address. To enter or modify the return to address, press the [Return to Addresses] button.

4. In the Country field, enter the vendor's country, if desired.

5. In the Contact field, enter the contact for the vendor, if desired.

6. In the Fax field, enter the fax number for the vendor.

7. In the Email field, enter the email address for the vendor.

8. In the URL field, enter the World Wide Web address for the vendor.

9. In the Tax No/Name fields, if the vendor is a 1099 vendor, enter the federal tax ID number and name for the vendor.

10. If the vendor is a 1099 vendor, set the 1099 Vendor flag to on.

9. If the vendor is a temporary vendor, set the Temporary flag to on.

10. If the vendor is active, set the Active flag to on.

11. If the payments to the vendor should be placed on hold, set the Vendor on Hold flag to on.

12. Set the Drop Ship Only flag to on if ALL purchase orders entered for this vendor are drop ship purchase orders.

13. If purchase order number must be entered for this vendor in program APVM, Voucher Entry/Maintenance, set the PO Mandatory in AP flag to on.

14. Set the Taxable Vendor flag to the desired setting.

15. If each invoice for this vendor should be paid with its own check, set the One Invoice per Check flag to on.

16. Set the Always Take Discount flag to the desired setting.

17. Set the Internal Supplier flag to the desired setting. When this flag is set to on, this vendor is an internal vendor used in the Internal Suppliers feature. The vendor number must already be assigned to a customer for this flag to be set to on.

18. If this vendor is an Internal Supplier, in the Int Enterprise field, enter the financial enterprise for the customer enterprise record that will be used to determine the sales location for the created sales orders.

19. In the Terms field, enter the default invoice payment terms code for the vendor.

20. In the FOB field, enter the default FOB code for the vendor.

21. In the Ship Via field, enter the default ship via code for the vendor.

22. In the 3rd Party Acct field, enter the third party shipping account for this vendor, from program VESM, Third Party Vendor Maintenance, if appropriate.

23. In the Insurance No field, enter the vendor's shipping insurance number, for reference, if desired.

24. In the Pay Type field, the payment type for the vendor defaults to CCK for computer generated checks.

25. Set the ACH Flag to the desired setting. When set to on, payments to this vendor are made electronically using the bank information entered in the lower block. The payment type should be CCK when setting up ACH payments for vendors. For more information, see ACH Payments for Vendors.

26. In the Min PO Value field, enter the minimum purchase order value for this vendor. When a purchase order in entered for this vendor, and the purchase order value is less than the amount entered here, you will not be able to print or transmit this purchase order in program POFM, Maintain PO Print Flags.

27. In the Min PO Freight field, enter the minimum purchase order freight value for this vendor. This is the purchase order value that you must reach before the freight is discounted or free from this vendor. When a purchase order is entered for this vendor, and the purchase order value is less than the amount entered here, you will not be able to print or transmit this purchase order in program POFM, Maintain PO Print Flags.

28. In the Tracking Type pop-list, if this vendor is a freight vendor, select the tracking type to use when tracking containers with program OEST, Container Status Inquiry.

29. In the Alternative Currency field, enter the alternative currency for the vendor from program SPRC, Currency Code Maintenance. Purchase orders can be entered for the vendor in only the alternative currency entered here.

30. Press the [Variance Tolerances] button, if you wish to enable variance checking and set variance tolerance percentages for the vendor.

31. Press the [Return to Addresses] button to enter multiple return to addresses for use when entering and maintaining return to vendor transactions with program RTVM, Return to Vendor Maintenance.

32. Press [Commit].

Entering Vendor Details for Financial Enterprise

1. Go to the lower block to define the financial enterprise details for the vendor. The information entered in the lower block is not mandatory.

2. In the AP Bank ID field, enter the bank code for the bank from which payments entered for this vendor will be taken.

3. In the Bank Routing No field, enter the routing number for the bank to which payments for this vendor will be electronically transferred. This information is required for vendor ACH payments.

4. In the Acct No field, for ACH payments, this is the bank account number to which payments for this vendor will be transferred. This information is required for vendor ACH payments.

5. The Vendor (Bank) field is the bank's name for this vendor. This information is required for vendor ACH payments and may also be used for payment types other than CCK.

6. Set the ACH Type pop-list to indicate whether the account is a checking or savings account.

7. The Transfer Bank ID field is used only for those vendors being paid via payment types other than CCK for some type of direct bank transfer, but the field is required for those vendors.

8. The Vendor Acct Ref field contains the vendor's bank account number. It is used only for payment types other than CCK.

9. In the AP Dist Code field, enter the account distribution code for this vendor, if the vendor's charges are always distributed to the same accounts.

10. In the AP Account field, enter the account payable liability account number that will be used for purchases from this vendor.

11. Set the Voucher Receipts Automatically flag to the desired setting.

12. In the Vendor Group field, enter the vendor group to which the vendor belongs, if desired. The list of values is available.

13. In the Tax Code field, enter the tax code for this vendor, if appropriate. This tax code is used to calculate tax for purchase orders and vouchers for this vendor.

14. In the Freight Code field, enter the freight code for this vendor, if appropriate. This freight code is used to calculate freight charges on purchase orders and vouchers for this vendor.

15. In the Misc 1 and Misc 2 fields, enter miscellaneous codes for this vendor, if appropriate. These miscellaneous codes are used to calculate miscellaneous charges on purchase orders and vouchers for this vendor.

16. In the Sort Cd field, enter the bank sort code for this vendor. The bank sort code is usually found under the check number in the upper right hand corner of the check. It is required for payment types other than CCK.

17. Press [Commit].

18. If the vendor exists in another enterprise and information has been entered for the vendor in the other enterprise in the lower block of VEMM, Vendor Master Maintenance, you can copy the information from that enterprise vendor record to this vendor record.

Entering Vendor Contacts

1. Enter the contact name.

2. Enter the contact email address.

3. Set the Primary flag to the desired setting. Only one contact per vendor can have the Primary flag set to on.

4. In the User 1 through 4 fields, you can enter user-defined codes for the contacts. The list of values will display all previously entered user-defined codes in the same user field.

5. Enter any notes for the contact.

6. Press [Commit].

7. Once you have finished entering the contact information, go to the right block of the program to enter telephone numbers.

8. Two telephone types are standard with NDS Applications. These are Business and Fax. All contacts will have these two telephone type records, and they cannot be deleted. However, the fields can be left blank if they do not apply.

9. In the Phone Number fields for the Business and Fax telephone types, enter the business and fax telephone numbers for the contact, if appropriate.

10. To enter another telephone type record, select the Phone Type pop-list to the desired setting. This pop-list contains all telephone types entered in program SPFT, Maintain Phone Types.

11. In the Phone Number field, enter the telephone number for the selected phone type.

12. When all telephone numbers have been entered, press [Commit].

VEMM Action Buttons

Copy details from Enterprise:

Enter in the field next to this button the enterprise from which you wish to copy the default banking and accounts payable information. Press this button to copy the information. This button should only be used to copy the vendor information between enterprises. In order to copy the information, the general ledger account structure must be the same in both enterprises, or the information will not be able to be copied. The FOB, Terms, and other codes must also exist in both enterprises; otherwise the program will state that it is an invalid code.

Mail/Fax Setup

Enter the information to print sales order reports for this vendor to email or fax.

Make Remit To the Same

Press this button to make the remit to address the same as the vendor address. The remit to address is printed on checks to the vendor.

Remit To Address

Press this button to enter the remit to address. The remit to address is printed on checks to the vendor.

Return To Addresses

Press this button to enter multiple return to addresses for use when entering and maintaining return to vendor transactions with program RTVM, Return to Vendor Maintenance.

Variance Tolerances

Press this button to maintain variance checking and tolerable variance percentages.