The RevRec Canvas
Book 9: Finding the root order cover

Home › Contracts and obligations

Book 9 · Alteryx workflows for SAP RAR

Finding the root order

Tracing every RAR revenue line up the SD document flow, through renewals, invoices and credit memos, to the order that started it, with an iterative macro that knows when to stop.

  • Contracts and obligations
  • Advanced
  • 89 pages
  • Tested workflows and sample data
$49Individual license · Team of five $147
Buy this bookTry the free Book 2 sample

What the example shows

572 revenue lines traced through the document flow to 93 root orders. Second workflow: document families against RAR contracts, with combination candidates.

What you get

  • The ebook: an 89-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (09_Root_Order.yxmd, 09b_Family_Contracts.yxmd)
  • 1 batch macro
  • Synthetic sample data (5 files) and an answer key, so you can check every number
  • Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment

Contents

  1. Chapter 1Which order started this revenue?
  2. Chapter 2The four input files
  3. Chapter 3One key rule, and the starting frontier
  4. Chapter 4The iterative macro: one level per iteration
  5. Chapter 5The closure table and the lookups
  6. Chapter 6From GL line to item to root
  7. Chapter 7The family tree, the root summary and the control totals
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10One family, one contract?
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 9: Finding the root order table of contents
Contents
Book 9: Finding the root order first page
First page