280 likes | 444 Views
Accounts Payable Automation using Document Management and Workflow presented by Paul Kiefer & Ken Cleary. March 18th, 2008. QAD REAL SOLUTIONS. Project Overview: Streamline A/P Process Company Overview Multiple Site Manufacturing Company Automotive Supplier Centralized A/P Department
E N D
Accounts Payable Automation usingDocument Management and Workflowpresented byPaul Kiefer&Ken Cleary March 18th, 2008
QAD REAL SOLUTIONS • Project Overview: Streamline A/P Process • Company Overview • Multiple Site Manufacturing Company • Automotive Supplier • Centralized A/P Department • Separate MFG/PRO Databases (Version eB)
QAD REAL SOLUTIONS • Project Overview (continued) • Project Drivers • Central Consolidation of 5 A/P Departments • Staff Reduction • A/P Process – “Past Due” • Daily Paper Chase • Painful Manual Process • Racks & Racks of Paper Document Storage
QAD REAL SOLUTIONS • Project Overview (continued) • Objectives and Goals • Handling Paper Documents one time only • Reduce Paper Storage Requirement • Automate Invoice Process – Exceptions only • Maintain Minimal Staffing • Maintain “Current” A/P Process
QAD REAL SOLUTIONS • Presentation Overview • Detailed Solution Review • Implementation Process • Live Demonstration • Other Applications • Questions/Answers
QAD REAL SOLUTIONS • Solution Overview • Packing Slip / Receiver Capture • Invoice Document Capture • MFG/PRO Data Capture • Invoice Processing • Initial Workflow Process • Auto Match • Exception Processing • Exception Vouchering • Invoice Completion • Check Processing • Other Features
QAD REAL SOLUTIONS • Technical Solutions Applied • OnBase Software by Hyland Corp. • Teleform by Cardiff Software • SIGConnects by SIG • ImageSoft Technical Services (OnBase Integrator)
QAD REAL SOLUTIONS • PACKING SLIP / RECEIVER PROCESS • Former Process • Each location receives in MFG/PRO (5.13.1) • Packing Slip documents mailed to central A/P Dept. • Central A/P receives paper documents and sorts by location and by vendor • Paper documents filed, then moved to storage • Manual “hunting” for packing slips when required
QAD REAL SOLUTIONS • PACKING SLIP / RECEIVER PROCESS • New Process • Each location receives into MFG/PRO (5.13.1) • Packing Slip scanned and receiver number captured from MFG/PRO – Document image sent to OnBase • OnBase lookup to MFG/PRO to retrieve receiver information: PO Number, Vendor, Date, etc. • Packing Slip paper retention minimal • Exception Report of Packing Slips not in OnBase
QAD REAL SOLUTIONS • PACKING SLIP / RECEIVER PROCESS • Benefits • Online lookup of receiving documents – immediately available • Significantly reduce paper handling & mailing costs • Minimal document storage requirements • Eliminate the cases of lost & misplaced paperwork
QAD REAL SOLUTIONS • Invoice Capture • Former Process • Receive invoices – mail (90%), email, EDI • Manually sort invoices by location & type and deliver to A/P • A/P processes the invoices • Upon completion, sort invoices by location and voucher number • File by location, move to long term storage
QAD REAL SOLUTIONS • Invoice Capture • New Process • Receive Invoices – Mail, Email, EDI • Capture Invoices from Email • Scan Invoices into OnBase/OCR • Begin Automation Process • File for short period - discard
QAD REAL SOLUTIONS • MFG/PRO Data Import to OnBase • Purchase Orders • Daily Update into OnBase • Form Overlay for Display • Open Receiver Line Items • Invoice Vouchers Processed
QAD REAL SOLUTIONS • Invoice Processing • Former Process • Manual Review of Invoice and MFG/PRO Report of Open Receivers • Email Invoice for Review/Approval, if Required • Invoice Discrepancy Review - P.O., Receiver/Packing Slip, Invoice • Manual Entry of Invoice into MFG/PRO Voucher Maint (28.1) • Vendor Inquiries – Paper Retrieval from Files • File Invoice
QAD REAL SOLUTIONS • Invoice Processing • New Process • Scan of Invoice Initiates Workflow Process in OnBase • Auto Match of PO in OnBase from MFG/PRO Import • Auto Match of Packing Slip in OnBase • Route to exception queue if supporting documents are not found after brief period • Automatic Match of Invoice and Receiver for payment • Variance Rules for Match • Outside of variance – Exception queue for review • Coding and tracking of exception reasons • Auto creation of MFG/PRO voucher (28.1)
QAD REAL SOLUTIONS • Invoice Processing • Exception Processing Actions • Route to inventory & non-inventory queues • Review invoice for exception • Exception reasons • Route to department for review/approval – single or multiple approvers • Put on hold with email notification and automatic routing after hold time expires • Temporary or permanent rejection of invoices from processing
QAD REAL SOLUTIONS • Invoice Processing • Exception Vouchering • Display invoice and all related documents in OnBase • List all open receivers from MFG/PRO, line items, amounts and project numbers • Selection of open MFG/PRO receivers to voucher with invoice • Create voucher GL distributions for Misc items (tax, freight, discrepancies) • Create debit memo with option to email to vendor • Create voucher transaction for import to MFG/PRO
QAD REAL SOLUTIONS • Invoice Processing • Invoice Completion • Voucher # created in MFG/PRO sent back to OnBase • OnBase matches invoice and voucher to clear invoice • Exception processing for missing vouchers • Check Processing • MFG/PRO check run and print • MFG/PRO check register passed to OnBase • Check number matched to invoice • Cancelled check image from bank into OnBase
QAD REAL SOLUTIONS • Other Features • OnBase Application Enabler • Allows for initiating document lookup and viewing right within MFG/PRO interface • Document Retrieval/Lookup in OnBase • All related documents accessed from single piece of information • Purchase order • Packing slip • Invoice • Voucher • Appropriation request • Payment information • Canceled check image
QAD REAL SOLUTIONS • Implementation Process • Upgrade OnBase • Launch packing slip process • Launch invoice scan/OCR process • Import PO’s into OnBase from MFG/PRO • Using OnBase documents - Manual load of MFG/PRO vouchers (interim process) • Launch Automatic Voucher update to MFG/PRO (28.1) • Implement Automatic Match Process • Large Supplier Integration (email/EDI)
QAD REAL SOLUTIONS • Other Applications • Capital Expenditure Requests • Non Funded Project Requests • Customer Purchase Orders • Shipping Order Slips – Logistics • Material Inspection Requests
ImageSoft Live Demonstration
ImageSoft Questions/Answers
Thank You ! www.imagesoftinc.com