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

Abstract

To reduce the work load related to the management of best-before dates when managing the inventory in a contract warehouse.SOLUTION: An inventory management device according to the present embodiment includes order input means for inputting order data including order number, client, commodity, and number of orders, and allocation means for allocating the inventory to the order data. At that time, first, the inventory is allocated to the order data by referring to first current inventory data in which commodities and quantity of stocks of a contract warehouse are registered. Next, regarding commodities and clients for which best-before dates are allocated by referring to the commodity master and the client master, among the order data to which the inventory has been allocated, the best-before dates are allocated with reference to second current inventory data in which commodities, quantity of stocks, and best-before dates of the contract warehouse are registered. The inventory management device further includes shipping instruction creation means for creating shipping instruction data for the contract warehouse, with regard to the order data after allocation.SELECTED DRAWING: Figure 2

Description

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

For example, in an industry such as a food sales company, there is a case where groceries are managed in a consignment warehouse and a shipping instruction is given to the consignment warehouse according to an order from a customer. Conventionally, as an inventory management system for managing inventory in a consignment warehouse, for example, there is Patent Document 1.

Japanese Unexamined Patent Publication No. 2018-101278

However, Patent Document 1 does not describe anything regarding the management of the expiration date in the case of inventory management in a consignment warehouse.

The present invention has been made in view of the above, and provides an inventory management device, an inventory management method, and an inventory management program capable of reducing the work load related to the management of the expiration date in the case of inventory management in a consignment warehouse. The purpose is to do.

In order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management device for a trader who has a storage unit and a control unit and outsources the warehouse business to a consignment warehouse. Stores a product master in which the expiration date allocation target / non-target is registered for each product, and a customer master in which the expiration date allocation target / non-target is registered for each customer. , Order entry means for inputting order data including order number, customer, product, and order quantity, and stock allocation for the order data. At that time, first, the product and inventory quantity of the consignment warehouse are registered. With reference to the first current warehouse data, inventory is allocated to the order data, and then, among the order data to which the inventory is allocated, the expiration date allocation is made with reference to the product master and the customer master. For the target products and customers, refer to the second current warehouse data in which the products in the consignment warehouse, the number of stocks, and the expiration date are registered, and outsource the allocation means for allocating the expiration date and the order data after allocation. It is characterized by being provided with a shipping instruction creating means for creating shipping instruction data for a warehouse.

Further, according to one aspect of the present invention, the first current warehouse data is managed by the inventory management device, the second current warehouse data is managed by the consignment warehouse side, and the inventory management device is used. It may be synchronized with the second current warehouse data of the consignment warehouse.

Further, according to one aspect of the present invention, when the allocation means allocates the expiration date of the second current warehouse data, the order data and the consignment warehouse, the customer, and the existing shipping instruction data having the same product are used. With reference to this, the expiration date of the final shipment may be acquired, and the inventory after the acquired expiration date of the final shipment may be allocated.

Further, according to one aspect of the present invention, the order data includes data on the number of cases, and when the allocation means allocates the expiration date of the second current warehouse data, the expiration date is set within one case. Arrangements may be made to prevent different products from being packed.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management method for causing an information processing apparatus including a control unit and a storage unit to execute the data, and the storage unit is a product. A product master that has registered the expiration date allocation target / non-target is stored for each customer, and a customer master that has registered the expiration date allocation target / non-target for each customer, and is executed by the control unit. , Order entry process for inputting order data including order number, customer, product, and order quantity, and allocation of inventory for the order data. At that time, first, the product and inventory quantity of the consignment warehouse are registered. With reference to the first current warehouse data, inventory is allocated to the order data, and then, among the order data to which the inventory is allocated, the expiration date allocation is made with reference to the product master and the customer master. For the target products and customers, refer to the second current warehouse data in which the products in the consignment warehouse, the number of stocks, and the expiration date are registered, and outsource the allocation process for allocating the expiration date and the order data after allocation. It is characterized by including a shipping instruction creating process for creating shipping instruction data for a warehouse.

