The RevRec Canvas
Book 7: Batch macros for every company code cover

Home › Build kit

Book 7 · Alteryx workflows for SAP RAR

Batch macros for every company code

Turning one tested RAR-to-trial-balance tie-out into a batch macro that runs for every company on a control list, with policy kept outside the macro and nothing left unchecked.

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

What the example shows

One tie-out runs for each company, with tolerances in local currency and a coverage check. Second workflow: every company, every period of the quarter, with a folder check before the batch.

What you get

  • The ebook: a 78-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (07_Batch_Tieout_All_Companies.yxmd, 07b_Batch_by_Period.yxmd)
  • 2 batch macros
  • Synthetic sample data (15 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 1One tie-out, every company
  2. Chapter 2The control list and the data
  3. Chapter 3How a batch macro works
  4. Chapter 4Building the macro: the interface
  5. Chapter 5Building the macro: the tie-out
  6. Chapter 6The calling workflow: driving the batch
  7. Chapter 7Policy after the macro, and coverage
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10Every company, every period
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 7: Batch macros for every company code table of contents
Contents
Book 7: Batch macros for every company code first page
First page