JP7437217B2 - Inventory management device, inventory management method, and inventory management program - Google Patents

Description

The present invention relates to an inventory management device, an inventory management method, and an inventory management program.

For example, when receiving an order for a product from a business partner, the product is shipped after allocating inventory in the warehouse. Here, there are cases where the status (product rank) of products that can be handled is determined by the business partner. For example, if your business partner has high requirements for product quality, you may not want automatic reservations to be made. As a conventional inventory allocation system, for example, there is Patent Document 1.

JP2017-208026A

However, Patent Document 1 does not describe anything regarding whether or not to automatically allocate inventory according to the product rank.

The present invention has been made in view of the above, and provides inventory management that can prevent erroneous shipments to business partners by determining whether or not to automatically allocate inventory according to product rank. The purpose is to provide a device, an inventory management method, and an inventory management program.

In order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory management device that includes a storage section and a control section, and the storage section stores information such as products, lots, quantities, and inventory for each warehouse. A table in which inventory information of product ranks, which are statuses, is registered is stored, and the control unit includes an order data input means for inputting order data including business partners, warehouses, product ranks, products, and quantities; The present invention is characterized by comprising a shipping instruction processing means for making inventory reservations for the products of the order data with reference to the above, and determining whether or not automatic reservations can be made according to the product rank of the products.

Further, according to one aspect of the present invention, the shipping instruction processing means may not perform automatic allocation when the product rank is high quality.

Further, in order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory management method for causing an information processing device including a control unit and a storage unit to execute the inventory management method, wherein the storage unit includes a warehouse. For each table, a table is stored in which inventory information of the product, lot, quantity, and product rank, which is the inventory status, is registered. An order input step for inputting data; and a shipping instruction processing step for referring to the inventory information, making inventory reservations for the products in the order data, and determining whether or not automatic reservations can be made according to the product rank of the product. It is characterized by including.

Further, in order to solve the above-mentioned problems and achieve the objects, the present invention provides an inventory management program to be executed by an information processing device including a control section and a storage section, the storage section including:
Each warehouse stores a table in which inventory information of the product, lot, quantity, and product rank, which is the stock status, is registered. a shipping instruction processing step of making inventory reservations for the products in the order data by referring to the inventory information, and determining whether or not automatic reservations can be made according to the product rank of the products; An inventory management program for executing on a computer.

According to the present invention, it is possible to prevent erroneous shipments to business partners by determining whether or not to automatically allocate inventory according to the product rank.

FIG. 1 is a diagram showing a processing image of this embodiment. FIG. 2 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. FIG. 3 is a diagram showing an example of the configuration of the product rank master. FIG. 4 is a diagram showing a flow for explaining the overall processing flow of the inventory management device according to the present embodiment. FIG. 5 is a diagram showing sample data for explaining a specific example of shipping instruction processing by the shipping instruction processing section. FIG. 6 is a diagram showing a display example of the shipping instruction screen. FIG. 7 is a diagram showing a display example of the shipping instruction screen.

Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
For example, when receiving an order for a product from a business partner, the product is shipped after allocating inventory in the warehouse. Here, there are cases where the status (product rank) of products that can be handled is determined by the business partner. For example, if your business partner has high requirements for product quality, you may not want automatic reservations to be made.

Previously, it was not possible to select whether or not automatic reservation should be made depending on the inventory status (product rank). Therefore, as a result of prioritizing the operational efficiency of automatic reservations, human errors were occurring that led to incorrect shipments to business partners who had strict requirements regarding inventory status.

Therefore, in this embodiment, it is determined whether or not to automatically allocate inventory according to the product rank, thereby preventing erroneous shipments to customers with strict requirements.

FIG. 1 is a diagram showing a processing image of this embodiment. In FIG. 1, the inventory status of the target product is confirmed by inventory inquiry. In order entry, the status of inventory to be shipped is selected depending on the customer. Here, if automatic reservation is not used, specify the lot. In shipping instruction processing, automatic reservation/manual reservation is controlled depending on the status of the inventory to be reserved.

