Skip to content

Receivables Query

Receivables Query shows outstanding customer balances and aging analysis as of a selected date.

Navigation: left sidebar → Revenues → Receivables Query (/revenue/ar-query).

Receivables Query
ColumnDescription
NumberInvoice number.
Date / Due DateInvoice and payment due dates.
CustomerCustomer name.
Grand TotalInvoice amount.
Due AmountOutstanding balance.
In DueCurrent (not overdue) portion.
30 / 60 / 90 / 90+Aging buckets for overdue amounts.
  1. Set As of date.
  2. Optionally filter by Customer or Org unit.
  3. Run the search / refresh.
  4. Use Export when you need Excel output.

From a row context menu you can typically create an AR offset, start Customer pay, or open related customer/invoice details.