Delivery-date reply management apparatus, delivery-date reply management method, and delivery-date reply management program

Abstract

To provide a delivery date reply management device, a delivery date reply management method and a delivery date reply management program, allowing calculation of a scheduled delivery date in a lead time on the basis of a supplier and a delivery destination in cooperation with stock data from the supplier to reply a delivery date.SOLUTION: When the ordered commodity is a prepared commodity, a scheduled delivery date of the ordered commodity is calculated based on the order data, the supplier stock data, the calendar master, and the lead time master, order reception data in which the delivery destination, the ordered commodity, the ordered quantity, and the scheduled delivery date are set is acquired, and delivery date reply data in which the scheduled delivery date of the ordered commodity is set is notified to the delivery destination based on the order reception data.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a delivery date response management device, a delivery date response management method, and a delivery date response management program. [Background technology]

[0002] Patent document 1 discloses a configuration in which delivery date response information for products sent from suppliers is stored in a management server, and delivery date response information for ordered products is provided to sales stores in response to a request from the sales store of a distributor to view ordered products. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2002-297972 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in the above Patent Document 1 has a problem in that it is not possible for a supplier to respond to a delivery destination regarding a scheduled delivery date taking into account lead time.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a delivery date response management device, a delivery date response management method, and a delivery date response management program that can link inventory data from suppliers, calculate the expected delivery date as a lead time based on the supplier and delivery destination, and provide a delivery date response. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the delivery date response management device of the present invention is a delivery date response management device comprising a memory unit and a control unit, wherein the memory unit comprises a delivery date response management storage means for storing supplier inventory data linking suppliers, products that are ordered items, inventory locations, and inventory quantities, a calendar master that sets the business days and holidays of the supplier, and a lead time master that sets the lead time number of days from the inventory location to the delivery destination, and the control unit comprises an order acquisition means for acquiring order data that sets the order date and order quantity of the ordered item from the delivery destination, when the ordered item is the ordered item, an order acquisition means for calculating the scheduled delivery date of the ordered item based on the order data, the supplier inventory data, the calendar master, and the lead time master, and acquiring order data that sets the delivery destination, the ordered item, the order quantity, and the scheduled delivery date, and a notification means for notifying the delivery destination of delivery date response data that sets the scheduled delivery date of the ordered item based on the order data.

[0007] In addition, in the delivery date response management device according to the present invention, the order acquisition means, when the ordered product is the procured product, calculates the number of days that have passed since the order date when the lead time has elapsed based on the order data, the supplier inventory data, the calendar master, and the lead time master, and, when the elapsed day is the business day, identifies the elapsed day as the scheduled delivery date, and, when the elapsed day is the non-business day, identifies the business day following the elapsed day as the scheduled delivery date, and acquires the order data in which the delivery destination, the ordered product, the order quantity, and the scheduled delivery date are set.

[0008] In addition, in the delivery date response management device of the present invention, the order acquisition means, when the ordered product is the procured product, identifies a supplier inventory record included in the supplier inventory data in which the inventory quantity is set to be equal to or greater than the ordered quantity, based on the order data and the supplier inventory data, calculates the scheduled delivery date of the ordered product based on the supplier inventory record, the calendar master, and the lead time master, and acquires the order data in which the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date are set.

[0009] In addition, in the delivery date response management device of the present invention, the order acquisition means, when the ordered product is the procured product, identifies the supplier inventory record included in the supplier inventory data in which the inventory quantity equal to or greater than the ordered quantity is set based on the order data and the supplier inventory data, and when there are multiple supplier inventory records, identifies the supplier inventory record in which the inventory location in which the lead time from the delivery destination is set is set based on the lead time master, calculates the scheduled delivery date of the ordered product based on the lead time, the supplier inventory record, and the calendar master, and acquires the order data in which the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date are set.

[0010] In addition, in the delivery date response management device of the present invention, the lead time master is characterized in including a supplier inventory location area conversion master that links and sets the supplier, the inventory location, and the inventory location area, a delivery destination master that links and sets the delivery destination and the delivery destination area, and a delivery destination inventory location area-specific lead time master that links and sets the lead time days from the inventory location area to the delivery destination area.