Further, in order to solve the above-mentioned problems and achieve the object, the present invention is an inventory management program for causing an information processing apparatus provided with a control unit and a storage unit to execute, and the storage unit includes the storage unit.
A product master that registers the expiration date allocation target / non-target for each product and a customer master that registers the expiration date allocation target / non-target for each customer are stored, and the control unit receives an order. An order entry process for inputting order data including numbers, customers, products, and the number of orders, and inventory allocation for the order data, at which time, first, the products and the number of stocks in the consignment warehouse are registered. With reference to the current warehouse data of 1, inventory is allocated to the order data, and then, among the order data to which the inventory is allocated, the product master and the customer master are referred to to allocate the expiration date. For products and customers, refer to the second current warehouse data for registering the products, the number of stocks, and the expiration date of the consignment warehouse, and for the allocation process for allocating the expiration date and the order data after allocation to the consignment warehouse. It is characterized by being a shipping instruction creating process for creating shipping instruction data and an inventory management program for executing the process.

According to the present invention, there is an effect that it becomes possible to reduce the work load related to the management of the expiration date when the inventory is managed in the consignment warehouse.

FIG. 1 is a diagram showing a processing image of an inventory management system (device) in the present embodiment. FIG. 2 is a block diagram showing an example of the configuration of the inventory management device (system) according to the present embodiment. FIG. 3 is a diagram showing a configuration example of the product master. FIG. 4 is a diagram showing a configuration example of the customer master. FIG. 5 is a diagram showing a flow for explaining the overall processing flow of the control unit of the inventory management device according to the present embodiment. FIG. 6 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment. FIG. 7 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment. FIG. 8 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment. FIG. 9 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment. FIG. 10 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment. FIG. 11 is a diagram for explaining the flow of processing of the control unit of the inventory management device according to the present embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. overview]
For example, in an industry such as a food sales company, there is a case where groceries are managed in a consignment warehouse and a shipping instruction is given to the consignment warehouse according to an order from a customer.

Since it is a grocery product, it is necessary to ship the products stored in the consignment warehouse in order from the one with the oldest expiration date. Basically, shipping is left to the consignment warehouse side, but for some customers who have strict expiration dates, it was necessary for the food sales company to specify the expiration date and ship it.

However, for example, since the picking method has been established on the consignment warehouse side, if all food products are specified as the expiration date for the consignment warehouse, the picking work load on the consignment warehouse side will increase, and all food sales companies will send all the food products. It is difficult to specify the expiration date for a product.

In the past, it was handwritten by referring to the expiration date information of the consignment warehouse, but it is checked whether the expiration date is reversed (whether the product with the expiration date older than the expiration date shipped in the past is shipped). However, since it is a person's judgment, mistakes occur frequently and the difference in the best-by date may be a complaint depending on the customer.

In addition, it is not realistic to manage the expiration date on the system for all products because the purchasing work and the registration work of the arrival record information of the consignment warehouse become complicated and the work load becomes high.

Therefore, in the present embodiment, in order to reduce the work load related to the management of the expiration date in the case of inventory management in the consignment warehouse, in the case of inventory management in the consignment warehouse, for a specific customer / product at the time of shipment. We have built a mechanism that allows you to specify the expiration date, and have configured it so that shipping instruction data that automatically sets the expiration date of the product at the time of shipment can be output to the consignment warehouse for a specific customer / product.

FIG. 1 is a diagram showing a processing image of an inventory management system (device) in the present embodiment. The inventory management system of the present embodiment can be suitably used in, for example, a company that manages inventory in a consignment warehouse (warehouse of another company) such as a food sales company sales company.

The inventory management system does not manage the inventory according to the expiration date (quantity only), and synchronizes with the second current warehouse data according to the expiration date from the consignment warehouse system. That is, the inventory management system manages only the first current warehouse data (quantity only) without the expiration date management of the consignment warehouse, and the second current warehouse data with the expiration date management managed by the consignment warehouse system. The data is retained in synchronization with the second current warehouse data with expiration date management held by the consignment warehouse system (in units of several hours).

For example, the inventory management system updates its own second current warehouse data with expiration date management by referring to the second current storage data with expiration date management held by the consignment warehouse system every few hours. The inventory management system specifies the expiration date only for specific customer / product data and requests it to the consignment warehouse system (for example, the number of specified expiration dates is about 10% of the total).

