JP7389875B2 - Inventory value adjustment device, inventory value adjustment method, and inventory value adjustment program - Google Patents

Description

The present invention relates to an inventory amount adjustment device, an inventory amount adjustment method, and an inventory amount adjustment program.

In the steel industry, distributors/wholesalers (equivalent to midstream companies in steel distribution) purchase steel products (purchases from steel manufacturers such as blast furnace manufacturers (equivalent to upstream companies in steel distribution)) or sell sales (equivalent to upstream companies in steel distribution). Several months after the sales to companies (equivalent to downstream companies in steel distribution) are recorded, the unit price of the steel product changes as a result of price negotiations between the steel manufacturer and the consumer. Sometimes. Additionally, in the steel industry, when there is a change in unit price, distributors/wholesalers are required to revise the recorded past transactions of steel products whose unit price has changed to the unit price after the change (retroactive unit price). It is business practice to carry out the following. For accounting purposes, retroactivity of unit prices is performed by creating red transaction data for offsetting transaction data based on the unit price before the change and creating black transaction data based on the unit price after the change.

In addition, while responding to the above business practices, distributors/wholesalers should also keep in mind that if a portion of their inventory has been withdrawn (for example, due to sales or processing) for steel products whose unit prices have fluctuated, It is necessary to adjust the inventory amount by the difference between the unit price before and after the change (the amount minus the unit price before the change from the unit price after the change) (``adjustment of inventory amount due to retrospective unit price adjustment'').

Patent Document 1 states that by creating a new sales format between the user, the sales side, and the manufacturing side, product transactions can be carried out efficiently without waste, and high-quality products can always be provided immediately to the user. A product trading system that can be used has been disclosed. In particular, paragraph 0083 of Patent Document 1 states, ``The information regarding the steel plate includes price information of the steel plate when the selling side 120(x) has ownership of the steel plate, and for example, the information is updated. "The function 113 updates (corrects/changes) the price information (inventory evaluation information) based on changes in the price of iron plates."

Japanese Patent Application Publication No. 2003-162618

However, for distributors/wholesalers, the current situation is that work related to adjusting inventory amounts due to retroactive unit prices is performed manually by the person in charge, so it is important to consider the efficiency and accuracy of the work. From this perspective, there is still room for improvement. Note that Patent Document 1 does not describe or suggest a specific information processing means for realizing the adjustment of the inventory amount due to retroactivity of the unit price.

The present invention has been made in view of the above-mentioned problems, and is an inventory amount adjustment device and an inventory amount adjustment method that can efficiently and accurately adjust the inventory amount due to retroactivity of unit prices in distributors/wholesalers. and to provide an inventory value adjustment program.

In order to solve the above-mentioned problems and achieve the purpose, an inventory amount adjustment device according to the present invention is an inventory amount adjustment device that includes a control unit that adjusts the inventory amount by retroactively revising the revised unit price for purchased purchases that have already been accounted for. In the amount adjustment device, the control unit stores inventory data including inventory quantities and inventory amounts at the end of each month for products whose inventory is managed on a first-in, first-out basis, receipt and payment data including the receipt and payment quantities of the products on each day, and Based on the period set as a condition when specifying the purchase subject to the retroactive process, for the product, the first inventory quantity, which is the inventory quantity on the day before the start date of the period, and the current inventory quantity. A second inventory quantity which is the inventory quantity, a payout quantity from the start date to the current date, a first purchase quantity which is the purchase quantity from the start date to the end date of the period, and one day after the end date. Calculation means for calculating a second purchase quantity, which is the purchase quantity from the date to the current date, and if the disbursement quantity is less than the first stock quantity, the revised unit price is subject to the retroactivity. Create movement data that includes the product of the difference after subtracting the unit price included in the purchase data of the product and the first purchase quantity as an adjustment amount of the stock price of the product, and make sure that the paid quantity is the first stock. If it is larger than the quantity and less than the sum of the first inventory quantity and the first purchase quantity, the product of the quantity obtained by subtracting the second purchase quantity from the second inventory quantity and the difference price is calculated as the product of the product. a creation means for creating movement data to be included as an adjustment amount of the inventory amount, and a month end immediately preceding the start date of the product included in the inventory data, based on the adjustment amount included in the movement data created by the creation means; and an adjustment means for adjusting the inventory amount. In addition, in the inventory value adjustment device according to the present invention, the product may be a steel product, and the unit price may be negotiated between a steel manufacturer and a consumer.

