Operation support device, operation support method, and operation 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 business support device, a business support method, and a business support program.

Background Art

[0002] In inventory management of products today, it is common to manage the products by attaching a lot number that is a consecutive number to the received products. As a technique for attaching numbers to products and managing them, a patent document 1 (Japanese Patent Application Laid-Open No. 2009-256071) discloses an export business support system. This export business support system captures data into the system at the order receiving information stage, associates data such as work information or packing information with the order receiving information and records it to align the shipping information, and finally, based on the completed shipping confirmation information, automatically creates an invoice list and a packing list necessary for customs clearance.

[0003] In this export business support system, on the terminal, the system user can confirm that elements for becoming shipping confirmation information such as production information, shipping information, work information, and packing information related to the order receiving information are gradually added, and can trace the processes from product order receiving to production, customs clearance, transportation, and delivery.

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0005] However, when some of the products with the same lot number attached at the time of receipt are moved to another storage warehouse or the like, or processed, they are managed with a lot number different from that at the time of receipt. For this reason, when some products are moved or processed, there has been a problem that it becomes difficult to manage all the products with the same lot number attached at the time of receipt over time.

[0006] The present invention has been made in view of the above, and aims to provide a business support device, a business support method, and a business support program that enable the original product to be easily identified in chronological order when moving or processing products with the same purchase.

Means for Solving the Problems

[0007] In order to solve the above-described problems and achieve the object, a business support device according to the present invention forms purchase data in which a unique lot number for inventory management of the received product, and a lot trace number obtained by adding a branch number to the lot number are associated with product information including the number of received products, and stores the purchase data in a storage unit. A purchase data storage control unit, when a product is moved or processed, creates an inventory file indicating the number of products that have been moved or processed and the number obtained by subtracting the number of products that have been moved or processed from the number of received products, and stores the inventory file in the storage unit. An inventory management unit, and forms state transition data in which the same product information as at the time of receipt, the same lot number as at the time of receipt, and a lot trace number formed by attaching a sequential branch number to the branch number at the time of receipt are associated with the number of products that have been moved or processed, and stores the state transition data together with the purchase data and the inventory file in the storage unit. A state transition correspondence storage control unit, the purchase data storage control unit and the state transition correspondence storage control unit form purchase data or state transition data further associated with arbitrary remarks information regarding the product, and store the purchase data or state transition data in the storage unit. Time information indicating the purchase date of the product is added to the purchase data, and time information indicating the movement date or processing date of the product is added to the state transition data. A display control unit that arranges and displays in a list in the display unit in chronological order in the column direction the purchase data and the state transition data having the same lot number or the same lot trace number based on the time information.

[0008] In addition, in order to solve the above-described problems and achieve the object, a 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 unique lot numbers for performing inventory management of the received products and lot trace numbers obtained by adding branch numbers to the lot numbers are associated with product information including the number of received products, 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 products that have been moved or processed and the number obtained by subtracting the number of products that have been moved or processed from the number of received products when the products are moved or processed, and stores the inventory file in the storage unit; a state transition correspondence storage control step in which a state transition correspondence storage control unit forms state transition data in which the same product information as at the time of receipt, the same lot number as at the time of receipt, and a lot trace number formed by attaching a serial number to the branch number at the time of receipt to the same lot number as at the time of receipt are associated with the number of products that have been moved or processed, and stores the state transition data together with the purchase data and the inventory file in the storage unit. The purchase data storage control step and the state transition correspondence storage control step further form purchase data or state transition data in which arbitrary remarks information regarding the product is further associated therewith, and store the data in the storage unit. Time information indicating the purchase date of the product is added to the purchase data, and time information indicating the movement date or processing date of the product is added to the state transition data. The display control unit further includes a display control step of arranging and displaying in a list on a display unit in a chronological order in a column direction the purchase data and the state transition data having the same lot number or the same lot trace number based on the time information.