[0011] In addition, in the delivery date response management device of the present invention, the order acquisition means further acquires relationship data linking the inventory location area set in the supplier inventory location area conversion master and the lead time days set in the delivery destination inventory location area lead time master to the supplier inventory data based on the order data and the delivery destination master, and the order acquisition means, when the ordered product is the arranged product, calculates the scheduled delivery date of the ordered product based on the order data, the calendar master and the relationship data, and acquires the order data in which the delivery destination, the ordered product, the order quantity and the scheduled delivery date are set.

[0012] In addition, in the delivery date response management device of the present invention, the delivery date response management storage means further stores the product, a product category indicating that the product is in stock or the ordered product, and a product master linked to the supplier, and the control unit is further characterized by having an inventory management means that, when supplier inventory linkage data linked to the inventory location and inventory quantity of the product is obtained from the supplier, registers a supplier inventory record linked to the supplier, the product that is the ordered product, the inventory location, and the inventory quantity in the supplier inventory data based on the product master.

[0013] Furthermore, a delivery date response management method according to the present invention is a delivery date response management method to be executed by a delivery date response management device having a memory unit and a control unit, wherein the memory unit comprises a delivery date response management storage means for storing supplier inventory data linking together suppliers, products that are ordered items, inventory locations, and inventory quantities, a calendar master setting business days and holidays for the suppliers, and a lead time master setting the number of lead times from the inventory locations to delivery destinations, and the method includes the following steps executed by the control unit: an order acquisition step for acquiring order data setting the order date and order quantity of the ordered product from the delivery destination, when the ordered product is the ordered product, a sales order acquisition step for calculating an expected delivery date of the ordered product based on the order data, the supplier inventory data, the calendar master, and the lead time master, and acquiring order data setting the delivery destination, the ordered product, the order quantity, and the expected delivery date, and a notification step for notifying the delivery destination of delivery date response data setting the expected delivery date of the ordered product based on the order data.

[0014] Furthermore, a delivery date reply management program according to the present invention is a delivery date reply management program to be executed by a delivery date reply management device having a memory unit and a control unit, wherein the memory unit comprises a delivery date reply management storage means for storing supplier inventory data linking together suppliers, products that are ordered items, inventory locations, and inventory quantities, a calendar master setting business days and holidays for the suppliers, and a lead time master setting the number of lead times from the inventory locations to delivery destinations, and the control unit executes the following steps in order acquisition step: acquiring order data setting the order date and order quantity of the ordered products from the delivery destination, if the ordered products are the ordered products, a sales order acquisition step: calculating an expected delivery date of the ordered products based on the order data, the supplier inventory data, the calendar master, and the lead time master, and acquiring order data setting the delivery destination, the ordered products, the order quantity, and the expected delivery date, and a notification step: notifying the delivery destination of delivery date reply data setting the expected delivery date of the ordered products based on the order data. [Effects of the Invention]

[0015] The present invention has the effect of shortening the time required to respond to customers about delivery dates, thereby improving business efficiency and customer satisfaction. Furthermore, the present invention has the effect of automatically linking supplier inventory data in companies that handle many products and manufacturers. Furthermore, the present invention has the effect of enabling machinery trading companies to manage expected delivery date responses. Furthermore, the present invention has the effect of enabling inventory quantities by supplier and by inventory location to be grasped. Furthermore, the present invention has the effect of enabling expected delivery dates to be responded to immediately at the order receiving stage. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a delivery date response management device according to this embodiment. [Figure 2] FIG. 2 is a flowchart showing an example of the process of the delivery date response management device in this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of delivery date response management processing in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of delivery date response management processing in this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of a method for calculating a scheduled delivery date at the time of placing or receiving an order in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of delivery date response management processing in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0018] [1. Overview] First, an outline of the present invention will be described.

[0019] In businesses such as machinery and tool trading companies, it is difficult to maintain all of the products in stock due to the large number of manufacturers and products handled, so in many cases they manage their inventory by either keeping the products in stock or ordering them from suppliers on a case-by-case basis.