Further, the inventory amount adjustment method according to the present invention is performed by the control unit of an information processing device including a control unit, which adjusts the inventory amount by retroactively revising the revised unit price for purchases that have already been accounted for. The adjustment method includes inventory data including the inventory quantity and inventory amount at the end of each month of products whose inventory is managed on a first-in, first-out basis, and the receipt and payment amount including the receipt and payment quantity of the products on each day, which is executed by the control unit. Based on the data and the period set as the condition for specifying the retroactive purchase, the first inventory quantity, which is the inventory quantity on the date one day before the start date of the said period, and the current a second inventory quantity which is the inventory quantity on the date, a payout quantity from the start date to the current date, a first purchase quantity which is the purchase quantity from the start date to the end date of the period, and one of the end date. a calculation step of calculating a second purchase quantity, which is the purchase quantity from a later date to the current date; and, if the paid-out quantity is less than the first stock quantity, the unit price after the revision is calculated to be subject to retroactivity; Create movement data that includes the product of the difference obtained by subtracting the unit price included in the purchase data of the product and the first purchase quantity as an adjustment amount of the inventory amount of the product, and If it is greater than one inventory quantity and less than the sum of the first inventory quantity and the first purchase quantity, the product of the quantity obtained by subtracting the second purchase quantity from the second inventory quantity and the difference amount, A creation step of creating movement data to be included as an adjustment amount of the inventory amount of the product, and based on the adjustment amount included in the movement data created in the creation step, immediately before the start date of the product included in the inventory data. and an adjustment step of adjusting the inventory amount at the end of the month.

Further, the inventory value adjustment program according to the present invention is an inventory value adjustment program that is executed by the control unit of an information processing device including a control unit, which adjusts the inventory value by retroactively revising the revised unit price for purchased purchases that have already been accounted for. The amount adjustment program includes inventory data including the inventory quantity and inventory amount at the end of each month for products whose inventory is managed on a first-in, first-out basis, and the amount of receipts and payments for each day of the products, to be executed by the control unit. Based on the included receipt and payment data and the period set as a condition when specifying the retroactive purchase, for the product, the first inventory quantity is the inventory quantity as of the day before the start date of the period. , a second inventory quantity that is the inventory quantity on the current date, a payout quantity from the start date to the current date, a first purchase quantity that is the purchase quantity from the start date to the end date of the period, and the end date. a calculation step of calculating the second purchase quantity, which is the purchase quantity from the date one day after the above to the current date; Create movement data that includes the product of the difference after subtracting the unit price included in the purchase data of the target product and the first purchase quantity as an adjustment amount of the inventory amount of the product, and If it is greater than the first inventory quantity and less than the sum of the first inventory quantity and the first purchase quantity, the product of the quantity obtained by subtracting the second purchase quantity from the second inventory quantity and the difference amount; a creation step of creating movement data including as an adjustment amount of the inventory amount of the product, and the start date of the product included in the inventory data based on the adjustment amount included in the movement data created in the creation step. and an adjustment step of adjusting the inventory amount at the end of the month immediately before.

Further, the inventory amount adjustment device according to the present invention is an inventory amount adjustment device that includes a control unit that adjusts the inventory amount by retroactively revising the revised unit price for purchases that have already been accounted for, and the control unit includes: From the inventory data storage area that stores inventory data including warehousing slip identification information, inventory quantity and inventory value of the product, purchase data of the product that includes warehousing slip identification information and is included in the retroactive target. an inventory acquisition means that acquires inventory data that includes the same information as the warehousing slip identification information, and the difference obtained by subtracting the unit price included in the purchase data from the revised unit price and the inventory data that is included in the inventory data acquired by the inventory acquisition means. A creation means for creating movement data that includes the product of the product with the inventory quantity as an adjustment amount of the inventory amount of the product, and an inventory acquisition means that acquires the movement data based on the adjustment amount included in the movement data created by the creation means. The present invention is characterized by comprising an adjustment means for adjusting the inventory amount included in the inventory data. In addition, in the inventory value adjustment device according to the present invention, the inventory data can further store warehousing slip identification information included in the inventory data of the product that is the source of the product whose inventory is managed using the data as the original warehousing slip identification information. The inventory acquisition means may further acquire inventory data that includes the same original warehousing slip identification information as the warehousing slip identification information included in the purchase data from the inventory data storage area. Furthermore, in the inventory value adjustment device according to the present invention, the product may be a steel product, and the unit price may be negotiated between a steel manufacturer and a consumer.

