You are here: Ajera Help (A-Z) > Inquiries > Inquiry descriptions > Vendor Invoice inquiry

Vendor Invoice inquiry

Use this inquiry to see information for each of your vendor invoices, such as invoice date, amount, and aging.

If needed, you can add predefined columns and view supplemental information. For example, you can view invoice type, status, and description; amounts to pay and to write off; and expense report or credit card statement details.

Using the inquiry

From the Inquiry menu, click Vendor > Vendor Invoice.

Audience

Accounting staff

Standard columns

Column	Links to this inquiry	Description	Date range available
Vendor	Vendor	The name of the vendor associated with the invoice
Invoice Number		The ID of the vendor invoice
Invoice Date		The date of the vendor invoice Aging is based on this date.
Invoice Amount		The total amount of the vendor invoice	x
Amount Paid		The amount of the invoice already paid to the vendor
Amount Written off		The amount of the invoice already written off
Vendor Payment	Vendor Payment	A link to the Vendor Payment inquiry The inquiry displays information about the vendor payments associated with the vendor invoice.
Outstanding	Vendor Payment	The amount of the invoice remaining to be paid to the vendor
Aging 0-30	Vendor Payment	The amount remaining to be paid on a vendor invoice that is less than 31 days old
Aging 31-60	Vendor Payment	The amount remaining to be paid on a vendor invoice that is between 31 and 60 days old
Aging 61-90	Vendor Payment	The amount remaining to be paid on a vendor invoice that is between 61 and 90 days old
Aging 91-120	Vendor Payment	The amount remaining to be paid on a vendor invoice that is between 91 and 120 days old
Aging +121	Vendor Payment	The amount remaining to be paid on a vendor invoice that is older than 120 days

Predefined columns

You can add predefined columns to this inquiry. Many columns are available, organized in these categories:

General info
Vendor info
Defined links

Column	Links to this inquiry	Description	Date range available
General info:
Vendor Invoice Key		The database identifier of the vendor invoice
Vendor Key	Vendor	The database identifier of the vendor
Invoice Status		The status of the invoice Examples: Normal
Invoice Type		The type of vendor invoice Examples: Credit Card, Expense Report, Payroll Service, Refund, Regular The invoice type identifies the source of the invoicing information. For example, when you enter information in Manage > Vendor Invoices, it creates a Regular invoice type, or when you close a credit card statement in Manage > Bank Register, it creates a Credit Card invoice type.
Invoice Description		A description entered on the vendor invoice
Invoice Company Key		Multi-company only. The database identifier of the company associated with the vendor invoice
Invoice Company Name		Multi-company only. The name of the company associated with the vendor invoice
Notes		Any notes entered on the vendor invoice
Invoice Date to Pay		The date Ajera uses to determine if your payment of the vendor invoice is past due	x
Accounting Date		The date Ajera uses to determine the period for which the vendor invoice appears on financial statements	x
Amount to Pay		The amount of the invoice to be paid to the vendor as entered in Manage Vendor Payments
Amount to Write off		The amount of the invoice to be written off as entered in Manage Vendor Payments
Balance as of Invoice Date	Vendor Payment	The amount remaining to be paid to the vendor as of the invoice date. This amount is used to determine aging.	x
Balance as of Accounting Date	Vendor Payment	The amount remaining to be paid to the vendor as of the accounting date.	x
Expense Report Key	Expense Report	The database identifier of the expense report associated with the vendor invoice Applies only to invoices with the type of Expense Report.
Expense Report Account	GL Account	The expense report GL account associated with the vendor invoice Applies only to invoices with the type of Expense Report.
Credit Card Statement Key		The database identifier of the credit card statement associated with the vendor invoice Applies only to invoices with the type of Credit Card.
Credit Card Statement		The credit card statement associated with the vendor invoice Applies only to invoices with the type of Credit Card.
Credit Card Bank Account	Bank Account	The bank account associated with the Credit Card account
Is Billed		Indicates if the amount on the vendor invoice has been billed to the client
Vendor info:
Vendor Type Key		The database identifier of the vendor type associated with the vendor invoice
Vendor Type	Vendor Type	The vendor type associated with the vendor invoice Examples: Communications, Electrical Consultant, Government
Department Key		unavailable in ajeraCore unless you have the Departments add-on The database identifier of the department associated with the vendor invoice
Department	Department	unavailable in ajeraCore unless you have the Departments add-on The department associated with the vendor invoice
Vendor Company Key		Multi-company only. The database identifier of the company associated with the vendor
Vendor Company Name		Multi-company only. The name of the company associated with the vendor
Account Key		The database identifier of the GL account associated with the vendor invoice
Account	GL Account	The GL account associated with the vendor invoice
Receives 1099?		Indicates whether the vendor associated with the invoice receives a 1099 form
W9 Form Received		Indicates whether the vendor associated with the invoice completed a W9 form
Defined links:
Link - Vendor Payment	Vendor Payment	A link to the Vendor Payment inquiry
Link - Transaction - All	Transaction - All	A link to the Transaction - All inquiry
Link - GL Entry - Accrual	GL Entry - Accrual	A link to the GL Entry inquiry