NORMA Tool ๐Ÿ“Š Report Customers Finance

get_order_to_cash_cycle โ€” Order-to-Cash Cycle

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

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

Order-to-cash-cycle report โ€” the average number of days from a sales order being created to its invoice being paid, per customer. Returns one row per customer with transaction_count (paid orderโ†’invoice chains) and avg_cycle_days, slowest payer first. A cycle-time metric: it walks the whole A/R chain (sales order โ†’ invoice โ†’ incoming payment). Only orders that were both invoiced and paid count.

Try these prompts

  • “show me the order-to-cash cycle time”
  • “how long does Acme take to pay?”
  • “which customers are slowest to pay?”
  • “order-to-cash for C001”

ื ืกื• ื’ื ื‘ืขื‘ืจื™ืช

  • “ื›ืžื” ื–ืžืŸ ืœื•ืงื— ืœื’ื‘ื•ืช ืžืœืงื•ื—?”
  • “ืื™ืœื• ืœืงื•ื—ื•ืช ืžืฉืœืžื™ื ื”ื›ื™ ืœืื˜?”
  • “ืžื” ืžืฉืš ื”ืžื—ื–ื•ืจ ืžื”ื–ืžื ื” ืขื“ ืชืฉืœื•ื?”

Arguments

ArgRequiredMeaning
card_codeoptionalOne customer, e.g. C001. Omit for all customers.

Example result

Beta Industries is your slowest payer. C002 Beta Industries โ€” 58 avg cycle days across 6 chains. C001 Acme Corp โ€” 34 avg cycle days across 11 chains.

Result columns

ColumnTypeMeaning
card_codetextThe customer’s SAP code.
card_nametextThe customer’s name.
transaction_countnumberHow many completed order โ†’ invoice โ†’ payment chains the average is drawn from.
avg_cycle_daysnumberAverage days from the order being placed to its invoice being paid.

Charts

  • bar: x=card_name, y=avg_cycle_days, title=“Days to get paid”
  • get_ar_aging โ€” a snapshot of what is currently owed and how overdue (not payment speed).