Inventory allocation execution device, inventory allocation execution method, and inventory allocation execution program

Abstract

To provide such as a stock allocation execution device capable of executing stock allocation for a plurality of commodities in own company corresponding to the commodity used or shipped at a client even in a case where management granularity is finer for a commodity in own company than the management granularity for the commodity in a client.SOLUTION: (1) Own company commodity code associated with client code and client commodity code in a record being taken in from a commodity conversion master is acquired, (2) a stock record having warehouse code in record in the taking in as well as having acquired own commodity code a stock file, and executing commodity stock for a plurality of commodities in own company by (3) subtracting allocatable in-stock number in the stock record from the quantity in the take-in record in the order of that with the shortest sell-by date in the acquired stock record from the quantity in the taking in record, and (4) executing these processes of (1) to (3) from the first taking in record to the last taking in record in the taking in file.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to an inventory allocation execution device, an inventory allocation execution method, and an inventory allocation execution program. [Background technology]

[0002] Patent Document 1 discloses an inventory management ordering device and the like that can appropriately manage the distribution volume of food raw materials in the distribution process (see paragraphs 0007 and 0008 of Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2018-205862 Summary of the Invention [Problem to be solved by the invention]

[0004] In the field of food inventory management, there are cases where the granularity of product management at your company is finer than that of your customer. For example, your customer's product management granularity may be "by standard" such as "shrimp," while your company's product management granularity may be "by standard and origin" such as "shrimp from Thailand" and "shrimp from Vietnam."

[0005] In the food industry, there is a practice of recording sales of in-house inventory based on shipping reports from customers (consumption sales), but if the product management granularity differs between the customer and the company as mentioned above, it takes time and effort to determine which products in the company correspond to the products reported by the customer.As a result, there is a problem in that inventory allocation of the company's inventory cannot be carried out smoothly.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide an inventory allocation execution device, an inventory allocation execution method, and an inventory allocation execution program that can execute inventory allocation for multiple products in a company that correspond to products used or shipped by a customer, even when the granularity of product management in a company is finer than the granularity of product management in a customer's company. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, an inventory allocation execution device according to the present invention is an inventory allocation execution device comprising a control unit and a memory unit, which is capable of executing inventory allocation of a plurality of products in the company that correspond to products used or shipped by the customer, in a case where the management granularity of products in the company is finer than the management granularity of products in the customer, and where a single product in the customer corresponds to a plurality of products in the company, the inventory allocation execution device comprising: a control unit and a memory unit; a storage ... and an inventory file including inventory records having other data, the company's own product identification data, a deadline for the product, and an allocable inventory quantity for the product, and the control unit comprises: a company product acquisition means for acquiring from the product association master the customer identification data in the import record and the company product identification data linked to the customer product identification data; an inventory record acquisition means for acquiring from the inventory file an inventory record having the warehouse identification data in the import record and the company product identification data acquired by the company product acquisition means; and an inventory allocation execution means for executing inventory allocation for the company's multiple products by subtracting the allocable inventory quantity in the inventory record from the quantity in the import record in order of the inventory record with the closest deadline in the inventory record acquired by the inventory record acquisition means, and the processing by the company product acquisition means, the inventory record acquisition means, and the inventory allocation execution means is executed for the first import record to the last import record in the import file.

[0008] Furthermore, the inventory allocation execution device of the present invention is characterized in that the inventory records in the inventory file further contain lot identification data for identifying the lot of the product within the company, and when the expiration dates in the inventory records acquired by the inventory record acquisition means are the same among multiple inventory records, the inventory allocation execution means executes the inventory allocation in order of the lot identification data in the inventory records acquired by the inventory record acquisition means, starting with the most recent.

[0009] In addition, the inventory allocation execution device of the present invention is characterized in that the import record in the import file further has delivery destination identification data for identifying the delivery destination, the memory unit further stores an exception setting master including the customer identification data, the customer product identification data, the warehouse identification data, the delivery destination identification data, and the company's own product identification data, the control unit further comprises an exception acquisition means for acquiring from the exception setting master the company's own product identification data linked to the warehouse identification data, the customer identification data, the customer product identification data, and the delivery destination identification data in the import record, and the company's own product acquisition means does not acquire the company's own product identification data acquired by the exception acquisition means.

[0010] In addition, the inventory allocation execution device of the present invention is characterized in that the control unit further comprises a sales data generation means for generating sales data including a sales record having the company's own product identification data in the inventory record that has been subject to inventory allocation by the inventory allocation execution means, and having the allocationable inventory quantity deducted by the inventory allocation execution means as the sales quantity.

[0011] In addition, the inventory allocation execution device of the present invention is characterized in that the control unit further includes an inventory file update means for updating the inventory file by subtracting the available inventory quantity deducted by the inventory allocation execution means from the available inventory quantity in the inventory record.

[0012] In addition, the inventory allocation execution device of the present invention is characterized in that the product is a food product, the customer product identification data is numbered according to the product specifications, the company's own product identification data is numbered according to the product specifications and place of origin, or according to the product specifications and rank, and the expiration date is a best-before date or a consume-by date.

[0013] Furthermore, the inventory allocation execution method of the present invention is an inventory allocation execution method executed by an information processing device having a control unit and a storage unit, which is capable of executing inventory allocation of a plurality of products in the company that correspond to products used or shipped by the customer when the management granularity of products in the company is finer than the management granularity of products in the customer and a plurality of products in the company correspond to one product in the customer, wherein the storage unit includes an import file including import records having warehouse identification data for identifying the company's warehouse, customer identification data for identifying the customer, customer product identification data for identifying the product in the customer, and a quantity of the product used or shipped by the customer, the customer identification data, the customer product identification data, and company product identification data for identifying the product in the company, and wherein a product association master in which a plurality of company product identification data are set for one combination of the customer identification data and the customer product identification data, and the warehouse identification data and the company product identification data are stored. and an inventory file including an inventory record having data, a deadline for the product, and an allocable inventory quantity for the product, the data being stored in the import file, and the control unit executes an in-house product acquisition step of acquiring from the product association master the customer identification data in the import record and in-house product identification data linked to the customer product identification data; an inventory record acquisition step of acquiring from the inventory file an inventory record having the warehouse identification data in the import record and the in-house product identification data acquired in the in-house product acquisition step; and an inventory allocation execution step of executing inventory allocation for the in-house's multiple products by subtracting the allocable inventory quantity in the inventory record from the quantity in the import record in order of the inventory record with the closest deadline in the inventory record acquired in the inventory record acquisition step, and the processing in the in-house product acquisition step, the inventory record acquisition step, and the inventory allocation execution step are executed for the first import record to the last import record in the import file.

[0014] Furthermore, the inventory allocation execution program of the present invention is an inventory allocation execution program executed by an information processing device having a control unit and a memory unit, which is capable of executing inventory allocation of a plurality of products in the company that correspond to products used or shipped by the customer when the management granularity of products in the company is finer than the management granularity of products in the customer and a plurality of products in the company correspond to one product in the customer, wherein the memory unit includes an import file including an import record having warehouse identification data for identifying the company's warehouse, customer identification data for identifying the customer, customer product identification data for identifying the product in the customer, and a quantity of products used or shipped by the customer, the customer identification data, the customer product identification data, and company product identification data for identifying the product in the company, and wherein a product association master in which a plurality of company product identification data are set for one combination of the customer identification data and the customer product identification data, and a product association master in which the warehouse identification data and the company product identification data are set and an inventory file including an inventory record having product identification data, a deadline for the product, and an available inventory quantity for allocation of the product, the system includes: an in-house product acquisition step executed by the control unit, which acquires from the product association master the customer identification data in the import record and in-house product identification data linked to the customer product identification data; an inventory record acquisition step which acquires from the inventory file an inventory record having the warehouse identification data in the import record and the in-house product identification data acquired in the in-house product acquisition step; and an inventory allocation execution step which executes inventory allocation for the in-house's multiple products by subtracting the available inventory quantity in the inventory record from the quantity in the import record in order of the inventory record with the closest deadline in the inventory record acquired in the inventory record acquisition step, wherein the processing in the in-house product acquisition step, the inventory record acquisition step, and the inventory allocation execution step are executed for the first import record to the last import record in the import file. [Effects of the Invention]

[0015] According to the present invention, even if the granularity of product management at one's own company is finer than that at a customer, it is possible to perform inventory allocation for multiple products at one's own company corresponding to products used or shipped at the customer. [Brief explanation of the drawings]

[0016] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an inventory allocation execution device. [Figure 2] FIG. 2 is a diagram showing an example of an outline of a processing flow according to this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of an import file. [Figure 4] FIG. 4 is a diagram illustrating an example of the product conversion master. [Figure 5] FIG. 5 is a diagram illustrating an example of the exception pattern master. [Figure 6] FIG. 6 is a diagram showing an example of an inventory file before updating. [Figure 7] FIG. 7 is a diagram showing the results of the company's own product acquisition process for the import record of row number 1. [Figure 8] FIG. 8 is a diagram showing the results of the inventory allocation execution process for the import record of row number 1. [Figure 9] FIG. 9 is a diagram showing the results of the inventory allocation execution process for the import record of row number 2. [Figure 10] FIG. 10 is a diagram showing a table summarizing the results of inventory allocation for each import record. [Figure 11] FIG. 11 is a diagram illustrating an example of the generated sales data. [Figure 12] FIG. 12 is a diagram showing an example of the inventory file after updating. DETAILED DESCRIPTION OF THE INVENTION

[0017] Hereinafter, an embodiment of an inventory allocation execution device, an inventory allocation execution method, and an inventory allocation execution program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to the embodiment.

[0018] [1. Overview] In industries such as the food industry, there is a practice of recording sales of the company's own inventory held in a consignment warehouse based on shipping reports from customers (consumption sales). In this case, the granularity of product management in the company's system (for example, sales management system) may be finer than the granularity of product management reported by the customer. For example, a customer may assign product codes "by specification," while the company assigns product codes "by specification and place of origin." In this case, it is not possible to make a 1:1 correspondence between the products reported by the customer and the company's own products.

[0019] In the past, staff would refer to the inventory status in the warehouse and determine which of their own products corresponded to the products reported by their customers. However, because inventory management was sometimes done by expiration date, determining which of their own stock had been used from the detailed inventory information and registering it in the system took a lot of time.

[0020] Therefore, in this embodiment, a product conversion master is implemented that allows multiple company products to be registered for one customer product. By preparing this master in advance, even if the customer's products and the company's products do not correspond 1:1, it is now possible to automatically allocate inventory for the company's products that correspond to the products reported by the customer. Note that this inventory allocation is performed, for example, in order of the expiration dates of the company's products.

[0021] This has succeeded in reducing the workload of, for example, determining the company's own inventory used and registering it in the system. It has also succeeded in reducing input errors during this work. Previously, this work was time-consuming, so the person in charge had to set aside a block of time to process multiple companies at once, but by reducing the time required for this work, the person in charge can now register the company's own products that correspond to the products reported by customers in the system in real time each time.

[0022] In addition, in this embodiment, an exception pattern master is implemented that can register combinations of company warehouses and delivery destinations that are not subject to the inventory allocation. By preparing this master in advance, it is possible to meet detailed industry requests to exclude specific combinations of company warehouses and delivery destinations from the inventory allocation.

[0023] In this embodiment, sales details can be registered in the system separately for each stock item identified as a target for stock allocation. The specific configuration and operation will be described below.

[0024] [2. Configuration] An example of the configuration of the inventory allocation execution device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the inventory allocation execution device 100.

[0025] The inventory allocation execution device 100 is a commercially available desktop personal computer. Note that the inventory allocation execution device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0026] The inventory allocation execution device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units comprised in the inventory allocation execution device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0027] The communication interface unit 104 communicatively connects the inventory allocation execution 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 exchanging data with other devices via the communication line. Here, the network 300 has a function of connecting the inventory allocation execution device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described below may be stored in the server 200, for example.

