Overdue Invoices Status

This component helps to analyze the overdue invoices. It calculates:
1. the due date of an invoice
2. number of days till the due date from today (or any other selected date)
3. the due status of the invoice as defined by the following categories:
%%00009• Paid
%%00009• Pending
%%00009• Due during next 30 days
%%00009• 1-30 Days overdue
%%00009• 30-45 Days overdue
%%00009• 45-60 Days overdue
%%00009• 60-90 Days overdue
%%00009• 90+ Days overdue

Options

Payment date
A column that contains the date when an invoice was paid. In case the input table includes only pending invoices, please select "Not available".
Issue date
A column that contains the date when an invoice was issued.
Payment terms
An integer column that contains the number of days during which the payment should be made.
Current date (or the date of interest)
Type in the date for which the days till the due date should be calculated.

Input Ports

Icon
Input table containing the issue date and payment terms columns and optionally a payment date column

Output Ports

Icon
Output table containing the original table and the appended Planned date of payment, Due from today, and Due status columns

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2021-02-19
Last update: 2024-04-27
Created with KNIME version: v4.3.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!