JP2022152905A - Weight difference calculating apparatus, weight difference calculating method, and weight difference calculating program - Google Patents

Abstract

To provide a weight difference calculating apparatus, a weight difference calculating method, and a weight difference calculating program which can calculate a roughly estimated inventory weight as well as a precise inventory weight to calculate difference between both of the weights.SOLUTION: A weight difference calculating apparatus 100 according to the present invention has a per-specification weight calculating unit 102a for calculating a reception/payment weight for an article by multiplying the number of articles in specification data by a unit weight, a per-specification integer weight calculating unit 102b for calculating weight indicated by an integer by carrying out fraction processing of the reception/payment weight in each specification data, a roughly estimated stock weight calculating unit 102c for calculating a roughly estimated stock weight for each article by summing every weight indicated by integer, a precise stock weight calculating unit 102d for calculating a precise stock weight for each article by summing the number of articles in the specification data for each article and calculating a value obtained by multiplying the number of articles by the unit weight for each article and then carrying out fraction processing, and a weight difference calculating unit 102e for calculating weight difference for each article between the roughly estimated stock weight for each article and the precise stock weight for each article.SELECTED DRAWING: Figure 1

Description

The present invention relates to a difference weight calculation device, a difference weight calculation method, and a difference weight calculation program.

In Patent Document 1, from the stage of determining the order quantity, productivity in the manufacturing process is improved without generating surplus materials in the manufacturing process by considering manufacturing constraints such as the manufacturing weight range that can be manufactured in each passing process. is disclosed (see paragraph 0005 of Patent Document 1).

Japanese Patent Application Laid-Open No. 2007-272431

For example, in the steel industry and the like, the number of items representing the packing style is used as the inventory management unit, and the weight is used as the unit for calculating the inventory value. That is, two units are used. Here, in order to manage the current inventory weight, the weight calculated by multiplying the number of daily transactions by the unit weight is rounded, and the daily weight after rounding is aggregated to obtain an approximate inventory weight. Sometimes. For example, receipt/payment data states that 10 steel pipes were purchased on the 4th of a month, 4 steel pipes were sold on the 5th of the same month, 4 steel pipes were sold on the 6th of the same month, and 2 steel pipes were sold on the 7th of the same month. Assuming that the unit weight is 1.1 kg/piece, the estimated inventory weight at the end of the month is (10 pieces x 1.1 kg/piece = 11 kg) + (-4 pieces x 1.1 kg/piece = - 4.4 kg rounded to the first decimal place - 4) + (-4 x 1.1 kg/piece = -4.4 kg rounded to the first decimal place - 4) + (-2 x 1.1 kg) / piece = -2.2 kg rounded to the first decimal place - 2) = 1 kg.

However, the 1 kg is only an approximate inventory weight and is different from the actual accurate inventory weight. The accurate inventory weight can be obtained by rounding the value obtained by multiplying the number of units at the end of the month by the unit weight. In the example of the previous paragraph, the number of pieces at the end of the month is (10 pieces) + (-4 pieces) + (-4 pieces) + (-2 pieces) = 0 pieces, so the accurate inventory at the end of the month The weight is 0 x 1.1 kg/piece = 0 kg (the calculated 0 kg is already an integer, so rounding is not performed).

Here, if the weight generated in daily transactions is totaled, the approximate inventory weight can be easily grasped. inventory weights must be manually recalculated at the end of the month. As a result, at the end of the month when the inventory amount is captured, the weight of the difference between the approximate inventory weight and the accurate inventory weight is obtained, and the weight of the difference is reflected in the receipt and payment data as payment details.

However, since the series of processes up to the calculation of the difference weight (particularly, the accurate calculation of the inventory weight) have been performed manually in the past, there were problems such as workload and calculation errors.

The present invention has been made in view of the above problems, and is a difference weight calculation device that can obtain an approximate inventory weight while also obtaining an accurate inventory weight and calculate the difference between the two weights. , to provide a difference weight calculation method and a difference weight calculation program.

