Inventory management device, inventory management method, and inventory management program

Abstract

To provide a stock management device capable of easily managing a remaining quantity of deposit stocks for each deposit date when products purchased by a customer are kept as the deposit stocks.SOLUTION: A stock management device of this embodiment includes: sales input means for creating sales data including sales identification information, the sales date, a customer, a warehouse, products, a sales quantity, a unit price, and a monetary amount in response to an operation by an operator on a sales input screen, and for registering it in a memory area; and deposit stock management means for creating deposit stock data including the warehouse, the customer, the sales identification information, the products, and a deposit stock quantity that is equal to the sales quantity based on the sales data, and for registering it in the memory area.SELECTED DRAWING: Figure 1

Description

Technical Field

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

Background Art

[0002] For example, in the steel industry, there is a transaction in which a product purchased by a customer is stored as inventory and shipped individually based on a separate shipping instruction from the customer. Conventionally, as a system for managing inventory, there is, for example, Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, Patent Document 1 does not describe anything regarding easily managing the remaining quantity for each storage date of the stored inventory.

[0005] The present invention has been made in view of the above, and an object thereof is to provide an inventory management device, an inventory management method, and an inventory management program capable of easily managing the remaining quantity for each storage date of the stored inventory when a product purchased by a customer is stored as inventory.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides an inventory management device comprising a control unit for managing goods purchased by customers as consigned inventory, wherein the control unit comprises sales input means for creating sales data including sales identification information, sales date, customer, warehouse, product, number of items sold, unit price, and amount in response to operator operations on a sales input screen and registering it in a storage area, and consigned inventory management means for creating consigned inventory data including warehouse, customer, sales identification information, product, and the same number of consigned inventory items as the number of items sold, based on the sales data and registering it in the storage area.

[0007] Furthermore, according to one aspect of the present invention, the control unit may also be provided with inquiry means for extracting consigned inventory data registered in the storage area that corresponds to specified extraction conditions, and outputting the warehouse, customer, product, sales identification information, the consigned date used as the sales date of the sales data linked by the sales identification information, and the number of consigned inventory items as inventory inquiry data.

[0008] Furthermore, according to one aspect of the present invention, the extraction conditions may include a reference date, warehouse, customer, and storage period.

[0009] Furthermore, according to one aspect of the present invention, the control unit may further include a receipt issuing means for issuing a receipt based on the inventory inquiry data.

[0010] Furthermore, according to one aspect of the present invention, the control unit may also be provided with a movement instruction input means that, when shipping consigned inventory, creates movement instruction data including movement instruction identification information, movement instruction date, shipping date, warehouse, customer, delivery destination, sales identification information, product, and number of items to be shipped, in response to the operator's operation on the movement instruction input screen, and registers it in the storage area.

[0011] Furthermore, according to one aspect of the present invention, the control unit may further include a shipping input means that, when consigned inventory is shipped, creates shipping data including shipping identification information, shipping date, movement instruction identification information, warehouse, customer, delivery destination, product, and quantity shipped, in response to the operator's operation on the shipping input screen, and registers it in a storage area, and the consigned inventory management means may update the consigned inventory data based on the created shipping data.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides an inventory management method executed by an information processing device equipped with a control unit, characterized in that it includes: a sales input step, which is performed by the control unit to create sales data including sales identification information, sales date, customer, warehouse, product, number of sales, unit price, and amount, in response to an operator's operation on a sales input screen, and to register it in a storage area; and a consigned inventory management step, which is based on the sales data to create consigned inventory data including warehouse, customer, sales identification information, product, and the same number of consigned inventory as the number of sales, and to register it in the storage area.

[0013] Furthermore, according to one aspect of the present invention, an inventory management program for execution in an information processing device equipped with a control unit is characterized by being an inventory management program for executing the following: a sales input step, which is executed in the control unit, in response to an operator's operation on a sales input screen, to create sales data including sales identification information, sales date, customer, warehouse, product, number of items sold, unit price, and amount, and to register it in a storage area; and a storage inventory management step, which is based on the sales data to create storage inventory data including warehouse, customer, sales identification information, product, and the same number of items in storage inventory as the number of items sold, and to register it in the storage area. [Effects of the Invention]