[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0029] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0030] The storage unit 106 includes, for example, an import file 106a, a product conversion master 106b as a product association master, an exception pattern master 106c as an exception setting master, an inventory file 106d, and sales data 106e.

[0031] In the following explanation, it is assumed that the granularity of product management at the company is finer than that at the customer, and that one product at the customer corresponds to multiple products at the company. The products are not particularly limited, but may be, for example, food products.

[0032] The import file 106a is a file prepared for importing the used or shipped products reported by the customer. As shown in Fig. 3, the import file 106a includes import records having, for example, a row number (row), a shipping date from the company's warehouse, warehouse identification data (warehouse code) for identifying the company's warehouse, customer identification data (customer code) for identifying the customer, delivery destination identification data (delivery destination code) for identifying the delivery destination, customer product identification data (customer product code and customer product name) for identifying the product at the customer, the quantity of the product used or shipped by the customer, and the unit price of the product used or shipped by the customer.

[0033] The customer product identification data is, for example, a code assigned according to the "specification" of the product. The order of the multiple import records in the import file 106a is not particularly limited, but in the example of Figure 3, they are sorted in ascending order of the shipping date.

[0034] The product conversion master 106b is a master for associating one product of the customer with multiple products of the company. By using the product conversion master 106b, it is possible to associate the products of the customer with the products of the company when the management granularity of the products of the company (for example, "by standard and place of origin" or "by standard and rank") is finer than the management granularity of the products of the customer (for example, "by standard").