[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 form purchase data in which unique lot numbers for inventory management of the stocked products, and lot trace numbers obtained by adding branch numbers to the lot numbers, are associated with product information including the number of stocked products, and store the purchase data in a storage unit; an inventory management unit that, when a product is moved or processed, creates an inventory file indicating the number of the moved or processed product and the number obtained by subtracting the number of the moved or processed product from the number of the stocked product, and stores the inventory file in the storage unit; a state transition correspondence storage control unit that forms state transition data in which the number of the moved or processed product is associated with the same product information as at the time of stocking, the same lot number as at the time of stocking, and a lot trace number formed by adding a sequential number to the branch number at the time of stocking with respect to the same lot number as at the time of stocking, and stores the state transition data in the storage unit together with the purchase data and the inventory file, and causes the computer to function as such. The purchase data storage control unit and the state transition correspondence storage control unit form purchase data or state transition data further associated with arbitrary remarks information regarding the product, and store the data in the storage unit. Time information indicating the purchase date of the product is added to the purchase data, and time information indicating the movement date or processing date of the product is added to the state transition data. The computer is caused to function as a display control unit that arranges, in chronological order and in a column direction, the purchase data and the state transition data having the same lot number or the same lot trace number, and displays them in a list on a display unit.

Advantages of the Invention

[0010] According to the present invention, when a product is moved or processed by the same purchase, there is an effect that the original product can be easily specified along the time series.

Brief Description of the Drawings

[0011]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Embodiments for Carrying Out the Invention

[0012] Hereinafter, a business support device according to an embodiment to which the present invention is applied will be described in detail with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0013] [Hardware Configuration] First, FIG. 1 is a block diagram showing the hardware configuration of the business support device 1 according to the embodiment. As the business support device 1, in addition to a desktop personal computer device, a notebook personal computer device or a tablet personal computer device can be used. Further, as the business support device 1, a portable information processing device such as a PDA (Personal Digital Assistants) device or a smartphone can be used. Such a business 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. As the output device 7, a monitor device (including a home television) can be used. As the input device 6, in addition to a keyboard device, a mouse device, and a microphone device, a monitor device that realizes a pointing device function in cooperation with the mouse device can be used.

[0015] As the storage unit 2, 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) can be used. The storage unit 2 stores an inventory management program 11 that enables the aging management of all stocked products. Further, purchase data, inventory files, lot detail data, lot trace data, movement data, processing payout data, and processing acceptance data are stored in the storage unit 2. Details will be described later.

[0016] [Functional Configuration] By executing the inventory management program 11 stored in the storage unit 2, the control unit 3 realizes the functions of the input processing unit 21, the number generation unit 22, the inventory file processing unit 23, and the lot detail data processing unit 24. Also, by executing the inventory management program 11, the control unit 3 realizes the functions of the lot trace data processing unit 25, the movement data processing unit 26, the processing payout data processing unit 27, the processing acceptance data control unit 28, and the display control unit 29.

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

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

[0019] (Creation process of various data at the time of purchase) First, when purchasing a product, 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 performs an input operation of desired data on this purchase data input screen via the input device 6. In step S1, the display control unit 29 monitors whether there is a display operation of the purchase data input screen performed by the business operator or the like, and when a 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 purchase data in response to the purchase input operation of the business operator. Also, in step S2, the number generation unit 22 automatically numbers a predetermined number and performs input processing on the purchase data. This purchase data is stored in the storage unit 2.

[0020] As shown in FIG. 3, the procurement data displayed on the procurement data input screen has data of "input items" manually input by the business operator and data of "automatic setting" into which numbers automatically generated by the number generation unit 22 are input. Also, the procurement number and the line number are automatically generated by the number generation unit 22 at the start of display of the procurement data input screen, and are input into each item of the procurement number and the line number by the input processing unit 21.

[0021] In FIG. 3, the procurement 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 procurement date as "2021061800001" and is input by the input processing unit 21 (automatic setting). The name of the receiving warehouse where the product of "Tokyo Warehouse" is received is manually input and operated by the business operator and is input by the input processing unit 21.

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

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

[0024] Also, in the case of the business support device 1 of the embodiment, it is possible to add attribute information and remarks information to the lot number and the lot trace number, enabling more detailed inventory management. That is, the purchase data is provided with items for the first lot attribute to the third lot attribute for inputting the attribute information of the product at the time of receipt. The first lot attribute to the third lot attribute are manually input by the business operator and 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 input into the corresponding items by the input processing unit 21. The example in FIG. 3 shows an example in which remarks information indicating the supplier of the product, "purchased from Supplier A", is input by the business operator for the first lot remarks.

[0025] Also, in the purchase data, for some of the received products when they are moved or processed, items for the first lot trace attribute to the third lot trace attribute, and the first lot trace remarks to the third lot trace remarks are provided for inputting attribute information or remarks information. As will be described below, when the product is moved or processed, the business operator inputs into the items of each lot trace attribute and each lot trace remarks.