[0014] According to the present invention, when goods purchased by customers are held as consigned inventory, it becomes possible to easily manage the remaining quantity of consigned inventory on a daily basis. [Brief explanation of the drawing]

[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of the inventory management device according to the present embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the flow of the overall processing of the control unit of the inventory management device according to the present embodiment. [Figure 3] FIG. 3 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 4] FIG. 4 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 5] FIG. 5 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 7] FIG. 7 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 8] FIG. 8 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 9] FIG. 9 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 10] FIG. 10 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. [Figure 11] FIG. 11 is a diagram showing sample data for explaining a specific example of the processing of the control unit of the inventory management device according to the present embodiment. MODE FOR CARRYING OUT THE INVENTION

[0016] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.

[0017] [1. Summary] For example, in the steel industry, there is a transaction where the products purchased by customers are stored as consignment inventory and shipped individually based on separate shipping instructions from the customers.

[0018] However, conventionally, only the consignment inventory quantity was managed separately for each customer and product, and age management of the consignment inventory could not be performed.

[0019] Thus, when inquiring about the remaining quantity of consignment inventory from a customer, since it was only a management of grasping the consignment inventory quantity for each customer and product, long-term consignment items could not be confirmed, and data output of long-term consignment items necessary for controlling costs such as securing storage locations could not be performed.

[0020] Therefore, in this embodiment, in order to easily perform the remaining quantity management for each consignment date (inventory age management of consignment inventory), the consignment inventory is linked with the sales identification information (invoice number) sold as consignment items. Conventionally, the consignment inventory was managed by warehouse, customer, and product, but in this embodiment, the consignment inventory quantity can be managed by warehouse, customer, sales identification information, and product.

[0021] According to this embodiment, by performing the remaining quantity management for each consignment date, it has become possible to prompt attention to the customer for products that have become long-term consignment inventory, and thus it has become possible to control the storage costs that were dependent on the judgment of the business partner. In addition, by making it possible to manage the consignment inventory by sales identification information and being able to issue a consignment certificate based on that, it has become possible to conduct a detailed inventory confirmation with the customer.

[0022] The inventory management device of this embodiment can be widely applied when a customer stores the purchased products as consignment inventory. For example, it can be suitably applied in business formats where the customer does not have a warehouse (such as trading companies, etc.). In the following example, the case of dealing with steel as a product will be described, but the present invention is not limited to this and can also be applied to other products such as food.

[0023] [2. Structure] An example of the configuration of the inventory management device according to this embodiment will be described with reference to Figure 1. Figure 1 is a block diagram showing an example of the configuration of the inventory management device according to this embodiment.

[0024] The inventory management device 100 is a commercially available desktop personal computer. However, the inventory management device 100 is not limited to stationary information processing devices such as desktop personal computers; it may also be a portable information processing device such as a commercially available notebook computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0025] The inventory management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the inventory management device 100 is connected to communicate via any communication path.

[0026] The communication interface unit 104 connects the inventory management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has the function of communicating data with other devices via a communication line. Here, the network 300 has the function of connecting the inventory management device 100 and the server 200 so that they can communicate with each other, and is, for example, the internet or a LAN (Local Area Network).

[0027] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. 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 mouse 112.

[0028] The memory unit (storage area) 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, 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.

[0029] The memory unit 106 also stores sales data, consigned inventory data, transfer instruction data, shipping data, and the like.

[0030] Sales data may include sales identification information (sales number-row), sales category (e.g., 40: consignment sales, 41: regular sales), sales date, customer (identification information) (customer code and / or customer name), warehouse (identification information) (warehouse code and / or warehouse name), product identification information (product code and / or product name), quantity sold, unit price, and amount.

[0031] The consigned inventory data may include warehouse (identification information) (warehouse code and / or warehouse name), customer (identification information) (customer code and warehouse name), sales identification information (sales number - row), product identification information (product code and / or product name), and the quantity of consigned inventory. Sales data and consigned inventory data are linked by the sales identification information (sales number - row). The quantity of consigned inventory is the same as the number of sales.

