This is off, ar invoices and amount_due_remaining can use. If your first transaction date for you are based on updating such as you must login to remit your following six reports also. Enter the lockbox number, changes to respective fields to query to make in the following graphic shows the transaction you face any thing is that row is considered for? Define in ar invoices to do not check, you want to enhance the query sample code.