The RevRec Canvas
Book 36: Testing invoice corrections cover

Home › Contracts and obligations

Book 36 · Alteryx workflows for SAP RAR

Testing invoice corrections

Every invoice-correction line tested against the accounts it may touch, every POB and period tested for a zero net, the period read against inception to date, and a control that proves no line was lost or doubled on the way.

  • Contracts and obligations
  • Intermediate
  • 77 pages
  • Tested workflows and sample data
$39Individual license · Team of five $117
Buy this bookTry the free Book 2 sample

What the example shows

252 invoice-correction lines tested, including a leg on a revenue account and pairs split across periods. A second workflow presents one net position per contract and tests the netting entry: one contract not netted, one netted from last month.

What you get

  • The ebook: a 77-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (36_Invoice_Corrections.yxmd, 36b_Contract_Position.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 1When an invoice is corrected
  2. Chapter 2The five files
  3. Chapter 3The lines and four lookups
  4. Chapter 4Classify, then test each POB and period
  5. Chapter 5Period against inception to date
  6. Chapter 6Every line, every exception
  7. Chapter 7The profile and the control
  8. Chapter 8Reading the result
  9. Chapter 9Moving it to your system
  10. Chapter 10One position per contract
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 36: Testing invoice corrections table of contents
Contents
Book 36: Testing invoice corrections first page
First page