CONTAINER COLLECTION MANAGEMENT DEVICE, CONTAINER COLLECTION MANAGEMENT METHOD, AND CONTAINER COLLECTION MANAGEMENT PROGRAM

The container collection management device tracks and visualizes customer collection rates, addressing the lack of control in existing systems to reduce costs and improve collection efficiency.

JP7583755B2Active Publication Date: 2024-11-14OBIC CO LTD
View PDF 4 Cites 0 Cited by

Patent Information

Application Number
JP2022032949
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-03-03
Publication Date
2024-11-14
Estimated Expiration
2042-03-03

AI Technical Summary

Technical Problem

Existing systems fail to manage and visualize container collection status for each customer after products are shipped, leading to uncontrolled collection and increased costs.

Method used

A container collection management device and method that includes a control section to track customer inventory, container data, and shipping information, allowing for real-time updates and visualization of collection rates.

Benefits of technology

Enables effective management and visualization of container collection for each customer, promoting cost reduction by encouraging better collection practices and reducing waste.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007583755000001
    Figure 0007583755000001
  • Figure 0007583755000002
    Figure 0007583755000002
  • Figure 0007583755000003
    Figure 0007583755000003
Patent Text Reader

Abstract

To visualize a container collection state by managing collection of containers for every customer.SOLUTION: A container collection management device includes: a shipping input means when shipping products, inputting shipping data including a shipping number, an accounting date, a customer, products, a shipping quantity, containers, and the number of containers, and updating customer inventory data and inventory data based on the input shipping data; first purchase input means when collecting containers, inputting first purchase data including a purchase number, a supplier, the customer, a receiving warehouse, containers and the number of containers, and updating the customer inventory data and the inventory data based on the input first purchase data; and inventory inquiry means for referring to the customer inventory data of a designated customer on a customer inventory inquiry screen displayed on a display part and displaying and outputting the containers, the inventory quantity, the shipping quantity, the number of collections, and a collection rate calculated by (the number of collections) / (the shipping quantity)×100.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

[Technical field]

[0001] The present invention relates to a container collection management device, a container collection management method, and a container collection management program. [Background technology]

[0002] For example, when beverages are shipped to customers in bottles or barrels, the containers are often collected and reused. Since reusing containers can reduce product costs, collecting containers as much as possible leads to cost reduction. Conventionally, a system for collecting containers is disclosed, for example, in Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2006-285545 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not disclose anything about managing the collection of containers for each customer and visualizing the collection status of the containers when products are packed in containers and shipped to customers.

[0005] The present invention has been made in consideration of the above, and aims to provide a container collection management device, a container collection management method, and a container collection management program that are capable of managing the collection of containers for each customer and visualizing the container collection status when products are packed in containers and shipped to customers. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a container collection management device that includes a control unit and manages the collection of containers shipped to customers, the control unit being configured to be able to access customer inventory data including customers (customer codes and / or customer names), containers (container codes and / or container names), stock quantities, shipment quantities, and collection quantities, and inventory data including warehouses (warehouse codes and / or warehouse names), containers, stock quantities, cumulative collections, and cumulative replenishment quantities, and when shipping products, inputting shipping data including a shipping number, accounting date, customer, product, shipping quantity, containers, and container quantity, and managing the collection of containers shipped to customers based on the inputted shipping data. The system is characterized by comprising a shipping input means for updating the customer inventory data and the inventory data, a first purchasing input means for inputting first purchasing data including the purchase number, the customer supplier (supplier code and / or supplier name), the receiving warehouse, the container, and the container quantity when the container is collected, and updating the customer inventory data and the inventory data based on the input first purchasing data, and an inventory inquiry means for displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, the container, the inventory quantity, the shipment quantity, the collection quantity, and the collection rate calculated as the collection quantity / shipment quantity x 100, by referring to the customer inventory data for a specified customer.

[0007] According to another aspect of the present invention, the inventory inquiry means may refer to the inventory data and display and output containers, inventory quantities, cumulative collections, and cumulative replenishment for a specified warehouse on an inventory inquiry screen displayed on a display unit.

[0008] In addition, according to one aspect of the present invention, the control unit is further configured to be able to access a product master in which products and containers are registered in association with each other, and the shipment input means may be configured to, when a product is input into the shipping data, automatically input the container associated with the product by referring to the product master.

[0009] In addition, according to one aspect of the present invention, the control unit is further configured to be able to access a customer master in which customers and suppliers are registered in association with each other, and the first purchasing input means may refer to the customer master, convert the supplier of the first purchasing data to a customer, and update the customer inventory data for the converted customer.

[0010] According to one aspect of the present invention, the control unit may further include an order input means for inputting order data including an order number, an accounting date, a supplier, an order category specifying a cleaning request or a replenishment order, an input warehouse, a container, a container quantity, a unit price, and an amount when making a cleaning request and / or a replenishment order, and when the order category is a cleaning request, generating transfer data including a transfer number, a transfer category, an output warehouse, a container, and a container quantity, and updating the inventory data based on the transfer data.

