The RevRec Canvas
Book 4: Contract and POB extracts, no VLOOKUP cover

Home › Contracts and obligations

Book 4 · Alteryx workflows for SAP RAR

Contract and POB extracts, no VLOOKUP

Turning an auditor's list of sales documents into a complete POB extract, with every request line accounted for and every contract checked.

  • Contracts and obligations
  • Beginner
  • 83 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

Messy order requests matched to contracts and POBs across both company codes. A second workflow compares it with a re-extract three months later and explains every difference.

What you get

  • The ebook: an 83-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (04_Contract_and_POB_Extract.yxmd, 04b_Extract_Comparison.yxmd)
  • Synthetic sample data (7 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 1The audit request
  2. Chapter 2The five files
  3. Chapter 3Cleaning the request, finding it in RAR
  4. Chapter 4The POBs and their revenue to date
  5. Chapter 5The extract and the contract summary
  6. Chapter 6Every request line accounted for
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9What changed by P09
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 4: Contract and POB extracts, no VLOOKUP table of contents
Contents
Book 4: Contract and POB extracts, no VLOOKUP first page
First page