Source: http://www.google.com/patents/US7849101?dq=5,072,412
Timestamp: 2014-03-10 00:59:13
Document Index: 19003751

Matched Legal Cases: ['art 300', 'art 800', 'art 800', 'art 900', 'art 1200', 'art 11', 'art 11']

Patent US7849101 - Method and system for enabling an electronic signature approval process - Google PatentsSearch Images Maps Play YouTube News Gmail Drive More »Sign inAdvanced Patent SearchPatentsThe present invention includes a computer-implemented method and an Enterprise Resource Planning System (ERP). The method and system allows a user to enable an electronic signature approval process for modification of data in a transaction. The method includes accessing a table that corresponds with...http://www.google.com/patents/US7849101?utm_source=gb-gplus-sharePatent US7849101 - Method and system for enabling an electronic signature approval processAdvanced Patent SearchPublication numberUS7849101 B2Publication typeGrantApplication numberUS 11/127,595Publication dateDec 7, 2010Filing dateMay 12, 2005Priority dateMay 12, 2005Also published asUS20060259486, WO2007067204A2, WO2007067204A3Publication number11127595, 127595, US 7849101 B2, US 7849101B2, US-B2-7849101, US7849101 B2, US7849101B2InventorsJacob Lind, Jan Lysgaard JensenOriginal AssigneeMicrosoft CorporationExport CitationBiBTeX, EndNote, RefManPatent Citations (80), Non-Patent Citations (28), Referenced by (1), Classifications (10), Legal Events (2) External Links: USPTO, USPTO Assignment, EspacenetMethod and system for enabling an electronic signature approval processUS 7849101 B2Abstract The present invention includes a computer-implemented method and an Enterprise Resource Planning System (ERP). The method and system allows a user to enable an electronic signature approval process for modification of data in a transaction. The method includes accessing a table that corresponds with the transaction and adding a signature field having a property sheet to the table. The method also includes defining a select property in the property sheet with a select parameter. The select property configured to provide approval of modified data in the transaction upon entry of a valid electronic signature.
1. A computer-implemented method of enabling an electronic signature approval process for modification of data in a transaction of an Enterprise Resource Planning System (ERP), the method comprising:
receiving the transaction having the data to be modified;
accessing a table from a computer storage media, the table corresponding to the transaction;
adding one or more signature fields to the table for approving the modification of the data, each signature field having a property sheet, wherein the property sheet includes a plurality of properties for defining one or more aspects of the electronic signature approval process in association with the transaction;
receiving a parameter for at least one of the plurality of properties, the parameter defining how one of the one or more signature fields functions;
receiving a request to modify the data;
receiving an electronic signature that corresponds to the parameter;
approving the modification of the data in the transaction when the electronic signature includes a valid username and password; and
logging the electronic signature as unsuccessful in a signature log when the electronic signature includes an invalid username and password.
accessing an electronic signature module; and configuring the electronic signature module to correspond with the transaction.
3. The computer-implemented method of claim 2, wherein configuring the electronic signature module to correspond with the transaction comprises applying code to the electronic signature module specific to the transaction.
4. The computer-implemented method of claim 1, wherein the parameter is used consistently across all transactions that enable the electronic signature approval process.
5. The computer-implemented method of claim 4, wherein the parameter has a consistent naming convention across all transactions that enable the electronic signature approval process.
6. The computer-implemented method of claim 1, wherein each signature field corresponds to a required electronic signature.
7. The computer-implemented method of claim 1, wherein one of the one or more signature fields is named signature modified.
automatically configuring a database log to log all changes made to the transaction upon entry of the select parameter; and
configuring the signature log for storing logs of one or more electronic signature approval attempts.
9. A computer readable medium having computer readable instructions stored thereon for enabling an electronic signature approval process for modification of data in a transaction of an Enterprise Resource Planning System (ERP), the computer readable instructions causing the computing device to perform the steps of:
accessing a table from a computer storage media, the table corresponding to the transaction having the data to be modified;
10. The computer readable medium of claim 9 wherein the computer readable instructions further cause the computing device to perform the steps of:
accessing an electronic signature module; and
configuring the electronic signature module to correspond with the transaction.
11. The computer readable medium of claim 10, wherein the computer readable instructions further cause the computing device to perform the step of applying code to the electronic signature module such that the electronic signature module corresponds with the transaction.
12. The computer readable medium of claim 9, wherein each signature field corresponds to a required electronic signature.
13. The computer readable medium of claim 9 wherein the computer readable instructions further cause the computing device to perform the steps of:
automatically configuring a database log to log all changes to all fields within the table upon entry of the parameter; and
14. An Enterprise Resource Planning (ERP) system having a plurality of transactions and configured to enable an electronic signature approval process for modifying data in each of the plurality of transactions, the ERP system comprising:
a computer storage media having a table configured to be accessed by a user, the table corresponding to one of the plurality of transactions that has the data to be modified;
one or more signature fields for approving the modification of the data, each signature field having a property sheet to be added to the table by the user, wherein the property sheet includes a plurality of properties for defining one or more aspects of the electronic signature approval process in association with the one of the plurality of transactions; and
a parameter for at least one of the plurality of properties, the parameter defining how one of the one or more signature fields functions;
an electronic signature module configured to receive an electronic signature that corresponds to the parameter and provides approval of modified data in the transaction when the electronic signature includes a valid username and password; and
a signature log for logging the electronic signature as unsuccessful when the electronic signature includes an invalid username and password.
15. The ERP system of claim 14 and further comprising an electronic signature module configured to correspond with the transaction.
16. The ERP system of claim 14, wherein each signature field corresponds to a required electronic signature.
17. The ERP system of claim 14, wherein the parameter is used consistently across all transactions that enable the electronic signature approval process.
18. The ERP system of claim 17, wherein the parameter has a consistent naming convention across all transactions that enable the electronic signature approval process.
19. The ERP system of claim 14 and further comprising:
a database log configured to log all changes made to all fields within the table that includes the parameter upon entry of the parameter; and
a wherein the signature log is configured to store logs of one or more electronic signature approval attempts.
CROSS-REFERENCE TO RELATED APPLICATIONS Reference is hereby made to the following co-pending and commonly assigned patent applications: U.S. application Ser. No. 11/127,464, filed May 12, 2005, entitled �ENTERPRISE RESOURCE PLANNING SYSTEM AND METHOD FOR MANAGING BILL OF MATERIAL TRANSACTIONS�; U.S. application Ser. No. 11/127,527, filed May 12, 2005, entitled �ENTERPRISE RESOURCE PLANNING SYSTEM AND METHOD FOR MANAGING ROUTE TRANSACTIONS� and U.S. application Ser. No. 11/127,518, filed May 12, 2005, entitled METHOD AND SYSTEM FOR PERFORMING AN ELECTRONIC SIGNATURE APPROVAL PROCESS�.
BACKGROUND OF THE INVENTION The present invention generally relates to computerized Enterprise Resource Planning (ERP) systems. More particularly, the present invention relates to an electronic signature approval process for approving modifications to transactions or documents in an ERP system.
Enterprise resource planning (or ERP) is a phrase used to describe a broad set of activities supported by multi-module application software that helps a manufacturer or other business manage the important parts of its business. Computerized ERP systems typically handle the logistics of various activity modules internal to a business or organization, such as manufacturing, production, distribution, inventory, shipping, invoicing, accounting and human resource management. Often, an ERP system uses or is integrated with a relational database system. An example of an ERP system is Microsoft� Business Solutions-Axapta�.
Each activity module managed by an ERP system includes transactions or documents. Transactions or documents include information or data that describes processes that occur internal to a business or organization. Many businesses, such as those in the pharmaceutical or biomedical industries, have certain processes that are critical processes and need to be approved before they can be implemented as an activity of the business. Such critical processes are highly regulated by the Food and Drug Administration (FDA) and require that implementation of new processes and modifications to processes as well as deletions of processes are signed off by a representative or multiple representatives of the pharmaceutical or biomedical business.
Generally, information related to a critical process is stored in the ERP system in the form of a transaction or document. To approve such a process or a modification to a process, the document is printed out and manually signed and dated by an individual or multiple individuals who are allowed to make such approvals. The document is then stored in a safe place that is readily available such that copies can be made of the approved document. For example, if the document requiring approval is a manufacturing drawing or a process of how a product is developed then a working copy of the originally signed document can be made for those needing to complete a specific job shown or discussed in the document. After the job is complete, the working copy is destroyed such that only one original exists.
This manual approval process ensures a history or audit trail that describes the lifecycle of data by storing old versions of an approved document as well as storing modified versions of a document. However, such a paper trail is difficult to manage. Original documents can easily become misplaced. To ensure that the history of critical data is fully documented, keeping and storing additional copies of the original documents is practiced, thus creating more problems with respect to managing paper trails.
SUMMARY OF THE INVENTION The present invention includes a computer-implemented method of enabling an electronic signature approval process for modification of data in a transaction of an Enterprise Resource Planning System (ERP). The method includes accessing a table that corresponds with the transaction and adding a signature field having a property sheet to the table. The method also includes defining a select property in the property sheet with a select parameter. The select property is configured to provide approval of modified data in the transaction upon entry of a valid electronic signature.
The present invention also includes an ERP system having a plurality of transactions. The ERP system is configured to allow a user to enable an electronic signature approval process for modifying data in each of the plurality of transactions. The ERP system includes a table configured to be accessed by the user. The table corresponds to one of the plurality of transactions. The ERP system includes a signature field having a property sheet. The signature field is added to the table by the user. The ERP also includes a select property included in the property sheet. The select property is defined with a select parameter such that it provides approval of modified data in the transaction upon entry of a valid electronic signature.
BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 illustrates a block diagram of a general computing environment in which the present invention can be practiced.
FIG. 2 illustrates a block diagram of an Enterprise Resource Planning (ERP) system in accordance with an embodiment of the present invention.
FIG. 3 is a flowchart illustrating a method of performing an electronic signature approval process in accordance with an embodiment of the present invention.
FIG. 4 illustrates a screenshot of an example electronic signature form in accordance with an embodiment of the present invention.
FIG. 5 illustrates a screenshot of a first tab form of a database log in accordance with an embodiment of the present invention.
FIG. 6 illustrates a screenshot of a second tab form of the database log illustrated in FIG. 5 in accordance with an embodiment of the present invention.
FIG. 7 illustrates a screenshot of a signature log in accordance with an embodiment of the present invention.
FIG. 8 is a flowchart illustrating an example method of performing an electronic signature approval process for making a change to a production resource in accordance with an embodiment of the present invention.
FIG. 9 is a flowchart illustrating a method of enabling an electronic approval process in an ERP system in accordance with an embodiment of the present invention.
FIG. 10 illustrates a screenshot of a table that corresponds with a transaction in accordance with an embodiment of the present invention.
FIG. 11 illustrates a screenshot of the table illustrated in FIG. 10 in accordance with an embodiment of the present invention.
FIG. 12 is a flowchart illustrating a further method of enabling an electronic approval process in an ERP system in accordance with an embodiment of the present invention.
DETAILED DESCRIPTION OF ILLUSTRATIVE EMBODIMENTS The present invention is described in the context of an Enterprise Resource Planning (ERP) system. The ERP system of the present invention includes an electronic signature approval process where an approver attempts to modify a critical process managed by the ERP system. Critical processes in the ERP system are stored in the form of transactions or documents. The present invention is also described in the context of a user enabling the electronic approval process. Before describing aspects of the present invention, however, it may be useful to describe suitable computing environments that can incorporate and benefit from these aspects.
The invention may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communication network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices. Tasks performed by the programs and modules are described below and with the aid of figures. Those skilled in the art can implement the description and figures provided herein as processor executable instructions, which can be written on any form of a computer readable medium.
With reference to FIG. 1, an exemplary system for implementing the invention includes a general-purpose computing device in the form of a computer 110. Components of computer 110 may include, but are not limited to, a processing unit 120, a system memory 130, and a system bus 121 that couples various system components including the system memory to the processing unit. System bus 121 may be any of several types of bus structures including a memory bus or memory controller, a peripheral bus, and a local bus using any of a variety of bus architectures. By way of example, and not limitation, such architectures include Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MCA) bus, Enhanced ISA (EISA) bus, Video Electronics Standards Association (VESA) local bus, and Peripheral Component Interconnect (PCI) bus also known as Mezzanine bus.
FIG. 2 illustrates a block diagram of an ERP system 200 in accordance with an embodiment of the present invention. FIG. 3 is a flowchart 300 illustrating a method of performing an electronic signature approval process in ERP system 200 in accordance with an embodiment of the present invention. In one embodiment, the approval process illustrated in FIG. 3 is directed towards approving modification of data in a transaction that requires a single electronic signature.
The method begins at block 302. At block 302, ERP system 200 accesses a transaction or document from a plurality of transactions 202. Each transaction 202 includes information or data related to a process that occurs internal to a business and managed by ERP system 200.
In one example, ERP system 200 manages a business's production. Many transactions in the ERP system are categorized as transactions relating to specific aspects of production. Example transactions include production resource transactions. A production resource transaction includes data or information about a resource that is being used in manufacturing. An example resource is a milling machine. In such an example, the milling machine resource transaction includes data indicating how long it takes the milling machine to operate or data indicating the maximum amount of units the milling machine can machine (i.e. capacity). It should be noted that other data is also included in production resource transactions.
In another example, ERP system 200 manages a business's manufacturing. Manufacturing includes many transactions that include data related to manufacture. One such transaction is a bill of materials (BOM). The BOM includes a list of materials that is required to make a particular product. Another such transaction is a route. The route includes data or information of how to use the BOM to make a particular product.
At block 304, ERP system 200 receives an indication that a piece of data in the accessed transaction 202 is to be modified. Modifications include additions, deletions or changes to data. Upon such an indication, ERP system 200 passes to block 306 and an electronic signature module 204 requests an approver to electronically sign the transaction in order to perform the indicated modification. Electronic signature module 204 requests an electronic signature by using an electronic signature form. The electronic signature form or window requires the entry of the approver's username and password.
FIG. 4 illustrates a screenshot of an example electronic signature form 400 used for requesting an electronic signature in accordance with an embodiment of the present invention. Electronic signature form 400 solicits an approver's username and password to approve modifications to a transaction. In FIG. 4, the transaction, which is to be approved, is indicated in process name block 402. In the example illustrated in FIG. 4, an electronic signature is requested for the approval of a production resource transaction. The production resource transaction is known as a Work Center in ERP system 200. In particular, the production resource is milling machine number 1. At username field 404, an approver is asked to enter a valid username. In the example illustrated in FIG. 4, the approver's username is SVE. Although the approver's username can be selectable from a plurality of usernames, the approver's username can also be keyed into username field 404. At password field 406, the approver is asked to enter a valid password. Electronic signature form 400 also includes an information block 408. Information block 408 provides an alert indicating that by electronically signing the document, the approver understands that the electronic signature is as legally binding as the approver's handwritten signature. After the approver has entered their username and password, the approver selects the okay field 410 such that electronic signature module 204 will begin processing the approver's information.
Referring back to FIGS. 2 and 3, electronic signature module 204 processes the username and password by accessing credentials module 206. Credentials module 206 compares the username and password to a list of acceptable usernames and corresponding passwords. Such a module is well known in the art of authentication and, in one embodiment of the present invention, credentials module 206 is used to validate the electronic signature such that modifications can be made to transaction 202. However, credentials module 206 is also configured to validate a user signing into an instance of ERP system 200. Such a sharing of credentials between electronic signature module 204 and an instance of an application of the ERP system makes user memorization of a username and a password simpler. There are additional advantages. For example, a user can be signed into an instance of ERP system 200 and a different user or approver can electronically sign a modification to a transaction without being particularly signed into ERP system 200.
At block 308, electronic signature module 204 verifies whether the username supplied, for example in username field 404 illustrated in FIG. 4, is a valid username for approving the specific process. If the username is valid, ERP system 200 proceeds to block 310. If, however, the username is invalid, ERP system 200 proceeds to block 312. At block 312 the electronic signature approval process is aborted. At block 310, electronic signature module verifies whether the password supplied, for example in password field 406 illustrated in FIG. 4, is a valid password for the given username. If the password is valid, ERP system 200 proceeds to block 314. If, however, the password is invalid, ERP system 200 proceeds to block 312. As discussed above, at block 312, the electronic signature approval process is aborted.
At block 314, the approver's username and password have been verified and ERP system 200 writes a signature identification (ID) that corresponds with the verified approver on accessed transaction 202. The signature ID indicates which approver has electronically signed or approved modifications to transaction 202. ERP system 200 proceeds to block 316 and updates the transaction with the modified data. At block 318, ERP system 200 registers the modified data in a database log 208. Database log 208 is a tracking system that is configured to log modifications of all information or data in any given transaction, for example in transaction 202.
FIGS. 5 and 6 illustrate screenshots of database log 208 in accordance with an embodiment of the present invention. As illustrated in FIGS. 5 and 6, the screenshot in FIG. 5 illustrates a first tab view 500, while the screenshot in FIG. 6 illustrates a second tab view 600. First tab view 500 and second tab view 600 illustrate logged data of the transaction that corresponds with production resource milling machine number 1. In FIG. 5, first tab view 500 illustrates an Overview tab 502 of logged modifications to milling machine number 1. Overview tab 502 includes a plurality of columns that categorizes information and describes modification entries that have been made to the particular production resource. Example columns include Name of Table 504, Record Description 506, Type of Change 508, Created Date 510, Created Time 512, Creator Signature ID 514 and Creator Name 516. As illustrated, the transaction, corresponding with milling machine number 1, was created in ERP system 200 on May 19, 2004. On Apr. 1, 2005, the table transaction was modified or updated and electronically signed by the Administrator.
In FIG. 6, second tab view 600 illustrates a history tab 618. History tab 618 shows the actual logged modifications made to milling machine number 1. History tab 618 includes a Field column 620, a Value column 622 and a Previous value column 624. Referring to history tab 618, on Apr. 1, 2005, data in Values column 622 was inserted and updated. History tab 618 also shows that there was no data in Previous values column 622 before database log 208 was updated.
After ERP system 200 registers the modified data into database log 208, the ERP system passes to block 320 in FIG. 3 and logs the approval attempt as being successful in a signature log 210 (FIG. 2). Referring back to block 312, if the electronic signature approval process was aborted, ERP system 200 passes to block 322 and logs the approval attempt as being unsuccessful in signature log 210. Successful attempts are those electronic signature approvals where valid usernames and passwords were used. Unsuccessful attempts are those electronic signature approvals where invalid usernames and/or passwords were used.
All successful and unsuccessful attempts at electronic signature approval are logged in signature log 210 at either block 320 or block 322. FIG. 7 is a screenshot illustrating a view 700 of signature log 210 in accordance with an embodiment of the present invention. View 700 shows each electronic signature approval attempt as a line entry. The signature log includes a plurality of columns that include information describing the different attempts made to electronically approve a process. Example columns include Machine name 702, Active user ID 704, Signature user ID 706, Signer name 708, Date 710, Time 712, Process description 714 and Signature ID 716.
Machine name column 702 includes the name of the computing device that was used to attempt electronic signature approval. As illustrated in FIG. 7, all entries were approval attempts made at the computing device named PC3401-JLIND. Active user ID column 704 includes the username that was used to sign into or open an instance of ERP system 200. As illustrated, all entries were approval attempts made on computing device PC3401-JLIND on an instance of the ERP system that was signed into by the username Admin. Signature user ID column 706 includes the username that was used to attempt electronic signature approval of the resource. In FIG. 7, the Signature user ID column 706 matches the Active user ID column 704. However, as discussed above, the user who is attempting to electronically sign a document need not be the same user who is signed into the current instance of ERP system 200. It should be noted that the username and password for signing into an instance of ERP system 200 has the same credentials as the username and password for electronically signing a transaction. Signer name column 708 is the name of the user who is attempting to electronically sign a transaction. The name of the user corresponds with the signature user ID. Date column 710 and Time column 712 include the dates and times at which there was an attempt to electronically approve a document. Process description column 714 includes a short description of what modifications were attempted.
Signature ID column 716 includes an alpha-numeric identification code that is associated with a successful attempt at electronically signing a document. The first entry of view 700 does not include a signature ID. The absence of a signature ID indicates that the particular attempt at electronic signature approval was unsuccessful. Therefore an unsuccessful entry is made into the signature log. There can be one of three reasons for an absence of a signature ID. In one aspect, the user trying to electronically sign a transaction is not allowed to do so because the user does not have the proper access rights or credentials to electronically sign the transaction. In another aspect, the user has entered a non-existing username. In yet another aspect, the user trying to electronically sign a transaction has entered the wrong password. The remaining two entries illustrated in FIG. 7 include a signature ID (i.e. ES-001 and ES-002). These two entries were successful attempts at electronically signing a transaction.
Regardless of the reason for an unsuccessful attempt at electronic signature, the unsuccessful attempt can also initiate an email or notification to the administrator. In addition, at any given time a report can be generated based on successful and unsuccessful attempts at electronic signature. For example, reports can be generated that show successful and unsuccessful electronic signature attempts per user or per date. Other types of reports are possible.
In another embodiment of the present invention, multiple electronic signatures can be applied to a transaction for approval of a modification. For example, it is possible that a manager or supervisor of an approver is also required to electronically approve a transaction. To electronically approve a transaction that requires multiple signatures, a first approver's electronic signature is performed in accordance with the method illustrated in FIG. 3. Upon a first approver's successful attempt at electronically approving a transaction, a second approver can attempt to make the same modification to a transaction using the method illustrated in FIG. 3. Upon a successful attempt, ERP system 200 writes the second approver's signature onto the transaction as illustrated in blocks 314, 316, 318 and 320 of FIG. 3.
FIG. 8 is a flowchart 800 illustrating an example method of performing an electronic signature approval process when making a change to a transaction in an ERP system, such as ERP system 200. The example illustrated in FIG. 8 illustrates the steps associated with changing the capacity of a production resource that requires electronic signature approval. More particularly, flowchart 800 illustrates changing the capacity of milling machine number 1 as previously discussed in association with FIGS. 5 and 6.
The method begins at block 802. At block 802, an approver changes the capacity of the production resource and at block 804 applies those changes. To make the change, an electronic signature module, such as electronic signature module 204, requests that the user electronically sign an electronic signature form, such as the form illustrated in FIG. 4. At block 806, the approver applies their electronic signature.
At block 808, the electronic signature module verifies whether the username applied in block 806 is a valid username for approving the specific process to be modified. If the username is valid, the ERP system proceeds to block 810. If, however, the username is invalid, the ERP system proceeds to block 812. At block 812 the electronic signature approval process is aborted. At block 810, the electronic signature module verifies whether the password applied in block 806 is a valid password for the given username. If the password is valid, the ERP system proceeds to block 814. If, however, the password is invalid, the ERP system proceeds to block 812. As discussed above, at block 812, the electronic signature approval process is aborted.
At block 814, the approver's username and password have been verified and the ERP system writes a signature ID that corresponds with the verified approver on the transaction. This signature ID indicates which approver has approved or electronically signed a transaction, such as transaction 202. At block 814, the ERP system also updates the changes to the capacity on the transaction. At block 816, the ERP system registers the changed capacity in a database log, such as database log 208. All successful and unsuccessful attempts at electronic signature approval are logged in a signature log, such as signature log 210, at either block 818 or block 820. The process description associated with either a successful or an unsuccessful attempt at electronic signature approval will include a description that capacity has been changed on the production resource.
FIG. 9 is a flowchart 900 illustrating a method of enabling an electronic approval process in an ERP system, such as ERP system 200 (FIG. 2), in accordance with an embodiment of the present invention. The method illustrated in FIG. 9 is performed in response to user inputs. In one embodiment, enabling an electronic signature for approval of a transaction can require a single electronic signature.
Each transaction, such as transaction 202 illustrated in FIG. 2, includes a corresponding table 212. Referring to FIG. 9, at block 902, table 212 is accessed in response to a first user input. Accessed table 212 includes a plurality of fields that contain data related to corresponding transaction 202. At block 904, a signature field is added to table 212 in response to a second user input in order to begin the process of adding an electronic signature approval process feature to a particular transaction.
FIG. 10 is a screenshot illustrating a form 1000 representing one table 212 in accordance with an embodiment of the present invention. Form 1000 illustrates that one table 212 is a Work Center table. A Work Center table is a table for a production resource. For example, the Work Center table could be for a milling machine (i.e. milling machine number 1) as previously discussed. Those skilled in the art should recognize that other names of tables exist for other types of transactions. As illustrated, a signature field 1002 has been added to table 212 to enable an electronic signature approval process in association with a particular transaction, such as a production resource. Signature field 1002 is named signature modified.
FIG. 11 is a screenshot illustrating a property sheet 1004 associated with signature field 1002 in accordance with an embodiment of the present invention. Upon adding signature field 1002 to a table, such as a Work Center table, the user is given access, via a property sheet 1004, to a list of properties associated with an electronic signature approval process that is being added to the Work Center table. As illustrated in FIG. 11, signature field 1002 includes a property sheet 1004. Property sheet 1004 includes a plurality of properties 1006 for defining aspects of an electronic signature approval process. Each property 1006 is defined by a parameter 1007.
Referring back to FIG. 9, at block 906, a select property in property sheet 1004 is defined by a select parameter in response to a third user input. As illustrated in FIG. 11, the select property to be defined is property 1008 or the extended data type. In FIG. 11, the user defines select property 1008 with the select parameter 1009, such as the parameter �SysSignID�. The defined select property 1009 is configured to provide approval of modified data in the transaction upon entry of a valid electronic signature. �SysSignID� is simply a naming convention for select parameter 1009. The naming of parameter 1009 should remain consistent across all transactions or tables in which the electronic signature approval process is to be enabled. In another words, parameter 1009 is a controlling parameter in that upon entry of the �SysSignID�, or other type of name, the database log is configured to log all changes to all fields within the particular table, such as the Work Center table, that includes select parameter 1009. At the point that select property 1008 is defined by the select parameter 1009, the foundation to use electronic signature in transaction 202 that corresponds with table 212 has been established.
FIG. 12 is a flowchart 1200 illustrating further steps for enabling electronic signature approval after the foundation has been established in accordance with FIG. 9. At block 1202, electronic signature module 204 is accessed in response to a fourth user input. For example, the fourth user input could be the manipulation of a developmental tool in ERP system 200. Electronic signature module 204 corresponds with an electronic signature form. At block 1204, electronic signature module 204 is configured to correspond with transaction 202 in response to a fifth user input. In order to configure electronic signature module 204 to correspond with transaction 202, the user applies code to the electronic signature module. The code is specific to the transaction. However, in many instances, the code is a generic code that needs very little modification from transaction type to transaction type in ERP system 200. The following example recites code that can be used to configure an electronic signature module to correspond with the example Work Center table:
SysSign sysSign;
sysSign = sysSign::construct( tableNum(WrkCtrTable),
fieldNum(WrkCtrTable, SignatureModified));
if (!sysSign.Prompt ( ) )
if (wrkCtrTable.RecId &&
sysSign.parmObjectStatus( ) == sysSignObjectStatus::
DialogFinishedOK)
sysSign.SetSysSignId(wrkCtrTable);
sysSign.finalize( );
if (sysSign && sysSign.parmObjectStatus( ) ==
sysSugnObjectStatus::DialogFinishedOK))
wrkCtrTable.update( );
wrkCenterTable_DS.reread( );
In another embodiment, enabling an electronic signature for approval of a transaction can require multiple electronic signatures. In such an embodiment, multiple signature fields are added for each required electronic signature. In addition, each signature field is configured with a select parameter, such as �SysSignID� in the extended data type field. Finally, electronic signature module 204 is configured to correspond with transaction 202 and therefore table 212, such that multiple signatures can be applied using different instances of an electronic signature form.
As discussed above in FIGS. 2-12 of the present invention, ERP system 200 (FIG. 2) is a multi-module software application. The ERP system 200 of the present invention includes a plurality of transactions 202. Each transaction 202 corresponds with a table 212. If an electronic signature approval process is to be enabled within a particular table, then the table includes a signature field having a property sheet. The property sheet includes properties that are defined by parameters. Basically the parameters define how each the signature field functions. If an electronic signature approval process has been enabled for a specific transaction, then that transaction corresponds with an electronic signature module 204. The electronic signature module 204 validates an electronic signature by accessing a credentials module 206. The ERP system also logs modifications to a transaction in a database log 208 and also logs electronic signature approval attempts in a signature log 210.
In order to accomplish these various functions, ERP system 200 includes suitably programmed processing circuitry or suitable programming storage circuitry that implements the various modules, such as a transaction, a table, an electronic signature module, a credentials module, a database log and a signature log. In addition, the programmed processing circuitry also controls the use of fields, property sheets and parameters in tables that correspond with transactions.
Patent CitationsCited PatentFiling datePublication dateApplicantTitleUS4393269 *Jan 29, 1981Jul 12, 1983International Business Machines CorporationMethod and apparatus incorporating a one-way sequence for transaction and identity verificationUS5315504 *Mar 14, 1990May 24, 1994International Business Machines CorporationElectronic document approval systemUS5367573 *Jul 2, 1993Nov 22, 1994Digital Equipment CorporationSignature data objectUS5659616 *Jul 16, 1996Aug 19, 1997Certco, LlcMethod for securely using digital signatures in a commercial cryptographic systemUS5867578 *Aug 19, 1996Feb 2, 1999Certco LlcAdaptive multi-step digital signature system and method of operation thereofUS6091835 *Feb 17, 1998Jul 18, 2000Penop LimitedMethod and system for transcribing electronic affirmationsUS6289460 *Dec 6, 1999Sep 11, 2001Astus CorporationDocument management systemUS6389402 *Jun 9, 1999May 14, 2002Intertrust Technologies Corp.Systems and methods for secure transaction management and electronic rights protectionUS6438690 *Dec 31, 1998Aug 20, 2002International Business Machines Corp.Vault controller based registration application serving web based registration authorities and end users for conducting electronic commerce in secure end-to-end distributed information systemUS6502102Mar 27, 2000Dec 31, 2002Accenture LlpSystem, method and article of manufacture for a table-driven automated scripting architectureUS6516337 *Oct 14, 1999Feb 4, 2003Arcessa, Inc.Sending to a central indexing site meta data or signatures from objects on a computer networkUS6704906 *Mar 27, 1999Mar 9, 2004Movaris, Inc.Self-directed routable electronic form system and methodUS6904370 *Dec 30, 2003Jun 7, 2005Compliance Software Solutions Corp.System, method, and computer-readable medium for collection of environmental data and generation of user report for compliance with FDA requirementsUS6912660 *Aug 6, 1999Jun 28, 2005Silanis Technology Inc.Method for parallel approval of an electronic documentUS7000179 *Feb 22, 2002Feb 14, 2006Movaris, Inc.Method and apparatus for programmatic learned routing in an electronic form systemUS7028180 *Oct 16, 2000Apr 11, 2006Northrop Grumman CorporationSystem and method for usage of a role certificate in encryption and as a seal, digital stamp, and signatureUS7100195 *Jul 30, 1999Aug 29, 2006Accenture LlpManaging user information on an e-commerce systemUS7103835 *Mar 12, 2002Sep 5, 2006Movaris, Inc.Process builder for a routable electronic document system and method for using the sameUS7177839 *Jan 27, 2000Feb 13, 2007Certco, Inc.Reliance manager for electronic transaction systemUS7225106 *Oct 7, 2004May 29, 2007Bayer Business Services GmbhData processing system and method for processing test ordersUS7251666 *Nov 21, 2001Jul 31, 2007Internet Business Information GroupSignature loop authorizing method and apparatusUS7356483 *Aug 16, 2002Apr 8, 2008The Boeing CompanyRequest for conformity systemUS7379931 *Apr 15, 2005May 27, 2008Morinville Paul VSystems and methods for signature loop authorizing using an approval matrixUS7451321 *Oct 7, 2003Nov 11, 2008Joseph Ernest DryerElectronic signature management methodUS7596511 *Oct 29, 2003Sep 29, 2009Iclosings.ComClosing system for closing real-estate transactions between a plurality of partiesUS7600124 *Dec 8, 2003Oct 6, 2009Oracle International CorporationMethod of and system for associating an electronic signature with an electronic recordUS7650512 *Dec 8, 2003Jan 19, 2010Oracle International CorporationMethod of and system for searching unstructured data stored in a databaseUS7720704May 12, 2005May 18, 2010Microsoft CorporationEnterprise resource planning system and method for managing route transactionsUS20010002485 *Dec 14, 2000May 31, 2001Bisbee Stephen F.System and method for electronic transmission, storage, and retrieval of authenticated electronic original documentsUS20010029482 *Mar 9, 2001Oct 11, 2001Integrate Online, Inc.Online mortgage approval and settlement system and method thereforUS20010037460 *Mar 5, 2001Nov 1, 2001Damian PorcariWeb-based document systemUS20020029194 *Sep 7, 2001Mar 7, 2002Richard LewisSystem and method of managing financial transactions over an electronic networkUS20020029337 *Jun 1, 2001Mar 7, 2002Certco, Llc.Method for securely using digital signatures in a commercial cryptographic systemUS20020062240 *Nov 21, 2001May 23, 2002Morinville Paul V.Signature loop authorizing method and apparatusUS20020077785Aug 16, 2001Jun 20, 2002Velquest CorporationUnified data acquisition systemUS20020091651 *Dec 14, 2001Jul 11, 2002Silanis Technology Inc.Web-based method and system for applying a legally enforceable signature on an electronic documentUS20020095601 *Jan 17, 2001Jul 18, 2002International Business Machines CorporationTechnique for establishing provable chain of evidenceUS20020116642 *Feb 26, 2001Aug 22, 2002Joshi Vrinda S.Logging access system eventsUS20020133470 *Jan 10, 2001Sep 19, 2002Gruber Robert M.Material ordering and reporting expediter (MORE)US20020161733 *Nov 27, 2001Oct 31, 2002First To File, Inc.Method of creating electronic prosecution experience for patent applicantUS20030018628Nov 2, 2001Jan 23, 2003Yih-Ping LuhSystem and method for automated management of electronic information derivativesUS20030037181Jul 7, 2001Feb 20, 2003Freed Erik J.Method and apparatus for providing process-container platformsUS20030069894 *Sep 17, 2001Apr 10, 2003Darlene CotterComputer-based system for assessing compliance with governmental regulationsUS20030093678Apr 23, 2001May 15, 2003Bowe John J.Server-side digital signature systemUS20030110443 *Feb 22, 2002Jun 12, 2003Steve YankovichMethod and apparatus for programmatic learned routing in an electronic form systemUS20030163686 *Aug 6, 2002Aug 28, 2003Ward Jean RenardSystem and method for ad hoc management of credentials, trust relationships and trust history in computing environmentsUS20030220855 *May 24, 2002Nov 27, 2003Duc LamSystem and method for payer (buyer) defined electronic invoice exchangeUS20040034554 *Aug 16, 2002Feb 19, 2004Shirley David P.Request for conformity systemUS20040093493 *Jul 16, 2003May 13, 2004Bisbee Stephen F.System and method for electronic transmission, storage and retrieval of authenticated documentsUS20040093526Nov 12, 2002May 13, 2004Hirsch Thomas StevenInstrument access control systemUS20040123107 *Jul 17, 2003Jun 24, 2004Kunihiko MiyazakiMethod for verifying a digital signatureUS20040158475 *Feb 6, 2003Aug 12, 2004Harry JuzeszynSystem and method for data handling in pharmaceutical manufactureUS20040201622 *Mar 15, 2002Oct 14, 2004Ricoh Company, Ltd.Free-form routing of physical and electronic documentsUS20040205653Dec 17, 2001Oct 14, 2004Workshare Technology, Ltd.Method and system for document collaborationUS20040243260 *Sep 19, 2003Dec 2, 2004Fisher-Rosemount Systems, Inc.Integrated electronic signatures for approval of process control and safety system software objectsUS20040250070 *Sep 3, 2002Dec 9, 2004Wong Yaw MingAuthentication of electronic documentsUS20050055306 *Oct 20, 2004Mar 10, 2005Science Applications International CorporationUser-defined dynamic collaborative environmentsUS20050076215 *Oct 7, 2003Apr 7, 2005Joseph DryerElectronic signature management methodUS20050080721 *Oct 12, 2004Apr 14, 2005Kearney Victor PaulAutomated financial transaction due diligence systems and methodsUS20050096869 *Oct 7, 2004May 5, 2005Bayer Business Services GmbhData processing system and method for processing test ordersUS20050108211 *Dec 8, 2003May 19, 2005Oracle International Corporation, A California CorporationMethod of and system for creating queries that operate on unstructured data stored in a databaseUS20050108212 *Dec 8, 2003May 19, 2005Oracle International CorporationMethod of and system for searching unstructured data stored in a databaseUS20050108232 *Nov 18, 2004May 19, 2005The Rockey Group, Inc.Electronic submittal method and systemUS20050108283 *Dec 8, 2003May 19, 2005Oracle International CorporationMethod of and system for associating an electronic signature with an electronic recordUS20050108295 *Dec 8, 2003May 19, 2005Oracle International Corporation, A California CorporationMethod of and system for committing a transaction to databaseUS20050108536 *Dec 8, 2003May 19, 2005Oracle International Corporation, A California CorporationMethod of and system for collecting an electronic signature for an electronic record stored in a databaseUS20050108537 *Dec 8, 2003May 19, 2005Oracle International CorporationMethod of and system for determining if an electronic signature is necessary in order to commit a transaction to a databaseUS20050132201Sep 23, 2004Jun 16, 2005Pitman Andrew J.Server-based digital signatureUS20050138382Dec 21, 2004Jun 23, 2005Ingeo Systems, LlcMethod and process for creating an electronically signed documentUS20050154744 *Jan 13, 2005Jul 14, 2005Morinville Paul V.Systems and methods for rule inheritanceUS20050165659 *Mar 17, 2005Jul 28, 2005Gruber Robert M.Material ordering and reporting expediter (MORE)US20050187927 *Apr 15, 2005Aug 25, 2005Morinville Paul V.Systems and methods for signature loop authorizing using an approval matrixUS20050210263 *Sep 24, 2004Sep 22, 2005Levas Robert GElectronic form routing and data capture system and methodUS20050257045 *Apr 12, 2005Nov 17, 2005Bushman M BSecure messaging systemUS20060184865 *Feb 11, 2005Aug 17, 2006Chakraborty Pallab BMethod and system for managing an electronic documentUS20060259962 *May 12, 2005Nov 16, 2006Microsoft CorporationMethod and system for performing an electronic signature approval processUS20060277123 *Jul 31, 2004Dec 7, 2006William KennedyIntegrated electronic credit application, contracting and securitization system and methodUS20060282350 *May 12, 2005Dec 14, 2006Microsoft CorporationEnterprise resource planning system and method for managing bill of material transactionsJP2000113051A Title not availableJP2004178119A Title not available* Cited by examinerNon-Patent CitationsReference1"bom.com Introduces Powerful, Paperless Product Change Management"; http://www.arenasolutions.com/news/releases/06102002.html, at least by Feb. 17, 2005.2"Engineering Change Tracking (ECT)", http://www.caelus.com/ect.htm, at least by Feb. 17, 2005.3"Manufacturing challenges of today and how we solve them-the solution for change; controlled by you"; http://www.centerlineerp.com/manufacturing/manufacturingwhitepaper.htm, at least by Feb. 17, 2005.4"MatrixOne Specification Central(TM)"; http://www.matrixone.com/pdf/ds-prod-speccentral.pdf, at least by Feb. 17, 2005.5"Microsoft� Business Solutions-Axapta� Production II"; http://www.cherryroad.com/Documents/AXAPTA/ProductionIII-FactSheet.pdf, May 14, 2003.6"ProductCenter(TM) BOM Editor-Streamlined Bill of Materials (BOM) Management with ProductCenter(TM)"; http://www.softech.com/products/productcenter/pdfs/datasheets/prc-ccs-bom.pdf, at least by Feb. 17, 2005.7"Reduce cycle time with electronic change management"; http://www.arenasolutions.com/products/features/chngmgmt.html, at least by Feb. 17, 2005.8"Manufacturing challenges of today and how we solve them�the solution for change; controlled by you"; http://www.centerlineerp.com/manufacturing/manufacturingwhitepaper.htm, at least by Feb. 17, 2005.9"MatrixOne Specification Central�"; http://www.matrixone.com/pdf/ds�prod�speccentral.pdf, at least by Feb. 17, 2005.10"Microsoft� Business Solutions-Axapta� Production II"; http://www.cherryroad.com/Documents/AXAPTA/ProductionIII�FactSheet.pdf, May 14, 2003.11"ProductCenter� BOM Editor�Streamlined Bill of Materials (BOM) Management with ProductCenter�"; http://www.softech.com/products/productcenter/pdfs/datasheets/prc�ccs-bom.pdf, at least by Feb. 17, 2005.12 *Anderson, Ross, et al., "Jikzi: A New Framework for Secure Publishing", Security Protocols, LNCS 1796, Springer-Verlag, Berlin, Germany, � 2000, pp. 21-36.13 *Blair, Barclay, et al., "XFDL: Creating Electronic Commerce Transaction Records Using XML", Computer Networks, � 1999, pp. 1611-1622.14 *Cole, James, et al., "Extending Support for Contracts in ebXML", ITVE, Queensland, Australia, � 2001, pp. 119-127.15 *Dan, Asit, et al., "Business-to-Business Integration with tpaML and a Business-to-Business Protocol Framework", IBM systems Journal, vol. 40, No. 1, � 2001, pp. 68-90.16 *Dayao, Anthony B., et al., "SuperForms: A Security-Enhanced Smart Electronic Form Management System", GLOBECOM '90, San Diego, CA, Dec. 2-5, 1990, pp. 1079-1083.17 *Gupta, Alok, et al., "Digital Signature: Use and Modification to Achieve Success in Next Generational E-Business Processes", Information & Management, vol. 41, Issue 5, May 2004, pp. 561-575.18 *Guth, Susanne, et al., "Experiences with the Enforcement of Access Rights Extracted from ODRL-Based Digital Contracts", DRM '03, Washington, DC, Oct. 27, 2003, pp. 90-102.19 *Huber, Ludwig, et al., "21 CFR Part 11-Requirements and New Scope", biopharm-mag.com, Feb. 15, 2004, pp. 1-4.20 *Huber, Ludwig, et al., "21 CFR Part 11�Requirements and New Scope", biopharm-mag.com, Feb. 15, 2004, pp. 1-4.21International Preliminary Report on Patentability (Chapter 1 of the Patent Cooperation Treaty) issued Mar. 19, 2009 in PCT/US2006/012735 filed Apr. 5, 2006; 5 pages.22International Search Report and Written Opinion issued Dec. 20, 2007 in PCT/US2006/012735 filed Apr. 5, 2006; 6 pages.23 *Leung, Karl R. P. H., et al., "Handling Signature Purposes in Workflow Systems", The Journal of Systems and Software, vol. 55, Issue 3, Jan. 15, 2001, pp. 245-259.24 *Leung, Karl R. P. H., et al., "Multiple signature Handling in Workflow Systems", Proc. of the 33rd Hawaii International Conf. on System Sciences, Jan. 4-7, 2000, pp. 1-8.25 *Yu, Chien-Chih, et al., "The Impacts of Electronic Commerce on Auditing Practices: An Auditing Process Model for Evidence Collection and Validation", Journal of Intelligent Systems in Accounting, Finance & Management, vol. 9, Issue 3, Nov. 15, 2000, pp. 195-216.26 *Zhou, Jianying, "Maintaining the Validity of Digital Signatures in B2B Applications", ACISP 2002, LNCS 2384, Springer-Verlag, Berlin, � 2002, pp. 303-315.27 *Zhou, Jianying, "Maintaining the Validity of Digital Signatures in B2B Applications", ACISP 2002, LNCS 2384, vol. 2384/2002, � 2002, pp. 303-315.28 *Zhou, Jianying, et al., "Validating Digital Signatures Without TTP's Time-Stamping and Certificate Revocation", ISC 2003, LNCS 2851, Springer-Verlag, Berlin, � 2003, pp. 96-110.* Cited by examinerReferenced byCiting PatentFiling datePublication dateApplicantTitleUS7958360 *May 12, 2005Jun 7, 2011Microsoft CorporationMethod and system for performing an electronic signature approval process* Cited by examinerClassifications U.S. Classification707/783, 713/176, 707/802International ClassificationG06F17/30, H04L9/32, G06F7/00Cooperative ClassificationG06Q10/10, G06Q10/06European ClassificationG06Q10/10, G06Q10/06Legal EventsDateCodeEventDescriptionJun 10, 2005ASAssignmentOwner name: MICROSOFT CORPORATION, WASHINGTONFree format text: CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE S NAME PREVIOUSLY RECORDED ON REEL 016083 FRAME 0767;ASSIGNORS:LIND, JACOB;JENSEN, JAN LYSGAARD;REEL/FRAME:016118/0763Effective date: 20050511Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE S NAME PREVIOUSLY RECORDED ON REEL 016083 FRAME 0767. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT.;ASSIGNORS:LIND, JACOB;JENSEN, JAN LYSGAARD;REEL/FRAME:016118/0763Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE S NAME PREVIOUSLY RECORDED ON REEL 016083 FRAME 0767. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT;ASSIGNORS:LIND, JACOB;JENSEN, JAN LYSGAARD;REEL/FRAME:016118/0763Jun 1, 2005ASAssignmentOwner name: MICROSOFT CORPORACTION, WASHINGTONFree format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:LIND, JACOB;JENSEN, JAN LYSGAARD;REEL/FRAME:016083/0767Effective date: 20050511RotateOriginal ImageGoogle Home - Sitemap - USPTO Bulk Downloads - Privacy Policy - Terms of Service - About Google Patents - Send FeedbackData provided by IFI CLAIMS Patent Services©2012 Google