Morning approval and release of bills on hold in Acumatica
Each morning this flow totals the bills on hold in Acumatica by vendor and asks your AP manager in Slack to release them all or review them one by one.
The prompt
Every morning at 9am, list the bills on hold in Acumatica, total them by vendor, and ask our AP manager in Slack whether to release all of them or review them one by one. If they pick release all, release every bill from hold and confirm in the Slack thread. If they want to review, post each bill in the thread with Release and Keep on hold buttons and wait for each answer. Release the approved bills and flag the ones kept on hold in the thread.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
Inside the loop: Release every bill
Inside the loop: Review bills one by one
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
- Find bills on hold Every morning, lists every bill in Acumatica that is on hold, with vendor, invoice number, amount and due date. When nothing is on hold, the run ends quietly.
- Ask the AP manager Posts the request to the AP manager in Slack: how many bills are waiting, what they add up to, and the total for each vendor, with two buttons, Release all and Review one by one.
- Wait for the AP manager's answer The run waits for the click.
- Release all? Release all takes every bill off hold in Acumatica, so they are ready for payment, and replies in the Slack thread with how many were released and their total. Review one by one walks the bills in the Slack thread.
- Review bills one by one Goes through the bills on hold one after another, waiting for an answer on each.
- Ask about the bill Posts one bill in the Slack thread with its vendor, invoice number, amount, due date and memo, and two buttons, Release and Keep on hold.
- Wait for the answer on the bill The run waits for the AP manager's click on that bill before moving to the next one.
- Release this bill? Release takes the bill off hold in Acumatica. Keep on hold leaves it there, and the thread notes that it stays on hold for review.
Before you turn it on
- Enter your Acumatica instance URL, API username and password, and connect your Slack account.
- Copy the URL of the block Wait for the AP manager's answer into the flow setting Answer link, and the URL of the block Wait for the answer on the bill into the flow setting Bill answer link. The Slack buttons open them.
- Pick your AP manager's Slack channel in the four Slack steps.
- Set the flow's schedule to 9 am every morning.