Icon

Invoice Monitoring Automated

<p><strong>Invoice Monitoring</strong><br></p><p>This workflow monitors invoices to identify account receivables and matches unpaid invoices with CRM data in order to follow up with the most critical customers.</p><ul><li><p>The workflow calculates the overdue invoices and their total amount, and joins the data with company internal data about the responsible persons for a specific customer and the customer credit rating.</p></li><li><p>Based on the sum of the due invoices as well as the customer credit rating, it automatically assigns actions to the sales department.</p></li><li><p>Finally, it presents a visual overview in a dashboard and stores receivables in a spreadsheet.</p></li></ul>

Databases

Reusable workflow

  • Plug in new data ➡ done!

  • No copy-pasting

  • No manual recreation of columns

  • No breaking formulas

  • No scripts or PowerQuery setups

Preparation

  • Filter

  • Sort

  • VLookup

Pivot

  • Aggregation

  • Visualizations

Reporting

Simple Functions

  • Expression

  • Date values

  • Renaming

Automation on KNIME Hub

  • 🕥 Schedule: execute at specific time

  • 📊 Data app: self-service execution


Note that some features of automation, collaboration and versioning are only available for some KNIME's paid plan.

Keep overdue
Nominal Value Row Filter
Total per manager
Row Aggregator
Report PDF Writer
Company database
SQLite Connector
Plot
Bar Chart
Lookup manager
Value Lookup
Group Loop Start
report_dd-mm-yyyy.pdf
Create file name
apply formattingto Customer ID
Expression
Read table
DB Reader
All invoices
Excel Reader
invoices Belgium
Excel Reader
Status
Expression
All invoices
Excel Reader
Date issued + Terms
Date Shifter
Sort descending
Sorter
Select managerstable
DB Table Selector
Date due
Column Renamer
Divide value by 1M
Expression
Report Template Creator
Sort by value
Sorter
Report Loop End
Component

Nodes

Extensions

Links