Business support device, business support method, and business support program

Abstract

To allow products purchased as one lot to be easily specified in time series when they are moved or processed.SOLUTION: In this embodiment, a purchase data storage control unit forms purchase data associating a peculiar lot number and a lot trace number obtained by adding a branch number to the lot number, with product information including the number of warehoused products and stores the purchase data in a storage unit. An inventory management unit generates an inventory file indicating the number of moved or processed products and the number of products resulting from subtracting the number of moved or processed products from the number of the warehoused products and stores the inventory file in the storage unit. A state transition association storage control unit forms state transition data associating the product information at the time of warehousing, the lot number at the time of warehousing, and a lot trace number formed by adding a branch number sequentially following the branch number at the time of warehousing to the lot number at the time of warehousing, with the number of moved or processed products and stores the state transition data in the storage unit together with the purchase data and the inventory file.SELECTED DRAWING: Figure 15

Description

[Technical field]

[0001] The present invention relates to a task support device, a task support method, and a task support program. [Background technology]

[0002] Today, the general practice in inventory management is to assign consecutive lot numbers to received products. Patent Document 1 (JP Patent Publication No. 2009-256071) discloses an export business support system as a technology for assigning numbers to products and managing them. This export business support system imports data into the system at the order information stage, records data such as work information or packing information in association with the order information, prepares shipping information, and finally automatically creates an invoice list and a packing list required for customs clearance based on the completed shipping confirmation information.

[0003] This export business support system allows system users to check on their terminals that elements related to order information, such as production information, shipping information, work information, and packaging information, are gradually added to become shipping confirmation information, and allows them to trace the process from product order receipt to production, customs clearance, transportation, and delivery. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2009-256071 A Summary of the Invention [Problem to be solved by the invention]

[0005] However, when some of the products that were assigned the same lot number when they were received are moved to another storage warehouse or processed, they are managed with a lot number different from the one assigned when they were received. Therefore, when some of the products are moved or processed, it becomes difficult to manage all of the products that were assigned the same lot number when they were received over time.

[0006] The present invention has been made in consideration of the above, and aims to provide a business support device, a business support method, and a business support program that make it possible to easily identify the original product in chronological order when the same purchased product is moved or processed. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention comprises a purchase data storage control unit which creates purchase data in which product information including the number of received products is associated with a unique lot number for inventory management of the received products and a lot trace number formed by adding a branch number to the lot number, and stores the data in a memory unit; an inventory management unit which, when products are moved or processed, creates an inventory file indicating the number of products moved or processed and the number obtained by subtracting the number of products moved or processed from the number of received products, and stores the created inventory file in the memory unit; and a state transition corresponding storage control unit which creates state transition data in which the number of moved or processed products is associated with the same product information as at the time of warehousing, the same lot number as at the time of warehousing, and a lot trace number formed by adding a branch number that is consecutive to the branch number at the time of warehousing to the same lot number as at the time of warehousing, and stores the state transition data in the memory unit together with the purchase data and the inventory file; a display control unit which, when a desired lot number is designated during receipt / payment history inquiry, refers to a storage unit based on the designated lot number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on purchase data assigned with the same lot number as the designated lot number, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "dispatch" or "receive" based on state transition data assigned with the same lot number as the designated lot number; when a desired lot trace number is designated, refers to a storage unit based on the designated lot trace number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on purchase data assigned with the same lot trace number as the designated lot trace number, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "dispatch" based on state transition data assigned with the same lot trace number as the designated lot trace number; has.

[0008] Also, in order to solve the above-described problems and achieve the object, the business support method according to the present invention includes a purchase data storage control step in which a purchase data storage control unit forms purchase data in which a unique lot number for performing inventory management of the received goods and a lot trace number obtained by adding a branch number to the lot number are associated with the goods information including the number of received goods, and stores the purchase data in a storage unit; an inventory management step in which an inventory management unit creates an inventory file indicating the number of moved or processed goods and the number obtained by subtracting the number of moved or processed goods from the number of received goods when the goods are moved or processed, and stores the inventory file in the storage unit; and a state transition correspondence storage control step in which a state transition correspondence storage control unit forms state transition data in which the number of moved or processed goods is associated with the same goods information as at the time of receipt, the same lot number as at the time of receipt, and a lot trace number formed by adding a sequential branch number to the branch number at the time of receipt to the same lot number as at the time of receipt, and stores the state transition data in the storage unit together with the purchase data and the inventory file. a receipt / payment history inquiry data generation step in which, when a desired lot number is specified at the time of receipt / payment history inquiry, the display control unit refers to the storage unit based on the specified lot number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on purchase data to which the same lot number as the specified lot number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "dispatch" or "receive" based on state transition data to which the same lot number as the specified lot number is assigned; when a desired lot trace number is specified, the display control unit refers to the storage unit based on the specified lot trace number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on purchase data to which the same lot trace number as the specified lot trace number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "dispatch" based on state transition data to which the same lot trace number as the specified lot trace number is assigned; It has.