[2. composition]
An example of the inventory management device according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of an inventory management device according to the present embodiment. In FIG. 1, cost management device 100 is a commercially available desktop personal computer. Note that the cost management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but also a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. It may also be an information processing device. The inventory management 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 inventory management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the inventory 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 a communication line. Here, the network 300 has a function of connecting the inventory management device 100, the server device 200, and a terminal device (not shown) so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

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. In addition, below, the output device 114 may be described as the monitor 114.

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 includes a product rank master 106a, an inventory information table 106b, an order table 106c, and a shipping instruction table 106d. FIG. 2 is a diagram showing an example of the configuration of the product rank master.

The product rank master 106a is a master for determining whether or not automatic allocation is possible according to the product rank. As shown in FIG. 2, the product rank master 106a can be composed of a table or the like in which product ranks and the presence or absence of automatic allocation targets are registered in association with each other. In the example shown in Figure 2, if the product rank is "regular product", it is subject to automatic reservation, if the product rank is "specific product", it is not eligible for automatic reservation, and if the product rank is "modified", it is not subject to automatic reservation. . The product rank (quality) increases in the order of specific product>normal product>modified product.

The inventory information table 106b is a table for storing inventory information. The inventory information may include data on the business office, warehouse name, product, lot, quantity, and product rank, which is the inventory status (see FIG. 5(A)).

The order table 106c is a table for storing order data. The order data may include data on order number, customer, delivery destination, warehouse, product rank, product, quantity, and scheduled shipping date (see FIG. 5(B)).

The shipping instruction table 106d is a table for storing shipping instruction data. The shipping instruction data may include data on shipping instruction number, customer, delivery destination, warehouse, product, lot, quantity, warehouse, and rank (see FIG. 5(B)).

The control unit 102 is a CPU or the like that controls the inventory management device 100 in an integrated manner. 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. Functionally, the control unit 102 includes a data registration unit 102a, an inventory inquiry unit 102b, an order input unit 102c, a shipping instruction processing unit 102d, a screen display control unit 102e, and a master maintenance unit 102f. .

The data registration unit 102a inputs and updates inventory information according to an operator's operation on an input screen displayed on the monitor 114, for example, and stores the information in the inventory information table 106b.

For example, the inventory inquiry unit 102b refers to the inventory information table 106b and checks the inventory status of the target product in response to an operator's operation on the inventory inquiry screen displayed on the monitor 114.

For example, the order entry unit 102c inputs order data including business partner, warehouse, product rank, product, and quantity in response to an operator's operation on the order entry screen displayed on the monitor 114, and creates an order table 106c. Store in.

For example, the shipping instruction processing unit 102d refers to the inventory information in the inventory information table 106b in response to an operator's operation on the shipping instruction screen displayed on the monitor 114, and allocates inventory for the product in the order data. The shipping instruction data is created and stored in the shipping instruction table 106d. At this time, the shipping instruction processing unit 102d determines whether or not automatic reservation is possible according to the product rank of the product in the order data.

Specifically, the shipping instruction processing unit 102d refers to the product rank master 106a, obtains whether or not the product is eligible for automatic reservation corresponding to the product rank of the product in the order data, and if the product is eligible for automatic reservation, the product is automatically reserved. Reserve will be made, but if the amount is not eligible for automatic reservation, automatic reservation will not be made. If automatic reservation is not performed, the operator manually reserves inventory. The shipping instruction processing unit 102d may decide not to perform automatic allocation when the product rank is high quality (for example, a specific product). Further, if the product rank is low quality (for example, a modified product), automatic reservation may not be performed.

The screen display control unit 102e controls the display and input of various input screens (eg, inventory information registration screen, inventory inquiry screen, order entry screen, shipping instruction screen, master maintenance screen, etc.) displayed on the monitor 114.

The master maintenance section 102f is for editing data such as inputting, adding, and changing data to the product rank master 106a in response to operations by an administrator or the like on a master maintenance screen (not shown) displayed on the monitor 114. It is.

[3. Concrete example]
A specific example of the processing of the inventory management device 100 according to the present embodiment will be described with reference to FIGS. 1 to 5. FIG. 4 is a diagram showing a flow for explaining the overall processing flow of the control unit 102 of the inventory management device 100 according to the present embodiment.

