Automate Vendor Invoice Validation in Qntrl Using Outbound REST API Integration | Qntrl Online Help | Web Services Online Help

Business Case: Automating Vendor Invoice Validation with External ERP

Scenario  

A company is looking to simplify and automate its vendor invoice processing. The finance team receives invoices from various vendors daily.  Each time a new invoice is submitted in Qntrl, the system needs to validate invoice must be validated against the company's ERP system to ensure:
  • The vendor is registered and active.
  • The invoice amount matches the purchase order.
  • No duplicate invoice has been submitted.
 

How it works 

With Outbound REST Web Services, Qntrl can automatically validate vendor invoices by connecting to the company’s ERP system via REST APIs.
When an invoice is submitted through a form in Qntrl:
  1. A custom script (Codex) is triggered to send invoice data to the ERP.
  2. The ERP checks the data against existing records.
  3. A response is returned indicating whether the invoice is valid, duplicate, or needs review.

Business Impact  

  • Reduced Errors: Automated validation eliminates manual entry mistakes.
  • Faster Processing: Invoices are validated in real-time.
  • Improved Compliance: Ensures all invoices meet internal and external audit requirements.
  • Scalability: Handles high volumes of invoices without additional manpower.

 

Steps to Configure Outbound REST API in Qntrl   

Create a new API

  • Navigate to (settings) >> WEB SERVICES >> Outbound >> Click REST.
  • Create a new API:
{
  "vendor_id": "{{vendorId}}",
  "invoice_number": "{{invoiceNumber}}",
  "amount": "{{amount}}"
}


    Create Pre Script (Optional)  

    Add a Pre Script to auto-generate a tracking ID or transform any input before sending.

    function beforeSend() {
        webservice.outboundREST.addHeader("x-tracking-id", "validate-" + Date.now());
    }


    Response Parser Setup  

    • Use JSON path to extract:
      • status
      • reason
      • validated_amount These can be reused in workflows or decision logic.

    Execute in Codex

    Trigger the API from a blueprint transition or business rule:

    let requestData = {
      vendorId: "V123",
      invoiceNumber: "INV56789",
      amount: "1200"
    };
    let result = OutboundREST.executeByName("ValidateVendorInvoice", requestData);
    console.log(result);

      • Related Articles

      • Business Case: Automating Order Management

        Scenario Consider a retail company that uses Qntrl to manage its order fulfillment process. The company has an external e-commerce platform that receives orders from customers and needs to integrate with Qntrl to process these orders automatically. ...
      • Business Case: Automate Card Creation via External CRM

        Scenario A company uses an external CRM (like Zoho CRM or Salesforce) to collect leads. Whenever a lead qualifies, the CRM needs to automatically create a task card in Qntrl's process management system to trigger internal follow-up actions. Instead ...
      • Business Case: Integrating Order Shipment Tracking with an External Carrier API

        Scenario A logistics company, QuickShip, provides real-time shipment tracking services. An ecommerce platform, Cell Retail, integrates with QuickShip’s SOAP-based tracking API using Qntrl’s Outbound SOAP Web Services. How it Works Whenever an order ...
      • Business case 1: Use client scripts to perform mathematical calculations and validations on data

        While designing forms to replicate finance related documents like purchase order, invoice, or reimbursement bills, our workflows might require the calculation of total cost or sum of expenses incurred. To automate such mathematical calculations and ...
      • Manage Business Rules

        What is a business rule? A business rule helps you trigger an event or a chain of automated events, when a defined action occurs in a card. For example, when a card's assignee field is updated, you might want to change the card's supervisor field ...

      You are currently viewing the help articles of Qntrl 3.0. If you are still using our older version and require guidance with it, Click here.