[0009] Also, in order to solve the above-described problems and achieve the object, the business support program according to the present invention causes a computer to perform a purchase data storage control unit that forms purchase data in which a unique lot number for performing inventory management of the received goods and a lot trace number obtained by adding a branch number to the lot number are associated with the goods information including the number of received goods, and stores the purchase data in a storage unit; an inventory management unit that creates an inventory file indicating the number of moved or processed goods and the number obtained by subtracting the number of moved or processed goods from the number of received goods when the goods are moved or processed, and stores the inventory file in the storage unit; and a state transition correspondence storage control that forms state transition data in which the number of moved or processed goods is associated with the same goods information as at the time of receipt, the same lot number as at the time of receipt, and a lot trace number formed by adding a sequential branch number to the branch number at the time of receipt to the same lot number as at the time of receipt, and stores the state transition data in the storage unit together with the purchase data and the inventory file and when a desired lot number is specified at the time of receipt / payment history inquiry, the storage unit is referred to based on the specified lot number, and receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" is generated based on purchase data to which the same lot number as the specified lot number is assigned, and receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "dispatch" or "receive" is generated based on state transition data to which the same lot number as the specified lot number is assigned; when a desired lot trace number is specified, the storage unit is referred to based on the specified lot trace number, and receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" is generated based on purchase data to which the same lot trace number as the specified lot trace number is assigned, and receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "receive" is generated based on state transition data to which the same lot trace number as the specified lot trace number is assigned.

Effect of the Invention

[0010] According to the present invention, when the same purchased product is moved or processed, it is possible to easily identify the original product in chronological order. [Brief description of the drawings]

[0011] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task support device according to an embodiment. [Diagram 2] FIG. 2 is a flowchart showing the flow of an automatic numbering operation and an inquiry operation based on each function of the business support device according to the embodiment. [Diagram 3] FIG. 3 is a diagram illustrating an example of purchase data. [Figure 4] FIG. 4 is a diagram showing an example of an inventory file. [Diagram 5] FIG. 5 is a diagram showing an example of the lot detail data. [Figure 6] FIG. 6 is a diagram showing an example of the lot trace data. [Figure 7] FIG. 7 is a diagram illustrating an example of movement data. [Figure 8] FIG. 8 is a diagram showing an example of an inventory file that is created when a product is transferred. [Figure 9] FIG. 9 is a diagram showing an example of lot trace data created when a product is moved. [Figure 10] FIG. 10 is a diagram showing an example of the processed and paid-out data. [Figure 11] FIG. 11 is a diagram illustrating an example of the processing acceptance data. [Figure 12] FIG. 12 is a diagram showing an example of an inventory file created when a product is processed. [Figure 13] FIG. 13 is a diagram showing an example of detailed lot data created when a product is processed. [Figure 14] FIG. 14 is a diagram showing an example of lot trace data created when a product is processed. [Figure 15] FIG. 15 is a diagram showing an example of the inventory inquiry screen. [Figure 16]FIG. 16 is a diagram showing an example of a display of a receipt / payment history inquiry screen based on a lot number. [Figure 17] FIG. 17 is a diagram showing an example of a display of a receipt / delivery history inquiry screen based on a lot tracing number. [Figure 18] FIG. 18 is a diagram for explaining how various data are acquired when inquiring about receipt and payment history. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0012] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. Note that the present invention is not limited to the embodiment.

[0013] [Hardware configuration] 1 is a block diagram showing a hardware configuration of a task support device 1 according to an embodiment. As the task support device 1, a desktop personal computer, a notebook personal computer, or a tablet personal computer can be used. As the task support device 1, a PDA (Personal Digital Assistant) device, a smartphone, or other portable information processing device can be used. Such a task support device 1 includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5.

[0014] An input device 6 and an output device 7 are connected to the input / output interface unit 5. A monitor device (including a home television) can be used as the output device 7. As the input device 6, a keyboard device, a mouse device, a microphone device, and a monitor device that cooperates with a mouse device to realize a pointing device function can be used.

[0015] The storage unit 2 may be, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive). The storage unit 2 stores an inventory management program 11 that enables chronological management of all stored products. The storage unit 2 also stores purchase data, inventory files, lot detail data, lot trace data, movement data, processing and delivery data, and processing and receipt data. This will be described in more detail later.

[0016] [Function configuration] The control unit 3 executes the inventory management program 11 stored in the memory unit 2 to realize the functions of an input processing unit 21, a number generating unit 22, an inventory file processing unit 23, and a lot detailed data processing unit 24. The control unit 3 also executes the inventory management program 11 to realize the functions of a lot trace data processing unit 25, a movement data processing unit 26, a processing and removal data processing unit 27, a processing and removal data control unit 28, and a display control unit 29.

[0017] The input processing unit 21 to the lot trace data processing unit 25 are an example of a purchase data storage control unit.

[0018] (Automatic numbering and inquiry operation) Next, the automatic numbering operation and inquiry operation of the business support device 1 of the embodiment based on each of the above-mentioned functions will be described with reference to the flowchart of Fig. 2. Each process shown in the flowchart of Fig. 2 is executed by each of the above-mentioned functions 21 to 29 as the control unit 3 executes the inventory management program 11.