In order to solve the above-described problems and achieve the object, a weight difference calculation device according to the present invention is a weight difference calculation device comprising a control unit and a storage unit, wherein the storage unit stores a product receipt/payment date and , receipt and payment data including itemized data having item identification data for identifying the item and the number of items received and paid for the item; the item identification data; and the unit weight of each item. is stored, and the control unit acquires the unit weight associated with the product identification data in the detailed data from the product master, and adds the acquired unit weight to the number of pieces in the detailed data. By multiplying the weight of each item by item weight calculation means for calculating the received and paid weight of the product for each item data, and by performing a predetermined fraction processing on the weight of each item data calculated by the item weight calculation means Integer weight calculation means for each detail for calculating an integer weight for each of the detail data and adding the calculated integer weight to the detail data; for each product to calculate an approximate inventory weight for each product at the end of the predetermined period, and store the calculated approximate inventory weight for each product to obtain inventory data and an estimated inventory weight calculating means for calculating the number of items in the detailed data whose receipt/payment date belongs to the predetermined period for each product, and adding the aggregated number of items for each product Accurate stock weight of each product at the end of the predetermined period by calculating a value obtained by multiplying the unit weight in the product master linked to the identification data and performing the predetermined fraction processing on the value an approximate inventory weight for each product in the inventory data generated by the approximate inventory weight calculation means, and an accurate inventory for each product calculated by the accurate inventory weight calculation means and weight difference calculation means for calculating a weight difference between the weight and the weight for each product.

Further, in the difference weight calculation device according to the present invention, the control unit adds the detailed data having the difference weight for each product calculated by the difference weight calculation means to the receipt and payment data, thereby calculating the receipt and payment data. It is characterized by further comprising receipt and payment data updating means for updating.

Further, in the difference weight calculation device according to the present invention, the control unit calculates the approximate inventory weight of each product in the inventory data with the accurate inventory weight of each product calculated by the accurate inventory weight calculation means. It is characterized by further comprising inventory data update means for updating the inventory data by overwriting.

Further, a difference weight calculation method according to the present invention is a difference weight calculation method executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores the date of receipt and payment of a product and the identification of the product. receipt and payment data including itemized data having item identification data and the number of items received and paid for the merchandise; and a merchandise master including the merchandise identification data and the unit weight of each merchandise. and acquiring the unit weight associated with the product identification data in the detailed data from the product master, and multiplying the number of pieces in the detailed data by the obtained unit weight, which is executed by the control unit. By performing a predetermined fraction processing on the weight of each item data calculated in the item weight calculation step of calculating the received and paid weight of the product for each item data, and the weight of each item data calculated in the item weight calculation step, an integer a step of calculating the weight of the integer for each of the detailed data, and adding the calculated integer weight to the detailed data; and are aggregated for each product to calculate an approximate inventory weight for each product at the end of the predetermined period, and the calculated approximate inventory weight for each product is stored to generate inventory data. an approximate inventory weight calculation step for calculating the item number in the itemized data whose receipt/payment date belongs to the predetermined period for each item, and adding the item identification data for the item to the aggregated item number for each item By calculating the value obtained by multiplying the unit weight in the product master associated with the product and performing the predetermined fraction processing on the value, the accurate inventory weight of each product at the end of the predetermined period is calculated. an accurate inventory weight calculation step, an approximate inventory weight for each product in the inventory data generated in the approximate inventory weight calculation step, and an accurate inventory weight for each product calculated in the accurate inventory weight calculation step; and a difference weight calculation step of calculating, for each product, the weight of the difference between .

Further, a difference weight calculation program according to the present invention is a difference weight calculation program to be executed by an information processing apparatus having a control unit and a storage unit, wherein the storage unit stores the receipt and payment date of the product and the product. Receipt/payment data including itemized data having item identification data for identification and the number of items received and paid for the item, and an item master including the item identification data and the unit weight of each item are stored. The unit weight associated with the product identification data in the detailed data is acquired from the product master, and the acquired unit weight is added to the number of items in the detailed data for the control unit to execute. By multiplying by , an integer weight calculation step for each detail of calculating an integer weight for each of the detail data and adding the calculated integer weight to the detail data; for each product to calculate an approximate inventory weight for each product at the end of the predetermined period, and store the calculated approximate inventory weight for each product to obtain inventory data an estimated inventory weight calculating step for generating the above-mentioned item number in the itemized data whose receipt and payment dates belong to the predetermined period; Accurate stock weight of each product at the end of the predetermined period by calculating a value obtained by multiplying the unit weight in the product master linked to the identification data and performing the predetermined fraction processing on the value an approximate inventory weight for each product in the inventory data generated in the approximate inventory weight calculation step; and an accurate inventory for each product calculated in the accurate inventory weight calculation step and a difference weight calculation step of calculating a difference weight for each product.

According to the present invention, it is possible to obtain an approximate inventory weight, while also obtaining an accurate inventory weight, and to calculate the difference between the two weights.

