The RevRec Canvas
Book 17: Variable consideration and price adjustments cover

Home › Contracts and obligations

Book 17 · Alteryx workflows for SAP RAR

Variable consideration and price adjustments

Rebuilding the transaction price from the latest constrained estimates and the credit memos that change it, and proving that every change reached RAR, was reallocated by relative SSP and caught up in revenue.

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

What the example shows

Transaction prices rebuilt for 62 contracts, including a stale constraint and a mislabeled credit memo. A second workflow tracks what the constraint holds back, period by period, and what its release did to the price.

What you get

  • The ebook: an 83-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (17_Variable_Consideration.yxmd, 17b_Constraint_Tracker.yxmd)
  • Synthetic sample data (6 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 price that moves
  2. Chapter 2The five files
  3. Chapter 3The fixed price and the latest estimate
  4. Chapter 4Before the last update, and which memos count
  5. Chapter 5RAR's price and the diagnosis
  6. Chapter 6Reallocation and the catch-up
  7. Chapter 7One list of exceptions
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10What the constraint holds back
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 17: Variable consideration and price adjustments table of contents
Contents
Book 17: Variable consideration and price adjustments first page
First page