Icon

SAP_​002_​AR-Aging

🎯 Technical Objective

To automate the creation of an AR aging report by calculating "Days Outstanding" and categorizing balances into aging buckets, filtering to show only clients with outstanding amounts.

🛠️ KNIME Nodes to Use

  • CSV Reader

  • String to Date&Time

  • Date&Time Shift

  • Create Date&Time Range

  • Cross Joiner

  • Date&Time Difference

  • Rule Engine

  • Pivot

  • Column Filter

  • Column Resorter

  • Missing Value

  • Rule-based Row Filter

  • Excel Writer (Optional, for output)

Nodes

  • No nodes found

Extensions

  • No modules found

Links