JP7445582B2 - Shipping warehouse determination device, shipping warehouse determination method, and shipping warehouse determination program - Google Patents

Description

The present invention relates to a shipping warehouse determining device, a shipping warehouse determining method, and a shipping warehouse determining program.

In the food industry, products are stored in multiple warehouses for reasons such as managing products that require different storage temperatures, such as refrigerated products, in separate warehouses, or storing inventory near the point of consumption from the perspective of expiration dates. Often managed. Furthermore, in the food industry, products are sometimes delivered directly to warehouses managed by customers. Therefore, when receiving an order from a customer for a product that is in stock at multiple warehouses, it is necessary to determine the warehouse from which the product will be shipped. Conventionally, this decision was made by the person in charge of taking orders while manually checking the location of the customer, the warehouse where the product was in stock, the distance between the customer and the warehouse, and the area.

Patent Document 1 describes a method for smoothly carrying out warehousing and unloading operations when moving products between warehouses and delivering the products to customers.

Japanese Patent Application Publication No. 2019-066949

However, the conventional method of making judgments manually has the problem of complicating the work and making it dependent on the individual. Furthermore, from the perspective of the accuracy of judgment, there was still room for improvement in the conventional manual judgment method.

The present invention has been made in view of the above, and provides a shipping warehouse determining device and a shipping warehouse that can determine an appropriate shipping warehouse and can further eliminate the complexity and individualization of operations. The purpose is to provide a determination method and a shipping warehouse determination program.

In order to solve the above-mentioned problems and achieve the purpose, a shipping warehouse determining device according to the present invention is a shipping warehouse determining device that includes a control section, and the control section is configured to monitor set products and set specialties. Based on the destination or delivery destination, refer to the warehouse judgment master that manages the warehouse by product and by customer, and the current inventory information that manages the current number of products in stock by product and by warehouse, and select the set product and the corresponding The present invention is characterized by comprising a shipping warehouse determining means that determines a warehouse linked to a set customer or delivery destination that has the set product in stock as a shipping warehouse.

Further, in the shipping warehouse determination device according to the present invention, the warehouse determination master stores ranks indicating priorities of shipping warehouses, and the shipping warehouse determination means stores the set products and the set If there are multiple warehouses linked to a customer or delivery destination that have the specified product in stock, the warehouse with the highest rank among the multiple warehouses will be determined as the shipping warehouse. Features.

In the shipping warehouse determination device according to the present invention, the control unit further includes order registration means for registering orders for products, and the order registration means is configured to set products to be ordered and customers or delivery destinations. and passing the set product and the set customer or delivery destination to the shipping warehouse determining means, and receiving the determination result returned from the shipping warehouse determining means.

Further, the shipping warehouse determining method according to the present invention is a shipping warehouse determining method executed by an information processing device including a control unit, and includes a set product and a set customer or Based on the delivery destination, refer to the warehouse judgment master that manages the warehouse by product and by customer, and the current inventory information that manages the current number of products in stock by product and by warehouse, The present invention is characterized in that it includes a shipping warehouse determining step of determining a warehouse linked to a customer or delivery destination that has the set product in stock as a shipping warehouse.

Further, the shipping warehouse determination program according to the present invention is a shipping warehouse determination program to be executed by an information processing device including a control unit, and includes a set product and a set specialty to be executed by the control unit. Based on the destination or delivery destination, refer to the warehouse judgment master that manages the warehouse by product and by customer, and the current inventory information that manages the current number of products in stock by product and by warehouse, and select the set product and the corresponding The present invention is characterized in that it includes a shipping warehouse determining step of determining a warehouse linked to a set customer or delivery destination that has the set product in stock as a shipping warehouse.

According to the present invention, it is possible to determine an appropriate shipping warehouse, and it is possible to eliminate the complexity and individualization of operations.

FIG. 1 is a block diagram showing an example of the configuration of a shipping warehouse determination device 100. FIG. 2 is a diagram showing an example of the data structure of the warehouse determination master 106a. FIG. 3 is a diagram illustrating an example of a flowchart regarding processing executed by the shipping warehouse determination device 100. FIG. 4 is a diagram showing an example of the warehouse determination master maintenance screen MA. FIG. 5 is a diagram showing an example of the warehouse determination master 106a. FIG. 6 is a diagram showing an example of the order entry screen MB.

