Friday, July 17, 2015

OPG-3 #14: How Do You Archive, Search & Retrieve Your Emails?


 
 
If I asked you to find an important email from three years ago, could you find it? And, how long would it take you to find it? Per your industry email compliance regulations, are you complaint? What would happen if you were sued? Could you find all the related eDiscovery documents and emails?  
 
For twenty eight years, managing storage of AP, AR, HR, Purchase orders, Quotes, Invoices, and other document types for easy search and retrieval has been a simple task for Laserfiche customers. By scanning paperwork, or by storing already digitized documents, Laserfiche customers have quick and easy access to their electronic documents. But, what about archiving your emails?
 
Although Microsoft Exchange will hold many GB’s of old emails, the searching capabilities are weak, and ponderous. So, why not use Laserfiche eFile from OPG-3 to store, search and retrieve archived emails instead?
 
Today, Customers are looking to Laserfiche to all of their electronic content.  We’ve introduced Laserfiche eFile to help meet this growing need to adhere to email compliance policies and long term storage needs without burdening already busy messaging systems.
 
 
Laserfiche eFile
Laserfiche eFile was designed as an email import agent for Laserfiche.  LF eFile can capture email from selected mailboxes based on content filtering rules.  These captured messages are then able to be stored securely in the Laserfiche repository.
 
This makes it possible to kick off business processes and workflows for important sales or service opportunities, process PTO requests, store images received from photo copiers email capability, or even simplify processing monthly expenses.
ARCHIVING & COMPLIANCE
 
Now we’re using Laserfiche eFile to meet the demand for email archiving compliance policies.  The same long term secure storage is available with the ability to monitor all inbound, all outbound, or both inbound and outbound messaging for users in an organization.  Laserfiche Workflow rules can still be applied to any of the archived content as well as maintaining the standard search and retrieval ease found only in Laserfiche.
Capture and Archive all messages:
1.       Inbound
2.       Outbound
3.       Both Inbound and Outbound
4.       Stored Securely
5.       Message Parts can be Indexed on Templates
6.       Message Parts Readily searchable
7.       Leave Attachments inside the message or copy and store separately
Laserfiche eFile sold exclusively by OPG-3

 

Ask OPG-3 to assess your email archiving today, before it becomes a problem. Please contact us today: 651-233-5064 jblackford@opg-3.com

OPG-3: Your Shared Point for Enterprise Content

Thursday, July 2, 2015

Is It Time To Streamline Accounts Payable Without Paper-Pushing? OPG-3 #18

Why would you do the same Accounts Payable process time after time, when Hemingway Solutions can make your AP jobs easier? We’re ready to build your Paperless Accounts Payable System with a Folder Structure and Templates (a badge for each document or folder with data about data: Fields).  
Here’s your process:


Open invoices come in and are put in one file that goes to counsel to be voted on paying - that is the batch -


Invoices are tagged by 11 digit - First 3 digits are fund #, next digits 5 department, 3 object (payroll, etc.) determines how it paid
Two Workflows


1.  1.  Searches for Open Invoices and makes into a batch to present to counsel


a.    Need a total calculation for the batch.


b.   If an invoice in the batch is not approved – need to be able to re run BP


2.  Invoice with check routed to individual departments under Vendor sub-folder


Accounts Payable Template


Vendor Name – Lookup (values in your Accounting System)


Vendor ID - Required


Vendor Address – Lookup (values in your Accounting System)


Type - drop down


Invoice # - Required


Gross – lookup (values in your Accounting System)


Bank Code – Lookup (values in your Accounting System)


Item Date – lookup (values in your Accounting System)


G/L Post Date – lookup (values in your Accounting System)


Due Date – lookup (values in your Accounting System)


Batch total - workflow calculation (?)


Approved - Y/N - drop down

The end result is a paperless Accounts Payable System with these categories automatically updated by Laserfiche Workflows.   


Folder Structure


Accounts Payable


Incoming Documents


Batches - Sub-folder by year and month


Departments with Vendor as sub-folder


If we build it, will you use it? Yes.


Are you ready for Paperless Accounts Payable? Call OPG-3 today! 651-233-5075


Chief Digital Officer



Thursday, June 18, 2015

Laserfiche Agenda Management via Workflows: The OPG-3 Way


Laserfiche Agenda Management via Workflows: The OPG-3 Way

Many Minnesota Community Action Agencies (CAP) use Laserfiche Workflows developed by OPG-3 to power the meeting paperwork processes. Here's another typical example.
Every Thousand Oaks city council meeting agenda packet contains at least 20-30 items. Each agenda item must go through a thorough review process before it is approved and included on the agenda. Here is how the city took this arduous, manual process and automated it with Laserfiche Workflow.

