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

Abstract

To provide an inventory management device, an inventory management method, and an inventory management program capable of reducing the burden of a person in charge in an inventory management business.SOLUTION: This inventory management device comprises: an expiry date calculation unit that calculates the number of days remaining from a prescribed date to a sale expiry date calculated by subtracting days from an expiry date referring to a commodity master for managing days inhibiting selling from an expiry date added to each commodity and each freshness date inventory data for managing a commodity for each expiry; and a first display control unit that displays a freshness date check screen having a region designating the remaining days. A calculation result less than the designated remaining days is extracted from the calculation result of the expiry date calculation unit, a commodity related to the extracted calculation result is acquired from the commodity master, and the acquired commodity and the extracted calculation result are displayed so as to be selectable as extraction results.SELECTED DRAWING: Figure 8

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 discloses an information processing device and a program that can easily and appropriately manage products. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2022-87216 Summary of the Invention [Problem to be solved by the invention]

[0004] In inventory management, sales information and product expiration information were managed separately, so the person in charge had to manually check the sales information against the product expiration information to manage inventory that was approaching its expiration date, which was a burden for the person in charge.

[0005] The present invention has been made in consideration of the above, and has an object to provide an inventory management device, an inventory management method, and an inventory management program that reduce the burden on a person in charge of inventory management. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the inventory management device of the present invention is characterized by comprising: a deadline day calculation unit that refers to first data that manages the number of days from the deadline assigned to each product that the product cannot be sold after that and second data that manages products by deadline, subtracts the number of days from the deadline to calculate the sell-by date, and calculates the number of days remaining from a specified date until the sell-by date; a first display control unit that displays an extraction condition specification screen having an area for specifying the number of remaining days; and a second display control unit that extracts calculation results that are less than the specified number of remaining days from the calculation results calculated by the deadline day calculation unit, obtains products related to the extracted calculation results from the second data, and displays the obtained products and the extracted calculation results selectable as extraction results.

[0007] In addition, the inventory management device of the present invention is characterized by further comprising a sales aggregation unit that aggregates sales by store by referring to sales data based on the product selected in the extraction result displayed by the second display control unit, and displays the aggregated result selectably on the sales list display screen, and a third display control unit that displays a product transfer input screen for instructing the store transfer process of the product, which reflects the product selected on the sales list display screen and includes a designation area for specifying the quantity of the product.

[0008] In addition, in the inventory management device of the present invention, the second data includes store information and manages products by store and by expiration date, the expiration date calculation unit calculates the sell-by date and remaining days for each store information and product, the extraction condition designation screen further includes an area for designating store information, and the second display control unit displays the extraction results including the designated store information in a selectable manner.

[0009] In the inventory management device according to the present invention, the sales totalization section refers to an area master that manages stores by area, and totals sales by store for each area.

[0010] In addition, the inventory management method of the present invention has a deadline day calculation step in which a deadline day calculation unit refers to first data that manages the number of days from the deadline given to each product that the product cannot be sold and second data that manages products by deadline, subtracts days from the deadline to calculate the sell-by date, and calculates the number of remaining days from a specified date until the sell-by date; a first display control step in which a first display control unit displays an extraction condition designation screen having an area for designating the number of remaining days; and a second display control step in which a second display control unit extracts calculation results that are less than the specified number of remaining days from the calculation results calculated by the deadline day calculation unit, acquires products related to the extracted calculation results from the second data, and displays the acquired products and the extracted calculation results selectable as extraction results.

[0011] In addition, the inventory management program of the present invention causes a computer to function as: a deadline day calculation means for calculating the sell-by date by subtracting days from the deadline, by referring to first data which manages the number of days from the deadline assigned to each product that the product cannot be sold, and second data which manages products by deadline, and calculating the number of days remaining from a specified date until the sell-by date; a first display control means for displaying an extraction condition specification screen having an area for specifying the number of remaining days; and a second display control means for extracting calculation results which are less than the specified number of remaining days from the calculation results calculated by the deadline day calculation unit, obtaining products related to the extracted calculation results from the second data, and displaying the obtained products and the extracted calculation results selectable as extraction results. Effect of the Invention

[0012] The present invention can reduce the burden on a person in charge of inventory management. [Brief description of the drawings]

[0013] [Figure 1] FIG. 1 is a diagram showing an example of the configuration of a task support device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of the product master according to the present embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of the area master according to the present embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of the store master according to the present embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of expiration date-classified inventory data according to the present embodiment. [Figure 6] FIG. 6 is a diagram showing an example of sales data according to the present embodiment. [Figure 7] FIG. 7 is a diagram showing an example of an outline of the process according to this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of a screen and an example of processing in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of a screen in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of processing in this embodiment. [Figure 11] FIG. 11 is a diagram showing an example of a screen in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, an embodiment of an inventory management device, an inventory management method, and an inventory management program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to the embodiment.