Explaining an operation example, the inventory management system performs inventory allocation processing (T2) when order data is input (accounted) (T1). In the allocation process (T2), first, inventory is allocated to the ordered quantity by referring to the first current stock data (without expiration date management) managed by the inventory management system. Next, among the order data that was successfully allocated, refer to the master and refer to the second current warehouse data (with expiration date management) synchronized with the consignment warehouse system for customers and products that require expiration date management. Then, the expiration date information is reserved.

Of the order data that has been successfully allocated, shipping instruction data is created for those that do not require expiration date management, and for those that require expiration date management, shipping instruction data is created for those that have successfully allocated expiration date information. Create (T3). Send the created shipping instruction data to the consignment warehouse system. In the consignment warehouse system, inventory allocation (T4) and picking / shipping (T5) are performed according to the shipping instruction data.

[2. Constitution]
An example of the inventory management device according to the present embodiment will be described with reference to FIG. FIG. 2 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. In FIG. 2, the inventory management 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 inventory management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the inventory management 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 inventory management device 100 to the consignment warehouse system 400 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.

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, a keyboard, a mouse, and a microphone, as well as 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 described as a monitor 114.

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) / 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 includes a product master 106a, a customer master 106b, an order file 106c, a shipping instruction file 106d, a first current storage data (without expiration date management) file 106e, and a second current storage data (second current storage data). It has a file 106f (with expiration date management). FIG. 3 is a diagram showing a configuration example of the product master 106a. FIG. 4 is a diagram showing a configuration example of the customer master 106b. The master can be divided or integrated. Therefore, the product master 106a and the customer master 106b are not limited to the configurations shown in FIGS. 3 and 4.

As shown in FIG. 3, the product master 106a can be composed of a table or the like in which a product code and an expiration date allocation target (for example, “1”: target, “0”: non-target) are registered in association with each other.

As shown in FIG. 4, the customer master 106b may be composed of a table or the like registered in association with a customer code and an expiration date allocation target (for example, "1": target, "0": non-target). can.

The order file 106c is a file for storing order data. The order data may include data such as an order number, a customer code, a warehouse code, a product code, an order quantity, and an allocation quantity.

The shipping instruction file 106d is a file for storing shipping instruction data. The shipping instruction data may include shipping instruction number, order number, customer code, warehouse code, product code, number of shipments, and expiration date data.

The first current storage data file 106e is a file for storing the first current storage data (without expiration date management). The first current warehouse data (without expiration date management) may include warehouse code, product code, and inventory quantity data. The first current warehouse data (without expiration date management) is managed by the inventory management unit 102a, and data is input, registered, and updated.

The second current warehouse data file 106f is a file for storing the second current warehouse data (with expiration date management). The second current warehouse data (with expiration date management) may include warehouse code, product code, inventory quantity, and expiration date data. The second current warehouse data (with expiration date management) is managed by the consignment warehouse system 400, and the inventory management unit 102a periodically accesses the consignment warehouse system 400 to access the second consignment warehouse system 400. The second current warehouse data (with expiration date management) of the second current warehouse data file 106f is updated (synchronized) with the value of the current warehouse data (with expiration date management).

The control unit 102 is a CPU or the like that comprehensively controls the inventory management 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 an inventory management unit 102a, an order input unit 102b, an allocation processing unit 102c, a shipping instruction unit 102d, and a master maintenance unit 102e.

The inventory management unit 102a manages the first current storage data (without expiration date management), and inputs, registers, and updates the first current storage data (without expiration date management) of the first current storage data file 106e. conduct.

The inventory management unit 102a periodically accesses the consignment warehouse system 400, synchronizes with the second current warehouse data (with expiration date management) managed by the consignment warehouse system 400, and synchronizes with the second current warehouse data file 106f. Update the second current warehouse data (with expiration date management).

The order input unit 102b inputs order data including an order number, a customer, a product, and the number of orders, and registers the order file 106c. Further, the order input unit 102b updates the order data stored in the order file 106c.

The allocation processing unit 102c allocates inventory to the order data, and at that time, first refers to the first current warehouse data in which the products and the number of stocks in the consignment warehouse are registered, and the inventory is stored in the order data. Of the order data for which inventory has been allocated, the product master 106a and the customer master 106b are referred to, and the products and customers subject to the expiration date allocation are the products in the consignment warehouse, the number of stocks, and the taste. The expiration date is assigned by referring to the second current warehouse data for which the expiration date is registered.