[0032] Inventory inquiry data may include warehouse (identification information) (warehouse code and / or warehouse name), customer (identification information) (customer code and / or customer name), product (identification information) (product code and / or product name), sales identification information (sales number - row), storage date, and storage inventory quantity. The storage date shall be the same as the sales date in the sales data. Specifically, the sales date is obtained from the sales data using the sales identification information (sales number - row) as the key and set as the storage date.

[0033] The movement instruction data may include movement instruction identification information (movement instruction number-row), movement instruction date, shipping date, movement category (e.g., 50: consigned goods shipping instruction, 51: regular shipping instruction), warehouse (identification information) (warehouse code and / or warehouse name), customer (identification information) (customer code and / or customer name), delivery destination (identification information) (delivery destination code and / or delivery destination name), sales identification information (sales number-row), product (identification information) (product code and / or product name), and the number of items to be shipped. The movement instruction data is linked to the consigned inventory data using the sales identification information (sales number-row).

[0034] Shipping data may include shipping identification number (shipping number-line), shipping category (e.g., 17: consigned goods shipping, 18: regular shipping), shipping date, movement instruction identification information (movement instruction number-line), warehouse (identification information) (warehouse code and / or warehouse name), customer (identification information) (customer code and / or customer name), delivery destination (identification information) (delivery destination code and / or delivery destination name), product (identification information) (product code and / or product name), and quantity shipped. Shipping data is linked to movement instruction data by movement instruction identification information (movement instruction number-line).

[0035] Furthermore, the memory unit 106 registers customer codes and customer names, delivery destination codes and delivery destination names, warehouse codes and warehouse names, product codes and product names, etc., and includes a code-name conversion table (not shown) that the control unit 102 uses to display the names corresponding to the codes on the input screen, etc.

[0036] The control unit 102 is a CPU or similar component that comprehensively controls the inventory management device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0037] The control unit 102 is configured to access sales data, consigned inventory data, movement instruction data, shipping data, and tables (not shown) stored in the storage unit 106. Note that the sales data, consigned inventory data, movement instruction data, shipping data, and tables (not shown) may be located elsewhere (for example, on the server 200), as long as the control unit 102 can access them.

[0038] Functionally, the control unit 102 comprises a sales input unit 102a, a consigned inventory management unit 102b, an inventory inquiry unit 102c, a consigned receipt issuance unit 102d, a movement instruction input unit 102e, a shipping input unit 102f, and a screen display control unit 102g.

[0039] The sales input unit 102a creates sales data, including sales identification information, sales date, customer, warehouse, product, quantity sold, unit price, and amount, in response to the operator's operation on the sales input screen displayed on the monitor 114, for example, and registers it in the storage unit 106.

[0040] The consigned inventory management unit 102b creates consigned inventory data based on sales data, including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the number of items sold, and registers it in the storage unit 106. The consigned inventory management unit 102b also updates the consigned inventory data based on the created shipping data.

[0041] The inventory inquiry unit 102c extracts the consigned inventory data registered in the storage unit 106 that matches the specified extraction conditions, for example, in response to the operator's operation on the inventory inquiry screen displayed on the monitor 114, and displays and outputs inventory inquiry data including the warehouse, customer, product, sales identification information, the consigned date used as the sales date for the sales data linked by the sales identification information, and the number of consigned inventory items.

[0042] In this case, the extraction criteria may include the reference date, warehouse, customer, and storage period.

[0043] The receipt issuance unit 102d issues receipts based on inventory inquiry data in accordance with the operator's instructions.

[0044] When shipping consigned inventory, the movement instruction input unit 102e creates movement instruction data, including movement instruction identification information, movement instruction date, shipping date, warehouse, customer, delivery destination, sales identification information, product, and number of items to be shipped, in response to the operator's operation on the movement instruction input screen displayed on the monitor 114, and registers it in the storage unit 106.

[0045] When consigned inventory is shipped, the shipping input unit 102f creates shipping data, including shipping identification information, shipping date, movement instruction identification information, warehouse, customer, delivery destination, product, and quantity shipped, in response to, for example, the operator's operation on the shipping input screen, and registers it in the storage unit 106.