FIG. 1 is a block diagram showing an example of the configuration of a difference weight calculation device. FIG. 2 is a diagram illustrating an example of a processing flow; FIG. 3 is a diagram showing an example of combinations of products, quantity units, and weight units. FIG. 4 is a diagram showing an example of receipt/payment data, commodity master data, and inventory data. FIG. 5 is a diagram showing an example of calculating the weight of the difference between the approximate inventory weight and the accurate inventory weight. FIG. 6 is a diagram showing an example of updated receipt/payment data and updated inventory data.

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of a weight difference calculation device, a weight difference calculation method, and a weight difference calculation program according to the present invention will be described below in detail with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. Overview]
In the steel industry, the number of items representing the packing style is used as a unit for managing inventory, and the weight is used as a unit for calculating the amount of inventory. That is, two units are used. Weight is often calculated by multiplying the number of items by the master-controlled unit weight. It may not be. In other words, the approximate end-of-month inventory weight obtained by aggregating the rounded values of the daily calculated weights may differ from the accurate end-of-month inventory weight.

Therefore, in order to accurately calculate the weight, which is the basis for calculating the inventory value, the accurate end-of-month inventory weight is obtained by manually rounding the value obtained by multiplying the number of units at the end of the month by the unit weight. was necessary. In addition, the approximate end-of-month inventory weight was adjusted based on the accurate end-of-month inventory weight.

Therefore, in the present embodiment, for example, at the end of the month when the inventory value is captured, the inventory adjustment can be performed based on automatic calculation. In other words, at the end of the month, the accurate inventory weight is automatically calculated by multiplying the number of remaining employees at the end of the month by the unit weight, and the difference from the approximate inventory weight can be registered as inventory adjustment data. Specifically, in the present embodiment, for example, the remaining weight (approximate remaining weight) obtained by aggregating the weight of daily transactions, and the theoretical weight (accurate remaining weight) calculated based on the number of employees remaining at the end of the month. By calculating the difference and creating a payout statement reflecting the calculated difference, the approximate end-of-month inventory weight can be adjusted with the accurate end-of-month inventory weight.

This can reduce, for example, the workload and the risk of miscalculation. Note that the inventory adjustment is a task that is required not only in the steel industry but also in industries that deal with irregular commodities such as wood and meat. Specific configurations and operations will be described below.

[2. Constitution]
An example of the configuration of the difference weight calculation device 100 according to this embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the difference weight calculation device 100. As shown in FIG.

The difference weight calculation device 100 is a commercially available desktop personal computer. Note that the difference weight calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistant), smart phone, tablet personal computer, or other mobile device. type information processing device.

The weight difference calculation device 100 includes a control section 102 , a communication interface section 104 , a storage section 106 and an input/output interface section 108 . Each unit included in the weight difference calculation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the weight difference calculation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the difference weight calculation apparatus 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data such as various masters described later may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface section 108 . The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that realizes a pointing device function in cooperation with a mouse. Note that, hereinafter, the output device 114 may be referred to as the monitor 114 and the input device 112 may be referred to as the keyboard 112 or the mouse 112 .

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for performing various processes by giving commands to a CPU (Central Processing Unit) in cooperation with an OS (Operating System). As the storage unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

The storage unit 106 includes, for example, receipt/payment data 106a, merchandise master 106b, rounding setting master 106c, inventory data 106d, and movement data 106e.

The receipt/payment data 106a is data for managing information on daily receipt/payment (purchase, sales, movement, etc.) of the product. As shown in FIGS. 4 and 6, the receipt/payment data 106a includes, for example, a slip number, a line number within the same slip number, the receipt/payment date of the product, a data category, and a warehouse identification for identifying the warehouse. data (warehouse code), lot identification data (lot number) for identifying the lot, product identification data (product code) for identifying the product, number of units received and paid for the product, and details to be described later Integer weight (weight) calculated by the integral weight calculation unit 102b and detailed data having the like are included. Examples of the data categories include purchase categories, sales categories, and movement (delivery) categories. Combinations of the merchandise, the units of the number of items, and the units of the weight are not particularly limited, but examples thereof include the combinations shown in FIG.

The product master 106b is a master for managing the unit weight of each product. The product master 106b, as shown in FIG. 4, includes, for example, the product identification data (product code), the unit weight of each product, and the like. For example, if the product is a steel pipe, the unit of the quantity is the book, and the unit of the weight is kg, the unit weight means the number of kilograms per steel pipe.