[0035] 4, the product conversion master 106b includes, for example, the customer identification data (customer code), the customer product identification data (customer product code), and company product identification data (company product code and company product name) for identifying the product within the company. The company product identification data is, for example, a code assigned according to the "standard and place of origin" of the product, or a code assigned according to the "standard and rank" of the product.

[0036] Here, in the product conversion master 106b, a plurality of the company's product identification data are set for one combination of the customer identification data and the customer product identification data. In the example of Fig. 4, for the customer "TK01", one customer product "TKS01: shrimp" is associated with four company's products, "EBI01: Thai shrimp", "EBI02: Vietnamese shrimp", "EBI03: Domestic shrimp", and "EBI04: Chinese shrimp".

[0037] The exception pattern master 106c is a master for setting combinations of the company's warehouse (= source) and delivery destination (= destination) that are not subject to inventory allocation. The company's products that are linked to the combinations set in the exception pattern master 106c are not subject to acquisition from the product conversion master 106b, and as a result, are not subject to inventory allocation.

[0038] As shown in Figure 5, the exception pattern master 106c includes, for example, the customer identification data (customer code), the customer product identification data (customer product code), the warehouse identification data (warehouse code), the delivery destination identification data (delivery destination code), and the company's own product identification data (company product code).

[0039] In the first record of Figure 5, excluding the item row, it is set that if the company warehouse is "LG01" and the delivery destination is "N001", "EBI03: Domestic shrimp" will not be retrieved from the product conversion master 106b.

[0040] Note that either the company warehouse or the delivery destination may be left blank. In the second record line excluding the item line in Fig. 5, it is set that if the delivery destination is "N003", then "EBI03: Domestic shrimp" is not to be acquired from the product conversion master 106b, regardless of the location of the company warehouse. In addition, in the third record line excluding the item line in Fig. 5, it is set that if the company warehouse is "LG02", then "EBI04: Chinese shrimp" is not to be acquired from the product conversion master 106b, regardless of the location of the delivery destination.

[0041] The inventory file 106d is a file for managing the company's inventory. As shown in Fig. 6, the inventory file 106d includes inventory records having, for example, the warehouse identification data (warehouse code), the company's product identification data (company product code), lot identification data (lot number) for identifying the lot of the product within the company, the expiration date (best before date) of the product, and the available inventory quantity of the product. The expiration date is not limited to the best before date, and may be, for example, a use-by date.

[0042] The sales data 106e is data for managing information related to the sales of the company. Details of the contents of the sales data 106e will be explained in [4-2] below.