[0019] (Creating and processing various data at the time of purchase) First, when purchasing goods, for example, the business operator performs a display operation of the purchase data input screen via the input device 6. In response to this display operation, the display control unit 29 controls the display of the purchase data input screen shown in FIG. 3 on the output device 7. The business operator inputs desired data into this purchase data input screen via the input device 6. In step S1, the display control unit 29 monitors whether or not the business operator or the like has performed a display operation of the purchase data input screen, and when the display operation is detected (step S1: Yes), the process proceeds to step S2. In step S2, the input processing unit 21 controls the display of the purchase data input screen, and the input processing unit 21 performs input processing of the purchase data in response to the purchase input operation of the business operator. Also, in step S2, the number generating unit 22 automatically assigns a predetermined number and inputs it into the purchase data. This purchase data is stored in the storage unit 2.

[0020] 3, the purchase data displayed on the purchase data input screen includes "input item" data that is manually input by the business operator, and "automatic set" data that is input with a number automatically generated by the number generation unit 22. Furthermore, the purchase number and line number are automatically generated by the number generation unit 22 when the purchase data input screen starts to be displayed, and are input into each of the purchase number and line number items by the input processing unit 21.

[0021] 3, the purchase date of "June 18, 2021" and the product name of "Product A" are manually input by the business operator. The lot number is automatically generated by the number generation unit 22 based on the purchase date, such as "2021061800001", and is input by the input processing unit 21 (automatic setting). The name of the receiving warehouse where the product is stored, "Tokyo Warehouse", is manually input by the business operator and input by the input processing unit 21.

[0022] The lot tracing number is generated by the number generation unit 22 by adding a branch number corresponding to the warehousing to the lot number. Specifically, in this example, since the lot number generated based on the purchase date of "June 18, 2021" is "2021061800001", the number generation unit 22 automatically generates the lot tracing number "2021061800001-001" by adding the branch number "001" corresponding to the warehousing to this lot number. The input processing unit 21 inputs the generated lot tracing number into the lot tracing number item (automatic setting).

[0023] The purchase quantity of the product, such as “100”, and the expiration date, such as “August 31, 2021”, are manually input by the business operator and input by the input processing unit 21.

[0024] Furthermore, in the case of the business support device 1 of the embodiment, attribute information and remark information can be added to the lot number and lot trace number, enabling more detailed inventory management. That is, the purchase data is provided with items of the first lot attribute to the third lot attribute for inputting attribute information of the product at the time of warehousing. The first lot attribute to the third lot attribute are manually input by the business operator, and are input into the corresponding items by the input processing unit 21. The first lot remarks to the third lot remarks are manually input by the business operator, and are input into the corresponding items by the input processing unit 21. The example of FIG. 3 shows an example in which the business operator inputs remark information indicating the supplier of the product, such as "Purchased from Supplier A", into the first lot remarks.

[0025] The purchase data also includes items of a first lot trace attribute to a third lot trace attribute and a first lot trace remarks to a third lot trace remarks for inputting attribute information or remarks information when some of the received goods are moved or processed. The items of each lot trace attribute and each lot trace remarks are input by the business operator when the goods are moved or processed, as described below.

[0026] Next, based on the purchase data thus created, the inventory file processing unit 23 creates an inventory file, the lot detail data processing unit 24 creates lot detail data, and the lot trace data processing unit 25 creates lot trace data.

[0027] FIG. 4 is a diagram showing an example of an inventory file created by the inventory file processing unit 23. As shown in FIG. 4, the inventory file has the following items: product name, lot number, warehouse name, lot trace number, and quantity. The inventory file processing unit 23 obtains data entered in the items corresponding to each item of the inventory file from the above-mentioned purchase data and enters it into the corresponding item of the inventory file. The example shown in FIG. 4 shows an example in which data such as "Product A" for the product name, "2021061800001" for the lot number, "Tokyo Warehouse" for the warehouse name, "2021061800001-001" for the lot trace number, and "100" for the quantity are entered based on the purchase data. Such an inventory file is stored in the memory unit 2.

[0028] Fig. 5 is a diagram showing an example of the lot detail data created by the lot detail data processing unit 24. As shown in Fig. 5, the lot detail data has items such as product name, lot number, expiration date, possible shipping date, first to third attribute information, and first to third remark information.

[0029] The lot detail data processing unit 24 acquires data input into the items corresponding to each item of the lot detail data from the above-mentioned purchase data, and inputs it into the corresponding items of the lot detail data. The example shown in FIG. 5 shows an example in which the product name is "Product A", the lot number is "2021061800001", the expiration date is "August 31, 2021", the shippable date is "June 18, 2021", and the first lot remarks is "Purchased from Supplier A" based on the purchase data. Such lot detail data is stored in the memory unit 2.

[0030] Fig. 6 is a diagram showing an example of lot tracing data created by the lot tracing data processing unit 25. As shown in Fig. 6, the lot tracing data has the following items: warehouse name, lot tracing number, slip number, line number, arrival date, initial arrival quantity, first to third attribute information, and first to third remark information.

[0031] The lot trace data processing unit 25 acquires data input into the items corresponding to each item of the lot trace data from the above-mentioned purchase data, and inputs the data into the corresponding items of the lot trace data. The example shown in FIG. 6 shows an example in which the warehouse name is "Tokyo Warehouse", the lot trace number is "2021061800001-001", the slip number is "SI001", the line number is "1", the arrival date is "June 18, 2021", and the initial arrival quantity is "100" based on the purchase data. Such lot trace data is stored in the memory unit 2.