[0015] [1. Configuration] An example of the configuration of a task assistance device 100 according to this embodiment (including the inventory management device of the present invention) will be described with reference to Fig. 1 etc. Fig. 1 is a block diagram showing an example of the configuration of the task assistance device 100.

[0016] The business support device 100 is constructed based on a commercially available desktop personal computer. The business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0017] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the business support device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0018] The communication interface unit 104 communicatively connects the task assistance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the task assistance 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). The data stored in the memory unit 106 may be stored in the server 200, for example.

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

[0020] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage 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 as the storage unit 106.

[0021] The memory unit 106 stores a product master 106a (corresponding to the first data of the present invention), an area master 106b (corresponding to the area master of the present invention), a store master 106c, inventory data by expiration date 106d (corresponding to the second data of the present invention), and sales data 106e (corresponding to the sales data of the present invention), etc.

[0022] The product master 106a is for managing product information, as shown in Fig. 2. The product master 106a stores product identification information for identifying a product (e.g., product code, product name, etc.) and the number of days before the sell-by date that specifies how many days before the product can be sold to consumers based on the expiration date attached to the product, such as the best-before date (the product cannot be sold during the period from the date that is the number of days before the expiration date to the expiration date). Note that in this embodiment, a case where the expiration date attached to the product is the best-before date will be described as an example, but the expiration date attached to the product is not limited to the best-before date.

[0023] The area master 106b manages the division of areas as shown in Fig. 3. The area master 106b stores area identification information (e.g., area code, etc.) for identifying an area, and area names (e.g., area names, etc.) included in the area identification information.

[0024] The store master 106c is for managing store information as shown in Fig. 4. The store master 106c stores store identification information for identifying a store (for example, a store code, a store name, etc.), an area code corresponding to the store, etc.

[0025] The expiration date-specific inventory data 106d is for managing product information by expiration date, as shown in Fig. 5. The expiration date-specific inventory data 106d stores the data processing date, store identification information, product identification information, inventory quantity (e.g., actual inventory, etc.), expiration date, etc.

[0026] The sales data 106e is for managing sales, as shown in Fig. 6. The sales data 106e stores sales identification information (e.g., sales number, etc.) that identifies a sale, a sales date, store identification information, product identification information, sales quantity, etc.

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

[0028] In terms of functional concept, the control unit 102 comprises an expiration date data import unit 102a, an expiration date inventory inquiry unit 102b (including the expiration date number calculation unit, first display control unit and second display control unit of the present invention), a sales ranking list compilation unit 102c (including the sales compilation unit of the present invention) and a store movement input unit 102d (including the third display control unit of the present invention).

[0029] The expiration date data import unit 102a imports expiration date data such as expiration dates contained in data read from products etc. by an electronic terminal (handy scanner etc.) and generates expiration date-classified inventory data 106d.

[0030] The expiration date-based inventory inquiry unit 102b performs the following processes (11) to (14). (11) In response to an instruction from the operator, the expiration date check screen MA is displayed (see FIG. 8). (12) The expiration date check screen MA is displayed, and the product master 106a and expiration date-specific inventory data 106d are referenced to calculate "sell-by date = best-by date - number of days until sell-by date" to calculate the sell-by date (see FIG. 8). Also, the remaining number of days until sell-by date = best-by date - number of days until sell-by date - server date (the date when the operator instructed to display the expiration date check screen MA)" is calculated to calculate the remaining number of days until sell-by date (see FIG. 8). (13) The operator sets the extraction conditions for areas MA1 to MA5 of the expiration date check screen MA, and data that matches the extraction conditions set by the operator is displayed as a list in area MA6. Note that the store code in area MA2 may be preset to the store code of the store for which the operator has instructed to display the expiration date check screen MA. (14) The operator is prompted to select a record from the list in area MA6, and the sales ranking list compilation unit 102c is started.

[0031] The sales ranking list compilation unit 102c performs the following processes (21) to (26). (21) The store code of the record specified in area MA6 of the expiration date check screen MA is obtained, and the area code is obtained by referring to the store master 106c. (22) Based on the acquired area code, the store master 106c is referenced to acquire a store code having the same area code (see FIG. 10). (23) Refer to the sales data 106e, obtain the record including the product code specified in area MA6 of the expiration date check screen MA, and total the sales figures for each obtained store code (see FIG. 10). Note that it may be set in advance to total the sales figures for the most recent month for each store. (24) For the product specified in area MA6 of the expiration date check screen MA, the acquired store code and the current stock quantity at the store are obtained from the inventory data of each store (not shown). (25) The sales ranking list screen MB is displayed, and the product code of the record specified in area MA6 of the expiration date check screen MA is displayed in area MB1, and the product name is displayed in area MB2. Area MB3 displays the store code, store name, sales amount, and inventory amount in descending order of the total sales (see Figure 9). (26) The operator selects a record from the list in area MB3 and starts up store relocation input section 102d.