The rounding setting master 106c is a master for setting the rounding of the calculated weight. Although not shown, the rounding setting master 106c includes, for example, information on how many places after the decimal point the rounding is to be performed, the rounding method (for example, rounding off), and the like.

The inventory data 106d is data for managing the approximate inventory weight of each product at the end of a predetermined period (for example, at the end of the month). As shown in FIG. 4, the inventory data 106d includes, for example, the product identification data (product code), the warehouse identification data (warehouse code), the lot identification data (lot number), and the end point of the predetermined period. and the estimated inventory weight (weight) of each product at the end of the predetermined period.

The movement data 106e is data for inventory adjustment of the approximate inventory weight with the accurate inventory weight. As shown in FIG. 5, the movement data 106e includes, for example, a slip number, a line number within the same slip number, the date of movement of the product, the data classification of the movement (shipment), and the product identification data (product code), quantity, weight (weight) of the difference between the approximate inventory weight and the exact inventory weight, and so on.

The control unit 102 is a CPU or the like that controls the difference weight calculation device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 functionally and conceptually, for example, (1) acquires the unit weight associated with the product identification data in the detailed data from the product master, and adds the acquired unit weight to the number of pieces in the detailed data. (2) the detail weight calculation unit 102a as weight calculation means for each detail, which calculates the received and paid weight of the product for each of the detail data by multiplying the weight by the weight; Integer for each detail as an integer weight calculation means for calculating an integer weight for each of the detail data by performing predetermined fraction processing on the weight for each data, and adding the calculated integer weight to the detail data and (3) a rough calculation for each product at the end of the predetermined period by aggregating the weight of the integer in the detailed data in which the date of receipt and payment belongs to the predetermined period for each product. (4) an approximate inventory weight calculation unit 102c as an approximate inventory weight calculation means for generating inventory data by calculating the inventory weight of each product and storing the calculated approximate inventory weight for each product; The number of pieces in the detailed data belonging to the predetermined period is aggregated for each product, and the unit weight in the product master linked to the product identification data for the product is added to the aggregated number of pieces for each product. Accurate inventory weight calculation as accurate inventory weight calculation means for calculating an accurate inventory weight for each product at the end of the predetermined period by calculating the multiplied value and performing the predetermined fraction processing on the value (5) an approximate inventory weight for each product in the inventory data generated by the approximate inventory weight calculation means, and an accurate inventory weight for each product calculated by the accurate inventory weight calculation means; (6) a difference weight calculation unit 102e as a difference weight calculation means for calculating the difference weight for each product; and (7) the approximate inventory weight of each product in the inventory data is calculated by the accurate inventory weight calculation means. and an inventory data updating unit 102g as inventory data updating means for updating the inventory data by overwriting with the calculated accurate inventory weight for each product. Details of the processing executed by each unit are described in [3. Specific example of processing].

[3. Specific example of processing]
In this section, a specific example of processing according to this embodiment will be described. As an overview of the flow of processing, as shown in FIG. Temporary tightening processing (weight recalculation processing) is executed. Then, as shown in FIG. 2, the contents of the inventory data 106d and the movement data 106e are updated by reflecting the result of the processing.

In this section, we will explain assuming that the difference between the approximate inventory weight and the exact inventory weight at the end of the month is obtained for each of the product code SH01100 and the product code SH01200.

As a premise for the explanation in this section, it is assumed that the receipt/payment data 106a indicating transactions during the month is registered with the contents shown in FIG. Since it is calculated by the process of , it is assumed to be blank at the start of the process. It is also assumed that the product master 106b has been registered in advance with the contents shown in FIG. 4 prior to the start of processing.

[3-1. Weight calculation process for each item]
The itemized weight calculation unit 102a acquires the unit weight associated with the item identification data in the itemized data from the item master 106b, and multiplies the number of pieces in the itemized data by the acquired unit weight to obtain the The received and paid weight of the product is calculated for each of the detailed data.

