Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Panel
Table of Contents

...

4. Click on  to post the vendor to the system, click on Cancel to not post the vendor and return to the Vendor grid.

Search/View Vendors 

Vendor Grid allows the user to search for existing vendors. Click on  to view a particular vendor.   The vendor grid also allows you to sort vendor information by typing specifics within the Column Title blank fields or selecting a Column Title to sort all vendors in ascending/descending order for example.

...

Field   

Format

Definition

Vendor #

An integer with a maximum of 8 digits.

Required field if modifying/updating an existing Vendor.  When adding a new vendor, enter Vendor # or if left blank, the system will auto assign.
Primary NameMaximum length is 15 characters. Required field when adding/modifying a vendor.  Vendor's primary name.

Account Number

Maximum length is 15 characters.The Vendor's account number.
Active
  • True or T = active
  • False or F = inactive
Required field only when changing vendor's Active/Inactive status.
Default Payment Type
  • Check
  • Electronic
Identifies the default payment type for the vendor.  This is case sensitive and should be entered as shown.
Ignore Limits
  • True or T
  • False or F
Indicates if vendor should ignore the 1099 limits. 
Tax ID Type
  • SSN  
  • EIN 
Identifies the Tax ID Type for vendor.  If this field is populated the Tax ID# is required.
Id #  Numeric without dashes

The vendor's SSN or EIN number.

Type1099
  • Non_1099
  • Non_Employee_Compensation
  • Rents
  • Other_Income
  • Medical_and_Health_Care
  • Royalty_Payments
  • Attorney_Gross_Proceeds
Indicates the 1099 type for vendor.  This is case sensitive and should be entered as shown.
Birth Date

Acceptable formats as used in UI can utilize '/' slashes or '-' hyphens or numbers only (no delimiter).  

  • MMDDYYYY
  • MM/DD/YYYY
  • MM-DD-YYYY
The vendor's birth date for New Hire reporting.
Begin Date

Acceptable formats as used in UI can utilize '/' slashes or '-' hyphens or numbers only (no delimiter).  

  • MMDDYYYY
  • MM/DD/YYYY
  • MM-DD-YYYY
The vendor's beginning date for New Hire reporting.
MonthsNumeric up to 2 digits.

The number of months the vendor's work is to be performed.

Email AddressCharacter stringThe Vendor's email address.
Last Activity Daten/aDate of Last transaction activity on the vendor. This field is non-modifiable and should not be included in a vendor import.
Minority Vendor
  • True or T
  • False or F
Identifies if the vendor is a minority vendor.
Withhold Child Support
  • True or T
  • False or F
Indicates if the vendor should have child support payments withheld.

ACH Active  

  • True or T
  • False or F               
If the ACHProcessing module is installed (using the System>Modules menu option), the ACH Active field can be added or updated on the vendor's record.   
Bank Account NumberNumeric and Alpha   Indicates the Vendor's bank account number.
Bank Routing NumberNumeric                     Indicates the Vendor's bank routing number.
Deposit Type
  • 22  
  • 23  
  • 32  
  • 33                           
Identifies the deposit type for the vendor.
  • 22 = automated deposit (demand credit record))
  • 23 = prenotification of demand credit authorization)
  • 32 = automated deposit (savings account credit record))
  • 33 = prenotification of savings credit authorization)
Entry Class Code
  • PPD                        
  • CCD
Identifies if the Entry Class Code is PPD for Prearranged Payment and Deposit Entry or CCD for Corporate Credit or Debit. This is case sensitive and should be entered as shown.
LocationText Required field if the Location for a vendor is to be added/updated.   This field is user defined to help Identify different Locations (addresses) for different situations. For example, the vendor may have a location for a PO address and location for a check address.    (examples:   Primary, Check Address, PO )
Name1Maximum length is 16 characters. Identifies the vendor's name to be used for specified location.
Name2Maximum length is 16 characters. Identifies a 2nd vendor name field to be used for specified location.  
Line1Numeric and TextIdentifies street address for vendor's specified location.
Line2Numeric and TextAllows for a second address line for the vendor's specified location
CityTextIdentifies the City for the vendor's specified location.
StateTwo character State abbreviationIdentifies the State for the vendor's specified location.
ZipNumericIdentifies the Zip Code for the vendor's specified location.
CountryTextIdentifies the Country for the vendor's specified location.
PhoneNumeric Identifies the Phone number for the vendor.
ExtensionNumericIdentifies the Phone extension number for the vendor. 
Country CodeNumericIdentifies the Phone country code.
1099
  • True
  • False
Identifies if Location entered is the 1099 address to be used.
Check
  • True
  • False
Identifies if Location entered is the Check address to be used.
PO
  • True
  • False
Identifies if Location entered is the PO address to be used.

...

Field FormatDefinition

Vendor #

An integer with a maximum of 8 digits.Required field Must match an existing vendor number.
Date

Acceptable formats as used in UI can utilize '/' slashes or '-' hyphens or numbers only (no delimiter).  

  • MMDDYYYY
  • MM/DD/YYYY
  • MM-DD-YYYY
Required field Date to post the vendor adjustment as of. This date will be used to determine which Month and Year totals the adjustment impacts. 
DescriptionCharacter StringDescription that will show on Vendor Adjustment grid for this entry
Taxable
  • True or T
  • False or F
Determines if this entry will impact the Taxable totals that are used for 1099 amounts. If this column is left blank or not included, the default valued is True.
AmountMust be a number. Cannot use $ or commas.  Required field Amount for this vendor adjustment.

...