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/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 ...How do I add a withholding tax number to a 1099 vendor?
Add the withholding tax number to a 1099 vendor. You may need to include the withholding tax number in the electronic 1099 file. When you select the 1099 vendor state, the 1099 Information section will show a box for entering a withholding tax ...How do I add a withholding permit number to a 1099 vendor?
Add the withholding permit number to a 1099 vendor. In some situations, a state may require you to include the withholding permit number in the electronic 1099 file. Selecting the 1099 vendor state will show any extra fields that are required for ...