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 
> Reports menu, click Standard Inquiries > 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:
| Column | Links to this inquiry | Description | Date range available |
|---|---|---|---|
|
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 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 |
|
|
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 |
|
