How do I add columns to show vendor information? (Reports)
Set up a report to show additional vendor information that is not included on a master report. For example, when a vendor record was created and the user who created it, when a vendor record was modified and the user who made the changes, and so on.
Adding report columns
1. Open Connect Accounts Payable > Reports > [Report Name].
2. Click to select the Columns tab.
3. Click to select Modify Columns for This Report Line.
Modify columns for the report line
4. Use the Selection window, move the report column to the Selected Columns list.
5. Click OK.
Vendor report columns
[Report].1099 ID Number
[Report].1099 Last Year
[Report].1099 Report Total
[Report].1099 This Year
[Report].Activation Date
[Report].Address 1
[Report].Address 2
[Report].Adjustments Last Year
[Report].Adjustments Report Total
[Report].Adjustments This Year
[Report].Balance
[Report].City State Zip
[Report].Contact
[Report].Current Year Title
[Report].Default Description
[Report].Discounts Last Year
[Report].Discounts Lost Last Year
[Report].Discounts Lost Report Total
[Report].Discounts Lost This Year
[Report].Discounts Report Total
[Report].Discounts This Year
[Report].Last Check Amount
[Report].Last Check Date
[Report].Last Check Number
[Report].Last Invoice Amount
[Report].Last Invoice Date
[Report].Last Invoice Number
[Report].Last PO Amount
[Report].Last PO Date
[Report].Last PO Number
[Report].Last Year Title
[Report].Merchant Name
[Report].Merchant Vendor Number
[Report].Name
[Report].Payments Last Year
[Report].Payments Report Total
[Report].Payments This Year
[Report].Phone
[Report].Purchases Last Year
[Report].Purchases Report Total
[Report].Purchases This Year
[Report].Rating
[Report].Standard GL Account
[Report].Termination Date
[Report].Terms Codes
[Report].Vendor Notes
[Report].Vendor Number
[Report].Vendor Type
<Blank>
<Text>
Terms.Description
Terms.Discount due days
Terms.Discount percent
Terms.Net due days
Terms.Notes
Vendor.1099 ID number
Vendor.1099 type
Vendor.Activation date
Vendor.After Hours Service
Vendor.Alert message
Vendor.Approved vendor
Vendor.Created by
Vendor.Created date
Vendor.Description history
Vendor.First name
Vendor.GL account
Vendor.GL activity number
Vendor.IA withholding permit number
Vendor.Item description
Vendor.Last check amount
Vendor.Last check date
Vendor.Last check number
Vendor.Last invoice amount
Vendor.Last invoice date
Vendor.Last invoice number
Vendor.Last modified by
Vendor.Last modified date
Vendor.Last name
Vendor.Last PO amount
Vendor.Last PO date
Vendor.Last PO number
Vendor.Limited balance
Vendor.Materials Management vendor
Vendor.Middle name
Vendor.Name
Vendor.Notes
Vendor.PY 1099 amount (PY is prior year.)
Vendor.PY adjustments
Vendor.PY discounts
Vendor.PY discounts lost
Vendor.PY payments
Vendor.PY purchases
Vendor.Rating
Vendor.Recipient first name
Vendor.Recipient first name 2
Vendor.Recipient last name
Vendor.Recipient last name 2
Vendor.Recipient middle name
Vendor.Recipient middle name 2
Vendor.Recipient state
Vendor.Recipient suffix
Vendor.Recipient suffix 2
Vendor.Recipient first name
Vendor.Recipient last name
Vendor.Secondary first name
Vendor.Secondary middle name
Vendor.Secondary name
Vendor.Secondary suffix
Vendor.Suffix
Vendor.Termination date
Vendor.Vendor guide
Vendor.Vendor number
Vendor.Vendor type
Vendor.Website
Vendor.WI withholding tax number
Vendor.YTD 1099 amount
Vendor.YTD adjustments
Vendor.YTD balance
Vendor.YTD discounts
Vendor.YTD discounts lost
Vendor.YTD payments
Vendor.YTD purchases
Copyright © 2025 Caselle, Incorporated. All rights reserved.
Related Articles
How do I add additional columns to Vendor Inquiry?
Add columns to the Vendor Inquiry screen to display additional information stored in the vendor file. Adding additional fields to Vendor Inquiry 1. Open Connect Accounts Payable > Vendor Inquiry. 2. Click to select the Invoices tab. 3. Click to ...How do I add user-defined fields to Vendor Inquiry?
If you have set up user-defined fields to collect invoice summary or invoice detail information, you can view the user-defined fields in Vendor Inquiry. Watch a video Learn how to add a user-defined field to Vendor Inquiry (1m25s). Before you get ...How do I add/remove columns for work orders? (Connect Online) (2023.11)
You can customize the work orders grid in Connect Online to show the information that you need to see when you're logged in. Work Orders page, Column headers Available columns Assigned to City Created By Created Date Department Description Due date ...Vendor List
Use Vendor List to print a list of vendors. You can print the vendor list for a single vendor, group of vendors, or all vendors. The master reports that show the vendor's 1099 ID Number will display it as an unencrypted number. Vendor List by Vendor ...How do I add a new vendor?
A vendor is an individual, entity, or organization that will fill the purchase order. You can use Setup New Vendor or Modify Existing Vendors to set up a new vendor record, make changes to an existing vendor record, or delete a vendor record. You ...