[0032] (Creating various data when transferring certain products) Next, when some of the received goods are moved to another warehouse, the business operator performs a display operation of the movement data input screen via the input device 6. In response to this display operation, the display control unit 29 controls the display of the movement data input screen shown in FIG. 7 on the output device 7. The business operator inputs data related to the movement of goods into this movement data input screen via the input device 6. In step S3 of the flowchart in FIG. 2, the display control unit 29 monitors whether or not there is a display operation of the movement data input screen performed by the business operator, etc., and when the display operation is detected (step S3: Yes), the process proceeds to step S6. In step S6, the display control unit 29 controls the display of the movement data input screen, and the movement data processing unit 25 performs input processing of the movement data (an example of state transition data) in response to the input operation of the movement data by the business operator and the automatic numbering process.

[0033] An example of the transfer data is shown in Fig. 7. As shown in Fig. 7, the transfer data is composed of the following items: paragraph number, line number, transfer date, product name, shipping warehouse, lot number, outgoing lot tracing number, incoming lot tracing number, transfer quantity, first lot tracing attribute to third lot tracing attribute, and first lot tracing remarks to third lot tracing remarks.

[0034] Among these, the paragraph number of "ID001" and the line number of "1" are numbers automatically assigned by the movement data processing unit 25 when the movement data is displayed. The movement date, product name, shipping warehouse, lot number, and shipping lot trace number are items entered by the business operator. The example of FIG. 7 shows the movement data created when 30 units of product A, out of 100 units purchased at the Tokyo warehouse, are moved to the Osaka warehouse on June 23, 2021.

[0035] For this reason, the business operator enters "June 23, 2021" as the transfer date, "Product A" as the product name, "Tokyo Warehouse" as the shipping warehouse, "2021061800001" as the lot number, "2021061800001-001" as the outgoing lot tracing number, and "30" as the number moved. The lot number entered is the same as the lot number that was automatically set at the time of purchase (see Figure 3). Additionally, the outgoing lot tracing number entered is the same as the lot tracing number that was automatically set at the time of purchase.

[0036] In contrast, the incoming lot tracing number is newly created when a product is moved, and is data specific to the product movement. As shown in Fig. 7, the movement data processing unit 25 creates an incoming lot tracing number by adding a branch number of "002" corresponding to the movement to the lot number of the product to be moved at the time of purchase, and enters this into the movement data (automatic setting). As a result, the 30 moved products are managed with the unique identification number of "2021061800001-002".

[0037] In addition, the business operator inputs the remark information "Tokyo warehouse → Osaka warehouse" indicating that the product has been moved from the Tokyo warehouse to the Osaka warehouse into the first lot trace remarks as shown in Fig. 7. The movement data processing unit 25 reflects the data of each item input by the business operator and the automatically set data in the movement data, and stores it in the memory unit 2.

[0038] In addition, when a product is moved, the movement data processing unit 25 updates the inventory file created at the time of purchase based on the movement data shown in Figure 7 in accordance with the movement of the product, and creates a new inventory file corresponding to this movement, and stores it in the memory unit 2 by adding it to the line following the inventory file created at the time of purchase.

[0039] FIG. 8 is a diagram showing an example of an inventory file updated in response to the transfer and a newly created inventory file. Of the two-line inventory file shown in FIG. 8, the inventory file in the first line is an inventory file created when the product was purchased. In this example, 30 products were transferred, so the transfer data processing unit 25 (an example of an inventory management unit) creates an inventory file in which the quantity in the inventory file created when the product was purchased is updated (subtracted) from 100 to 70. The transfer data processing unit 25 also creates a new inventory file with the lot trace number "2021061800001-002" corresponding to the 30 products transferred to the Osaka warehouse. Then, the transfer data processing unit 25 stores the newly created inventory file corresponding to the transfer in the storage unit 2 as the inventory file in the second line following the inventory file at the time of purchase.

[0040] In addition, when a product is moved, the movement data processing unit 25 creates new lot trace data corresponding to this movement based on the movement data shown in Figure 7, and stores it in the memory unit 2 by adding it to the line following the inventory file created at the time of purchase.

[0041] FIG. 9 is a diagram showing an example of lot trace data newly created in response to a movement. Of the two lines of lot trace data shown in FIG. 9, the lot trace data in the first line is lot trace data created when the product was purchased. The movement data processing unit 25 creates new lot trace data with the lot trace number "2021061800001-002" corresponding to the 30 products moved to the Osaka warehouse. Then, the movement data processing unit 25 stores the newly created lot trace data corresponding to the movement in the memory unit 2 as the lot trace data in the second line following the lot trace data at the time of purchase.

[0042] When goods are moved in this way, movement data, inventory files, and lot trace data are created, but the lot detail data shown in FIG. 5 is not created.

[0043] (Creating and processing various data when processing some products) Next, when some of the received goods have been processed, the business operator performs a display operation of the processed outgoing data input screen and the processed receiving data input screen via the input device 6. In response to this display operation, the display control unit 29 controls the display of the processed outgoing data input screen shown in Fig. 10 or the processed receiving data input screen shown in Fig. 11 on the output device 7. The business operator inputs data related to the processing of goods into the processed outgoing data input screen and the processed receiving data input screen via the input device 6. The processed outgoing data and the processed receiving data are examples of state transition data.

