Detect new invoices
The workflow checks ERPNext every 3 minutes for newly submitted Sales Invoices. Invoices without a customer are set aside.
LIVE WEBINAR · 18 NOV: Make your SAP Business One ready for Black Friday — live demo 18 November. Save my seat
Update the HubSpot company with each new ERPNext invoice and the customer's outstanding and overdue balances, keep a linked invoice record and alert Microsoft Teams at 30 days past due
Apps used in this template
About this template
Account managers in HubSpot rarely know what a customer has been billed or still owes, so they email finance before calls. This template checks ERPNext every 3 minutes for new submitted Sales Invoices, matches the customer to a HubSpot company by name, writes total outstanding and overdue balances to the company, keeps a linked HubSpot invoice record and sends a Microsoft Teams alert when the invoice is 30 or more days past due.
Key benefits
Inside the flow
Every 3 minutes, the workflow takes each new ERPNext Sales Invoice, finds the HubSpot company with the customer's name and totals the customer's outstanding and overdue balances across open invoices. It updates the company and the HubSpot invoice record, and sends a Microsoft Teams alert if the invoice is 30 or more days overdue.
The workflow checks ERPNext every 3 minutes for newly submitted Sales Invoices. Invoices without a customer are set aside.
It looks up the HubSpot company whose name matches the ERPNext customer. If none exists, it creates a ToDo in ERPNext against the invoice for follow-up.
For a matched customer, it totals the outstanding amount across all open ERPNext invoices and the part already past due.
The HubSpot company gets the latest payment status, the most recent invoice number and date, that invoice's outstanding amount, and the total outstanding and overdue balances.
It checks HubSpot for a record of this invoice. If one exists, it updates the total, due date, status and outstanding amount; if not, it creates the record and links it to the company.
If the invoice still has a balance and is 30 or more days past due, a Microsoft Teams message shares the customer, invoice number, outstanding amount and due date.
Billing position on every HubSpot account, kept current from ERPNext
01
Account managers see what each customer was billed and still owes on the company record, without leaving the CRM or emailing finance.
02
Reps know a customer's balance and overdue amount before they call, so they avoid pitching accounts already in collections.
03
Outstanding and overdue totals are calculated from all open ERPNext invoices, so the company record reflects the full position, not a single invoice.
04
A Microsoft Teams alert fires when an invoice reaches 30 days past due, giving teams time to engage the customer or escalate.
05
Each invoice is its own HubSpot record linked to the company, updated rather than duplicated when its status or balance changes.
01
Account managers see what each customer was billed and still owes on the company record, without leaving the CRM or emailing finance.
02
Reps know a customer's balance and overdue amount before they call, so they avoid pitching accounts already in collections.
03
Outstanding and overdue totals are calculated from all open ERPNext invoices, so the company record reflects the full position, not a single invoice.
04
A Microsoft Teams alert fires when an invoice reaches 30 days past due, giving teams time to engage the customer or escalate.
05
Each invoice is its own HubSpot record linked to the company, updated rather than duplicated when its status or balance changes.
Keep exploring
Every repetitive process between your ERP, CRM, and business apps has a template. Find yours, customize it, and go live today.
Customize the flow
Every trigger and action this template uses is available in the appse ai builder, so the same flow can be rebuilt with your own routing, thresholds and destinations.
Questions & answers
Everything you need to know about this template before you deploy it.
Discover how appse ai has helped businesses automate processes and achieve growth through our users' success stories.
Start free — no credit card, no setup calls required. Use this template as-is or customize every step inside the appse ai no-code builder and go live today.