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
- Chapter 1When an invoice is corrected
- Chapter 2The five files
- Chapter 3The lines and four lookups
- Chapter 4Classify, then test each POB and period
- Chapter 5Period against inception to date
- Chapter 6Every line, every exception
- Chapter 7The profile and the control
- Chapter 8Reading the result
- Chapter 9Moving it to your system
- Chapter 10One position per contract
- Chapter 11Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