[0032] The store movement input unit 102d performs the following processes (31) to (33). (31) The store transfer input screen MC is displayed, and the date when the operator instructed to display the expiration date check screen MA is acquired and displayed in area MC1, the store code specified on the expiration date check screen MA is acquired and displayed in area MC2, and the store code of the record specified in area 3 of the sales ranking list screen MB is acquired and displayed in area MC3 (see Figure 11). (32) In areas MC41 and MC42, the product code and product name of the record designated in area 3 of the sales ranking list screen MB are acquired and displayed (see FIG. 11). (33) The operator sets the number of movements of the area MC42, and the process proceeds to the movement process (see FIG. 11).

[0033] [2. Overview] The following is an overview of the functions of the present invention. A data area is held that accumulates inventory information by expiration date, which is registered by a staff member at a store or the like using an electronic terminal (such as a handy scanner) for in-store products. A screen is displayed that allows the accumulated data to be referenced in list format at the operator's command, and the reference screen allows data to be referenced by product and expiration date. In addition, the product master is set with a number of days from the expiration date that makes the product ineligible for sale for a certain period of time, making it possible to manage the sales deadline for each product (the period before the expiration date that the product may be sold). This implements extraction conditions that make it easy to obtain products that are approaching their sell-by date. Furthermore, the sales ranking list can be launched on a separate screen from the reference screen, making it possible to reference the sales ranking of target products within the same area.

[0034] The outline of the process will be described with reference to Fig. 7. A person in charge at a store or the like reads the products on display with a handy scanner or the like, and registers the product information and the quantity by expiration date in the expiration date inventory data 106d. The expiration date data import unit 102a generates the expiration date inventory data 106d from the handy data.

[0035] When the operator instructs to check inventory by expiration date, the inventory inquiry by expiration date unit 102b displays an inventory inquiry screen by expiration date (best-before date check screen MA). When the operator instructs to check inventory by expiration date, the inventory inquiry by expiration date unit 102b refers to the inventory data by expiration date 106d and the product master 106a at the same time, calculates the sell-by date, the number of days remaining until the sell-by date, etc., and extracts and displays products that match the extraction conditions from the calculation results based on the conditions set by the operator.

[0036] In response to an instruction from the operator to display the sales ranking list, the sales ranking list compilation unit 102c displays the generated sales ranking list. The operator checks whether there is a store in the same area that has a sales volume for the relevant product.

[0037] The operator, after examining the list, issues a store transfer input instruction to transfer the item to a store that has a sales volume for the item. The store transfer input unit 102d then displays a store transfer input screen, prompts the operator to enter information, and transitions to transfer processing for the target store.

[0038] [3. Specific examples of processing] A specific example of the process executed by the business support device 100 configured as described above will be described in detail with reference to Fig. 8 to Fig. 11. Note that the expiration date check screen MA, the sales ranking list screen MB, and the store movement input screen MC are only partial views of each screen.

[0039] As a premise, a person in charge uses a handheld terminal to register product information, store inventory information, and the quantity by expiration date for products in the store. Then, the expiration date data import unit 102a generates expiration date-specific inventory data 106d from the accumulated registration data.

[0040] The operator issues an instruction to display the expiration date check screen MA.

[0041] Then, the expiration date-specific inventory inquiry unit 102b displays an expiration date check screen MA and calculates the sell-by date and the remaining number of days until the sell-by date (see FIG. 8).

[0042] For example, in the case of the product code "6750" shown in a bold frame in <Calculation results when displayed on screen> in Figure 8, the expiration date inventory inquiry unit 102b refers to the product master 106a, obtains the sales expiration date number of days "50 days" from the record containing the product code "6750", and obtains the record containing the product code "6750" from the expiration date inventory data 106d.

[0043] Next, the expiration date-specific inventory inquiry unit 102b calculates the sell-by date by calculating "Sell-by date = Best-by date - Number of days until sell-by date". The expiration date-specific inventory inquiry unit 102b subtracts the acquired number of sales days "50 days" from the best-by date "2023 / 10 / 10" of the record of the acquired expiration date-specific inventory data 106d to calculate the sell-by date "2023 / 8 / 21" (see FIG. 8).