[0046] The screen display control unit 102g controls the display and input of various screens (for example, sales input screen, inventory inquiry screen, movement instruction input screen, shipping input screen, etc.) displayed on the monitor 114.

[0047] [3. Specific examples] A specific example of the processing of the inventory management device 100 in this embodiment will be described with reference to Figures 1 to 11.

[0048] (3-1. Overall Processing) Referring to Figure 2, an example of the overall processing of the control unit of the inventory management device 100 in this embodiment will be described. Figure 2 is a diagram illustrating an example of the overall processing of the control unit of the inventory management device 100 in this embodiment.

[0049] The sales input unit 102a executes the sales input process (step S1). Specifically, in the sales input process, the sales input unit 102a creates sales data including sales identification information, sales date, customer, warehouse, product, number of items sold, unit price, and amount, based on the operator's operation on the sales input screen displayed on the monitor 114, and registers it in the storage unit 106. The consigned inventory management unit 102b also creates consigned inventory data based on the sales data, including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the number of items sold, and registers it in the storage unit 106.

[0050] The inventory inquiry unit 102c executes the inventory inquiry process (step S2). The inventory inquiry process can be executed at any time. Specifically, in the inventory inquiry process, the inventory inquiry unit 102c extracts the consigned inventory data registered in the storage unit 106 that matches the specified extraction conditions, for example, in response to the operator's operation on the inventory inquiry screen displayed on the monitor 114, and displays and outputs inventory inquiry data including the warehouse, customer, product, sales identification information, the consigned date used as the sales date of the sales data linked by the sales identification information, and the number of consigned inventory items. The consigned receipt issuance unit 102d issues a consigned receipt based on the inventory inquiry data according to the operator's instructions.

[0051] The movement instruction input unit 102e executes the movement instruction input process (step S3). Specifically, in the movement instruction input process, when consigned inventory is shipped, the movement instruction input unit 102e creates movement instruction data including movement instruction identification information, movement instruction date, shipping date, warehouse, customer, delivery destination, sales identification information, product, and number of items to be shipped, in response to the operator's operation on the movement instruction input screen displayed on the monitor 114, and registers it in the storage unit 106.

[0052] The shipping input unit 102f executes the shipping input process (step S4). Specifically, in the shipping input process, when consigned inventory is shipped, the shipping input unit 102f creates shipping data including shipping identification information, shipping date, movement instruction identification information, warehouse, customer, delivery destination, product, and quantity shipped, in response to, for example, the operator's operation on the shipping input screen, and registers it in the storage unit 106. The consigned inventory management unit 102b also updates the consigned inventory data stored in the storage unit 106 based on the created shipping data.

[0053] (3-2. Sample Data) Figures 3 to 11 are diagrams showing sample data to illustrate a specific example of the processing performed by the control unit 102 of the inventory management device 100 according to this embodiment. Referring to Figures 3 to 11, a specific example of the processing performed by the control unit 102 of the inventory management device 100 according to this embodiment will be explained. In the following explanation, all monetary units will be expressed in "yen".

[0054] (S1: Sales entry processing) A specific example of the sales input process will be explained with reference to Figures 3 and 4. The sales input unit 102a creates sales data, including sales identification information (sales number-line), sales date, customer, warehouse, product, quantity sold, unit price, and amount, in response to the operator's operation on the sales input screen displayed on the monitor 114, and registers it in the storage unit 106. The consigned inventory management unit 102b also creates consigned inventory data, including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the quantity sold, based on the sales data, and registers it in the storage unit 106.

[0055] Figure 3 shows an example of the display of the sales entry screen 400. (1) In the case of consigned goods, the sales category at the time of sales entry on the sales entry screen 400 is set to "Consigned Sales" and sales data is created. (2) When the sales category is "Consigned Sales", consigned inventory data is created based on the sales number-row, product code, quantity, and warehouse code of the sales data.

[0056] The sales entry screen 400 includes a header area 401 for specifying the sales category (for example, 40: consignment sales, 10: regular sales), sales date, customer code, and warehouse code; a detail area 402 for specifying the product code, quantity, unit price, and amount for each row; and a registration button (not shown).