[0011] In addition, according to one aspect of the present invention, the control unit may further include a second purchasing input means for inputting second purchasing data including a purchasing number, a supplier, a receiving warehouse, a container, a container quantity, a unit price, and an amount when cleaning and / or replenishment is performed, and updating the inventory data based on the input second purchasing data.

[0012] In addition, according to one aspect of the present invention, the control unit may further be provided with an empty container collection status list inquiry means for displaying and outputting a list of customers with a collection rate below a specified collection rate for a specified target period on an empty container collection status list screen displayed on the display unit, by referring to the customer inventory data.

[0013] According to another aspect of the present invention, the container may include a bottle or a barrel.

[0014] In order to solve the above-mentioned problems and achieve the object, the present invention provides a container recovery management method executed by an information processing device having a control unit, the control unit being configured to be able to access customer inventory data including customer, container, stock quantity, shipment quantity, and recovery quantity, and inventory data including warehouse, container, stock quantity, cumulative recovery, and cumulative replenishment, and a method executed by the control unit includes inputting shipping data including a shipping number, a recording date, customer, product, shipping quantity, container, and container quantity when shipping a product, and calculating the customer inventory data and the previous inventory data based on the input shipping data. The method includes a shipment input process for updating inventory data, a first purchase input process for inputting first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when a container is collected, and updating the customer inventory data and the inventory data based on the input first purchase data, and an inventory inquiry process for displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, the container, the inventory quantity, the shipment quantity, the collection quantity, and the collection rate calculated as the collection quantity / shipment quantity x 100, by referring to the customer inventory data for a specified customer.

[0015] In order to solve the above-mentioned problems and achieve the object, the present invention provides a container collection management program to be executed by an information processing device having a control unit, the control unit being configured to be able to access customer inventory data including customer, container, stock quantity, shipment quantity, and collection quantity, and inventory data including warehouse, container, stock quantity, cumulative collection, and cumulative replenishment, and the control unit inputs shipping data including a shipping number, a recording date, customer, product, shipment quantity, container, and container quantity when shipping a product, and updates the customer inventory data and the inventory data based on the input shipping data. a first purchase input step of inputting first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when a container is collected, and updating the customer inventory data and the inventory data based on the input first purchase data; and an inventory inquiry step of displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, the container, the inventory quantity, the number of shipments, the number of collections, and the collection rate calculated as the number of collections / the number of shipments x 100, for a specified customer, by referring to the customer inventory data. Effect of the Invention

[0016] According to the present invention, when a product is shipped to a customer in a container, it is possible to manage the collection of containers for each customer and visualize the collection status of the containers. [Brief description of the drawings]

[0017] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a container collection management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the customer master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the configuration of the supplier master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the product master. [Diagram 5] FIG. 5 is a diagram showing a process flow illustrating an example of the overall process of the container collection management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the process of the control unit of the container collection management device according to the present embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the process of the control unit of the container collection management apparatus according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0018] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0019] [1. Overview] For example, when beverages are shipped to customers in bottles or barrels, the containers are often collected and reused. Since reusing containers reduces costs, collecting as many as possible leads to cost reduction.

[0020] However, in the past, it was not possible to manage containers after they were shipped to customers, and in actual operations, collection was left to the customers, making it impossible to manage how much was being collected.

[0021] In this embodiment, when products are shipped to customers in containers, the container collection status is visualized by managing the collection of containers for each customer, thereby promoting cost reduction.

[0022] Specifically, the container recovery management device of this embodiment performs the following process. (1) Update customer inventory data for containers linked to the product when it is shipped to the customer. (2) When inquiring about customer inventory, the inventory data is referenced to visualize the inventory of containers shipped to each customer. (3) When collecting containers, update the customer inventory data so that the inventory amount of containers collected from the customer is reduced. (4) Enter an order for empty containers to replenish the stock, and be able to check the replenishment in the inventory data for your warehouse.

[0023] In the following explanation, an example will be given of a case where a product (beverage) is packed in a bottle or barrel and shipped to a customer, but in the present invention, the container is not limited to a bottle or barrel, and any recyclable container is applicable, and the product is not limited to a beverage, and the present invention is applicable to any product that is shipped in a container. The container recovery management device of the present invention is widely applicable to industries such as the food industry and the chemical industry.

[0024] [2. Configuration] An example of the configuration of a container collection management apparatus 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 container collection management apparatus 100.

