Integrated business-to-business Web commerce and business automation system

• US 6,115,690 A
• Filed: 12/22/1997
• Issued: 09/05/2000
• Est. Priority Date: 12/22/1997
• Status: Expired due to Term

• Current Assignee: Big Baboon, Inc.
• Original Assignee: Charles Wong
• Inventors: Wong, Charles
• Primary Examiner(s): Cosimano, Edward R.
• Assistant Examiner(s): Alvarez, Raquel
• Application Number:
  US08/995,591
• Time in Patent Office: 988 Days
• Field of Search: 235/380, 364/468.02, 364/468.14, 364/468.21, 364/479.06, 364/479.07, 364/479.08, 364/705.06, 364/709.06, 705/34, 705/1, 705/30, 705/7, 705/8
• US Class Current: 705/7.27
• CPC Class Codes: G06Q 10/0633 Workflow analysis
• CPC Class Codes: G06Q 10/06375 Prediction of business process outcome or impact based on a proposed change
• CPC Class Codes: G06Q 10/0639 Performance analysis of employees; Performance analysis of enterprise or organisation operations
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 40/12 Accounting
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A software system business-to-business Web commerce (Web business, or e-business) and automates to the greatest degree possible, in a unified and synergistic fashion and using best proven business practices, the various aspects of running a successful and profitable business. Web business and business automation are both greatly facilitated using a computing model based on a single integrated database management system (DBMS) that is either Web-enabled or provided with a Web front-end. The Web provides a window into a "seamless" end-to-end internal business process. The effect of such integration on the business cycle is profound, allowing the sale of virtually anything in a transactional context (goods, services, insurance, subscriptions, etc.) to be drastically streamlined.

Claims

1. An automated end-to-end business process for product sales that uses a relational database management system, the process comprising the steps of:

a first user inputting a sales record to the database for an order of a customer;

automatically generating a customer invoice;

a second user inputting a customer payment record to the database, wherein system privileges of the first user and the second user are at least partially mutually exclusive;

automatically determining a status of the customer payment as reconciled or not reconciled; and

during each of the foregoing inputting steps, qualifying user inputs using experiential constraints, based on the then-current state of the database as a whole.

2. The method of claim 1, wherein the process uses a single database described by a single database schema.

3. The method of claim 1, wherein the business process is based on a virtual-inventory model for the sale of tangible goods, the process comprising the further steps of:

a third user placing a purchase order for goods in accordance with the sales record and inputting purchasing information to the database;

automatically generating a vendor invoice record; and

a fourth user receiving the goods.

4. The method of claim 3, comprising the further step of, during the inputting of purchasing information, qualifying user inputs using experiential constraints, based on the then-current state of the database as a whole.

5. The method of claim 3, wherein system privileges of the first, second, third and fourth users are at least partially mutually exclusive.

6. The method of claim 3, wherein the database contains a Sales Record file, a related Items Sold file containing a single consolidated record for a quantity of multiple identical items, and a related Item Details file containing a separate record for each separate item of said quantity, wherein receiving the goods comprises:

automatically determining a group of Sales Records having Items Sold not yet fully received;

selecting within the database a Sales Record from said group of Sales Records and selecting from the Sales Record a related Items Sold record; and

for each separate item of said quantity, inputting a serial number from an item of the physical goods into a field within a separate Item Details record.

7. The method of claim 3, wherein the at least some of the goods require assembly or installation, the process comprising the further steps of:

during order entry, the first user inputting installation instructions and identifying items required to be shipped together to the customer.

8. The method of claim 7, comprising the further step of, during the inputting of installation instructions, qualifying user inputs using experiential constraints, based on the then-current state of the database as a whole.

9. The method of claim 7, comprising the further step of automatically adding to the customer invoice an installation charge.

10. The method of claim 7, comprising the further step of, when an item together with any other item required to be shipped together with it to the customer have been received, automatically generating at least one of a shipping worksheet and a packing slip.

11. The method of claim 3, comprising the further steps of:

inputting to the database actual vendor invoice information; and

automatically determining a status of the vendor invoice as reconciled or not reconciled.

12. The method of claim 11, comprising the further step of automatically determining a detailed status of non-reconciled vendor invoices in accordance with a plurality of categories of discrepancies.

13. The method of claim 12, wherein a vendor invoice may belong to a plurality of categories of discrepancies, the method comprising the further step of sorting vendor invoices in accordance with a hierarchy of discrepancies such that a vendor invoice having both a discrepancy higher in the hierarchy and a discrepancy lower in the hierarchy is sorted into a group of vendor invoices belonging to the discrepancy of the higher category.

14. The method of claim 13, comprising the further steps of:

for a non-reconciled vendor invoice, inputting to the database a Vendor Expected Credit record;

