Inventory management device, inventory management method, and inventory management program
The inventory management system addresses the challenge of managing products stored in manufacturer yards by tracking and allocating storage based on delivery destinations, enhancing inventory management and reducing errors, thus improving business efficiency.
Patent Information
- Application Number
- JP2023077137
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-05-09
- Publication Date
- 2024-11-21
- Estimated Expiration
- 2043-05-09
AI Technical Summary
Companies face challenges in managing inventory of products stored in manufacturer yards, which are assets of other companies, leading to high transportation costs and difficulties in securing inventory for customers.
An inventory management system that includes a warehouse management device and method to track and allocate storage locations for products in manufacturer yards based on delivery destination information, generating inventory data and reports, and integrating with accounting systems.
Enables companies to manage inventory of products stored in manufacturer yards efficiently, reducing errors, preventing customer complaints, and improving business efficiency by securing inventory and reducing waste.
Smart Images

Figure 2024162011000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to an inventory management device, an inventory management method, and an inventory management program. [Background technology]
[0002] Patent document 1 (JP 2021-157397 A) discloses a product storage management method that can reduce the frequency of interruptions in the product manufacturing process and enable efficient production.
[0003] This product storage location management method is a product storage location management method when transporting products from a first storage location where products processed in a first process are stored to a second storage location where products to be processed in a second process are stored. Specifically, in a first prediction step, for a production schedule in a first prediction period, whether or not a suspension will occur is predicted based on the number of products to be processed in the first process and the second process and the total number of products stored in the first storage location and the second storage location at each of a plurality of prediction time points set in the first prediction period.
[0004] In the second prediction step, for the production schedule in which no stoppages are predicted in the first prediction step, the presence or absence of stoppages in the first processing line and the second processing line is predicted at each of a plurality of prediction time points set in a second prediction period that is shorter than the first prediction period. If a stoppage is predicted in the second prediction step, the production schedule is adjusted in the adjustment step. This makes it possible to reduce the frequency of stoppages in the product manufacturing process, and to carry out efficient production. [Prior art documents] [Patent documents]
[0005] [Patent Document 1] Patent Publication No. 2021-157397 Summary of the Invention [Problem to be solved by the invention]
[0006] Here, for example, products such as steel are heavy and expensive, so when they arrive at the port by ship or are manufactured in a factory, moving them from the manufacturer's location (manufacturer's yard) incurs high transportation costs.
[0007] For this reason, companies that sell goods to consumers (delivery destinations) do not move the goods to their own warehouses, but instead issue shipping instructions for the goods stored in the manufacturer's yard, and deliver them directly from the manufacturer's yard to the consumer.
[0008] However, since the products stored in the manufacturer's yard become the assets of other companies, it is difficult for the company selling the products to customers to manage the inventory.
[0009] The present invention has been made in consideration of the above-mentioned problems, and aims to provide an inventory management device, an inventory management method, and an inventory management program that enable the company that sells the products to consumers to manage the inventory of products that are other companies' assets and are stored in a manufacturer's yard. [Means for solving the problem]
[0010] In order to solve the above-mentioned problems and achieve the object, the inventory management device of the present invention has an acquisition unit that acquires inventory information including the number of incoming goods stored in the manufacturer's warehouse, delivery destination identification information indicating the delivery destination of the incoming goods, and product identification information of the generated goods, which is notified when goods manufactured by the manufacturer are stored in the manufacturer's warehouse; a delivery destination warehouse allocation unit that generates warehouse identification information that assigns the storage location of goods for each delivery destination in the manufacturer's warehouse as a storage warehouse for goods for each delivery destination based on the delivery destination identification information included in the acquired inventory information; a data generation unit that generates inventory information including warehouse identification information indicating the storage warehouse for each delivery destination, the product identification information and stock numbers of goods stored in the storage warehouse for each delivery destination; and an output control unit that outputs the generated inventory information.
[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the inventory management method of the present invention includes an acquisition step in which an acquisition unit acquires inventory information including the number of incoming products stored in the manufacturer's warehouse, delivery destination specific information indicating the delivery destination of the incoming products, and product specific information of the generated products, which is notified when products manufactured by the manufacturer are stored in the manufacturer's warehouse; a delivery destination-specific warehouse allocation step in which a delivery destination-specific warehouse allocation unit generates warehouse specific information in which the storage locations of products in the manufacturer's warehouse for each delivery destination are assigned as storage warehouses for products for each delivery destination based on the delivery destination specific information included in the acquired inventory information; a data generation step in which a data generation unit generates inventory information including warehouse specific information indicating the storage warehouse for each delivery destination, the product specific information and inventory quantity of products stored in the storage warehouse for each delivery destination; and an output control step in which an output control unit outputs the generated inventory information. Effect of the Invention
[0012] The present invention makes it possible for the company that sells the products to customers to manage the inventory of products that are stored in a manufacturer's yard and are assets of other companies. [Brief description of the drawings]
[0013] [Figure 1] FIG. 1 is a block diagram showing a hardware configuration of an inventory management device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the warehouse master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the consumer delivery destination code conversion master. [Figure 4] FIG. 4 is a diagram illustrating an example of the consumer-specific product code conversion master. [Diagram 5] FIG. 5 is a diagram illustrating an example of the journal entry link conversion master. [Figure 6] FIG. 6 is a diagram showing how inventory data is generated in the inventory management device of the embodiment as a result of products manufactured by a manufacturer being stored in each customer's yard warehouse. [Figure 7]FIG. 7 is a diagram showing yard movement data transmitted from the manufacturer to the inventory management device as products manufactured by the manufacturer are stored in each customer's yard warehouse, and movement data generated based on the yard movement data. [Figure 8] FIG. 8 is a diagram showing an example of an order entry screen for entering an order based on an order from a customer. [Figure 9] FIG. 9 is a diagram for explaining the operation of converting delivery destination codes and product codes, etc. into delivery destination codes and product codes used by the manufacturer when transmitting order data generated by the inventory management device to the manufacturer. [Figure 10] FIG. 10 is a diagram showing how inventory data in the inventory management device is updated as new products are produced by a manufacturer and stored in each customer's yard warehouse. [Figure 11] FIG. 11 is a diagram showing how inventory data in the inventory management device is updated as a result of the product stored in a customer's yard warehouse by the manufacturer being shipped in the morning of March 10th. [Figure 12] FIG. 12 is a diagram showing how inventory data in the inventory management device is updated as a result of the product stored in a customer's yard warehouse by the manufacturer being shipped in the afternoon of March 10th. [Figure 13] FIG. 13 is a diagram for explaining the pre-inventory process. [Figure 14] FIG. 14 is a diagram showing a situation in which a person in charge goes to a customer's yard warehouse on the manufacturer's side to check the stock quantity. [Figure 15] FIG. 15 is a diagram showing an example of inventory quantity adjustment data for adjusting the inventory quantity on the ledger. [Figure 16] FIG. 16 is a diagram showing an example of post-inventory data in which the stock quantity has been adjusted based on the stock quantity adjustment data. [Figure 17] FIG. 17 is a diagram showing an example of the inventory report material sent or mailed to the consumer. [Figure 18] FIG. 18 is a diagram showing an example of the stock inquiry screen. [Figure 19]FIG. 19 is a diagram showing an example of inventory data used for inventory inquiry. [Figure 20] FIG. 20 is a diagram showing an example of the inventory amount in a yard by consumer that can be output to a management form. [Figure 21] FIG. 21 is a diagram showing an example of the journalization link screen. [Figure 22] FIG. 22 is a diagram illustrating an example of journal data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An inventory management device according to an embodiment of the present invention will now be described in detail with reference to the accompanying drawings. It should be noted that the present invention is not limited to the following embodiment.
[0015] (Hardware configuration) As shown in FIG. 1, the inventory management device 1 of the embodiment is a terminal device of a company that conducts commercial transactions to deliver products manufactured by a manufacturer using steel as a material from the manufacturer's storage location (manufacturer's yard) to a customer who is the delivery destination, and is equipped with a memory unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5.
[0016] An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 may be a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function. The communication interface unit 4 is connected to a network 50, for example, a wide area network such as the Internet or a private network such as a LAN (Local Area Network).
[0017] A manufacturer terminal device 51 of a manufacturer that manufactures products using steel as a material, and a consumer terminal device 52 of a consumer that places orders for the products and is the delivery destination of the products manufactured by the manufacturer are connected to the network 50. Also connected to the network 50 is an accounting server device 60 provided with an accounting system 61, which is software for accounting for the company that owns the inventory management device 1. As shown by the dotted line block in Fig. 1, accounting may be performed in the accounting system 61 provided in the memory unit 2 of the inventory management device 1.
[0018] The storage unit 2 may be, for example, a read only memory (ROM), a random access memory (RAM), a hard disk drive (HDD), or a solid state drive (SSD). The storage unit 2 stores an inventory management program that enables inventory management of other companies' assets stored in the manufacturer's yard. The storage unit 2 also stores a warehouse master 11, a customer delivery destination code conversion master 12, a customer-specific product code conversion master 13, and an accounting linkage conversion master 14, as well as various other data described below.
[0019] In the warehouse master 11, warehouse codes, warehouse names, asset management flags, customer management flags, and customer codes (company) are stored in association with each other as shown in Fig. 2. In the warehouse master 11, the warehouse codes "C001" and "C002" are warehouse codes assigned to the manufacturer's yard as if it were a virtual warehouse of the manufacturer's company. That is, "C001" is a warehouse code assigned to the manufacturer's yard as if it were a "yard warehouse for the first customer," and the warehouse code "C002" is a warehouse code assigned to the manufacturer's yard as if it were a "yard warehouse for the second customer."
[0020] As the managed asset flag, if the asset in that warehouse is the company's own asset, "0: company's asset" is entered, and if the asset in that warehouse is another company's asset, "1: other company's asset" is entered. Since the assets stored in the above-mentioned "yard warehouse for the first customer" and "yard warehouse for the second customer" are other company's assets, the managed asset flag for each is entered as "1: other company's asset."
[0021] As the consumer management flag, if the consumer of the warehouse's assets is not managed, "0: not managed" is input, and if the consumer of the warehouse's assets is managed, "1: managed" is input. The above-mentioned "yard warehouse for the first consumer" and "yard warehouse for the second consumer" are virtual yard warehouses for the corresponding consumers, so the consumer management flag of "1: managed" is input.
[0022] Furthermore, when the customer management flag of "1: Manage" is entered, the customer code (customer code (company)) of each customer used by the company (company) that owns the inventory management device 1 is a mandatory input requirement. The example in Figure 2 is an example in which the customer code (company) of "TOK001" used by the company is entered for the above-mentioned "yard warehouse for first customer," and the customer code (company) of "TOK505" used by the company is entered for the "yard warehouse for second customer."
[0023] The consumer delivery destination code conversion master 12 stores the consumer code of each consumer used in-house (consumer code (company)) and the consumer code of each consumer used by the manufacturer (consumer code (manufacturer)) in association with each other, as shown in Fig. 3. The example in Fig. 3 shows that the consumer code "109100001" is assigned on the manufacturer's side to the consumer "TOK001" used in-house, and the consumer code "109155001" is assigned on the manufacturer's side to the consumer "TOK505" used in-house.
[0024] The customer-specific product code conversion master 13 stores, in association with each other, the "customer code of each customer and the product code of each product used by the company" and the "customer code of each customer and the product code of each product used by the manufacturer" for each product delivered to each customer.
[0025] The example in Figure 4 shows that a product with a product code (in-house) of "SH100001" that is delivered to a consumer managed by the company with a customer code of "TOK001" and managed by the manufacturer with a customer code of "109100001" is managed by the manufacturer with a product code (GLCC5001).The example in Figure 4 also shows that a product with a product code (in-house) of "S135-180" that is delivered to a consumer managed by the company with a customer code of "TOK505" and managed by the manufacturer with a customer code of "109155001" is managed by the manufacturer with a product code (GLWSW950).
[0026] As shown in Fig. 5, the journal entry linkage conversion master 14 stores the journal entry linkage definition of the inventory at the first consumer yard warehouse and the second consumer yard warehouse described with reference to Fig. 2. Specifically, the journal entry linkage conversion master 14 defines that the debit account item for the inventory at the first consumer yard warehouse and the second consumer yard warehouse is "7053" and the debit account item name is "yard end of month inventory" at the time of journal entry linkage.
[0027] Also, it is defined that the amount is the amount of "inventory amount", and the accounting customer code is the delivery destination code (customer code (company)) associated with the warehouse code in the warehouse master 11 shown in Fig. 2. Furthermore, it is defined as a creation condition that accounting linkage is performed only for the inventory of customers whose customer management flag in the warehouse master 11 is set to "1: managed".
[0028] (Functional configuration of inventory management device) Next, the control unit 3 executes the inventory management program stored in the memory unit 2, and thereby functions as an acquisition unit 21, a warehouse allocation unit by delivery destination 22, a data generation unit 23, an output control unit 24, a display control unit 25, and a memory control unit 26, as shown in FIG. 1.
[0029] The acquisition unit 21 acquires inventory information including the number of products stored in the manufacturer's warehouse, delivery destination identification information indicating the delivery destination of the stored products, and product identification information of the created products, which is notified when products manufactured by the manufacturer are stored in the manufacturer's warehouse.
[0030] The destination-specific warehouse allocation unit 22 generates warehouse identification information (warehouse code such as C001 shown in FIG. 6(a), etc.) that assigns the storage location of the product for each destination in the manufacturer's warehouse as a storage warehouse for the product for each destination based on the destination identification information included in the acquired warehousing information.
[0031] The data generation unit 23 generates inventory information (inventory data shown in FIG. 6(a), etc.) including warehouse identification information indicating the storage warehouse of each delivery destination, product identification information (product code shown in FIG. 6(a), etc.) of the products stored in the storage warehouse of each delivery destination, and inventory numbers (weight and quantity, etc. shown in FIG. 6(a), etc.).
[0032] The output control unit 24 outputs the generated inventory information to an output destination such as the output device 7. As the output device 7, in addition to a display unit, an external storage device such as a printing device, a speaker device, a semiconductor memory, or a magnetic storage medium can be used.
[0033] The acquisition unit 21 also acquires inventory information including the number of stored products, delivery destination identification information indicating the delivery destination of the stored products, and product identification information of the stored products, which is sent when the products are further manufactured by the manufacturer and stored in a product storage warehouse for the delivery destination.
[0034] When this inventory information is further obtained, the memory control unit 26 updates the inventory information by adding the inventory quantity of the stored products included in the inventory information to the inventory quantity at the delivery destination indicated by the delivery destination identification information of the inventory information, among the delivery destinations of the storage warehouse indicated by the warehouse identification information included in the inventory information.
[0035] In addition, the acquisition unit 21 acquires shipping information including the number of shipped products, product identification information of the shipped products, and delivery destination identification information indicating the delivery destination of the shipped products, which is sent when the manufacturer ships the products to the delivery destination.
[0036] When this shipping information is acquired, the storage control unit 26 updates the inventory quantity in the inventory information to the inventory quantity obtained by subtracting the number of shipments of the shipped products from the inventory quantity at the delivery destination to which the products were shipped.
[0037] In addition, when the memory control unit 26 receives an input of the difference between the actual stock quantity of the product confirmed by performing an inventory and the stock quantity of the product indicated in the inventory information at the time of the inventory, the memory control unit 26 adjusts the stock quantity in the inventory information by adding or subtracting the input difference to the stock quantity indicated in the inventory information at the time of the inventory.
[0038] When the inventory quantity in the inventory information is adjusted by the inventory, the data generation unit 23 generates inventory quantity report data (inventory quantity report material exemplified in FIG. 17) including the adjusted inventory quantity, and the output control unit 24 outputs this inventory quantity report data. The output control unit 24 outputs the generated inventory quantity report data to an output destination such as the output device 7. As the output device 7, in addition to a display unit, an external storage device such as a printer, a speaker device, a semiconductor memory, or a magnetic storage medium can be used. In addition, the inventory quantity report data is attached as an attachment to an e-mail and sent to the customer terminal device 52 of the customer or mailed to the customer.
[0039] The data generating unit 23 also refers to a storage unit (journal entry linkage conversion master 14) that stores at least account title name designation information that designates an account title name, amount designation information that designates an inventory amount as an amount to be used for accounting among amounts included in the inventory information, and creation conditions for identifying inventory information to be used for accounting data creation among the inventory information. The data generating unit 23 then generates accounting data including an account title name designated by the account title name designation information, an inventory amount designated by the amount designation information, and a business partner based on the inventory information designated by the creation conditions among the inventory information. The output control unit outputs the accounting data to an output destination such as an output device 7. As the output device 7, in addition to a display unit, an external storage device such as a printer, a speaker device, a semiconductor memory, or a magnetic storage medium can be used. The accounting data is also recorded in an accounting system 61, which is software of the accounting server device 60 shown in FIG. 1, or is recorded in the accounting system 61 stored in the storage unit 2.
[0040] (Inventory management operation at manufacturer's yard) Next, the operation of managing the inventory for each consumer stored in the above-mentioned manufacturer yard in the inventory management device 1 of the embodiment will be described. The acquisition unit 21 to the memory control unit 26 of the inventory management device 1 function based on the inventory management program in the memory unit 2, and manage the inventory for each consumer stored in the manufacturer yard as follows.
[0041] First, as shown in the inventory data in Figure 6(a), for example, let us assume that as of March 1, the first customer yard warehouse with warehouse code "C001" virtually assigned to the manufacturer yard does not store an item with product code "SH100001" and inventory unit price "1000 yen". Also, let us assume that as of March 1, the second customer yard warehouse with warehouse code "C002" virtually assigned to the manufacturer yard does not store an item with product code "SI35-180" and inventory unit price "1500 yen".
[0042] In this state, suppose that the acquiring unit 21 has received and acquired the yard movement data shown in Fig. 7(a) as EDI (Electronic Data Interchange) received data from the manufacturer terminal device 51 on March 7th. As shown in Fig. 7(a), this yard movement data is for a product with a product code of "GLCC5001" for a delivery destination code of "109100001" used by the manufacturer, with a weight of "1.2t" and a quantity of "2.4m". Also, suppose that the acquired yard movement data is for a product with a product code of "GLWSW950" for a delivery destination code of "109155001" used by the manufacturer, with a weight of "7.4t" and a quantity of "3.7m" as shown in Fig. 7(a).
[0043] When such yard movement data is acquired from the manufacturer terminal device 51, the data generating unit 23 refers to the consumer delivery destination code conversion master 12 shown in FIG. 3 based on the "delivery destination code (= consumer code used by the manufacturer)" of the acquired yard movement data, and detects the "consumer code (company)" used by the company. In this example, for the consumer code (manufacturer) of "109100001", a consumer code (company) of "TOK001" is detected. Also, for the consumer code (manufacturer) of "109155001", a consumer code (company) of "TOK505" is detected.
[0044] Based on the detected "consumer code (our company)", the data generation unit 23 refers to the warehouse master 11 shown in Fig. 2 and detects a "warehouse code" corresponding to the "consumer code (our company)". In this example, for the consumer code (our company) of "TOK001", the data generation unit 23 detects a warehouse code of "C001", and for the consumer code (our company) of "TOK505", the data generation unit 23 detects a warehouse code of "C002".
[0045] Next, the data generation unit 23 refers to the consumer-specific product code conversion master 13 shown in Fig. 4 based on the "delivery destination code" and "product code" of the acquired yard movement data, and detects the product code (company) used by the company that corresponds to the product code (manufacturer) used by the manufacturer indicated in the yard movement data. In this example, the product code (company) of "SH100001" is detected as the product code (company) that corresponds to the product code (manufacturer) of "GLCC5001". In addition, the product code (company) of "S135-180" is detected as the product code (company) that corresponds to the product code (manufacturer) of "GLWSW950".
[0046] When such information is detected, the data generation unit 23 generates movement data indicating that a product with a weight of "1.2t", a quantity of "2.4m", and a product code (our company) of "SH100001" has been stored in a first customer yard warehouse with a warehouse code of "C001", as shown in Fig. 7(b). The data generation unit 23 also generates movement data indicating that a product with a weight of "7.4t", a quantity of "3.7m", and a product code (our company) of "SI35-180" has been stored in a second customer yard warehouse with a warehouse code of "C002", as shown in Fig. 7(b).
[0047] An automatically assigned transfer number and a transfer category of "entered into yard" are assigned to this transfer data.
[0048] Based on such movement data, the memory control unit 26 inputs (updates) the weight (1.2t) and quantity (2.4m) of the product with product code "SH100001" that has been stored in the first customer yard warehouse with warehouse code "C001", as shown in Figure 6 (b), and also calculates and inputs (updates) the inventory amount corresponding to the weight (1.2t x 1000 yen = 1200 yen).
[0049] Similarly, based on the movement data, the memory control unit 26 inputs (updates) the weight (7.4t) and quantity (3.7m) of the product with product code "SI35-180" that was stored in the first customer yard warehouse with warehouse code "C002", as shown in Figure 6 (b), and calculates and inputs (updates) the inventory amount corresponding to the weight (7.4t x 1,500 yen = 11,100 yen).
[0050] Next, for example, on March 8, a customer (=delivery destination) places an order for a product via the customer terminal device 52. As a result, the operator of the inventory management device 1 performs a display specification operation of the order input screen. When this display specification operation is performed, the display control unit 25 displays the order input screen illustrated in FIG. 8 via the output device 7. The operator operates the input device 6 to input the order number, order date, delivery date, order category (yard order), warehouse code, and insertion destination code as shown in FIG. 8. In the example of FIG. 8, the order date is "March 8, 2023" and the delivery date is "March 10, 2023". In addition, it is indicated that the product is to be shipped from the first customer yard warehouse with a warehouse code of "C001", and the delivery destination is "XX Steelworks" with a delivery destination code of "TOK001".
[0051] The operator also inputs details of the ordered goods, such as the product code, product name, order quantity (weight and amount), order price, order amount, purchase price, purchase amount, gross profit, etc.
[0052] When such an order is input, the data generating unit 23 generates order data including the delivery destination code (= customer code (our company)), delivery destination name, product code (our company), product name, weight, quantity, and delivery date, as shown in Fig. 9(a).The data generating unit 23 also refers to the customer-specific product code conversion master 13 and converts the delivery destination code (= customer code (our company)) into the delivery destination code (= customer code (manufacturer)) used by the manufacturer, and converts the product code (our company) into the product code (customer product code (manufacturer)) used by the manufacturer, generating order data as shown in Fig. 9(b).
[0053] The output control unit 24 transmits the generated order data to the manufacturer terminal device 51. As a result, the manufacturer manufactures the product based on this order data and stores it in the manufacturer's yard. Then, for example, on March 9, the manufacturer generates the transfer yard data shown in FIG. 10(a) corresponding to the newly manufactured product and transmits it to the inventory management device 1.
[0054] When the acquisition unit 21 of the inventory management device 1 acquires the yard movement data, the data generation unit 23 refers to the warehouse master 11 to the customer-specific product code master 13 shown in Figs. 2 to 4 to generate movement data corresponding to the product newly manufactured at the manufacturer side, as shown in Fig. 10(b). The example of Fig. 10(b) indicates that the manufacturer manufactured a product with a weight of "5.5t", a quantity of "11.0m", and a product code of "SH100001", and that this product was stored in a warehouse (storage area) with a warehouse code of "C001" in the manufacturer yard. The example of Fig. 10(b) also indicates that the manufacturer manufactured a product with a weight of "45.7t", a quantity of "22.85m", and a product code of "SI35-180", and that this product was stored in a warehouse (storage area) with a warehouse code of "C002" in the manufacturer yard.
[0055] When new stock is stored in the warehouse (storage area) with warehouse code "C001" and the warehouse (storage area) with warehouse code "C002" in this way, the storage control unit 26 adds the weight and quantity of the movement data in Fig. 10(b) to the weight and quantity of the stock data shown in Fig. 6(b), respectively. As a result, as shown in Fig. 10(c), the stock data is updated by adding the stock of new products manufactured by the manufacturer in response to an order from a consumer to the original stock.
[0056] Next, for example, in the morning of March 10th, when the manufacturer ships the product from the customer yard warehouse for the customer indicated in the order data to the customer indicated in the order data, the shipping data shown in FIG. 11(a) is transmitted to the inventory management device 1 via the manufacturer terminal device 51. The acquisition unit 21 of the inventory management device 1 acquires this shipping data. The data generation unit 23 converts the delivery destination code (manufacturer) and product code (manufacturer) of the acquired shipping data into the delivery destination code (company) and product code (company) used by the company by referring to the customer-specific product code conversion master 13 shown in FIG. 4, and generates the sales data shown in FIG. 11(b). The memory control unit 26 stores this sales data in the memory unit 2.
[0057] In addition, based on this sales data, the memory control unit 26 recalculates the inventory amount by subtracting the weight and quantity of the products sold to "XX Steelworks" this time, as shown in the sales data in Figure 11(b), from the weight and quantity of the inventory data for "XX Steelworks" before the sale, as shown in Figure 10(c), and updates the inventory data as shown in Figure 11(c).
[0058] Similarly, for example, when the manufacturer ships a product from the customer yard warehouse for the customer indicated in the order data to the customer indicated in the order data on the afternoon of March 10, the shipping data shown in FIG. 12(a) is transmitted to the inventory management device 1 via the manufacturer terminal device 51. The acquisition unit 21 of the inventory management device 1 acquires this shipping data. The data generation unit 23 converts the delivery destination code (manufacturer) and product code (manufacturer) of the acquired shipping data into the delivery destination code (company) and product code (company) used by the company by referring to the customer-specific product code conversion master 13 shown in FIG. 4, and generates the sales data shown in FIG. 12(b). The memory control unit 26 stores this sales data in the memory unit 2.
[0059] In addition, based on this sales data, the memory control unit 26 recalculates the inventory amount by subtracting the weight and quantity of the products sold this time to "XX Factory", as shown in the sales data in Figure 12(b), from the weight and quantity of the inventory data of "XX Factory" before the sale, as shown in Figure 11(c), and updates the inventory data as shown in Figure 12(c).
[0060] (Inventory processing) Next, we will explain the inventory process for an inventory carried out on March 31, which is the end of March. When this inventory is carried out, first, a "pre-inventory process" is carried out to confirm the current stock quantity in the ledger. That is, when it is time to carry out the inventory, the operator of the inventory management device 1 operates the input device 6 to specify the display of the pre-inventory process screen.
[0061] When this designation operation is performed, the display control unit 25 displays the inventory pre-processing screen shown in Fig. 13(b) via the output device 7. The operator inputs the inventory date and the warehouse code of the warehouse where the inventory will be performed to this inventory pre-processing screen. The example of Fig. 13(b) is an example where the second customer yard warehouse assigned to the manufacturer yard as described above is designated as the warehouse where the inventory will be performed.
[0062] The data generating unit 23 refers to the inventory data based on the input warehouse code, and generates inventory data indicating the inventory quantity (weight and quantity) of the product stored in the warehouse specified on the inventory pre-processing screen, as shown in FIG. 13(a). The example of FIG. 13(b) is an example in which a first consumer yard warehouse (C001) and a second consumer yard warehouse (C002) are specified as warehouses for inventory, and inventory data indicating the inventory quantities (4.3t / 8.6m, 42.6t / 21.3m) of the products (SH100001, SI35-180) stored in the first consumer yard warehouse and the second consumer yard warehouse is generated. The memory control unit 26 stores this inventory data in the memory unit 2.
[0063] Next, the operator or person in charge visits the manufacturer's yard as shown in Fig. 14 and visually recognizes the inventory quantity of the product stored in the first consumer's yard warehouse and the inventory quantity of the product stored in the second consumer's yard warehouse. Then, the operator calculates the difference between the inventory quantities in the first consumer's yard warehouse (C001) and the second consumer's yard warehouse (C002) shown in the inventory data as of March 31 as shown in Fig. 12(c) and the inventory quantities in the first consumer's yard warehouse (C001) and the second consumer's yard warehouse (C002) visually recognized.
[0064] Then, the operator inputs the difference in the number of the first consumer yard warehouse (C001) and the second consumer yard warehouse (C002) via the inventory adjustment input screen. When the input operation of the difference in the number of the stocks is performed on this inventory adjustment input screen, the data generation unit 23 generates inventory adjustment data indicating the difference in the number of the stocks (=adjustment number) of each product (SH100001, SI35-180) in the first consumer yard warehouse (C001) and the second consumer yard warehouse (C002), as shown in FIG. 15(a).
[0065] The example of inventory adjustment data in Fig. 15(a) shows that a difference of "1.0t, 2.0m" occurred between the book quantity of the product (SH100001) of the first customer's yard warehouse (C001) and the quantity actually stored in the yard warehouse. Also, the example of inventory adjustment data in Fig. 15(b) shows that a difference of "-1.2t, -0.6m" occurred between the book quantity of the product (SI35-180) of the second customer's yard warehouse (C002) and the quantity actually stored in the yard warehouse.
[0066] Next, the operator specifies the display of the inventory input screen via the input device 6. When this specification operation is performed, the display control unit 25 displays the inventory input screen shown in FIG. 15(b) via the output device 7. The operator inputs, on this inventory input screen, an inventory date such as "March 31, 2023", an inventory classification such as "regular inventory", a warehouse code such as "C002 (an example of a case where an inventory is being conducted at a second customer yard warehouse)", a product code such as "SH100001", and a product name such as "iron pillar H type A001".
[0067] In addition, based on the inventory quantity adjustment data shown in Figure 15(a), the operator inputs the above-mentioned difference quantity (=adjustment quantity) corresponding to the warehouse and product for which the inventory is being taken in the inventory information input field among the detailed input fields on the inventory input screen.
[0068] That is, the input fields for details on the inventory input screen are provided with input fields for the product code and product name of the product being inventoryed, as well as a display field for pre-inventory information, an input field for inventory information, and a display field for post-inventory information. In the display field for pre-inventory information, the display control unit 25 displays the inventory quantity (weight and quantity in this case) of the warehouse and product on the inventory date shown in Fig. 12(c) in a state that cannot be changed by the operator.
[0069] Furthermore, when the above-mentioned difference number (=adjustment number) is input in the input field for inventory information, the display control unit 25 performs a calculation process in which the input difference number (=adjustment number) is added or subtracted from the inventory number in the pre-inventory information to match the inventory number in the ledger on the inventory day with the actual inventory number. This adjusts the inventory number in the ledger to the actual inventory number. The display control unit 25 displays the inventory number (weight, quantity) that is the calculation result of this adjustment in the display field for post-inventory information in a state in which it cannot be changed by the operator.
[0070] Next, the operator specifies the update of the inventory quantity of the warehouse (the first consumer yard warehouse or the second consumer yard warehouse, etc.) adjusted via the inventory input screen via the inventory update screen exemplified in FIG. 16(a). As a result, the data generation unit 23 generates post-inventory inventory data updated to the adjusted inventory quantity based on the above-mentioned difference number (=adjustment number), as shown in FIG. 16(b). The memory control unit 26 stores this post-inventory inventory data in the memory unit 2.
[0071] Next, the data generating unit 23 generates inventory report data corresponding to the inventory report for each customer based on the post-inventory data. This inventory report data includes information on the system ledger inventory quantity, adjustment quantity, and inventory result quantity for each product, as well as the accounting year and month, inventory date, and destination customer name input by the operator.
[0072] The data generating unit 23 inputs the system ledger inventory quantity obtained from the inventory data shown in Fig. 13(a) created by the above-mentioned pre-inventory processing into the inventory report material data. The data generating unit 23 also inputs the adjustment quantity obtained from the inventory quantity adjustment data shown in Fig. 15(a) into the inventory report material data. The data generating unit 23 also inputs the inventory result quantity obtained from the inventory data after inventory processing shown in Fig. 16(b) into the inventory report material data.
[0073] This inventory report material data is sent by the output control unit 24 to the customer terminal device 52 of the corresponding customer, or printed via the output device 7, which corresponds to a printing device, and mailed to the corresponding customer.
[0074] (Stock inquiry operation) Next, in the case of the inventory management device of the embodiment, manufacturer yards are assigned to and managed by each customer yard warehouse, making it possible to quickly and accurately inquire about the inventory of a specified customer yard warehouse based on the inventory data.
[0075] In this case, the operator displays the inventory inquiry screen shown in Fig. 18, and inputs the date, the warehouse code of the warehouse being inquired, and the customer code (= consumer or delivery destination). The display control unit 25 refers to the inventory data shown in Fig. 19, for example, and displays the inventory data corresponding to the input warehouse code and customer code in the details display column of the inventory inquiry screen, as shown in Fig. 18. The example in Fig. 18 is an example in which the inventory of "XX Steelworks" stored in the first consumer yard warehouse is inquired.
[0076] Conventionally, inventory management at manufacturer yards for each customer was done using spreadsheet software. However, when using spreadsheet software, the manufacturer would process the movement or shipment of products, which caused the inconvenience of errors in inventory management. Such inventory management errors resulted in the inventory not being secured for the customer, which meant that shipments could not be made, resulting in the inconvenience of complaints from the customer.
[0077] However, the inventory management device 1 of the embodiment can manage inventory at manufacturer yards for each customer in the system, and can manage the secured inventory for each customer in the system, which can improve the problems that have occurred in shipping operations in the past. This can prevent the inconvenience of complaints from customers.
[0078] Furthermore, when a customer requests an inventory report for the manufacturer's yard, in the past, because it was difficult to perform inventory management using a system, documents were created using spreadsheet software. However, with the inventory management device 1 of the embodiment, the manufacturer's yard inventory for one customer can be managed as one warehouse, so inventory processing can be performed in the same format as in the company's own warehouse. This makes it possible to shorten the work time for routine tasks (inventory processing, etc.) that occur periodically.
[0079] In addition, because inventory can be managed by customer, the inventory of other companies' assets can be identified on the management accounting balance sheet. This makes it possible to grasp future liabilities and prevent the inconvenience of excess inventory.
[0080] (Journal entry collaboration operation) Next, the inventory management device 1 of the embodiment generates accounting data of the inventory amounts of the first consumer yard warehouse and the second consumer yard warehouse set in the manufacturer yard based on the inventory data, and can link with the accounting system 61. This makes it possible to output and confirm the inventory amounts of the consumer yards, for example, as shown in FIG. 20, on a management form.
[0081] Specifically, when performing journal entry linkage, the operator operates the input device 6 to specify display of a journal entry linkage screen. As a result, the display control unit 25 displays the journal entry linkage screen illustrated in Fig. 21 via the output device 7. The operator inputs the accounting year and month into this journal entry linkage screen, and also inputs the target date corresponding to the accounting period.
[0082] The data generation unit 23 refers to the journal entry linkage conversion master 14 shown in Figure 5 and recognizes the debit account item, debit account item name, source of amount, source of accounting client code, and warehouse for which journal entry data is to be created that are specified to be used when generating journal entry data.
[0083] The example of the journal entry linkage conversion master 14 shown in Fig. 5 is an example in which "7053" is specified as the debit account item of the journal entry data to be created, "Yard end of month warehouse" is specified as the debit account item name, and "Inventory amount of inventory data" is specified as the source of the amount. Also, the example of the journal entry linkage conversion master 14 shown in Fig. 5 is an example in which the delivery destination code (= consumer code (company)) stored in the warehouse master 11 shown in Fig. 2 is specified as the source of the accounting customer code, and journal entry data is to be created for those whose consumer management flag in the warehouse master 11 in Fig. 2 is set to "1: managed."
[0084] As shown in Fig. 19, the data generation unit 23 acquires inventory data of customers and warehouses specified by the accounting link conversion master 14 and the warehouse master 11. Then, as shown in Fig. 22, based on the acquired inventory data, it generates accounting data indicating the inventory amount of each customer yard warehouse.
[0085] As an example, the journal data has input items of the recording date, account code, item name, accounting customer code, accounting customer name, and recording amount. In this example, the data generation unit 23 inputs "March 31, 2023" as the recording date, and inputs "7053" specified in the journal entry linkage conversion master 14 as the account code. The data generation unit 23 also inputs "Yard end of month warehouse" specified in the journal entry linkage conversion master 14 as the item name, and inputs "customer code (company)" such as "TOK001" or "TOK005" registered in the warehouse master 11 as the accounting customer code.
[0086] In addition, the data generation unit 23 inputs the name of the customer of the first customer's yard warehouse, such as "XX Steel Works" or "XX Factory," or the name of the customer of the second customer's yard warehouse, as the accounting customer name.
[0087] In addition, the data generation unit 23 inputs the total inventory amount of the same warehouse code shown in FIG. 19 as the recorded amount. For example, in the case of the first consumer yard warehouse "C001", the total inventory amount is "118,630 yen". Therefore, the data generation unit 23 inputs "118,630 yen" as the recorded amount of the consumer of the first consumer yard warehouse "C001" into the journal data. Similarly, in the case of the second consumer yard warehouse "C002" shown in FIG. 19, the total inventory amount is "174,380 yen". Therefore, the data generation unit 23 inputs "174,380 yen" as the recorded amount of the consumer of the second consumer yard warehouse "C002" into the journal data.
[0088] When the journal data is generated in this manner, the storage control unit 26 controls the storage of the generated journal data in the storage unit 2. In addition, the output control unit 24 transmits the generated journal data to the accounting system 61 of the accounting server device 60 or the accounting system 61 of the storage unit 2 for recording.
[0089] (Effects of the embodiment) As is clear from the above description, the inventory management device 1 of the embodiment can manage other companies' assets stored in the manufacturer's yard separately from the company's own assets. This can prevent inconveniences such as difficulty in securing inventory for customers due to missed maintenance, and can prevent missed shipments.
[0090] In addition, the system can manage inventory at manufacturer yards for each customer, and can manage the secured inventory for each customer, which improves the problems that previously occurred in shipping operations. This prevents the inconvenience of complaints from customers.
[0091] In addition, because the inventory of one customer's manufacturer yard can be managed as one warehouse, inventory processing can be carried out in the same format as in the company's own warehouse, which can reduce the time required for routine tasks that occur periodically (inventory processing, etc.).
[0092] In addition, because inventory can be managed by customer, the inventory of other companies' assets can be identified on the management accounting balance sheet. This makes it possible to grasp future liabilities and prevent the inconvenience of excess inventory.
[0093] [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, and can therefore contribute to Goals 8 and 9 of the SDGs.
[0094] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of Goals 12, 13, and 15 of the SDGs.
[0095] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0096] [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.
[0097] 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.
[0098] 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.
[0099] Furthermore, with regard to the inventory management device 1, the components shown in the figures are merely conceptual functional components, and the device does not necessarily have to be physically configured as shown in the figures.
[0100] For example, the processing functions of the inventory management device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory management device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processing is recorded in a storage unit such as a ROM or HDD. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.
[0101] In addition, the inventory management program of this inventory management device 1 may be stored in another server device connected to the inventory management device 1 via any network, and it is also possible to download all or part of it as needed.
[0102] In addition, the inventory management 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 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.
[0103] 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 works with a separate program, such as an OS, to achieve its function. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the inventory management device 1 shown in the embodiment, as well as the installation procedure after reading.
[0104] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.
[0105] The inventory management device 1 may be configured as an information processing device such as a known personal computer device or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.
[0106] 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. [Industrial Applicability]
[0107] The present invention is suitable for application to inventory management in the steel industry, for example, where yard inventory is operated. [Explanation of symbols]
[0108] 1. Inventory management device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Warehouse Master 12 Customer delivery destination code conversion master 13 Customer-specific product code conversion master 14 Journal entry conversion master 21 Acquisition Department 22 Warehouse Allocation by Delivery Destination 23 Data Generation Division 24 Output control section 25 Display control section 26 Memory control unit 50 Network 51 Manufacturer terminal device 52 Customer terminal equipment 60 Accounting server device 61 Accounting System
Claims
1. an acquisition unit that acquires inventory information including the number of products stored in the manufacturer's warehouse, delivery destination information indicating the delivery destination of the products that have been stored, and generated product specification information for the products, which is notified when the products manufactured by the manufacturer are stored in the manufacturer's warehouse; a destination-specific warehouse allocation unit that generates warehouse identification information in which a storage location of the product for each destination in the manufacturer's warehouse is allocated as a storage warehouse for the product for each destination based on the destination identification information included in the acquired warehousing information; a data generating unit that generates inventory information including the warehouse identification information indicating a storage warehouse of each of the delivery destinations, product identification information of the products stored in the storage warehouse of each of the delivery destinations, and inventory numbers; an output control unit that outputs the generated inventory information; An inventory management device having the following:
2. The acquisition unit acquires inventory information including the number of the stored products, delivery destination identification information indicating the delivery destination of the stored products, and product identification information of the stored products, which is transmitted when the products are further manufactured by the manufacturer and stored in a storage warehouse for the products for the delivery destination, and a storage control unit that, when the warehousing information is further acquired, updates the inventory information by adding the number of received products of the stored products, which is included in the warehousing information, to the number of stocks at a delivery destination, which is indicated by the delivery destination identification information of the warehousing information, among delivery destinations of the storage warehouse, which is indicated by the warehouse identification information included in the inventory information; 2. The inventory management device according to claim 1,
3. The acquisition unit acquires shipping information including a shipment quantity of the shipped products, product identification information of the shipped products, and delivery destination identification information indicating a delivery destination of the shipped products, the shipping information being transmitted when the manufacturer ships the products to the delivery destination; when the shipping information is acquired, the storage control unit updates the inventory quantity of the inventory information to an inventory quantity obtained by subtracting the shipping quantity of the shipped item from the inventory quantity of the delivery destination to which the item is shipped; 3. The inventory management device according to claim 2, wherein:
4. when a difference between the actual stock quantity of the product confirmed by performing an inventory and the stock quantity of the product indicated in the inventory information at the time of the inventory is input, the storage control unit adjusts the stock quantity of the inventory information by adding or subtracting the input difference to the stock quantity indicated in the inventory information at the time of the inventory; The data generation unit generates inventory quantity report data including the adjusted inventory quantity, The output control unit outputs the inventory quantity report data.
4. The inventory management device according to claim 3,
5. The data generation unit Refer to a storage unit that stores at least account title name designation information that designates an account title name, amount designation information that designates an inventory amount as an amount to be used for accounting among amounts included in the inventory information, and creation conditions for identifying inventory information to be used for creating accounting data among the inventory information; generating accounting data including the account name specified by the account name specification information, the inventory amount specified by the amount specification information, and the business partner based on the inventory information specified by the creation conditions out of the inventory information; The output control unit outputs the accounting data.
5. The inventory management device according to claim 4,
6. An acquisition step in which an acquisition unit acquires inventory information including the number of products stored in the manufacturer's warehouse, which is notified when the products manufactured by the manufacturer are stored in the manufacturer's warehouse, delivery destination identification information indicating the delivery destination of the received products, and the generated product identification information of the products; a destination-specific warehouse allocation step in which a destination-specific warehouse allocation unit generates warehouse identification information in which a storage location of the product for each destination in the manufacturer's warehouse is allocated as a storage warehouse for the product for each destination based on the destination identification information included in the acquired warehousing information; a data generating step of generating inventory information including the warehouse identification information indicating a storage warehouse of each of the delivery destinations, product identification information of the products stored in the storage warehouse of each of the delivery destinations, and a stock quantity by a data generating unit; an output control step in which an output control unit outputs the generated inventory information; An inventory control method having the following features.
7. Computer, an acquisition unit that acquires inventory information including the number of products stored in the manufacturer's warehouse, delivery destination information indicating the delivery destination of the products that have been stored, and generated product specification information for the products, which is notified when the products manufactured by the manufacturer are stored in the manufacturer's warehouse; a destination-specific warehouse allocation unit that generates warehouse identification information in which a storage location of the product for each destination in the manufacturer's warehouse is allocated as a storage warehouse for the product for each destination based on the destination identification information included in the acquired warehousing information; a data generating unit that generates inventory information including the warehouse identification information indicating a storage warehouse of each of the delivery destinations, product identification information of the products stored in the storage warehouse of each of the delivery destinations, and inventory numbers; functioning as an output control unit that outputs the generated inventory information; An inventory management program that features:
Citation Information
Patent Citations
Physical distribution management device
JP1987027202A
Stock management, system for providing guarantee service for stock amount at delivery destination, and its method
JP2004338926A
Scheduling support system, scheduling support method, and scheduling support program
JP2011159230A
Product storage place management method
JP2021157397A