[0025] The container collection management device 100 is a commercially available desktop personal computer. The container collection management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may 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 container collection management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the container collection management 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 container collection management apparatus 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the container collection management apparatus 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[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 realize 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. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as a "user operation via a UI."

[0029] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes a customer master 106a, a supplier master 106b, a product master 106c, a data table 106d, and the like. FIG. 2 is a diagram showing an example of the configuration of the customer master 106a. FIG. 3 is a diagram showing an example of the configuration of the supplier master 106b. FIG. 4 is a diagram showing an example of the configuration of the product master 106c.

[0030] The customer master 106a is a master for converting between customers and suppliers. The customer master 106a can be configured as a table in which customer codes, customer names, and supplier codes are registered in association with each other, as shown in Fig. 2. In the example shown in Fig. 2, the first line has customer code "TOK001", customer name "AAA Co., Ltd.", and supplier code "SIR001", and the second line has customer code "TOK002", customer name "BBB Co., Ltd.", and supplier code "SIR002".

[0031] The supplier master 106b can be configured, for example, as a table in which supplier codes and supplier names are registered in association with each other, as shown in Fig. 3. The supplier master 106b is referred to when converting a supplier code and a supplier name.

[0032] The product master 106c is a master for linking products with containers. The product master 106c can be configured as a table or the like in which product codes, product names, container codes, and container names are associated and registered, as shown in Fig. 4. In the example shown in Fig. 4, the first line contains the product code "SEI001", the product name "XXX", the container code "YOK001", and the container name "Bottle (XX)".

[0033] The data file 106d is a file for storing customer stock data, stock data, shipping data, first purchase data, order data, movement data, second purchase data, and the like.

[0034] The customer inventory data may include a customer code, a container code, a quantity in stock, a quantity shipped, and a quantity collected.

[0035] The inventory data may include a warehouse code, a container code, an inventory quantity, a cumulative total of items withdrawn, and a cumulative total of items replenished.

[0036] The shipping data may include a shipping number, a recording date, a customer name, a product, a shipping quantity, a container, and a container quantity.

[0037] The first purchase data may include data on a purchase number, a recording date, a supplier name, a receiving warehouse, a container, and a container quantity.

[0038] The order data may include order number, accounting date, line, supplier name, order category, receiving warehouse, container, container quantity, unit price, and amount.

[0039] The movement data may include movement number, movement category, row, issuing warehouse, container, and container quantity.

[0040] The second purchase data may include a purchase number, a posting date, a line, a supplier name, a purchase category, a receiving warehouse, a container, a container quantity, a unit price, and an amount.

[0041] 1, the control unit 102 is a CPU or the like that performs overall control of the container collection management 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, and the like, and executes various types of information processing based on these stored programs.

[0042] The control unit 102 is configured to be able to access the customer master 106a, the supplier master 106b, the product master 106c, the data file 106d, and the like stored in the storage unit 106. The customer master 106a, the supplier master 106b, the product master 106c, and the data file 106d may be provided in another location (e.g., the server 200) as long as the control unit 102 is able to access them.

[0043] The control unit 102, in terms of functional concept, includes a shipping input unit 102a, a first purchasing input unit 102b, an order input unit 102c, a second purchasing input unit 102d, an inventory inquiry unit 102e, an empty container collection status list inquiry unit 102f, a screen display control unit 102g, and a master maintenance unit 102h.

[0044] The shipment input unit 102a, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, inputs shipping data including the shipping number, accounting date, customer (customer code and / or customer name), product (product code and / or product name), shipping quantity, container (container code and / or container name), and container quantity when shipping a product, and registers the data in the data file 106d, and updates the customer inventory data and inventory data in the data file 106d based on the input shipping data.

[0045] When a product is input as shipping data, the shipment input unit 102a may automatically input a container associated with the product by referring to the product master 106c.

[0046] The first purchasing input unit 102b, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, inputs first purchasing data including the purchasing number, the customer supplier (supplier code and / or supplier name), the receiving warehouse, the container, and the quantity of containers when the container is collected, and registers the data in the data file 106d, and updates the customer inventory data and inventory data in the data file 106d based on the input first purchasing data.

[0047] The first purchase input unit 102b may refer to the customer master 106a, convert the supplier in the first purchase data to a customer, and update the customer inventory data for the converted customer.

[0048] The order input unit 102c, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, when making a cleaning request and / or a replenishment order, inputs order data including the order number, accounting date, supplier, order category specifying the cleaning request or replenishment order, receiving warehouse, container, container quantity, unit price, and amount, and registers this in the data file 106d, and if the order category is a cleaning request, generates transfer data including the transfer number, transfer category, shipping warehouse, container, and container quantity, and registers this in the data file 106d, and updates the inventory data in the data file 106d based on the transfer data.

[0049] The second purchase input unit 102d, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, inputs second purchase data including a purchase number, supplier, receiving warehouse, container, container quantity, unit price, and amount when cleaning and / or replenishment is performed, registers the data in the data file 106d, and updates the inventory data in the data file 106d based on the input second purchase data.

[0050] For example, on a customer inventory inquiry screen displayed on the monitor 114, the inventory inquiry unit 102e refers to the customer inventory data in the data file 106d for a specified customer, and displays and outputs the container, number in stock, number shipped, number recovered, and the return rate calculated by number recovered / number shipped x 100.

[0051] Furthermore, the stock inquiry unit 102e, for example, on the stock inquiry screen displayed on the monitor 114, references the stock data in the data file 106d for the specified warehouse, and outputs and displays the product, the number of items in stock, the total number of items recovered, and the total number of items replenished.

[0052] The empty container collection status list inquiry unit 102f displays and outputs a list of customers with a collection rate equal to or lower than the specified collection rate for the specified target period on the empty container collection status list screen displayed on the means display unit, by referring to the customer inventory data.

[0053] The screen display control unit 102g controls the display of various screens (eg, input screen, customer stock inquiry screen, stock inquiry screen, empty container collection status list screen, etc.) displayed on the monitor 114 and the input therefor.

[0054] The master maintenance unit 102h performs settings such as data input, addition, change, and update for the customer master 106a, the supplier master 106b, and the product master 106c, in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0055] [3. Specific Examples] A specific example of the process of the control unit 102 of the container collection management apparatus 100 in this embodiment will be described with reference to FIGS.

