Order processing device, order processing method, and order processing program
The order processing device automates the checking of item combinations and notifies customers of incorrect orders, reducing manual labor and enabling efficient data entry.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- OBIC CO LTD
- Filing Date
- 2024-11-20
- Publication Date
- 2026-06-01
AI Technical Summary
Existing order processing systems require manual visual inspection to confirm correct combinations of parent and child items, leading to inefficiencies and the inability to automate data entry from analog methods like FAX and telephone orders.
An order processing device with a control unit that accesses masters for parent and child items, automatically checks for compatible combinations, and notifies customers of incorrect orders, allowing operators to update order details.
Reduces labor required for checking incorrect item combinations and enables automated data entry, improving operational efficiency and reducing manual work.
Smart Images

Figure 2026089548000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to an order processing device, an order processing method, and an order processing program.
Background Art
[0002] For example, when receiving an order from a retail store, the order may be received in combination of a parent item and a child item. Here, although a specific child item (for example, a member) only fits a parent item (for example, a device), the order may be placed with an incorrect combination of the parent item and the child item. As a conventional order receiving system, for example, there is Patent Document 1.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] However, conventionally, for these orders, visual inspection by a person is required, so all orders need to be confirmed by a person, and order data cannot be automatically received by the system, and there is a problem that it has not been possible to get rid of analog operations such as FAX and telephone orders.
[0005] The present invention has been made in view of the above, and an object thereof is to provide an order processing device, an order processing method, and an order processing program capable of saving the checking work when an order is placed with an incorrect combination when it is necessary to place an order by combining a parent item and a child item.
Means for Solving the Problems
[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides an order processing device equipped with a control unit, wherein the control unit is configured to access a storage area that stores a first master registered in association with a combination code and a parent item, and a second master registered in association with a combination code and a child item that matches the parent item, and is equipped with an order data import means that imports order data including a slip number, customer, order date, line, item, and amount, and for each slip number of the order data, refers to the first master, and if an item is registered as a parent item, refers to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists, and determines that the order is "on hold" if it does not exist, and otherwise determines that the order is "confirmed".
[0007] Furthermore, according to one aspect of the present invention, the order data acquisition means may create order data including a slip number, customer, order date, and order hold information indicating the decision result of the order, and order detail data including a slip number, line, item, and amount, and store these in the storage area based on the order data.
[0008] Furthermore, according to one aspect of the present invention, if the order data acquisition means determines that an order should be "held," it may also notify the customer accordingly.
[0009] Furthermore, according to one aspect of the present invention, the control unit may also include an order entry means that, in response to an operator's operation on the order entry screen, reads and displays order data and order detail data stored in the storage area based on specified extraction conditions, and updates the order hold information to "confirmed" by allowing the operator to modify the sub-items of the displayed order detail data when the order hold information is "hold".
[0010] Furthermore, according to one aspect of the present invention, the item may include goods or services, and the customer may include retail stores or sales agents.
[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides an order processing method executed by an information processing device equipped with a control unit, wherein the control unit is configured to access a storage area that stores a first master registered in association with a combination code and a parent item, and a second master registered in association with a combination code and a child item that matches the parent item, and the method includes an order data acquisition step which is executed in the control unit to acquire order data including a slip number, customer, order date, line, item, and amount, and for each slip number of the order data, it refers to the first master, and if an item is registered as a parent item, it refers to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists, and if it does not exist, it determines to "hold" the order, and otherwise determines to "confirm" the order.
[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is an order processing program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a storage area that stores a first master registered in association with a combination code and a parent item, and a second master registered in association with a combination code and a child item that matches the parent item, and the control unit is configured to take in order data including slip number, customer, order date, line, item, and amount, and for each slip number of the order data, it refers to the first master, and if an item is registered as a parent item, it refers to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists, and if it does not exist, it determines to "hold" the order, and otherwise determines to "confirm" the order, and the present invention is an order processing program to be executed by a computer. [Effects of the Invention]
[0013] According to the present invention, when it is necessary to order a combination of parent and child items, it is possible to reduce the labor required to check for incorrect combinations of orders. [Brief explanation of the drawing]
[0014] [Figure 1] Figure 1 is a diagram for explaining a specific example of a combination check target. [Figure 2] Figure 2 is a block diagram showing an example of the configuration of the order receiving processing apparatus according to the present embodiment. [Figure 3] Figure 3 is a diagram showing an example of the configuration of a product master. [Figure 4] Figure 4 is a diagram showing an example of the configuration of a parent product number master. [Figure 5] Figure 5 is a diagram showing an example of the configuration of a child product number master. [Figure 6] Figure 6 is a diagram showing a flowchart for explaining an overview of the entire processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 7] Figure 7 is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 8] Figure 8 is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 9] Figure 9 is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 10A] Figure 10A is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 10B] Figure 10B is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment. [Figure 10C] Figure 10C is a diagram for explaining a specific example of the processing of the control unit of the order receiving processing apparatus according to the present embodiment.
Embodiments for Carrying Out the Invention
[0015] Hereinafter, embodiments of an order receiving processing apparatus, an order receiving processing method, and an order receiving processing program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited by this embodiment.
[0016] [1. Summary] The summary of the present invention will be described in the order of [1-1. Background and problems] and [1-2. Solution method].
[0017] [1-1. Background and problems] For example, when receiving an order from a retail store, there are cases where the order is received in combination of a parent item and a child item. Here, although only a specific child item (for example, a member) is compatible with the parent item (for example, a device), there are cases where the order is placed with an incorrect combination of the parent item and the child item.
[0018] However, conventionally, for these orders, visual inspection by a person is required, so all orders need to be confirmed by a person, and order data cannot be automatically received by the system, and there is a problem that it has not been possible to get rid of analog operations such as FAX and telephone orders.
[0019] FIG. 1 is a diagram for explaining a specific example of combination check target. Specific examples of combination check targets include, for example, combinations of installation equipment and members such as a gas stove as a parent item and a gas hose as a child item. In addition, other examples of those that require combination check include combinations of a main contract plan of a mobile phone and options.
[0020] [1-2. Solution method] In the present invention, child items compatible with the parent item are registered in a master, and by using the master to judge (extract) an order that may be mis-ordered, the checking work in the case of an incorrect order is labor-saving, and systematic automatic import is realized.
[0021] Specifically, the present invention has the following functions. (1) A function of registering child items compatible with the parent item in a master and using the master to judge an order in the case of an incorrect order and putting it on hold temporarily (2) A function of notifying when there is a held order (3) A function that allows you to retrieve pending orders, make corrections if necessary, and then register them.
[0022] In this specification, "item" includes goods (e.g., equipment and components, furniture and components, etc.) or services (e.g., main contracts and option contracts in the carrier shop industry, insurance industry, etc.), and "customer" includes individuals, retailers (outside sales outlets), or sales agents. In the following description, "item" may also be referred to as part number, goods, or services.
[0023] In the following embodiment, we will explain the case where the parent item is a gas stove and the child item is a gas hose as an example.
[0024] [2. Structure] The configuration of the order processing device 100 according to this embodiment will be described with reference to Figure 2, etc. Figure 2 is a block diagram showing an example of the configuration of the order processing device 100 according to this embodiment.
[0025] The order processing device 100 is a commercially available desktop personal computer. However, the order processing device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.
[0026] As shown in Figure 2, the order processing device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the order processing device 100 is connected to communicate via any communication path.
[0027] The communication interface unit 104 connects the order processing device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the order processing device 100 with the server 200 and customer terminals 400, etc., so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network). The data stored in the storage unit 106, which will be described later, may also be stored in the server 200.
[0028] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 as the keyboard 112 or mouse 112. "Output" includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114. Furthermore, user operations on information displayed on the monitor 114 using the input device 112, etc., may be referred to as "user operation via UI".
[0029] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.
[0030] Furthermore, the storage unit 106 stores the product master 106a, parent product number master 106b, child product number master 106c, notification destination management master 106d, work table 106e, order data, order data, order detail data, etc. Figure 3 shows an example of the configuration of the product master 106a. Figure 4 shows an example of the configuration of the parent product number master 106b. Figure 5 shows an example of the configuration of the child product number master 106c.
[0031] As shown in Figure 3, the product master 106a can consist of tables that associate and register product codes and product names. The product master 106a is used by the control unit 102 when converting between product codes and product names.
[0032] As shown in Figure 4, the parent part number master (first master) 106b can consist of tables that register combination codes and products (product codes and / or product names) in association.
[0033] The child product number master (second master) 106c can be composed of tables, etc., that register combination codes and products (product codes and / or product names) in association, as shown in Figure 5.
[0034] The notification recipient management master 106d can be composed of tables that register customer information in association with email addresses.
[0035] The work table 106e is used by the control unit 102 as a work area and is for temporarily storing intermediate data, and for example, it includes a check work table. As will be described later, the order data acquisition unit 102b uses the check work table to execute hold judgment logic, etc.
[0036] Order data may include invoice number, customer, order date, line, product (product code and / or product name), quantity, unit price, and total amount.
[0037] Order data may include invoice number, customer, order date, and order hold information (1: held, 0: confirmed).
[0038] An example of order detail data is shown. The order detail data may include the invoice number, line number, product (product code and / or product name), quantity, unit price, and total amount. The order data and order detail data are linked by the invoice number.
[0039] The control unit 102 is a CPU or similar component that comprehensively controls the order processing device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.
[0040] The control unit 102 is configured to access the product master 106a, parent product number master 106b, child product number master 106c, notification destination management master 106d, work table 106e, order data, order data, order detail data, etc., which are stored in the storage unit 106. The product master 106a, parent product number master 106b, child product number master 106c, notification destination management master 106d, work table 106e, order data, order data, order detail data, etc. may be stored in another location (for example, server 200), as long as the control unit 102 can access them.
[0041] Functionally, the control unit 102 comprises a master maintenance unit 102a, an order data acquisition unit 102b, an order input unit 102c, and a screen display control unit 102d.
[0042] The master maintenance unit 102a performs editing such as inputting, adding, changing, and updating data for the product master 106a, parent product number master 106b, child product number master 106c, and notification destination management master 106d, for example, in response to the operator's operation on the master maintenance screen (not shown) displayed on the monitor 114.
[0043] The order data import unit 102b imports order data, including the slip number, customer, order date, line, item (product), and amount, from the customer's terminal 400, for example. For each slip number in the order data, it refers to the parent part number master 106b, and if an item is registered as a parent item, it refers to the child part number master 106c for the combination code associated with that parent item to determine whether or not a child item exists. If it does not exist, it determines that the order is "on hold"; otherwise, it determines that the order is "confirmed".
[0044] Furthermore, the order data import unit 102b creates order data, which includes the slip number, customer, order date, and order hold information indicating the decision result of the order, and order detail data, which includes the slip number, line, item, and amount, based on the order data, and stores them in the storage unit 106.
[0045] Furthermore, if the order data import unit 102b determines that an order should be "held," it may also notify the customer's terminal 400 via email or other means using the notification destination management master 106d.
[0046] The order entry unit 102c reads and displays order data and order detail data stored in the storage unit 106 based on specified extraction conditions in response to the operator's operation on the order entry screen. If the order hold information is "hold," the operator modifies the sub-items in the displayed order detail data to update the order hold information to "confirmed."
[0047] The screen display control unit 102d controls the display of various screens (for example, master maintenance screen, order entry screen, product search screen, etc.) on the monitor 114 and the acceptance of input on the screen.
[0048] [3. Specific Examples] A specific example of the processing performed by the control unit 102 of the order processing device 100 according to this embodiment will be described with reference to Figures 1 to 10C.
[0049] [3-1. Overall Processing] Figure 6 is a flowchart illustrating the overall processing flow of the control unit 102 of the order processing device 100. The overall processing flow of the control unit 102 of the order processing device 100 will be explained with reference to Figure 6.
[0050] In Figure 6, the master maintenance unit 102a performs master maintenance processing (step S1). Specifically, in the master maintenance processing, the master maintenance unit 102a sets data for the parent part number master 106b and the child part number master 106c in response to the operator's operation on, for example, a master maintenance screen (not shown) displayed on the monitor 114.
[0051] The order data import unit 102b executes the order data import process (step S2). Specifically, in the order data import process, the order data import unit 102b imports order data, including the slip number, customer, order date, line, item (product), and amount, from the customer's terminal 400, for example. For each slip number of the order data, it refers to the parent part number master 106b, and if an item is registered as a parent item, it refers to the child part number master 106c for the combination code associated with the parent item to determine whether or not an associated child item exists. If it does not exist, it determines that the order is "on hold"; otherwise, it determines that the order is "confirmed". The order data import unit 102b also creates order data, including the slip number, customer, order date, and order hold information indicating the result of the order determination, and order detail data, including the slip number, line, item, and amount, and stores them in the storage unit 106. Furthermore, if the order data import unit 102b determines that an order should be "held," it may also notify the customer's terminal 400 via email or other means using the notification destination management master 106d.
[0052] The order entry unit 102c executes the order entry process (step S3). Specifically, in response to the operator's operation on the order entry screen, the order entry unit 102c reads and displays the order data and order detail data stored in the storage unit 106 based on the specified extraction conditions. If the order hold information is "hold," the operator modifies the sub-items in the displayed order detail data to update the order hold information to "confirmed."
[0053] (3-2. Sample Data) Referring to Figures 7 to 10C, a specific example of the processing performed by the control unit 102 of the order processing device 100 will be explained. Figures 7 to 10C are diagrams illustrating a specific example of the processing performed by the control unit 102 of the order processing device 100.
[0054] (S1: Master Maintenance Processing) Refer to Figure 7 to explain a specific example of the master maintenance process. The master maintenance unit 102a sets data for the parent part number master 106b and the child part number master 106c in response to the operator's operation on the master maintenance screen displayed on the monitor 114, for example. In the master maintenance process, a combination of part number groups for the base equipment (main items) and part number groups for the components (child items) is set.
[0055] Figure 7(A) shows an example of data in the parent part number master 106b. The parent part number master 106b has fields for combination code, product code, and product name. In the example shown in the figure, the first row has combination code "A00001", product code "K00001R", and product name "Equipment 1 (Right side high power)", and the second row has combination code "A00001", product code "K00001L", and product name "Equipment 1 (Left side high power)".
[0056] Figure 7(B) shows an example of data for the child part number master 106c. The child part number master 106c has fields for combination code, product code, and product name. In the example shown in the figure, the first row has the combination code "A00001", product code "B00001_30", and product name "Part A (30cm)", and the second row has the combination code "A00001", product code "B00001_60", and product name "Part A (60cm)".
[0057] (S2: Order data import process) Referring to Figure 8, a specific example of the order data import process will be explained. The order data import unit 102b imports order data, including the invoice number, customer, order date, line, item (product), and amount, from the customer's terminal 400, for example. For each invoice number of the order data, it refers to the parent part number master 106b, and if an item is registered as a parent item, it refers to the child part number master 106c for the combination code associated with the parent item to determine whether or not a child item associated with it exists. If it does not exist, it determines that the order is "on hold"; otherwise, it determines that the order is "confirmed". The order data import unit 102b also creates order data, including the invoice number, customer, order date, and order hold information indicating the result of the order determination, and order detail data, including the invoice number, line, item, and amount, based on the order data, and stores them in the storage unit 106. Furthermore, if the order data import unit 102b determines that an order should be "held," it may also notify the customer's terminal 400 via email or other means using the notification destination management master 106d.
[0058] Figure 8(A) shows an example of order data. The order data may include invoice number, customer, order date, line, product code, quantity, unit price, and amount. In the example shown in the figure, the first line is invoice number "CHU001", customer "TOK001", order date "2024 / 09 / 20", line "1", product code "K00001R", quantity "3", unit price "120,000", amount "360,000", and the second line is invoice number "CHU001", customer "TOK001", order date "2024 / 09 / 20", line "2", product code "B00002_30", quantity "3", unit price "1,000", amount "3,000".
[0059] For invoice number "CHU001", the product codes are "K00001R" and "B00002_30". Product code "K00001R" is registered in the parent product code master 106b, and for the combination code "A00001" of product code "K00001R", product code "B00002_30" is not registered in the child product code master 106c, so the order is determined to be "on hold".
[0060] For invoice number "CHU002", the product codes are "K00002L" and "B00001_120". Product code "K00002L" is registered in parent product code master 106b, and for the combination code "A00001" of product code "K00002L", product code "B00001_120" is registered in child product code master 106c. Therefore, the order is determined to be "confirmed".
[0061] For invoice number "CHU003", the product code is "K00001L". Product code "K00001L" is registered in the parent product code master 106b, but there is no child product code, so the order is determined to be "on hold".
[0062] For invoice number "CHU004," the product code is "K00003R." Since product code "K00003R" is not registered in the parent product code master 106b, no check is required, and the order is judged as "confirmed." The detailed logic for determining whether an order should be held will be described later.
[0063] Figure 8(B) shows an example of order data. The order data may include the invoice number, customer, order date, and order hold information (1: held, 0: confirmed). In the example shown in the figure, the first row contains the invoice number "CHU001", customer "TOK001", order date "2024 / 09 / 20", line "1", product code "K00001R", quantity "3", unit price "120,000", and amount "360,000". The second row contains the invoice number "CHU001", customer "TOK001", order date "2024 / 09 / 20", line "2", product code "B00002_30", quantity "3", unit price "1,000", and amount "3,000".
[0064] The order data import unit 102b sends an email notification to customer "TOK001" terminal 400 stating that the order hold information for slip numbers "CHU001" and "CHU003" is "1: Hold".
[0065] Figure 8(C) shows an example of order detail data. Order detail data may include invoice number, line, product code, quantity, unit price, and amount. In the example shown in the figure, the first line is invoice number "CHU001", line "1", product code "K00001R", quantity "3", unit price "120,000", and amount "360,000", and the second line is invoice number "CHU001", customer "TOK001", line "2", product code "B00002_30", quantity "3", unit price "1,000", and amount "3,000".
[0066] Figure 8(D) is a diagram illustrating the notification recipient management master 106d. The notification recipient management master 106d contains an email address registered for each customer.
[0067] (S9: Order entry processing) Refer to Figure 9 to explain a specific example of order entry processing. The order entry unit 102c reads and displays order data and order detail data stored in the storage unit 106 based on specified extraction conditions in response to the operator's operation on the order entry screen. If the order hold information is "hold," the order hold information is updated to "confirmed" by the operator modifying the sub-items in the displayed order detail data. In order entry processing, the order data and order detail data are read on the order entry screen, and if modifications are necessary, the order can be confirmed by changing and updating the order detail data. If no changes are necessary, the order can be registered as "confirmed" by updating without making any changes.
[0068] Figure 9(A) shows an example of the order entry screen 500 before the revision. Figure 9(B) shows an example of the product search screen 600, and Figure 9(A) shows an example of the order entry screen 500 before the revision.
[0069] The order entry screen 500 includes a header area 501 with fields for specifying extraction criteria for order number (invoice number), customer, and order date, and an area for displaying the status of order hold information; a detail information area 502 for displaying order detail data that matches the extraction criteria; an unillustrated "Display" button for extracting and displaying order data and order detail data that match the extraction criteria; an unillustrated "Update" button for confirming the order with the content entered on the screen; and an unillustrated "Product Search" button for displaying the product search screen 600.
[0070] When extraction criteria are specified and the "Display" button is pressed, the order data and order detail data stored in the storage unit 106 are extracted using the specified extraction criteria as the key, the status is displayed in the header area 501, and the order detail data is displayed in the detail information area 502.
[0071] When the "Product Search" button is pressed, the product search screen 600 is displayed. On the product search screen 600, by specifying the parent product number in the header 601, the child product numbers associated with the combination code specified in the parent product number master 106b are displayed in the details 602, as shown in the child product number master 106c. In this way, when making corrections, by specifying the parent product number on the product search screen 600, only the relevant child product numbers can be displayed, and the child product numbers can be corrected by looking at this display.
[0072] In this example, when the operator specifies the order number "CHU001", customer "TOK001:□△ Industries", and order date "2024 / 09 / 20", and presses the "Display" button, the order data and order detail data (the first line of the order data in Figure 8(B), and the first and second lines of the order detail data in Figure 8(C)) stored in the memory unit 106 are extracted using the specified extraction conditions as keys, the status "Pending" is displayed in the header area 501, and the detail information area 502 displays the following in the first line: product code "K00001R", quantity "3", unit price "120,000", amount "360,000", and in the second line: product code "B00002_30", quantity "3", unit price "1,000", amount "3,000".
[0073] Additionally, on the product search screen 600, when the parent product number "K00001R" is specified, the child product numbers "B00001_30", "B00001_60", "B00001_90", and "B00001_120" are displayed. The operator can view these child product numbers and change the status from "On Hold" to "Confirmed" in the details information area 502 by correcting them to the child product numbers associated with the parent product number.
[0074] In the example shown in Figure 9(C), the operator changes the product code "B00002_30" in the details information area 502 to "B00001_30", which is associated with the parent product code "K00001R". When the "Update" button is pressed, the order hold information in the first row of the order data in Figure 8(B) is updated from "1: Hold" to "0: Confirmed", and the product code in the second row of the order details data in Figure 8(C) is updated from "B00002_30" to "B00001_30".
[0075] (Logic for deciding to hold) The hold decision logic for the order data import process S2 described above will be explained with reference to Figures 10A to 10C. The order data import unit 102b uses the check work table of work table 106e to execute the following hold decision logic.
[0076] (1) Combine the order data with the parent part number master 106b and retrieve the documents to be checked. Figure 10A(A) shows the order data. Figure 10A(B) shows the parent part number master 106b.
[0077] As shown in Figure 10(C), the details of the parent part number to be checked, registered in the parent part number master 106b, are extracted from the order data. For the slip numbers included in these details, all details are obtained and expanded into the check work table as shown in Figure 10(D). The check work table has the following fields: slip number, customer, order date, line, product code, quantity, unit price, amount, combination code, and child part number check (child part number: 0, not a child part number: 1). At this stage, the "child part number check" is blank.
[0078] (2) On the check work table, check the presence or absence of the child part number in the child part number master 106c based on the combination code. Figure 10B shows the work table used for checking after the sub-part number check.
[0079] (3) If there are no records on the check work table that are slips and have a sub-part number check of 1, the records will be imported as pending. Figure 10C shows the data to be imported.
[0080] As described above, according to this embodiment, a parent part number master 106b is registered by associating a combination code with a parent item, a child part number master 106c is registered by associating a combination code with a child item that matches the parent item, and an order data import unit 102b is provided that imports order data including the slip number, customer, order date, line, item, and amount, and for each slip number of the order data, it refers to the first master, and if an item is registered as a parent item, it refers to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists, and if it does not exist, it determines that the order is "on hold", and otherwise determines that the order is "confirmed".
[0081] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.
[0082] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0083] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0084] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.
[0085] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.
[0086] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.
[0087] Furthermore, with respect to the order processing device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.
[0088] For example, the processing functions of the order processing device 100, particularly those performed by the control unit 102, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the order processing device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0089] Furthermore, this computer program may be stored on an application program server connected to the order processing device 100 via any network, and it is possible to download all or part of it as needed.
[0090] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.
[0091] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.
[0092] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.
[0093] Furthermore, the order processing device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the order processing device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.
[0094] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]
[0095] 100 Order Processing System 102 Control Unit 102a Master Maintenance Department 102b Order Data Import Section 102c Order Entry Section 102d Screen display control unit 104 Communication Interface Section 106 Storage section 106a Product Master 106b Parent Part Number Master 106c Sub-part number master 106d Notification Destination Management Master 106e Work Table 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks 400 devices
Claims
1. An order processing device equipped with a control unit, The control unit, The first master, which is registered by associating the combination code with the parent item, A second master is registered by associating the combination code with the child item that matches the parent item, It is configured to allow access to the memory area that stores it, An order processing device characterized by comprising order data import means, which imports order data including invoice number, customer, order date, line, item, and amount; for each invoice number of the order data, it refers to the first master, and if an item is registered as a parent item, it refers to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists, and if it does not exist, it determines that the order is "on hold", and otherwise determines that the order is "confirmed".
2. The order processing device according to claim 1, characterized in that the order data acquisition means creates order data including a slip number, customer, order date, and order hold information indicating the result of the order determination, and order detail data including a slip number, line, item, and amount, based on the order data, and stores them in the storage area.
3. The order processing device according to claim 1 or 2, characterized in that the order data acquisition means notifies the customer if it determines that the order is "on hold".
4. The control unit further, The order processing device according to claim 2, characterized in that it includes an order entry means that, in response to an operator's operation on the order entry screen, reads and displays order data and order detail data stored in the storage area based on specified extraction conditions, and updates the order hold information to "confirmed" when the order hold information is "hold" by allowing the operator to modify the sub-items of the displayed order detail data.
5. The order processing device according to claim 1, characterized in that the items include goods or services, and the customers include retail stores or sales agents.
6. An order processing method executed by an information processing device equipped with a control unit, The control unit, The first master, which is registered by associating the combination code with the parent item, A second master is registered by associating the combination code with the child item that matches the parent item, It is configured to allow access to the memory area that stores it, The control unit is executed as follows: An order processing method characterized by including an order data import step, which involves importing order data including invoice number, customer, order date, line, item, and amount; referring to the first master for each invoice number of the order data; and, if an item is registered as a parent item, referring to the second master for the combination code associated with the parent item to determine whether or not an associated child item exists; and determining that the order is "on hold" if it does not exist, or "confirmed" otherwise.
7. An order processing program to be executed by an information processing device equipped with a control unit, The control unit, The first master, which is registered by associating the combination code with the parent item, A second master is registered by associating the combination code with the child item that matches the parent item, It is configured to allow access to the memory area that stores it, The control unit, An order processing program that causes a computer to execute an order data import process, which involves importing order data including invoice number, customer, order date, line, item, and amount; referring to the first master for each invoice number of the order data; and, if an item is registered as a parent item, referring to the second master for the combination code associated with that parent item to determine whether or not an associated child item exists; and determining whether the order is "held" if it does not exist, or "confirmed" otherwise.