Specifically, referring to the product master 106b, the unit weight associated with product code SH01100 is 1.1 kg/piece, while the unit weight associated with product code SH01200 is also 1.1 kg/piece. Therefore, the weight per item calculation unit 102a
(1) For the detailed data (purchase details) of product code SH01100 on line number 1 of slip number SI0001, calculate the number of pieces: 10 x unit weight: 1.1 kg/piece = weight: 11 kg,
(2) For the detail data (purchase details) of product code SH01200 in line number 2 of slip number SI0001, calculate 100 units x unit weight 1.1 kg/piece = weight 110 kg,
(3) For the detailed data (sales details) of product code SH01100 on line number 1 of slip number UR0001, calculate the number of pieces - 4 pieces x unit weight 1.1 kg/piece = weight - 4.4 kg,
(4) For the detailed data (sales details) of product code SH01100 on line number 1 of slip number UR0002, calculate the number of pieces - 4 units x unit weight 1.1 kg/piece = weight - 4.4 kg,
(5) For the detailed data (sales details) of product code SH01100 on line number 1 of slip number UR0003, calculate the number of pieces - 2 units x unit weight 1.1 kg/piece = weight - 2.2 kg,
(6) For the detailed data (sales details) of product code SH01200 on line number 2 of slip number UR0003, calculate the number of pieces - 4 units x unit weight 1.1 kg/piece = weight - 4.4 kg,
(7) For the detailed data (sales details) of product code SH01200 on line number 1 of slip number UR0004, calculate the number of pieces - 4 pieces x unit weight 1.1 kg/piece = weight - 4.4 kg,
(8) For the detailed data (sales details) of product code SH01200 on line number 1 of slip number UR0005, calculate the number of pieces - 4 pieces x unit weight 1.1 kg/piece = weight - 4.4 kg.

[3-2. Integer weight calculation process for each item]
The per-detailed integer weight calculation unit 102b calculates an integer weight for each of the detailed data by performing predetermined fraction processing on the weight of each of the detailed data calculated by the per-detailed weight calculation unit 102a, and calculates the weight of the integer to the detailed data.

Specifically, in the rounding setting master 106c, if rounding is set to the first decimal place, the detail weight calculation unit 102b
(1) Regarding the detail data (purchase detail) of product code SH01100 on line number 1 of slip number SI0001, weight 11kg is already an integer, so add it to the detail data as it is,
(2) Regarding the detail data (purchase detail) of product code SH01200 on line number 2 of slip number SI0001, the weight of 110 kg is already an integer, so add it to the detail data as it is,
(3) For the detail data (sales details) of product code SH01100 on line number 1 of slip number UR0001, add weight - 4.4kg, which is an integer rounded to the first decimal place - 4kg to the detail data,
(4) For the detail data (sales details) of product code SH01100 on line number 1 of slip number UR0002, add weight - 4.4kg, which is an integer rounded to the first decimal place - 4kg to the detail data,
(5) For the detailed data (sales details) of product code SH01100 on line number 1 of slip number UR0003, weight - 2.2 kg, the integer weight rounded to the first decimal place - 2 kg is added to the relevant detailed data,
(6) For the detail data (sales details) of product code SH01200 on line number 2 of slip number UR0003, weight - 4.4 kg, an integer rounded to the first decimal place - 4 kg, is added to the detail data,
(7) For the detail data (sales details) of product code SH01200 on line number 1 of slip number UR0004, weight - 4.4 kg, an integer rounded to the first decimal place - 4 kg, is added to the detail data,
(8) For the detail data (sales details) of product code SH01200 on line number 1 of slip number UR0005, weight - 4.4 kg, rounded to the first decimal place, weight - 4 kg will be added to the relevant detail data.

As a result, the receipt/payment data 106a shown in FIG. 4 is completed.

[3-3. Approximate Inventory Weight Calculation Processing]
The approximate inventory weight calculation unit 102c aggregates the weight of the integer in the detailed data whose receipt/payment date belongs to a predetermined period for each product, thereby obtaining an approximate estimate for each product at the end of the predetermined period. Inventory data 106d is generated by calculating the inventory weight and storing the calculated approximate inventory weight for each product.

Specifically, if the predetermined period is the period from 2021/01/01 to 2021/01/31, the detailed data of (1) to (8) of [3-2] are all The payment date belongs to the period. For this reason, the approximate inventory weight calculation unit 102c calculates the weight of integers in the detailed data of (1), (3), (4) and (5) of [3-2] as 11 kg + (-4kg) + (-4kg) + (-2kg) = 1kg. In addition, the estimated inventory weight calculation unit 102c calculates the weight of the integers in the detailed data of (2), (6), (7) and (8) of [3-2] for the product SH01200 by adding 110 kg + ( -4kg) + (-4kg) + (-4kg) = 98kg.