[0056] (3-1. Overall processing) FIG. 5 is a diagram showing a process flow for explaining an outline of the overall process of the control unit 102 of the container collection management apparatus 100 in this embodiment.

[0057] An outline of the overall processing of the control unit 102 of the container collection management apparatus 100 in this embodiment will be described with reference to Fig. 5. In Fig. 5, the shipment input unit 102a executes a shipment input process (step S1). Specifically, in the shipment input process, the shipment input unit 102a inputs shipping data including a shipping number, a recording date, a customer name, a product, a shipping quantity, a container, and a container quantity when a product is shipped in response to an operation by an operator on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106d, and updates the customer inventory data and inventory data in the data file 106d based on the input shipping data.

[0058] The first purchase input unit 102b executes a first purchase input process (step S2). Specifically, in the first purchase input process, the first purchase input unit 102b inputs first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when a container is returned in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, registers the data in the data file 106d, and updates the customer stock data and stock data in the data file 106d based on the input first purchase data.

[0059] The order input unit 102c executes an order input process (step S3). Specifically, in the order input process, when making a cleaning request and / or a replenishment order in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, the order input unit 102c inputs order data including an order number, a recording date, a supplier, an order category specifying a cleaning request or a replenishment order, an input warehouse, a container, a container quantity, a unit price, and an amount, and registers the data in the data file 106d, and when the order category is a cleaning request, generates transfer data including a transfer number, a transfer category, a delivery warehouse, a container, and a container quantity, and registers the transfer data in the data file 106d, and updates the inventory data in the data file 106d based on the transfer data.

[0060] The second purchase input unit 102d executes a second purchase input process (step S4). Specifically, in the second purchase input process, the second purchase input unit 102d inputs second purchase data including a purchase number, a supplier, a receiving warehouse, a container, a container quantity, a unit price, and an amount when cleaning and / or refilling is performed in response to an operation by an operator on an input screen (not shown) displayed on the monitor 114, registers the second purchase data in the data file 106d, and updates the inventory data in the data file 106d based on the input second purchase data.

[0061] The stock inquiry unit 102e executes a stock inquiry process (step S5). Specifically, in the stock inquiry process, the stock inquiry unit 102e, for example, refers to the customer stock data in the data file 106d for a specified customer on a customer stock inquiry screen displayed on the monitor 114, and displays and outputs the container, the number of items in stock, the number of items shipped, the number of items collected, and the collection rate calculated by collecting number / number of items shipped×100. The stock inquiry process can be executed at any time.

[0062] In addition, in the inventory inquiry process, the inventory inquiry unit 102e, for example, refers to the inventory data in the data file 106d for the specified warehouse on an inventory inquiry screen displayed on the monitor 114, and displays and outputs the product, inventory quantity, cumulative recovery, and cumulative replenishment.

[0063] The empty container collection status list inquiry unit 102f executes an empty container collection status list inquiry process (step S6). Specifically, in the empty container collection status list inquiry process, the empty container collection status list inquiry unit 102f displays and outputs a list of customers with collection rates equal to or lower than the designated rate on the empty container collection status list screen displayed on the monitor 114 by referring to customer inventory data.

[0064] (3-2. Sample data) 6 to 14 are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the container collection management apparatus 100 in this embodiment. A specific example of the processing of the control unit 102 of the container collection management apparatus 100 in this embodiment will be explained with reference to Figs. 6 to 14. In the following example, a case will be explained in which the data examples of the customer master 106a, supplier master 106b, and product master 106c in Figs. 2 to 4 are used.

[0065] (S1: Shipping input processing) A specific example of the shipment input process will be described with reference to Fig. 6. When a product is shipped, the shipment input unit 102a inputs shipping data including a shipping number, a recording date, a customer name, a product, a shipping quantity, a container, and a container quantity in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data file 106d. When a product is input, the container is obtained from the product master 106c using the product as a key, and a container associated with the product is automatically set.

[0066] FIG. 6(A) shows an example of shipping data. The shipping data includes the following fields: shipping number, accounting date, customer name, product, shipping quantity, container, and container quantity. In the example shown in FIG. 6(A), the shipping number is "SH0001", accounting date is "2021 / 12 / 10", customer is "TOK001:AAA Co., Ltd.", product is "SEI001:XXX", shipping quantity is "10,000 bottles", container is "YOK001:Bottle (XX)", and container quantity is "10,000 bottles." Using the customer "TOK001:AAA Co., Ltd." as a key, the container "YOK001:Bottle (XX)" is obtained from the product master 106c in FIG. 4 and automatically set.