DESCRIPTION OF THE PREFERRED EMBODIMENTS Below, embodiments of a shipping warehouse determining device, a shipping warehouse determining method, and a shipping warehouse determining program according to the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. composition]
Here, an example of the configuration of the shipping warehouse determination device 100 according to the present embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of a shipping warehouse determination device 100.

The shipping warehouse determination device 100 is constructed based on a commercially available desktop personal computer. Note that the shipping warehouse determination device 100 is not limited to stationary information processing devices such as desktop personal computers, but also mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may be a type information processing device.

The shipping warehouse determination device 100 includes a control section 102, a communication interface section 104, a storage section 106, and an input/output interface section 108. Each unit included in the shipping warehouse determination device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the shipping warehouse determination 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 a communication line. Here, the network 300 has a function of connecting the shipping warehouse determination 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). Note that the data stored in the storage unit 106 may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). As the storage unit 106, 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, an optical disk, etc. can be used.

The storage unit 106 stores, for example, a warehouse determination master 106a, current inventory information 106b, and the like.

FIG. 2 is a diagram showing an example of the data structure of the warehouse determination master 106a. The warehouse determination master 106a includes customer classification identification information (e.g., name of customer classification), customer identification information (e.g., customer code, etc.), product identification information (e.g., product code, etc.), and shipping information. It includes a rank indicating the priority of the warehouse and warehouse identification information (for example, a warehouse code). The rank is based on the distance between the customer and the warehouse, whether the customer and the warehouse are in the same area (for example, the Kanto area), whether each product is stocked in multiple locations or in a single location, and if there are multiple locations, where is the main warehouse? Set this by taking into account the following circumstances:

The current inventory information 106b (not shown) includes warehouse identification information, product identification information, and the current number of products.

Returning to FIG. 1, the control unit 102 is a CPU or the like that centrally controls the shipping warehouse determination device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally includes a master maintenance unit 102a, an order registration unit 102b that corresponds to the order registration unit of the present invention, and a shipping warehouse determination unit 102c that corresponds to the shipping warehouse determination unit of the present invention.

The master maintenance unit 102a manages the warehouse judgment master 106a (for example, registers new registration, edits, or deletes data) based on the set customer classification identification information, customer identification information, product identification information, rank, and warehouse identification etc.).

The order registration unit 102b registers orders for products. Further, when the product identification information and customer identification information or delivery destination identification information to be registered for order are set, the order registration unit 102b stores the set product identification information and the set customer information or delivery destination identification information. is passed to the shipping warehouse determining unit 102c, and the determination result returned from the shipping warehouse determining unit 102c is received.

The shipping warehouse determination unit 102c compares the warehouse determination master 106a and the current inventory based on the set product identification information and the set customer identification information or delivery destination identification information (for example, customer code or delivery destination code). With reference to the information 106b, the warehouse identified by the set product identification information and the warehouse identification information linked to the set customer identification information or delivery destination identification information is identified by the set product identification information. A warehouse with the identified product in stock is determined as a shipping warehouse.

In addition, the shipping warehouse determination unit 102c is a warehouse that is identified by the warehouse identification information that is linked to the set product identification information and the set customer identification information or the delivery destination identification information. If there are multiple warehouses that have the identified product in stock, the warehouse with the highest rank among the multiple warehouses is determined to be the shipping warehouse.

A specific example of the processing executed by each processing unit constituting the control unit 102 will be described in detail below.

[2. Specific example of processing]
Here, a specific example of processing executed by the shipping warehouse determination device 100 will be described with reference to FIG. 3 and the like. FIG. 3 is a diagram illustrating an example of a flowchart regarding processing executed by the shipping warehouse determination device 100.

FIG. 4 is a diagram showing an example of the warehouse determination master maintenance screen MA. Further, FIG. 5 is a diagram showing an example of the warehouse determination master 106a. In the description of this specific example, it is assumed that the master maintenance section 102a has previously registered the warehouse determination master 106a as shown in FIG. 5 by setting on the warehouse determination master maintenance screen MA shown in FIG.