[0043] The control unit 102 is a CPU or the like that performs overall control of the inventory allocation execution device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0044] The control unit 102 has, in terms of functional concept, for example: (1) an exception acquisition unit 102a as an exception acquisition means for acquiring from the exception setting master the warehouse identification data, the customer identification data, the customer product identification data, and the company product identification data linked to the delivery destination identification data in the import record; (2) an in-house product acquisition unit 102b as an in-house product acquisition means for acquiring from the product association master the company product identification data linked to the customer identification data and the customer product identification data in the import record; (3) an inventory record acquisition unit 102c as an inventory record acquisition means for acquiring from the inventory file an inventory record having the warehouse identification data in the import record and the company product identification data acquired by the company product acquisition means; and (4) an inventory record acquired by the inventory record acquisition means. The system comprises: (5) an inventory allocation execution unit 102d as inventory allocation execution means that executes inventory allocation for a plurality of products in the company by subtracting the available inventory quantity in the inventory record from the quantity in the import record in order of the record with the nearest expiration date; (6) a sales data generation unit 102e as sales data generation means that generates sales data including sales records that have the company's product identification data in the inventory record that has been subject to inventory allocation by the inventory allocation execution means and that have the available inventory quantity subtracted by the inventory allocation execution means as a sales quantity; and (7) an inventory file update unit 102f as inventory file update means that updates the inventory file by subtracting the available inventory quantity subtracted by the inventory allocation execution means from the available inventory quantity in the inventory record.

[0045] The exception acquiring unit 102a acquires, from the exception pattern master 106c (see FIG. 5), the company's product code linked to the warehouse code, customer code, customer product code, and delivery destination code in the import record in the import file (see FIG. 3).

[0046] The company's product acquisition unit 102b acquires company's product codes linked to the customer codes and customer product codes in the import records in the import file (see FIG. 3) from the product conversion master 106b (see FIG. 4). However, the company's product acquisition unit 102b may not acquire company's product codes acquired by the exception acquisition unit 102a.

[0047] The inventory record acquisition unit 102c acquires from the pre-update inventory file 106d (see Figure 6) an inventory record that has the warehouse code in the import record in the import file (see Figure 3) and also has the company product code acquired by the company product acquisition unit 102b.

[0048] The inventory allocation execution unit 102d executes inventory allocation for multiple products in the company by subtracting the quantity of inventory available for allocation in the inventory records from the quantity in the import records in the import file (see FIG. 3), in order of the expiration dates nearest to the expiration dates in the inventory records acquired by the inventory record acquisition unit 102c. Note that if the expiration dates in the inventory records acquired by the inventory record acquisition unit 102c are the same among multiple inventory records, the inventory allocation execution unit 102d may execute the inventory allocation in order of the lot numbers in the inventory records acquired by the inventory record acquisition unit 102c, in order of the lot numbers nearest to the expiration dates.

[0049] The processing in the exception acquisition unit 102a, company product acquisition unit 102b, inventory record acquisition unit 102c, and inventory allocation execution unit 102d is executed for the first to last import records in the import file (see FIG. 3).

[0050] The sales data generation unit 102e generates sales data 106e including sales records that have the company's product code in the inventory record that was subject to inventory allocation by the inventory allocation execution unit 102d and that have the allocationable inventory quantity deducted by the inventory allocation execution unit 102d as the sales quantity (see Figure 11).

[0051] The inventory file update unit 102f updates the inventory file 106d (see Figure 12) by subtracting the available inventory quantity deducted by the inventory allocation execution unit 102d from the available inventory quantity in the inventory record in the inventory file 106d before the update (see Figure 6).

[0052] [3. Processing flow overview] In this section, an overview of the processing flow according to this embodiment will be explained with reference to FIG. 2. As shown in FIG. 2, the product conversion master 106b and the exception pattern master 106c are registered in advance, and the shipment report file received from the customer is registered as the import file 106a. In the product conversion master 106b, the correspondence between the customer's products and the company's products is set, and in the exception pattern master 106c, the combination of warehouse and delivery destination that will be considered as an exception to inventory allocation is set. Furthermore, the shipment report file includes the customer's product code, not the company's product code.

[0053] 2, the sales import process is executed based on the registered import file 106a, product conversion master 106b, and exception pattern master 106c to generate sales data 106e and withdraw inventory from the inventory file 106d. In the sales import process, inventory is reserved in the order explained in the following paragraphs, and sales data 106e is generated based on the reserved inventory.

[0054] First, as shown in FIG. 2(1), a list of target company product codes is acquired based on the import file 106a, with reference to the product conversion master 106b and the exception pattern master 106c.

[0055] Next, as shown in FIG. 2(2), the inventory information of the company's product code obtained in the list in (1) is obtained from the inventory file 106d.

[0056] Finally, as shown in (3) of Figure 2, the inventory file 106d is updated by performing inventory allocation on the inventory information acquired in (2) (usually inventory information for multiple products) in order of the expiration date, while generating sales data 106e with sales details for each allocated inventory.

[0057] [4. Specific examples of processing] This section describes a specific example of the processing according to this embodiment. Note that this section will proceed on the assumption that the import file 106a has the content shown in Fig. 3, the product conversion master 106b has the content shown in Fig. 4, the exception pattern master 106c has the content shown in Fig. 5, and the pre-update inventory file 106d has the content shown in Fig. 6.