[0067] The shipment input unit 102a updates the customer inventory data and inventory data in the data file 106d based on the shipment data. Fig. 6(B) shows an example of customer inventory data. The customer inventory data is data for managing the inventory of containers at a customer, and includes items such as customer code, container code, inventory quantity, shipment quantity, and recall quantity. In the example shown in Fig. 6(B), the customer code is "TOK001", inventory quantity "10,000", shipment quantity "10,000", and recall quantity "0".

[0068] Figure 6(C) shows an example of inventory data. The inventory data has the following fields: warehouse code, container code, stock quantity, cumulative recovery, and cumulative replenishment. In the example shown in Figure 6(C), the warehouse code is "SOK001", the container code is "YOK001", the stock quantity is "0", the cumulative recovery is "0", and the cumulative replenishment is "0".

[0069] (S5: Stock inquiry process after receiving input process) The stock inquiry unit 102e can always inquire about the customer stock data and stock data in the data file 106d. Here, a case where stock inquiry is made after the arrival input process will be described. The stock inquiry process after the arrival input process will be described with reference to FIG. 7.

[0070] For example, on a customer inventory inquiry screen displayed on the monitor 114, the inventory inquiry unit 102e refers to the customer inventory data in the data file 106d for a specified customer, and displays and outputs the container, number in stock, number shipped, number recovered, and the recovery rate calculated as number recovered / number shipped x 100.

[0071] FIG. 7A is a diagram showing a display example of a customer inventory inquiry screen. The customer inventory inquiry screen is It is provided with a customer designation area for designating a customer, an extraction result area for displaying the extraction results (containers, number in stock, number shipped, number collected, and collection rate) with the designated customer as the extraction condition, and an execute button (not shown).When the operator designates a customer in the customer designation area and presses the execute button (not shown), the stock inquiry unit 102e uses the designated customer as a key to refer to the customer stock data in the data file 106d, and displays the containers, number in stock, number shipped, number collected, and collection rate calculated by (number collected / number shipped)×100 in the extraction result area.

[0072] In the example shown in FIG. 7(A), the customer "TOK001 AAA Co., Ltd." is specified in the customer specification area, and the following are displayed in the extraction result area: container "YOK001 Bottle (○○)", stock quantity "10,000", shipment quantity "10,000", recovery quantity "0", and recovery rate "0".

[0073] For example, the stock inquiry unit 102e refers to the stock data in the data file 106d for a specified warehouse on a stock inquiry screen displayed on the monitor 114, and displays and outputs the product, the number of items in stock, the total number of items collected, and the total number of items replenished.

[0074] 7(B) is a diagram showing an example of the display of the inventory inquiry screen. The inventory inquiry screen includes a warehouse designation area for designating a warehouse, an extraction result area for displaying the extraction results (containers, inventory quantity, total collection, total replenishment) with the designated warehouse as the extraction condition, and an execute button (not shown).

[0075] When the operator specifies a customer in the warehouse specification area and presses an execute button (not shown), the inventory inquiry unit 102e uses the specified warehouse as a key to refer to the inventory data in the data file 106d, and displays the container, inventory quantity, cumulative recovery, and cumulative replenishment in the extraction result area.

[0076] In the example shown in FIG. 7(B), the warehouse "SOK001 Material Warehouse" is specified in the warehouse specification area, and the container "YOK001 Bottle (○○)", stock quantity "0", cumulative recovery "0", and cumulative replenishment "0" are displayed in the extraction result area.

[0077] (S2: First purchase input process) A specific example of the first purchase input process will be described with reference to Fig. 8. For example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, the first purchase input unit 102b inputs first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when a container is collected, registers the data in the data file 106d, and updates the customer stock data and stock data in the data file 106d based on the input first purchase data.

[0078] FIG. 8(A) shows an example of the first purchasing data. The first purchasing data includes the following items: purchase number, accounting date, supplier name, receiving warehouse, container, and container quantity. In the example shown in FIG. 8(A), the purchase number is "SH0001", the accounting date is "2022 / 01 / 20", the supplier name is "SIR001: AAA Co., Ltd.", the receiving warehouse is "SOK001: Material Warehouse," the container is "YOK001: Bottle (○○)," and the container quantity is "9,500 bottles." Here, the container "YOK001: Bottle (○○)" is collected in a quantity of "9,500 bottles" from the supplier (customer) "SIR001: AAA Co., Ltd." to the receiving warehouse "SOK001: Material Warehouse."

[0079] FIG. 8(B) shows an example of data in the customer master 106a (similar to FIG. 2). Using the customer master 106a, conversion is performed from supplier to customer in the purchase data, and the stock in the customer inventory data for the target customer code is reduced. In the example shown in FIG. 8(B), the customer code is "TOK001", the customer name is "AAA Co., Ltd.", and the supplier code is "SIR001." Here, the supplier name "SIR001:AAA Co., Ltd." is converted to the customer code "TOK001," and the stock quantity in the customer inventory data for customer code "TOK001" is updated to "500 (=10,000-9,500)" and the collected quantity to "9,500 (=0+9,500)" as shown in FIG. 8(C). Also, as shown in FIG. 8(D), the inventory data is updated to the inventory quantity "9,500 (=0+9,500)" and the cumulative collection amount "9,500 (=0+9,500)."