When assigning the expiration date of the second current warehouse data, the allocation processing unit 102c refers to the existing shipping instruction data in which the order data and the consignment warehouse, the customer, and the product are the same, and acquires the expiration date of the final shipment. , The inventory after the best-by date of the acquired final shipment may be allocated.

Further, the order data may include data on the number of cases. In this case, when the allocation processing unit 102c allocates the expiration date of the second current storage data, the allocation processing unit 102c may make an allocation so that products having different expiration dates are not packed in one case.

The shipping instruction unit 102d creates shipping instruction data for the consignment warehouse for the order data after allocation, outputs the data, and stores the order data in the shipping instruction file 106d. More specifically, among the order data that has been successfully allocated, the shipping instruction data is created for the data that does not require the expiration date management, and the data that has succeeded in the allocation of the expiration date information for the data that requires the expiration date management. Create shipping instruction data. No shipping instruction data is created for items for which the expiration date information has not been successfully allocated.

The master maintenance unit 102f edits data input / addition / change to the product master 106a and the customer master 106b in response to an operation by an administrator or the like on a master maintenance screen (not shown) displayed on the monitor 114. It is for doing.

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

(Overall processing)
With reference to FIG. 5, the overall processing flow of the control unit of the inventory management device 100 according to the present embodiment will be described. In FIG. 5, the order input unit 102b executes the order input process (step S1). Specifically, in the order input process, the order input unit 102b inputs order data including an order number, a customer, a product, and the number of orders, and stores the order data in the order file 106c.

The allocation processing unit 102c executes the allocation processing (step S2). Specifically, in the allocation processing, first, the allocation processing unit 102c first refers to the first current storage data (without expiration date management) stored in the first current storage data file 106e, and converts it into order data. In contrast, inventory is allocated (step S2-1). Next, among the order data for which inventory has been allocated, the products in the consignment warehouse, the number of stocks, and the expiration date are registered for the products and customers for which the expiration date is allocated by referring to the product master 106a and the customer master 106b. With reference to the second current warehouse data (with expiration date management), the expiration date is assigned (step S2-2).

Further, when the allocation processing unit 102c allocates the expiration date of the second current warehouse data, the shipping instruction data stored in the shipping instruction file 106d in which the order data and the consignment warehouse, the customer, and the product are the same. You may obtain the expiration date of the final shipment by referring to, and reserve the inventory after the expiration date of the acquired final shipment.

Further, when the allocation processing unit 102c manages the order data by the number of cases, when the expiration date of the second current warehouse data is assigned, the allocation processing unit 102c allocates so that products having different expiration dates are not packed in one case. You may decide to do it.

The shipping instruction unit 102d executes a shipping instruction creation process (step S3). Specifically, in the shipping instruction creation process, the shipping instruction unit 102d creates shipping instruction data for the consignment warehouse for the order data after allocation, outputs the data, and stores the order data in the shipping instruction file 106d.

6 to 11 are diagrams for explaining a specific example of processing of the control unit 102 of the inventory management device 100 according to the present embodiment. A specific example of the processing of the control unit 102 of the inventory management device 100 according to the present embodiment will be described with reference to FIGS. 6 to 11.

(Inventory allocation processing)
(1: Allocation of the first current warehouse data)
The allocation processing unit 102c first allocates inventory to the order data with reference to the first current stock data. FIG. 6 is a diagram for explaining the allocation of the first current storage data (without the expiration date management). FIG. 7 shows a data example of the order data and the first current warehouse data (no expiration date for taste management).

In the example of the order data shown in FIG. 7A, the first line is the order number "J001", the customer code "T001", the warehouse code "K01", the product code "S001", the number of orders "50", and 2 The line is the order number "J002", the customer code "T002", the warehouse code "K01", the product code "S002", the number of orders "100", and the third line is the order number "J003", the customer code " T003 ", warehouse code" K01 ", product code" S003 ", order quantity" 200 ", the fourth line is the order number" J004 ", customer code" T004 ", warehouse code" K01 ", product code" S004 ". , The number of orders is "500". The warehouse code “K01” indicates a consignment warehouse.