Further, the inventory amount adjustment method according to the present invention is performed by the control unit of an information processing device including a control unit, which adjusts the inventory amount by retroactively revising the revised unit price for purchases that have already been accounted for. The adjustment method is executed by the control unit and purchases the product including the incoming slip identification information from an inventory data storage area that stores inventory data including the incoming slip identification information, the inventory quantity and the inventory value of the product. an inventory acquisition step of acquiring inventory data that includes the same incoming slip identification information included in the data that is subject to retroactivity, and subtracting the unit price included in the purchase data from the revised unit price. a creation step of creating movement data that includes the product of the difference and the inventory quantity included in the inventory data acquired in the inventory acquisition step as an adjustment amount of the inventory amount of the product; and and an adjustment step of adjusting the inventory amount included in the inventory data acquired in the inventory acquisition step, based on the adjustment amount.

Further, the inventory value adjustment program according to the present invention is an inventory value adjustment program that is executed by the control unit of an information processing device including a control unit, which adjusts the inventory value by retroactively revising the revised unit price for purchased purchases that have already been accounted for. The amount adjustment program is a price adjustment program that is to be executed by the control unit, and is to execute a program for calculating the amount of goods including the receipt slip identification information from an inventory data storage area that stores inventory data including the stock receipt identification information, the stock quantity and the stock amount of the product. an inventory acquisition step of acquiring inventory data that includes the same incoming slip identification information that is included in the purchase data that is subject to retroactivity; and a unit price that is included in the purchase data based on the revised unit price. a creation step of creating movement data that includes the product of the subtracted difference and the inventory quantity included in the inventory data acquired in the inventory acquisition step as an adjustment amount of the inventory amount of the product; and movement data created in the creation step. The method is characterized by comprising an adjustment step of adjusting the inventory amount included in the inventory data acquired in the inventory acquisition step, based on the adjustment amount included in the inventory data acquired in the inventory acquisition step.

The present invention has the effect that it is possible to efficiently and accurately adjust the inventory amount due to retroactivity of unit prices at distributors/wholesalers.

FIG. 1 is a block diagram showing an example of the configuration of an inventory value adjustment device according to the first embodiment. FIG. 2 is a diagram illustrating an example of a flowchart regarding the inventory amount adjustment process according to the first embodiment. Figure 3 is a diagram showing specific examples of inventory on the day before the start date of the unit price lookback period, receipts and payments after the start date of the unit price lookback period, and current inventory by inventory management method (A: first in, last out; b: first in, first out). ). FIG. 4 is a diagram showing a specific example of an execution pattern of movement data creation and inventory price adjustment. FIG. 5 is a diagram showing a specific example of an execution pattern of movement data creation and inventory price adjustment. FIG. 6 is a diagram showing a specific example of points for cost adjustment. FIG. 7 is a block diagram illustrating an example of the configuration of the inventory amount adjustment device according to the second embodiment. FIG. 8 is a diagram illustrating an example of a flowchart regarding the inventory amount adjustment process according to the second embodiment. FIG. 9 is a diagram showing a specific example of movement data creation and inventory price adjustment. FIG. 10 is a diagram showing a specific example of movement data creation and inventory price adjustment. FIG. 11 is a diagram showing a specific example of movement data creation and inventory price adjustment. FIG. 12 is a diagram showing a specific example of movement data creation and inventory price adjustment. FIG. 13 is a diagram showing a specific example of movement data creation and inventory price adjustment.

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments (first embodiment and second embodiment) of an inventory amount adjustment device, an inventory amount adjustment method, and an inventory amount adjustment program according to the present invention will be described below in detail based on the drawings. Note that the present invention is not limited to this embodiment.

[1. First embodiment]
A first embodiment of the present invention will be described in detail with reference to FIGS. 1 to 6.

[1-1. composition]
An example of the configuration of the inventory price adjustment device according to the first embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of an inventory value adjustment device according to the first embodiment.

The inventory amount adjustment device 100 adjusts the inventory amount by retroactively revising the revised unit price for purchases that have already been accounted for. Inventory amount adjustment device 100 is a commercially available desktop personal computer. Note that the inventory amount adjustment device 100 is not limited to stationary information processing devices such as desktop personal computers, but also mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may be a type information processing device.

