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 if an uploaded attachment exists.

     
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.