In the example of the first current warehouse data (no expiration date for taste management) shown in FIG. 7B, the first line is the warehouse code “K01”, the product code “S001”, the inventory quantity “50”, and the second line is. , Warehouse code "K01", product code "S002", inventory quantity "100", third line is warehouse code "K01", product code "S003", inventory quantity "200", fourth line is warehouse code " "K01", the product code "S004", and the number of stocks "0".

When the stock of the first current warehouse data is allocated to the order data by first-in first-out, as shown in FIG. 7 (C), the order number "J001" is the reserve number "50" and the order number "J002" is the reserve number "100". , The order number "J003" is the allocation number "200", and the order number "J004" is the allocation number "0".

(2: Allocation of the second current warehouse data)
Next, the allocation processing unit 102c entrusts the products and customers subject to the expiration date allocation with reference to the product master 106a and the customer master 106b among the order data to which the inventory of the first current warehouse data is allocated. With reference to the second current warehouse data including the goods in the warehouse, the number of stocks, and the expiration date, the expiration date is assigned (step S2-2). FIG. 8 is a diagram for explaining the allocation of the second current storage data.

In FIG. 8, when the expiration date is assigned, if the inventory of the second current warehouse data is OK but the expiration date set by the following check does not exist, the inventory of the second current warehouse data (consignment warehouse inventory) is NG. And put the item on hold (the order backlog remains). The contents of the check are (1) best-by date reversal prevention check, and (2) case-by-case crying farewell check.

FIG. 9 shows data examples of order data, a second current warehouse (with expiration date management), a product master 106a, a customer master 106b, and shipping instruction data. FIG. 9A shows the order data after the inventory of the first current warehouse data (without the expiration date management) is allocated.

In the second example of the current warehouse data (with expiration date management) shown in FIG. 9B, the first line is the warehouse code "K01", the product code "S001", the number of stocks "50", and the expiration date "2020 /". "12/31", the second line is the warehouse code "K01", the product code "S002", the inventory quantity "3", and the expiration date "2020/11/30".

In the example of the product master 106a shown in FIG. 9C, the first line is the product code “S001” and the expiration date allocation target “1: target”, and the second line is the product code “S002” and the expiration date allocation target. "1: Target", the third line is the product code "S003", and the expiration date allocation target "0: Not applicable".

In the example of the customer master 106b shown in FIG. 9 (D), the first line is the customer code "T001", the expiration date allocation target "1: target", and the first line is the customer code "T001", the taste. Deadline allocation target "1: Target", 2nd line is customer code "T002", expiration date allocation target "1: Target", 3rd line is customer code "T003", expiration date allocation target "0: Not applicable ".

In the product master 106a and the customer master 106b, the product code "S001" and the customer code "T001", the product code "S002" and the customer code "T002" are subject to the expiration date allocation, and the product code "S003". And the customer code "T003" is not subject to the expiration date allocation. Therefore, among the order data to which the inventory of the first current warehouse data shown in FIG. 7A is allocated, the order numbers “J001” and “J002” are subject to the expiration date allocation, and the order numbers “J003” and the taste are available. Not subject to deadline allocation.

For the order number "J001", the expiration date "2020/12/31" in the first line of the second current warehouse data is assigned, and for the order number "J002", the second current warehouse data is out of stock. , The allocation is NG, and the order number "J003" is not subject to the expiration date allocation, so it is not necessary to allocate the expiration date.

In the example of the shipping instruction data shown in FIG. 9F, the first line is the shipping instruction number "U001", the order number "J001", the customer code "T001", the warehouse code "K01", and the product code "S001". , Shipment number "50", Expiration date "2020/12/31", 2nd line is shipping instruction number "U001", order number "J003", customer code "T003", warehouse code "K01", product code It has "S003", the number of shipments "200", and the expiration date "-].

Next, (1) an expiration date reversal prevention check and (2) a crying farewell check for each case will be described, which are executed when the allocation processing unit 102c allocates the expiration date.

(1) In the best-by-date reversal prevention check, the existing shipping instruction data stored in the shipping instruction file 106d, which has the same warehouse code, customer code, and product code as the order data, is referred to, and the final shipment is the best. The deadline is acquired, and the inventory of the second current warehouse data after the acquired expiration date is subject to allocation.

(2) In the case-by-case crying farewell check, allocation is made so that products with different expiration dates are not packed in one case, and if one expiration date does not meet the number of orders in one case, it is excluded from the allocation. ..