The inventory amount adjustment 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 inventory amount adjustment device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the inventory amount adjustment device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the inventory value adjustment device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server device 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

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

The storage unit 106 includes an inventory data storage unit 106a that stores inventory data, a receipt and payment data storage unit 106b that stores receipt and payment data, and the like.

The inventory data includes data regarding the inventory quantity and inventory value at the end of each month (for example, 4/30, 5/31, 6/30, etc.) of products whose inventory is managed on a first-in, first-out basis. Inventory data includes, for example, product identification information, month-end date, inventory quantity, and inventory value.

The receipt and payment data includes data regarding the quantity of products received and paid for each day (purchased quantity, sales quantity, etc.). If the product is a steel product, the receipt and payment data may include, for example, the inventory quantity increased by 2 pieces/20 kg due to purchasing input on May 2nd, or the inventory quantity decreased by 3 pieces/30 kg due to sales input on May 18th. , etc. The receipt and payment data includes, for example, product identification information, date, receipt and payment quantity, and receipt and payment amount. For example, if the quantity received or paid and the amount received or paid are increased due to purchasing, they are held as a positive value, and when they are decreased due to sales, etc., they are held as a negative value.

The control unit 102 is a CPU or the like that controls the inventory amount adjustment device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

Functionally, the control unit 102 includes a calculation unit 102a, a creation unit 102b, and an adjustment unit 102c.

The calculation unit 102a calculates one of the starting dates of the period for the product based on inventory data, receipt and payment data, and a period (start date and end date) set as conditions for specifying purchases to be retroactive. The first inventory quantity is the inventory quantity on the previous day's date, the second inventory quantity is the inventory quantity on the current date (for example, the date when the calculation unit 102a operates), the payout quantity from the start date to the current date, and the quantity from the start date. A first purchase quantity, which is the purchase quantity up to the end date of the period, and a second purchase quantity, which is the purchase quantity from the date one day after the end date to the current date, are calculated.

Here, the first inventory quantity is calculated based on inventory data if the date one day before the start date is the end of the month, and is calculated based on the inventory data and receipt and payment data if the date is not the end of the month. For example, if the date (e.g. 4/2) that is one day before the start date (e.g. 4/3) is not the end of the month (e.g. 4/30), (1) the month to which the date (e.g. 4/2) belongs; (2) The inventory quantity on the last day (e.g. 3/31) of the month before the month (e.g. March) (e.g. April) is extracted from the inventory data, and (2) on the last day (e.g. 3/31) The amount of receipts and payments (positive numbers for purchases, negative numbers for sales, etc.) for each day from the date one day later (example: 4/1) to the relevant date (example: 4/2) is the receipt and payment data. (3) The sum of the extracted inventory quantity and the received and paid quantity is calculated as the first inventory quantity on the date (for example, 4/2).

Further, the second inventory quantity is calculated based on the inventory data if the current date is the end of the month, and is calculated based on the inventory data and the receipt and payment data if the current date is not the end of the month. The method of calculating the second inventory quantity is the same as the method of calculating the first inventory quantity, so a description thereof will be omitted.

The payout quantity is calculated based on the received and paid quantities for each day from the start date to the current date, which are negative numbers.

The first purchase quantity is calculated based on the quantity received and paid for each day from the start date to the end date that has a positive value.

The second purchase quantity is calculated based on the receipt and payment quantities for each day from the date one day after the end date to the current date, which are positive numbers.

If the delivery quantity is less than the first stock quantity, the preparation unit 102b multiplies the difference obtained by subtracting the unit price included in the purchase data of the product targeted for retroactivity from the revised unit price and the first purchase quantity. Create movement data that includes as the adjustment amount of the product inventory amount, and if the withdrawal quantity is greater than the first inventory quantity and less than the sum of the first inventory quantity and the first purchase quantity, it will be transferred from the second inventory quantity. Movement data is created that includes the product of the quantity obtained by subtracting the second purchase quantity and the difference amount as an adjustment amount of the inventory amount of the product.