The legacy process: All agenda items must be reviewed and approved before they can be included in the agenda packet. The first three reviewing departments are:
  • City Attorney’s Office
  • Finance Department
  • City Manager’s Office
    In the past, the submitting department would email a copy of the agenda item to all three departments. Each department would review the document independently and make comments/changes. Some would make the changes directly in the electronic document while others would print out the document first and send back written comments. The submitter would then receive three different versions of the marked-up documents (some electronic, and some paper). The submitting department then had to incorporate all of those changes into the agenda item. Occasionally the comments from one department would conflict with changes requested by another.
    On occasion, the updated agenda item was then resubmitted to the reviewing department for another review. Once approved by all three departments, the item was then submitted to the City Clerk and the process continued until the item was finalized.
    The City Clerk would print all the finalized agenda items and manually compile the agenda packet. The agenda packet was then scanned into Laserfiche where it was OCRd. A city employee would then perform quality control on the entire document (averaging 500-700 pages) to make sure that it was scanned correctly. The printed agenda packet would then be sent to a print shop that would scan it in again, and print out at least 30 copies for distribution to council members, the public and other staff.
    The current process: Laserfiche Workflow automated and streamlined the entire agenda packet review/approval and generation process. Now, after the agenda item is written, the submitting department imports it into the department’s For Submission folder in Laserfiche.
    During the import process, the submitter fills out the document’s metadata including Meeting Date, Title and Agenda Section. The submitter also changes the value of the Submitted field from Pending to Submitted.
    Laserfiche Workflow routes the agenda item to the submitting department’s Pending Approval folder and creates a shortcut (and assigns appropriate entry access rights) in each of the three reviewer’s folders (City Attorney, Finance Department and City Manager).
    Laserfiche Workflow notifies each reviewing department by email of new items that require attention. Since all three departments will be reviewing and making comments/updates in the same Microsoft Word document, City Manager review is completed last to avoid creating conflicts.
    Once the reviewer from the appropriate department finishes making comments/edits using Microsoft Word’s track changes option, the value of the appropriate status field is changed to one of the following:

  • Approved: agenda item is approved as is.
  • Additional Info Needed: agenda item needs changes and must be resubmitted afterward for another review.
  • Conditionally Approved: agenda item needs minor changes but does not need to be resubmitted for another review afterward.
    The reviewer also includes any comments in the appropriate Comments field. If the agenda item is approved by all three reviewing departments, it is routed directly to the City Clerk for final review. If the Additional Info Needed or Conditionally Approved option is selected, the submitter is notified of this decision by email and the value of the Submitted field reverts back to Pending. The submitter makes the required changes and updates the value of the Submitted field to Submitted.
    If additional info was needed, the agenda item moves through the same review process outlined above. If the item was conditionally approved, after being updated it is routed to the City Clerk for a final review.
    The City Clerk is notified of agenda items for review. After reviewing it, she must change the value of the City Clerk Approval field to either Approved or Additional Info Needed. If additional information is needed, the submitter is notified by email and has to make the changes before resubmitting. Once approved, the original is moved to the City Clerk’s processing folder where City Clerk staff merges the agenda items (report and attachments) and to assemble the agenda packet. At this point, the agenda item leaves the workflow process and can no longer be accessed by the submitting department. City Clerk staff converts all merged documents to TIFF images to store in the repository.
    The finalized agenda packet is distributed by email to city council members, department heads, deputies and other staff members. It is also made available to the public on the city’s website through Laserfiche WebLink. The print shop accesses an electronic version of the agenda for the limited packets now being printed.
    Laserfiche Workflow
    The backbone of the new automated process is Laserfiche Workflow. One workflow runs behind the scenes routing agenda items for review between the various approvers.
    When designing this workflow, we had to take into consideration that not all departments have to review the agenda item a second time. In order to make sure that this is the case, we use the Conditional Parallel activity. Here is what the City Manager review branch of the Conditional Parallel activity looks like. It was also important that only the people who have to work with the document at the time, such as the submitter and then the reviewer, could modify it. We used the Assign Rights activity to assign rights to the appropriate individuals and then remove them after their tasks are completed. When the agenda item has been approved by everyone, the submitter is notified by email. To make sure that the workflow does not terminate, if an email cannot be sent, we’ve enclosed the E-mail activity within a Try-Catch activity.
    Since the same workflow processes both new agenda items and those that need another review, the starting rules are configured so that the workflow is invoked when an entry is created, changed or moved.
    Benefits of Laserfiche & OPG-3
    Automating the agenda review process has resulted in the following benefits for the City of Thousand Oaks:
  • The city eliminated two scanning sessions (one by the City Clerk department and one by the print shop) that used to take up to eight hours by compiling the entire agenda electronically. The print shop now receives a PDF version of the agenda and packet to print only ten copies.
  • Reviewers receive the documents in their native format allowing for changes and comments to be tracked in a single document. The final reviewer, the City Manager, sees all comments from the other two reviewing departments.
  • Reviewers no longer have to be at their desks to review the agenda items. They can do so remotely through Laserfiche Web Access even when they’re out of the office.
  • Submitters no longer have to reconcile three different sets of comments and changes to their agenda items before resubmitting for review. All of the comments are now in a single document.
  • Staff can now monitor electronically when the document was submitted and where it is in the approval process.
  • Agendas are now available to the public online through Laserfiche WebLink at 5pm on posting day.
    Do Agenda Management with us today! www.opg-3.com