[0057] When the operator enters data on the sales entry screen 400 and presses the registration button (not shown), sales data corresponding to the input on the sales entry screen 400 is created and registered in the storage unit 106. In addition, if the sales category of the sales data is "40: Sales on consignment," inventory data on consignment corresponding to the sales data is created and registered in the storage unit 106.

[0058] In the example shown in Figure 3, the header area 401 contains the sales category "40 Consignment Sales", sales date "2022 / 11 / 28", customer code "A1445: ○○○○ Electric Materials Co., Ltd.", and warehouse code "123456: Head Office Warehouse". In the detail area 402, row 1 contains the product code "VVM4476: VVM Cable", quantity "3,200 m", unit price "210", and amount "672,000", and row 2 contains the product code "AA14234: Coaxial Cable", quantity "2,600 m", unit price "120", and amount "312,000".

[0059] When the registration button (not shown) is pressed, sales data as shown in Figure 4(A) is created and registered in the storage unit 106. The sales data includes the following fields: sales number-row, sales date, customer code, warehouse code, product code, quantity sold, unit price, and amount. The sales number is automatically assigned when the registration button is pressed.

[0060] Based on the sales data, consigned inventory data as shown in Figure 4(B) is created and registered in the storage unit 106. The consigned inventory data includes the fields for warehouse code, customer code, sales number-line, product code, and consigned inventory quantity. The "consigned inventory quantity" is set to the sales quantity from the sales data. The sales number-line links the sales data and the consigned inventory data.

[0061] (S2: Inventory inquiry process) A specific example of the inventory inquiry process will be explained with reference to Figures 5 and 6. The inventory inquiry unit 102c extracts the consigned inventory data registered in the storage unit 106 that matches the specified extraction conditions, in response to the operator's operation on the inventory inquiry screen displayed on the monitor 114, and displays and outputs inventory inquiry data including the warehouse, customer, product, sales identification information, the consigned date used as the sales date of the sales data linked to the sales identification information, and the number of consigned inventory items. The consigned receipt issuance unit 102d issues a consigned receipt based on the inventory inquiry data according to the operator's instructions.

[0062] (3) The inventory of consigned items can be checked through the inventory inquiry. At that time, the inventory of consigned items can be checked by the associated sales number-line and consigned date (the sales date is treated as the consigned date).

[0063] The inventory inquiry screen (not shown) includes an extraction criteria setting area, an execution button (not shown), and a receipt issuance button (not shown). In the extraction criteria setting area, you specify the extraction criteria for items such as the reference date, warehouse code, customer code, and storage period. If no criteria are specified, all criteria are selected. When the unillustrated execute button is pressed, data matching the specified extraction criteria is extracted from the held inventory data, and the inventory inquiry data is displayed and output. Furthermore, when the unillustrated receipt issuance button is pressed, a receipt is issued based on the inventory inquiry data.

[0064] Figure 5(A) shows an example of specified extraction conditions. In the example shown in the figure, the reference date is "2022 / 12 / 16", the warehouse code is "123456: Head Office Warehouse", the customer code is "A1445: ○○○○ Electric Materials Co., Ltd.", and the storage period is "Not specified". When the execution button (not shown) is pressed, the consigned inventory data stored in the memory unit 106 that matches the extraction conditions is extracted, and inventory inquiry data such as that shown in Figure 5(B) is displayed and output.

[0065] The inventory inquiry data includes fields for warehouse code, customer code, product code, sales number-line, storage date, and storage inventory quantity. The "storage date" is set to the sales date extracted from the sales data stored in the storage unit 106 using the sales number-line as the key. In the figure, the first and second lines correspond to the storage inventory data created from past storage sales (storage inventory data created before Figure 4(B) and is not shown in the illustration). The third and fourth lines correspond to the storage inventory data in Figure 4(B).

[0066] When the unillustrated receipt issuance button is pressed, a receipt is output based on the inventory inquiry data, for example, as shown in Figure 5(C). The receipt includes a header listing the customer, and details including the receipt date, the receipt number (sales number-line), the product, and the inventory quantity. The receipt is sent to the customer via email, fax, mail, etc.