[0080] (S5: Inventory inquiry process after first purchase input process) With reference to FIG. 9, the stock inquiry process after the first purchase input process will be described.

[0081] Fig. 9(A) is a diagram showing a display example of a customer inventory inquiry screen. In the example shown in Fig. 9(A), the customer "TOK001 AAA Co., Ltd." is specified in the customer specification area, and the container "YOK001 Bottle (XX)", the stock quantity "500", the shipment quantity "10,000", the collection quantity "9,500", and the collection rate "95% (= 9,500 / 10,000)" are displayed in the extraction result area.

[0082] Fig. 9(B) is a diagram showing an example of the display of the inventory inquiry screen. In the example shown in Fig. 9(B), the warehouse "YOK001 Material Warehouse" is specified in the warehouse specification area, and the container "YOK001 Bottle (○○)", the stock quantity "9,500", the total collection "9,500", and the total replenishment "0" are displayed in the extraction result area.

[0083] (S3: Order entry processing) The order input process will be described with reference to Fig. 10. For example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, when making a cleaning request and / or a replenishment order, the order input unit 102c inputs order data including an order number, an accounting date, a supplier, an order category specifying a cleaning request or a replenishment order, an input warehouse, a container, a container quantity, a unit price, and an amount, and registers the data in the data file 106d, and when the order category is a cleaning request, generates transfer data including a transfer number, a transfer category, an output warehouse, a container, and a container quantity, and registers the transfer data in the data file 106d, and updates the inventory data in the data file 106d based on the transfer data.

[0084] Here, an example will be explained in which, in order to manufacture 10,000 products, an order is placed with the supplier to clean the collected containers and to replenish the shortfall.

[0085] FIG. 10(A) shows an example of order data. The order data includes the following fields: order number, accounting date, line, supplier name, order category, receiving warehouse, container, container quantity, unit price, and amount. In the example shown in FIG. 10(A), the first line contains the order number "HA0001", accounting date "2022 / 01 / 23", line "1", supplier name "SIR002: BBB Co., Ltd.", order category "cleaning request", receiving warehouse "SOK001: material warehouse", container "YOK001: bottle (○○)", container quantity "9,500 bottles", unit price "3", and amount "28,500". The second line contains the order number "HA0001", accounting date "2022 / 01 / 23", line "2", supplier name "SIR002: BBB Co., Ltd.", order category "Replenishment order", receiving warehouse "SOK001: Materials warehouse", container "YOK001: Bottle (○○)", container quantity "500", unit price "10", and amount "5,000".

[0086] When the order category of the order data is a cleaning request, the order input unit 102c generates transfer data including the transfer number, transfer category, shipping warehouse, container, and container quantity, registers it in the data file 106d, and updates the inventory data in the data file 106d based on the transfer data.

[0087] In the case of a cleaning request, transfer data is created to ship the stock from the receiving warehouse. Figure 10(B) shows an example of the transfer data. The transfer data may include the following fields: transfer number, transfer category, line, shipping warehouse, container, and container quantity. In the example shown in Figure 10(B), the transfer number is "ID0001", transfer category "shipping", line "1", shipping warehouse "SOK001: material warehouse", container "YOK001: bottle (○○)", and container quantity "9,500 bottles".

[0088] Since "9,500" containers have been moved, the inventory quantity in the inventory data is updated to "0 (=9,500-9,500)", as shown in FIG. 10(D).

[0089] (S5: Stock inquiry process after ordering) With reference to FIG. 11, the stock inquiry process after the order process will be described.

[0090] Fig. 11(A) is a diagram showing an example of a customer inventory inquiry screen. The example table shown in Fig. 11(A) is the same as Fig. 9(A), and the customer "TOK001 AAA Co., Ltd." is specified in the customer specification area, and the container "YOK001 Bottle (XX)", stock quantity "500", shipment quantity "10,000", collection quantity "9,500", and collection rate "95% (= 9,500 / 10,000)" are displayed in the extraction result area.

[0091] Fig. 11(B) is a diagram showing an example of the display of the inventory inquiry screen. In the example shown in Fig. 11(B), the warehouse "SOK001 Material Warehouse" is specified in the warehouse specification area, and the container "YOK001 Bottle (○○)", the stock quantity "0", the total amount of collection "9,500", and the total amount of replenishment "0" are displayed in the extraction result area.

[0092] (S4: Second purchase input process) A specific example of the second purchase input process will be described with reference to Fig. 12. For example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, the second purchase input unit 102d inputs second purchase data including a purchase number, a supplier, a receiving warehouse, a container, a container quantity, a unit price, and an amount when cleaning and / or refilling is performed, registers the second purchase data in the data file 106d, and updates the inventory data in the data file 106d based on the input second purchase data.

