prasad@leowise.com
8904448717
2 TIER SOLUTION
Frontend | Middleware | Backend | InterfaceWith |
---|---|---|---|
MS Access | MS SQL Server | MS Excel, MS Outlook |
The Park Document Automation is an application designed to streamline the processing of invoices by automating their digitization, integration into SAP, and subsequent handling within the OmniFlow system. Key features include:
Invoice Digitization and Data Entry:
Provides a user-friendly front-end interface for manual data entry and attachment of documents, ensuring accurate digitization of invoices.
Changes the record status to "READY FOR SAP" upon completion of data entry.
Automated SAP Integration:
Generates CSV files in SAP upload format and sends them via email to designated recipients at scheduled intervals (e.g., 8:30 AM, every 60 minutes, or every 100 transactions).
Updates the record status to "SENT TO SAP" after email dispatch.
Allows users to upload the CSV file into SAP for document creation and download reports from SAP.
Provides functionality for reverse upload of SAP reports into the tool, updating the status to "READY FOR OMNI."
OmniFlow System Integration:
Automatically creates CSV files in Predetermined format and copies them to a predefined folder on the OmniFlow server.
Copies invoice copies and supporting documents to designated folders on the OmniFlow server.
Updates the record status to "SENT TO OMNI" upon successful file transfer.
Tracking and Validation:
Periodically queries the system using a unique ID to verify if a VP (Vendor Payment) has been created, updating the line item with the VP number and changing the status to "VP CREATED."
Identifies duplicates where a VP is not created in OmniFlow and generates a daily report sent to designated email addresses for necessary cancellation or reversal in SAP.
This application enhances efficiency by reducing manual intervention, ensuring timely processing of invoices, and maintaining accurate tracking throughout the invoice lifecycle.