get_ar_aging — A/R Aging

Which customers owe money and how overdue — open A/R invoices bucketed current / 1-30 / 31-60 / 60+ days.

This is a Named SQL Query (SAP /SQLQueries) — dynamic aggregate SQL returning per-query rows, not a fixed Service Layer entity.

AR aging report — which customers owe money and how overdue are they. Returns each open customer (A/R) invoice with its aging bucket — current, 1-30, 31-60, or 60+ days overdue — plus days overdue, due date, amount, and currency. Only open invoices appear; a paid/closed invoice is not overdue.

Try these prompts

“show me the AR aging”
“who owes us money?”
“which customers are more than 60 days overdue?”
“AR aging for customer C001”
“overdue receivables as of 2025-12-31”

נסו גם בעברית

“הראה לי את חובות הלקוחות”
“מי חייב לנו כסף?”
“אילו לקוחות באיחור של יותר מ-60 יום?”
“מה מצב הגבייה מהלקוחות?”
“אילו חובות פתוחים יש נכון לסוף השנה?”

Arguments

Arg	Required	Meaning
`card_code`	optional	One customer, e.g. `C001`. Omit for all customers.
`as_of_date`	optional	`YYYY-MM-DD` — compute aging as of this date (e.g. period-end). Omit for today.

Example result

Two accounts receivable over 60 days. C002 Beta Industries — $1,250, 60+ days overdue. C001 Acme Corp — $1,800, 60+ days overdue.

Result columns

Column	Type	Meaning
`card_code`	text	The customer’s SAP code.
`card_name`	text	The customer’s name.
`doc_num`	number	The A/R invoice’s document number.
`doc_date`	date	When the invoice was posted.
`due_date`	date	When payment falls due (empty when the invoice carries none).
`overdue_days`	number	Days past due at the as-of date; negative while still current.
`bucket`	text	The aging band this invoice falls in: `current`, `1-30`, `31-60`, or `60+`.
`doc_total`	number	The amount still owed on the invoice.
`currency`	text	The invoice’s currency code (empty when unset).

Charts

bar: x=doc_num, y=doc_total, title=“Open value by document”
bar: x=doc_num, y=overdue_days, title=“Days overdue by document”

list_ar_invoices — a plain list of invoices (not aged).
get_ap_aging — the supplier (accounts payable) side.
get_credit_exposure — total exposure per customer vs their limit.