// Template · Finance

Odoo Overdue Invoices Alert

Reads overdue customer invoices from Odoo daily, filters by a configurable threshold, and sends a formatted summary to your team's chat channel — so finance always knows what needs chasing, without opening Odoo.

Uses

Odoo Input Chat

Chat

Finance ERP Alerting 8 transforms + 1 workflow Apache Hop

Download .zip

Apache Hop pipeline
Created Jan 23, 2026
Putki 2026.03+

Pipeline

Putki

read-overdue-invoices

OdooInput

get-days-threshold

GetVariable

calculate-days-overdue

ScriptValueMod

filter-by-threshold

FilterRows

sort-by-days-overdue

SortRows

format-message-line

ScriptValueMod

build-summary-message

MemoryGroupBy

chat-slack-notifications.hwf

WorkflowExecutor

How it works

This template runs daily and sends your finance team a formatted list of overdue customer invoices — directly to Slack, Teams, or any chat channel — before anyone has to open Odoo. Configure the overdue threshold, point it at your webhook, and it runs on autopilot.

Read overdue invoices from Odoo

The Putki Odoo Input plugin reads all posted customer invoices from account.move where the due date has passed and payment is still outstanding — either not paid or only partially paid.

Calculate days overdue and filter

For each invoice, the pipeline computes how many days past due it is. Invoices below the configured threshold (default: 30 days) are discarded. The rest are sorted from most to least overdue.

Build the alert message

Each invoice is formatted as a single line — invoice number, customer name, amount due, and days overdue. All lines are assembled into a single summary message with a header and total count.

Send to your chat channel

The pipeline calls chat-slack-notifications.hwf via a WorkflowExecutor, passing the assembled message as a parameter. The workflow's Chat action posts it to your webhook — Slack, Teams, or Google Chat.

What you need

Putki subscription

Access to the Odoo Input and Chat plugins, both included in all Putki tiers.

Odoo API access

An Odoo user with read access to account.move, plus your database URL and API key.

A chat webhook URL

An incoming webhook from Slack, Microsoft Teams, or Google Chat. Create one in your workspace settings and paste the URL into the CHAT_WEBHOOK_URL pipeline parameter.