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 ...Webinar: Accounts Payable Year End - Convert year-end tax information (05m59s)
Transfer the 1099 vendor and invoice information from the Accounts Payable application to the 1099 Recipients table in the Government Reporting application. In this webinar, learn how to: Step 6. Convert Year-end tax information [More] 202411, ...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 ...