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

Abstract

To provide a shipping warehouse determination device and the like, capable of determining an appropriate shipping warehouse, which, as a result, can resolve complicity in operation and dependency on individual skills.SOLUTION: According to the present embodiment, a device includes the steps of: 1) an order reception entry section passes product codes and client codes or shipping destination codes that are set at an order reception input screen to a shipping warehouse determination section; 2) the shipping warehouse determination section refers to, based on the passed information, a warehouse determination master and current inventory information, for determining shipping warehouses, and returns a determination result to the order reception entry section; and 3) the order reception entry section enters an order reception, based on the returned determination result.SELECTED DRAWING: Figure 3

Description

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

In the food industry, for example, products with different temperature zones during storage, such as refrigerated products, are managed in separate warehouses, and inventories are held near the consumption area from the viewpoint of expiration date, so products are stored in multiple warehouses. Often managed. In the food industry, goods may also be delivered directly to a warehouse managed by the customer. Therefore, when an order for a product in stock in a plurality of warehouses is received from a customer, it is necessary to determine the shipping warehouse of the product. In the past, the person in charge of ordering made this judgment by manually checking the location of the customer, the warehouse in which the product was in stock, the distance between the customer and the warehouse, and the area.

Patent Document 1 describes a method for smoothly performing warehousing / delivery operations when moving goods between warehouses and delivering the goods to a customer.

Japanese Unexamined Patent Publication No. 2019-066949

However, the conventional manual judgment method has problems of complicated work and personalization. In addition, from the viewpoint of the appropriateness of judgment, there is still room for improvement in the conventional manual judgment method.

The present invention has been made in view of the above, and is a shipping warehouse determining device and a shipping warehouse that can determine an appropriate shipping warehouse and can eliminate complicated work and personalization. It is an object of the present invention to provide a determination method and a shipping warehouse determination program.

In order to solve the above-mentioned problems and achieve the object, the shipping warehouse determination device according to the present invention is a shipping warehouse determination device including a control unit, and the control unit is a set product and a set specialty. The set product and the relevant product and the relevant It is characterized in that it is provided with a shipping warehouse determining means for determining a warehouse associated with a set customer or a delivery destination and having 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 the priority order of the shipping warehouse, and the shipping warehouse determining means is the set product and the set. If there are multiple warehouses associated with the customer or delivery destination that have the set product in stock, the warehouse with the highest rank among the multiple warehouses is determined as the shipping warehouse. It is a feature.

Further, in the shipping warehouse determination device according to the present invention, the control unit further includes an order registration means for registering an order for a product, and the order registration means is set with a product to be registered as an order and a customer or a delivery destination. It is characterized in that the set product and the set customer or delivery destination are passed to the shipping warehouse determination means, and the determination result returned from the shipping warehouse determination means is received.

Further, the shipping warehouse determination method according to the present invention is a shipping warehouse determination method executed by an information processing apparatus including a control unit, and is executed by the control unit, and is a set product and a set customer or a set customer. Based on the delivery destination, the set product and the set are set by referring to the warehouse judgment master that manages the warehouse by product and business partner and the current warehouse information that manages the current number of products by product and by warehouse. It is characterized by including a shipping warehouse determination step of determining a warehouse associated with a customer or a delivery destination and having 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 for being executed by an information processing apparatus including a control unit, and is a set product and a set specialty for being executed by the control unit. The set product and the relevant product and the relevant It is characterized by including a shipping warehouse determination step of determining a warehouse associated with a set customer or delivery destination and having 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 complicated work and the personalization.

FIG. 1 is a block diagram showing an example of the configuration of the 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 showing an example of a flowchart relating to 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 input screen MB.

Hereinafter, embodiments of the shipping warehouse determination device, the shipping warehouse determination method, and the shipping warehouse determination program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present 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 the shipping warehouse determination device 100.

The shipping warehouse determination device 100 is constructed based on a commercially available desktop personal computer. The shipping warehouse determination device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

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

The communication interface unit 104 connects the shipping warehouse determination device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the shipping warehouse determination device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. 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, a speaker or a printer can be used in addition to a monitor (including a home television). 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. In the following, 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.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. 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, or the like can be used.

