This report runs using a Point-In-Time logic. Basically this means that the report shows all the invoice balances as they existed on the date entered in the AR Date field.


When Running Report with Include Deposits Off and Include Security Deposits Off

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposit (Prepayment) Allocations - The report then finds all Prepayment Allocations where the Prepayment Transaction Date is on or before the AR Date and the target of that allocation (receivable invoice) has an Invoice Date on or before the AR Date.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals", and the "Deposit (Prepayment) Allocations"


When Running Report with Include Deposits On and Include Security Deposits Off

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposits (Prepayments) - The report then gathers all prepayments where the Transaction Date is on or before the AR Date and includes the full amount of that prepayment.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals" and the "Deposits (Prepayments)".


When Running Report with Include Deposits On and Include Security Deposits On

  • Steps the Report Takes
  • Find Invoice and Credit Note Balances - The report gathers all invoices, and credit notes where the Invoice Date is on or before the AR Date in the report. It then sums all the active line items of those invoices and credit notes to get a customer balance.
  • Find Payment and Refund Totals - The report then gathers all payments, refunds, and payments on account where the Transaction Date is on or before the AR Date.
  • Find Deposits (Prepayments) - The report then gathers all prepayments where the Transaction Date is on or before the AR Date and includes the full amount of that prepayment.
  • Find Security Deposits - The report then gathers all Security Deposits where the Transaction Date is on or before the AR Date and includes the full amount of that Security Deposits.
  • It then combines the "Invoice and Credit Note Balances", the "Payment and Refund Totals" , the " Deposits (Prepayments)" and the "Security Deposits".