With reference to the sample data of FIG. 10, the best-by-date reversal prevention check and the crying farewell check for each case will be described.

(1) As an example of the order data to be allocated, as shown in FIG. 10A, the order number "J005", the customer code "T001", the warehouse code "K01", the product code "S001", and the number of cases " 1 ”and the number of orders are“ 50 ”, and we have data on the number of cases.

(2) Refer to the existing shipping instruction data having the same warehouse code, customer code, and product code as the order data to be allocated. FIG. 10B shows an example of shipping instruction data (existing), and the first line shows the shipping instruction number “U001”, the order number “J001”, the customer code “T001”, and the warehouse code “K01”. , Product code "S001", number of shipments "100", expiration date "2020/09/30", second line is shipping instruction number "U002", order number "J002", customer code "T001", warehouse code The product code is "K01", the number of shipments is "45", and the expiration date is "2020/10/15".

The third line is the shipping instruction number "U003", the order number "J003", the customer code "T001", the warehouse code "K01", the product code "S001", the number of shipments "13", and the expiration date "2020/10 /". 31 ", 4th line is shipping instruction number" U004 ", order number" J004 ", customer code" T001 ", warehouse code" K01 ", product code" S001 ", number of shipments" 25 ", expiration date" 2020 ". / 11/20 ". The final shipping expiration date is "2020/11/20" on the 4th line.

For example, when shipping operations are performed from a plurality of departments, it is difficult to judge the shipping results by visual inspection. In this embodiment, the systemization has realized the prevention of complaints due to an incorrect expiration date.

(3) Products with a best-by date after the final shipping best-by date are assigned from the second current warehouse data. In the example of the second current warehouse data (with expiration date management) shown in FIG. 10C, the first line is the warehouse code “K01”, the product code “S001”, the number of stocks “5”, and the expiration date “2020”. "/ 9/30", the second line is the warehouse code "K01", the product code "S001", the number of stocks "21", and the expiration date "2020/10/31".

The third line is the warehouse code "K01", the product code "S001", the inventory quantity "45", the expiration date "2020/11/30", and the fourth line is the warehouse code "K01", the product code "S001", The number of stocks is "50", the expiration date is "2020/12/31", and the fifth line is the warehouse code "K01", the product code "S001", the number of stocks "80", and the expiration date "2021/1/31". ing.

In the first to third lines of the second current storage data, the final shipping expiration date of the shipping instruction data in FIG. 10B is "2020/11/20", and the expiration date before "2020/11/20". Therefore, it is not subject to allocation (best-by date reversal prevention check), and because the number of stocks is less than the number of orders received (50) in one case, it is not subject to allocation (check for crying farewell on a case-by-case basis).

Of the second current warehouse data that can be allocated after the two checks, the fourth row [2020/12/31], which has the closest expiration date, is allocated.

FIG. 11 shows an output data sample of shipping instruction data (shipping instruction). For example, CSV data is linked to the consignment warehouse system 400. In the consignment warehouse system 400, the product with the specified expiration date is shipped for the details with the expiration date management. In addition, for items without expiration date management, priority is given to the operations of the consignment warehouse without specifying the shipping deadline.

As described above, according to the present embodiment, the product master 106a in which the expiration date allocation target / non-target is registered for each product, and the customer who has registered the expiration date allocation target / non-target for each customer. The master 106b, the order input unit 102b for inputting the order data including the order number, the customer, the product, and the number of orders, and the order data, inventory is allocated, and at that time, first, the product in the consignment warehouse. With reference to the first current warehouse data in which the number of stocks is registered, inventory is allocated to the order data, and then, among the order data to which the stock is allocated, the product master and the customer master are referred to. For the products and customers subject to the expiration date allocation, refer to the products in the consignment warehouse, the number of stocks, and the second current warehouse data in which the expiration date is registered, and the allocation processing unit 102c for allocating the expiration date, and after allocation. Since the shipping instruction unit 102d for creating the shipping instruction data for the consignment warehouse is provided for the order data of the above, it is possible to reduce the work load related to the management of the expiration date when the inventory is managed in the consignment warehouse.

[4. 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 idea described in the claims.

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

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

Further, with respect to the inventory management 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 inventory management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program 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 inventory management apparatus is required. Read mechanically to 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 106 such as a ROM or an HDD (Hard Disk Drive). 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 an arbitrary network, and all or a part thereof can be downloaded as needed. be.

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 Disc), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, 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 multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the embodiment.

