get_revenue_annual — Annual Revenue

How much we invoiced per customer and salesperson, by year, from posted A/R invoices.

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

Annual revenue report — how much we invoiced per customer and salesperson, by year. Returns one row per year × customer × salesperson with the summed revenue, plus the year and a YYYY period label (e.g. 2025), newest year first. Revenue is taken from posted A/R invoices.

Try these prompts

“show me annual revenue”
“how much did we invoice in 2025?”
“yearly revenue”
“annual revenue for C001”

נסו גם בעברית

“הצג הכנסות שנתיות”
“כמה חייבנו בשנה שעברה?”
“מה ההכנסה השנתית?”

Arguments

Arg	Required	Meaning
`card_code`	optional	One customer, e.g. `C001`. Omit for all customers.

Example result

2025 topped $100k. 2025 — C001 Acme Corp $110,000; C002 Beta Industries $62,000. 2024 — C001 Acme Corp $88,000.

Result columns

Column	Type	Meaning
`year`	number	The calendar year. Declared `number` because that is what the row holds (`int32` in the query); it reads as a label, but the type states the DATA, not the axis role.
`period_label`	text	The same year rendered for display, e.g. `2025`.
`customer_code`	text	The invoiced customer’s SAP code.
`customer_name`	text	The invoiced customer’s name.
`salesperson_code`	number	The salesperson credited with the invoices (0 when unassigned).
`revenue`	number	Revenue posted for that year × customer × salesperson.

Charts

None. This tool returns one row per period × customer × salesperson, so period_label repeats across rows and a bar keyed on it would draw the same year many times. Aggregation belongs in the tool’s SQL, not the chart layer (decided 2026-07-29): a chart is declarable only where the tool already returns the grain the chart wants. get_revenue_yoy is the already-aggregated tool for this question, and it does declare charts.

get_revenue_quarterly / get_revenue_monthly — finer breakdowns.