FlowRunner
Features Pricing
Theme
Start Free

Daily AP health check from Acumatica in Slack

Each morning this flow posts your payables picture from Acumatica to Slack, with total open AP, the bills due this week and every vendor with an overdue balance.

The prompt

Every morning, pull the AP aging balance and the open bills from Acumatica, and post a summary to our finance channel in Slack with total open payables, the bills due in the next 7 days, and each vendor with an overdue balance.

FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.

The flow

Code Write the dailysummary Action Post the summaryto finance Action Get the APbalance Action List open bills

Download the file, then in FlowRunner click + beside Flows, pick it under Import a Flow Version and click Create. How importing works

What each step does

  1. Get the AP balance Runs the AP aging summary report in Acumatica for all vendors.
  2. List open bills Lists every open bill with its vendor, invoice number, due date and balance.
  3. Write the daily summary Adds up total open payables, lists the bills due in the next 7 days, and groups overdue bills by vendor with the amount and the oldest due date.
  4. Post the summary to finance Posts the summary to your finance channel in Slack, so the team starts the day knowing what is due and what is late.

Before you turn it on

  • Enter your Acumatica instance URL, API username and password, and connect your Slack account.
  • Pick your finance channel in the Slack step.
  • Set the flow's schedule to the time you want the summary each morning.