Report

Which suppliers we owe and how overdue — open A/P invoices bucketed current / 1-30 / 31-60 / 60+ days.

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

Expected A/R collections from open invoices due within the next N days, bucketed by week with a running total.

Each customer's credit limit against current balance plus open sales-order value, flagging who is over limit.

A single aggregate over delivery notes — count, total value, min, max, and the date range.

Revenue minus cost of goods per item, by month — which products actually make money.

For each item with open sales-order demand, how much is ordered versus how much stock is on hand.

Average days from a sales order being created to its invoice being paid, per customer.

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

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

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

Revenue per year with the year-over-year growth % and a YTD-vs-last-year comparison, from posted A/R invoices.

For each item, how many days the current on-hand quantity lasts at the recent average daily sales rate.

The open sales orders sitting unfulfilled too long — the aging backlog.

For each item, how much open sales-order demand is NOT covered by current stock plus open purchase orders.

Lists the SAP pre-registered Named SQL Queries (codes starting mcp-) — the analytics and reporting queries you can run against the live system.

Total value of on-hand stock, valued at each item's cost price and rolled up by item group.

Booked sales-order value and order count, grouped by month or quarter — a bookings view.

Runs a SAP pre-registered Named SQL Query by its mcp- code and returns the result rows.