Various databases and the like stored in the storage unit 106 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 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 an arbitrary peripheral device is connected. Further, the inventory management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the information processing device.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or the like. 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.

100 Inventory management device 102 Control unit 102a Inventory management unit 102b Order input unit 102c Allocation processing unit 102d Shipping instruction unit 102e Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Product master 106b Customer master 106c Order file 106d Shipping instruction file 106e 1 current warehouse data (without expiration date management) file 106f 2nd current warehouse data (with expiration date management) file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network 400 Consignment warehouse system

Claims (6)

It is an inventory management device for contractors that has a storage unit and a control unit and outsources the warehouse business to a consignment warehouse.
In the storage unit
For each product, the product master that registered the target / non-target for the expiration date, and
For each customer, the customer master who registered the target / non-target for the expiration date, and
Is stored,
The control unit
An order input method for inputting order data including an order number, a customer, a product, and the number of orders.
Inventory is allocated to the order data, and at that time, first, inventory is allocated to the order data by referring to the first current warehouse data in which the products and the number of stocks of the consignment warehouse are registered. Next, among the order data for which inventory has been allocated, for the products and customers subject to the expiration date allocation with reference to the product master and customer master, the products in the consignment warehouse, the number of stocks, and the expiration date are registered. With reference to the current warehouse data of 2, the allocation means for allocating the expiration date,
With regard to the order data after allocation, a shipping instruction creating means for creating shipping instruction data for the consignment warehouse, and
An inventory management device characterized by being equipped with. The first current warehouse data is managed by the inventory management device, the second current warehouse data is managed by the consignment warehouse side, and the inventory management device is the second current warehouse data of the consignment warehouse. The inventory management device according to claim 1, wherein the inventory management device is synchronized with the data. When the allocation means allocates the expiration date of the second current warehouse data, it refers to the existing shipping instruction data in which the order data and the consignment warehouse, the customer, and the product are the same, and obtains the expiration date of the final shipment. The inventory management device according to claim 1 or 2, wherein the inventory after the best-by date of the acquired final shipment is subject to allocation. The order data includes data on the number of cases.
The allocation means according to claim 1 to 3, wherein when the expiration date of the second current warehouse data is assigned, the allocation means is provided so that products having different expiration dates are not packed in one case. The inventory management device according to any one. It is an inventory management method for causing an information processing device equipped with a control unit and a storage unit to execute.
In the storage unit
For each product, the product master that registered the target / non-target for the expiration date, and
For each customer, the customer master who registered the target / non-target for the expiration date, and
Is stored,
Executed in the control unit,
An order entry process for entering order data including order number, customer, product, and number of orders,
Inventory is allocated to the order data, and at that time, first, inventory is allocated to the order data by referring to the first current warehouse data in which the products and the number of stocks of the consignment warehouse are registered. Next, among the order data for which inventory has been allocated, for the products and customers subject to the expiration date allocation with reference to the product master and customer master, the products in the consignment warehouse, the number of stocks, and the expiration date are registered. With reference to the current warehouse data of 2, the allocation process for allocating the expiration date and
For the order data after allocation, the shipping instruction creation process that creates shipping instruction data for the consignment warehouse, and
A warehouse management method characterized by including. It is an inventory management program to be executed by an information processing device equipped with a control unit and a storage unit.
In the storage unit
For each product, the product master that registered the target / non-target for the expiration date, and
For each customer, the customer master who registered the target / non-target for the expiration date, and
Is stored,
In the control unit
An order entry process for entering order data including order number, customer, product, and number of orders,
Inventory is allocated to the order data, and at that time, first, inventory is allocated to the order data by referring to the first current warehouse data in which the products and the number of stocks of the consignment warehouse are registered. Next, among the order data for which inventory has been allocated, for the products and customers subject to the expiration date allocation with reference to the product master and customer master, the products in the consignment warehouse, the number of stocks, and the expiration date are registered. With reference to the current warehouse data of 2, the allocation process for allocating the expiration date and
For the order data after allocation, the shipping instruction creation process that creates shipping instruction data for the consignment warehouse, and
An inventory management program to run.

Images