[0044] In step S4 of the flowchart in Fig. 2, the display control unit 29 monitors whether or not a display operation of the processing input screen, which is the processed outgoing data input screen or the processed receiving data input screen, is performed by the business operator, etc., and when a display operation is detected (step S4: Yes), the process proceeds to step S7. In step S7, the display control unit 29 controls the display of the processed outgoing data input screen or the processed receiving data input screen, and the processed outgoing data processing unit 27 or the processed receiving data processing unit 28 performs input processing of the processed data in response to the input operation of the processed data by the business operator and the automatic numbering process.

[0045] FIG. 10 is a diagram showing an example of processing and sending data. This processing and sending data is data indicating how many products have been sent out for processing from the products currently in stock. As shown in FIG. 10, the business operator inputs, via the input device 6, the processing date such as "June 25, 2021" and the product name of the product sent out from the stock for processing such as "Product A".

[0046] The business operator also inputs, via the input device 6, the name of the warehouse from which the product was dispensed, such as "Tokyo Warehouse", and a dispensed lot number, such as "2021061800001", which is the lot number attached to the product dispensed for processing. The business operator also inputs, via the input device 6, a dispensed lot tracing number, such as "2021061800001-001", which is the lot tracing number attached to the product dispensed for processing. Furthermore, the business operator inputs, via the input device 6, the number of products dispensed this time for processing (20 units).

[0047] The processed and paid-out data processing unit 27 creates the processed and paid-out data shown in Fig. 10 in response to the input operation of the business operator, and stores it in the storage unit 2. The processed and paid-out data number and row number of the processed and paid-out data are automatically numbered and input by the processed and paid-out data processing unit 27 when the processed and paid-out data input screen is displayed.

[0048] Next, FIG. 11 is a diagram showing an example of processed acceptance data. This processed acceptance data is acceptance data for products that have been dispatched and processed. As shown in FIG. 11, the business operator inputs the processing date of the dispatched product such as "June 25, 2021", the product name of the processed product such as "Product B", the name of the receiving warehouse for the processed product such as "Tokyo Warehouse", the number of products such as "20 pieces", and the expiration date of the processed product such as "October 31, 2021" via the input device 6.

[0049] The business operator also inputs remark information indicating the supplier of the processed product, such as "Supplied from Supplier A," into the first lot remarks. Furthermore, the business operator inputs remark information indicating the "processing lot number" into the first lot tracing remarks. By inputting remark information in this way, the supplier of the product that is the source of the processed product can be confirmed at a later date.

[0050] In addition, the processing acceptance data processing unit 28 inputs the lot number "2021061800001" assigned to the processed product at the time of purchase as the acceptance lot number into the processing acceptance data as shown in Fig. 11 (automatic setting). In addition, the processing acceptance data processing unit 28 creates an acceptance lot trace number for the processed product by assigning the branch number "003" corresponding to the processing to the lot number "2021061800001" assigned to the processed product at the time of purchase, and inputs this into the processing acceptance data (automatic setting). As a result, the 20 processed products are managed with the unique identification number "2021061800001-003".

[0051] The processing acceptance data processing unit 28 creates the processing acceptance data shown in Fig. 11 in response to the input operation of the business operator, and stores it in the storage unit 2. The processing acceptance number and the line number of the processing acceptance data are automatically numbered and input by the processing and delivery data processing unit 27 when the processing and delivery data input screen is displayed.

[0052] In addition, when a product is processed, the processed receipt data processing unit 28 (which may be the processed delivery data processing unit 27) updates the inventory file created at the time of purchase based on the processed receipt data shown in Figure 11 in accordance with the number of processed products, and creates a new inventory file corresponding to this processing, which is stored in the memory unit 2 by being added to the line following the inventory file created at the time of purchase and the inventory file created at the time of transfer.

[0053] FIG. 12 is a diagram showing an example of an inventory file updated in response to processing and a newly created inventory file. Of the three-line inventory file shown in FIG. 12, the inventory file in the first line is an inventory file created when the product was purchased. The inventory file in the second line is an inventory file created when the product was moved. In this example, 30 of the total 100 products purchased were moved, and 20 were processed. For this reason, the processing acceptance data processing unit 28 (an example of an inventory management unit) creates an inventory file in which the quantity in the inventory file created when the product was purchased is updated (subtracted) from 70 to 50. The processing acceptance data processing unit 28 also creates a new inventory file with the lot trace number "2021061800001-003" corresponding to the 20 products B received in the Tokyo warehouse after processing. The processing acceptance data processing unit 28 then stores the newly created inventory file corresponding to the movement in the storage unit 2 as the inventory file in the third line following the inventory file at the time of movement.

[0054] Furthermore, the processing acceptance data processing unit 28 creates new lot detail data based on the processing acceptance data shown in FIG. 11, and stores it in the storage unit 2 by adding it to the line following the lot detail data created at the time of purchase.