[0020] Here, in the past, in businesses such as machine tool trading companies, when receiving an order from a customer, the speed with which a delivery date was given was extremely important, but when arranging for delivery from a supplier (manufacturer), it was necessary to inquire about the delivery date each time, which meant it took a long time to get a delivery date response.

[0021] Therefore, in this embodiment, by linking the inventory data of major suppliers, a system is provided that allows for the reply of the expected delivery date before the supplier is contacted. That is, in this embodiment, (1) as a background process at any time, data on inventory quantity by inventory location is received from each supplier and linked as supplier inventory data, (2) an order is received from a customer, and if the product is a procured item, the expected delivery date is calculated based on the manufacturer inventory data in (1), and (3) a delivery date reply is output based on the expected delivery date calculated in (2).

[0022] [2. Configuration] An example of the configuration of a delivery date reply management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of a delivery date reply management device 100 according to this embodiment.

[0023] 1, the delivery date reply management device 100 is a commercially available desktop personal computer. Note that the delivery date reply management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0024] The delivery date reply 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 delivery date reply management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0025] The communication interface unit 104 communicably connects the delivery date reply 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 delivery date reply management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0026] 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 touch panel), 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 achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0027] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes a delivery date response management database 106a.

[0028] The delivery date response management database 106a stores delivery date response management data. The delivery date response management database 106a may store supplier inventory data linking suppliers, ordered products, inventory locations, and inventory quantities; a calendar master linking business days and holidays for suppliers; and a lead time master linking the lead time from inventory locations to delivery destinations. The lead time master may include a district master linking districts; a supplier inventory location district conversion master linking suppliers, inventory locations (supplier warehouses), and inventory location districts (supplier warehouse districts); a delivery destination master linking delivery destinations and delivery destination districts; and a delivery destination inventory location district lead time master linking the lead time from inventory location districts to delivery destination districts. The delivery date response management database 106a may also store a product master linking products, product categories indicating whether the products are in stock or ordered, and suppliers.

[0029] The control unit 102 is a CPU or the like that performs overall control of the delivery date reply 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, etc., and executes various information processing based on these stored programs. Functionally, the control unit 102 conceptually includes an inventory management unit 102a, an order acquisition unit 102b, a sales order acquisition unit 102c, and a notification unit 102d.

[0030] The inventory management unit 102a manages inventory data. Here, the inventory management unit 102a may register a supplier inventory record in which a supplier, a product to be ordered, a stock location, and a stock quantity are linked together in the supplier inventory data. Furthermore, when the inventory management unit 102a acquires (receives) supplier inventory linked data in which a product's stock location and stock quantity are linked together from a supplier, the inventory management unit 102a may register a supplier inventory record in which a supplier, a product to be ordered, a stock location, and a stock quantity are linked together in the supplier inventory data based on the product master.

[0031] The order acquiring unit 102b acquires order data that sets the order quantity of ordered products from the delivery destination. Here, the order acquiring unit 102b may acquire order data that sets the order date and order quantity of ordered products from the delivery destination. Furthermore, the order acquiring unit 102b may acquire relation data that links the inventory location district set in the supplier inventory location district conversion master and the lead time days set in the delivery destination inventory location district lead time master to the supplier inventory data, based on the order data and the delivery destination master.

