Report Designer: Vendor variables

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The Report Designer Vendor variables display information on reports about the vendor setup. The following tables list all of the currently available variables, what they output, and where the information is retrieved from within the application.

See also: Variables overview

Workpapers CS users: This section of variables is visible in the Design Tools frame in the Report Designer, but will not output any information. If any of these variables are inserted, the report or other document will display as "This report contains no data."

Vendor

Variable name Data content/source Format Variable syntax
Vendor Account The account number for the client that the vendor has assigned, from Setup > Vendors Number [Vendor.Account]
Vendor DBA Name The doing business as (DBA) name for the vendor from Setup > Vendors Text [Vendor.DBAName]
EIN or SSN The EIN or SSN for the vendor from Setup > Vendors Number [Vendor.EINSSN]
EIN or SSN Last Four Digits The last four digits of the vendor EIN or SSN from Setup > Vendors Number [Vendor.EINSSNLastFourDigits]
EIN or SSN Verified Date The date the EIN or SSN was verified for the vendor from Setup > Vendors Date [Vendor.EINSSNVerifiedDate]
Exclude Vendor from Fee Calculation Exclude from fee calculations checkbox on Setup > Vendors Yes/No [Vendor.ExcludefromFeeCalculation]
Vendor ID The vendor ID from Setup > Vendors Text [Vendor.ID]
Inactive Date The inactive date for the vendor from Setup > Vendors Date [Vendor.InactiveDate]
Inactive Reason The inactive reason for the vendor from Setup > Vendors Text [Vendor.InactiveReason]
Vendor Name The name of the vendor from Setup > Vendors Text [Vendor.Name]
Type The type of the vendor (1099 Recipient, Trade, or Payroll Agent) from Setup > Vendors Text [Vendor.Type]

1099 Properties

Variable name Data content/source Format Variable syntax
Default Default checkbox on Setup > Vendors Yes/No [Vendor.1099Properties.Default]
First Box The first box selection for the 1099 form on Setup > Vendors Number [Vendor.1099Properties.FirstBox]
First Box Description The description of the first box selected for the 1099 form on Setup > vendors Text [Vendor.1099Properties.FirstBoxDescription]
Form The selected 1099 form for the vendor on Setup > Vendors Text [Vendor.1099Properties.Form]
One Form per Transaction One form per transaction checkbox on Setup > Vendors Yes/No [Vendor.1099Properties.OneFormperTransaction]
Second Box The second box selection for the 1099 form on Setup > Vendors Number [Vendor.1099Properties.SecondBox]
Second Box Description The description of the second box selected for the 1099 form on Setup > Vendors Text [Vendor.1099Properties.SecondBoxDescription]

Accounts Payable

Variable name Data content/source Format Variable syntax
Beginning Balance The beginning balance amount for the vendor from Setup > Vendors Amount [Vendor.AccountsPayable.BeginningBalance.Amount]
GL Account Number The AP GL account assigned to the vendor from Setup > Vendors Text [Vendor.AccountsPayable.GeneralLedgerAccount.AccountsPayable.GLAccount]
GL Account Description The AP GL account description assigned to the vendor from Setup > Vendors Text [Vendor.AccountsPayable.GeneralLedgerAccount.AccountsPayable.GLAccountDescription]
Memo The memo field for the vendor payable on Setup > Vendors Text [Vendor.AccountsPayable.PayableInformation.Memo]
PO Number The PO number field on Setup > Vendors Text [Vendor.AccountsPayable.PayableInformation.PONumber]
Payment Term Description The payment term description from Setup > Vendors Text [Vendor.AccountsPayable.PaymentTerm.PaymentTermDescription]
Payment Term ID The payment term ID from Setup > Vendors Text [Vendor.AccountsPayable.PaymentTerm.PaymentTermID]

Addresses