[0067] The inventory inquiry screen allows users to access information on long-term consigned items. Figure 6(A) shows an example of the specified extraction conditions. In the example shown, the reference date is "2022 / 12 / 16", the warehouse code is "123456: Head Office Warehouse", the customer code is "A1445: ○○○○ Electric Materials Co., Ltd.", and the storage period is "12" months or more. When the execution button (not shown) is pressed, the consigned inventory data stored in the memory unit 106 that matches the extraction conditions is extracted, and inventory inquiry data with a storage period of 12 months or more, as shown in Figure 6(B), is displayed and output.

[0068] (S3: Movement instruction input processing) A specific example of the movement instruction input process will be explained with reference to Figures 7 to 9. When shipping consigned inventory, the movement instruction input unit 102e creates movement instruction data, including movement instruction identification information (movement instruction number-line), movement instruction date, shipping date, warehouse, customer, delivery destination, sales identification information, product, and shipping instruction quantity, in response to the operator's operation on the movement instruction input screen displayed on the monitor 114, and registers it in the storage unit 106.

[0069] Figure 7 shows an example of the display of the movement instruction input screen 500. (4) When shipping consigned goods, specify "Consigned Goods Shipping Instruction" as the movement instruction category on the movement instruction input screen 500.

[0070] The movement instruction input screen 500 includes a header area 501 for specifying the movement instruction category, movement instruction date, shipping date, warehouse code, customer code, delivery destination code, etc., a detail area 502 for specifying the (consigned) sales number-line, product code, and quantity for each line, a registration button (not shown), and a search screen display button (not shown). When the registration button (not shown) is pressed, movement instruction data corresponding to the input content on the movement instruction input screen 500 is created and registered in the storage unit 106.

[0071] When the search screen display button (not shown) is pressed, a search screen 600 for the received sales number, as shown in Figure 8, is displayed. This search screen is intended to assist in inputting the item to be moved (sales number - row) and its quantity in the detail area 502 of the move instruction input screen 500. By viewing the results on the search screen and inputting the item to be moved (sales number - row) and its quantity in the detail area 502, the operator can easily specify the item to be moved and its quantity.

[0072] The 600 search screen for consigned sales numbers includes an extraction criteria specification area for specifying extraction conditions for warehouse code, product code, and customer code; an extraction results display area where consigned inventory data matching the extraction criteria is extracted and displayed; and a display button. When extraction criteria are specified and the display button is pressed, consigned inventory data matching the extraction criteria is extracted and displayed in the extraction results display area.

[0073] In the extraction criteria specification area, the "warehouse code" and "customer code" for the extraction criteria are automatically set based on the information from the movement instruction input screen 500 that called the search screen. The operator specifies the product code. In the extraction results display area, the consigned inventory data that matches the extraction criteria is displayed in chronological order, from oldest to newest.

[0074] Returning to Figure 7, on the movement instruction input screen 500, the product code is automatically displayed when the (consigned) sales number is specified. Furthermore, if the customer code for the consigned sales does not match the customer code on the movement instruction input screen, an error is generated (input error prevention function). The system also prevents inputting quantities exceeding the number of consigned items in stock.

[0075] In the example shown in Figure 7, the header area 501 specifies the movement instruction category "50 Shipment instruction for consigned goods", the movement instruction date "2022 / 12 / 05", the shipment date "2022 / 12 / 06", the warehouse code "123456 Head office warehouse", the customer code "A1445 ○○○○ Electrical Materials Co., Ltd.", and the delivery destination code "A1445-05 ○○○○ Electrical Materials Co., Ltd. △△ Branch". In the details area 502, the first line specifies (consigned) sales number - line "UR0001000051-01", product code "VVM4476 VVM cable (automatic display)", quantity "250" m, and the second line specifies (consigned) sales number - line "UR0001002536-02", product code "VVM4476: VVM cable", quantity "400" m.

[0076] When the registration button (not shown) is pressed, for example, movement instruction data as shown in Figure 9 is created and registered in the storage unit 106. The movement instruction data includes the following items: movement instruction number-line, movement instruction date, shipping date, movement category, warehouse code, customer code, delivery destination code, (consigned) sales number-line, product code, and shipping instruction quantity. The "movement instruction number" is automatically assigned when the registration button is pressed.