In this way, the estimated inventory weight calculation unit 102c calculates the approximate inventory weight of SH01100 as of the end of January 31, 2021 to be 1 kg, and also calculates the approximate inventory weight of SH01200 as of the end of January 31, 2021. An approximate inventory weight for the product can be calculated as 98 kg. The reason why the expression “approximate” is used is that the calculated value is obtained by adding up the integer weight obtained by rounding off for each of the detailed data in [3-2].

Then, the estimated inventory weight calculation unit 102c stores the calculated approximate inventory weight of each product at the end of 2021/01/31 in the inventory data 106d, thereby completing the inventory data 106d shown in FIG. .

[3-4. Accurate Inventory Weight Calculation Processing]
The accurate inventory weight calculation unit 102d aggregates the quantity in the detailed data whose receipt/payment date belongs to a predetermined period for each product, and adds the product identification data for the product to the aggregated quantity for each product. A value obtained by multiplying the unit weight in the associated product master is calculated, and the predetermined fractional processing is performed on the value to calculate an accurate inventory weight for each product at the end of the predetermined period. .

Specifically, assuming that the predetermined period is the period from 01/01/2021 to 01/31/2021 as described in [3-3], (1) to (8) in [3-2] ), all the receipt/payment dates belong to the period. Therefore, for the SH01100 product, the accurate inventory weight calculation unit 102d calculates the number of items in the detailed data (1), (3), (4), and (5) of [3-2] data 106a) is counted as 10 + (-4) + (-4) + (-2) = 0. In addition, the accurate inventory weight calculation unit 102d calculates the number of items in the detailed data (2), (6), (7) and (8) of [3-2] (receipt and payment data in FIG. 106a) is counted as 100 + (-4) + (-4) + (-4) = 88.

Here, since the unit weight associated with SH01100 in the product master 106b of FIG. Calculate 0 kg as the value multiplied by kg. In addition, since the unit weight associated with SH01200 in the product master 106b of FIG. Calculate 96.8 kg as a value multiplied by

Then, in the rounding setting master 106c, as described in [3-2], if rounding is set to the first decimal place, then the exact inventory weight calculating unit 102d will calculate the exact inventory weight for each product as of the end of 2021/01/31 as follows: That is, the accurate inventory weight calculation unit 102d calculates 0 kg as the accurate inventory weight as it is because 0 kg calculated for the product SH01100 in the previous paragraph is an integer. On the other hand, the accurate inventory weight calculation unit 102d calculates 97 kg as the accurate inventory weight by rounding off the 96.8 kg calculated for the SH01200 product in the previous paragraph to the first decimal place.

[3-5. Difference weight calculation process]
The difference weight calculation unit 102e calculates the approximate inventory weight for each product in the inventory data 106d generated by the approximate inventory weight calculation unit 102c, the accurate inventory weight for each product calculated by the accurate inventory weight calculation unit 102d, , the weight of the difference is calculated for each product.

Specifically, as described in [3-3], the approximate inventory weight of each product is shown in the inventory data 106d of FIG. inventory data 106d. On the other hand, the accurate inventory weight of each product calculated in [3-4] is shown as inventory data (value calculated from unit weight) on the right side of FIG.

As shown in the inventory data on the left side of Figure 5, the approximate inventory weight for SH01100 products as of the end of January 31, 2021 is 1 kg, and the approximate inventory weight for SH01200 products as of the end of January 31, 2021 is Approximate inventory weight is 98kg. As shown in the inventory data on the right in FIG. The exact stock weight is 97kg. Therefore, the difference weight calculation unit 102e calculates the difference weight of the product SH01100 as -1 kg, and the difference weight of the product SH01200 as -1 kg at the time of the monthly temporary closing process at the end of the month (the end of January). calculate.

Then, as shown in FIG. 5, movement data 106e storing detailed data (movement details) having the weight of the calculated difference is generated.

[3-6. Receipt/payment data update process]
The receipt/payment data update unit 102f updates the receipt/payment data 106a by adding the detailed data having the difference weight for each product calculated by the difference weight calculation unit 102e to the receipt/payment data 106a.

Specifically, the receipt/payment data update unit 102f adds the detailed data (moving details) described in the last paragraph of [3-5] to the receipt/payment data 106a after the monthly provisional closing process at the end of the month (end of January). As a result, the receipt/payment data 106a is updated as shown in FIG. The hatched lines (9) and (10) in the receipt/payment data 106a of FIG. 6 are the added detail data (transfer details).