[0058] [4-1. Execution of inventory allocation] In this section, we will explain how four processes, namely, exception acquisition process, company product acquisition process, inventory record acquisition process, and inventory allocation execution process, are performed for each import record in the import file 106a in FIG.

[0059] (1) Regarding the import record for row number 1 First, how the above four processes are performed for the import record of line number 1 in the import file 106a in FIG. 3 will be described.

[0060] The exception acquisition unit 102a acquires "EBI03" from the exception pattern master 106c in Fig. 5 as the company's product code linked to the warehouse code "LG01," customer code "TK01," customer product code "TKS01," and delivery destination code "N001" in the import record of row number 1 in the import file 106a in Fig. 3. The product with "EBI03" is an exception to inventory allocation.

[0061] Next, the company product acquisition unit 102b attempts to acquire four products, "EBI01" to "EBI04," from the product conversion master 106b in Figure 4 as company product codes linked to the customer code "TK01" and customer product code "TKS01" in the import record of row number 1 in the import file 106a in Figure 3. However, since "EBI03" is an exception to inventory allocation as explained in the previous paragraph, only three products, "EBI01," "EBI02," and "EBI04," are acquired. The results of this acquisition are shown in Figure 7.

[0062] Next, the inventory record acquisition unit 102c acquires the inventory records in lines 1 to 4 from the pre-update inventory file 106d in Figure 6 as inventory records that have the warehouse code "LG01" in the import record of line number 1 in the import file 106a in Figure 3 and the company product code "EBI01", "EBI02" or "EBI04" acquired by the company product acquisition unit 102b.

[0063] Finally, the inventory allocation execution unit 102d executes inventory allocation in the following manner, starting with the item with the nearest expiration date in the inventory records acquired by the inventory record acquisition unit 102c.

[0064] First, the inventory allocation execution unit 102d assigns priority numbers to the inventory records in the first to fourth rows acquired by the inventory record acquisition unit 102c, starting with the one with the closest expiration date. That is, as shown in Fig. 8, the inventory allocation execution unit 102d assigns a priority of "1" to the inventory record in the fourth row (expiration date 10 / 15), a priority of "2" to the inventory record in the first row (expiration date 10 / 20), a priority of "3" to the inventory record in the second row (expiration date 10 / 30), and a priority of "4" to the inventory record in the third row (expiration date 11 / 10).

[0065] Then, as shown in Figure 8, the inventory allocation execution unit 102d executes inventory allocation by subtracting the available inventory quantity "5" in the inventory record on the fourth line with priority "1" from the quantity "5" in the import record on line number 1 in the import file 106a of Figure 3.

[0066] As a result of this inventory allocation, the quantity "5" in the import record of row number 1 has been subtracted entirely to become 0, and therefore the inventory allocation process for the import record of row number 1 ends here.

[0067] (2) Regarding the import record for row number 2 Next, how the above four processes are performed for the import record at line number 2 in the import file 106a in FIG. 3 will be described.

[0068] Referring to the exception pattern master 106c in Figure 5, there is no company product code linked to the warehouse code "LG01," customer code "TK01," customer product code "TKS01," and delivery destination code "N002" in the import record of row number 2 in the import file 106a in Figure 3, so there are no products that are exceptions to inventory allocation for the import record of row number 2.

[0069] Next, the company's product acquisition unit 102b acquires four products, "EBI01" to "EBI04", from the product conversion master 106b of Figure 4 as company's product codes linked to the customer code "TK01" and customer product code "TKS01" in the import record of row number 2 in the import file 106a of Figure 3.

[0070] Next, the inventory record acquisition unit 102c attempts to acquire the inventory records on lines 1 to 5 from the pre-update inventory file 106d in Figure 6 as inventory records that have the warehouse code "LG01" in the import record of line number 2 in the import file 106a in Figure 3 and the in-house product code "EBI01," "EBI02," "EBI03," or "EBI04" acquired by the in-house product acquisition unit 102b. However, as for the inventory record on line 4, as explained in (1), all of the available inventory has already been allocated, so only the inventory records on lines 1 to 3 and 5 are acquired.

[0071] Finally, the inventory allocation execution unit 102d executes inventory allocation in the following manner, starting with the item with the nearest expiration date in the inventory records acquired by the inventory record acquisition unit 102c.

[0072] First, the inventory allocation execution unit 102d assigns priority numbers to the inventory records in the first to third and fifth lines acquired by the inventory record acquisition unit 102c, starting with the item with the closest expiration date. That is, as shown in Figure 9, the inventory allocation execution unit 102d assigns a priority of "1" to the inventory record in the fifth line (expiration date 10 / 05), a priority of "2" to the inventory record in the first line (expiration date 10 / 20), a priority of "3" to the inventory record in the second line (expiration date 10 / 30), and a priority of "4" to the inventory record in the third line (expiration date 11 / 10).

[0073] Then, as shown in Figure 9, the inventory allocation execution unit 102d executes inventory allocation by subtracting the available inventory quantity "4" in the inventory record on the fifth line with priority "1" from the quantity "5" in the import record on line number 2 in the import file 106a of Figure 3.

[0074] As a result of this inventory allocation, the quantity in the import record for row number 2 is updated to "1," but the inventory allocation is not yet complete. Therefore, the inventory allocation execution unit 102d then executes inventory allocation by subtracting "1" from the available inventory quantity of "5" in the inventory record for the first row with priority "2" from the updated quantity of "1" in the import record for row number 2, as shown in Figure 9. As a result of this inventory allocation, the available inventory quantity in the inventory record for the first row with priority "2" is updated from "5" to "4."