Here, the purchase data that is subject to retroactivity is stored in the purchase data storage area, for example, based on the period (start date and end date) that is set as a condition when specifying purchases that are subject to retroactivity. (The inventory value adjustment device 100 may include information processing means for executing this extraction.) Here, the purchase data includes, for example, purchase slip number, purchase accounting date (warehousing date), customer identification information (supplier), product identification information, quantity, price (= quantity x unit price), unit price ( (equivalent to the unit price before the revision), etc. Further, the revised unit price is, for example, what is input by the operator with respect to the extracted purchase data. Further, the adjustment amount will be a positive value if the revised unit price is larger than the pre-revised unit price, and will be a negative value if the revised unit price is smaller than the pre-revised unit price.

The adjustment unit 102c adjusts the inventory amount at the end of the month immediately before the product start date, which is included in the inventory data, based on the adjustment amount included in the movement data created by the creation unit 102b. Specifically, the adjustment amount is added to the inventory amount at the end of the month (however, if the adjustment amount is a negative number, it corresponds to a subtraction).

[1-2. process]
Here, an example of the inventory amount adjustment process executed by the inventory amount adjustment device 100 will be described with reference to FIG. 2 and the like. FIG. 2 is a diagram illustrating an example of a flowchart regarding the inventory amount adjustment process according to the first embodiment. Figure 3 is a diagram showing specific examples of inventory on the day before the start date of the unit price lookback period, receipts and payments after the start date of the unit price lookback period, and current inventory by inventory management method (A: first in, last out; b: first in, first out). ). FIGS. 4 and 5 are diagrams showing specific examples of execution patterns for movement data creation and inventory amount adjustment.

In this description, it is assumed that the inventory value adjustment device 100 is used by a distributor/wholesaler (midstream company) that exists between a steel manufacturer (upstream company) and a consumer (downstream company) in steel distribution. Assuming that. In addition, in this explanation, the product is a steel product (steel product), and the unit price is determined by the steel manufacturer (for example, a blast furnace manufacturer), which is the supplier for the distributor/wholesaler, and the sales destination for the distributor/wholesaler. Prices shall be determined through periodic price negotiations with corresponding consumers.

First, the calculation unit 102a calculates inventory data, receipt and payment data, and objects to be retroactive on a unit price retroactive processing screen (not shown) for retroactively revising revised unit prices for transactions that have already been recorded (purchases and sales). Based on the product identification information and unit price retrospective period (start date and end date) set as conditions for specifying the purchase, for steel products specified by the product identification information, one day before the start date. The first inventory quantity on the date (corresponding to the current inventory number J shown in Figure 3), the second inventory quantity on the date at the time of execution of this process (corresponding to the current inventory quantity K shown in Figure 3), and this process from the relevant start date. The payout quantity up to the date at the time of execution (corresponding to the cumulative payout number D + cumulative payout number G shown in Figure 3), the first purchase quantity from the start date to the end date (corresponding to the cumulative purchase number B shown in Figure 3) (corresponding to the total purchase quantity C shown in FIG. 3) and a second purchase quantity (corresponding to the cumulative purchase quantity C shown in FIG. 3) from the date one day after the end date to the date at the time of execution of this process (step SA1).

Next, if the payout quantity calculated in step SA1 is less than or equal to the first inventory quantity calculated in step SA1 (step SA2: Yes), the preparation unit 102b generates a message that says, Transfer data is created that includes the product of the "difference after subtracting the unit price included in the input data" and the first purchase quantity calculated in step SA1 as an adjustment amount for the inventory amount of the product (step S3). Here, the purchase data targeted for retroactivity is extracted from the purchase data storage area based on the set product identification information and unit price retroactivity period. Further, the revised unit price is, for example, the one input by the operator with respect to the extracted purchase data. Note that for a specific example of the process of step SA3, refer to pattern 1 in FIG. 4.

On the other hand, if the payout quantity calculated in step SA1 is not less than the first stock quantity calculated in step SA1 (step SA2: No), the said payout quantity is the first stock quantity and the first purchase quantity calculated in step SA1. When the sum is equal to or less than the sum of the quantity (Step SA4: Yes), the preparation unit 102b generates the quantity obtained by subtracting the second purchase quantity calculated in Step SA1 from the second inventory quantity calculated in Step SA1 and the revised quantity. Transfer data is created that includes the product of the unit price minus the unit price included in the purchase data of the product targeted for retroactivity as the adjustment amount for the product inventory amount (step SA5). Specifically, movement data is created that includes the product as the adjustment amount, the movement quantity is zero, the date at the time of execution of this process, and the set product identification information. Note that for a specific example of the process of step SA5, refer to pattern 3 in FIG. 4 and FIG. 5.

