Ordering and order receiving management device, ordering and order receiving management method, and ordering and order receiving management program
The order management device addresses the challenge of differing product codes between sales and purchasing departments by using a control unit with part number masters and conversion history, enabling efficient order management and code conversion, thus simplifying the order placement process.
Patent Information
- Application Number
- JP2023168659
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-09-28
- Publication Date
- 2025-04-09
AI Technical Summary
Existing order management systems face challenges in efficiently replacing product codes for ordered items between the sales and purchasing departments, especially when multiple ordered items are required for a single order or vice versa, leading to a high burden on personnel.
An order management device equipped with a control unit that includes a sales part number master, a purchasing part number master, and a part number conversion history master, which allows for the extraction and conversion of ordered part number codes, enabling the creation of arrangement data and efficient order placement even with differing part codes between departments.
The system enables easy replacement of order item codes with ordered item codes, facilitates the creation of arrangement data, and simplifies the order placement process, even when part codes differ between the sales and purchasing departments, thereby reducing the workload and improving efficiency.
Smart Images

Figure 2025058619000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to an order management device, an order management method, and an order management program. [Background technology]
[0002] In order management, the part number code of the ordered item managed by the sales department that receives the order may differ from the part number code of the procured item managed by the purchasing department that arranges for the ordered item. In such cases, the purchasing department staff creates purchase orders by replacing the procured part number code. Also, there are cases where multiple procured items are generated for one ordered item, or multiple ordered items correspond to one procured item, and in such cases the procured item code needs to be replaced, which places a heavy burden on the staff, so a system that can efficiently handle orders was desired.
[0003] Patent Document 1 describes an order placement and receipt support system characterized by comprising a computer having: a code storage means for storing, as a code correspondence table, an order code for identifying a product when an orderer orders the product and a manufacturing code for identifying the product when a contractor manufactures the product; a code input means for the orderer to input the order code; an extraction means for extracting all order codes including the main part from a plurality of order codes stored in the code storage means when at least a main part of an order code is input by the code input means; a prompting means for displaying all the order codes extracted by the extraction means on a display means and prompting the user to select a desired order code from the displayed order codes; and a conversion means for converting the selected order code into a manufacturing code in accordance with the code correspondence table when a desired order code is selected from the order codes displayed on the display means and outputting data related to the converted manufacturing code. [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2002-170006 A Summary of the Invention [Problem to be solved by the invention]
[0005] The object of the present invention is to provide an order management device, an order management method, and an order management program that can easily replace an order part number code with an order part number code, create order data, and place an order, even if the part number codes of the sales department and the purchasing department are different. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the order management device of the present invention is an order management device equipped with a control unit, and is capable of accessing a sales part number master that stores the part number names and order part number codes of ordered items used by the sales department, a purchasing part number master that stores the part number names and order part number codes of ordered items used by the purchasing department, a part number conversion history master that stores the order part number codes and the order part number codes in association with each other, and order data that stores order information including the order number, customer, order part number code, and common number, and the control unit is equipped with an order order transfer unit that refers to the part number conversion history master and extracts the order part number code corresponding to the order part number code in the order data, and an order data creation unit that creates order data including a delivery date, quantity, and order amount based on the order part number code extracted by the order order transfer unit.
[0007] In the order management device according to the present invention, in the above-mentioned invention, the part number conversion history master associates two or more order part number codes with one order part number code.
[0008] In the order management device according to the present invention, in the above invention, the part number conversion history master associates one order part number code with two or more order part number codes.
[0009] In the order management device according to the present invention, in the above invention, the item number conversion history master associates a plurality of conversion patterns with one order item number code.
[0010] Further, in the order management method according to the present invention, in the above invention, the order data creation section creates order data for each order item corresponding to an order item number code.
[0011] In addition, the order management device of the present invention, in the above invention, is equipped with a sales data creation unit that creates sales data, and when the order placement transfer unit replaces one ordered item with two or more arranged items, the sales data creation unit creates sales data in which the total arrangement amount of the two or more replaced arranged items is used as the cost of sales.
[0012] In addition, the order management device of the present invention, in the above invention, is equipped with a sales data creation unit that creates sales data, and when the order placement transfer unit replaces two or more ordered items with one arranged item, the sales data creation unit creates sales data in which the arrangement amount of the replaced arranged item is divided by the number of ordered items, and the sales cost of each ordered item is the amount.
[0013] Furthermore, an order management method according to the present invention is an order management method executed by an order management device equipped with a control unit, the order management device having access to a sales part number master that stores part number names and order part number codes of ordered items used by the sales department, a purchasing part number master that stores part number names and order part number codes of ordered items used by the purchasing department, a part number conversion history master that stores the order part number codes and the order part number codes in association with each other, and order data that stores order information including the order number, customer, order part number code, and common number, and is characterized in including an order order transfer step executed by the control unit for extracting an order part number code corresponding to the order part number code in the order data based on the part number conversion history master, and an order data creation step for creating order data including a delivery date, quantity, and order amount based on the order part number code extracted in the order order transfer step.
[0014] In addition, the order management system of the present invention is an order management program to be executed by an order management device equipped with a control unit, the order management device having access to a sales part number master that stores the part number names and order part number codes of ordered items used by the sales department, a purchasing part number master that stores the part number names and order part number codes of ordered items used by the purchasing department, a part number conversion history master that stores the order part number codes and the order part number codes in association with each other, and order data that stores order information including the order number, customer, order part number code, and common number, and causes the control unit to execute an order order transfer step of extracting an order part number code corresponding to the order part number code in the order data based on the part number conversion history master, and an order data creation step of creating order data including a delivery date, quantity, and order amount based on the order part number code extracted in the order order transfer step. Effect of the Invention
[0015] According to the present invention, even if the part number codes of the business department and the purchasing department are different, it is possible to easily replace the received order part number code with the ordering part number code, create ordering data, and place an order. [Brief description of the drawings]
[0016] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of an order management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the business part number master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the purchase item number master. [Figure 4] FIG. 4 is a diagram showing an example of the product number conversion history master. [Diagram 5] FIG. 5 is a diagram illustrating an example of the order data. [Figure 6] FIG. 6 is a diagram showing an example of an order arrangement transfer input screen. [Figure 7] FIG. 7 is a diagram showing an example of the order data. [Figure 8]FIG. 8 is a diagram explaining the flow from order receipt to delivery. [Figure 9] FIG. 9 is a diagram illustrating an example of sales data. [Figure 10] FIG. 10 is a diagram showing an example of the product number conversion history master. [Figure 11] FIG. 11 is a diagram showing an example of the procured part conversion master search screen. [Figure 12] FIG. 12 is a diagram showing an example of an order arrangement transfer input screen. [Figure 13] FIG. 13 is a diagram illustrating an example of the order data. [Figure 14] FIG. 14 is a diagram illustrating an example of the order data. [Figure 15] FIG. 15 is a diagram showing an example of an order arrangement transfer input screen. [Figure 16] FIG. 16 is a diagram showing an example of the order data. [Figure 17] FIG. 17 is a diagram illustrating an example of sales data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0017] Hereinafter, an embodiment of an order management device, an order management method, and an order management program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.
[0018] [1. Configuration] An example of the configuration of an order management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of an order management device 100 according to this embodiment.
[0019] The order management device 100 is constructed based on a commercially available desktop personal computer. The order management device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0020] The order management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the order management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0021] The communication interface unit 104 communicatively connects the order management 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 a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the order management device 100 and the server device 200 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 memory unit 106 may be stored in the server device 200, for example.
[0022] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0023] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage 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 as the storage unit 106.
[0024] The memory unit 106 stores, for example, a sales part number master 106a, a purchase part number master 106b, a part number conversion history master 106c, order data 106d, arrangement data 106e, delivery data 106f, billing data 106g, and sales data 106h.
[0025] The sales item number master 106a is a master relating to the order item number code used by the sales department. The sales item number master 106a stores the item number name and the order item number code of the ordered item, as shown in FIG.
[0026] The purchase part number master 106b is a master relating to the order part number codes used by the purchasing department. The purchase part number master 106b stores order part number names, order part number codes, etc., as shown in an example in FIG.
[0027] The part number conversion history master 106c is a master that links an order part number code and a procured part number code. The part number conversion history master 106c stores the order part number code and the procured part number code in a linked manner, as shown in an example in FIG.
[0028] The order data 106d is data related to the ordered product. The order data 106d stores information including the order number, the common number, the customer code, the order item code, the order item name, the delivery date, etc., as shown in an example in FIG.
[0029] The order data 106e is data related to the ordered items. The order data 106e stores information including an order number, a common number, an order item code, an order item name, a delivery date, an order amount, etc., as shown in an example in FIG.
[0030] The delivery data 106f is data related to delivery, and stores information including a sales number, an order item code, an order item name, and a quantity.
[0031] The billing data 106g is data related to billing, and stores information including a billing number, an order item code, an order item name, and a quantity.
[0032] The sales data 106h is data related to sales. As shown in FIG. 9, the sales data 106h stores information including a sales number, a customer code, a product code, a product name, a delivery date, a quantity, and a cost of sales.
[0033] The control unit 102 is a CPU or the like that performs overall control of the order management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various information processing based on these stored programs.
[0034] The control unit 102 conceptually includes an order order transfer unit 102a, an order data creation unit 102b, a delivery data creation unit 102c, a sales data creation unit 102d, and the like.
[0035] The order placement transfer unit 102a refers to the part number conversion history master 106c and extracts the placement part number code corresponding to the order part number code in the order data 106a.
[0036] The order data creation unit 102b creates order data 106e including the order number, delivery date, quantity, and order amount based on the order item number code extracted by the order receipt transfer unit 102a. The order data creation unit 102b also creates a purchase order based on the order data 106e.
[0037] The sales data generating unit 102c generates sales data 106h, an example of which is shown in FIG.
[0038] The delivery data creation unit 102c creates delivery data 106f and billing data 106g based on the order data 106d.
[0039] [2. Processing] Here, a specific example of the process executed by the order management device 100 will be described with reference to FIGS.
[0040] When a transaction is concluded with a customer, the sales department staff creates order data 106d including the order number, common number, customer code, order item code, item name, delivery date, and quantity.
[0041] After creating the order data 106d, the order placement transfer unit 102a refers to the part number conversion history master 106c and extracts the placement part number code corresponding to the order part number code in the order data 106d.
[0042] Fig. 6 is a diagram showing an example of an order receipt arrangement transfer input screen. When an order number is entered on the order receipt arrangement transfer input screen MA-1, order data for the entered order number is output in the order details field. When an order addition command is selected on the order receipt arrangement transfer input screen MA-1, the order receipt arrangement transfer unit 102a refers to the item number conversion history master 106c, and extracts the arrangement item number code and arrangement item number name corresponding to the order item number code. The arrangement data creation unit 102b creates arrangement data 106e including the order number, delivery date, quantity, and arrangement amount based on the arrangement item number code extracted by the order receipt arrangement transfer unit 102a, and outputs it in the arrangement details field.
[0043] The order receipt order transfer input screen MA-2 is in a state where the order details have been output. In the item number conversion history master 106c in Fig. 4, the order item number codes corresponding to the order item number code "A00" are "A01", "A02", and "A03", so the order data creation unit 102b creates order data 106e for the order item number codes "A01", "A02", and "A03". The order data creation unit 102b assigns a common number (shared number) to link the order data 106d and the order data 106e, and the common number is stored in the order data 106d and the order data 106e.
[0044] FIG. 8 is a diagram explaining the flow from order receipt to delivery. The order data creation unit 102b creates three purchase orders for each order part number code, i.e., "A01", "A02", and "A03", based on the order data 106e. When the order part numbers "Product A1", "Product A2", and "Product A3" corresponding to the order part number codes "A01", "A02", and "A03" are arranged by the order, "Product A1", "Product A2", and "Product A3" are delivered to the customer as one order part number "Product A" together with a delivery note and invoice. The delivery note and invoice are created by the delivery data creation unit 102c as one delivery note and invoice for each order part number code, i.e., one corresponding to the order part number code "A00", based on the order data 102d.
[0045] After the payment for "Product A" is completed, the sales data creation unit 102c creates sales data 106h including the sales number, customer code, order item code, order item name, delivery part, quantity, and cost of sales. The sales data 106h shown in FIG. 9 is sales data for order item codes "A01", "A02", and "A03", but is stored as one data with a sales number of 1. The cost of sales is recorded as the total amount of the order amount of the three replaced order items "Product A1", "Product A2", and "Product A3". In the order data 106e of FIG. 7, the order amounts of the order items "Product A1", "Product A2", and "Product A3" are "1,000", "2,000", and "3,000", respectively, so the total amount "6,000" is the cost of sales for sales number "U00000000001". The order item code and order item name may use any of the three item numbers.
[0046] According to the order management device 100 of this embodiment, an order item number code can be easily replaced with an order item number code, order data can be created, and an order can be placed, so even an inexperienced person in charge can place an accurate order. Even if multiple order items are generated for one order item, an order form can be created for each order item, simplifying the work. Furthermore, by adopting a common number, part number control can be strengthened.
[0047] In the above embodiment, an example has been described in which three order part number codes are automatically associated with one order part number code, but the part number conversion history master may also link multiple conversion patterns to one order part number code.
[0048] 10 is a diagram showing an example of part number conversion history master 106c'. In part number conversion history master 106c', three conversion patterns are associated with one ordered part number code "A00". Pattern 1 is a case in which the part number is assigned to order part number codes "A01", "A02", and "A03", pattern 2 is a case in which the part number is assigned to order part number codes "B01", "B02", "B03", "B04", and "B05", and pattern 3 is a case in which the part number is assigned to order part number codes "C01" and "C02".
[0049] 11 is a diagram showing an example of a procured part conversion master search screen. When an order part number code "A00" is entered on the procured part conversion master search screen MB, the corresponding conversion pattern and the procured part number code corresponding to the conversion pattern with the standard category "1" among the conversion patterns are output. Among the conversion patterns linked to the order part number code "A00" in the part number conversion history master 106c', pattern 2 is selected as the conversion pattern with the standard category "1", so the procured part number code of pattern 2 is output in the procured part number field on the procured part conversion master search screen MB. If the conversion pattern to be allocated is not pattern 2, select the pattern to be allocated from the conversion pattern No., and the procured part number code and procured part number name corresponding to the selected pattern are output in the procured part field.
[0050] When pattern 2 is selected and registered on the order part conversion master search screen MB, the order order transfer input screen shown in FIG. 12 is output. On the order order transfer input screen MA-3, the order part number code of the conversion pattern selected on the order part conversion master search screen MB is output in the order details column. Since pattern 2 is selected on the order part conversion master search screen MB, order part number codes "B01", "B02", "B03", "B04", and "B05" are output. When the register button is pressed with this content, the order data creation unit 102b creates order data 106e' for order part number codes "B01", "B02", "B03", "B04", and "B05", an example of which is shown in FIG. 13.
[0051] Furthermore, the order management device 100 can also handle cases where one order item number code is linked to multiple order item number codes. Fig. 14 is a diagram showing an example of order data. In the example of Fig. 14, an order is placed from one customer for three order item numbers "item D1", "item D2", and "item D3", and order data 106d-1 is created for each order item number code.
[0052] After creating the order data 106d-1, the order placement transfer unit 102a refers to the part number conversion history master 106c and extracts the placement part number code corresponding to the order part number code in the order data 106d.
[0053] FIG. 15 is a diagram showing an example of an order placement transfer input screen. When an order number is input on the order placement transfer input screen MA-1, order data for the order number input in the order details field is output. Here, order data 106d-1 for three order item number codes "D01", "D02", and "D03" are output in the order details field. When an order consolidation command is selected on the order placement transfer input screen MA-1, the order placement transfer unit 102a refers to the item number conversion history master 106c and extracts the order item number code and order item number name corresponding to the order item number code. The order data creation unit 102b creates order data 106e-1 including an order number, delivery date, quantity, and order amount, an example of which is shown in FIG. 16, based on the order item number code extracted by the order placement transfer unit 102a, and outputs it to the order details field.
[0054] The order receipt order transfer input screen MA-2 is in a state where the order details have been output. In the item number conversion history master 106c in Fig. 4, the order item number code "E01" corresponds to the order item number codes "D01", "D02", and "D03", so the order data creation unit 102b creates order data 106e-1 for the order item number code "E01". The order data creation unit 102b assigns a common number (shared number) to link the order data 106d-1 and the order data 106e-1, and the common number is stored in the order data 106d-1 and the order data 106e-1.
[0055] Furthermore, the order data creation unit 102b creates a purchase order for the order part number code "E01" based on the order data 106e-1. When the order for the order part numbers "Product D1", "Product D2", and "Product D3" corresponding to the order part number code "E01" is completed, a delivery note and invoice are created for the three order part numbers "Product D1", "Product D2", and "Product D3", and the products are delivered to the customer.
[0056] After the payment for "Product D1", "Product D2", and "Product D3" is completed, the sales data creation unit 102c creates sales data 106h-1 including the sales number, customer code, order item code, order item name, delivery part, quantity, and cost of sales. The sales data 106h-1 shown in FIG. 17 is sales data for the order item codes "D01", "D02", and "D03". The sales data creation unit 102c creates sales data 106h-1 in which the order amount of the replaced order item "Product E1" divided by the number of ordered items is used as the cost of sales of each ordered item. In the order data 106e-1 in FIG. 16, the order amount of the order item "Product E1" is "3,000", so the amount "1,000" obtained by dividing this by the number of ordered items, 3, is recorded as the cost of sales for the order item codes "D01", "D02", and "D03".
[0057] As described above, even when one order item occurs for multiple ordered items, the order part number code can be easily replaced with the order part number code, order data can be created, and an order can be placed.
[0058] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0059] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0060] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0061] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0062] 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 using known methods.
[0063] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0064] Moreover, with regard to the order management device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.
[0065] For example, the processing functions of the order management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the order management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0066] In addition, this computer program may be stored in an application program server connected to the order management device 100 via any network, and it is also possible to download all or part of it as necessary.
[0067] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0068] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0069] The various databases etc. stored in the memory unit are storage means such as 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 etc. used for various processes and providing websites.
[0070] The order management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The order management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processes described in this embodiment.
[0071] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0072] The present invention can be used when the part number codes used by the sales department and the purchasing department are different, when multiple items are procured for one ordered item, or when common parts are procured for multiple ordered items. [Explanation of symbols]
[0073] 100 Order management device 102 Control section 102a Order and Order Transfer Department 102b Arrangement Data Data Creation Department 102c Sales Data Creation Department 102d Delivery Data Creation Department 104 Communication interface section 106 Storage section 106a Business Part Number Master 106b Purchase item number master 106c Part number conversion history master 106d Order Data 106e Wanted Data 106f Delivery data 106g Billing Data 106h Sales Data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. An order management device including a control unit, A sales part number master that stores the part number names and order part number codes of ordered items used by the sales department; A purchasing part number master that stores the part number names and part number codes of the procured items used by the purchasing department; a part number conversion history master that stores the order part number code and the procurement part number code in association with each other; Order data that stores order information including order number, customer, order item code, and common number; is accessible to The control unit is an order placement transfer unit that refers to the part number conversion history master and extracts a placement part number code corresponding to the order part number code in the order data; an order data creation unit that creates order data including an order number, a delivery date, a quantity, and an order amount based on the order item number code extracted by the order transfer unit; An order management device comprising:
2. 2. The order management device according to claim 1, wherein the part number conversion history master associates two or more order part number codes with one received order part number code.
3. 2. The order management device according to claim 1, wherein the part number conversion history master associates one order part number code with two or more order part number codes.
4. 2. The order management device according to claim 1, wherein the product number conversion history master associates a plurality of conversion patterns with one ordered product number code.
5. 2. The order management device according to claim 1, wherein said order data creation unit creates order data for each order item corresponding to an order item number code.
6. A sales data creation department that creates sales data; Equipped with When the order placement transfer unit replaces one order item with two or more placement items, 6. The order management device according to claim 5, wherein the sales data creation unit creates sales data in which the total amount of the ordering amounts of the two or more replaced ordering items is used as the cost of sales.
7. A sales data creation department that creates sales data; Equipped with When the order placement transfer unit replaces two or more ordered items with one placement item, 6. The order management device according to claim 5, wherein the sales data creation section creates sales data in which the cost of sales of each ordered item is calculated by dividing the order amount of the replaced ordered item by the number of ordered items.
8. An order management method executed by an order management device having a control unit, The order management device includes: A sales part number master that stores the part number names and order part number codes of ordered items used by the sales department; A purchasing part number master that stores the part number names and part number codes of the procured items used by the purchasing department; a part number conversion history master that stores the order part number code and the procurement part number code in association with each other; Order data that stores order information including order number, customer, order item code, and common number; is accessible to Executed by the control unit, an order placement transfer step of extracting a placement part number code corresponding to an order part number code in the order data based on the part number conversion history master; an order data creation step of creating order data including an order number, a delivery date, a quantity, and an order amount based on the order item number code extracted in the order transfer step; 13. An order management method comprising:
9. An order management program to be executed by an order management device having a control unit, The order management device includes: A sales part number master that stores the part number names and order part number codes of ordered items used by the sales department; A purchasing part number master that stores the part number names and part number codes of the procured items used by the purchasing department; a part number conversion history master that stores the order part number code and the procurement part number code in association with each other; Order data that stores order information including order number, customer, order item code, and common number; is accessible to The control unit, an order placement transfer step of extracting a placement part number code corresponding to an order part number code in the order data based on the part number conversion history master; an order data creation step of creating order data including an order number, a delivery date, a quantity, and an order amount based on the order item number code extracted in the order transfer step; An order management program for executing the above.
Citation Information
Patent Citations
Member ordering data production system corresponding to production on reception of order
JP1998254961A
Order reception system
JP2005099929A
Commodity management method, system and apparatus
JP2007004469A
Supplier selection device, supplier selection method, and supplier selection program
JP2021117901A
Order reception and order placement management device, order reception and order placement management method, order reception and order placement management program
JP2021149947A