offsetting an amount of the Vendor Expected Credit against the non-reconciled vendor invoice; and

changing the status of the non-reconciled vendor invoice to reconciled.

15. The method of claim 1, comprising the further steps of:

at intervals, performing a suite of database checks using experiential constraints;

detecting a condition requiring user attention;

identifying a user responsible for attending to the condition; and

automatically reporting the condition to the identified user.

16. The method of claim 15, comprising the further steps of:

detecting an error;

troubleshooting the error; and

adding to the system an additional experiential constraint to prevent future occurrences of the error.

17. The method of claim 1, comprising the further step of inputting to the database a Return Merchandise Authorization record relating to a sales record, the Return Merchandise Authorization record specifying one of a plurality of return types.

18. The method of claim 17, wherein return types includes a plurality of the following types:

credit, replacement, and warranty.

19. The method of claim 17, comprising the further step of automatically completing selected fields of the Return Merchandise Authorization record as being not applicable in accordance with the specified return type.

20. The method of claim 17, comprising the further step of automatically grouping a sales record to which the Return Merchandise Authorization pertains with sales records having one or more items to be received.

21. The method of claim 20, comprising the further steps of:

receiving a returned item; and

automatically generating a credit memo for said returned item.

22. The method of claim 1, comprising the further steps of:

receiving a Return Merchandise Authorization request via a global computer network, the request specifying return type;

evaluating the request based on a plurality of stored criteria in accordance with the return type; and

if the applicable criteria are met, automatically assigning, and communicating to a user via the global computer network, a return authorization number.

23. The method of claim 1, wherein the sales record includes a ship-to address, the process comprising the further steps of:

automatically retrieving an applicable sales tax rate based on the ship-to address and generating a sales tax record; and

from a multiplicity of sales tax records pertaining to a tax reporting period, automatically generating a tax return.

24. The method of claim 1, wherein the sales record identifies a sales representative, the process comprising the further steps of:

automatically retrieving an applicable commission rate based on the sales representative; and

from a multiplicity of sales records pertaining to a pay period, automatically generating a commission total for each of a plurality of sales representatives.

25. The method of claim 1, comprising the further steps of:

identifying multiple persons each having a role in a sales transactions; and

computing separate commissions for each of said multiple persons.

26. The method of claim 1, comprising the further steps of:

at periodic intervals automatically posting general ledger accounting entries for transactions posted since the previous interval, including sales and customer payments; and

at a time determined by a user, automatically generating a financial statement indicative of at least one of profit/loss and cashflow.

27. The method of claim 26, wherein said periodic intervals are user-scheduled.

28. The method of claim 26, wherein said time is scheduled by the user in advance.

29. The method of claim 26, wherein said time is any time at which the user inputs a predetermined command.

30. The method of claim 1, comprising the further steps of, for each of said first user and said second user:

determining performance measurements quantifiable using data stored within the single database; and

automatically calculating and maintaining a history of said performance measurements.

31. The method of claim 1, wherein sales record information is accessible remotely via a global computer network by authorized users.

32. The method of claim 1, wherein customer invoice information is accessible remotely via a global computer network by authorized users.

33. The method of claim 32, comprising the further step of displaying for an open invoice detailed payment status information.

34. The method of claim 32, comprising the further step of displaying for an open invoice detailed payment status information including a reason for non-payment.

35. The method of claim 1, wherein vendor invoice information is accessible remotely via a global computer network by authorized users.

36. A method of integrating business automation across multiple business domains and automatically reflecting automated business activities of one business domain within another business domain, the method comprising the steps of:

providing a Web-enabled, client/server relational database management system storing a database described by a single database schema including files belonging to each of a first business domain dealing with products and a second business domain dealing with payments; and

a user making modifications to a record within a file belonging to the first business domain, the database management system in response thereto automatically reflecting said modifications within files belonging to the second business domain.

37. The method of claim 36, wherein the database further includes files belonging to a third business domain dealing with financial performance, the database management system, in response to a user making modifications to a record within a file belonging to one of the first and second business domains, automatically reflecting said modifications within a file belong to the third business domain.

38. The method of claim 37, wherein the database further includes files belonging to a fourth business domain dealing with personnel, wherein the database management system automatically alters a record of an employee or contractor having responsibilities within one or more of said first, second and third business domains by referencing records within files belong to said one or more of said first, second and third business domains.

39. The method of claim 36, comprising the further step of, at regular intervals, performing cross-checks between records of files belonging to different business domains.

40. The method of claim 39, wherein said cross-checks are performed during a nightly update routine.

41. The method of claim 36, comprising the further step of establishing and enforcing a division of responsibilities between different users of the database management system.