Next, the adjustment unit 102c adds the amount of inventory included in the movement data created in step SA3 or step SA5 to the inventory amount at the end of the month immediately before the start date of the product specified by the set product identification information, which is included in the inventory data. The inventory amount is adjusted by adding the adjustment amount (step SA6).

[1-3. Summary of first embodiment]
As described above, in the first embodiment, the adjustment of the inventory amount corresponding to the inventory management method for each inventory management key (for example, the method of managing the inventory using only the product code) has been described. According to the first embodiment, the distributor/wholesaler can efficiently and accurately adjust the inventory amount due to the retrospective revision of the revised unit price for purchased purchases that have already been accounted for. For example, the first embodiment can solve the problem illustrated in FIG. FIG. 6 is a diagram showing a specific example of points for cost adjustment.

Furthermore, the first embodiment is useful not only in the steel industry but also in industries where unit prices fluctuate due to imports (for example, manufacturers that handle various materials).

[2. Second embodiment]
A second embodiment of the present invention will be described in detail with reference to FIGS. 7 to 13.

[2-1. composition]
An example of the configuration of the inventory price adjustment device according to the second embodiment will be described with reference to FIG. 7. FIG. 7 is a block diagram illustrating an example of the configuration of the inventory amount adjustment device according to the second embodiment.

The inventory amount adjustment device 100 adjusts the inventory amount by retroactively revising the revised unit price for purchases that have already been accounted for. Inventory amount adjustment device 100 is a commercially available desktop personal computer. Note that the inventory amount adjustment device 100 is not limited to stationary information processing devices such as desktop personal computers, but also mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers. It may be a type information processing device.

The inventory amount adjustment 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 inventory amount adjustment device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the inventory amount adjustment device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of connecting the inventory value adjustment device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server device 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108 . As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Note that in the following description, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

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

The storage unit 106 stores an inventory data storage unit 106c that stores inventory data.

The inventory data includes data regarding incoming slip identification information, inventory quantity and inventory value of products, and the like. Note that the inventory data may be capable of further storing warehousing slip identification information included in the inventory data of the product that is the source (origin) of the product whose inventory is managed using the data, as the original warehousing slip identification information. The inventory data includes, for example, a warehousing slip number, a warehousing date, product identification information, an inventory quantity, an inventory amount (=inventory quantity x unit price), a unit price, and a former warehousing slip number. Inventory data is linked to purchase data using warehousing slip identification information. Purchase data includes, for example, purchase slip number, purchase accounting date (warehousing date), customer identification information (supplier), product identification information, purchase quantity, purchase amount (= purchase quantity x unit price) , unit price, receipt slip number, etc.

The control unit 102 is a CPU or the like that controls the inventory amount adjustment device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute.

The control unit 102 functionally includes an inventory acquisition unit 102d, a creation unit 102e, and an adjustment unit 102f.

The inventory acquisition unit 102d acquires, from the inventory data storage unit 106c, inventory data that includes the same inventory receipt identification information as the inventory receipt identification information included in the item that is subject to retroactivity and is product purchasing data that includes the inventory receipt identification information. do. Note that if the inventory data is such that it is possible to further store the original warehousing slip number, the inventory acquisition unit 102d retrieves the same warehousing slip identification information included in the purchase data from the inventory data storage unit 106c as the original warehousing slip number. Inventory data included as identification information may also be acquired. Here, the purchase data targeted for retroactivity is extracted from the purchase data storage area based on the period (start date and end date) set as the condition when specifying the purchases targeted for retroactivity. (The inventory value adjustment device 100 may include information processing means for executing this extraction.)

The creation unit 102e calculates the product of the difference obtained by subtracting the unit price included in the purchase data that is subject to retroactivity from the revised unit price and the inventory quantity included in the inventory data acquired by the inventory acquisition unit 102d. Create movement data to be included as an adjustment amount. Here, the revised unit price is, for example, the one input by the operator with respect to the extracted purchase data. Further, the adjustment amount will be a positive value if the revised unit price is larger than the pre-revised unit price, and will be a negative value if the revised unit price is smaller than the pre-revised unit price.

The adjustment unit 102f adjusts the inventory amount included in the inventory data acquired by the inventory acquisition unit 102d based on the adjustment amount included in the movement data created by the creation unit 102e. Specifically, the adjustment amount is added to the inventory amount (however, if the adjustment amount is a negative number, it corresponds to a subtraction).

