Job Payables - List Box Column Descriptions

The columns on this screen show the critical vendor and customer invoice information.

Understanding how A/R Invoices are assigned to Vendor Invoices

The rules for associating customer invoices with vendor invoices depends on the 'Job Type'.

  • Fixed Price / Unit Price Job Type: The system will read for the customer on the primary contract looking for the first invoice dated later than the vendor invoice on the current row. All vendor invoices that fall into this group will be associated to the customer invoice. All A/R credit memos are skipped as are A/R invoices dated exactly the same as the vendor invoice.

  • T+M / Cost Plus Job Type: The system will read the T+M Billing History Table for the vendor and A/P invoice number referenced on the current row. If found, it will then read for the A/R invoice generated by this transaction and determine whether or not it has been paid.

Columns

Descriptions

Pymt status

The status that displays depends on the pay-when-paid setting in Accounts Payable.

If the current job is not authorized for pay-when-paid processing, the status will be 'Released'.

Vendor

AP invoice #

AP current balance

This column displays the current portion of outstanding balance of the vendor invoice or credit memo.

Days old

This is the number of days from 'A/P invoice date' to the current system date.

AR% paid

This column is calculated by taking the 'Customer current paid' divided by the 'Customer original current' columns.

Release note

The pay-when-paid release note text displays from the Vendor Invoice Inquiry screen.

Customer invoice date

Customer paid date

The latest payment date for the customer invoice displays.

Customer original current

The original 'current portion' of the Invoice Total of the customer invoice displays.

Customer original total

This is the invoice total for the customer.

Customer current paid

This column includes all cash receipts performed on the 'Customer invoice #'. For more information, use the Contract Info Bar to navigate to Payment History.

Customer invoice #

Customer

AP company

This column indicates the Spectrum company where the invoice's payable is booked.

AP invoice date

This is the date of the vendor transaction.

AP original total

This is the invoice total for the vendor transaction.

AP retention balance

This is the outstanding Balance of the vendor transaction.

AP on hold?

This column indicates whether the invoice is on hold.

AP invoice status

This column indicates where the invoice is in the update process (unapproved, unposted, or open).