[0093] Containers for cleaning and refilling are received from the supplier (container cleaning company). FIG. 12(A) shows an example of the second purchasing data. The second purchasing data has the following fields: purchase number, accounting date, line, supplier name, purchasing category, receiving warehouse, container, container quantity, unit price, and amount. In the example shown in FIG. 12(A), the first line has purchase number "SH0002", accounting date "2022 / 01 / 23", line "1", supplier name "SIR002: BBB Co., Ltd.", purchasing category "cleaning request", receiving warehouse "SOK001: material warehouse", container "YOK001: bottle (○○)", container quantity "9,500", unit price "3", and amount "28,500". The second line contains the purchase number "SH0001", accounting date "2022 / 01 / 23", line "2", supplier name "SIR002: BBB Co., Ltd.", purchase category "Replenishment order", receiving warehouse "SOK001: Materials warehouse", container "YOK001: Bottle (○○)", container quantity "500", unit price "10", and amount "5,000".

[0094] As shown in FIG. 12(C), based on the second purchase data, the inventory amount in the inventory data is updated to "10,000 (=0+9,500+500)" and the cumulative replenishment amount is updated to "500 (=0+500)."

[0095] (S5: Inventory inquiry process after second purchase input process) The inventory inquiry process after the second purchase input process will be described with reference to FIG.

[0096] Fig. 13(A) is a diagram showing an example of a customer inventory inquiry screen. The example table shown in Fig. 13(A) is the same as Fig. 9(A), and the customer "TOK001 AAA Co., Ltd." is specified in the customer specification area, and the container "YOK001 Bottle (XX)", stock quantity "500", shipment quantity "10,000", collection quantity "9,500", and collection rate "95% (= 9,500 / 10,000)" are displayed in the extraction result area.

[0097] Fig. 13(B) is a diagram showing an example of the display of the inventory inquiry screen. In the example shown in Fig. 13(B), the warehouse "SOK001 material warehouse" is specified in the warehouse specification area, and the container "YOK001 bottle (○○)", the stock quantity "10,000", the total collection "9,500", and the total replenishment "500" are displayed in the extraction result area.

[0098] (S6: Empty container collection status list inquiry process) The empty container collection status list inquiry process will be described with reference to Fig. 14. The empty container collection status list inquiry unit 102f outputs information on a list of customers with collection rates equal to or lower than a specified rate on the empty container collection status list screen displayed on the monitor 114 by referring to the customer inventory data in the data file 106d.

[0099] 14(A) is a diagram showing an example of the display of the empty container collection status list screen. The empty container collection status list screen has areas for specifying the extraction conditions of customer, target date, and collection rate (hereinafter), and an execute button (not shown). The empty container collection status list inquiry unit 102f extracts information that meets the specified extraction conditions from the customer inventory data, and outputs an empty container collection status list report (a report including items such as customer, container, number shipped, number collected, collection rate, and number in stock).

[0100] Figure 14(B) is a diagram showing an example of an image of an empty container collection status list form. In the example shown in Figure 14(A), the target date "2021 / 12 / 01~" and collection rate "95% or less" are specified, and an empty container collection status list form as shown in Figure 14(B) (customer "TOK001 AAA Co., Ltd.", container "YOK001 bottle (○○)", shipment quantity "10,000", collection quantity "9,500", collection rate "95%", inventory quantity "500") is output.

[0101] As described above, according to this embodiment, the system includes a shipping input unit 102a that inputs shipping data including a shipping number, a recording date, a customer, a product, a shipping quantity, a container, and a container quantity when shipping a product, and updates customer inventory data and inventory data based on the input shipping data, a first purchase input unit 102b that inputs first purchase data including a purchase number, a customer supplier, a warehouse, a container, and a container quantity when collecting containers, and updates customer inventory data and inventory data based on the input first purchase data, and an inventory inquiry unit 102e that refers to the customer inventory data for a specified customer on a customer inventory inquiry screen displayed on a monitor 114 and displays and outputs containers, inventory quantity, number of shipments, number of collections, and a collection rate calculated by number of collections / number of shipments×100, so that it is possible to manage the collection of containers for each customer and visualize the collection status of containers. As a result, it is possible to grasp the collection status of containers for each customer, and promote collection for customers with poor collection rates, thereby promoting cost reduction.

[0102] [4. 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 goals 8 and 9 of the SDGs.

[0103] 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.

[0104] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0105] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0106] 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.

[0107] In addition, 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 may be changed as desired unless otherwise specified.

[0108] Moreover, with regard to the container recovery management device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0109] For example, the processing functions of the container collection management apparatus 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the container collection management apparatus 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form the control unit.

[0110] In addition, this computer program may be stored in an application program server connected to the container collection management apparatus 100 via an arbitrary network, and it is also possible to download all or a part of it as necessary.

[0111] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.

[0112] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working 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, may use well-known configurations and procedures.

[0113] The various databases etc. 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 etc. used for various processes and providing websites.

[0114] The container collection management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The container collection management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.