[2-2. process]
Here, an example of the inventory amount adjustment process executed by the inventory amount adjustment device 100 will be described with reference to FIG. 8 and the like. FIG. 8 is a diagram illustrating an example of a flowchart regarding the inventory amount adjustment process according to the second embodiment.

In this description, it is assumed that the inventory value adjustment device 100 is used by a distributor/wholesaler (midstream company) that exists between a steel manufacturer (upstream company) and a consumer (downstream company) in steel distribution. Assuming that. In addition, in this explanation, the product is a steel product (steel product), and the unit price is determined by the steel manufacturer (for example, a blast furnace manufacturer), which is the supplier for the distributor/wholesaler, and the sales destination for the distributor/wholesaler. Prices shall be determined through periodic price negotiations with corresponding consumers.

First, the inventory acquisition unit 102d acquires, from the inventory data storage unit 106c, inventory data that includes the same warehousing slip identification information included in the purchase data targeted for retroactivity (step SB1). Note that if the inventory data is such that it is possible to further store the original warehousing slip number, in step SB1, inventory data that includes the same warehousing slip identification information as the warehousing slip identification information included in the purchase data is further acquired. You may. Here, the purchasing data that is subject to retroactive data can be retroactively used, for example, on the unit price retroactive processing screen (not shown) for retroactively revising the revised unit price for transactions that have already been recorded (purchases/sales). This information is extracted from the purchase data storage area based on the product identification information and unit price retrospective period (start date and end date) set as conditions for specifying the target purchase.

Next, the preparation unit 102e calculates the product of the difference obtained by subtracting the unit price included in the purchase data that is subject to retroactivity from the revised unit price and the inventory quantity included in the inventory data acquired in step SB1. The movement data to be included as the adjustment amount of the inventory amount is created (step SB2). Specifically, movement data is created that includes the seat in question as an adjustment amount, the movement quantity is zero, the date at the time of execution of this process, and the set product identification information. Here, the revised unit price is, for example, the one input by the operator with respect to the extracted purchase data.

Next, the adjustment unit 102f adjusts the inventory amount by adding the adjustment amount included in the movement data created in step SB2 to the inventory amount included in the inventory data acquired in step SB1 (step SB3). .

[2-3. Summary of second embodiment]
As mentioned above, in the second embodiment, the adjustment of the inventory amount corresponding to the inventory management method in units of warehousing details has been described. According to the second embodiment, as in case 1 shown in FIG. 9, movement data for inventory adjustment can be created, and the inventory value of inventory data can be adjusted based on the created movement data. Further, according to the second embodiment, by providing the original stocking slip number to the inventory data, the base material can be It is possible to create movement data for inventory adjustment and adjust the inventory value of inventory data based on the created movement data, not only for processed goods but also for processed goods. In light of the current situation where the majority of companies are distributors/wholesalers, but do processing for a living, they are now able to adjust the inventory value of processed products. Note that FIGS. 9 to 13 are diagrams showing specific examples of movement data creation and inventory amount adjustment.

According to the second embodiment, the distributor/wholesaler can efficiently and accurately adjust the inventory amount due to retroactivity of the revised unit price for purchased purchases that have already been accounted for. For example, similar to the first embodiment, the problem illustrated in FIG. 6 can be solved.

Further, the second embodiment is useful not only in the steel industry but also in industries where unit prices fluctuate due to imports (for example, manufacturers that handle various materials).

[3. Other embodiments]
In addition to the embodiments described above, the present invention may be implemented in various different embodiments 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 performed automatically can be performed manually, or all of the processes described as being performed manually can be performed manually. Alternatively, some of the steps can be performed automatically using known methods.

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

Further, regarding the inventory amount adjustment device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the inventory value adjustment device 100, particularly each processing function performed by the control unit, may be realized by a CPU and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware using wired logic. Note that the program is recorded on a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing device to execute the processing described in the embodiment, and the inventory value adjustment device Machine read to 100. That is, a storage unit such as a ROM or an HDD (Hard Disk Drive) stores a computer program that cooperates with an OS to give instructions to a CPU and perform various processes. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

Further, this computer program may be stored in an application program server connected to the inventory value adjustment device 100 via an arbitrary network, and all or part of it may be downloaded as necessary. It is.

Further, a program for executing the processes described in the embodiments may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EE. PROM (registration Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk) ), DVD (Digital Versatile Disk), Blu-ray (registered trademark) Disc, etc. shall include any “portable physical medium”.

