Unit conversion device, unit conversion method, and unit conversion program
By providing conversion source unit information, conversion target unit information, conversion condition information and corresponding coefficients, the problem of conversion of commodity processing units under different accounting formats is solved, and the easy conversion of commodity processing units and the improvement of data accuracy and efficiency is achieved.
Patent Information
- Application Number
- JP2023167800
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-09-28
- Publication Date
- 2025-04-09
Smart Images

Figure 2025057947000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to a unit conversion device, a unit conversion method, and a unit conversion program. [Background technology]
[0002] Nowadays, there are products that are handled in different units depending on the accounting format, such as the units used when inputting purchases, sales, and inventory management. One example is gas products such as oxygen, nitrogen, and carbon dioxide.
[0003] Patent Document 1 (JP Patent Publication 2009-230623 A) discloses a unit conversion coefficient changing device, which automatically sets conversion coefficients in response to changes in units for multiple databases that store drug data including multiple units and conversion coefficients between at least some of the multiple units in association with drug identifiers.
[0004] Also, a designation of a changed unit is accepted for a specific unit for a specific drug identifier in a specific database among the multiple databases, and a relational conversion coefficient relating to a relationship between the specific unit and the changed unit for the specific drug identifier is extracted from the multiple databases, and a conversion coefficient relating to the specific unit of the specific drug identifier is extracted from the specific database.
[0005] Then, the conversion coefficient value for the changed unit is calculated from the extracted relational conversion coefficient and the conversion coefficient for the specific unit, and is set in a specific database together with the changed unit. This makes it possible to automatically change the conversion coefficient required when changing a specific unit among multiple units set in the system. [Prior art documents] [Patent documents]
[0006] [Patent Document 1] JP 2009-230623 A Summary of the Invention [Problem to be solved by the invention]
[0007] There is a need for technology that can easily convert the units of a product that are handled in different units depending on the accounting format into a handling amount in a desired unit depending on the accounting format.
[0008] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a unit conversion device, a unit conversion method, and a unit conversion program that can easily convert the handling volume of a product into the handling volume of a desired unit depending on the accounting form. [Means for solving the problem]
[0009] In order to solve the above-mentioned problems and achieve the object, the unit conversion device of the present invention has at least source unit information indicating the source unit, which is the unit before unit conversion of each product, destination unit information indicating the destination unit, which is the unit after unit conversion of each product, condition information indicating the conditions for converting the source unit to the destination unit, and a conversion coefficient corresponding to the condition information input at the time of recording input from a memory unit storing conversion coefficients which are coefficients according to the condition information and are multiplied by the recorded quantity of the product in the source unit when converting the recorded quantity of the product in the source unit to the recorded quantity of the destination unit, a calculation unit which calculates the recorded quantity of the destination unit by multiplying the acquired conversion coefficient by the recorded quantity of the product in the source unit input at the time of recording input, and an output control unit which controls the output of the unit converted recorded quantity including the calculated recorded quantity of the destination unit via an external device.
[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the unit conversion method of the present invention includes at least: source unit information indicating the source unit, which is the unit before unit conversion of each product; destination unit information indicating the destination unit, which is the unit after unit conversion of each product; condition information indicating the conditions for converting the source unit to the destination unit; and a coefficient according to the condition information, an acquisition step in which an acquisition unit acquires a conversion coefficient corresponding to the condition information input at the time of recording input from a memory unit in which a conversion coefficient is stored, the conversion coefficient being multiplied by the recorded quantity of the product in the source unit when converting the recorded quantity of the product in the source unit to the recorded quantity of the destination unit; a calculation step in which a calculation unit calculates the recorded quantity of the destination unit by multiplying the acquired conversion coefficient by the recorded quantity of the product in the source unit input at the time of recording input; and an output control step in which an output control unit controls the output of the unit converted recorded quantity including the calculated recorded quantity of the destination unit via an external device.
[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the unit conversion program of the present invention causes a computer to function as an acquisition unit that acquires a conversion coefficient corresponding to the condition information input at the time of recording input from a memory unit that stores at least conversion source unit information indicating the conversion source unit, which is the unit before unit conversion of each product, conversion destination unit information indicating the destination unit, which is the unit after unit conversion of each product, condition information indicating the conditions for converting the conversion source unit to the destination unit, and a conversion coefficient that is a coefficient according to the condition information and is multiplied by the recorded quantity of the product in the conversion source unit when converting the recorded quantity of the conversion source unit to the recorded quantity of the destination unit, a calculation unit that calculates the recorded quantity of the destination unit by multiplying the acquired conversion coefficient by the recorded quantity of the product in the conversion source unit input at the time of recording input, and an output control unit that controls the output of the unit converted recorded quantity including the calculated recorded quantity of the destination unit via an external device. Effect of the Invention
[0012] The present invention can easily convert the handling volume of a commodity into a desired unit of handling volume depending on the accounting format. [Brief description of the drawings]
[0013] [Figure 1] FIG. 1 is a block diagram showing a hardware configuration of an inventory management device according to an embodiment of the present invention. [Diagram 2] FIG. 2 is a diagram showing buying and selling units, inventory management units, and performance management units according to gas products. [Diagram 3] FIG. 3 is a diagram illustrating an example of the product master. [Figure 4] FIG. 4 is a diagram illustrating an example of the product type master. [Diagram 5] FIG. 5 is a diagram illustrating an example of the unit master. [Figure 6] FIG. 6 is a diagram illustrating an example of the warehouse master. [Figure 7] FIG. 7 is an example of the unit conversion master, showing the first half of the unit conversion master. [Figure 8] FIG. 8 is an example of the unit conversion master, showing the latter half of the unit conversion master. [Figure 9] FIG. 9 is a diagram showing an example of input to the maintenance screen of the unit conversion master. [Figure 10] FIG. 10 is a diagram showing another example of input to the maintenance screen of the unit conversion master. [Figure 11] FIG. 11 is a diagram showing how oxygen gas is stored in a large tank from a tank truck. [Figure 12] FIG. 12 is a diagram showing how oxygen gas is filled from a large tank into an oxygen gas cylinder. [Figure 13] FIG. 13 is a diagram for explaining the purchase input process of oxygen gas cylinders for the Sapporo warehouse. [Figure 14] FIG. 14 is a diagram showing how liquefied oxygen is loaded from a large tank onto a tank truck. [Figure 15] FIG. 15 is a diagram for explaining the purchase input process of liquefied oxygen for the Sapporo warehouse in January. [Figure 16] FIG. 16 is a diagram showing purchase detail data indicating the number of oxygen gas cylinders and liquefied oxygen purchased for the Sapporo warehouse. [Figure 17] FIG. 17 is a diagram showing inventory data indicating the inventory numbers of oxygen gas cylinders and liquefied oxygen at the Sapporo warehouse. [Figure 18] FIG. 18 shows the shipment of 10 oxygen gas cylinders from the Sapporo warehouse in March. [Figure 19] FIG. 19 is a diagram for explaining the sales input process for 10 oxygen gas cylinders shipped from the Sapporo warehouse in March. [Figure 20] FIG. 20 shows how liquefied oxygen is loaded onto a tank truck and shipped from the Sapporo warehouse in March. [Figure 21] FIG. 21 is a diagram for explaining the sales input process for the shipment of liquefied oxygen from the Sapporo warehouse in a tanker truck in March. [Figure 22] FIG. 22 is a diagram showing sales detail data indicating the sales quantity of oxygen gas cylinders and liquefied oxygen shipped from the Sapporo warehouse in March. [Diagram 23] FIG. 23 is a diagram showing inventory data indicating that the inventory quantities of oxygen gas cylinders and liquefied oxygen at the Sapporo warehouse became zero due to shipment in March. [Figure 24] FIG. 24 is a diagram showing purchase detail data indicating the quantities of oxygen gas cylinders and liquefied oxygen to be procured for the Okinawa warehouse in response to sales scheduled for March. [Diagram 25] FIG. 25 is a diagram showing inventory data indicating the inventory numbers of oxygen gas cylinders and liquefied oxygen in the Okinawa warehouse, based on the oxygen gas cylinders and liquefied oxygen procured for sales scheduled for March. [Figure 26] FIG. 26 is a diagram showing sales statement data corresponding to the shipment numbers of oxygen gas cylinders and liquefied oxygen shipped from the Okinawa warehouse in March. [Figure 27] FIG. 27 is a diagram showing the inventory data of the Okinawa warehouse where the inventory quantity became zero due to the shipment of oxygen gas cylinders and liquefied oxygen in March. [Figure 28]FIG. 28 shows an example of the aggregated sales detail data for oxygen gas cylinders and liquefied oxygen at the Sapporo warehouse and the Okinawa warehouse for March, and an example of the monthly sales report for March for oxygen produced based on the aggregated sales detail data. [Figure 29] FIG. 29 is a diagram showing an example of a monthly sales report for nitrogen for March that is generated based on the collected sales detail data for nitrogen gas cylinders and liquefied nitrogen for the Sapporo warehouse and the Okinawa warehouse for March. [Diagram 30] FIG. 30 is a diagram showing purchase detail data for oxygen gas cylinders and liquefied oxygen purchased for the Sapporo warehouse in July. [Diagram 31] FIG. 31 is a diagram showing inventory data indicating the inventory quantities of oxygen gas cylinders and liquefied oxygen purchased in July at the Sapporo warehouse. [Diagram 32] FIG. 32 is a diagram showing sales data of oxygen gas cylinders and liquefied oxygen sold by the Sapporo warehouse in July. [Diagram 33] FIG. 33 is a diagram showing inventory data for the Sapporo Warehouse, which indicates that the inventory quantity became 0 due to the sale of oxygen gas cylinders and liquefied oxygen from the Sapporo Warehouse in July. [Diagram 34] FIG. 34 is a diagram showing purchase detail data for oxygen gas cylinders and liquefied oxygen purchased for the Okinawa warehouse in July. [Diagram 35] FIG. 35 is a diagram showing inventory data indicating the inventory quantities of oxygen gas cylinders and liquefied oxygen purchased in July at the Okinawa warehouse. [Diagram 36] FIG. 36 is a diagram showing sales data of oxygen gas cylinders and liquefied oxygen sold from the Okinawa warehouse in July. [Figure 37] FIG. 37 is a diagram showing inventory data for the Okinawa warehouse, which indicates that the inventory quantity became 0 due to the sale of oxygen gas cylinders and liquefied oxygen from the Okinawa warehouse in July. [Figure 38] Figure 38 shows an example of the July sales detail data for oxygen gas cylinders and liquefied oxygen at the Sapporo warehouse and the Okinawa warehouse, and an example of the July monthly sales report for oxygen produced based on the aggregated sales detail data. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0014] As an example, the present invention is applied to an inventory management device that supports inventory management of gas products, and will be described in detail below as an embodiment with reference to the drawings. Note that the present invention is not limited to the following embodiment, and may be applied to devices other than inventory management devices, such as devices that perform accounting input processing, such as purchase input and sales input. Also, the present invention may be applied to unit conversion processing for products other than gas products, such as water, gasoline, etc., whose handling units differ depending on the accounting format. In any case, the present invention functions effectively and can obtain the same effects as those described below.
[0015] (overview) Nowadays, gas products are managed in different ways, for example, filled in gas cylinders or in tank trucks, and the inventory management units are not standardized even for the same gas product. In order to capture the unit of sales performance at the time of closing processing, it is preferable to use the same unit as the inventory management unit, but the unit handled at the time of closing processing and the unit of inventory management are often different units.
[0016] It is possible to manage inventory in the units used during closing processing, but in this case, there is a problem that conversion is required to grasp inventory at the time of inventory. Also, when calculating the trading volume of gas products, for example, a conversion factor is used to convert from a volume unit (cubic meters) to a weight unit (kilograms). However, even for the same gas type, differences in conversion factors can occur depending on the base (storage location such as a warehouse) or seasonal temperature, making accurate conversion difficult and resulting in discrepancies in inventory numbers.
[0017] For this reason, in the inventory management device of the embodiment, a unit conversion quantity is set for each gas type (product), unit, month (season), and base (warehouse), and a conversion coefficient corresponding to the timing of the accounting process is used to convert the buying and selling quantity into the inventory quantity. Also, by converting the inventory quantity into the total quantity, accurate conversion results are stored in the actual data, making it possible to omit conversion during the closing inventory work.
[0018] (Hardware configuration) As shown in FIG. 1, the inventory management device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function. The communication interface unit 4 is connected to a network such as a wide area network such as the Internet or a private network such as a LAN (Local Area Network).
[0019] The storage unit 2 may be, for example, a storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), a HDD (Hard Disk Drive), or an SSD (Solid State Drive). The storage unit 2 stores an inventory management program including a unit conversion program that allows the handling amount of a commodity to be easily converted into the handling amount of a desired unit according to the accounting form. That is, although this is just one example, in this embodiment, the present invention is realized by a function realized by the control unit 3 executing the unit conversion program included in the inventory management program.
[0020] The storage unit 2 also stores a product master 11, a product type master 12, a unit master 13, a warehouse master 14, and a unit conversion master 15, which are each storage areas. The storage unit 2 also stores various data such as purchase statement data, inventory data, and sales statement data.
[0021] Here, the inventory management device 1 of the embodiment handles oxygen gas cylinders, liquefied oxygen, nitrogen gas cylinders, liquefied nitrogen, and carbon dioxide gas cylinders as gas products, as shown in Fig. 2. The inventory management device 1 also supports a sales form in which oxygen gas, nitrogen gas, and carbon dioxide gas are loaded onto a tanker truck and sold.
[0022] The gas type of oxygen gas cylinders and liquefied oxygen is "oxygen." The buying and selling price and inventory management unit of oxygen gas cylinders are "units," which is the number of cylinders, and the performance management unit is "cubic meters," which is a unit of volume. In contrast, the buying and selling unit of liquefied oxygen is "kilograms," which is a unit of weight, and the inventory management unit and performance management unit are "cubic meters," which is a unit of volume.
[0023] The gas type of nitrogen gas cylinders and liquefied oxygen is "nitrogen." The buying and selling price and inventory management unit of nitrogen gas cylinders are "bottles," which is the number of cylinders, and the performance management unit is "cubic meters," which is a unit of volume. Similarly, the buying and selling unit of liquefied nitrogen is "kilograms," which is a unit of weight, and the inventory management unit and performance management unit are "cubic meters," which is a unit of volume.
[0024] The gas type of carbon dioxide is "carbon dioxide gas." The buying and selling price and inventory management unit of carbon dioxide gas are each "bottles," which is the number of cylinders, and the performance management unit is "kilograms," which is a unit of weight. In contrast, when carbon dioxide gas is loaded onto a tanker truck and sold, the gas type is "carbon dioxide gas," but the buying and selling unit, inventory management unit, and performance management unit are each "kilograms," which is a unit of gravity.
[0025] As shown in Fig. 3, the product master 11 stores the product code, product name, variety code, sales unit code, purchase unit code, inventory control unit code, etc. for each of these gas type products. Even if the product is the same oxygen gas cylinder, there are products with a capacity of "7 cubic meters" and products with a capacity of "6 cubic meters". For this reason, the product code for an oxygen gas cylinder with a capacity of "7 cubic meters" is "S001", the product code for an oxygen gas cylinder with a capacity of "6 cubic meters" is "S002", etc., and they are managed as separate products.
[0026] The same product code, "O1: oxygen," is assigned to oxygen gas, a "7 cubic meter" oxygen gas cylinder, a "6 cubic meter" oxygen gas cylinder, and liquefied oxygen. The same is true for nitrogen products, where the same product code, "N1: nitrogen," is assigned to nitrogen gas, a "7 cubic meter" nitrogen gas cylinder, and liquefied nitrogen.
[0027] The buying and selling unit code, purchasing unit code, and inventory management unit code are set for each product. Specifically, in the case of oxygen gas, the buying and selling unit code, purchasing unit code, and inventory management unit code are all set to "01: cubic meters." In addition, in the case of oxygen gas cylinders with capacities of "7 cubic meters" and "6 cubic meters," the buying and selling unit code, purchasing unit code, and inventory management unit code are all set to "03: bottles." In contrast, in the case of liquefied oxygen, the buying and selling unit code and purchasing unit code are each set to "02: kilograms," and the inventory management unit code is set to "01: cubic meters."
[0028] In this example, each unit is set for each product, but each unit may be set for each type. In this case, by managing results by unit, products of the same gas type will have the same type, and the results management units can also be consistent.
[0029] 4, the product type master 12 stores the product type code, product type name, and product type unit code of each product type in association with each other. Specifically, the product type code of oxygen (O1) and the product type code of nitrogen "N1" are associated with the unit "01: cubic meters," and the product type code of carbon dioxide "C1" is associated with the unit "02: kilograms."
[0030] In the unit master 13, unit codes and unit names are registered as shown in Fig. 5. Fig. 5 shows an example in which the unit code "01" indicates the unit of "cubic meters", the unit code "02" indicates the unit of weight "kilograms", and the unit code "03" indicates the unit of quantity "books".
[0031] In the warehouse master 14, warehouse codes and warehouse names are registered as shown in Fig. 6. Fig. 6 shows an example in which the warehouse code "K001" indicates the "Fukuoka Warehouse", the warehouse code "K002" indicates the "Sapporo Warehouse", and the warehouse code "K003" indicates the "Okinawa Warehouse".
[0032] (Unit conversion master) 7 and 8 respectively show the first and second halves of the unit conversion master 15. In this unit conversion master 15, the source unit, destination unit, and conversion coefficient are set by the display control unit 21 via a maintenance screen displayed on the output device 7, for example, for each product, each type, each applicable month (for each desired period, each season), and each warehouse (for each storage location).
[0033] 9, 10(a) and 10(b) show examples of the maintenance screen of the unit conversion master 15. First, FIG. 9 shows an example of the setting of the unit conversion master 15 for an oxygen gas cylinder with a capacity of "7 cubic meters". The maintenance staff refers to the product master 11 to the warehouse master 14 shown in FIGS. 3 to 6, and specifies the desired product as shown in FIG. 9. Then, the staff inputs the desired conversion source unit, conversion destination unit, applicable month (period, season, etc.), warehouse (base, storage location), and conversion coefficient. The master maintenance unit 22 stores each of the input information in the unit conversion master 15 shown in FIGS. 7 and 8.
[0034] The example in Figure 9 is an example in which a conversion coefficient is set to convert the unit of trade quantity of oxygen gas cylinders with a capacity of "7 cubic meters" from the inventory management unit (pieces) to the performance management unit (= aggregation unit: cubic meters) (see Figure 2).
[0035] The conversion coefficient is calculated in advance based on experience in handling gas products. For example, in the case of the oxygen gas cylinder in the example of FIG. 9, since the capacity is "7 cubic meters", a conversion coefficient of "7" is set. That is, as an example, in the case of an oxygen gas cylinder, a conversion coefficient corresponding to the capacity is set. For example, in the case of an oxygen gas cylinder with a capacity of "6 cubic meters", a conversion coefficient of "6" is set.
[0036] As shown in the example of Figure 9, when converting units from quantity to volume, the conversion coefficient is the same even if the application month or warehouse changes, because the application month or warehouse base does not affect the conversion coefficient. In other words, even if the application month or warehouse changes, the conversion coefficient corresponding to the capacity of the oxygen gas cylinder is set as described above.
[0037] 10(a) and 10(b) show an example in which a conversion coefficient for converting the trading volume of liquefied oxygen from the trading volume in the buying and selling unit (weight: kilograms) to the trading volume in the inventory unit (volume: cubic meters) is set in the unit conversion master 15. In this case as well, the person in charge specifies the desired product (in this example, liquefied oxygen) and inputs the desired source unit, destination unit, applicable month (period, season, etc.), warehouse (base, storage location), and conversion coefficient.
[0038] Figure 10(a) is an example where "January" is specified as the applicable month and the Sapporo Warehouse is specified as the warehouse for storing liquefied oxygen. Figure 10(b) is an example where "July" is specified as the applicable month and the Okinawa Warehouse is specified as the warehouse for storing liquefied oxygen.
[0039] In the case of liquefied oxygen, the product is loaded onto a tank truck and delivered directly to the customer's tank. The product is sold and bought by weight (kilograms), but inventory is managed by volume (cubic meters). When converting units from weight to volume, different conversion coefficients are used depending on the applicable month or base (warehouse). That is, in the example of Figure 10(a), the applicable month is "January" and the base is the "Sapporo Warehouse," so a conversion coefficient of "0.700" is used. In contrast, in the example of Figure 10(b), the applicable month is "July" and the base is the "Okinawa Warehouse," so a conversion coefficient of "0.789" is used. There is a large difference in temperature between the Sapporo Warehouse in January and the Okinawa Warehouse in July, so different conversion coefficients are used in this way.
[0040] In this way, the master in which the conversion coefficients are set for each product, each applicable month, and each base (each warehouse or each storage location) is the unit conversion master 15 shown in Figures 7 and 8. When converting from the inventory management unit "quantity: bottles" to the performance management unit "volume: cubic meters" like the oxygen gas cylinders shown in Figure 7, the conversion coefficient does not differ depending on the temperature at the time of conversion, so the conversion coefficient is the same for all units regardless of the applicable month or base (warehouse) ("7" if the capacity is 7 cubic meters, and "6" if the capacity is 6 cubic meters).
[0041] When converting the trading unit "book" to the inventory management unit "book", unit conversion is not required, so the conversion factor is not registered in the unit conversion master 15.
[0042] In addition, when converting from the trading unit "weight: kilograms" to the inventory management unit "volume: cubic meters" as in the case of liquefied oxygen shown in Figure 7, the conversion coefficient differs depending on the temperature as mentioned above, so a different conversion coefficient is set for each applicable month and each base (warehouse).
[0043] (Functional configuration of inventory management device) Next, the control unit 3 executes the inventory management program stored in the memory unit 2, so that, as shown in FIG. 1, the display control unit 21, master maintenance unit 22, acquisition unit 23, calculation unit 24, and output control unit 25 function as a data generation unit 26 and a monthly sales report generation unit 27.
[0044] The display control unit 21 displays the maintenance screen of the unit conversion master 15 described with reference to Fig. 9, Fig. 10(a) and Fig. 10(b) via the output device 7. The master maintenance unit 22 sets (stores) the application month, base (warehouse), conversion coefficient, etc., input for each product via the maintenance screen as described above, in the unit conversion master 15 as shown in Fig. 7 and Fig. 8.
[0045] The acquisition unit 23 acquires a conversion coefficient corresponding to the condition information entered at the time of recording input from a memory unit (corresponding to unit conversion master 15) that stores at least source unit information indicating the source unit, which is the unit before unit conversion of each product, destination unit information indicating the destination unit, which is the unit after unit conversion of each product, condition information indicating the conditions for converting the source unit to the destination unit (information indicating the application month and base (warehouse) for each product in Figure 7), and a conversion coefficient that is a coefficient according to the condition information and is multiplied by the recorded quantity of the product in the source unit when converting the recorded quantity in the source unit to the recorded quantity in the destination unit.
[0046] The calculation unit 24 calculates the recorded quantity in the destination unit by multiplying the acquired conversion coefficient by the recorded quantity of the product in the source unit entered at the time of recording input (e.g., at the time of inputting purchases, sales, inventory management, etc.).
[0047] The output control unit 25 controls the output of the unit converted accounted quantity including the calculated accounted quantity of the conversion destination unit via an external device (corresponding to the output device 7). This output control may be display control on the display unit or printout control via a printer.
[0048] The condition information is information indicating the application period of the conversion coefficient (application month in FIG. 7) and the storage location of the product (warehouse in FIG. 7), and the conversion coefficient is a value corresponding to the application period and the storage location.
[0049] The conversion coefficient is set to a value corresponding to the product type (product type code in FIG. 7), the applicable period (applicable month), and the storage location (base or warehouse).
[0050] In addition, when the goods are transported in a specified container (e.g., a gas cylinder), the conversion factor is set to a value corresponding to the capacity of the container (the above-mentioned 7 cubic meters or 6 cubic meters, etc.), the applicable period, and the storage location.
[0051] The calculation unit 24 also calculates the added and accounted quantities (e.g., sales data) by product and storage location by adding up the unit-converted accounted quantities (e.g., sales data) for a predetermined period. The output control unit 25 controls the output of the calculated added and accounted quantities via an external device (output device 7).
[0052] (Unit conversion operation) The unit conversion operation in the inventory management device 1 of the embodiment will be described below for each accounting input. The inventory management device 1 of the embodiment executes this unit conversion operation based on the inventory management program stored in the storage unit 2 by having the display control unit 21, master maintenance unit 22, acquisition unit 23, calculation unit 24, output control unit 25 function as a data generation unit 26, and monthly sales report generation unit 27.
[0053] In this example, the display control unit 21 to the monthly sales report generating unit 27 are described as being realized by software based on an inventory management program, but some or all of the display control unit 21 to the monthly sales report generating unit 27 may be realized by hardware. In either case, the same effects as those described below can be obtained.
[0054] (Outline of gas product inventory management) For example, various gas products such as oxygen gas are temporarily stored in large tanks called "gyoku" (balls) as shown in Figure 11, and are then filled into gas cylinders and shipped at the time of shipment. The remaining amount of raw oxygen gas is not managed by inventory in the system, but is managed by the ball storage meter. Also, at this point, gas products are managed by volume, and unit conversion processing is not performed.
[0055] When an order is placed, oxygen gas or other gas is filled from the balls into a gas cylinder and shipped, so filled gas cylinders are rarely held in inventory, but in the case of gas products that sell frequently, they may be held in inventory. When the number of gas products in stock decreases due to sales, a bulk purchase process is carried out at the end of the month, for example, to adjust the number of stocks.
[0056] (Unit conversion during purchase input) The unit conversion operation at each accounting input will be explained below using a specific example.
[0057] For example, suppose that in March, the Sapporo warehouse received an order for 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen. In response to this order, oxygen gas is filled from the balls into the gas cylinders, as shown in Figure 12. As a result, the person in charge enters the purchase entry and records the inventory.
[0058] Specifically, when the person in charge specifies purchase input, the display control unit 21 displays a purchase input screen as shown in Fig. 13 via the output device 7. The purchase input screen shown in Fig. 13 is a purchase input screen (details) that is displayed when the person in charge specifies detail input on the main screen for purchase input.
[0059] In the purchase input screen (details) shown in Fig. 13, the purchase date is entered as the date entered by the person in charge on the main purchase input screen or the date automatically entered by the control unit 3. The person in charge also enters the "product (oxygen gas cylinder with a capacity of 7 cubic meters)", "receiving warehouse (Sapporo warehouse)", "purchase quantity (10)", and "purchase quantity unit (unit code 03 = "pieces", see Fig. 3)".
[0060] The "Purchase quantity unit", which is the unit of purchase quantity, displays the purchase unit acquired by the display control unit 21 with reference to the product master 11 shown in Fig. 3 when selecting a product. The "Inventory management unit", which is the unit of arrival quantity, displays the inventory management unit acquired by the display control unit 21 with reference to the product master 11 when selecting a product.
[0061] Furthermore, the "performance management unit" which is the unit of performance count displays the product type unit acquired by the display control unit 21 with reference to the product type master 12 shown in FIG. 4, which is a higher level than the product master 11 when the product is selected.
[0062] The calculation unit 24 refers to the unit conversion master 15 shown in Figs. 7 and 8 to obtain a "conversion coefficient" based on the input "product code," "purchase quantity unit," "purchase date," "receiving warehouse," the "inventory management unit (see Fig. 3)" determined according to the input product, and the "product type unit" determined according to the product type. The calculation unit 24 then multiplies the obtained conversion coefficient by the purchase quantity to calculate the "arrival quantity" corresponding to the unit conversion process. The display control unit 21 displays the calculated "arrival quantity" in units of the inventory management unit (in this case, "pieces") obtained from the product master 11 in Fig. 3 (unit conversion process).
[0063] However, in the case of an oxygen gas cylinder with a capacity of 7 cubic meters, the purchase quantity unit (= bottle) and the inventory management unit (= bottle) are the same, as shown in Fig. 3. In this case, the calculation unit 24 calculates the same number as the purchase quantity as the arrival quantity. Then, the display control unit 21 displays the arrival quantity, which is the same as the purchase quantity, in units of the inventory management unit (in this case, "bottles") obtained from the product master 11 in Fig. 3.
[0064] The calculation unit 24 also multiplies the calculated "number of arrivals" by the "conversion coefficient" to calculate the "actual number." That is, in this example, by referring to the unit conversion master 15 under the conditions of "product code=S0001," "conversion source unit=inventory management unit (pieces)," "conversion destination unit=actual management unit (cubic meters)," "base (warehouse)=receiving warehouse (K002)," and "application month=purchase month=March," the conversion coefficient "7" can be obtained. Therefore, the calculation unit 24 multiplies the obtained conversion coefficient "7" by the arrival number "10 (pieces)" to calculate the actual number of "70 (cubic meters)."
[0065] In the case of oxygen gas cylinders, as mentioned above, no unit conversion is performed when calculating the number of shipments from the purchase quantity, but when calculating the actual number from the number of shipments, a unit conversion process is performed from "bottles" to "cubic meters." Also, in this case, since the unit conversion process is from "bottles" to "cubic meters," there is no difference in the conversion factor due to the temperature difference, as shown in Figure 7, and the same conversion factor ("7" in this example) is used.
[0066] Next, the liquefied oxygen is procured by loading the bulk onto a tanker truck, as shown in Figure 14. The liquefied oxygen loaded onto the tanker truck is then transferred to the customer's tank and delivered.
[0067] When the person in charge purchases liquefied oxygen in this manner, at the time of purchase input, he / she inputs the "purchase date," "product," "receiving warehouse," "purchase quantity," and "purchase quantity unit" into the purchase input screen (details) shown in FIG. 15. The "purchase quantity unit," which is the unit of the purchase quantity, is obtained by the display control unit 21 from the product master 11 at the time of product selection and displayed. The "inventory management unit," which is the unit of the arrival quantity, is obtained by the display control unit 21 from the product master 11 at the time of product selection and displayed. The "performance management unit," which is the unit of the performance quantity, is obtained by the display control unit 21 from the product master 12 shown in FIG. 4, which is a higher hierarchical level than the product master 11, at the time of product selection and displayed.
[0068] The calculation unit 24 refers to the unit conversion master 15 and obtains a "conversion coefficient" using the input "product code," "purchase quantity unit," "purchase date," "receiving warehouse," and an "inventory management unit" determined according to the product. The calculation unit 24 calculates the "receiving quantity" by multiplying the obtained conversion coefficient by the purchase quantity.
[0069] That is, in this example, by referring to the unit conversion master 15 under the conditions of "product code=S0003," "source unit=purchase quantity unit (kilograms)," "destination unit=inventory control unit (cubic meters)," "base (warehouse)=receiving warehouse (K002)," and "applicable month=purchase month=March," a conversion coefficient of "0.723" can be obtained as shown in FIG. 7. The calculation unit 24 multiplies the obtained conversion coefficient "0.723" by the purchase quantity "10 (pieces)" to calculate the arrival quantity of "7.23 (cubic meters)." The display control unit 21 displays in units of the inventory control unit (in this case, "cubic meters") obtained from the product master 11 in FIG. 3 (unit conversion process).
[0070] Furthermore, the calculation unit 24 multiplies the conversion coefficient of "0.723" obtained from the unit conversion master 15 by the incoming quantity of "10 (kilograms)" to calculate the actual quantity of "7.23 (cubic meters)". In the case of this liquefied oxygen, the inventory management unit is "cubic meters" as shown in FIG. 3, and the actual management unit (= the unit indicated by the product type unit code in FIG. 4) is also "cubic meters". In this case, the display control unit 21 displays the actual quantity using "cubic meters" as the unit.
[0071] In other words, in the case of this liquefied oxygen, when displaying the quantity of arrivals, the display control unit 21 displays the quantity of arrivals in the units changed by the unit conversion process, but when displaying the actual quantity, it displays the actual quantity in the same units as the quantity of arrivals.
[0072] Also, when converting units from "kilograms" to "cubic meters," as can be seen by comparing the application month, warehouse code, and conversion coefficient of liquefied oxygen in Figure 7, different conversion coefficients are used for each application month and warehouse depending on the application month and temperature difference depending on the location.
[0073] When the purchase input is performed in this manner, the data generation unit 26 generates purchase detail data shown in Fig. 16 and inventory data shown in Fig. 17, and stores them in the storage unit 2. As shown in Fig. 16, the purchase detail data includes a purchase number, a line number, a receiving warehouse, a product code, a purchase quantity, a purchase unit, a received quantity, an inventory unit, a total quantity, and a performance unit.
[0074] The above example is an example of purchasing 10 oxygen gas cylinders with a capacity of 7 cubic meters to the Sapporo warehouse. Therefore, purchase detail data is generated with the purchase quantity "10 (bottles)", purchase unit "03: (bottles)", arrival quantity "10 (bottles)", inventory unit "03: (bottles)", total quantity "70 (bottles: 10 bottles x conversion factor 7)", and actual unit "01: cubic meters" (see the record on the first line of Figure 16).
[0075] The above example is an example of purchasing 10 kilograms of liquefied oxygen to the Sapporo warehouse. Therefore, purchase detail data is generated with the purchase quantity "10 (kilograms)", purchase unit "02: (kilograms)", arrival quantity "7.23 (cubic meters): 10 kilograms x conversion factor 0.723", inventory unit "01: (cubic meters)", total quantity "7.23 (cubic meters)", and actual unit "01: cubic meters" (see the record on the second line of Figure 16).
[0076] The inventory data also includes a warehouse code, a product code, a stock quantity, and a total number, as shown in Fig. 17. The above example is an example in which 10 oxygen gas cylinders with a capacity of 7 cubic meters were purchased at the Sapporo warehouse. Therefore, as shown in Fig. 17, inventory data is generated that includes the warehouse code "K002" indicating that the receiving warehouse is the Sapporo warehouse, the product code "S0001" indicating that the oxygen gas cylinders have a capacity of 7 cubic meters, the stock quantity of "10 bottles," and the total number of "10 bottles" (see the record on the first line of Fig. 17).
[0077] In the above example, 10 kilograms of liquefied oxygen was purchased at the Sapporo warehouse. Therefore, as shown in Fig. 17, inventory data is generated that includes the warehouse code "K002" indicating that the receiving warehouse is the Sapporo warehouse, the product code "S0003" indicating that the product is liquefied oxygen, the inventory quantity "7.23 (cubic meters)", and the total quantity "7.23 (cubic meters)" (see the record on the second line of Fig. 17).
[0078] (Unit conversion when entering sales) Next, as shown in Fig. 18, when the oxygen gas cylinders procured at the Sapporo warehouse are shipped, the person in charge inputs the prescribed sales information on the sales input screen (details) shown in Fig. 19, which is displayed by the display control unit 21. Specifically, the person in charge inputs the "sales date," "product code," "shipping warehouse," "sales quantity," and "sales quantity unit" on this sales input screen (details).
[0079] The display control unit 21 acquires and displays the "sales volume unit" which is the unit of sales volume from the product master 11 when selecting a product. Note that since the same product may be sold in different units depending on the business partner, the person in charge can input a desired sales volume unit.
[0080] Furthermore, the display control unit 21 acquires and displays the "inventory management unit", which is the unit of shipment quantity, from the product master 11 when a product is selected. Furthermore, the display control unit 21 displays the "performance management unit", which is the unit of performance quantity, by acquiring the product type unit from the product type master 12 shown in FIG. 4, which is a higher hierarchical level than the product master 11, when a product is selected.
[0081] Next, the calculation unit 24 refers to the unit conversion master 15 based on the input "product code," "sales volume unit," "sales date," "shipping warehouse," and the "inventory management unit" determined according to the product, and acquires a "conversion coefficient." The calculation unit 24 then multiplies the acquired conversion coefficient by the sales volume to calculate the "shipment volume."
[0082] As described above, in the case of an oxygen gas cylinder with a capacity of 7 cubic meters, the sales unit (= bottle) and the inventory management unit (= bottle) are the same, as shown in Fig. 3. In this case, the calculation unit 24 calculates the same number as the sales quantity as the shipping quantity. Then, the display control unit 21 displays the shipping quantity, which is the same as the sales quantity, in units of the inventory management unit (in this case, "bottles") obtained from the product master 11 in Fig. 3.
[0083] Furthermore, the calculation unit 24 calculates the "achieved number" by multiplying the "shipped number" calculated in this manner by a conversion coefficient acquired from the unit conversion master 15. The display control unit 21 displays the calculated achieved number in the achieved number management unit (01: cubic meters in the case of oxygen) indicated by the product type unit code shown in FIG.
[0084] Specifically, the calculation unit 24 refers to the unit conversion master 15 shown in Fig. 7 under the conditions of product code = S0001, conversion source unit = inventory management unit (books), conversion destination unit = performance management unit (cubic meters), base (warehouse) = shipping warehouse (K002), and application month = sales month = March, and obtains a conversion coefficient of "7". The calculation unit 24 multiplies the obtained conversion coefficient of "7" by the shipment quantity of 10 (books), and calculates the performance quantity of "70 cubic meters".
[0085] In this example, since the product shipped is an oxygen gas cylinder, the same unit of "bottles" is used for both sales and shipments, and the unit of "cubic meters" is used for the actual number calculated from the shipments through unit conversion processing.
[0086] In addition, since the goods are delivered using oxygen gas cylinders, they are less affected by temperature differences, and as shown in Figure 7, the actual number is calculated using the same conversion coefficient regardless of the application month and base (warehouse).
[0087] Next, the liquefied oxygen is loaded from the container into a tanker truck, as shown in Figure 20, and then transferred to the customer's tank for delivery.
[0088] When the liquefied oxygen is shipped in this manner, the person in charge enters the "sales date," "product," "shipping warehouse," "sales quantity," and "sales quantity unit" into the sales input screen (details) shown in FIG. 21 when entering sales. The "sales quantity unit," which is the unit of the sales quantity, is acquired by the display control unit 21 from the product master 11 when the product is selected and displayed. The "inventory management unit," which is the unit of the shipment quantity, is acquired by the display control unit 21 from the product master 11 when the product is selected and displayed. The "performance management unit," which is the unit of the performance quantity, is acquired by the display control unit 21 from the product master 12 shown in FIG. 4, which is a higher hierarchical level than the product master 11, when the product is selected and displayed.
[0089] The calculation unit 24 refers to the unit conversion master 15 using the input "product code," "sales volume unit," "sales date," "shipping warehouse," and the "inventory management unit" determined according to the product to obtain a "conversion coefficient." The calculation unit 24 calculates the "shipment quantity" by multiplying the obtained conversion coefficient by the sales quantity.
[0090] That is, in this example, by referring to the unit conversion master 15 under the conditions of "product code=S0003," "source unit=sales volume unit (kilograms)," "destination unit=inventory management unit (cubic meters)," "base (warehouse)=shipping warehouse (K002)," and "application month=shipping month=March," a conversion coefficient of "0.723" can be obtained as shown in FIG. 7. The calculation unit 24 multiplies the obtained conversion coefficient "0.723" by the sales volume "10 (kilograms)" to calculate the shipment volume of "7.23 (cubic meters)." The display control unit 21 displays in units of the inventory management unit (in this case, "cubic meters") obtained from the product master 11 in FIG. 3 (unit conversion process).
[0091] Furthermore, the calculation unit 24 calculates the actual number by multiplying the calculated shipment quantity by the conversion coefficient obtained from the unit conversion master 15. However, in the case of shipped liquefied oxygen, the inventory management unit is "cubic meters" as shown in Fig. 3, and the actual management unit (= the unit indicated by the product type unit code in Fig. 4) is also "cubic meters". For this reason, the display control unit 21 displays the actual number using "cubic meters" as the unit.
[0092] That is, in the case of this liquefied oxygen, the display control unit 21 displays both the number of shipments and the number of actual deliveries using the same unit (cubic meters).
[0093] Also, when converting units from "kilograms" to "cubic meters," as can be seen by comparing the application month, warehouse code, and conversion coefficient of liquefied oxygen in Figure 7, different conversion coefficients are used for each application month and warehouse depending on the application month and temperature difference depending on the location.
[0094] When sales are entered in this manner, the data generation unit 26 generates sales statement data shown in Fig. 22 and inventory data shown in Fig. 23, and stores them in the storage unit 2. As shown in Fig. 22, the sales statement data includes the sales number, line number, issuing warehouse, product code, sales quantity, sales unit, shipment quantity, inventory unit, total quantity, and performance unit.
[0095] In the above example, 10 oxygen gas cylinders with a capacity of 7 cubic meters were shipped from the Sapporo warehouse. Therefore, sales detail data is generated with the sales quantity and shipment quantity set to "10 (bottles)", the sales unit set to "03: (bottles)", the inventory unit set to "03: (bottles)", the total quantity set to "70 (bottles: 10 bottles x conversion factor 7)", and the performance unit set to "01: cubic meters" (see the record in the first row of Figure 22).
[0096] In the above example, 10 kilograms of liquefied oxygen was shipped from the Sapporo warehouse. Therefore, purchase detail data is generated with the sales amount "10 (kilograms)", sales unit "02: (kilograms)", shipment amount "7.23 (cubic meters): 10 kilograms x conversion factor 0.723", inventory unit "01: (cubic meters)", total amount "7.23 (cubic meters)", and performance unit "01: cubic meters" (see the record on the second line of Figure 22).
[0097] In addition, if 10 oxygen gas cylinders with a capacity of 7 cubic meters are shipped from the Sapporo warehouse, the inventory data generated will include the warehouse code of "K002" indicating that the shipping warehouse is the Sapporo warehouse, the product code of "S0001" indicating that the oxygen gas cylinders have a capacity of 7 cubic meters, and the inventory quantity of "0 bottles" and the total quantity of "0 bottles" as all of the purchased products have been shipped, as shown in Figure 23 (see the record on the first row of Figure 23).
[0098] In addition, when 10 kilograms of liquefied oxygen are shipped from the Sapporo warehouse, the inventory data generated includes the warehouse code of "K002" indicating that the shipping warehouse is the Sapporo warehouse, the product code of "S0003" indicating that the product is liquefied oxygen, and since all of the purchased products have been shipped, the inventory quantity of "0 (cubic meters)" and the aggregate quantity of "0 (cubic meters)" as shown in Figure 23 (see the record on the second row of Figure 23).
[0099] (Unit conversion operation when entering purchases and sales for different warehouses) The above explanation was about the unit conversion operation when the warehouse where purchases and shipments are made is the "Sapporo Warehouse." However, if the product purchased and shipped is "liquefied oxygen" and the warehouse is the "Okinawa Warehouse," even for the same March year, different conversion coefficients are used in Sapporo and Okinawa, resulting in differences in the number of items received, shipped, in stock, and totaled.
[0100] That is, Figure 24 shows the purchase details data when 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen were purchased for the Okinawa warehouse in March. In this case, the conversion factor for oxygen gas cylinders is "7" as shown in Figure 7, and there is no difference between Sapporo and Okinawa. Therefore, the purchase details data also shows the number of goods received as "10 (bottles)" and the total number as "70 (cubic meters)" as shown in the record on the first line of Figure 24, which is the same data as for the Sapporo warehouse.
[0101] Moreover, as shown in the record on the first line of FIG. 25, the inventory data also shows that the inventory quantity and the total quantity are both "10 (units)", which is the same data as in the case of the Sapporo warehouse.
[0102] In contrast, if 10 kilograms of liquefied oxygen were purchased at the Okinawa Warehouse in March, the conversion factor would be "0.768", as shown in Figure 7. Therefore, as shown in the record on the second line of Figure 24, the number of items received and the total number would be "10 kilograms x 0.768 = 7.68 (cubic meters)", which differs from the figure of "7.23 (cubic meters)" when the item was purchased at the Sapporo Warehouse.
[0103] Also, as shown in the second record in Figure 25, the inventory data shows that the inventory quantity and total quantity are both "7.68 (cubic meters)", which is a different figure from the Sapporo warehouse's "7.23 (cubic meters)".
[0104] The same is true for the sales detail data. Figure 26 shows the sales detail data for the shipment of 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen from the Okinawa warehouse in March. In this case, the conversion factor for oxygen gas cylinders is "7" as shown in Figure 7, and there is no difference between Sapporo and Okinawa. Therefore, as shown in the record on the first line of Figure 26, the sales and shipment quantities are "10 (bottles)" and the total quantity is "70 (cubic meters)", which is the same data as for the Sapporo warehouse.
[0105] In contrast, if 10 kilograms of liquefied oxygen were shipped from the Okinawa Warehouse in March, the conversion factor would be "0.768", as shown in Figure 7. Therefore, as shown in the record on the second line of Figure 26, the number of shipments and the total number would be "10 kilograms x 0.768 = 7.68 (cubic meters)", which differs from the figure of "7.23 (cubic meters)" when the quantity was purchased at the Sapporo Warehouse.
[0106] Furthermore, once all 10 oxygen gas cylinders and 10 kilograms of liquefied oxygen have been shipped, the inventory quantities and total quantities in the inventory data for the Okinawa warehouse (K003) will become "0 (cubic meters)," as shown in Figure 27.
[0107] Also, because different conversion factors are used, the remaining amount of oxygen in Sapporo and Okinawa is different. For example, let's say the remaining amount of oxygen in Sapporo and Okinawa is "1000 (cubic meters)." In the case of the oxygen in Sapporo, 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen were shipped, so "1000 cubic meters - (total number 70 cubic meters + total number 7.23 cubic meters) = 922.73 cubic meters."
[0108] In contrast, in the case of Okinawa, 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquid oxygen were shipped, so the total is 1,000 cubic meters - (total of 70 cubic meters + total of 7.68 cubic meters) = 922.32 cubic meters. As can be seen by comparing the two, the amount of remaining oxygen in Okinawa is slightly less than that in Sapporo.
[0109] (Confirmation of March's actual figures based on monthly sales report) Next, the inventory management device 1 of the embodiment can confirm the total number of each warehouse in a report (monthly sales report) for confirming the total sales amount within a month. Specifically, the person in charge specifies the collection period and the product type, and specifies the generation of the monthly sales report. When this specification is made, the monthly sales report generation unit 27 refers to the above-mentioned sales detail data, and extracts the sales detail data of each warehouse corresponding to the specified collection period and product type, as exemplified in FIG. 28(a).
[0110] Then, the monthly sales report generation unit 27 generates monthly sales report data for the monthly sales report including the aggregation period, product type, and the aggregated number for each warehouse, as shown in Figure 28(b) based on the extracted sales detail data, and stores it in the storage unit 2. The example of Figure 28(b) is an example in which monthly sales report data including the aggregated numbers for the Sapporo warehouse and the Okinawa warehouse for the product type "Oxygen" for the aggregation period of "March 1, 2023 to March 31, 2023" has been generated.
[0111] Moreover, the example of Figure 29 is an example of monthly sales report data generated for the "Nitrogen" variety, including the respective aggregated numbers for the Sapporo warehouse and the Okinawa warehouse, with the aggregation period being "March 1, 2023 to March 31, 2023."
[0112] Such monthly sales report data is read out from the storage unit 2 at a predetermined timing and displayed via the output device 7 as a display unit, or printed out via the output device 7 as a printer.
[0113] (Unit conversion processing at the time of purchase and shipment to the Sapporo warehouse in July) Next, we will explain an example in which, as described above, goods were purchased and sold in March, and then, in July, the Sapporo warehouse and the Okinawa warehouse received orders for 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen, respectively, and again purchased and sold (sales).
[0114] When 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen are purchased at the Sapporo warehouse in July, the purchase details data of the arrival quantity and total quantity shown in Figure 30 and the inventory data shown in Figure 31 are generated. The conversion coefficient used for oxygen gas cylinders in July is also "7" as shown in Figure 7. Therefore, as shown in the first row records of Figures 30 and 31, the arrival quantity, inventory quantity, and total quantity of oxygen gas cylinders in July are the same as the arrival quantity, inventory quantity, and total quantity of oxygen gas cylinders in March, respectively.
[0115] In contrast, the conversion coefficients used for liquefied oxygen at the Sapporo Warehouse are "0.723" for March and "0.752" for July, as shown in Figure 7. For this reason, as shown in the second row of records in Figures 30 and 31, the number of arrivals, inventory, and totals of liquefied oxygen at the Sapporo Warehouse in July are different from the number of arrivals, inventory, and totals of liquefied oxygen at the Sapporo Warehouse in March.
[0116] Also, assume that in July, 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen were shipped to the Sapporo Warehouse. In this case, sales detail data of the number of shipments and the total number shown in FIG. 32 and inventory data shown in FIG. 33 are generated. The conversion coefficient used for oxygen gas cylinders in July is also "7" as shown in FIG. 7. Therefore, as shown in the first row records of FIG. 30 and FIG. 31, the number of shipments, the number of inventory, and the total number of oxygen gas cylinders at the Sapporo Warehouse in July are the same as the number of shipments, the number of inventory, and the total number of oxygen gas cylinders at the Sapporo Warehouse in March, respectively.
[0117] In contrast, the conversion coefficients used for liquefied oxygen at the Sapporo Warehouse are "0.723" for March and "0.752" for July, as shown in Figure 7. For this reason, as shown in the second row records of Figures 32 and 33, the number of shipments, number of stocks, and number of totals of liquefied oxygen at the Sapporo Warehouse in July are different from the number of shipments, number of stocks, and number of totals of liquefied oxygen at the Sapporo Warehouse in March.
[0118] In addition, the remaining amount of balls in Sapporo was 922.77 cubic meters at the time of shipment in March, but at the time of shipment in July it was 922.77 cubic meters - (70 cubic meters + 7.23 cubic meters) = 845.54 cubic meters.
[0119] On the other hand, if 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen are purchased for the Okinawa warehouse in July, the purchase details data of the arrival quantity and total quantity shown in Figure 34 and the inventory data shown in Figure 35 are generated. Even for the Okinawa warehouse in July, the conversion factor used for oxygen gas cylinders is "7", the same as for the Sapporo warehouse. Therefore, as shown in the first row records of Figures 34 and 35, the arrival quantity, inventory quantity, and total quantity of oxygen gas cylinders at the Okinawa warehouse in July are the same as the arrival quantity, inventory quantity, and total quantity of oxygen gas cylinders at the Okinawa warehouse in March, respectively.
[0120] In contrast, the conversion coefficients used for liquefied oxygen for the Okinawa warehouse are "0.768" for March and "0.789" for July, as shown in Figure 7. For this reason, as shown in the second row of records in Figures 34 and 35, the number of arrivals, inventory, and totals of liquefied oxygen at the Okinawa warehouse in July are different from the number of arrivals, inventory, and totals of liquefied oxygen at the Okinawa warehouse and the Sapporo warehouse in March.
[0121] In addition, suppose that in July, 10 oxygen gas cylinders with a capacity of 7 cubic meters and 10 kilograms of liquefied oxygen were shipped to the Sapporo warehouse. In this case, the sales statement data of the shipment number and the total number shown in FIG. 36 and the inventory data shown in FIG. 37 are generated. The conversion coefficient used for oxygen gas cylinders in July is "7" as shown in FIG. 7, regardless of the application month and base. Therefore, as shown in the first row records of FIG. 36 and FIG. 37, the shipment number, inventory number and total number of oxygen gas cylinders at the Okinawa warehouse in July are the same as the shipment number, inventory number and total number of oxygen gas cylinders at the Okinawa warehouse and the Sapporo warehouse in March. In addition, the shipment number, inventory number and total number of oxygen gas cylinders at the Okinawa warehouse in July are the same as the shipment number, inventory number and total number of oxygen gas cylinders at the Sapporo warehouse in July.
[0122] In contrast, the conversion coefficient used for liquefied oxygen for the Okinawa warehouse is "0.768" for March and "0.789" for July, as shown in Figure 7. Therefore, as shown in the record in the second row of Figure 36, the number of liquefied oxygen shipped and the total number of liquefied oxygen shipped in July and the number of liquefied oxygen shipped and the total number of liquefied oxygen shipped in March are different values.
[0123] Furthermore, once all 10 oxygen gas cylinders and 10 kilograms of liquefied oxygen have been shipped, the inventory quantities and total quantities in the inventory data for the Okinawa warehouse (K003) will become "0 (cubic meters)," as shown in Figure 37.
[0124] Also, the amount of remaining balls in Okinawa is different from the amount of remaining balls in Sapporo; at the time of shipment in March it was 922.32 cubic meters, but at the time of shipment in July it was 922.32 cubic meters - (70 cubic meters + 7.89 cubic meters) = 844.43 cubic meters.
[0125] (Confirm July's actual figures based on monthly sales report) Next, assume that the person in charge specifies "July" as the collection period, "oxygen" as the product type, and then specifies the generation of a monthly sales report. When this specification is made, the monthly sales report generation unit 27 refers to the above-mentioned sales detail data and extracts the sales detail data for each warehouse corresponding to the "July" collection period and the product type "oxygen", as shown in Fig. 38(a).
[0126] Then, based on the extracted sales detail data, the monthly sales report generation unit 27 generates monthly sales report data for the monthly sales report including the collection period for July, the product type of "Oxygen", and the total number of each warehouse, as shown in Figure 38(b), and stores it in the storage unit 2. The example of Figure 38(b) is an example in which monthly sales report data including each of the total numbers of the Sapporo warehouse and the Okinawa warehouse for the product type of "Oxygen", with the collection period being "July 1, 2023 to July 31, 2023", has been generated.
[0127] As described above, such monthly sales report data is read out from the memory unit 2 at a predetermined timing and displayed via the output device 7 as a display unit, or printed out via the output device 7 as a printing device.
[0128] (Effects of the embodiment) As is clear from the above description, the inventory management device 1 according to the embodiment can achieve the following effects.
[0129] 1. Conversion coefficients for unit conversion are provided for each product, type of gas (variety), applicable period (applicable month), and location (warehouse), so that conversion between different units, such as from purchase and sale quantity to inventory quantity, can be easily performed at the time of purchase and sale processing.
[0130] 2. By converting the inventory quantity into the total quantity, accurate conversion results can be retained in the actual data, making it possible to omit conversion during the next inventory count, etc.
[0131] [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, making it possible to contribute to the eighth and ninth goals of the SDGs.
[0132] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of the 12th, 13th, and 15th goals of the SDGs.
[0133] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to the 16th goal of the SDGs.
[0134] [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.
[0135] 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.
[0136] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0137] Furthermore, with regard to the inventory management device 1, the components shown in the figures are merely conceptual functional components, and the device does not necessarily have to be physically configured as shown in the figures.
[0138] For example, the processing functions of the inventory management 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 containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the inventory management device 1 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processing 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.
[0139] In addition, the inventory management program of this inventory management device 1 may be stored in another server device connected to the inventory management device 1 via any network, and it is also possible to download all or part of it as needed.
[0140] 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.
[0141] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading a recording medium in the inventory management device 1 shown in the embodiment, as well as the installation procedure after reading.
[0142] 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.
[0143] The inventory management 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 connected to any peripheral device. The information processing device may be realized by implementing software (including programs or data, etc.) that realizes the processing described in this embodiment.
[0144] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0145] The present invention is suitable for application to inventory management operations in industries such as the chemical industry or gas industry, which handle products in units that differ depending on the accounting format. [Explanation of symbols]
[0146] 1. Inventory management device 2 Storage section 3. Control Unit 4. Communication Interface Section 5 Input / Output Interface Section 6 Input Devices 7 Output Devices 11 Product Master 12 Product Master 13 Unit Master 14 Warehouse Master 15 Unit Conversion Master 21 Display control unit 22 Master Maintenance Department 23 Acquisition Department 24 Calculation section 25 Output control section 26 Data Generation Section 27 Monthly Sales Report Generation Department
Claims
1. an acquisition unit that acquires, from a storage unit that stores at least source unit information indicating a source unit which is a unit before the unit of each product is converted, destination unit information indicating a destination unit after the unit of each product is converted, condition information indicating a condition for converting the source unit to the destination unit, and a conversion coefficient which corresponds to the condition information and is to be multiplied by the accounted quantity of the product in the source unit when converting the accounted quantity of the product in the source unit into the accounted quantity of the destination unit; a calculation unit that calculates the recorded quantity of the product in the conversion source unit input at the time of recording input by the acquired conversion coefficient; an output control unit that controls output of the calculated unit converted accounted quantity including the accounted quantity of the conversion destination unit via an external device; A unit conversion device having the following function.
2. The condition information is information indicating an application period of the conversion coefficient and a storage location of the product, The conversion coefficient is a value corresponding to the application period and the storage location; 2. The unit conversion device according to claim 1 .
3. The conversion coefficient is set to a value corresponding to the type of the product, the application period, and the storage location; 3. The unit conversion device according to claim 2 .
4. When the commodity is transported in a predetermined container, the conversion coefficient is set to a value corresponding to the capacity of the container, the applicable period, and the storage location; 4. The unit conversion device according to claim 3,
5. The calculation unit calculates an added and accounted quantity by the product and the storage location by adding up the unit converted accounted quantity for a predetermined period of time by the product and the storage location, The output control unit controls the output of the calculated added accrual quantity via the external device; The unit conversion device according to any one of claims 2 to 4,
6. an acquisition step in which an acquisition unit acquires, from a storage unit that stores at least source unit information indicating a source unit which is a unit before the unit of each product is converted, destination unit information indicating a destination unit after the unit of each product is converted, condition information indicating a condition for converting the source unit to the destination unit, and a conversion coefficient which corresponds to the condition information and is to be multiplied by the accounted quantity of the product in the source unit when converting the accounted quantity of the product in the source unit into the accounted quantity of the destination unit; A calculation step in which a calculation unit calculates an accounted quantity of the product in the conversion source unit input at the time of accounting input by the acquired conversion coefficient; an output control step in which an output control unit controls output of a unit converted accounted quantity including the calculated accounted quantity of the conversion destination unit via an external device; A unit conversion method having the following structure.
7. Computer, an acquisition unit that acquires, from a storage unit that stores at least source unit information indicating a source unit which is a unit before the unit of each product is converted, destination unit information indicating a destination unit after the unit of each product is converted, condition information indicating a condition for converting the source unit to the destination unit, and a conversion coefficient which corresponds to the condition information and is to be multiplied by the accounted quantity of the product in the source unit when converting the accounted quantity of the product in the source unit into the accounted quantity of the destination unit; a calculation unit that calculates the recorded quantity of the product in the conversion source unit input at the time of recording input by the acquired conversion coefficient; an output control unit that controls output of the calculated unit converted accounted quantity including the accounted quantity of the conversion destination unit via an external device; A unit conversion program to function as.
Citation Information
Patent Citations
Delivery prediction system and method by front-loading by α days
JP2015069312A
Management device, product data providing system, product data management method and management program
JP2017134650A
Merchandise management unit conversion device, merchandise management unit conversion method, and merchandise management unit conversion program
JP2018097779A
Gas container management device and gas container management program
JP2023097748A
Concurrently using multiple units of measure for inventory management
US20160125353A1