[0026] Next, based on the purchase data created in this way, 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 the inventory file created by the inventory file processing unit 23. As shown in FIG. 4, the inventory file has items such as product name, lot number, warehouse name, lot trace number, and quantity. The inventory file processing unit 23 acquires the data input to the items corresponding to each item of the inventory file from the above-mentioned purchase data and inputs it to the corresponding item of the inventory file. The example shown in FIG. 4 shows an example in which, based on the purchase data, "Product A" is input to the product name, "2021061800001" is input to the lot number, "Tokyo Warehouse" is input to the warehouse name, "2021061800001-001" is input to the lot trace number, and "100" is input to the quantity. Such an inventory file is stored in the storage 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, available shipment date, first to third attribute information, and first to third remarks information.

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

[0030] FIG. 6 is a diagram showing an example of the lot trace data created by the lot trace data processing unit 25. As shown in FIG. 6, the lot trace data has items such as warehouse name, lot trace number, invoice number, line number, arrival date, initial arrival quantity, first to third attribute information, and first to third remarks information.

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

[0032] (Creation process of various data when moving some products) Next, when some of the stocked products 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 the product to 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 there is a display operation of the movement data input screen performed by the business operator or the like, and when a 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 an input process of movement data (an example of state transition data) in response to the input operation and automatic numbering process of the movement data by the business operator.

[0033] FIG. 7 is an example of movement data. As shown in this FIG. 7, the movement data is composed of items such as paragraph number, line number, movement date, product name, shipping warehouse, lot number, outbound lot trace number, inbound lot trace number, movement quantity, first lot trace attribute to third lot trace attribute, and first lot trace remarks to third lot trace 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 outgoing lot trace number are items input by the business operator. The example in Figure 7 shows the movement data created when 30 out of 100 items of Product A purchased at the Tokyo warehouse were moved to the Osaka warehouse on June 23, 2021.

[0035] Therefore, "June 23, 2021" is input as the movement date, "Product A" is input as the product name, "Tokyo warehouse" is input as the shipping warehouse, "2021061800001" is input as the lot number, "2021061800001-001" is input as the outgoing lot trace number, and "30" is input as the quantity moved by the business operator. The lot number input is the same as the lot number automatically set at the time of purchase (see Figure 3). Also, the outgoing lot trace number input is the same as the lot trace number automatically set at the time of purchase.

[0036] On the other hand, the incoming lot trace number is data that is newly created due to the movement of the product, so to speak, data unique to the product movement. As shown in Figure 7, the movement data processing unit 25 creates an incoming lot trace number by attaching the branch number "002" corresponding to the movement to the lot number at the time of purchase of the product being moved, and inputs it into the movement data (automatically set). As a result, the 30 moved products will be managed with the unique identification number "2021061800001-002".

[0037] Also, as shown in Figure 7, the business operator inputs the remarks information "Tokyo warehouse → Osaka warehouse", which indicates that the product has been moved from the Tokyo warehouse to the Osaka warehouse, into the first lot trace remarks. 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 storage unit 2.

[0038] Also, when the product is moved, the movement data processing unit 25 updates the inventory file created at the time of purchase according to the movement of the product based on the movement data shown in FIG. 7, creates a new inventory file corresponding to this movement, and stores it in the storage unit 2 in a manner of adding it after the line of the inventory file created at the time of purchase.

[0039] FIG. 8 is a diagram showing an example of the inventory file updated corresponding to the movement and the newly created inventory file. Among the two lines of inventory files shown in this FIG. 8, the inventory file in the first line is the inventory file created at the time of purchasing the product. In this example, since 30 products were moved, the movement data processing unit 25 (an example of the inventory management unit) creates an inventory file in which the quantity of the inventory file created at the time of purchasing the product is updated (subtraction processing) from 100 to 70. Also, the movement data processing unit 25 newly creates an inventory file 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 inventory file corresponding to the movement as the inventory file in the second line following the inventory file at the time of purchase in the storage unit 2.

[0040] Also, when the 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 FIG. 7, and stores it in the storage unit 2 in a manner of adding it after the line of the inventory file created at the time of purchase.

