Pre-processor for inbound sales order requests with link to a third party available to promise (ATP) system

• US 7,606,742 B2
• Filed: 04/30/1999
• Issued: 10/20/2009
• Est. Priority Date: 04/30/1999
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gopalan, Balasubramanian, Krishnamurthy, Jayakumar, Bright, Marion Scott, Peachey-Kountz, Penny Jeannette, Scott, James Donald, McKee, Gregory Lee, Michel, Sylvain, Joshipura, Jinraj Dhruvakumar, Channikere, Pushpalatha, Jindani, Rahul, Kannoth, Vinod
• Primary Examiner(s): Gart; Matthew S.
• Assistant Examiner(s): ADE, OGER GARCIA
• Application Number:
  US09/303,368
• Publication Number:
  US 20020013731A1
• Time in Patent Office: 3,826 Days
• Field of Search: 705/28, 705/5, 705/6, 705/16, 705/20, 705/21, 705/22, 705/26
• US Class Current: 705/28
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 10/0875 Itemisation or classification of parts, supplies or services, e.g. bill of materials
• CPC Class Codes: G06Q 20/20 Point-of-sale [POS] network systems
• CPC Class Codes: G06Q 20/203 Inventory monitoring
• 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 30/0613 Third-party assisted

Abstract

A method and apparatus for pre-processing electronic data requests within the EDI subsystem layer and within the order fulfillment application system. An order interceptor, third-party Available To Promise (ATP) interface, pseudo-sales order workbench, and the reject acknowledgment system processes are provided within the order fulfillment application system to accomplish the pre-processing. The order interceptor performs an asynchronous availability check before a sales order is posted. The result of the ATP check is stored in an ESO, and is applied during the posting process with unique user exits. The result of the ATP check is also used to determine key information about the sales order, such as the sales organization, and division and distribution channels. The pre-processor uses business rules to determine if the ESO should be split into multiple documents for requests satisfied across multiple sales areas. The Workbench provides a customer purchase order view of the ESO that looks, feels and behaves like actual order entry screens. The Workbench also displays messages generated from the pre-processor describing why the ESO was held for review. After the condition is corrected the Workbench re-executes the ESO pre-processor. This continues until all messages are corrected or marked reviewed. The supplier can decide to either accept the request, reject the request or accept individual line items.

Claims

1. A system for pre-processing orders before they are transmitted to an order processing system, comprising:

an order interceptor receiving and pre-processing electronic sales order data prior to transmitting to the order processing system, the order interceptor being capable of adding, changing and deleting electronic sales order data, wherein changes to an electronic sales order are logged so as to provide an audit trail of activity;

an interface system receiving the electronic sales order data from the order interceptor and performing an availability check, wherein the availability check determines the portions of the electronic sales order data that can be satisfied; and

means for transmitting at least a portion of the electronic sales order data to the order processing system for order processing.

2. The system of claim 1, wherein the order interceptor comprises:

means for translating the electronic sales order data to an internal format of the order interceptor;

means for determining if an availability check is required;

means for transmitting at least a portion of the electronic sales order data;

means for determining if there are any processing problems associated with the electronic sales order data; and

means for processing the electronic sales order data in accordance with business rules.

3. The system of claim 1, further comprising a workbench receiving electronic sales order data that contains errors or is incomplete.

4. The system of claim 3, wherein the workbench comprises:

a) means for displaying electronic sales order data that contains errors or is incomplete;

b) means for displaying error messages associated with the electronic sales order data of step a); and

c) means for correcting, editing, and updating the at least one database containing electronic sales order data.

5. The system of claim 4, wherein the workbench further comprises:

means for displaying the status of the electronic sales order data;

means for determining if the configuration rules are satisfied; and

means for indicating to the order interceptor that at least a portion of the electronic order data is rejected.

6. The system of claim 1, further comprising a reject acknowledgment system receiving an indication from the order interceptor that at least a portion of the electronic sales order data has been rejected.

7. The system of claim 6, wherein the reject acknowledgment system comprises:

means for updating the at least one database to indicate the portions of the electronic order data that have been rejected.

8. The system of claim 7, wherein the reject acknowledgment system further comprises:

means for determining if the electronic sales order data was received via a transmission from the World Wide Web; and

means for updating the at least one database in either an ESO format or an SAP format.

9. The system of claim 1, wherein the order interceptor receives the electronic sales order data in a standard Electronic Data Interchange (EDI) format.

10. The order interceptor system of claim 1, wherein the system is an SAP system.

11. The order interceptor system of claim 1, wherein the order interceptor determines if any processing problems are present and, if so, creates a workflow item that can be reviewed and modified prior to transmitting to the order processing system.

12. The order interceptor system of claim 1, wherein the order interceptor validates an accuracy of the electronic sales order at the different stages prior to transmitting to the order processing system.

13. The order interceptor system of claim 1, wherein the order interceptor processes data by customer specific business rules prior to transmitting to the order processing system.

14. The order interceptor system of claim 13, wherein the order interceptor ensures all attributes are present and accurate in the electronic sales order prior to transmitting to the order processing system.

15. The order interceptor system of claim 1, wherein the order interceptor allows correction of problems in the electronic sales order in a prior to transmitting to the order processing system.

16. The order interceptor system of claim 1, wherein the electronic sales order data is a proposed customer order.

17. A system for pre-processing orders before they are transmitted to an order processing system, comprising:

an order interceptor receiving and pre-processing electronic sales order data prior to transmitting to the order processing system, wherein pre-processing the electronic sales order includes splitting the electronic sales order into at least two separate requests prior to transmitting to the order processing system;

an interface system receiving the electronic sales order data from the order interceptor and performing an availability check, wherein the availability check determines the portions of the electronic sales order data that can be satisfied; and

means for transmitting at least a portion of the electronic sales order data to the order processing system for order processing.