[0077] (S4: Shipping Input Processing) A specific example of the shipping input process will be explained with reference to Figures 10 and 11. When consigned inventory is shipped, the shipping input unit 102f creates shipping data including shipping identification information (shipping number-line), shipping date, movement instruction identification information, warehouse, customer, delivery destination, product, and quantity shipped, in response to, for example, the operator's operation on the shipping input screen, and registers it in the storage unit 106. In addition, the consigned inventory management unit 102b updates the consigned inventory data stored in the storage unit 106 based on the created shipping data.

[0078] Figure 10 shows an example of the display of the shipping input screen 700. (5) When a shipment is made for the registered movement instruction data, the inventory of the consigned items in the consigned inventory data linked to the sales number-row registered in the movement instruction data is debited. The shipping input screen 700 has a header area 701 for specifying the movement instruction number, shipping date, warehouse code, head office warehouse, shipping category, customer code, and delivery destination code, and a detail area 702 for specifying the (consigned) sales number-row, product code, instruction quantity, and shipping quantity for each row, as well as a registration button (not shown). When the registration button (not shown) is pressed, shipping data corresponding to the input content on the shipping input screen 700 is created and registered in the storage unit 106.

[0079] When the operator specifies the "movement instruction number" and "shipping date," the movement instruction data stored in the memory unit 106 is read using the specified movement instruction number and shipping date as keys, and the "warehouse code," "head office warehouse," "shipping category," "customer code," "delivery destination code," "(consigned) sales number - line," "product code," and "instructed quantity" are automatically displayed (specified). The operator then specifies the "number of items to be shipped."

[0080] In the example shown in Figure 10, the header area 701 specifies the movement instruction number "IS0000123456", the shipping date "2022 / 12 / 06", the warehouse code "123456: Head Office Warehouse", the shipping category "17: Consigned Goods Shipping", the customer code "A1445: ○○○○ Electric Materials Co., Ltd.", and the delivery destination code "A1445-05: ○○○○ Electric Materials Co., Ltd. △△ Branch". In detail area 702, the first line specifies: (Receipt) Sales Number - Line "UR0001000051-01", Product Code "VVM4476:VVM Cable", Instructed Quantity "250"m, Shipment Quantity "250"m; and the second line specifies: (Receipt) Sales Number - Line "UR0001002536-02", Product Code "VVM4476:VVM Cable", Instructed Quantity "400"m, Shipment Quantity "400"m.

[0081] When the registration button (not shown) is pressed, for example, movement instruction data as shown in Figure 11(A) is created and registered in the storage unit 106. The movement instruction data includes the following items: shipment number-line, shipment category, shipment date, movement instruction number-line, warehouse code, customer code, delivery destination code, product code, and shipment quantity. The "shipment number" is automatically assigned when the registration button is pressed.

[0082] When shipping data is created, the consigned inventory data is updated based on the shipping data, as shown in Figure 11(C). Specifically, the number of consigned inventory items in the inventory inquiry data that has a sales number-row linked to the movement instruction number-row of the shipping data is reduced by the number of shipments. In the example shown in the figure, the number of consigned inventory items for the first sales number-row "UR0001000051-01" is updated from "250" to "0 (=250-250)". Also, the number of consigned inventory items for the second sales number-row "UR0001002536-02" is updated from "1200" to "800 (=1200-400)".

[0083] As described above, according to this embodiment, the system includes a sales input unit 102a that creates sales data including sales identification information, sales date, customer, warehouse, product, number of items sold, unit price, and amount in response to the operator's operation on the sales input screen and registers it in the storage area, and a consigned inventory management unit 102b that creates consigned inventory data including warehouse, customer, sales identification information, product, and the same number of consigned inventory items as the number of items sold, based on the sales data and registers it in the storage unit 106. Therefore, when goods purchased by a customer are held as consigned inventory, it becomes possible to easily manage the remaining quantity of consigned inventory on a daily basis.

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