[0041] FIG. 9 is a diagram showing an example of the newly created lot trace data corresponding to the movement. Among the two lines of lot trace data shown in this FIG. 9, the lot trace data in the first line is the lot trace data created at the time of purchasing the product. The movement data processing unit 25 newly creates 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 storage unit 2 as the lot trace data in the second line following the lot trace data at the time of purchase.

[0042] Incidentally, when the 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] (Creation process of various data during processing of some goods) Next, when some of the received goods are processed, the business operator performs a display operation of the processing issue data input screen and the processing receipt data input screen via the input device 6. In response to this display operation, the display control unit 29 controls the output device 7 to display the processing issue data input screen shown in FIG. 10 or the processing receipt data input screen shown in FIG. 11. The business operator inputs data related to the processing of the goods via the input device 6 to the processing issue data input screen and the processing receipt data input screen. The processing issue data and the processing receipt data are an example of state transition data.

[0044] In step S4 of the flowchart in FIG. 2, the display control unit 29 monitors whether there is a display operation of the processing input screen, which is the processing issue data input screen or the processing receipt data input screen, performed by the business operator or the like. 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 processing issue data input screen or the processing receipt data input screen, and the processing issue data processing unit 27 or the processing receipt data processing unit 28 performs an input process of the processing data in response to the input operation and automatic numbering process of the processing data by the business operator.

[0045] FIG. 10 is a diagram showing an example of processing issue data. This processing issue data indicates how many of the currently stocked goods have been issued for processing. As shown in FIG. 10, the business operator inputs, via the input device 6, for example, the processing date such as "June 25, 2021" and the product name of the goods issued for processing from the inventory such as "Product A".

[0046] In addition, the business operator inputs, via the input device 6, the name of the warehouse such as "Tokyo Warehouse" where the goods were shipped out, and the shipping lot number such as "2021061800001" which is the lot number attached to the goods shipped out for processing. Also, the business operator inputs, via the input device 6, the shipping lot trace number such as "2021061800001-001" which is the lot trace number attached to the goods shipped out for processing. Furthermore, the business operator inputs, via the input device 6, the number of goods (20 pieces) shipped out for processing this time.

[0047] In response to such an input operation by the business operator, the processing shipment data processing unit 27 creates the processing shipment data shown in FIG. 10 and stores it in the storage unit 2. Note that the processing shipment number and line number of the processing shipment data are automatically numbered and input by the processing shipment data processing unit 27 when the processing shipment data input screen is displayed.

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

[0049] In addition, the business operator inputs, in the first lot remarks, remarks information indicating the supplier of the processed goods, such as "Purchased from Supplier A". Furthermore, the business operator inputs, in the first lot trace remarks, remarks information indicating "processing lot number". By inputting such remarks information, the supplier of the goods that are the source of the processed goods can be confirmed at a later date.

[0050] In addition, as shown in FIG. 11, the processed product received by the processing acceptance data processing unit 28 has the lot number "2021061800001" attached at the time of purchase input into the processing acceptance data as the received lot number (automatic installation). Also, for the processed product, the processing acceptance data processing unit 28 creates a received lot trace number by attaching the branch number "003" corresponding to the processing to the lot number "2021061800001" attached at the time of purchase and inputs it into the processing acceptance data (automatic setting). As a result, the 20 processed products will be managed with the unique identification number "2021061800001-003".

[0051] In response to such an input operation by the business operator, the processing acceptance data processing unit 28 creates the processing acceptance data shown in FIG. 11 and stores it in the storage unit 2. Note that the processing acceptance number and line number of the processing acceptance data are automatically numbered and input by the processing payment data processing unit 27 when the processing payment data input screen is displayed.

[0052] Also, when the product is processed, the processing acceptance data processing unit 28 (it may also be the processing payment data processing unit 27) updates the inventory file created at the time of purchase according to the number of processed products based on the processing acceptance data shown in FIG. 11, creates a new inventory file corresponding to this processing, and stores it in the storage unit 2 by adding it after the inventory file created at the time of purchase and the inventory file created at the time of movement.

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

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

[0055] FIG. 13 is a diagram showing the lot detail data created at the time of purchasing and the newly created lot detail data corresponding to 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 product after processing such as "Product B", the lot number of the product before processing 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. Also, the processing acceptance data processing unit 28 newly creates the available shipment date of the processed product such as "June 25, 2021" and the remarks information such as "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 processing newly created in this way in the storage unit 2 as the lot detail data in the second line following the lot detail data at the time of purchasing.

