The RevRec Canvas
Book 15: Foreign currency in RAR cover

Home › Contracts and obligations

Book 15 · Alteryx workflows for SAP RAR

Foreign currency in RAR

Recomputing every local-currency amount from the rate table, naming the cause of each difference, and following the FX difference on the contract liability.

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

What the example shows

635 lines retranslated. Rates the wrong way round, wrong rate types and rounding errors found. Second workflow: the contract liability at the close, checked for revaluation currency by currency.

What you get

  • The ebook: an 82-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (15_Foreign_Currency.yxmd, 15b_CL_Not_Revalued.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 1Two currencies on every line
  2. Chapter 2The six files
  3. Chapter 3A rate table that works both ways round
  4. Chapter 4One stream of lines
  5. Chapter 5Every candidate rate in one lookup
  6. Chapter 6Recompute, and name the cause
  7. Chapter 7The FX difference on the contract liability
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10The liability is not revalued
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 15: Foreign currency in RAR table of contents
Contents
Book 15: Foreign currency in RAR first page
First page