Returned item inventory management device, returned item inventory management method, and returned item inventory management program
The returned inventory management device enhances inventory accuracy by linking product status and arrival date with inventory data, addressing the challenge of managing returned products and preventing erroneous shipments.
Patent Information
- Application Number
- JP2023106356
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-06-28
- Publication Date
- 2025-01-17
- Estimated Expiration
- 2043-06-28
Smart Images

Figure 2025005919000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a returned goods inventory management device, a returned goods inventory management method, and a returned goods inventory management program. [Background technology]
[0002] Patent Document 1 discloses a configuration in which, when goods are returned from a customer, the returned stock quantity and supplier are managed in a product master file as returned stock, and for goods that are not to be disposed of and are not returned to the supplier, the management of the returned stock quantity as returned stock is changed to the management of the normal stock quantity as normal stock. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Publication No. 5-298344 Summary of the Invention [Problem to be solved by the invention]
[0004] However, in the invention described in Patent Document 1 above, products that are not to be disposed of and are not returned to suppliers are managed as regular inventory rather than as returned inventory, which creates the problem that it is not possible to grasp the status of products at each status.
[0005] The present invention has been made in consideration of the above problems, and aims to provide a returned inventory management device, a returned inventory management method, and a returned inventory management program that can manage the status of returned inventory to indicate whether it is a regular item, awaiting appraisal by a supplier, or has been appraised, and can strengthen management of returned inventory by managing retained inventory. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the objective, the returned goods inventory management device of the present invention is a returned goods inventory management device equipped with a memory unit and a control unit, wherein the memory unit comprises an inventory memory means for storing inventory data set in association with the status of the product indicating whether it is a product, a regular product, awaiting appraisal by a supplier or after appraisal by the supplier, the inventory quantity, and the last arrival date, and the control unit comprises an instruction acquisition means for acquiring a delayed inventory inquiry instruction set in association with the inquired product and the inquiry status, and an inventory inquiry means for displaying delayed inventory inquiry detail data set in association with the inventory quantity of the inquired product of the inquiry status and the delay period based on the inventory data and the delayed inventory inquiry instruction.
[0007] In addition, in the returned inventory management device of the present invention, the instruction acquisition means acquires the slow inventory inquiry instruction set in association with the inquiry period, the queried item, and the inquiry status, and the inventory inquiry means displays slow inventory inquiry detail data set in association with the inventory quantity of the queried item in the inquiry status and the slow inventory period that satisfies the inquiry period based on the inventory data and the slow inventory inquiry instruction.
[0008] In addition, in the returned goods inventory management device of the present invention, the control unit is further characterized by having a status change means for acquiring status change data setting the post-change status and number of changes of the product when the appraisal of the product awaiting appraisal is completed at the supplier, and an inventory registration means for updating the inventory data based on the status change data.
[0009] In addition, in the returned goods inventory management device of the present invention, the inventory registration means is characterized in that when the inventory quantity set in the inventory data becomes 0 based on the status change data, the inventory registration means updates the last arrival date set in the inventory data to blank.
[0010] In addition, in the returned goods inventory management device of the present invention, the control unit is further characterized by having a sales acquisition means for acquiring sales data set by linking the status of the product, the sales date including the return date, and the sales number including the number of returns, and an inventory registration means for registering the inventory data based on the sales data.
[0011] In addition, in the returned goods inventory management device of the present invention, the memory unit further includes a status linking master that links the status and a shippable category indicating whether or not the item can be shipped, and the sales acquisition means identifies the status of the item based on the status linking master, and acquires the sales data that is linked to the status, the sales date which includes the return date, and the sales number which includes the number of returns.
[0012] In addition, in the returned goods inventory management device of the present invention, the inventory data is further set in association with a lot number, and the inventory inquiry means displays the retained inventory inquiry detail data, which is set in association with the inventory quantity for each lot number of the inquired item in the inquiry status and the retained inventory period, based on the inventory data and the retained inventory inquiry instruction.
[0013] In addition, the returned goods inventory management method of the present invention is a returned goods inventory management method to be executed by a returned goods inventory management device having a memory unit and a control unit, the memory unit having an inventory memory means for storing inventory data set in association with the status of the product indicating whether it is a product, a regular product, awaiting appraisal by a supplier or after appraisal by the supplier, the inventory quantity, and the last arrival date, and is characterized in that the method includes an instruction acquisition step executed by the control unit for acquiring a delayed inventory inquiry instruction set in association with a referenced product and an inquiry status, and an inventory inquiry step for displaying, based on the inventory data and the delayed inventory inquiry instruction, the inventory quantity of the referenced product in the inquiry status and delayed inventory inquiry detail data set in association with the delay period.
[0014] In addition, the return inventory management program of the present invention is a return inventory management program to be executed by a return inventory management device having a memory unit and a control unit, the memory unit having an inventory memory means for storing inventory data set in association with the status of the product indicating whether it is a product, a regular product, awaiting appraisal by a supplier or after appraisal by the supplier, the inventory quantity, and the last arrival date, and the control unit is caused to execute an instruction acquisition step for acquiring a delayed inventory inquiry instruction set in association with the inquired product and the inquiry status, and an inventory inquiry step for displaying delayed inventory inquiry detail data set in association with the inventory quantity of the inquired product of the inquiry status and the delay period based on the inventory data and the delayed inventory inquiry instruction. Effect of the Invention
[0015] According to the present invention, in addition to improving the accuracy of returned inventory management and preventing erroneous shipment of reserved items, the accuracy of retained inventory management can be improved. Also, according to the present invention, the accuracy of returned inventory management can be improved and erroneous shipment can be prevented by controlling reshipment of reserved items. Also, according to the present invention, the accuracy of inventory management can be improved in companies that handle many products and have many returns. Also, according to the present invention, the inventory can be recorded in the waiting for appraisal status at the time of return based on the update of the last arrival date, and the inventory can be recorded by transferring the status after appraisal. Also, according to the present invention, the status of the product can be automatically changed when a return is made, shipping control can be applied in that status, and it is possible to check how long the product has been retained as inventory. [Brief description of the drawings]
[0016] [Figure 1] FIG. 1 is a diagram illustrating an example of conventional status management. [Diagram 2] FIG. 2 is a diagram illustrating an example of the status association master in this embodiment. [Diagram 3] FIG. 3 is a diagram showing an example of status management in this embodiment. [Figure 4] FIG. 4 is a block diagram showing an example of the configuration of a returned goods inventory management device in this embodiment. [Diagram 5] FIG. 5 is a flowchart showing an example of the process of the returned goods inventory management device in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a returned goods inventory management process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a returned goods inventory management process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of a returned goods inventory management process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of a returned goods inventory management process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of the delayed inventory confirmation process in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0017] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.
[0018] [1. Overview] First, an overview of the present invention will be described with reference to Fig. 1 to Fig. 3. Fig. 1 is a diagram showing an example of conventional status management. Fig. 2 is a diagram showing an example of status linking master in this embodiment. Fig. 3 is a diagram showing an example of status management in this embodiment.
[0019] Traditionally, in the electrical equipment industry and other industries, returned products were stored on shelves separate from regular inventory, but because there were many products handled, managing regular and returned inventory became complicated, and returned inventory often ended up remaining in inventory. In addition, traditionally, there was no function to automatically change the status, and since they had the same status, it was often difficult to distinguish between regular and returned products and to manage them properly. Traditionally, returned products were assessed by a supplier, and once the assessment was completed, they were classified as either to be discarded or to be shipped again.
[0020] Therefore, in this embodiment, when a product is returned, its status is differentiated from that of a normal product, control is applied to prevent it from being shipped, and retained inventory management is implemented to check whether the returned inventory is left behind, thereby providing a mechanism to improve the accuracy of returned inventory management.
[0021] For example, as shown in Figure 1, in the past, products were managed as normal, shippable items at all times: when sales were recorded, when they were returned, and after evaluation by the supplier.
[0022] Here, as shown in FIG. 2, in this embodiment, the status classification of the product is divided into three categories, A, B, and C (A: no control is applied on each input screen, B: a warning message can be issued when sales input and shipment input are performed, and C: a stop is applied when sales input and shipment input are performed), and the master is set. In this embodiment, a status can be added arbitrarily, and a status classification can be set for each. In this embodiment, a shipping check can be performed by the shipping category (0: shipping possible, 1: warning, 2: shipping impossible). In this embodiment, a status can be specified at the time of arrival or shipment. In addition, conventionally, defective products, which are products that are judged to be defective during inspection at the time of new arrival, or retained products, which are products that have missed the chance of production or shipment due to seasonal or cyclical fluctuations, were classified as status B (or C). That is, conventionally, if a product cannot be used as a single product, or a product that cannot be shipped at present but is functionally usable as a production part or service part, the status classification of these products was B (or C).
[0023] Therefore, as shown in Fig. 3, in this embodiment, the product status is managed separately at the time of recording sales, at the time of return, and after the supplier's appraisal, so that (1) when recording the return slip, the status is automatically changed to "waiting appraisal" and the inventory is recorded, (2) when the supplier's appraisal is completed and shipping is possible, the status is changed to "after appraisal" on the status change screen, and (3) it is possible to check from the inquiry screen how much of the returned inventory has been held up as inventory since it was recorded. As a result, in this embodiment, after the return, an appraisal request is made to the supplier, and shipping can be controlled until the appraisal is completed, and since the system allows the setting of whether shipping is possible for each status, shipping can be controlled by changing the status, and since inventory can be managed for each status, it is possible to grasp how many returned products there are.
[0024] [2. Configuration] An example of the configuration of the returned stock management device 100 according to this embodiment will be described with reference to Fig. 4. Fig. 4 is a block diagram showing an example of the configuration of the returned stock management device 100 according to this embodiment.
[0025] 4, the returned goods inventory management device 100 is a commercially available desktop personal computer. The returned goods inventory management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0026] The returned goods inventory management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the returned goods inventory management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0027] The communication interface unit 104 communicably connects the returned 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 a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the returned 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).
[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), 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 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0029] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes a status matching master 106a and an inventory database 106b.
[0030] The status matching master 106a is a master that sets the status of the product. Here, the status matching master 106a may be set by matching the product status indicating whether it is a normal product, awaiting evaluation by the supplier, or after evaluation by the supplier, and the shipping possibility category indicating whether it can be shipped.
[0031] The inventory database 106b stores inventory data of products. Here, the inventory database 106b may store inventory data that is set by linking the product status (product, regular product, awaiting evaluation by the supplier, or after evaluation by the supplier), the number of stocks, and the last arrival date. In addition, the inventory data may be set by linking the lot number.
[0032] The control unit 102 is a CPU or the like that performs overall control of the returned goods inventory management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of functional concepts, the control unit 102 includes a sales acquisition unit 102a, a status change unit 102b, an inventory registration unit 102c, an instruction acquisition unit 102d, and an inventory inquiry unit 102e.
[0033] The sales acquisition unit 102a acquires sales data of a product. Here, the sales acquisition unit 102a may acquire sales data that is set by linking the product status, the sales date including the return date, and the sales number including the number of returns. The sales acquisition unit 102a may also identify the product status based on the status linking master 106a, and acquire sales data that is set by linking the status, the sales date including the return date, and the sales number including the number of returns.
[0034] The status change unit 102b acquires status change data that sets a request to change the status of the inventory data. Here, when the appraisal of a product waiting for appraisal at a supplier is completed, the status change unit 102b may acquire status change data that sets the post-change status of the product and the number of changes.
[0035] The inventory registration unit 102c registers inventory data. Here, the inventory registration unit 102c may register the inventory data based on sales data. The inventory registration unit 102c may also update the inventory data based on status change data. The inventory registration unit 102c may also update the last arrival date set in the inventory data to blank when the inventory quantity set in the inventory data becomes 0 based on the status change data.
[0036] The instruction acquisition unit 102d acquires an inventory inquiry instruction for a product. Here, the instruction acquisition unit 102d may acquire a retained inventory inquiry instruction set by linking a reference product and a reference status. The instruction acquisition unit 102d may also acquire a retained inventory inquiry instruction set by linking a reference period, a reference product, and a reference status.
[0037] The inventory inquiry unit 102e displays inventory inquiry detail data. Here, the inventory inquiry unit 102e may display the slow inventory inquiry detail data set by linking the inventory quantity of the inquiry product in the inquiry status with the slow inventory period based on the inventory data and the slow inventory inquiry instruction. The inventory inquiry unit 102e may also display the slow inventory inquiry detail data set by linking the inventory quantity of the inquiry product in the inquiry status with the slow inventory period that satisfies the inquiry period based on the inventory data and the slow inventory inquiry instruction. The inventory inquiry unit 102e may also display the slow inventory inquiry detail data set by linking the inventory quantity of the inquiry product in the inquiry status for each lot number with the slow inventory period based on the inventory data and the slow inventory inquiry instruction.
[0038] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.
[0039] [Return inventory management processing] An example of returned stock management processing in this embodiment will now be described with reference to Fig. 5. Fig. 5 is a flowchart showing an example of processing of the returned stock management device 100 in this embodiment.
[0040] As shown in FIG. 5, when the user sets the sales date and the number of returns via the input device 112, the sales acquisition unit 102a identifies the status of the product based on the status linking master 106a, and acquires sales data set by linking the status, the sales date including the return date, and the sales number including the number of returns (step SA-1).
[0041] Then, the inventory registration unit 102c registers inventory data of the product in the inventory database 106b based on the sales data (step SA-2).
[0042] Then, when the appraisal of the product waiting for appraisal at the supplier is completed, the status change unit 102b acquires the status change data in which the post-change status of the product and the number of changes are set (step SA-3).
[0043] Then, the inventory registration unit 102c updates the inventory data stored in the inventory database 106b based on the status change data (step SA-4).
[0044] Then, when the user sets the inquiry period, the queried item, and the inquiry status on the slow-moving inventory inquiry screen via the input device 112, the instruction acquisition unit 102d acquires the slow-moving inventory inquiry instruction that is set in association with the inquiry period, the queried item, and the inquiry status (step SA-5).
[0045] Then, based on the inventory data stored in the inventory database 106b and the delayed inventory inquiry instruction, the inventory inquiry unit 102e causes the output device 114 to display the delayed inventory inquiry detail data, which is set by linking the inventory quantity for each lot number of the inquired product in the inquiry status and the delayed inventory period (step SA-6), and ends the processing.
[0046] Here, an example of returned goods inventory management processing in this embodiment will be described with reference to Fig. 6 to Fig. 9. Fig. 6 to Fig. 9 are diagrams showing an example of returned goods inventory management processing in this embodiment.
[0047] In this embodiment, when the status linking master 106a is set as shown in Fig. 6 and inventory data of the product is registered in the inventory database 106b, as shown in Fig. 7, in the event of a sale or return, the sales data is acquired and the inventory data is registered in the inventory database 106b based on the sales data. Here, as shown in Fig. 7, in this embodiment, in the event of a return, the status of the sales data is automatically set to "1: waiting for appraisal." Also, in this embodiment, when entering sales or shipment, an error message is output for inventory with status = "1: waiting for appraisal" (inventory registration not possible), and a warning message is output for inventory with status = "2: after appraisal" (inventory registration possible).
[0048] In this embodiment, as shown in Fig. 8, a request for appraisal of the returned item is made to the supplier, and when the appraisal is completed by the supplier, status change data is acquired and the status set in the inventory data of the returned item is changed to a rank that allows shipment, as shown in Fig. 9. Here, in this embodiment, as shown in Fig. 9, when the inventory quantity set in the inventory data becomes 0, the last arrival date set in the inventory data is deleted.
[0049] An example of the slow inventory confirmation process in this embodiment will be described with reference to Fig. 10. Fig. 10 is a diagram showing an example of the slow inventory confirmation process in this embodiment.
[0050] As shown in FIG. 10, in this embodiment, the period from arrival to shipment is considered to be retention, and the most recent arrival date for each product is compared with the current accounting year and month, and the difference in months is determined as the retention month. That is, as shown in FIG. 10, in this embodiment, for a product with product code: S0001, arrival occurred most recently on 2023 / 1 / 15, and as of May 2023, shipment has not yet occurred. Therefore, the retention month is determined to be "4 (months)" based on the formula "month of current accounting year and month - month of last arrival date". Here, in this embodiment, even if the last arrival date is 2023 / 1 / 28, the retention month will be the same "4". In addition, in this embodiment, the current accounting year and month is obtained from the basic information table.
[0051] As shown in Figure 10, in this embodiment, a backlog inventory inquiry screen is output based on the basic information table and inventory data, and the items "Status" to "Number of months backlogged" at the top of the screen set by the user become the extraction conditions for retrieving data, and data narrowed down by the extraction conditions is output in the details section.
[0052] [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.
[0053] 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.
[0054] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0055] 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.
[0056] 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.
[0057] In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0058] Moreover, with regard to the returned goods inventory management device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.
[0059] For example, the processing functions of the returned goods inventory management device 100, particularly the processing functions performed by the control unit 102, 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 that includes programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the returned goods inventory management 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.
[0060] In addition, this computer program may be stored in an application program server connected to the returned goods inventory management device 100 via any network, and it is also possible to download all or part of it as needed.
[0061] 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.
[0062] 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 configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0063] The various databases etc. stored in the memory unit 106 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.
[0064] The returned goods inventory management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The returned goods inventory management device 100 may be realized by installing software (including programs or data) that causes the device to realize the processing described in this embodiment.
[0065] 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]
[0066] The present invention is useful in industries such as trading companies, including machinery trading companies, which handle a large number of products and have a large number of returns, and the retail industry. [Explanation of symbols]
[0067] 100 Return inventory management device 102 Control section 102a Sales Acquisition Department 102b Status change section 102c Inventory Registration Department 102d Instruction acquisition part 102e Stock Inquiry Section 104 Communication interface section 106 Storage section 106a Status pegging master 106b inventory database 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A return inventory management device including a memory unit and a control unit, The storage unit is an inventory storage means for storing inventory data that is set by linking the status of the product, which indicates whether the product is a product, a regular product, awaiting evaluation by a supplier, or after evaluation by the supplier, the number of products in stock, and the last arrival date; Equipped with The control unit is An instruction acquisition means for acquiring a delayed inventory inquiry instruction set by linking the inquiry product and the inquiry status; an inventory inquiry means for displaying the inventory quantity of the inquired item of the inquiry status and the delayed inventory inquiry detail data set in association with the delayed inventory inquiry instruction based on the inventory data and the delayed inventory inquiry instruction; A returned goods inventory management device comprising:
2. The instruction acquisition means includes: The slow-moving inventory inquiry instruction is acquired by linking the inquiry period, the inquiry product, and the inquiry status, and is set. The inventory inquiry means is The return inventory management device of claim 1, characterized in that, based on the inventory data and the delayed inventory inquiry instruction, the inventory quantity of the inquired item in the inquiry status and the delayed inventory inquiry detail data that is linked to the delayed inventory period that satisfies the inquiry period are displayed.
3. The control unit is a status change means for acquiring status change data that sets a post-change status of the product and a number of changes when the evaluation of the product waiting for evaluation is completed by the supplier; an inventory registration means for updating the inventory data based on the status change data; 3. The returned goods inventory management device according to claim 1, further comprising:
4. The inventory registration means includes: The returned goods inventory management device according to claim 3, characterized in that if the inventory quantity set in the inventory data becomes 0 based on the status change data, the last arrival date set in the inventory data is updated to blank.
5. The control unit is a sales acquisition means for acquiring sales data that is set by linking the status of the product, a sales date including a return date, and a sales number including a return number; an inventory registering means for registering the inventory data based on the sales data; 3. The returned goods inventory management device according to claim 1, further comprising:
6. The storage unit is A status pegging master that links the status and a shipping possibility category indicating whether or not the item can be shipped; Further comprising: The sales acquisition means includes: The return inventory management device of claim 5, characterized in that the status of the product is identified based on the status linking master, and the sales data is obtained by linking the status, the sales date including the return date, and the sales number including the return quantity.
7. The inventory data is In addition, lot numbers are linked and set, The inventory inquiry means is The return inventory management device according to claim 1 or 2, characterized in that, based on the inventory data and the delayed inventory inquiry instruction, the delayed inventory inquiry detail data is displayed, which is set in association with the inventory quantity for each lot number of the inquired product in the inquiry status and the delayed inventory period.
8. A return inventory management method to be executed by a return inventory management device having a storage unit and a control unit, The storage unit is an inventory storage means for storing inventory data that is set by linking the status of the product, which indicates whether the product is a product, a regular product, awaiting evaluation by a supplier, or after evaluation by the supplier, the number of products in stock, and the last arrival date; Equipped with Executed in the control unit, An instruction acquisition step of acquiring a delayed inventory inquiry instruction set by linking the inquiry product and the inquiry status; an inventory inquiry step of displaying the inventory quantity of the inquired item in the inquiry status and the delayed inventory inquiry detail data set in association with the delayed inventory inquiry instruction based on the inventory data and the delayed inventory inquiry instruction; A return inventory management method comprising:
9. A returned goods inventory management program to be executed by a returned goods inventory management device having a storage unit and a control unit, The storage unit is an inventory storage means for storing inventory data that is set by linking the status of the product, which indicates whether the product is a product, a regular product, awaiting evaluation by a supplier, or after evaluation by the supplier, the number of products in stock, and the last arrival date; Equipped with In the control unit, An instruction acquisition step of acquiring a delayed inventory inquiry instruction set by linking the inquiry product and the inquiry status; an inventory inquiry step of displaying the inventory quantity of the inquired item in the inquiry status and the delayed inventory inquiry detail data set in association with the delayed inventory inquiry instruction based on the inventory data and the delayed inventory inquiry instruction; A return inventory management program to execute the following:
Citation Information
Patent Citations
Stock management system, stock management method and stock management program
JP2011060222A
Data processing device and computer program
JP2013168052A
Program, method, apparatus and system for generating inventory information, and inventory information display device
JP2014052892A
Inventory breakdown information creation device, inventory breakdown information creation method, and inventory breakdown information creation program
JP2020052742A
Shelf stacking management device, shelf stacking management method, and program
JP2022129283A