Oracle AR AutoLockbox Setup
Budget: $30 – $250 USD
I need my Oracle Receivables AutoLockbox fully configured so that every week I can drop an Excel file from our bank into a secure folder and have the receipts flow straight through to the AR interface without manual touch.
Scope
• Configure the entire AutoLockbox chain in Oracle E-Business Suite (receipt classes, transmission formats, import & validation programs, post-processing rules, and auto-reconciliation).
• Build/import the transmission format that matches the Oracle AR Interface requirements
• Must meet the validation requirements of the Autolock box program in Oracle Receivables
Acceptance criteria
– Upload of sample Excel file executes the three AutoLockbox phases (Import, Validation, Post QuickCash) without errors.
– All agreed validations trigger correctly and rejected receipts appear on the standard AutoLockbox Execution Report with the expected message.
– Receipts that pass post automatically to customer accounts and the GL distribution lines are created.
– Receipts are matched / applied as per criteria with the invoices
– Documentation and a brief hand-off session completed.
Oracle E-Business Suite R12 experience with Lockbox, SQL*Loader, and concurrent program tuning is essential. If you have implemented Excel-based lockboxes before, let me know—this will move quickly once we agree on the mapping.
Scope
• Configure the entire AutoLockbox chain in Oracle E-Business Suite (receipt classes, transmission formats, import & validation programs, post-processing rules, and auto-reconciliation).
• Build/import the transmission format that matches the Oracle AR Interface requirements
• Must meet the validation requirements of the Autolock box program in Oracle Receivables
Acceptance criteria
– Upload of sample Excel file executes the three AutoLockbox phases (Import, Validation, Post QuickCash) without errors.
– All agreed validations trigger correctly and rejected receipts appear on the standard AutoLockbox Execution Report with the expected message.
– Receipts that pass post automatically to customer accounts and the GL distribution lines are created.
– Receipts are matched / applied as per criteria with the invoices
– Documentation and a brief hand-off session completed.
Oracle E-Business Suite R12 experience with Lockbox, SQL*Loader, and concurrent program tuning is essential. If you have implemented Excel-based lockboxes before, let me know—this will move quickly once we agree on the mapping.