[3-7. Inventory data update process]
The inventory data update unit 102g updates the inventory data 106d by overwriting the approximate inventory weight of each product in the inventory data 106d with the accurate inventory weight of each product calculated by the accurate inventory weight calculation unit 102d. do.

Specifically, after the monthly provisional closing process at the end of the month (the end of January), the inventory data updating unit 102g corrects the estimated inventory weight of each product in the inventory data 106d of FIG. 4 in [3-4]. The inventory data 106d is updated as shown in FIG. 6 by overwriting with the accurate inventory weight for each product calculated by the inventory weight calculator 102d. The hatched numbers in the inventory data 106d of FIG. 6 are the accurate inventory weights after the overwriting.

[4. Summary of this embodiment]
As described above, according to the difference weight calculation device 100 according to the present embodiment, as described mainly in [3-1] to [3-5], while obtaining an approximate inventory weight, on the other hand, an accurate It is also possible to obtain the weight of the inventory, and calculate the difference between the two weights. Further, according to the weight difference calculation device 100 according to the present embodiment, as described mainly in [3-6] and [3-7], inventory adjustment can be performed based on the calculated difference. .

[5. Contribution to the Sustainable Development Goals (SDGs) led by the United Nations]
Since this embodiment can contribute to improving operational efficiency and promoting appropriate management decisions of companies, it is possible to contribute to Goals 8 and 9 of the SDGs.

In addition, the present embodiment can contribute to the reduction of disposal loss and the promotion of paperless and computerization.

In addition, since this embodiment can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[6. Other embodiments]
The present invention may be implemented in various different embodiments other than the embodiments described above within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed Alternatively, some can be done automatically by known methods.

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

Also, with respect to the weight difference calculation device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the weight difference calculation device 100, particularly the processing functions performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be implemented as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment. It is read mechanically by the device 100 . That is, a storage unit such as a ROM or HDD (Hard Disk Drive) stores a computer program for giving commands to the CPU in cooperation with the OS to perform various processes. This computer program is executed by being loaded into the RAM and constitutes a control section in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the weight difference calculation device 100 via any network, and all or part of it can be downloaded as necessary. is.