Further, a "program" is a data processing method written in any language or writing method, and does not matter in the form of source code or binary code. Note that a "program" is not necessarily limited to a unitary structure, but may be distributed as multiple modules or libraries, or may work together with separate programs such as an OS to achieve its functions. Including things. Note 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, and the installation procedure after reading.

The various databases stored in the storage unit are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and are used for various processing and website provision. Stores programs, tables, databases, web page files, etc.

Further, the inventory amount adjustment 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 any peripheral device is connected. In addition, the inventory amount adjustment device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in the embodiment.

Furthermore, the specific form of dispersion and integration of devices is not limited to what is shown in the diagram, and all or part of them can be functionally or physically divided into arbitrary units according to various additions or functional loads. It can be configured in a distributed/integrated manner. That is, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively.

The present invention is particularly useful in the steel industry.

100 Inventory amount adjustment device 102 Control unit
102a Calculation unit
102b Creation Department
102c Adjustment section
102d Inventory acquisition department
102e Creation Department
102f adjustment section 104 communication interface section 106 storage section
106a Inventory data storage unit
106b Receipt and payment data storage unit
106c Inventory data storage unit 108 Input/output interface unit 112 Input device 114 Output device 200 Server device 300 Network

Claims (5)

An inventory amount adjustment device comprising a control unit that adjusts the inventory amount by retroactively revising the revised unit price for recorded purchases,
The control unit includes:
From the inventory data storage area that stores inventory data including warehousing slip identification information, inventory quantity and inventory value of the product, purchase data of the product that includes warehousing slip identification information and is included in the retroactive target. inventory acquisition means for acquiring inventory data that includes the same information as the inventory receipt identification information;
Transfer data that includes the product of the difference obtained by subtracting the unit price included in the purchase data from the revised unit price and the inventory quantity included in the inventory data acquired by the inventory acquisition means as an adjustment amount of the inventory amount of the product. a creation means to create;
Adjustment means for adjusting the inventory amount included in the inventory data acquired by the inventory acquisition means based on the adjustment amount included in the movement data created by the creation means;
to have
An inventory amount adjustment device characterized by: The inventory data can further store warehousing slip identification information included in the inventory data of the product that is the source of the product whose inventory is managed using the data, as the original warehousing slip identification information,
The inventory acquisition means further acquires inventory data that includes the same original inventory slip identification information as the inventory slip identification information included in the purchase data from the inventory data storage area;
The inventory amount adjustment device according to claim 1, characterized in that: The product is a steel product, and the unit price is negotiated between the steel manufacturer and the consumer;
The inventory amount adjustment device according to claim 1 or 2, characterized in that: An inventory amount adjustment method executed by the control unit of an information processing device including a control unit, which adjusts the inventory amount by retroactively revising the revised unit price for recorded purchases,
executed by the control unit,
From the inventory data storage area that stores inventory data including warehousing slip identification information, inventory quantity and inventory value of the product, purchase data of the product that includes warehousing slip identification information and is included in the retroactive target. an inventory acquisition step of acquiring inventory data that includes the same information as the receipt slip identification information;
Transfer data that includes the product of the difference obtained by subtracting the unit price included in the purchase data from the revised unit price and the inventory quantity included in the inventory data acquired in the inventory acquisition step as an adjustment amount of the inventory amount of the product. a creation step to create;
an adjustment step of adjusting the inventory amount included in the inventory data acquired in the inventory acquisition step based on the adjustment amount included in the movement data created in the creation step;
including;
An inventory amount adjustment method characterized by: An inventory amount adjustment program to be executed by a control unit of an information processing device , which adjusts an inventory amount due to retroactivity of revised unit prices for recorded purchases,
for the control unit to execute,
From the inventory data storage area that stores inventory data including warehousing slip identification information, inventory quantity and inventory value of the product, purchase data of the product that includes warehousing slip identification information and is included in the retroactive target. an inventory acquisition step of acquiring inventory data that includes the same information as the receipt slip identification information;
Transfer data that includes the product of the difference obtained by subtracting the unit price included in the purchase data from the revised unit price and the inventory quantity included in the inventory data acquired in the inventory acquisition step as an adjustment amount of the inventory amount of the product. a creation step to create;
an adjustment step of adjusting the inventory amount included in the inventory data acquired in the inventory acquisition step based on the adjustment amount included in the movement data created in the creation step;
causing the control unit to execute
An inventory amount adjustment program featuring:

Images