Supplier invoice three-way match in Tripletex
When a supplier invoice is posted in Tripletex, this flow matches it to the order and the goods receipt, fixes the coding, and asks your approver in Slack.
The prompt
When a supplier invoice is posted in Tripletex, find the purchase order it belongs to and what was actually received against it. Compare the invoiced lines with the received quantities and the order prices, and work out any difference in money. If the invoice is coded to a different department or project than the order, move it to the order's. Then ask our approver in Slack, with Approve and Reject buttons, showing the match, the difference and the coding, and wait for the answer. If no purchase order is linked, tell the approver in Slack to review the invoice in Tripletex.
FlowRunner Prompt to Flow built this flow from that request. Here it is as it opens in the editor.
The flow
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
- New voucher in Tripletex Fires when a voucher is created in Tripletex. A supplier invoice is posted as a voucher, so this is the moment it arrives in the books.
- Find the supplier invoice Looks up the supplier invoice behind the voucher, with its lines and its cost postings. Other vouchers, such as a manual journal entry, stop here.
- Find the purchase order Finds the purchase order Tripletex has linked to the invoice. When there is none, the invoice number, supplier and amount go to the approver in Slack so they review it in Tripletex.
- Read the purchase order Reads the order lines and prices, and the department and project the order is coded to.
- Read what was received Reads the goods receipt lines, the quantities somebody actually received.
- Match invoice, order and receipt An AI agent compares each invoiced line with the order and the quantity received, and prices any gap. It also checks the cost postings against the order's department and project, and the flow moves any cost coded elsewhere to the order's department and project.
- Ask the approver Posts the match to the approver in Slack with the supplier, amount, due date, order number, the lines that differ and any coding change. Clean matches are asked too, because approving is what makes the invoice payable.
- Wait for the approver's answer The run waits for the click. Approve approves the invoice in Tripletex with a note that it was approved in Slack after the match, and Reject rejects it with the line differences in the comment.
Before you turn it on
- Enter the employee token for your Tripletex account. An administrator creates it under API access, and the employee needs the right to approve supplier invoices and change their coding.
- Connect your Slack account and pick the approver's channel in Ask the approver and Flag an invoice with no order.
- Add your Anthropic key in the flow setting Anthropic key.
- Copy the URL of the block Wait for the approver's answer into the flow setting Answer link. The Slack buttons open it.