The storage unit 106 stores, for example, the warehouse determination master 106a, the current warehouse 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 the customer classification identification information (for example, the name of the business partner classification), the business partner identification information (for example, the business partner code), the product identification information (for example, the product code), and the shipment. Includes a rank indicating the priority of the warehouse and warehouse identification information (eg, warehouse code). The rank is 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 there are multiple or singular inventory locations for each product, and if there are multiple, where is the main warehouse. Set in consideration of circumstances such as.

The current warehouse 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 collectively controls the shipping warehouse determination device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 is functionally and conceptually provided with a master maintenance unit 102a, an order registration unit 102b corresponding to the order registration means of the present invention, a shipping warehouse determination unit 102c corresponding to the shipping warehouse determination means of the present invention, and the like.

The master maintenance unit 102a manages (for example, new registration, modification, or deletion) of the warehouse determination master 106a based on the set supplier classification identification information, supplier identification information, product identification information, rank, and warehouse identification information. Etc.).

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

The shipping warehouse determination unit 102c sets the warehouse determination master 106a and the current warehouse 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 is identified by the set product identification information and the warehouse identification information associated with the set customer identification information or the delivery destination identification information, and the set product identification information is used. The in-stock item of the identified item is determined as the shipping warehouse.

Further, the shipping warehouse determination unit 102c is a warehouse identified by the set product identification information and the set customer identification information or the warehouse identification information associated with the delivery destination identification information, and is the warehouse identified by the set product identification information. If there are a plurality of identified goods in stock, the warehouse with the highest rank among the plurality of warehouses is determined as the shipping warehouse.

Specific examples 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 the 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 showing an example of a flowchart relating to 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 unit 102a has registered the warehouse determination master 106a in advance as shown in FIG. 5 by the setting on the warehouse determination master maintenance screen MA shown in FIG.

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

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

Next, the shipping warehouse determination unit 102c determines the shipping warehouse with reference to the warehouse determination master 106a and the current warehouse information 106b shown in FIG. 5 based on the information passed from the order registration unit 102b in step S1. 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 registers the order 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 by the shipping warehouse determining unit 102c as the shipping warehouse is displayed at the bottom of each order input. In the order input screen MB1 shown in FIG. 6, the warehouse code “K001” associated with the customer classification “0: customer”, the customer code “T001”, and the product code “S001” of the warehouse determination master 106a shown in FIG. 5 The warehouse is determined to be the shipping warehouse. Further, on the order input screen MB2 shown in FIG. 6, the warehouse code “K002” associated with the customer classification “0: customer”, the customer code “T001”, and the product code “S002” of the warehouse determination master 106a shown in FIG. Is determined to be the shipping warehouse. Further, on the order input screen MB3 shown in FIG. 6, among the warehouse codes associated with 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 product of the product code "S001" is in stock in the warehouse of the warehouse code "K003" having the highest rank, it is determined as the warehouse code "K003". Further, on the order input screen MB4 shown in FIG. 6, among the warehouse codes associated with the customer classification “1: delivery destination”, the customer code “N001”, and the product code “S001” of the warehouse determination master 106a shown in FIG. , The warehouse with the highest rank warehouse code "K003" is out of stock of the product with the product code "S001", and the warehouse with the next highest rank warehouse code "K004" is in stock with the product with the product code "S001". Since there was, it is determined that the warehouse code is "K004".

From the above processing, the shipping warehouse can be easily determined by automatically determining the shipping warehouse when the order data is registered. In the explanation of this specific example, the product and the customer or the delivery destination to be registered as an order are set by inputting to the order input screen MB shown in FIG. 6, but instead, the order data by EDI (Electronic Data Interchange) is set. Goods and customers or delivery destinations may be set by importing. Further, when both the customer and the delivery destination are set at the time of order registration, the shipping warehouse determination unit 102c first acquires the warehouse associated with the delivery destination by referring to the warehouse determination master 106a. If the warehouse determination master 106a does not have a warehouse associated with the delivery destination, the warehouse determination master 106a may be subsequently referred to to acquire the warehouse associated with the customer.

In addition, when the same product is stored in multiple warehouses, by ranking the priority to be judged as the shipping warehouse and registering it in the system in advance, the rank in which the product is in stock at the time of order data registration is the highest. The warehouse can be automatically determined as the shipping warehouse.