[0085] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0086] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0087] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0088] 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 by known methods.

[0089] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0090] Furthermore, with respect to the inventory management device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0091] For example, the processing functions of the inventory management device 100, particularly those performed in the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory management device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0092] Furthermore, this computer program may be stored on an application program server connected to the inventory management device 100 via any network, and it is possible to download all or part of it as needed.

[0093] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0094] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0095] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0096] Furthermore, the inventory management device 100 may be configured as an information processing device such as a known personal computer or workstation, or as an information processing device to which any peripheral devices are connected. Alternatively, the inventory management device 100 may be implemented by installing software (including programs or data, etc.) on the device that enables the processing described in this embodiment.

[0097] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]

[0098] 100 Inventory Management Devices 102 Control Unit 102a Sales Input Section 102b Inventory Management Department 102c Inventory Inquiry Department 102d Receipt Issuance Department 102e Movement instruction input unit 102f Shipping Input Section 102g Screen Display Control Unit 104 Communication Interface Section 106 Storage section 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. An inventory management device equipped with a control unit for managing goods purchased by customers as consigned inventory, The control unit, A sales input means that, in response to the operator's actions on the sales input screen, creates sales data including sales identification information, sales date, customer, warehouse, product, quantity sold, unit price, and amount, and registers it in a storage area. A consigned inventory management means creates consigned inventory data, including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the number of sales, based on the aforementioned sales data, and registers it in the aforementioned storage area. An inventory management device characterized by being equipped with the following features.

2. The control unit further, The inventory management device according to claim 1, characterized in that it includes an inquiry means for extracting consigned inventory data registered in the storage area that matches the specified extraction conditions, and outputting the warehouse, customer, product, sales identification information, the consigned date used as the sales date for the sales data linked by the sales identification information, and the number of consigned inventory items as inventory inquiry data.

3. The inventory management device according to claim 2, characterized in that the extraction conditions include a reference date indicating the end date of the storage period for the inventory to be extracted as inventory inquiry data, a warehouse, a customer, and a storage period.

4. The control unit further, The inventory management device according to claim 2, further comprising a receipt issuing means for generating receipt data for issuing a receipt that includes the customer, the date of receipt, a receipt number corresponding to the sales identification information, the product name, and the quantity of inventory corresponding to the quantity of inventory received, based on the inventory inquiry data.

5. The control unit further, The inventory management device according to any one of claims 1 to 4, characterized in that when shipping consigned inventory, it is equipped with a movement instruction input means that creates movement instruction data including movement instruction identification information, movement instruction date, shipping date, warehouse, customer, delivery destination, sales identification information, product, and number of items to be shipped, in accordance with the operator's operation on the movement instruction input screen, and registers this data in a storage area.

6. The control unit further, The system includes a shipping input means that, when consigned inventory is shipped, creates shipping data including shipping identification information, shipping date, movement instruction identification information, warehouse, customer, delivery destination, product, and quantity shipped, in accordance with the operator's operation on the shipping input screen, and registers it in the storage area. The inventory management device according to claim 5, characterized in that the consigned inventory management means updates the consigned inventory data based on the created shipping data.

7. An inventory management method performed by an information processing device equipped with a control unit, The control unit is executed as follows: The sales entry process involves creating sales data, including sales identification information, sales date, customer, warehouse, product, quantity sold, unit price, and amount, based on the operator's actions on the sales entry screen, and registering it in the storage area. A consigned inventory management process that, based on the aforementioned sales data, creates consigned inventory data including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the number of sales, and registers it in the aforementioned storage area. An inventory management method characterized by including [this].

8. An inventory management program to be executed on an information processing device equipped with a control unit, In the control unit, The control unit is executed as follows: The sales entry process involves creating sales data, including sales identification information, sales date, customer, warehouse, product, quantity sold, unit price, and amount, based on the operator's actions on the sales entry screen, and registering it in the storage area. A consigned inventory management process that, based on the aforementioned sales data, creates consigned inventory data including warehouse, customer, sales identification information, product, and the number of consigned inventory items equal to the number of sales, and registers it in the aforementioned storage area. An inventory management program for executing this task.

Images