FlowRunner
Features Pricing
Theme
Start Free

Parsed vendor invoice to AP bill in Acumatica

Parseur reads each vendor invoice. This flow checks the vendor and looks for a duplicate in Acumatica, creates the bill on hold with the PDF attached, and tells AP in Slack.

The prompt

When Parseur finishes reading a vendor invoice from our AP mailbox, find the vendor in Acumatica by name and make sure it's active, and check that the invoice number hasn't already been entered as a bill. If both checks pass, create the bill in Acumatica on hold with the invoice lines, attach the original PDF, and post the new bill to our accounts payable channel in Slack. If the vendor is missing or inactive, or the invoice is already in Acumatica, send it to the same Slack channel with the reason instead.

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

The flow

Yes No Yes No Condition Vendor on file? Action Check for aduplicate bill Action Create the bill inAcumatica Action Send the invoiceto AP Starts the flow Invoice parsed inParseur Action Find the vendor inAcumatica Action Attach the invoicePDF Action Validate thevendor Condition Active vendor andnew invoice? Code Write the note for AP Code Build the bill lines Action Post the new billto AP

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. Invoice parsed in Parseur Starts the run when Parseur finishes reading an invoice in your vendor invoice mailbox. It brings the vendor name, invoice number, dates, total, line items and a link to the original PDF.
  2. Find the vendor in Acumatica Looks up the vendor by the name printed on the invoice. When Acumatica has no vendor by that name, the invoice goes to AP in Slack instead.
  3. Check for a duplicate bill Looks for a bill from this vendor that already carries the same invoice number.
  4. Active vendor and new invoice? An active vendor with no earlier bill for this invoice moves on to bill entry. Anything else goes to AP in Slack.
  5. Create the bill in Acumatica Creates the AP bill on hold for the vendor, with the invoice number, invoice date, due date and the invoice lines. An invoice without readable lines becomes one line for the total, and Acumatica fills in the expense account from the vendor's defaults.
  6. Attach the invoice PDF Attaches the original invoice PDF to the new bill.
  7. Post the new bill to AP Tells AP in Slack that the bill is in Acumatica and waiting on hold for approval, with the vendor, invoice number, amount and due date.
  8. Send the invoice to AP When an invoice stays out of Acumatica, posts the reason to AP in Slack: no vendor by that name, a vendor that is not active, or a bill that already has this invoice number. A link to the invoice lets someone handle it by hand.

Before you turn it on

  • Enter your Acumatica instance URL, API username and password, and your Parseur API key, and connect your Slack account.
  • In the Parseur mailbox for vendor invoices, name the fields VendorName, InvoiceNumber, InvoiceDate, DueDate and Total, add a table field LineItems with the columns Description, Quantity, UnitPrice and Amount, and turn on the OriginalDocument metadata field.
  • Pick that mailbox in the block Invoice parsed in Parseur.
  • Pick your accounts payable channel in the two Slack steps.