[0032] The order acquisition unit 102c acquires order data for an ordered product. Here, if the ordered product is a pre-ordered product, the order acquisition unit 102c may calculate the expected delivery date of the ordered product based on the order data, supplier inventory data, calendar master, and lead time master, and acquire order data in which the delivery destination, ordered product, order quantity, and expected delivery date are set. Furthermore, if the ordered product is a pre-ordered product, the order acquisition unit 102c may calculate the number of days that have passed since the order date, the number of lead time days, based on the order data, supplier inventory data, calendar master, and lead time master, and if the elapsed day is a business day, specify the elapsed day as the expected delivery date. If the elapsed day is a non-business day, specify the business day next to the elapsed day as the expected delivery date, and acquire order data in which the delivery destination, ordered product, order quantity, and expected delivery date are set. Furthermore, when the ordered product is a pre-ordered product, the order acquisition unit 102c may identify, based on the order data and the supplier inventory data, a supplier inventory record included in the supplier inventory data in which an inventory quantity equal to or greater than the ordered quantity is set, calculate the scheduled delivery date of the ordered product based on the supplier inventory record, the calendar master, and the lead-time master, and acquire order data in which the delivery destination, the ordered product, the order quantity, and the scheduled delivery date are set. Furthermore, when the ordered product is a pre-ordered product, the order acquisition unit 102c may identify, based on the order data and the supplier inventory data, a supplier inventory record included in the supplier inventory data in which an inventory quantity equal to or greater than the ordered quantity is set, and when there are multiple supplier inventory records, identify, based on the lead-time master, a supplier inventory record in which the inventory location with the shortest lead time from the delivery destination is set, calculate the scheduled delivery date of the ordered product based on the lead-time days, the supplier inventory record, and the calendar master, and acquire order data in which the delivery destination, the ordered product, the order quantity, and the scheduled delivery date are set. In addition, if the ordered product is a pre-ordered product, the order acquisition unit 102c may calculate the scheduled delivery date of the ordered product based on the order data, calendar master, and relationship data, and acquire order data that sets the delivery destination, ordered product, order quantity, and scheduled delivery date.

[0033] The notification unit 102d notifies the delivery destination of the delivery date response data for the ordered product. Here, the notification unit 102d may notify the delivery destination of the delivery date response data that sets the expected delivery date of the ordered product based on the order data.

[0034] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0035] [Delivery date response management process] An example of the delivery date reply management process in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a flowchart showing an example of the process of the delivery date reply management device 100 in this embodiment.

[0036] As shown in Figure 2, when the inventory management unit 102a receives supplier inventory linkage data from a supplier that links the inventory location and inventory quantity of a product, as a data linkage process, it registers a supplier inventory record that links the supplier, the ordered product, the inventory location, and the inventory quantity based on the product master into the supplier inventory data stored in the delivery date response management database 106a (step SA-1).

[0037] Then, the order acquisition unit 102b acquires order data from the delivery destination, which sets the order date and the order quantity of the ordered product (step SA-2).

[0038] If the ordered product is a procured product, the order acquisition unit 102c calculates the number of days that have passed since the order date, based on the order data, supplier inventory data, calendar master, and lead time master, and if the number of days that have passed is a business day, it identifies the number of days that have passed as the scheduled delivery date.If the number of days that passed is a non-business day, it identifies the next business day after the number of days that passed as the scheduled delivery date, and acquires order data that sets the delivery destination, ordered product, order quantity, and scheduled delivery date (step SA-3).

[0039] Then, the notification unit 102d notifies the delivery destination of delivery date response data that sets the expected delivery date of the ordered product based on the order data (step SA-4), and ends the process.

[0040] Here, an example of delivery date response management processing in this embodiment will be described with reference to Fig. 3 to Fig. 6. Fig. 3, Fig. 4 and Fig. 6 are diagrams showing an example of delivery date response management processing in this embodiment. Fig. 5 is a diagram showing an example of a method for calculating an expected delivery date at the time of placing or receiving an order in this embodiment.

[0041] As shown in Fig. 3, in this embodiment, inventory data by inventory location (supplier inventory linked data) is received from each supplier as background processing at any time and linked as supplier inventory data. Here, as shown in Fig. 3, in this embodiment, the product code is obtained from the product master using the "supplier product code" as a key and set in the supplier inventory data.

[0042] As shown in Fig. 4, in this embodiment, an order is received from a customer and an order is entered. Here, as shown in Fig. 4, in this embodiment, the order classification is automatically determined based on the product classification in the product master, and if the product classification is an in-stock item, "warehouse release" is set in the order data, and if the product classification is a procured item, "order placement" is set in the order data. Also, as shown in Fig. 4, in this embodiment, if the order classification is "order placement," the expected delivery date is automatically calculated.

