The Kodaris lockbox feature addresses the challenge of efficiently transferring customer payment data from the Kodaris payment portal to an ERP system. When customers make payments through Kodaris, these transactions need to be properly recorded in the ERP system to update customer accounts. Without automation, this would require manual entry and reconciliation.
The lockbox solution establishes an automated file transfer process between the two systems. Once configured, the Kodaris system generates and posts a lockbox file to the ERP nightly, containing all payment transactions made throughout the day. The ERP's standard lockbox processing then automatically applies these payments to the appropriate customer accounts.
This integration eliminates the need for manual payment application, reduces errors, and ensures timely updating of financial records. Configuration options include selecting the appropriate file format (EDI 820, EDI 823, XML), scheduling, defining upload methods (file transfer or SFTP), and specifying file parameters. The Kodaris system also supports multi-site configurations and provides testing capabilities to verify proper functionality.
Topics Covered:
Purpose and benefits of the lockbox configuration in Kodaris
Step-by-step configuration
Batch out settings including scheduling and file format options
Upload method options (file transfer and SFTP)
Configuration of lockbox file names, numbers, and routing information
GL journal management
Multi-site lockbox configuration options
Manual testing of the batch out process
Viewing and monitoring batch out history
Troubleshooting batch out processes
Steps to Configure a Lockbox in Kodaris
First, set up the lockbox in your ERP system
In Kodaris, navigate to the Accounts Receivable section and select "Lockbox"
On the Configuration screen:
Set "Enable batch out" to "yes" (update only after complete configuration in Kodaris)
Choose the batch out hour (UTC time)
Select the batch out method (EDI820, EDI823XML, API, etc.)
Decide whether to close GL journals automatically (yes or no)
For multiple web sites in multi-site mode, choose whether to enable batch out per host
Select lockbox upload method (File transfer or SFTP)
Enter the lockbox file name
Enter the lockbox number
Enter the routing number
To test your configuration before enabling automatic processing:
Make a payment through the payment portal
Use the manual batch out trigger button
Configure the test options before triggering a batch out:
Set "Mark as exported" (yes or no)
Choose whether to include already exported data
Select export format
Set date range for payments
For multiple web sites in multi-site mode, select specific host code if needed
Click "Submit" to trigger the batch out process
Verify the payment was correctly processed in your ERP system
Review the batch out history in Kodaris and preview the results
Once testing is successful, set "Enable batch out" to "yes" for automated daily processing
Product Documentation