Panel | |
---|---|
|
Vendor
...
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.
...
- View a vendor
- Click on Vendor Adjustments to open the Vendor Adjustments grid.
- Click on Create to create an adjustment:
- Date: The date will default to the current date.
- Description: You can optionally enter a description for the vendor transaction
- By default, taxable will be checkmarked. When checked, both the FYTD Taxable Total and FYTD Total as well as the YTD Taxable Total and YTD Total amounts will be updated. The 1099 program will use the amount from the YTD Taxable Total.
- Amount: the amount of the vendor adjustment. The amount entered can be positive or negative to increase or reduce the current YTD totals. This field cannot be blank or $0.00. This field cannot contain special characters ($) or commas.
- Click on Post to post the transaction and it will be displayed on the Vendor Adjustment grid.
...
When viewing a Vendor, qualifying vendors will have the Merged Vendor button available. This button will only be available to click for vendors that are eligible to be merged or vendors that have already had other vendors merged into it. A vendor is eligible to be merged if it is active and there are other vendors that have the same Tax ID Type, Tax ID#, and Type 1099. If there are no other vendors with this information it is not eligible to be merged and therefore the Merged Vendors button will be greyed out.
...
- View an active vendor
- Click on Merged Vendors to open the Merged Vendors grid.
- Click on Merge Vendor to initiate a new merge:
- Effective Calendar Year: When merged, any existing transactions for the old vendor in the selected calendar year only will be changed.
- The current calendar year will display by default. Any future years that have been created will also be available to select.
- Vendors: Select one or more vendors to be included in the merge using the checkbox in the first column.
- Only vendors that are eligible to be merged into this vendor will appear in this grid. This list can be filtered by number or primary name.
- For a vendor to be eligible for merge, the selected vendors are required to have the same values for the following fields:
- Tax ID Type
- ID #
- Type 1099
- Effective Calendar Year: When merged, any existing transactions for the old vendor in the selected calendar year only will be changed.
- Click on Merge to merge the selected vendors into the originating vendor. The selected vendors will be made inactive and marked as Merged.
- The vendor(s) being merged will no longer be active and the associated transactions beginning with calendar year selected will now be linked to the primary vendor.
- An output report will generate showing any transactions that will be updated to the new vendor as a result of the merge. A copy of this report is automatically sent to the Calendar Year section of the File Archive.
- The vendor(s) being merged will no longer be active and the associated transactions beginning with calendar year selected will now be linked to the primary vendor.
...
Once vendors have been merged, the list of "old" vendors that were merged into the vendor being viewed will show in the Merged Vendor grid. This grid will show the Vendor Name, Number, Calendar Year of the change, and the date the Merge was performed. In order to regenerate a report of the transactions updated in the merge, click the print icon on the row to generate a report for any one merged vendor. To print a report for more than one merged vendor, use the checkbox in the first column to select vendors then click the Print button at the top of the grid. To close the Merged Vendor pop up window, click the Close button at the top.
Vendor Updates
...
If the vendors involved in the merge have associated Accounts Receivable records, the Billings and Payments will be updated to include the Customer (new vendor) and the Original Customer (merged vendor) on the transaction. Any updated Billing and Payment transactions will show on the Merged Vendor Transactions report. The Customer associated with the merged vendor will be made inactive.Customer (merged vendor) on the transaction. Any updated Billing and Payment transactions will show on the Merged Vendor Transactions report. The Customer associated with the merged vendor will be made inactive.
Un-Merge Vendor
After a vendor has been merged, the option to Un-Merge Vendor will become available. When a vendor is unmerged, any transactions previously updated to the new vendor will be changed back to the original vendor. This will only apply for the transactions originally changed. The vendor's merge flag will be cleared and the vendor will be made Active. In order to view a list of qualifying transactions, use the print option from the Merge List prior to using the unmerge option.
- View an active vendor
- Click on Merged Vendors to open the Merged Vendors grid.
- On the Merged Vendors List, locate the vendor that should be unmerged.
- Prior to unmerging, use the print icon to generate a list of transactions that were updated during the merge. These transactions will be unmerged.
- Use the checkbox to select the vendor to be unmerged
- Click Un-Merge Vendor
- Review the information in the pop up and click Yes to proceed
File Archive
When a Vendor Merge is performed, the Merge Vendor Transactions report showing the results of the merge will be sent to the File Archive. These reports will show in the Calendar Year Reports Archive tab for the Calendar Year associated with the "Effective Calendar Year" chosen when the merge is performed. These reports will contain the date of the merge in the file name as well as a timestamp field.
...
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 Name | Maximum 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 |
| Required field only when changing vendor's Active/Inactive status. |
Default Payment Type |
| Identifies the default payment type for the vendor. This is case sensitive and should be entered as shown. |
Ignore Limits |
| Indicates if vendor should ignore the 1099 limits. |
Tax ID Type |
| 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 |
| 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).
| 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).
| The vendor's beginning date for New Hire reporting. |
Months | Numeric up to 2 digits. | The number of months the vendor's work is to be performed. |
Email Address | Character string | The Vendor's email address. |
Last Activity Date | n/a | Date of Last transaction activity on the vendor. This field is non-modifiable and should not be included in a vendor import. |
Minority Vendor |
| Identifies if the vendor is a minority vendor. |
Withhold Child Support |
| Indicates if the vendor should have child support payments withheld. |
ACH Active |
| 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 Number | Numeric and Alpha | Indicates the Vendor's bank account number. |
Bank Routing Number | Numeric | Indicates the Vendor's bank routing number. |
Deposit Type |
| Identifies the deposit type for the vendor.
|
Entry Class Code |
| 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. |
Location | Text | 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 ) |
Name1 | Maximum length is 16 characters. | Identifies the vendor's name to be used for specified location. |
Name2 | Maximum length is 16 characters. | Identifies a 2nd vendor name field to be used for specified location. |
Line1 | Numeric and Text | Identifies street address for vendor's specified location. |
Line2 | Numeric and Text | Allows for a second address line for the vendor's specified location |
City | Text | Identifies the City for the vendor's specified location. |
State | Two character State abbreviation | Identifies the State for the vendor's specified location. |
Zip | Numeric | Identifies the Zip Code for the vendor's specified location. |
Country | Text | Identifies the Country for the vendor's specified location. |
Phone | Numeric | Identifies the Phone number for the vendor. |
Extension | Numeric | Identifies the Phone extension number for the vendor. |
Country Code | Numeric | Identifies the Phone country code. |
1099 |
| Identifies if Location entered is the 1099 address to be used. |
Check |
| Identifies if Location entered is the Check address to be used. |
PO |
| Identifies if Location entered is the PO address to be used. |
...
Field | Format | Definition |
---|---|---|
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).
| 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. |
Description | Character String | Description that will show on Vendor Adjustment grid for this entry |
Taxable |
| 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. |
Amount | Must be a number. Cannot use $ or commas. | Required field Amount for this vendor adjustment. |
...