Vendor Invoice Base
Use this base to see information for each of your vendor invoices, such as invoice date, amount, and aging.
| Available Columns | Description | Date Range Available | Chartable | Links to Page |
| General Information | ||||
| Company Name | The name of the company associated with the vendor invoice | Company | ||
| Credit Card Statement |
The credit card statement associated with the vendor invoice Applies only to invoices with the type of Credit Card. |
Bank Statement | ||
| Invoice Description | A description entered on the vendor invoice | |||
| Invoice Number | The ID of the vendor invoice | |||
| 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. |
|||
| Is Billed | Indicates if the amount on the vendor invoice has been billed to the client | |||
| Is On Hold | Indicates if the invoice is on hold | |||
| Is PM or Principal | Indicates if the person logged in is the PM or Principal for the vendor invoice | |||
| Notes | Any notes entered on the vendor invoice | |||
| PM Approval Required | Indicates if the vendor invoice requires project manager or principal approval | |||
| PM Approved | Indicates if the vendor invoice has been approved by all the project manager or principal | |||
| PM Rejected | Indicates if the vendor invoice has been rejected by any of the project manager or principal | |||
| Receives 1099? | Indicates whether the vendor associated with the invoice receives a 1099 form | |||
| Vendor Account ID | The Vendor Account ID of the vendor associated with the vendor invoice | |||
| Vendor Company Name | The name of the company associated with the vendor | Company | ||
| Vendor Department Name | The department associated with the vendor invoice | Department | ||
| Vendor Status | The status of the vendor associated with the vendor invoice | |||
| Vendor Type |
The vendor type associated with the vendor invoice Examples: Communications, Electrical Consultant, Government |
Vendor Type | ||
| Vendor | The name of the vendor associated with the invoice | Vendor | ||
| W9 Form Received | Indicates whether the vendor associated with the invoice completed a W9 form | |||
| Dates | ||||
| Accounting Date | The date Ajera uses to determine the period for which the vendor invoice appears on financial statements | |||
| Finance Approved Date | The date the invoice was approved by the finance approver | |||
| Finance Rejected Date | The date the invoice was rejected by the finance approver | |||
| Invoice Date to Pay | The date Ajera uses to determine if your payment of the vendor invoice is past due | |||
| Invoice Date |
The date of the vendor invoice Aging is based on this date. |
Vendor Invoice | ||
| Last Payment Date | The date a last payment was made for the invoice | |||
| PM Approved Date | The date the invoice was approved by the project manager or principal (last project manager approval date) | |||
| PM Rejected Date | The date the invoice was rejected by the project manager or principal | |||
| Dollars | ||||
| Amount Paid | The amount of the invoice already paid to the vendor | X | ||
| Amount to Pay | The amount of the invoice to be paid to the vendor as entered in Manage Vendor Payments | X | ||
| Amount to Write-off | The amount of the invoice to be written off as entered in Manage Vendor Payments | X | ||
| Amount Written off | The amount of the invoice already written off | X | ||
| Balance as of Accounting Date | The amount remaining to be paid to the vendor as of the accounting date. | X | X | |
| Balance as of Invoice Date |
The amount remaining to be paid to the vendor as of the invoice date. This amount is used to determine aging. |
X | X | |
| Invoice Amount | The total amount of the vendor invoice | X | X | |
| Accounts | ||||
| Account | The GL account associated with the vendor invoice | GL Account | ||
| Credit Card Bank Account | The bank account associated with the Credit Card account | |||
| Expense Report Account |
The expense report GL account associated with the vendor invoice Applies only to invoices with the type of Expense Report. |
GL Account | ||
| Action | ||||
| Open Vendor Invoice | Opens the vendor invoice | |||
| Keys | ||||
| Company Key | The database identifier of the company associated with the vendor invoice | Company | ||
| 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. |
Bank Statement | ||
| Expense Report Key |
The database identifier of the expense report associated with the vendor invoice Applies only to invoices with the type of Expense Report. |
Expense Report | ||
| Finance Approver Key | The database identifier of the finance approver | |||
| GL Account Key | The database identifier of the GL account associated with the vendor invoice | GL Account | ||
| Payment filter | To filter by payment | |||
| Project Filter | To filter by project | |||
| Vendor Company Key | The database identifier of the company associated with the vendor | Company | ||
| Vendor Department Key | The database identifier of the department associated with the vendor invoice | Department | ||
| Vendor Invoice Key | The database identifier of the vendor invoice | Vendor Invoice | ||
| Vendor Key | The database identifier of the vendor | Vendor | ||
| Vendor Type Key | The database identifier of the vendor type associated with the vendor invoice | Vendor Type | ||
| Action | ||||
| Attachments |
View the uploaded attachments for the vendor invoice. The attachment icon will be highlighted green |
|||
| Open Vendor Invoice | Opens the vendor invoice to allow you to edit it. | |||
| Gantt |
unavailable in ajeraCore Select to add the Gantt chart to your table widget. |
|||
if an uploaded attachment exists. 