[0055] FIG. 13 is a diagram showing the lot detail data created at the time of purchase and the lot detail data newly created corresponding to the processing. As shown in FIG. 13, the processing acceptance data processing unit 28 newly creates lot detail data in which the product name of the processed product such as "Product B", the lot number of the processed product such as "2021061800001", and the expiration date of the processed product such as "October 31, 2021" are input based on the processing acceptance data shown in FIG. 11. In addition, the processing acceptance data processing unit 28 newly creates the shipping date of the processed product such as "June 25, 2021" and the remark information "Purchased from Supplier A" based on the processing acceptance data shown in FIG. 11. Then, the processing acceptance data processing unit 28 stores the lot detail data corresponding to the newly created processing in the memory unit 2 as the lot detail data of the second line following the lot detail data at the time of purchase.

[0056] In addition, when a product is processed, the processed receipt data processing unit 28 creates new lot trace data corresponding to this processing based on the processed and discharged data shown in Figure 10 and the processed receipt data shown in Figure 11, and stores it in the memory unit 2 by adding it to the line following the inventory file created at the time of transfer.

[0057] FIG. 14 is a diagram showing an example of lot tracing data newly created corresponding to processing. Of the three lines of lot tracing data shown in FIG. 14, the lot tracing data in the first line is lot tracing data created when the product was purchased. The processing and receiving data processing unit 28 creates new lot tracing data with the lot tracing number "2021061800001-003" corresponding to the 20 units of product B received in the Tokyo warehouse. Then, the processing and receiving data processing unit 28 stores the newly created lot tracing data corresponding to the movement in the memory unit 2 as the lot tracing data in the third line following the lot tracing data at the time of the movement.

[0058] (Display behavior of inquiry screen) 2, the display control unit 29 monitors whether or not the inquiry screen display operation is performed by the business operator. If the inquiry screen display operation is detected (step S5: Yes), the process proceeds to step S8, where the display control unit 29 displays the inquiry screen on the output device 7, which has been instructed to be displayed.

[0059] FIG. 15 is a display example of an inventory inquiry screen. The example in FIG. 15 is an example in which an operator performs an inventory inquiry by specifying the lot number "2021061800001". In this case, the display control unit 29 refers to the inventory file shown in FIG. 12, the lot detail data shown in FIG. 13, and the lot trace data shown in FIG. 14 based on the lot number "2021061800001". Then, the data with the lot number "2021061800001" is extracted from the inventory file, etc., and arranged in chronological order in the column direction to create the inventory inquiry screen (inventory inquiry data) shown in FIG. 15.

[0060] The inventory inquiry data is formed to include, for example, product name, lot number, warehouse name, lot trace number, quantity, expiration date, possible shipping date, first to third lot attributes, first to third lot remarks, first to third lot trace attributes, and first to third lot trace remarks. By arranging such inventory inquiry data in columns in chronological order, the flow of inventory goods due to purchase, movement, and processing of goods can be recognized.

[0061] Specifically, in the example of Figure 15, it can be seen that of 100 units of Product A purchased from Supplier A, 50 units are currently in stock at the Tokyo warehouse, and of the remaining 50 units, 30 units have been moved to the Osaka warehouse, and 20 units have been processed into Product B and are stored in the Tokyo warehouse. Therefore, if there is a problem with a product, it is possible to check the progress information of products that arrived at the same time at once. In other words, by extracting by lot number, it is possible to check at once the current state (has it been processed into a different product, etc.) and where the products that arrived through the same purchase are stored.

[0062] In addition, even if the product is purchased from the same source, different lot tracing numbers, such as "2021061800001-001" to "2021061800001-003", are assigned depending on the movement and processing, allowing products to be managed by adding different note information, enabling more detailed product management.

[0063] Next, Fig. 16 is a display example of a receipt / payment history inquiry screen (receipt / payment history inquiry data). The example in Fig. 16 is an example in which a business operator performs a receipt / payment history inquiry by specifying the lot number "2021061800001". Fig. 18 is a diagram showing a method of acquiring various data by data category and receipt / payment when the display control unit 29 forms a receipt / payment history inquiry screen.

[0064] As shown in FIG. 18, when forming receipt and payment history inquiry data with a data category of "purchase" and receipt and payment of "receive", the display control unit 29 refers to the purchase data shown in FIG. 3 based on the lot number of "2021061800001" and recognizes the product and warehouse corresponding to this lot number. Then, the display control unit 29 acquires the lot detail data shown in FIG. 13 based on the lot number specified by the business operator and the product corresponding to this lot number. In addition, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the lot number specified by the business operator and the warehouse corresponding to this lot number. The display control unit 29 forms receipt and payment history inquiry data with a data category of "purchase", receipt and payment of "receive", and a purchase quantity of 100 as shown in the first row of FIG. 16 based on the acquired lot detail data and lot trace data.

[0065] Also, as shown in FIG. 18, when forming receipt and payment history inquiry data with the data category being "transfer" and receipt and payment being "withdrawal", the display control unit 29 refers to the transfer data shown in FIG. 7 based on the lot number "2021061800001" and recognizes the product, shipping warehouse, and outgoing lot trace data corresponding to this lot number. Then, the display control unit 29 acquires the lot detail data shown in FIG. 13 based on the lot number specified by the business operator and the product corresponding to this lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the shipping warehouse and outgoing lot trace data of the transfer data recognized based on the lot number specified by the business operator. The display control unit 29 forms receipt and payment history inquiry data with the data category being "transfer", receipt and payment being "withdrawal", and the amount of withdrawal being 30, as shown in the second row of FIG. 16, based on the acquired lot detail data and lot trace data.

