The RevRec Canvas
Book 13: Clearing the RAI monitor cover

Home › Close and reconciliation

Book 13 · Alteryx workflows for SAP RAR

Clearing the RAI monitor

Finding the order items that never reached RAR, the revenue accounting items that are stuck, and the order to work them in.

  • Close and reconciliation
  • Intermediate
  • 85 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

43 RAI issues ranked by age and amount, including order items that never reached RAR. Second workflow: a week later, what was cleared, what is still stuck, and what is new.

What you get

  • The ebook: an 85-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (13_RAI_Monitor.yxmd, 13b_Follow_Up.yxmd)
  • 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 1What never reached RAR
  2. Chapter 2The three files
  3. Chapter 3One cut-off, one key, one row per RAI
  4. Chapter 4Expected against actual
  5. Chapter 5Following the dependency
  6. Chapter 6One work list, two summaries
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9A week later
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 13: Clearing the RAI monitor table of contents
Contents
Book 13: Clearing the RAI monitor first page
First page