FIG. 6 is a diagram showing an example of the order entry screen MB. The product to be registered for order and the delivery destination are set by inputting to the order entry screen MB. In the description of this specific example, it is assumed that the product code and customer code or delivery destination code are set on each of the order entry screens MB1 to MB4 as shown in FIG.

First, the order registration unit 102b passes the product code and customer code or delivery destination code set on the order entry screen MB to the shipping warehouse determination unit 102c (step S1).

Next, the shipping warehouse determination unit 102c refers to the warehouse determination master 106a and current inventory information 106b shown in FIG. 5, based on the information passed from the order registration unit 102b in step S1, and determines the shipping warehouse ( Step S2).

Next, the shipping warehouse determination unit 102c returns the determination result in step S2 to the order registration unit 102b (step S3).

Next, the order registration unit 102b performs order registration based on the determination result returned from the shipping warehouse determination unit 102c (step S4).

As shown in FIG. 6, the warehouse code of the warehouse determined as the shipping warehouse by the shipping warehouse determining unit 102c is displayed at the bottom of each order entry. In the order entry screen MB1 shown in FIG. 6, the warehouse code "K001" linked to the customer classification "0: Customer", the customer code "T001", and the product code "S001" in the warehouse determination master 106a shown in FIG. The warehouse is determined to be a shipping warehouse. In addition, on the order entry screen MB2 shown in FIG. 6, the warehouse code "K002" is linked to the customer classification "0: Customer", the customer code "T001", and the product code "S002" in the warehouse determination master 106a shown in FIG. ” is determined to be the shipping warehouse. In addition, in the order entry screen MB3 shown in FIG. 6, among the warehouse codes linked to the customer classification "1: Delivery destination", the customer code "N001", and the product code "S001" of the warehouse determination master 106a shown in FIG. Since the warehouse with the highest ranking warehouse code "K003" had the product with the product code "S001" in stock, the warehouse code is determined to be "K003". In addition, in the order entry screen MB4 shown in FIG. 6, among the warehouse codes linked to the customer classification "1: Delivery destination", the customer code "N001", and the product code "S001" in the warehouse determination master 106a shown in FIG. , the warehouse with the highest rank warehouse code "K003" does not have the product code "S001" in stock, and the warehouse with the next highest rank warehouse code "K004" does not have the product code "S001" in stock. Since there is, it is determined that the warehouse code is "K004".

From the above process, by automatically determining the shipping warehouse at the time of order data registration, the shipping warehouse can be easily determined. In the explanation of this specific example, the product to be ordered and the customer or delivery destination are set by inputting to the order entry screen MB shown in FIG. 6, but instead, order data by EDI (Electronic Data Interchange) You can also set products and customers or delivery destinations by importing. Further, if both the customer and the delivery destination are set at the time of order registration, the shipping warehouse determination unit 102c first refers to the warehouse determination master 106a to obtain the warehouse linked to the delivery destination, If there is no warehouse associated with the delivery destination in the warehouse determination master 106a, the warehouse associated with the customer may be obtained by referring to the warehouse determination master 106a.

In addition, if the same product is stored in multiple warehouses, by ranking the priority order to be determined as a shipping warehouse and registering it in the system in advance, the highest rank with the product in stock at the time of order data registration can be ranked and registered in the system in advance. Warehouses can be automatically determined as shipping warehouses.

In the food industry, products are often managed in multiple warehouses. Reasons behind this include, for example, managing products with different temperature ranges, such as refrigerated products, in separate warehouses, and keeping inventory close to the point of consumption from the perspective of expiration dates. In some cases, products are also delivered directly to warehouses managed by customers. When a customer places an order for products stocked in multiple warehouses, according to this embodiment, for example, it is possible to determine the shipping warehouse that can ship the product the earliest, thereby reducing the opportunity loss of orders. can be prevented. In this embodiment, it is also possible to determine which warehouse to prioritize and allocate by taking into consideration the inventory warehouse for each product, the distance to the customer, the area, etc. Further, since electronic transactions are progressing in the food industry, in this embodiment, an appropriate shipping warehouse may be automatically determined based on order data from customers and shipping instructions may be given. That is, in this embodiment, the shipping warehouse can be automatically determined both in the case of operator input and EDI.