The overall processing flow of inventory management device 100 according to this embodiment will be described with reference to FIG. 4. In FIG. 4, first, the inventory inquiry unit 102b executes an inventory inquiry process (step S1). Specifically, in the inventory inquiry process, the inventory inquiry unit 102b checks the inventory status of the target product, for example, in response to an operator's operation on the inventory inquiry screen displayed on the monitor 114.

The order input unit 102c executes order input processing (step S2). Specifically, in the order entry process, the order entry unit 102c inputs information including the business partner, warehouse, product rank, product, and quantity according to the operator's operation on the order entry screen displayed on the monitor 114, for example. Order data is input and stored in the order table 106c.

The shipping instruction processing unit 102d executes shipping instruction processing (step S3). Specifically, in the shipping instruction process, the shipping instruction processing unit 102d refers to the inventory information in the inventory information table 106b in response to an operator's operation on the shipping instruction screen displayed on the monitor 114, for example. Inventory allocation is made for the products in the order data, shipping instruction data is created, and the shipping instruction data is stored in the shipping instruction table 106d. At this time, the shipping instruction processing unit 102d determines whether or not automatic reservation is possible according to the product rank of the product in the order data.

Specifically, the shipping instruction processing unit 102d refers to the product rank master 106a, obtains whether or not the product is eligible for automatic reservation corresponding to the product rank of the product in the order data, and if the product is eligible for automatic reservation, the product is automatically reserved. Reserve will be made, but if the amount is not eligible for automatic reservation, automatic reservation will not be made. If automatic reservation is not performed, the operator manually reserves inventory. The shipping instruction processing unit 102d may decide not to perform automatic allocation when the product rank is high quality (for example, a specific product). Further, if the product rank is low quality (for example, a modified product), automatic reservation may not be performed.

FIG. 5 is a diagram showing sample data for explaining a specific example of shipping instruction processing by the shipping instruction processing section 102d.

A specific example of shipping instruction processing by the shipping instruction processing unit 102d will be described with reference to FIG. FIG. 5(A) is a diagram showing an example of inventory information data (before shipping instruction processing). In the example of inventory information shown in FIG. 5(A), for the product "Product A" in the warehouse "A" of the business "Chiba", the lot "0605" has a quantity of "800", a product rank of "regular product", Lot "0607" has a quantity of "400" and a product rank of "regular product". Lot "0608" has a quantity of "400" and a product rank of "specific product". Lot "0609" has a quantity of "400" and a product rank of "regular product". "Deformation".

According to the product rank master 106a in FIG. 3, a product rank of "regular product" is subject to automatic reservation, "specific product" is not subject to automatic reservation, and "modified" is not subject to automatic reservation.

(1) The case of shipping instructions for orders subject to automatic reservation will be explained. As shown in Figure 5(B), the order data includes order number "J0001", customer "Customer A", delivery address "Delivery address X", warehouse "Before shipping to Chiba", product rank "Regular product", The product is "Product A", the quantity is "1000", and the scheduled shipping date is "6/26". Since the product rank is ``regular item,'' automatic reservation is made as shown in the shipping instruction data, and the quantity ``800'' of lot ``0605'' and the quantity ``200'' of lot ``0607'' are reserved. Automatic reservation may be performed on a first-in, first-out basis, for example.

(2) The case of shipping instructions for orders that are not subject to automatic reservation will be explained. As shown in Figure 5(C), the order data includes order number "J0001", customer "Customer A", delivery destination "Delivery to" X, warehouse "Before shipping to Chiba", product rank "Specific product", The product is "Product A", the quantity is "200", and the scheduled shipping date is "6/26". Since the product rank is "specific product", automatic allocation is not performed as shown in the shipping instruction data of FIG. 5(C). The lot, quantity, warehouse, and rank are blank, indicating that the item has not been reserved. In this case, the operator manually reserves inventory.