[0115] 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 functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0116] 100 Container collection management device 102 Control section 102a Shipping Input Section 102b First purchase input section 102c Order input section 102d Second Purchase Input Section 102e Stock Inquiry Section 102f Empty container collection status list inquiry section 102g Screen display control unit 102h Master Maintenance Department 104 Communication interface section 106 Storage section 106a Customer Master 106b Supplier Master 106c Product Master 106d Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. A container collection management device that includes a control unit and manages collection of containers shipped to customers, The control unit is Customer inventory data including customer, container, stock quantity, shipment quantity, and collection quantity; Inventory data including warehouse, container, stock quantity, total collection, total replenishment, is configured to be accessible to a shipment input means for inputting shipping data including a shipping number, a recording date, a customer, a product, a shipping quantity, a container, and a container quantity when shipping a product, and updating the customer inventory data and the inventory data based on the input shipping data; a first purchase input means for inputting first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when the container is collected, and updating the customer inventory data and the inventory data based on the input first purchase data; an inventory inquiry means for displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, containers, inventory quantities, shipment quantities, collection quantities, and collection rates calculated by collection quantities / shipment quantities×100, for a designated customer, by referring to the customer inventory data; A container collection management device comprising:

2. The container recovery management device according to claim 1, characterized in that the inventory inquiry means refers to the inventory data for a specified warehouse on an inventory inquiry screen displayed on the display unit, and displays and outputs containers, inventory quantities, cumulative recovery, and cumulative replenishment.

3. The control unit further includes: It is configured to be able to access product master data that associates products with containers, 3. The container recovery management device according to claim 1, wherein the shipment input means, when a product is input for the shipping data, automatically inputs a container associated with the product by referring to the product master.

4. The control unit further includes: It is configured to be able to access customer master data that associates customers and suppliers. The container recovery management device described in any one of claims 1 to 3, characterized in that the first purchasing input means refers to the customer master, converts the supplier of the first purchasing data to a customer, and updates the customer inventory data for the converted customer.

5. The control unit further includes: The container recovery management device described in any one of claims 1 to 4 is characterized in that, when making a cleaning request and / or a replenishment order, order data including an order number, a recording date, a supplier, an order category specifying a cleaning request or replenishment order, an input warehouse, a container, a container quantity, a unit price, and an amount is input, and if the order category is a cleaning request, movement data including a movement number, a movement category, a shipping warehouse, a container, and a container quantity is generated, and the inventory data is updated based on the movement data.

6. The control unit further includes: The container recovery management device described in claim 5, characterized in that it is equipped with a second purchasing input means for inputting second purchasing data including a purchasing number, supplier, receiving warehouse, container, container quantity, unit price, and amount when cleaning and / or replenishment is performed, and updating the inventory data based on the input second purchasing data.

7. The control unit further includes: A container collection management device as described in any one of claims 1 to 6, characterized in that it is equipped with an empty container collection status list inquiry means for displaying and outputting a list of customers with collection rates below a specified level on an empty container collection status list screen displayed on the display unit, by referring to the customer inventory data.

8. 8. The container recovery management device according to claim 1, wherein the container includes a bottle or a barrel.

9. A container collection management method executed by an information processing device having a control unit, The control unit is Customer inventory data including customer, container, stock quantity, shipment quantity, and collection quantity; Inventory data including warehouse, container, stock quantity, total collection, total replenishment, is configured to be accessible to Executed in the control unit, a shipment input process for inputting shipping data including a shipping number, a recording date, a customer, a product, a shipping quantity, a container, and a container quantity when shipping a product, and updating the customer inventory data and the inventory data based on the input shipping data; a first purchase input process for inputting first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when the container is collected, and updating the customer inventory data and the inventory data based on the input first purchase data; an inventory inquiry step of displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, containers, inventory quantities, shipment quantities, collection quantities, and collection rates calculated by collection quantities / shipment quantities×100, for a designated customer, with reference to the customer inventory data; A container collection management method comprising:

10. A container collection management program to be executed by an information processing device having a control unit, The control unit is Customer inventory data including customer, container, stock quantity, shipment quantity, and collection quantity; Inventory data including warehouse, container, stock quantity, total collection, total replenishment, is configured to be accessible to In the control unit, a shipment input process for inputting shipping data including a shipping number, a recording date, a customer, a product, a shipping quantity, a container, and a container quantity when shipping a product, and updating the customer inventory data and the inventory data based on the input shipping data; a first purchase input process for inputting first purchase data including a purchase number, a customer supplier, a receiving warehouse, a container, and a container quantity when the container is collected, and updating the customer inventory data and the inventory data based on the input first purchase data; an inventory inquiry step of displaying and outputting, on a customer inventory inquiry screen displayed on a display unit, containers, inventory quantities, shipment quantities, collection quantities, and collection rates calculated by collection quantities / shipment quantities×100, for a designated customer, with reference to the customer inventory data; A container collection management program to implement the above.

Citation Information

Patent Citations

  • Recovery control server

    JP2003203185A

  • Distribution information management system

    JP2006285545A

  • Portable terminal for container collection support, container collection support system and program

    JP2009110254A

  • Portable terminal for supporting container collection and container collection support system

    JP2017199244A