The RevRec Canvas
Book 10: The allocation effect, proved cover

Home › Contracts and obligations

Book 10 · Alteryx workflows for SAP RAR

The allocation effect, proved

Proving RAR's allocation from a second table: the deferral items that carry the allocation difference, tied to their own control, rebuilt to the contractual price and netted to zero by contract.

  • 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

166 POBs rebuilt from deferral items, and a 250.00 manual shift found in a contract that still nets to zero. Second workflow: the effect rolled forward a month, with a check that closed periods did not change.

What you get

  • The ebook: an 83-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (10_Allocation_Effect.yxmd, 10b_Effect_Rollforward.yxmd)
  • Synthetic sample data (3 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 allocation moved, and the proof
  2. Chapter 2The two files
  3. Chapter 3Cleaning the deferral items
  4. Chapter 4The delta sum and the control
  5. Chapter 5The SSP allocation, rebuilt
  6. Chapter 6Four proofs, three outputs
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9A month later
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 10: The allocation effect, proved table of contents
Contents
Book 10: The allocation effect, proved first page
First page