Variable name Data content/source Format Variable syntax
Business Address Line 1 The first line of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.AddressLine1]
Business Address Line 1 and Line 2 The first and second lines of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.AddressLine1andAddressLine2]
Business Address Line 2 The second line of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.AddressLine2]
Business Address City The city of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.City]
Business Address City, State, and Zip The city, state, and zip code of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.CityStateandZip]
Complete Business Address The complete business address for the vendor, from Setup > Vendors Text [Vendor.Business.CompleteAddress]
Complete Business Address (Single line) The complete business address for the vendor on a single line, from Setup > Vendors Text [Vendor.Business.CompleteAddressSingleLine]
Business Address Country The country of the business address for the vendor, from Setup > Vendors Text [Vendor.Business.Country]
Business Address County The county of the business address for the vendor from Setup > Vendors Text [Vendor.Business.County]
Business Address State (abbreviation) The state abbreviation of the business address for the vendor from Setup > Vendors Text [Vendor.Business.State]
Business Address State (full name) The name of the state of the business address of the vendor from Setup > Vendors Text [Vendor.Business.StateName]
Business Address Zip code The zip code of the business address of the vendor from Setup > Vendors Number [Vendor.Business.Zip]
Home Address Line 1 The first line of the home address for the vendor, from Setup > Vendors Text [Vendor.Home.AddressLine1]
Home Address Line 1 and Line 2 The first and second lines of the home address for the vendor, from Setup > Vendors Text [Vendor.Home.AddressLine1andAddressLine2]
Home Address Line 2 The second line of the home address for the vendor, from Setup > Vendors Text [Vendor.Home.AddressLine2]
Home Address City The city of the home address for the vendor, from Setup > Vendors Text [Vendor.Home.City]
Home Address City, State and Zip The city, state, and zip code of the home address for the vendor, from Setup > Vendors Text [Vendor.yStateandZip]
Complete Home Address The complete home address for the vendor, from Setup > Vendors Text [Vendor.Home.CompleteAddress]
Complete Home Address (Single Line) The complete home address for the vendor on a single line, from Setup > Vendors Text [Vendor.Home.CompleteAddressSingleLine]
Home Address Country The country of the home address for the vendor, from Setup > Vendors Text [Vendor.Home.Country]
Home Address County The county of the home address for the vendor from Setup > Vendors Text [Vendor.Home.County]
Home Address State (abbreviation) The state abbreviation of the home address for the vendor from Setup > Vendors Text [Vendor.Home.State]
Home Address State (full name) The name of the state of the home address of the vendor from Setup > Vendors Text [Vendor.Home.StateName]
Home Address Zip Code The zip code of the home address of the vendor from Setup > Vendors Number [Vendor.Home.Zip]
Mailing Address Line 1 The first line of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.AddressLine1]
Mailing Address Line 1 and Line 2 The first and second lines of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.AddressLine1andAddressLine2]
Mailing Address Line 2 The second line of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.AddressLine2]
Mailing Address City The city of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.City]
Mailing Address City, State and Zip The city, state, and zip code of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.CityStateandZip]
Complete Mailing Address The complete mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.CompleteAddress]
Complete Mailing Address (Single line) The complete mailing address for the vendor on a single line, from Setup > Vendors Text [Vendor.Mailing.CompleteAddressSingleLine]
Mailing Address Country The country of the mailing address for the vendor, from Setup > Vendors Text [Vendor.Mailing.Country]
Mailing Address County The county of the mailing address for the vendor from Setup > Vendors Text [Vendor.Mailing.County]
Mailing Address State (abbreviation) The state abbreviation of the mailing address for the vendor from Setup > Vendors Text [Vendor.Mailing.State]
Mailing Address State (full name) The name of the state of the mailing address of the vendor from Setup > Vendors Text [Vendor.Mailing.StateName]
Mailing Address Zip code The zip code of the mailing address of the vendor from Setup > Vendors Number [Vendor.Mailing.Zip]
Other Address Line 1 The first line of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.AddressLine1]
Other Address Line 1 and Line 2 The first and second lines of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.AddressLine1andAddressLine2]
Other Address Line 2 The second line of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.AddressLine2]
Other Address City The city of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.City]
Other Address City, State, and Zip The city, state, and zip code of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.CityStateandZip]
Complete Other Address The complete other address for the vendor, from Setup > Vendors Text [Vendor.Other.CompleteAddress]
Complete Other Address (Single line) The complete other address for the vendor on a single line, from Setup > Vendors Text [Vendor.Other.CompleteAddressSingleLine]
Other Address Country The country of the other address for the vendor, from Setup > Vendors Text [Vendor.Other.Country]
Other Address County The county of the other address for the vendor from Setup > Vendors Text [Vendor.Other.County]
Other Address State (abbreviation) The state abbreviation of the other address for the vendor from Setup > Vendors Text [Vendor.Other.State]
Other Address State (full name) The name of the state of the other address of the vendor from Setup > Vendors Text [Vendor.Other.StateName]
Other Address Zip code The zip code of the other address of the vendor from Setup > Vendors Number [Vendor.Other.Zip]

Direct Deposit

Variable name Data content/source Format Variable syntax
Allocation Amount The fixed amount of the direct deposit allocation from Setup > Vendors Amount [Vendor.DirectDeposit.AllocationAmount]
Allocation Bank Account Number The bank account number for direct deposit allocation from Setup > Vendors Number [Vendor.DirectDeposit.AllocationBankAccountNumber]
Allocation Bank Account Number (Last four digits) The last four digits of the bank account number for direct deposit allocation from Setup > Vendors Number [Vendor.DirectDeposit.AllocationBankAccountNumberLastFourDigits]
Allocation Bank Account Type The type of bank account (checking or savings) for direct deposit allocation from Setup > Vendors Text [Vendor.DirectDeposit.AllocationBankAccountType]
Allocation Bank Name The name of the bank for direct deposit allocation from Setup > Vendors Text [Vendor.DirectDeposit.AllocationBankName]
Allocation Bank Account Routing Number The routing number of the bank for direct deposit allocation from Setup > Vendors Number [Vendor.DirectDeposit.AllocationBankRoutingNumber]
Allocation Percent The percent of the distribution to allocate to the specified bank account from Setup > Vendors Number [Vendor.DirectDeposit.AllocationPercent]
Allocation Percentage Basis The percentage calculation basis (total distribution of remainder of distribution) for direct deposit allocation from Setup > Vendors Text [Vendor.DirectDeposit.AllocationPercentageBasis]
Allocation Status The status of the bank account for direct deposit allocation from Setup > Vendors Text [Vendor.DirectDeposit.AllocationStatus]
Paycard Recipient Paycard recipient checkbox on Setup > Vendors Yes/No [Vendor.DirectDeposit.PaycardRecipient]

