What the example shows
106 billed items and 151 ledger lines, posted gross and discount or net. A discount line posted 10.00 short, an item never posted, a 30% rate the policy does not allow and a free copy outside a kit, plus seven audit selections each proved in one sentence. A second workflow checks every discount against an approval matrix.
What you get
- The ebook: a 93-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (47_Discount_Proof.yxmd, 47b_Discount_Approvals.yxmd)
- Synthetic sample data (9 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 1A discount is three numbers
- Chapter 2The data
- Chapter 3Grouping the ledger
- Chapter 4The order's pricing and the policy
- Chapter 5Tying every billed item
- Chapter 6Seven rules
- Chapter 7Proving an audit selection
- Chapter 8The control
- Chapter 9Moving it to your system
- Chapter 10Was the discount allowed?
- Chapter 11Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