[0075] As a result of this inventory allocation, the quantity "5" in the import record of row number 2 has been subtracted entirely to become 0, and therefore the inventory allocation process for the import record of row number 2 also ends here.

[0076] (3) Regarding the import record for row number 3 Next, we will explain how the above four processes are performed for the import record of line number 3 in the import file 106a. However, since the exception acquisition process and the company's own product acquisition process are the same as (2), we will only explain the inventory record acquisition process and the inventory allocation execution process.

[0077] First, the inventory record acquisition unit 102c attempts to acquire the inventory records on lines 1 to 5 from the pre-update inventory file 106d in Figure 6 as inventory records that have the warehouse code "LG01" in the import record of line number 3 in the import file 106a in Figure 3 and the in-house product code "EBI01," "EBI02," "EBI03," or "EBI04" acquired by the in-house product acquisition unit 102b. However, since the inventory record on line 4 has already allocated all of the available inventory as explained in (1), and the inventory record on line 5 has already allocated all of the available inventory as explained in (2), only the inventory records on lines 1 to 3 are acquired.

[0078] Next, the inventory allocation execution unit 102d executes inventory allocation in the following manner, starting with the item with the nearest expiration date in the inventory records acquired by the inventory record acquisition unit 102c.

[0079] First, the inventory allocation execution unit 102d assigns priority numbers to the inventory records in the first to third rows acquired by the inventory record acquisition unit 102c, starting with the item with the closest expiration date. That is, although not shown, the inventory allocation execution unit 102d assigns a priority number of "1" to the inventory record in the first row (expiration date 10 / 20), a priority number of "2" to the inventory record in the second row (expiration date 10 / 30), and a priority number of "3" to the inventory record in the third row (expiration date 11 / 10).

[0080] Then, although not shown, the inventory allocation execution unit 102d executes inventory allocation by subtracting the updated available inventory quantity "4" in the inventory record in the first line with priority "1" from the quantity "5" in the import record in line number 3 in the import file 106a in Figure 3.

[0081] As a result of this inventory allocation, the quantity in the import record for row number 3 is updated to "1," but the inventory pull is not yet complete. Therefore, although not shown, the inventory allocation execution unit 102d then executes inventory allocation by subtracting "1" from the available inventory quantity of "10" in the inventory record for the second row with priority "2" from the updated quantity of "1" in the import record for row number 3. As a result of this inventory allocation, the available inventory quantity in the inventory record for the second row with priority "2" is updated from "10" to "9."

[0082] As a result of this inventory allocation, the quantity "5" in the import record of row number 3 has been subtracted to 0, and therefore the inventory allocation process for the import record of row number 3 also ends here.

[0083] (4) Regarding the import record in row number 4 Finally, we will explain how the above four processes are performed for the import record of line number 4 in the import file 106a. However, since the exception acquisition process and the company's own product acquisition process are the same as (2), we will only explain the inventory record acquisition process and the inventory allocation execution process.

[0084] First, the inventory record acquisition unit 102c attempts to acquire the inventory records on lines 1 to 5 from the pre-update inventory file 106d in Figure 6 as inventory records that have the warehouse code "LG01" in the import record of line number 4 in the import file 106a in Figure 3 and the in-house product code "EBI01," "EBI02," "EBI03," or "EBI04" acquired by the in-house product acquisition unit 102b. However, since the inventory record on line 4 has already allocated all of the available inventory as explained in (1), the inventory record on line 5 has already allocated all of the available inventory as explained in (2), and the inventory record on line 1 has already allocated all of the available inventory as explained in (3), only the inventory records on lines 2 and 3 are acquired.

[0085] Next, the inventory allocation execution unit 102d executes inventory allocation in the following manner, starting with the item with the nearest expiration date in the inventory records acquired by the inventory record acquisition unit 102c.

[0086] First, the inventory allocation execution unit 102d assigns priority numbers to the inventory records in the second and third lines, starting with the one with the closest expiration date. That is, although not shown, the inventory allocation execution unit 102d assigns a priority number of "1" to the inventory record in the second line (expiration date 10 / 30) and a priority number of "2" to the inventory record in the third line (expiration date 11 / 10).

[0087] Then, although not shown, the inventory allocation execution unit 102d executes inventory allocation by subtracting "5" from the updated available inventory quantity "9" in the inventory record on the second line with priority "1" from the quantity "5" in the import record on line number 4 in the import file 106a in Figure 3.

[0088] As a result of this inventory allocation, the quantity "5" in the import record of row number 4 has been subtracted to 0, and therefore the inventory allocation process for the import record of row number 4 also ends here.

[0089] As described above, by the processes described in (1) to (4), inventory allocation has been completed for all import records of line numbers 1 to 4 in the import file 106a in Figure 3. A table summarizing the inventory allocation results for each import record is shown in Figure 10.

[0090] As explained above in section [4-1], the inventory allocation execution device 100 according to this embodiment can execute inventory allocation for multiple products (in this example, products "EBI01" to "EBI04") in the company that correspond to a product used or shipped by the customer (product "TKS01" in this example) even if the company's product management granularity (in this example, "by standard") is finer than the customer's product management granularity (in this example, "by standard"). This makes it possible to execute inventory allocation for the company's products quickly, easily, and accurately.