[0056] Also, when the product is processed, the processing acceptance data processing unit 28 creates new lot trace data corresponding to this processing based on the processing payout data shown in FIG. 10 and the processing acceptance data shown in FIG. 11, and stores it in the storage unit 2 by adding it to the line after the inventory file created during movement.

[0057] FIG. 14 is a diagram showing an example of the lot trace data newly created corresponding to the processing. Among the three lines of lot trace data shown in FIG. 14, the lot trace data in the first line is the lot trace data created at the time of purchasing the product. The processing acceptance data processing unit 28 newly creates lot trace data with a lot trace number of "2021061800001-003" corresponding to 20 products B received at the Tokyo warehouse. Then, the processing acceptance data processing unit 28 stores the lot trace data corresponding to the newly created movement in the storage unit 2 as the lot trace data in the third line following the lot trace data at the time of movement.

[0058] (Display operation of the inquiry screen) Next, in step S5 of the flowchart in FIG. 2, the display control unit 29 monitors whether there is a display operation of the inquiry screen by the business operator. When a display operation of the inquiry screen is detected (step S5: Yes), the process proceeds to step S8, and the display control unit 29 displays the inquiry screen for which display is instructed on the output device 7.

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

[0060] The inventory inquiry data is formed to include, for example, product name, lot number, warehouse name, lot trace number, quantity, expiration date, available shipment 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 the column direction along the time series, the flow of inventory products due to the purchase, movement, and processing of products can be recognized.

[0061] Specifically, in the example of Figure 15, it can be recognized that 100 pieces of product A purchased from supplier A currently have 50 pieces remaining in stock in the Tokyo warehouse, and among the other 50 pieces, 30 pieces have been moved to the Osaka warehouse and 20 pieces have been processed into product B and are stored in the Tokyo warehouse. Therefore, in the case where there is a problem with the product, etc., the progress information of the products received at the same time can be confirmed at once. That is, by extracting with the lot number, it is possible to confirm at once what state (such as being processed into another product) the products received by the same purchase are in and where they are stored.

[0062] Also, even for products of the same purchase, different lot trace numbers such as "2021061800001-001" to "2021061800001-003" are added due to movement and processing, so products can be managed by adding different remarks information, and product management can be performed in more detail.

[0063] Next, FIG. 16 is an example of the display of the payment history inquiry screen (payment history inquiry data). The example in FIG. 16 is an example where the business operator specified the lot number of "2021061800001" to inquire about the payment history. Further, FIG. 18 is a diagram showing the method of acquiring various data by data classification and by payment when the display control unit 29 forms the payment history inquiry screen.

[0064] As shown in FIG. 18, when forming the payment history inquiry data where the data classification is "purchase" and the payment is "receipt", 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 detailed 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 lot number specified by the business operator and the warehouse corresponding to this lot number. The display control unit 29 forms the payment history inquiry data shown in the first row of FIG. 16, where the data classification is "purchase", the payment is "receipt", and the purchase quantity is 100 pieces, based on the acquired lot detailed data and lot trace data.

[0065] Also, as shown in FIG. 18, when forming payment history inquiry data where the data classification is "movement" and the payment is "payment out", the display control unit 29 refers to the movement data shown in FIG. 7 based on the lot number of "2021061800001", and recognizes the product, shipping warehouse, and shipping 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 designated 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 shipping lot trace data of the movement data recognized based on the lot number designated by the business operator. The display control unit 29 forms payment history inquiry data where the data classification is "movement", the payment is "payment out", and the quantity of payment out is 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 payment history inquiry data where the data classification is "movement" and the payment is "receipt", the display control unit 29 refers to the movement data shown in FIG. 7 based on the lot number of "2021061800001", and recognizes the product, receiving warehouse, and receiving 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 designated 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 receiving warehouse and receiving lot trace data of the movement data recognized based on the lot number designated by the business operator. The display control unit 29 forms payment history inquiry data where the data classification is "movement", the payment is "receipt", and the destination warehouse is 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 payment history inquiry data where the data classification is "processing" and the payment is "payment out", the display control unit 29 refers to the processed payment out data shown in FIG. 10 based on the lot number "2021061800001", and recognizes the payment out products, payment out warehouse, and payment out lot trace data corresponding to this lot number (payment out lot number). Then, the display control unit 29 acquires the lot detailed data shown in FIG. 13 based on the recognized payment out lot number and the payment out products corresponding to this payment out lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the payment out warehouse and payment out lot trace data of the processed payment out data recognized based on the lot number designated by the business operator. The display control unit 29 forms payment history inquiry data shown in the 4th row of FIG. 16, where the data classification is "processing", the payment is "payment out", and the product A is paid out from the Tokyo warehouse.