Distributions

Variable name Data content/source Format Variable syntax
Amount The default amount of the distributions from Setup > Vendors Amount [Vendor.Distributions.Amount]
Description The description of the distributions from Setup > Vendors Text [Vendor.Distributions.Description]
GL Account Number The GL account number of the distributions from Setup > Vendors Text [Vendor.Distributions.GLAccount]
GL Account Description The GL account description of the distributions from Setup > Vendors Text [Vendor.Distributions.GLAccountDescription]
Standard Amount The standard amount of the distributions from Setup > Vendors Amount [Vendor.Distributions.StandardAmount]
Transaction Memo The transaction memo field from Setup > Vendors Text [Vendor.Distributions.TransactionMemo]

Email and Web Addresses

Variable name Data content/source Format Variable syntax
Email Address The email address for the vendor from Setup > Vendors Text [Vendor.Email]
Website The web address for the vendor from Setup > Vendors Text [Vendor.Website]

Payment Preferences

Variable name Data content/source Format Variable syntax
Bank Account The bank account name of the preferred bank account from the vendor from Setup > Vendors Text [Vendor.PaymentPreferences.BankAccount]
Method The preferred payment method for the vendor from Setup > Vendors Text [Vendor.PaymentPreferences.Method]
Payment Preferences List Outputs a list of possible selections for the payment preferences from Setup > Vendors Text [Vendor.PaymentPreferences.PayPreferencesList]
Reminder The reminder field from Setup > Vendors Text [Vendor.PaymentPreferences.Reminder]
Taxpayer PIN The taxpayer PIN field from Setup > Vendors (if applicable) Number [Vendor.PaymentPreferences.TaxpayerPIN]
Use Payroll Bank Account Always use payroll bank account for payroll liabilities checkbox on Setup > Vendors Yes/No [Vendor.PaymentPreferences.UsePayrollBankAccountforPayrollLiabilities]

Phone and Fax Numbers

Variable name Data content/source Format Variable syntax
Business Extension The business extension for the vendor from Setup > Vendors Number [Vendor.Business.Extension]
Business Number The business number for the vendor from Setup > Vendors Number [Vendor.Business.Number]
Business Number and Extension The business number and extension for the vendor from Setup > Vendors Number [Vendor.Business.NumberandExtension]
Car Extension The car extension for the vendor from Setup > Vendors Number [Vendor.Car.Extension]
Car Number The car number for the vendor from Setup > Vendors Number [Vendor.Car.Number]
Car Number and Extension The car number and extension for the vendor from Setup > Vendors Number [Vendor.Car.NumberandExtension]
Fax Extension The fax extension for the vendor from Setup > Vendors Number [Vendor.Fax.Extension]
Fax Number The fax number for the vendor from Setup > Vendors Number [Vendor.Fax.Number]
Fax Number and Extension The fax number and extension for the vendor from Setup > Vendors Number [Vendor.Fax.NumberandExtension]
Home Extension The home extension for the vendor from Setup > Vendors Number [Vendor.Home.Extension]
Home Number The home number for the vendor from Setup > Vendors Number [Vendor.Home.Number]
Home Number and Extension The home number and extension for the vendor from Setup > Vendors Number [Vendor.Home.NumberandExtension]
Mobile Extension The mobile extension for the vendor from Setup > Vendors Number [Vendor.Mobile.Extension]
Mobile Number The mobile number for the vendor from Setup > Vendors Number [Vendor.Mobile.Number]
Mobile Number and Extension The mobile number and extension for the vendor from Setup > Vendors Number [Vendor.Mobile.NumberandExtension]
Other Extension The other extension for the vendor from Setup > Vendors Number [Vendor.Other.Extension]
Other Number The other number for the vendor from Setup > Vendors Number [Vendor.Other.Number]
Other Number and Extension The other number and extension for the vendor from Setup > Vendors Number [Vendor.Other.NumberandExtension]
Pager Extension The pager extension for the vendor from Setup > Vendors Number [Vendor.Pager.Extension]
Pager Number The pager number for the vendor from Setup > Vendors Number [Vendor.Pager.Number]
Pager Number and Extension The pager number and extension for the vendor from Setup > Vendors Number [Vendor.Pager.NumberandExtension]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!