Document Management - White Paper (ID 5277).pdf Jul. 2014 | Page 26

Integration Morris & Associates Manufacturer fills in ERP gaps with DMS metadata Morris & Associates designs and builds industrial-scale refrigeration products and tracks most of its engineering and maintenance records in a networked Enterprise Resource Planning (ERP) system. “Our company’s ERP stores all of our vendor information, customer data, projects, job processes, as well as our inventory,” says IT Manager, Heather Kent. “Pretty much the entirety of our business is located in this one application, but not everything. In some cases, there’s some data we’d like to include, but can’t.” As an example, the company maintains all its part lists in the ERP application, but the system has no feature to include a photograph or drawing of a part. “When we look up a part number, we want to bring up the essential data, and also verify if we’ve selected the right component visually.” Kent installed the M-Files document management solution to handle the extraneous documents that did not have a place within its ERP program. Because M-Files contains an open database platform, Kent discovered she could coordinate the two company-wide systems to operate with the same project numbers and part lists. This has allowed the synching of image files with ERP part information displays as well as a host of integrated tasks. “One of the great things about M-Files is you can use SQL queries to directly pull information such as products, parts, or contacts from our existing ERP databases and link it to metadata on documents in M-Files,” says Kent. “M-Files can actually pull our entire list of parts in our database. Any time a new part is added to our ERP system, M-Files automatically updates and pulls that information into its database.” “The M-Files document management solution turned out to be an excellent fit for our situation,” adds Kent, “and we keep discovering new uses beyond those we initially envisioned.” Storage and Archiving After adopting a document management solution, the actual hardware storage location of documents will be irrelevant to the average user, who accesses what appears to be a single repository. In the background however, the system works to manage the changing conditions of server hardware storage. The system should have the versatility to change to new storage locations in the future as the organization grows and new hardware is introduced. EASY DOCUMENT MANAGEMENT Storage devices have evolved considerably over the last ten years and will continue advance at a rapid rate. It is important that companies can easily transfer their data from one data storage location to another while continuing to access the documents as before. The IT administrator should also be able to designate certain hardware to store backups or archived files. Some systems may give options pertaining to file retention, including the capability to automatically delete of certain document types past a certain age as required for certain types of confidential recordkeeping, or simply as an efficient use of storage space. - 26 -