6 and 7 are diagrams showing display examples of the shipping instruction screen. For example, on the screen shown in FIG. 6, target order data can be confirmed using the shipping instruction date, warehouse, scheduled shipping date, and product rank as search conditions. On the screen shown in FIG. 7, inventory reservation can be made by specifying the order number, product, and product rank. In the example shown in the figure, the product rank "regular product" is specified for product A, and the quantity "800" of lot "0605" and the quantity "200" of lot "0607" are automatically allocated. ing. When the product rank "Specific Product" is specified, automatic reservation is not performed, so inventory can be manually reserved in the area designated by the lot.

As explained above, according to the present embodiment, there is a table in which the inventory information of the product, lot, quantity, and product rank, which is the stock status, is registered for each warehouse, and a table that registers the inventory information of the product, lot, quantity, and product rank, which is the stock status, and the an order entry unit 102c that inputs order data including order data; and a shipping instruction that refers to inventory information, makes inventory reservations for the products in the order data, and determines whether or not automatic reservations can be made according to the product rank of the product. Since the processing unit 102d is provided, it is possible to prevent erroneous shipments to business partners by determining whether or not to automatically allocate inventory according to the product rank.

[4. 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 inventory management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the inventory management device 100, especially each processing function performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is stored in the inventory management device as necessary. Machine read to 100. That is, in a storage unit 106 such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

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

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.

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

Further, the inventory 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 to which any peripheral device is connected. Further, the inventory management device 100 may be realized by installing software (including programs, data, etc.) that causes the information processing device to realize the processing described in this embodiment.

Furthermore, the specific form of dispersion/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 additions of functions. 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.

100 Inventory management device 102 Control unit 102a Data registration unit 102b Inventory inquiry unit 102c Order entry unit 102d Shipping instruction processing unit 102e Screen display control unit 102f Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Product rank master 106b Inventory information table 106c Order reception Table 106d Shipping instruction table 108 Input/output interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

An inventory management device comprising a storage unit and a control unit,
In the storage unit,
A product rank master that is registered by associating the product rank with whether or not it is subject to automatic reservation,
For each warehouse, there is a table that registers inventory information of products, lots, quantities, and product ranks, which are inventory status.
is stored,
The control unit includes:
an order data input means for inputting order data including business partner, warehouse, product rank, product, and quantity;
Referring to the inventory information, perform inventory reservation for the product in the order data , and at that time, refer to the product rank master to obtain whether the product rank of the product in the order data is subject to automatic reservation. A shipping instruction processing means that automatically makes reservations if the shipping instruction is eligible for automatic reservations and does not make automatic reservations if the shipping instructions are not eligible for automatic reservations ;
An inventory management device characterized by: 2. The inventory management device according to claim 1, wherein the shipping instruction processing means does not perform automatic reservation when the product rank is high quality. An inventory management method executed by an information processing device including a control unit and a storage unit, the method comprising:
In the storage unit,
A product rank master that is registered by associating the product rank with whether or not it is subject to automatic reservation,
For each warehouse, there is a table that registers inventory information of products, lots, quantities, and product ranks, which are inventory status.
is stored,
executed in the control unit,
an order entry step for entering order data including business partner, warehouse, product rank, product, and quantity;
Refer to the inventory information to make inventory reservation for the product in the order data , and at that time, refer to the product rank master to obtain whether the product rank of the product in the order data is subject to automatic reservation. a shipping instruction processing step in which automatic reservation is made if the automatic reservation is applicable, and automatic reservation is not performed if the automatic reservation is not applicable ;
An inventory management method characterized by comprising: An inventory management program to be executed by an information processing device including a control unit and a storage unit,
In the storage unit,
A product rank master that is registered by associating the product rank with whether or not it is subject to automatic reservation,
For each warehouse, there is a table that registers inventory information of products, lots, quantities, and product ranks, which are inventory status.
is stored,
In the control section,
an order entry step for entering order data including business partner, warehouse, product rank, product, and quantity;
Referring to the inventory information, perform inventory reservation for the product in the order data , and at that time, refer to the product rank master to obtain whether the product rank of the product in the order data is subject to automatic reservation. a shipping instruction processing step in which automatic reservation is made if the automatic reservation is applicable, and automatic reservation is not performed if the automatic reservation is not applicable ;
Inventory management program to run.

Images