Project Overview
Challenge
Traditional payment recording was manual and time-consuming with frequent errors, requiring staff to check payment slips and manually enter data into the ERP system.
Solution
We developed an automated system that generates QR codes for customer scanning, receives slips via LINE Bot, uses SlipOK for verification, then automatically updates ERP data.
Results
The result was a 90% reduction in payment recording time with no manual data entry errors, and customers were satisfied seeing payment status immediately.
System Workflow
The Auto Record Payment system follows a 6-step automated process:
Generate QR Code Payment
ERP system generates QR Code for customer scanning
When there's an invoice, the system creates a QR Code with complete information like amount and reference number according to Thai QR Payment standards.
Zoho Books + Firebase Cloud FunctionsCustomer Scans and Pays
Customer scans QR and pays through banking app
Customer opens mobile banking app, scans the QR Code, and confirms payment according to the specified amount.
Banking App + QR ScannerSend Slip to Bot
Customer or staff sends slip to LINE Bot
After payment completion, take a photo of the payment slip and send it to the company's LINE Official Account.
LINE OA BotBot Receives and Processes Slip
LINE Bot receives slip image for processing
When LINE Bot receives the slip image, it forwards it to the verification system to check authenticity and read slip data.
LINE API + WebhookSlipOK Verifies Slip
SlipOK system verifies slip authenticity
Uses SlipOK API to read slip data, verify if it's a genuine slip, and extract transfer information.
SlipOK APIUpdate ERP System
ERP system automatically updates payment status
After verification is complete, the system automatically updates payment status in the ERP (Zoho Books) invoice.
Zoho Books APITechnologies Used
ERP System
Payment System
Communication
Cloud System
Verification
Key Features
Generate QR Payment Automatically
System generates QR Code for customers to pay according to invoices
LINE Bot Integration
Customers can send slips through LINE easily
Automatic Slip Verification
Uses SlipOK API to read slip data and verify authenticity
ERP System Update
System immediately updates payment status in Zoho Books
Error Management
Has automatic error checking and problem notification system
Work History Recording
Keeps complete work history for verification