Hub
ComponentComponent

Overdue Invoices Status

Last edited: 

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: • Paid • Pending • Due during next 30 days • 1-30 Days overdue • 30-45 Days overdue • 45-60 Days overdue • 60-90 Days overdue • 90+ Days overdue

Component details

Input ports
  1. Type: Table
    0
    Input table containing the issue date and payment terms columns and optionally a payment date column
Output ports
  1. Type: Table
    Output table
    Output table containing the original table and the appended Planned date of payment, Due from today, and Due status columns