Icon

SAP_​002_​AR-Aging_​Solution

🎯 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)

Solution:

CSV Reader
Create Date&Time Range
Cross Joiner
Date&Time Difference
String to Date&Time
Date&Time Shift
Pivot
Rule Engine
Missing Value
Rule-based Row Filter
Column Filter
Column Resorter

Nodes

Extensions

Links