[0066] Also, as shown in FIG. 18, when forming receipt and payment history inquiry data with the data category being "transfer" and receipt and payment being "received", the display control unit 29 refers to the transfer data shown in FIG. 7 based on the lot number "2021061800001" and recognizes the product, incoming warehouse, and incoming lot trace data corresponding to this lot number. Then, the display control unit 29 acquires the lot detail data shown in FIG. 13 based on the lot number specified by the business operator and the product corresponding to this lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the incoming warehouse and incoming lot trace data of the transfer data recognized based on the lot number specified by the business operator. The display control unit 29 forms receipt and payment history inquiry data with the data category being "transfer", receipt and payment being "received", and the destination warehouse being the Osaka warehouse, as shown in the third row of FIG. 16, based on the acquired lot detail data and lot trace data.

[0067] Also, as shown in FIG. 18, when forming receipt and payment history inquiry data with the data category being "processing" and receipt and payment being "dispatch", the display control unit 29 refers to the processing and dispensing data shown in FIG. 10 based on the lot number "2021061800001" and recognizes the dispensing product, dispensing warehouse, and dispensing lot trace data corresponding to this lot number (dispatch lot number). Then, the display control unit 29 acquires the lot detail data shown in FIG. 13 based on the recognized dispensing lot number and the dispensing product corresponding to this dispensing lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the dispensing warehouse and dispensing lot trace data of the processing and dispensing data recognized based on the lot number designated by the business operator. The display control unit 29 forms receipt and payment history inquiry data of the product A with the data category being "processing" and receipt and payment being "dispatch" and dispensed from the Tokyo warehouse, as shown in the fourth row of FIG. 16, based on the acquired lot detail data and lot trace data.

[0068] Also, as shown in FIG. 18, when forming receipt and payment history inquiry data with the data category being "processing" and receipt and payment being "receiving", the display control unit 29 refers to the processing receipt data shown in FIG. 10 based on the lot number "2021061800001" and recognizes the received product (product B), receiving warehouse, and receiving lot trace data corresponding to this lot number (receiving lot number). Then, the display control unit 29 acquires the lot detail data of product B shown in FIG. 13 based on the recognized receiving lot number and the received product corresponding to this receiving lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the receiving warehouse and receiving lot trace data of the processing receipt data recognized based on the lot number specified by the business operator. The display control unit 29 forms receipt and payment history inquiry data of product B, which has the data category being "processing" and receipt and payment being "receiving" and has been received at the Tokyo warehouse after processing, as shown in the fifth row of FIG. 16, based on the acquired lot detail data and lot trace data.

[0069] The above example is an example in which the business operator performs a receipt / payment history inquiry by specifying the lot trace number "2021061800001", but Fig. 17 is an example in which the business operator performs a receipt / payment history inquiry by specifying the lot trace number "2021061800001-001". In this case as well, the display control unit 29 refers to various data as shown in Fig. 18 based on the lot trace number "2021061800001" specified by the business operator, and forms a receipt / payment history inquiry corresponding to the lot trace number "2021061800001-001".

[0070] When a receipt / payment history inquiry is made by designating this lot tracing number, the display control unit 29 extracts the lot detail data and lot tracing data assigned with the lot tracing number "2021061800001-001" as shown in Fig. 17 to form receipt / payment history inquiry data. Therefore, receipt / payment history inquiry data is formed that does not include the lot detail data and lot tracing data corresponding to the lot tracing number "2021061800001-002" due to the above-mentioned movement, and the lot tracing number "2021061800001-003" due to the above-mentioned processing.

[0071] The task support device 1 according to the embodiment repeatedly executes the operations of steps S1 to S8 in the flowchart of FIG. 2 in response to an operation by a task operator.

[0072] [Effects of the embodiment] As is clear from the above description, the business support device 1 according to the embodiment can easily identify the original product in chronological order when the same purchased product is moved or processed.

[0073] In addition to managing detailed inventory information by product lot, it is also possible to manage information by branch number, making it possible to hold inventory information from both these two perspectives.

[0074] In addition, by assigning a branch number to the same lot and storing management information (such as remarks information) for each branch number, it is possible to simultaneously manage information on a product lot basis and additional information generated by movement, processing, etc.

[0075] In addition, the branch number for each lot is automatically generated and entered according to certain rules, which prevents inconveniences such as input errors caused by manual input by the business operator.

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

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

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

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

[0080] For example, the above embodiment has been described taking the sale of products as an example, but similar operations and effects can be obtained when providing a specific service by performing the same operations as described above.

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

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

[0083] Furthermore, with regard to the journal entry input system, the components shown in the figures are merely functional concepts, and the system does not necessarily have to be physically configured as shown in the figures.

[0084] For example, the processing functions of the business support device 1, particularly the control unit 3 and each processing function performed by the control unit 3, may be realized in whole or in part by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the business support device 1 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. This computer program is executed by being loaded into a RAM, and constitutes the control unit 3 in cooperation with the CPU.

[0085] In addition, this computer program, the inventory management program, may be stored in another server device connected to the business support device 1 via any network, and it is also possible to download all or part of it as needed.

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

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