[0044] Next, the expiration date-specific inventory inquiry unit 102b calculates "remaining days until the sell-by date = expiration date - number of days until the sell-by date - server date" to calculate the remaining days until the sell-by date. The expiration date-specific inventory inquiry unit 102b subtracts the server date "2023 / 8 / 1" from the sell-by date "2023 / 8 / 21", which is obtained by subtracting the acquired sell-by date "50 days" from the expiration date "2023 / 10 / 10", to calculate the remaining days until the sell-by date "20 days". The expiration date-specific inventory inquiry unit 102b holds the actual inventory, expiration date, sell-by date, and remaining days until the sell-by date from the processing date, store code, product code, and expiration date-specific inventory data 106d for each product (see FIG. 8).

[0045] Next, the operator sets the extraction conditions for the displayed expiration date check screen MA in areas MA1 to MA5, by setting the store code in area MA2 to "0011," the processing date in area MA3 to "07 / 31 / 2023," and the number of days remaining until the sell-by date in area MA5 to "0 to less than 30 days," and then instructs data extraction (see Figure 8).

[0046] Then, the expiration date inventory inquiry unit 102b acquires the retained information for product code "6750" from the <calculation results when displaying on screen> shown in Figure 8, which includes the processing date "2023 / 07 / 31", the store code "0011", and the number of days remaining until the sales expiration date is in the range of "0 to less than 30 days".

[0047] Next, the expiration date-specific inventory inquiry unit 102b displays the processing date "2023 / 7 / 31" in MA61, the store code "011" in MA62, the product code "6750" in MA64, the expiration date "2023 / 10 / 10" in MA66, the sell-by date "2023 / 8 / 21" in MA67, the remaining days until the sell-by date "20 days" in MA68, and the actual inventory quantity "50" in MA69 in the area MA6 that displays the extraction result of the expiration date check screen MA (see FIG. 8). The expiration date-specific inventory inquiry unit 102b refers to the store master 106c based on the store code "011" and displays the store "Shinjuku store" in the area MA63. The expiration date-specific inventory inquiry unit 102b refers to the product master 106a based on the product code "6750" and displays the product name "Shrimp Stock 80g" in the area MA65 (see FIG. 8).

[0048] The operator then selects the record with the product name "6750" from the extraction results in area MA6 of the expiration date check screen MA, and issues an instruction to display a sales ranking list.

[0049] Then, the sales ranking list compilation unit 102c acquires the store code "011" in MA62, and acquires the area code "A0001" by referring to the store master 106c shown in Fig. 10. The sales ranking list compilation unit 102c acquires store codes that include "A0001" in the area code by referring to the store master 106c.

[0050] Next, the sales ranking list compilation unit 102c refers to the sales data 106e shown in Fig. 10, acquires records including the product code "6750" specified in area MA6 of the expiration date check screen MA, and compiles the sales figures for the most recent month, which is a preset period, for each acquired store code. The sales ranking list compilation unit 102c acquires the latest (closest to the server date) actual inventory for each store of product code "6750" from inventory data (not shown) for each store.

[0051] Next, the sales ranking list compilation unit 102c displays the product code "6750" in area MB1 of the sales ranking list screen MB, and the product name "Shrimp Stock 80g" in area MB2 (see FIG. 9). Furthermore, the sales ranking display area MB3 displays the store code, store, sales volume, and inventory volume in descending order of sales volume (see FIG. 9).

[0052] The operator considers stores that have the potential to sell the product. In this example, it is assumed that store code "0013" and store name "Shinjuku BB store" are judged to be stores with the potential to sell the product. Next, the operator designates a record containing store code "0013" in area MB3 of the sales ranking list screen MB, and issues an instruction to display the store transfer input screen MC.

[0053] Then, the store transfer input unit 102d displays the store transfer input screen MC. The store transfer input unit 102d displays the server date "2023 / 8 / 1" as the transfer date in the area MC1, and displays "011" as the store code in the area MC2, which was specified in the expiration date check screen MA (see FIG. 11). Furthermore, the store transfer input unit 102d displays the destination store code "0013", product code "6750", and product name "Shrimp Stock 80g" from the record specified in the sales ranking list screen MB as the destination store code in the area MC3, the store code in MC41 in the area MC4 that specifies the product information to be moved, and the product name in MC42, respectively (see FIG. 11).

[0054] The operator then specifies and registers the number of moves "30" in area MC43 of the store move input screen MC, and proceeds to store move processing for the product.