Also, the program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (registered (trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Disc (registered trademark) such as Blu- shall include any "portable physical medium".

A "program" is a data processing method written in any language or writing method, regardless of the format such as source code or binary code. In addition, the "program" is not necessarily limited to a single configuration, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiments, the installation procedure after reading, and the like.

The various databases stored in the storage unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. It stores programs, tables, databases, files for web pages, and so on.

Further, the difference weight calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which arbitrary peripheral devices are connected. Further, the difference weight calculation device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the device.

Furthermore, the specific forms of distribution and integration of devices are not limited to those shown in the figures, and all or part of them can be functionally or physically arranged in arbitrary units according to various additions or functional loads. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is useful, for example, in industries dealing with irregular commodities, and is particularly useful in the steel industry, building material industry, food industry, and the like.

100 weight difference calculation device 102 control unit
102a Weight calculation unit for each item
102b Integer weight calculation unit for each item
102c Approximate Inventory Weight Calculator
102d Accurate stock weight calculator
102e Difference weight calculator
102f Receipt/payment data update unit
102g inventory data update unit 104 communication interface unit 106 storage unit
106a receipt and payment data
106b Product master
106c Rounding setting master
106d Inventory data
106e moving data 108 input/output interface unit 112 input device 114 output device 200 server 300 network

Claims (5)

A difference weight calculation device comprising a control unit and a storage unit,
The storage unit contains
Receipt and payment data including detailed data having the date of receipt and payment of the product, product identification data for identifying the product, and the number of received and paid items for the product;
a product master including the product identification data and the unit weight of each product;
is stored and
The control unit
The unit weight associated with the product identification data in the detailed data is acquired from the product master, and the received and paid weight of the product is obtained by multiplying the number of pieces in the detailed data by the acquired unit weight. Weight per detail calculation means for calculating each detail data;
An integer weight is calculated for each of the detailed data by performing predetermined fraction processing on the weight of each of the detailed data calculated by the weight of each detailed data calculation means, and the calculated integer weight is added to the detailed data. Integer weight calculation means for each item;
Calculating the approximate inventory weight of each product at the end of the predetermined period by totaling the weight of the integer in the detailed data whose receipt and payment date belongs to the predetermined period for each product, and calculating an approximate inventory weight calculation means for generating inventory data by storing an approximate inventory weight for each product;
The quantity in the detailed data whose receipt and payment date belongs to the predetermined period is aggregated for each product, and the quantity in the product master linked to the product identification data for the product is added to the aggregated quantity for each product. Accurate inventory weight calculation means for calculating an accurate inventory weight for each product at the end of the predetermined period by calculating a value obtained by multiplying the unit weight and performing the predetermined fraction processing on the value;
The weight of the difference between the approximate inventory weight of each product in the inventory data generated by the approximate inventory weight calculation means and the accurate inventory weight of each product calculated by the accurate inventory weight calculation means is calculated as the weight of the product. a difference weight calculation means for calculating each
to provide
A difference weight calculation device characterized by: The control unit
further comprising receipt and payment data update means for updating the receipt and payment data by adding detailed data having the difference weight for each product calculated by the difference weight calculation means to the receipt and payment data;
The difference weight calculation device according to claim 1, characterized by: The control unit
inventory data updating means for updating the inventory data by overwriting the approximate inventory weight for each product in the inventory data with the accurate inventory weight for each product calculated by the accurate inventory weight calculating means; be prepared,
The difference weight calculation device according to claim 1 or 2, characterized by: A difference weight calculation method executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Receipt and payment data including detailed data having the date of receipt and payment of the product, product identification data for identifying the product, and the number of received and paid items for the product;
a product master including the product identification data and the unit weight of each product;
is stored and
executed by the control unit;
The unit weight associated with the product identification data in the detailed data is acquired from the product master, and the received and paid weight of the product is obtained by multiplying the number of pieces in the detailed data by the acquired unit weight. A weight calculation step for each detail, which is calculated for each detail data;
An integer weight is calculated for each of the detailed data by performing predetermined fraction processing on the weight of each of the detailed data calculated in the step of calculating the weight of each detailed item, and the calculated integer weight is added to the detailed data. an integer weight calculation step for each item;
Calculating the approximate inventory weight of each product at the end of the predetermined period by totaling the weight of the integer in the detailed data whose receipt and payment date belongs to the predetermined period for each product, and calculating an approximate inventory weight calculation step of generating inventory data by storing an approximate inventory weight for each of the products;
The quantity in the detailed data whose receipt and payment date belongs to the predetermined period is aggregated for each product, and the quantity in the product master linked to the product identification data for the product is added to the aggregated quantity for each product. an accurate inventory weight calculation step of calculating an accurate inventory weight of each product at the end of the predetermined period by calculating a value obtained by multiplying the unit weight and performing the predetermined fraction processing on the value;
The weight of the difference between the approximate inventory weight for each product in the inventory data generated in the approximate inventory weight calculation step and the accurate inventory weight for each product calculated in the accurate inventory weight calculation step is calculated for the product. a difference weight calculation step for calculating each
including
A difference weight calculation method characterized by: A difference weight calculation program to be executed by an information processing device comprising a control unit and a storage unit,
The storage unit contains
Receipt and payment data including detailed data having the date of receipt and payment of the product, product identification data for identifying the product, and the number of received and paid items for the product;
a product master including the product identification data and the unit weight of each product;
is stored and
for causing the control unit to execute
The unit weight associated with the product identification data in the detailed data is acquired from the product master, and the received and paid weight of the product is obtained by multiplying the number of pieces in the detailed data by the acquired unit weight. A weight calculation step for each detail, which is calculated for each detail data;
An integer weight is calculated for each of the detailed data by performing predetermined fraction processing on the weight of each of the detailed data calculated in the step of calculating the weight of each detailed item, and the calculated integer weight is added to the detailed data. an integer weight calculation step for each item;
Calculating the approximate inventory weight of each product at the end of the predetermined period by totaling the weight of the integer in the detailed data whose receipt and payment date belongs to the predetermined period for each product, and calculating an approximate inventory weight calculation step of generating inventory data by storing an approximate inventory weight for each of the products;
The quantity in the detailed data whose receipt and payment dates belong to the predetermined period is aggregated for each product, and the quantity in the product master linked to the product identification data for the product is added to the aggregated quantity for each product. an accurate inventory weight calculation step of calculating an accurate inventory weight for each product at the end of the predetermined period by calculating a value obtained by multiplying the unit weight and performing the predetermined fraction processing on the value;
The weight of the difference between the approximate inventory weight for each product in the inventory data generated in the approximate inventory weight calculation step and the accurate inventory weight for each product calculated in the accurate inventory weight calculation step is calculated for the product. a difference weight calculation step for calculating each
including
A difference weight calculation program characterized by:

Images