[0088] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, and web page files used for various processes and providing websites.

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

[0090] Furthermore, the specific form of distribution and integration of the devices is not limited to those 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 function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0091] The present invention is useful for creating documents for inventory management of products. [Explanation of symbols]

[0092] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Inventory Management Program 21 Input processing section 22 Number Generation Unit 23 Inventory File Processing Unit 24 Lot detailed data processing section 25 Lot trace data processing section 26 Movement Data Processing Unit 27 Processing and delivery data processing section 28 Processing and receiving data processing section 29 Display control section

Claims

1. a purchase data storage control unit that forms purchase data by associating product information including the number of received products with a unique lot number for inventory management of the received products and a lot trace number obtained by adding a subnumber to the lot number, and stores the purchase data in a storage unit; an inventory management unit that creates an inventory file indicating the number of moved or processed products when the products are moved or processed, and the number of the products stored minus the number of moved or processed products, and stores the file in the storage unit; a state transition corresponding storage control unit which creates state transition data in which the number of the moved or processed products is associated with the same product information as at the time of warehousing, the same lot number as at the time of warehousing, and a lot trace number formed by adding a branch number that is consecutive to the branch number at the time of warehousing to the same lot number as at the time of warehousing, and stores the state transition data in the storage unit together with the purchase data and the inventory file; a display control unit which, when a desired lot number is designated during receipt / payment history inquiry, refers to the storage unit based on the designated lot number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot number as the designated lot number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" or "receive" based on the state transition data to which the same lot number as the designated lot number is assigned; when a desired lot trace number is designated, refers to the storage unit based on the designated lot trace number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot trace number as the designated lot trace number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" based on the state transition data to which the same lot trace number as the designated lot trace number is assigned; A business support device having the above configuration.

2. The purchase data storage control unit and the state transition correspondence storage control unit form the purchase data or the state transition data further associated with any remark information regarding the product, and store the data in the storage unit.

2. The business support device according to claim 1,

3. The purchase data is added with time information indicating a purchase date of the product, and the state transition data is added with time information indicating a transfer date of the product or a processing date of the product, The display control unit displays, on the display unit, a list of the purchase data and the state transition data having the same lot number or the same lot trace number, in a column direction in chronological order based on the time information.

3. The business support device according to claim 2,

4. The remark information is the supplier of the product, the moving warehouse to which the product is to be moved, or the processing lot number.

4. The business support device according to claim 2 or 3,

5. a purchase data storage control step in which a purchase data storage control unit forms purchase data by associating product information including the number of received products with a unique lot number for inventory management of the received products and a lot trace number obtained by adding a branch number to the lot number, and stores the purchase data in a storage unit; an inventory management step in which an inventory management unit creates an inventory file indicating the number of moved or processed products when the products are moved or processed, and the number of the products stored minus the number of moved or processed products, and stores the file in the storage unit; a state transition correspondence storage control step in which a state transition correspondence storage control unit creates state transition data in which the number of the moved or processed products is associated with the same product information as at the time of warehousing, the same lot number as at the time of warehousing, and a lot trace number formed by adding a branch number that is consecutive to the branch number at the time of warehousing to the same lot number as at the time of warehousing, and stores the state transition data in the storage unit together with the purchase data and the inventory file; a receipt / payment history inquiry data generating step in which, when the desired lot number is specified at the time of receipt / payment history inquiry, the display control unit refers to the storage unit based on the specified lot number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot number as the specified lot number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" or "receive" based on the state transition data to which the same lot number as the specified lot number is assigned; when the desired lot trace number is specified, the display control unit refers to the storage unit based on the specified lot trace number, and generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot trace number as the specified lot trace number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" based on the state transition data to which the same lot trace number as the specified lot trace number is assigned; A business support method having the above-mentioned features.

6. Computer, a purchase data storage control unit that forms purchase data by associating product information including the number of received products with a unique lot number for inventory management of the received products and a lot trace number obtained by adding a subnumber to the lot number, and stores the purchase data in a storage unit; an inventory management unit that creates an inventory file indicating the number of moved or processed products when the products are moved or processed, and the number of the products stored minus the number of moved or processed products, and stores the file in the storage unit; a state transition corresponding storage control unit which creates state transition data in which the number of the moved or processed products is associated with the same product information as at the time of warehousing, the same lot number as at the time of warehousing, and a lot trace number formed by adding a branch number that is consecutive to the branch number at the time of warehousing to the same lot number as at the time of warehousing, and stores the state transition data in the storage unit together with the purchase data and the inventory file; functioning as a display control unit which, when a desired lot number is designated at the time of receipt / payment history inquiry, refers to the storage unit based on the designated lot number, generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot number as the designated lot number is assigned, generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" or "receive" based on the state transition data to which the same lot number as the designated lot number is assigned, when a desired lot trace number is designated, refers to the storage unit based on the designated lot trace number, generates receipt / payment history inquiry data with a data category of "purchase" and receipt / payment of "receive" based on the purchase data to which the same lot trace number as the designated lot trace number is assigned, and generates receipt / payment history inquiry data with a data category of "movement" or "processing" and receipt / payment of "delivery" based on the state transition data to which the same lot trace number as the designated lot trace number is assigned; A business support program that features:

Images