The RevRec Canvas
Book 47: Proving a discount: from the order to the ledger cover

Home › Close and reconciliation

Book 47 · Alteryx workflows for SAP RAR

Proving a discount: from the order to the ledger

From the order to the ledger. Put an item's gross and discount lines back together, tie them to the billing, check every rate against a written policy, and explain the one line an auditor picked.

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

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

  1. Chapter 1A discount is three numbers
  2. Chapter 2The data
  3. Chapter 3Grouping the ledger
  4. Chapter 4The order's pricing and the policy
  5. Chapter 5Tying every billed item
  6. Chapter 6Seven rules
  7. Chapter 7Proving an audit selection
  8. Chapter 8The control
  9. Chapter 9Moving it to your system
  10. Chapter 10Was the discount allowed?
  11. Chapter 11Exercises
  12. Appendix ATool-by-tool settings
  13. Appendix BOutput field dictionary
  14. Appendix CAnswer key

Look inside

Book 47: Proving a discount: from the order to the ledger table of contents
Contents
Book 47: Proving a discount: from the order to the ledger first page
First page