[0091] [4-2. Generating sales data] In this section, the generation of the sales data 106e will be described.

[0092] The sales data generation unit 102e generates the sales data 106e shown in Fig. 11. Each sales record in the sales data 106e in Fig. 11 was generated based on each import record in the import file 106a in Fig. 3. That is, the sales records with sales numbers "UR001" to "UR004" were generated based on the import records with row numbers 1 to 4, respectively.

[0093] As shown in FIG. 11, the sales data 106e includes a sales record having, for example, a sales number, the shipment date (sales date) in the import file 106a, the warehouse identification data (warehouse code) in the import file 106a, the customer identification data (customer code) in the import file 106a, the delivery destination identification data (delivery destination code) in the import file 106a, a detail number, the company's product identification data (product code) in the inventory record that was subject to inventory allocation by the inventory allocation execution unit 102d in [4-1], the lot identification data (lot number) in the inventory record, the expiration date in the inventory record, the available inventory quantity (sales quantity) deducted by the inventory allocation execution unit 102d in [4-1], the unit price in the inventory record, and the sales amount (amount) calculated by multiplying the sales quantity by the unit price.

[0094] As shown by the hatching in Figure 11, the expiration date of 10 / 05 in the sales record for sales number "UR002" is closer than the expiration date of 10 / 15 in the sales record for the lower sales number "UR001." In other words, the expiration dates of the allocated inventory are arranged in order of longitude, "10 / 15 → 10 / 05," only here. This is due to the exception setting in the exception pattern master 106c. When an exception setting is made in the exception pattern master 106c, the expiration dates of the allocated inventory may be partially reversed (arranged in order of longitude) in the sales data 106e as shown here.

[0095] Furthermore, even if a customer reports the shipment of only one product (product "TKS01"), the sales data 106e will register the information divided into multiple products of the company (product "EBI03" and product "EBI01" shown by hatching in Figure 11) by dividing the detail number.

[0096] As described above in this section [4-2], the inventory allocation execution device 100 according to this embodiment can generate sales data 106e that reflects the results of inventory allocation.

[0097] [4-3. Updating inventory files] This section describes how to update the inventory file 106d.

[0098] The inventory file update unit 102f updates the inventory file 106d by subtracting the available inventory quantity subtracted by the inventory allocation execution unit 102d in [4-1] from the available inventory quantity in the inventory record in the inventory file 106d before the update shown in Figure 6. The updated inventory file 106d is shown in Figure 12. Note that in the updated inventory file 106d in Figure 12, the updated available inventory quantity is indicated by hatching.

[0099] As explained above in section [4-3], the inventory allocation execution device 100 according to this embodiment can update the inventory file 106d by reflecting the results of inventory allocation. This allows the inventory file 106d to be updated simultaneously with, for example, a shipping report from a customer, eliminating inventory allocation errors and the like caused by delays in updating the inventory file 106d.

[0100] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0101] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

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

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

[0104] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0105] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0106] Furthermore, with regard to the inventory allocation execution device 100, the components shown in the figures are functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0107] For example, all or any part of the processing functions of the inventory allocation execution device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inventory allocation execution device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

[0108] This computer program may also be stored in an application program server connected to the inventory allocation execution device 100 via any network, and all or part of it may be downloaded as needed.

[0109] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

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

[0111] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0112] The inventory allocation execution 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. The inventory allocation execution device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.

[0113] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0114] The present invention is useful in any industry where inventory is handled, but is useful, for example, in the food industry (especially the food industry that handles unprocessed ingredients), the food processing industry, the seafood industry, and the fresh food industry. [Explanation of symbols]

[0115] 100 Inventory allocation execution device 102 Control section 102a Exception acquisition part 102b In-house Product Acquisition Department 102c Inventory Record Acquisition Section 102d Inventory Allocation Department 102e Sales Data Generation Department 102f Inventory File Update Section 104 Communication interface unit 106 Storage section 106a Import file 106b Product conversion master 106c Exception Pattern Master 106d Inventory File 106e Sales Data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. An inventory allocation execution device comprising a control unit and a storage unit, which is capable of executing inventory allocation of a plurality of products in the company corresponding to products used or shipped by the customer, in a case where the management granularity of products in the company is finer than the management granularity of products in the customer's company, and a plurality of products in the company correspond to one product in the customer's company, The storage unit includes: an import file including an import record having warehouse identification data for identifying the company's warehouse, customer identification data for identifying the customer, customer product identification data for identifying the product at the customer, and the quantity of the product used or shipped at the customer; a product association master including the customer identification data, the customer product identification data, and company product identification data for identifying the product within the company, wherein a plurality of company product identification data are set for one combination of the customer identification data and the customer product identification data; an inventory file including an inventory record having the warehouse identification data, the company's own product identification data, a deadline for the product, and an available inventory quantity for the product; is stored, The control unit a company product acquisition means for acquiring company product identification data linked to the customer identification data and the customer product identification data in the import record from the product association master; an inventory record acquisition means for acquiring from the inventory file an inventory record having the warehouse identification data in the import record and the company product identification data acquired by the company product acquisition means; an inventory allocation execution means for executing inventory allocation for the plurality of products in the company by subtracting the available inventory quantity in the inventory record from the quantity in the import record in order of the product with the nearest expiration date in the inventory record acquired by the inventory record acquisition means; Equipped with the processes in the company product acquisition means, the inventory record acquisition means, and the inventory allocation execution means are executed for the first to last import records in the import file; The product is a food product, The customer product identification data is numbered according to the product specifications, The company's own product identification data is numbered according to the product specifications and origin, or according to the product specifications and rank, The said deadline is a best-before date or a consumption date; An inventory allocation execution device comprising:

2. the inventory record in the inventory file further includes lot identification data for identifying a lot of the product within the company; when the deadlines in the inventory records acquired by the inventory record acquisition means are the same among a plurality of inventory records, the inventory allocation execution means executes the inventory allocation in order of the lot identification data in the inventory records acquired by the inventory record acquisition means, starting from the most recent lot identification data; 2. The inventory allocation execution device according to claim 1, wherein:

3. the import record in the import file further includes delivery destination identification data for identifying a delivery destination; The storage unit includes: An exception setting master including the customer identification data, the customer product identification data, the warehouse identification data, the delivery destination identification data, and the company product identification data is further stored; The control unit The system further includes an exception acquisition means for acquiring, from the exception setting master, the warehouse identification data, the customer identification data, the customer product identification data, and the company product identification data associated with the delivery destination identification data in the import record, The company's own product acquisition means does not acquire the company's own product identification data acquired by the exception acquisition means; 2. The inventory allocation execution device according to claim 1, wherein:

4. The control unit a sales data generating means for generating sales data including a sales record having the company's own product identification data in the inventory record that has been subject to inventory allocation by the inventory allocation executing means and having the allocable inventory quantity subtracted by the inventory allocation executing means as a sales quantity; Further comprising:

2. The inventory allocation execution device according to claim 1, wherein:

5. The control unit an inventory file update means for updating the inventory file by subtracting the available inventory quantity deducted by the inventory allocation execution means from the available inventory quantity in the inventory record; Further comprising:

2. The inventory allocation execution device according to claim 1, wherein:

6. An inventory allocation execution method executed by an information processing device having a control unit and a storage unit, which is capable of executing inventory allocation of a plurality of products in the company corresponding to products used or shipped by the customer, in a case where the management granularity of products in the company is finer than the management granularity of products in the customer's company, and a plurality of products in the company correspond to one product in the customer's company, comprising: The storage unit includes: an import file including an import record having warehouse identification data for identifying the company's warehouse, customer identification data for identifying the customer, customer product identification data for identifying the product at the customer, and the quantity of the product used or shipped at the customer; a product association master including the customer identification data, the customer product identification data, and company product identification data for identifying the product within the company, wherein a plurality of company product identification data are set for one combination of the customer identification data and the customer product identification data; an inventory file including an inventory record having the warehouse identification data, the company's own product identification data, a deadline for the product, and an available inventory quantity for the product; is stored, Executed by the control unit, a company product acquisition step of acquiring company product identification data linked to the customer identification data and the customer product identification data in the import record from the product association master; an inventory record acquisition step of acquiring, from the inventory file, an inventory record having the warehouse identification data in the import record and the company product identification data acquired in the company product acquisition step; an inventory allocation execution step of executing inventory allocation for the plurality of products in the company by subtracting the available inventory quantity in the inventory record from the quantity in the import record in order of the product with the nearest expiration date in the inventory record acquired in the inventory record acquisition step; Including, The processes in the company product acquisition step, the inventory record acquisition step, and the inventory allocation execution step are executed for the first to last import records in the import file; The product is a food product, The customer product identification data is numbered according to the product specifications, The company's own product identification data is numbered according to the product specifications and origin, or according to the product specifications and rank, The said deadline is a best-before date or a consumption date; An inventory allocation execution method characterized by the above.

7. An inventory allocation execution program executed by an information processing device having a control unit and a storage unit, which is capable of executing inventory allocation of a plurality of products in the company corresponding to products used or shipped by the customer, in a case where the management granularity of products in the company is finer than the management granularity of products in the customer's company and a plurality of products in the company correspond to one product in the customer's company, The storage unit includes: an import file including an import record having warehouse identification data for identifying the company's warehouse, customer identification data for identifying the customer, customer product identification data for identifying the product at the customer, and the quantity of the product used or shipped at the customer; a product association master including the customer identification data, the customer product identification data, and company product identification data for identifying the product within the company, wherein a plurality of company product identification data are set for one combination of the customer identification data and the customer product identification data; an inventory file including an inventory record having the warehouse identification data, the company's own product identification data, a deadline for the product, and an available inventory quantity for the product; is stored, The information processing device includes: a company product acquisition step of acquiring company product identification data linked to the customer identification data and the customer product identification data in the import record from the product association master; an inventory record acquisition step of acquiring, from the inventory file, an inventory record having the warehouse identification data in the import record and the company product identification data acquired in the company product acquisition step; an inventory allocation execution step of executing inventory allocation for the plurality of products in the company by subtracting the available inventory quantity in the inventory record from the quantity in the import record in order of the product with the nearest expiration date in the inventory record acquired in the inventory record acquisition step; Execute The processes in the company product acquisition step, the inventory record acquisition step, and the inventory allocation execution step are executed for the first to last import records in the import file; The product is a food product, The customer product identification data is numbered according to the product specifications, The company's own product identification data is numbered according to the product specifications and origin, or according to the product specifications and rank, The said deadline is a best-before date or a consumption date; An inventory allocation execution program characterized by the above.

Images