[0068] Also, as shown in FIG. 18, when forming payment history inquiry data where the data classification is "processing" and the payment is "receipt", the display control unit 29 refers to the processed receipt data shown in FIG. 10 based on the lot number "2021061800001", and recognizes the received products (product B), received warehouse, and received lot trace data corresponding to this lot number (receipt lot number). Then, the display control unit 29 acquires the lot detailed data of product B shown in FIG. 13 based on the recognized receipt lot number and the received products corresponding to this receipt lot number. Also, the display control unit 29 acquires the lot trace data shown in FIG. 14 based on the received warehouse and received lot trace data of the processed receipt data recognized based on the lot number designated by the business operator. The display control unit 29 forms payment history inquiry data shown in the 5th row of FIG. 16, where the data classification is "processing", the payment is "receipt", and product B is received by the Tokyo warehouse after processing.

[0069] The above example is an example where the business operator specified the lot trace number "2021061800001" to inquire about the payment history. However, Fig. 17 is an example where the business operator specified the lot trace number "2021061800001-001" to inquire about the payment history. The same applies in this case. 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 an inquiry about the payment history corresponding to the lot trace number "2021061800001-001".

[0070] When an inquiry about the payment history is made by specifying this lot trace number, the display control unit 29 extracts the lot detail data and lot trace data with the lot trace number "2021061800001-001" as shown in Fig. 17 to form payment history inquiry data. Therefore, the lot detail data and lot trace data corresponding to the lot trace number "2021061800001-002" due to the above-mentioned movement and the lot trace number "2021061800001-003" due to the above-mentioned processing are not included, and payment history inquiry data is formed.

[0071] The business support device 1 of the embodiment repeatedly executes the operations of steps S1 to S8 in the flowchart of Fig. 2 according to the operation of the business operator.

[0072] [Effect of the Embodiment] As is clear from the above description, the business support device 1 of 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 the inventory detail information in units of product lots, by enabling information management in units of branch numbers, inventory information can be held from these two perspectives.

[0074] In addition, by assigning branch numbers to the same lot and holding management information (such as remarks information) for each branch number, it is possible to manage information in units of product lots and simultaneously manage additional information generated by movement, processing, or the like.

[0075] In addition, the branch numbers for each lot are automatically numbered and input according to a certain rule. Therefore, it is possible to prevent inconveniences such as input errors caused by manual input by the business operator.

[0076] [Contribution to the Sustainable Development Goals (SDGs) led by the United Nations] According to this embodiment, it is possible to contribute to improving business efficiency and making appropriate business judgments for enterprises, so it is possible to contribute to Goals 8 and 9 of the SDGs.

[0077] In addition, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0078] In addition, according to this embodiment, it is possible to contribute to strengthening control and governance, so it is possible to contribute to Goal 16 of the SDGs.

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

[0080] For example, in the above-described embodiments, the sale of products has been described as an example, but when providing a predetermined service, the same operations as described above can be performed to obtain the same effects.

[0081] For example, among the processes described in the embodiments as being automatically performed, all or part of the processes can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0082] In addition, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.

[0083] Regarding the journal entry input system, each illustrated component is a functional concept and does not necessarily need to be physically configured as shown in the drawings.

[0084] For example, regarding the processing functions provided by the business support device 1, particularly each processing function performed by the control unit 3 and the control unit 3, all or any part of them may be realized by a CPU (Central Processing Unit) and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. The program is recorded in a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 1 as necessary. That is, in a storage unit such as a ROM or HDD, a computer program for giving commands to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit 3 in cooperation with the CPU.

[0085] In addition, this inventory management program, which is a computer program, may be stored in another server device connected to the business support device 1 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0087] Also, a "program" is a data processing method described in any language or description method, and is not limited to forms such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

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

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

[0090] Furthermore, the specific forms of the distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or function additions. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0091] The present invention is useful for creating work sheets for inventory management of products.

Explanation of Signs