[0055] (Effects of the embodiment) Previously, stores were unable to track receipts and payments by expiration date because the POS (Point Of Sale) system did not include expiration date information in sales. Therefore, staff had to count in-store stock by expiration date, write down the information on the number of items in stock by expiration date on paper, and then transfer the data to Excel. As a result, the systems varied depending on the staff, and mistakes occurred. This made each check process cumbersome. In addition, area managers and others were unable to immediately grasp the sales trends of their store or the trends of other stores, and it took time to decide what action to take for products that were about to be removed from the store (close to their sell-by date).

[0056] According to this embodiment, when a person in charge obtains store inventory data using a handy scanner or the like, the data is given a best-before date, so that anyone can check the best-before date in the same way and with the same accuracy in store operations where personnel change frequently. In addition, by comparing the sales deadline set for each product with the best-before date information, it becomes easier to pick up products that may remain in stock, and it becomes possible to take effective action on the target products. Furthermore, it is possible to have the operator select the target product and search the sales ranking for the past month in the same area in a list format on a separate screen, and it is possible to check which store to allocate more specifically by referring to the list. As a result, it is possible to manage information on multiple stores in a lump sum, so that area managers can use it to determine the allocation of surplus inventory along with sales by store, and it is also possible to prevent excessive ordering in the area by checking the system before other stores place orders.

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

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

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

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

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

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

[0063] Moreover, with regard to the task support device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.

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

[0065] In addition, this computer program may be stored in an application program server connected to the task support device 100 via any network, and it is also possible to download all or a part of it as necessary.

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

[0067] 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 the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

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

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

[0070] 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]

[0071] The present invention is useful in industries that operate stores and handle products with expiration dates, such as food products. [Explanation of symbols]

[0072] 100 Business support equipment 102 Control section 102a Expiration date data input section 102b Expiration date inventory inquiry section 102c Sales Ranking List Compilation Section 102d Store movement input section 104 Communication interface section 106 Storage section 106a Product Master 106b Area Master 106c Store Master 106d Inventory data by expiration date 106e Sales Data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. a deadline calculation unit that calculates the number of days remaining from a specified date to the sell-by date by subtracting the number of days from the deadline given to each product by referring to first data that manages the number of days from which the product cannot be sold and second data that manages products by the deadline, and calculates the sell-by date; a first display control unit that displays an extraction condition designation screen having an area for designating the number of remaining days; a second display control unit that extracts a calculation result that is less than the specified remaining number of days from the calculation results calculated by the deadline days calculation unit, obtains the product related to the extracted calculation result from the second data, and displays the obtained product and the extracted calculation result selectably as an extraction result; An inventory management device comprising:

2. a sales aggregation unit that aggregates sales by store by referring to sales data based on the selected product in the extraction result displayed by the second display control unit, and displays the aggregated results in a selectable manner on a sales list display screen; a third display control unit that displays a product transfer input screen for instructing a store transfer process of a product, the product selected on the sales list display screen being reflected and including a designation area for designating a quantity of the product; The inventory management device of claim 1 , further comprising:

3. The second data includes store information and manages the products by store and by the expiration date; The expiration date calculation unit calculates the sell-by date and the remaining days for each store information and each product, The extraction condition specification screen further includes an area for specifying store information, the second display control unit displays the extraction result including the designated store information in a selectable manner; 2. The inventory management device according to claim 1,

4. 3. The inventory management device according to claim 2, wherein the sales totalization unit refers to an area master that manages stores by area, and totals the sales of the stores by the area.

5. A deadline calculation step in which a deadline calculation unit calculates a sell-by date by subtracting the number of days from a deadline given to each product by referring to first data that manages the number of days from which the product cannot be sold and second data that manages products by the deadline, and calculates the number of days remaining from a specified date to the sell-by date; a first display control step of causing a first display control unit to display an extraction condition designation screen having an area for designating the number of remaining days; A second display control step in which a second display control unit extracts a calculation result that is less than the specified remaining days from the calculation results calculated by the deadline days calculation unit, obtains the product related to the extracted calculation result from the second data, and displays the obtained product and the extracted calculation result selectably as an extraction result; An inventory control method having the following features.

6. Computer, a deadline date calculation means for calculating the number of days remaining from a specified date to the sell-by date by subtracting the number of days from the deadline given to each product by referring to first data for managing the number of days from which the product cannot be sold and second data for managing products by the deadline; a first display control means for displaying an extraction condition designation screen having an area for designating the number of remaining days; a second display control means for extracting, from the calculation results calculated by the deadline days calculation unit, the calculation results that are less than the designated remaining days, acquiring the products related to the extracted calculation results from the second data, and displaying the acquired products and the extracted calculation results selectably as extraction results; Inventory management program to function as.

Images