[0043] As shown in FIG. 5(1), in this embodiment, for products with product codes: SHO2001 and SHO3001, the delivery destination's delivery area code: TIK003 is obtained from the "Delivery Destination Master." Then, as shown in FIG. 5(2), in this embodiment, the "Supplier Inventory Data," "Supplier Warehouse District Conversion Master," and "Delivery Destination Inventory Location District Lead Time Master" are combined to obtain the lead time number of days for product with product code: SHO2001: "1" and the lead time number of days for product with product code: SHO3001: "2." In this embodiment, the relationship data is sorted by lead time number of days (ascending order), inventory quantity (descending order), and inventory location code (ascending order), and shipment is performed from an inventory location that holds inventory equal to or greater than the ordered quantity. The two essential sorting conditions are the lead time number of days and inventory quantity, and the inventory location code is used to uniquely identify a record. As shown in Figure 5(3), in this embodiment, holidays are taken into account based on the "Calendar Master" (i.e., 2023 / 4 / 13 and 2023 / 4 / 14 are not included in the number of days because they are holidays), and the scheduled delivery date is calculated based on the lead time days obtained in Figure 5(2).

[0044] As shown in Fig. 6, in this embodiment, a delivery date reply is output based on the estimated delivery date calculated in Fig. 4. In this way, in this embodiment, the estimated delivery date is immediately provided at the time of order receipt, allowing the customer's representative to make decisions quickly, which contributes to differentiation from competitors and customer satisfaction.

[0045] [4. 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 the achievement of SDGs Goals 8 and 9.

[0046] 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.

[0047] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0048] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0049] 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.

[0050] Furthermore, 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 can be changed as desired unless otherwise specified.

[0051] Furthermore, with regard to the delivery date response management device 100, the components shown in the figures are functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0052] For example, all or any part of the processing functions of the delivery date reply management device 100, particularly the processing functions performed by the control unit 102, may be realized 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 on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the delivery date reply management device 100 as needed. That is, a computer program for issuing 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 RAM, and cooperates with the CPU to form the control unit.

[0053] This computer program may be stored in an application program server connected to the delivery date response management device 100 via any network, and all or part of it may be downloaded as needed.

[0054] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.

[0055] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0056] The various databases stored in the memory unit 106 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 used for various processes and providing websites.

[0057] The delivery date reply management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The delivery date reply management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

[0058] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0059] The present invention is useful in industries such as trading companies, including the machinery trading company industry, which handles a large number of products and manufacturers. [Explanation of symbols]

[0060] 100 Delivery date response management device 102 Control section 102a Inventory Control Department 102b Order Acquisition Department 102c Order Acquisition Department 102d Notification Department 104 Communication interface unit 106 Storage section 106a Delivery date response management database 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A delivery date reply management device including a storage unit and a control unit, The storage unit a delivery date response management storage means for storing supplier inventory data that links together suppliers, ordered products, inventory locations, and inventory quantities, a calendar master that sets business days and holidays for the suppliers, and a lead time master that sets the number of days of lead time from the inventory locations to delivery destinations; Equipped with The control unit an order acquisition means for acquiring order data that sets an order date and an order quantity of the ordered product from the delivery destination; an order acquisition means for calculating, when the ordered product is the arranged product, a scheduled delivery date of the ordered product based on the order data, the supplier inventory data, the calendar master, and the lead time master, and acquiring order data that sets the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date; notification means for notifying the delivery destination of delivery date response data that sets the expected delivery date of the ordered product based on the order data; A delivery date response management device comprising:

2. The order acquisition means 2. The delivery date response management device according to claim 1, wherein, when the ordered product is the arranged product, the device calculates the number of days that have passed since the order date based on the order data, the supplier inventory data, the calendar master, and the lead time master, and, when the number of days that have passed is the business day, identifies the number of days that have passed as the scheduled delivery date, and, when the number of days that have passed is the non-business day, identifies the business day following the number of days that passed as the scheduled delivery date, and acquires the order data that sets the delivery destination, the ordered product, the order quantity, and the scheduled delivery date.