[0092] 1 Business support device 2 Storage unit 3 Control unit 4 Communication interface unit 5 Input / output interface unit 6 Input device 7 Output device 11 Inventory management program 21 Input processing unit 22 Number generation unit 23 Inventory file processing unit 24 Lot detail data processing unit 25 Lot trace data processing unit 26 Movement data processing unit 27 Processing issue data processing unit 28 Processing acceptance data processing unit 29 Display control unit

Claims

1. A purchase data storage control unit that forms and stores in a storage unit purchase data in which a unique lot number for inventory management of the received goods and a lot trace number obtained by adding a branch number to the lot number are associated with product information including the number of received goods; An inventory management unit that, when the movement or processing of the product is performed, creates an inventory file indicating the number of moved or processed products and the number obtained by subtracting the number of moved or processed products from the number of received products, and stores the inventory file in the storage unit; A state transition correspondence storage control unit that forms state transition data in which the number of moved or processed products is associated with the same product information as at the time of receipt, the same lot number as at the time of receipt, and a lot trace number formed by attaching a sequential branch number to the same lot number as at the time of receipt for the branch number at the time of receipt, and stores the state transition data in the storage unit together with the purchase data and the inventory file; 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 remarks information regarding the product, and store the data in the storage unit; Time information indicating the purchase date of the product is added to the purchase data, and time information indicating the movement date or the processing date of the product is added to the state transition data; Further comprising a display control unit that arranges and displays in a list in the display unit in chronological order in the column direction the purchase data and the state transition data having the same lot number or the same lot trace number based on the time information; A business support device characterized by the above.

2. The remarks information is the supplier of the product, the moving warehouse that is the destination of the product movement, or the processing lot number. The business support device according to claim 1, characterized by the above.

3. A purchase data storage control step in which a purchase data storage control unit forms and stores in a storage unit purchase data in which a unique lot number for inventory management of the received goods and a lot trace number obtained by adding a branch number to the lot number are associated with product information including the number of received goods; An inventory management step in which an inventory management unit, when the movement or processing of the product is performed, creates an inventory file indicating the number of moved or processed products and the number obtained by subtracting the number of moved or processed products from the number of received products, and stores the inventory file in the storage unit; The state transition corresponding memory control unit forms state transition data in which the lot trace number formed by associating the number of the goods that have been moved or processed with the same goods information as at the time of warehousing, the same lot number as at the time of warehousing, and a branch number that is a serial number with respect to the branch number at the time of warehousing for the same lot number is associated, and stores the state transition data together with the purchase data and the inventory file in the memory unit, the state transition corresponding memory control step, In the purchase data storage control step and the state transition corresponding memory control step, arbitrary remarks information regarding the goods is further associated to form the purchase data or the state transition data, and is stored in the memory unit, Time information indicating the purchase date of the goods is added to the purchase data, and time information indicating the movement date or the processing date of the goods is added to the state transition data, The display control unit further includes a display control step of arranging the purchase data and the state transition data having the same lot number or the same lot trace number in chronological order in a column direction based on the time information and displaying them in a list on the display unit, A business support method characterized by the above.

4. A computer, A purchase data storage control unit that forms purchase data in which the goods information including the number of the warehoused goods is associated with a unique lot number for inventory management of the warehoused goods and a lot trace number obtained by adding a branch number to the lot number, and stores the purchase data in a memory unit, An inventory management unit that creates an inventory file indicating the number of the goods that have been moved or processed and the number obtained by subtracting the number of the goods that have been moved or processed from the number of the warehoused goods when the goods are moved or processed, and stores the inventory file in the memory unit, Function as a state transition corresponding memory control unit that forms state transition data in which the number of the goods that have been moved or processed is associated with the same goods 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 a serial number with respect to the branch number at the time of warehousing for the same lot number, and stores the state transition data together with the purchase data and the inventory file in the memory unit, The purchase data storage control unit and the state transition corresponding memory control unit form the purchase data or the state transition data further associated with arbitrary remarks information regarding the goods, and store the purchase data or the state transition data in the memory unit, The purchase data is appended with time information indicating the purchase date of the product, and the state transition data is appended with time information indicating the transfer date or the processing date of the product. Functioning the computer as a display control unit that arranges and displays in a list on a display unit in columnar order in chronological sequence, based on time information, the purchase data and the state transition data having the same lot number or the same lot trace number. A business support program characterized by the above.

Images