42. The method of claim 41, wherein each user within a group of users is assigned to a single business domain and is allowed to change only records of files belonging to that business domain.

43. A method of business-to-business Web commerce between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, the method comprising the steps of:

storing user privileges for a plurality of user authorized by the purchaser to act on its behalf;

authenticating and determining a privilege level of a user;

the user entering product parameters;

identifying products in accordance with the product parameters and displaying product information for the products;

the user selecting at least one product from the displayed product information and requesting a price quote for the product;

producing and displaying a price quote for the product, the price quote including a quote number; and

storing the price quote within the database for future reference.

44. The method of claim 43, wherein the process uses a single database described by a single database schema.

45. In a system for business-to-business Web commerce system between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, a method of maintaining and updating a multi-vendor product list, comprising the steps of:

a user selecting a baseline vendor;

electronically retrieving product information from the baseline vendor;

electronically retrieving product information from at least one additional vendor;

comparing product information from said additional vendor with product information from the baseline vendor; and

if an identical product is offered by both the baseline vendor and said additional vendor, consolidating information from both the baseline vendor and the additional vendor into a common record for display.

46. The method of claim 45, wherein the process uses a single database described by a single database schema.

47. The method of claim 45, further comprising:

producing a baseline electronic catalog;

updating the baseline electronic catalog to produce an updated baseline electronic catalog;

performing comparison of the updated baseline electronic catalog and a prior baseline electronic catalog; and

based on the comparison flagging at least one of new products, products the price of which has changed, and discontinued products.

48. The method of claim 47, wherein the electronic catalog includes different categories of items including at least component items and items that receive component items.

49. The method of claim 47, wherein at least one of new products, products the price of which has changed, and discontinued products are flagged within an Approved Products List of a specific customer.

50. A method of business-to-business Web commerce between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, the method providing for merchandise returns, comprising the steps of:

storing in the database a record for each item sold;

authenticating a user;

using a flexible product identification procedure, the user entering information identifying at least one item of merchandise to be returned for which a record is stored in the database;

using the record stored in the database, creating a return record and notifying a representative authorized by the supplier to approve returns;

approving the return and assigning a Return Merchandise Authorization number to the return record; and

communicating to the user the Return Merchandise Authorization number.

51. The method of claim 50, wherein the process uses a single database described by a single database schema.

52. The method of claim 50, wherein communicating comprises sending to the user an electronic message including the Return Merchandise Authorization number.

53. The method of claim 50, wherein the user entering information identifying at least one item of merchandise to be returned occurs via the Web.

54. In a system for business-to-business Web commerce system between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, a method of tracking financial information on a real-time basis and automatically generating a general ledger of accounts, the method comprising the steps of:

automatically posting transactions by making corresponding general ledger entries continuously or at programmed intervals; and

automatically posting adjusting entries when records pertaining to transactions that have already been posted are modified.

55. The method of claim 54, wherein the process uses a single database described by a single database schema.

56. In a system for business-to-business Web commerce system between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, a method of processing accounts, the method comprising the steps of:

storing in the database customer invoices and vendor invoices;

identifying open vendor invoices;

applying a set of rules to the open vendor invoices and related records, including classifying and grouping the open vendor invoices in accordance with a hierarchy of experiential classifications; and

forming a determination based on the set of rules whether or not a group of open invoices should be paid.

57. The method of claim 56, wherein the process uses a single database described by a single database schema.

58. In a system for business-to-business Web commerce system between a first business acting as supplier and a second business acting as purchaser, using a computer net including a relational database server, a method of employee evaluation comprising the steps of:

collecting activity information as activities occur and storing it in the database;

determining a computer-generated, data-based performance norm for an individual or entity; and

automatically producing an electronic evaluation report based on the activity information and the data-based norm.

59. The method of claim 58, wherein the process uses a single database described by a single database schema.

60. The method of claim 58, comprising the further step of communicating via a global computer network the electronic employee evaluation report via a global computer network to at least one of the employee to whom the electronic employee evaluation report pertains and authorized supervisory personnel.

61. The method of claim 58, further comprising displaying an evaluation report via the Web.

62. The method of claim 58, further comprising displaying for ready comparison activity information and resulting performance information, whereby the contribution of different activities to performance can be guaged by users.

63. In a relational database system, a method of displaying information, comprising the steps of:

for each of a plurality of base tables, identifying at least one related table;

providing a related switch GUI control displayed in conjunction with display of each of said plurality of base tables, for selecting a related table;

displaying records of one of said plurality of base tables;

a user selecting at least one record;

using said GUI control, said user selecting a related table;

performing a search to identify records in the related table that are related to said at least one record; and

displaying records of said related table identified by said search.

64. In a relational database business automation system, a method of displaying information so as to facilitate user manipulation and interaction, comprising the steps of:

producing a workscope/workflow structured display of complex database records each comprising multiple lines of text and pertaining to both a first party to a business transaction and a second party to the business transaction, the structured display constituting an integrated decision-making environment for a particular business function; and

providing a GUI control displayed in conjunctions with said workscope/workflow structured display of complex database records;

a user selecting at least one of said complex database records; and

the user activating the GUI control, wherein activation of the GUI control has at least one of the following effects;

taking a prescribed action in relation to the selected record and changing at least one field of said record within said database;

changing the display to a functionally-related display; and

bringing up a pop-up screen through which data may be entered, changing at least one field of said record within said database, the pop-up screen only partially obscuring said workscope/workflow structured display.

65. A method of order fulfillment using a relational database system in which customer order information and vendor order information are stored, comprising the steps of:

displaying customer order items for which vendor orders have not been placed;

enabling a user to, in accordance with a user command, sort customer order items by the following categories;

item sold, vendor and availability;

grouping a plurality of customer order items;

placing a single vendor order corresponding to a group of customer order items; and

refreshing the display so as to remove one or more groups of items from the display.

66. The method of claim 65, comprising the further steps of:

storing within the database information identifying items that must be shipped together;

grouping items having a backorder status;

placing vendor orders for customer order items having backorder status; and

removing from the display items that must be shipped together with an ordered item having backorder status.

67. The method of claim 65, comprising the further step of preparing records of ordered items so that the ordered items can be received.

68. The method of claim 67, comprising the further steps of:

receiving ordered items and changing item records to reflect receipt; and

preparing records of received items for installation.

69. The method of claim 68, comprising the further steps of:

installing received items; and

preparing records of installed items for shipping.

70. The method of claim 69, comprising the further steps of:

shipping installed items; and

changing item records to reflect shipment.

71. The method of claim 68, wherein placing the vendor order comprises communicating corresponding vendor order information to the appropriate vendor via a global computer network.

72. The method of claim 65, wherein said grouping includes both automatic grouping based on customer instructions obtained via the Web and manual grouping performed for convenience and efficiency in purchasing.

73. The method of claim 72, wherein said grouping includes logistics-derived. implicit grouping.

74. A method of handling sales returns over a global computer network, comprising the steps of:

receiving a Return Merchandise Authorization request via a global computer network, the request specifying return type;

evaluating the request based on a plurality of stored criteria in accordance with the return type; and

if the applicable criteria are met, automatically assigning, and communicating to a user via the global computer network, a return authorization number.

75. In a business-to-business automated Web commerce system, a method of specifying complex installation instruction regarding a plurality of purchase items using a graphical user interface, the method comprising the steps of:

selecting a first primary item;

selecting one or more secondary items to be installed with said first primary item;

selecting a second primary item; and

selecting one or more secondary items to be installed with said second primary item.

76. The method of claim 75 wherein selecting said items occurs via the Web.

77. An automated business process for product sales that uses a Web-enabled relational database management system to automate an integrated supply chain including a seller and a plurality of vendors, the process comprising the steps of:

a seller placing vendor orders and entering order information into the database, the orders being communicated to the vendors through a global computer network;

the seller receiving the orders in whole or in part and entering receiving information into the database;

the vendors accessing receiving information through the global computer network to ensure prompt receipt of orders;

the seller requesting return of selected order items; and

the vendors accessing return information through the global computer network and in response thereto communicating return merchandise authorization numbers to the seller through the global computer network.

78. The method of claim 77, wherein the process uses a single database described by a single database schema.

79. The method of claim 77, comprising the further steps of:

customers placing customer orders with the seller through the global computer network; and

customers accessing order tracking information through the global computer network.

80. The method of claim 79, comprising the further step of customers and vendors accessing invoice information through the global computer network.

81. A method of order fulfillment, comprising the steps of:

placing an order for a part;

entering the order within a Web-enabled relational database system;

tracking each significant event in the order fulfillment process within the relational database system; and

communicating the order status to at least one party via the Web.

82. The method of claim 81, wherein the order status is communicated using Web pull technology.

83. The method of claim 81, wherein the order status is communicated using Web push technology.

84. A method of automating an end-to-end business process using a software program running on a relational database system, comprising the steps of:

as data is entered into the relational database system, qualifying data entries in accordance with a stored knowledge base;

producing a workscope/workflow structured display of complex database records, the structured display constituting a decision-making environment for a particular business function, and displaying data together with GUI controls in such as way as to allow a user to readily change the status of a record within the relational database system in way determined by the stored knowledge base; and

based on the experience of users using the software program, altering the stored knowledge base so as to increase the stored knowledge base.

85. The method of claim 84, wherein data is entered only once at a limited number of controlled points of entry.