3. The order acquisition means The delivery date response management device of claim 1, characterized in that if the ordered product is the procured product, a supplier inventory record included in the supplier inventory data in which the inventory quantity set is equal to or greater than the ordered quantity is identified based on the order data and the supplier inventory data, the scheduled delivery date of the ordered product is calculated based on the supplier inventory record, the calendar master, and the lead time master, and the order data in which the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date are set is obtained.

4. The order acquisition means 4. A delivery date response management device as described in claim 3, characterized in that, if the ordered product is a procured product, the supplier inventory record included in the supplier inventory data in which the inventory quantity equal to or greater than the ordered quantity is identified based on the order data and the supplier inventory data, and if there are multiple supplier inventory records, the supplier inventory record in which the inventory location with the shortest lead time from the delivery destination is set is identified based on the lead time master, the expected delivery date of the ordered product is calculated based on the lead time, the supplier inventory record, and the calendar master, and the order data in which the delivery destination, the ordered product, the ordered quantity, and the expected delivery date are set is obtained.

5. The lead time master 2. The delivery date response management device according to claim 1, further comprising a supplier inventory location area conversion master that links and sets the supplier, the inventory location, and the inventory location area, a delivery destination master that links and sets the delivery destination and the delivery destination area, and a delivery destination inventory location area-specific lead time master that links and sets the lead time days from the inventory location area to the delivery destination area.

6. The order acquisition means Furthermore, based on the order data and the delivery destination master, relation data is acquired in which the inventory location area set in the supplier inventory location area conversion master and the lead time days set in the delivery destination inventory location area lead time master are linked to the supplier inventory data; The order acquisition means The delivery date response management device described in claim 5, characterized in that if the ordered product is an arranged product, the expected delivery date of the ordered product is calculated based on the order data, the calendar master and the relationship data, and the order data that sets the delivery destination, the ordered product, the order quantity and the expected delivery date is obtained.

7. The delivery date response management storage means A product master set up by linking the product, a product category indicating whether the product is in stock or the ordered product, and the supplier; Further memorize, The control unit an inventory management means for registering a supplier inventory record set by linking the supplier, the ordered product, the inventory location, and the inventory quantity to the supplier inventory data based on the product master when supplier inventory linked data set by linking the inventory location and the inventory quantity of the product is obtained from the supplier; 5. The delivery date reply management device according to claim 1, further comprising:

8. A delivery date reply management method to be executed by a delivery date reply management device having a storage unit and a control unit, The storage unit a delivery date response management storage means for storing supplier inventory data that links together suppliers, ordered products, inventory locations, and inventory quantities, a calendar master that sets business days and holidays for the suppliers, and a lead time master that sets the number of days of lead time from the inventory locations to delivery destinations; Equipped with Executed in the control unit: an order acquisition step of acquiring order data that sets an order date and an order quantity of the ordered product from the delivery destination; an order acquisition step of calculating a scheduled delivery date for the ordered product based on the order data, the supplier inventory data, the calendar master, and the lead time master, if the ordered product is the arranged product, and acquiring order data that sets the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date; a notification step of notifying the delivery destination of delivery date response data that sets the expected delivery date of the ordered product based on the order data; A method for managing delivery date responses, comprising:

9. A delivery date reply management program to be executed by a delivery date reply management device having a storage unit and a control unit, The storage unit a delivery date response management storage means for storing supplier inventory data that links together suppliers, ordered products, inventory locations, and inventory quantities, a calendar master that sets business days and holidays for the suppliers, and a lead time master that sets the number of days of lead time from the inventory locations to delivery destinations; Equipped with In the control unit, an order acquisition step of acquiring order data that sets an order date and an order quantity of the ordered product from the delivery destination; an order acquisition step of calculating a scheduled delivery date for the ordered product based on the order data, the supplier inventory data, the calendar master, and the lead time master, if the ordered product is the arranged product, and acquiring order data that sets the delivery destination, the ordered product, the ordered quantity, and the scheduled delivery date; a notification step of notifying the delivery destination of delivery date response data that sets the expected delivery date of the ordered product based on the order data; A delivery date response management program for executing the above.

Images