The RevRec Canvas
Book 39: Invoices that don’t match cover

Home › Close and reconciliation

Book 39 · Alteryx workflows for SAP RAR

Invoices that don’t match

Every invoice line RAR holds, checked against the billing document and the POB master: one class per line, every failed test kept, the unmatched lines aged and sized, and a proof that no line was lost or doubled.

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

What the example shows

339 RAR invoice lines checked against billing. 17 don’t match, in six classes. Second workflow: a month later, the old worklist, the new one and the resolution log compared item by item.

What you get

  • The ebook: a 75-page PDF that walks through the workflow tool by tool
  • 2 tested Alteryx workflows (39_Unmatched_Invoices.yxmd, 39b_Worklist_Followup.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 1Invoices that don't match
  2. Chapter 2The four files
  3. Chapter 3The invoice lines
  4. Chapter 4Billing and the POB master
  5. Chapter 5The lookups and the classification
  6. Chapter 6The outputs and the control
  7. Chapter 7Reading the result
  8. Chapter 8Moving it to your system
  9. Chapter 9A month later: what got fixed?
  10. Chapter 10Exercises
  11. Appendix ATool-by-tool settings
  12. Appendix BOutput field dictionary
  13. Appendix CAnswer key

Look inside

Book 39: Invoices that don’t match table of contents
Contents
Book 39: Invoices that don’t match first page
First page