The RevRec Canvas
Book 5: Checking SSP allocation across every contract cover

Home › Contracts and obligations

Book 5 · Alteryx workflows for SAP RAR

Checking SSP allocation across every contract

Recalculating the relative standalone selling price allocation for every contract, independently of RAR, and comparing the two to the cent.

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

What the example shows

219 POBs reallocated to the cent, including a stale price list, freight and a missing SSP. A second workflow measures what an SSP tolerance policy would change: contracts still reallocated, the amount left on the wrong POB and the effect on timing.

What you get

  • The ebook: a 69-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (05_SSP_Allocation_Check.yxmd, 05b_SSP_Tolerance_Sensitivity.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 1Is the price split the way the standard says?
  2. Chapter 2The three files
  3. Chapter 3The SSP valid at inception
  4. Chapter 4The pool and the relative share
  5. Chapter 5The rounding cent, and the comparison
  6. Chapter 6Four outputs
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9How much does a tolerance change?
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 5: Checking SSP allocation across every contract table of contents
Contents
Book 5: Checking SSP allocation across every contract first page
First page