Here, in the food industry, products are often managed in a plurality of warehouses. The background is, for example, managing products with different temperature zones such as refrigerated products in a separate warehouse, and having inventory near the consumption area from the viewpoint of the expiration date. In some cases, products are delivered directly to a customer-managed warehouse. When there is an order from a customer for products stocked in such a plurality of warehouses, according to the present embodiment, for example, it is possible to determine the shipping warehouse that can be shipped earliest, so that the opportunity loss of orders can be lost. Can be prevented. In the present embodiment, the inventory warehouse of each product, the distance to the customer, the area, and the like may be taken into consideration to determine the warehouse to be preferentially allocated. Further, since electronic transactions are progressing in the food industry, in the present embodiment, an appropriate shipping warehouse may be automatically determined based on order data from a customer and a shipping instruction may be given. That is, in the present embodiment, the shipping warehouse can be automatically determined in both cases of input by the operator and EDI.

Further, in the past, it was necessary for the operator to judge and specify a reserved warehouse that differs depending on the location of the customer, the product, and the like. Then, in order to make that judgment, it is necessary for the operator to grasp the difference in the storage warehouse depending on the product, the distance between the warehouse and the customer, the area, etc., and the work is complicated and personalized. According to this embodiment, by registering in advance from which warehouse each product is shipped with the customer of the shipping destination, for example, the shipping warehouse is automatically determined at the time of order data registration and allocation is performed. Can solve the problem. In this embodiment, when the same product is stored in a plurality of warehouses, the allocation priority order can be registered.

[3. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the shipping warehouse determination device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the shipping warehouse determination device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program that is interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the shipping warehouse is determined as necessary. It is read mechanically by the device 100. 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 an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

Further, this computer program may be stored in the application program server connected to the shipping warehouse determination device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "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 EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

The "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration or procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, 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 an arbitrary peripheral device is connected. Further, the shipping warehouse determination device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Further, the specific form of distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is particularly useful in a business format in which the same product is stored in a plurality of warehouses or in a business format in which the shipping warehouse needs to be changed depending on the business partner.

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

Claims (5)

It is a shipping warehouse judgment device equipped with a control unit.
The control unit
Refer to the warehouse judgment master that manages the warehouse by product and customer based on the set product and the set customer or delivery destination, and the current warehouse information that manages the current number of products by product and by warehouse. Therefore, it is provided with a shipping warehouse determination means for determining a warehouse associated with the set product and the set customer or delivery destination as a shipping warehouse in which the set product is in stock.
A shipping warehouse determination device characterized by. The warehouse determination master stores ranks indicating the priority of the shipping warehouse.
When there are a plurality of warehouses associated with the set product and the set customer or delivery destination in which the set product is in stock, the shipping warehouse determination means of the plurality of warehouses. Judging the warehouse with the highest rank as the shipping warehouse,
The shipping warehouse determination device according to claim 1. The control unit further includes an order registration means for registering an order for a product.
When the product and the customer or the delivery destination to be registered as an order are set, the order registration means passes the set product and the set customer or the delivery destination to the shipping warehouse determination means, and determines the shipping warehouse. Receiving the judgment result returned from the means,
The shipping warehouse determination device according to claim 1 or 2. It is a shipping warehouse determination method executed by an information processing device equipped with a control unit.
Executed by the control unit,
Refer to the warehouse judgment master that manages the warehouse by product and customer based on the set product and the set customer or delivery destination, and the current warehouse information that manages the current number of products by product and by warehouse. Including a shipping warehouse determination step of determining a warehouse associated with the set product and the set customer or delivery destination as a shipping warehouse that has the set product in stock.
A shipping warehouse determination method characterized by. It is a shipping warehouse judgment program to be executed by an information processing device equipped with a control unit.
To make the control unit execute
Refer to the warehouse judgment master that manages the warehouse by product and customer based on the set product and the set customer or delivery destination, and the current warehouse information that manages the current number of products by product and by warehouse. Including a shipping warehouse determination step of determining a warehouse associated with the set product and the set customer or delivery destination as a shipping warehouse that has the set product in stock.
A shipping warehouse judgment program characterized by.

Images