Furthermore, in the past, the operator had to judge and specify different allocation warehouses depending on the customer's location, product, etc. In order to make this decision, the operator needs to understand the differences in storage warehouses depending on the product, the distance between the warehouse and the customer, the region, etc., making the work complicated and individualized. According to this embodiment, by registering in advance which warehouse to ship from for each shipping destination business partner and product, the shipping warehouse is automatically determined and reserved, for example, when registering order data. can solve the problem. Note that in this embodiment, if the same product is stored in multiple warehouses, the allocation priority order can also be registered.

[3. 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.

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 of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

In addition, unless otherwise specified, information including processing procedures, control procedures, specific names, parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings are included. It can be changed arbitrarily.

Further, regarding the shipping warehouse determination device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions provided by the shipping warehouse determination device 100, especially each processing function 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. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in this embodiment. Mechanically read by device 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the shipping warehouse determination device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary. It is.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, and the installation procedure after reading.

The various databases etc. stored in the storage 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 are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Furthermore, the shipping warehouse determination 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 to which any peripheral device is connected. Furthermore, the shipping warehouse determination device 100 may be realized by installing software (including programs, data, etc.) that makes the device realize the processing described in this embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

The present invention is particularly useful in business formats where the same product is stored in multiple warehouses or where shipping warehouses need to be changed depending on the customer.

100 Shipping warehouse determination device 102 Control unit
102a Master maintenance department
102b Order registration department
102c Shipping warehouse determination unit 104 Communication interface unit 106 Storage unit
106a Warehouse judgment master
106b Current inventory information 108 Input/output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A shipping warehouse determination device comprising a control unit,
The control unit includes:
Based on the set product and the set customer or delivery destination, refer to the warehouse judgment master that manages the warehouse by product and business partner, and the current inventory information that manages the current number of products in stock by product and warehouse. and a shipping warehouse determining means for determining a warehouse associated with the set product and the set customer or delivery destination that has the set product in stock as the shipping warehouse ,
The warehouse is a warehouse that manages food products, and the products are food products.
A shipping warehouse determination device characterized by: The warehouse determination master stores ranks indicating priorities of shipping warehouses,
If there are multiple warehouses linked to the set product and the set customer or delivery destination that have the set product in stock, the shipping warehouse determining means is configured to determine whether or not each of the plurality of warehouses has the set product in stock. Determining the warehouse with the highest rank as the shipping warehouse;
The shipping warehouse determining device according to claim 1, characterized in that: The control unit further includes order registration means for registering orders for products,
When the product to be ordered and the customer or delivery destination are set, the order registration means passes the set product and the set customer or delivery destination to the shipping warehouse determining means, and the shipping warehouse is determined. receiving the determination result returned from the means;
The shipping warehouse determining device according to claim 1 or 2, characterized in that: A shipping warehouse determination method executed by an information processing device including a control unit, the method comprising:
executed by the control unit,
Based on the set product and the set customer or delivery destination, refer to the warehouse judgment master that manages the warehouse by product and business partner, and the current inventory information that manages the current number of products in stock by product and warehouse. a shipping warehouse determination step of determining a warehouse associated with the set product and the set customer or delivery destination that has the set product in stock as the shipping warehouse ;
The warehouse is a warehouse that manages food products, and the products are food products.
A shipping warehouse determination method characterized by: A shipping warehouse determination program to be executed by an information processing device including a control unit, the program comprising:
for the control unit to execute,
Based on the set product and the set customer or delivery destination, refer to the warehouse judgment master that manages the warehouse by product and business partner, and the current inventory information that manages the current number of products in stock by product and warehouse. a shipping warehouse determination step of determining a warehouse associated with the set product and the set customer or delivery destination that has the set product in stock as the shipping warehouse ;
The warehouse is a warehouse that manages food products, and the products are food products.
A shipping warehouse determination program featuring:

Images