JP7336003B2 - Unit Price Retroactive Processing Device, Unit Price Retroactive Processing Method and Unit Price Retroactive Processing Program - Google Patents

Description

The present invention relates to a unit price retroactive processing device, a unit price retroactive processing method, and a unit price retroactive processing 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 (demand A few months after recording sales to households (equivalent to downstream companies in steel distribution), the unit price of the steel product fluctuates as a result of price negotiations between steel manufacturers and consumers. Sometimes. Also, in the steel industry, when there is a change in unit price, distributors/wholesalers will revise the unit price after the change (retroactive unit price) for past transactions of steel products whose unit price has changed. It is commercial practice to implement

In Patent Document 1, when the product price is changed within the period until closing, the billing slip that has already been created based on the old price is discarded, and a billing slip is generated using the changed price. A trading device or the like is disclosed.

JP 2008-181236 A

Here, retroactive unit price in distributors/wholesalers is implemented for purchases or sales. Wholesalers may retroactively implement a total of four patterns of unit prices. Specifically, distributors/wholesalers are required to (1) retroactively determine the unit price of purchases based on the date of the contract with the supplier (steel manufacturer), and (2) determine the criteria for revaluation of inventory. (3) retroactive unit price for sales based on the delivery date related to the delivery of products to the sales destination (consumer); ), there is a possibility that the unit price will be retroactively applied to sales based on the contract date. In addition, the unit price retroactively is performed by creating transaction red data for canceling transaction data based on the unit price before the change and creating transaction black data based on the unit price after the change in terms of accounting.

However, with the technique described in Patent Document 1, it is difficult to retroactively trace the unit prices of these four patterns (that is, create transaction red/black data) efficiently and conveniently for the operator. In other words, there is still room for improvement from the perspective of efficiency and convenience in terms of retroactive unit price operations performed by distributors/wholesalers.

The present invention has been made in view of the above-mentioned problems, and is capable of efficiently and conveniently for operators to trace back unit prices of four patterns (that is, create transaction red/black data) that can be implemented in distributors/wholesalers. It is an object of the present invention to provide a unit price retrospective processing device, a unit price retrospective processing method, and a unit price retrospective processing program that can perform the above.

In order to solve the above-mentioned problems and achieve the object, the unit price retrospective processing device according to the present invention is provided by: An area for selecting one of the third retroactive and fourth retroactive, which means retroactive, and the identification information of the supplier or the sales destination, the start date and end date of the period, and the inventory evaluation If the first retrospective is selected on the screen that includes the reference date for the replacement and the area for setting the product identification information of the product, the Output the purchase data corresponding to the period from the start date to the end date set on the screen for the contract date related to the contract with the supplier specified by the vendor identification information, and (2) second is selected, the purchase data that includes the supplier identification information and product identification information set on the screen and whose recording date is before the reference date set on the screen, and the purchase Output the inventory data that corresponds to the data, the receipt date is the same as the reference date, and the quantity is not zero, and (3) if the third retroactive is selected on the screen, set it on the screen The start date on which the delivery date related to the delivery of the product specified by the product identification information to the sales destination specified by the supplier identification information is set on the screen (4) If the fourth retroactive option is selected on the screen, the transaction including the supplier identification information and product identification information set on the screen and the transaction Output execution means for outputting sales data corresponding to the period from the start date to the end date set on the screen for the contract date related to the contract with the sales destination specified by the destination identification information, and output by the output execution means. importing means for importing the purchase data or sales data in which the revised unit price is entered; , purchase red data for canceling the purchase data in which the unit price before the revision is set and purchase black data in which the unit price after the revision is set are created, and the sales data is captured by the capturing means. If so, based on the imported sales data, create red sales data to cancel the sales data with the unit price before the revision and black sales data with the revised unit price. A control unit comprising a creating means.

In the unit price retrospective processing apparatus according to the present invention, the product may be a steel product, and the unit price may be determined between a steel manufacturer corresponding to a supplier and a consumer corresponding to a sales destination.

In addition, the unit price retroactive processing method according to the present invention includes (1) first retroactive and second retroactive, meaning retroactive of the unit price for purchase and sales, executed by the control unit of an information processing apparatus having a control unit. an area for selecting either one of the third retroactive and fourth retroactive, which means retroactive unit price for the If the first retrospective is selected on the screen that includes the reference date for inventory revaluation and the area for setting the product identification information of the product, the business partner identification information and product identification information set on the screen are included. And output the purchase data corresponding to the period from the start date to the end date set on the screen for the contract date related to the contract with the supplier specified by the supplier identification information, (2) the screen If the second retroactive method is selected in , the purchase data includes the supplier identification information and product identification information set on the screen and the recording date is before the reference date set on the screen. Outputs inventory data that corresponds to the purchase data, has the same receipt date as the reference date, and has a non-zero quantity. The delivery date related to the delivery of the product specified by the product identification information, including the supplier identification information and product identification information set on the screen, to the sales destination specified by the supplier identification information is set on the screen. (4) If the fourth retrospective is selected on the screen, including the business partner identification information and product identification information set on the screen and an output execution step of outputting sales data corresponding to a period from the start date to the end date set on the screen in which the contract date pertaining to the contract with the sales destination specified by the supplier identification information is set; and the output execution step. An importing step of importing the purchase data or sales data output by the step into which the revised unit price is entered, and when the purchase data is imported by the importing step, the imported purchase data. Based on this, purchase red data for canceling the purchase data with the unit price before revision and purchase black data with the revised unit price are created. When the data is imported, based on the imported sales data, red sales data and black sales data with revised unit price are set to cancel the sales data with unit price before revision. and a creating step of creating a

In addition, a unit price retrospective processing program according to the present invention includes (1) a first retrospective and a second retrospective meaning retrospective of a unit price for purchase, to be executed by the control unit of an information processing apparatus having a control unit. and an area for selecting either one of the third retroactive and fourth retroactive that means retroactive of the unit price for sales, the identification information of the supplier or the sales destination, the start date and end of the period If the first retrospective is selected on the screen containing the date, the reference date for inventory revaluation, and the area for setting the product identification information, the business partner identification information and product identification information set on the screen and the contract date pertaining to the contract with the supplier specified by the supplier identification information falls within the period from the start date to the end date set on the screen, (2) If the second retroactive method is selected on the screen, purchase data that includes the supplier identification information and product identification information set on the screen and whose recording date is before the reference date set on the screen. If there is inventory data that corresponds to the purchase data and has the same receipt date as the reference date and the quantity is not zero, and (3) when the third retroactive is selected on the screen , the delivery date related to the delivery of the product specified by the product identification information to the sales destination specified by the supplier identification information set on the screen is displayed on the screen. Output the sales data corresponding to the period from the set start date to the end date; and an output execution step of outputting sales data corresponding to the period from the start date to the end date set on the screen for the contract date related to the contract with the sales destination specified by the business partner identification information; A capture step for capturing the purchase data or sales data output by the output execution step in which the revised unit price is entered; Based on the purchase data, purchase red data for canceling the purchase data in which the unit price before revision is set and purchase black data in which the revised unit price is set are created, and the import step is performed. If the sales data is imported by , based on the imported sales data, the sales red data to cancel the sales data with the unit price before revision and the sales with the unit price after revision are set. and a creating step of creating black data.

ADVANTAGE OF THE INVENTION The present invention has the effect of being able to efficiently and conveniently perform four patterns of unit price retrospective (that is, creation of transaction red/black data) that can be implemented by distributors/wholesalers.

FIG. 1 is a block diagram showing an example of the configuration of a unit price retrospective processing device. FIG. 2 is a diagram showing an example of a unit price retroactive processing screen. FIG. 3 is a diagram showing an example of a flowchart regarding unit price retroactive processing. FIG. 4 is a diagram showing an example of the retroactive determination of the unit price for purchase (creation of red/black data) based on the contract date of the contract with the supplier. FIG. 5 is a diagram showing an example of retroactive determination of unit prices (creation of red/black data) for purchases based on a reference date for inventory revaluation. FIG. 6 is a diagram showing an example of the retrospective lookup of the unit price for sales (creation of red/black data) based on the delivery date of the delivery of the product to the sales destination. FIG. 7 is a diagram showing an example of retroactively updating (creating red/black data) the unit price for sales based on the contract date related to the contract with the sales destination.

Embodiments of a unit price retrospective processing device, a unit price retrospective processing method, and a unit price retrospective processing program according to the present invention will be described in detail below with reference to the drawings. It should be noted that the present invention is not limited by this embodiment.

[1. composition]
An example of the configuration of the unit price retrospective processing apparatus according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a block diagram showing an example of the configuration of a unit price retrospective processing device.

The unit price retrospective processing device 100 is a commercially available desktop personal computer. Note that the unit price retrospective processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but can also be used in mobile devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smart phones, and tablet personal computers. type information processing device.

The unit price retrospective processing 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 unit price retrospective processing device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the unit price retrospective processing 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 unit price retrospective processing 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). Data stored in the storage unit 106 (for example, purchase data, sales data, etc., which will be described later) 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 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 stores a purchase data storage unit 106a that stores purchase data, a sales data storage unit 106b that stores sales data, an inventory data storage unit 106c that stores inventory data, and the like. ing.

The purchase data is for managing information related to purchases that are accounted for, for example, based on the receipt of goods. It includes data related to product identification information, quantity, price (=quantity x unit price), unit price, receipt slip number, and contract date (date related to contract with supplier).

Sales data is for managing information related to sales recorded on a shipping basis, for example, sales slip number, sales recording date (delivery date), business partner identification information (sales destination), product identification information, quantity , price (=quantity x unit price), unit price, delivery date (date related to delivery of goods to customer), contract date (date related to contract with customer), etc.

The inventory data includes, for example, the receipt slip number, receipt date, product identification information, quantity, price (=quantity×unit price), unit price, creation date (date when this inventory data was created), and the like. The inventory data storage unit 106c stores inventory data relating to the inventory at the end of the month as a history in addition to the inventory data relating to the current inventory.

The control unit 102 is a CPU or the like that comprehensively controls the unit price retrospective processing device 100 . 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. Execute.

The control unit 102 functionally and conceptually includes a display execution unit 102a, an output execution unit 102b, an acquisition unit 102c, and a creation unit 102d.

The display executing unit 102a causes the monitor 114 to display the unit price retrospective processing screen. Here, an example of the unit price retroactive processing screen will be described with reference to FIG. The unit price retrospective processing screen MA is any one of the first retrospective and second retroactive means retroactive unit price for purchasing and the third retroactive and fourth retroactive means retroactive unit price for sales. area MA1 for selecting, area MA2 for setting the identification information of suppliers or customers, area MA3 for setting the start date and end date of the period, and inventory revaluation It includes an area MA4 for setting the reference date, an area MA5 for setting product identification information, and an area MA6 for instructing execution of unit price retroactive processing.

It should be noted that the first retroactive means retroactive of the unit price for the purchase (retroactive of the unit price on the basis of the contract for the purchase) based on the contract date of the contract with the supplier. Further, the second retroactive means retroactive of the unit price for the purchase (retroactive of the unit price on the basis of inventory revaluation for the purchase) based on the reference date for inventory revaluation. Further, the third retroactive means retroactive of the unit price for sales (retroactive of unit price for sales based on the delivery date) based on the delivery date related to the delivery of the product to the sales destination. Further, the fourth retroactive means retroactive of the unit price for sales (retroactive of the unit price on a contract basis for sales) based on the contract date of the contract with the sales destination.

Returning to FIG. 1, when the first retroactive process is selected on the unit price retroactive processing screen, the output execution unit 102b retrieves from the purchase data storage unit 106a the supplier identification information and product identification information set on the screen. In addition, purchase data corresponding to the period from the start date to the end date set on the screen for the contract date related to the contract with the supplier specified by the supplier identification information is stored in a predetermined file format (for example, Excel (file format supported by (product name of spreadsheet software developed and sold by Microsoft Corporation), etc.) to a predetermined storage area.

When the second retroactive process is selected on the unit price retroactive processing screen, the output execution unit 102b retrieves from the purchase data storage unit 106a the Inventory data that is before the reference date set on the screen, corresponds to the purchase data, has the same receipt date as the reference date, and the quantity is not zero is stored in the inventory data storage unit 106c. Existing items are output to a predetermined storage area in a predetermined file format (for example, a file format supported by Excel (a product name of spreadsheet software developed and sold by Microsoft Corporation)).

When the third retroactive process is selected on the unit price retroactive processing screen, the output execution unit 102b retrieves the sales data storage unit 106b from the sales data storage unit 106b, including the customer identification information and product identification information set on the screen, and with the product identification information. The sales data corresponding to the period from the start date to the end date set on the screen where the delivery date of the specified product to the sales destination specified by the supplier identification information is set in the specified file format (for example, Excel ( (product name of spreadsheet software developed and sold by Microsoft Corporation), and output to a predetermined storage area in a file format supported by).

When the fourth retrospective is selected on the unit price retroactive processing screen, the output execution unit 102b retrieves from the sales data storage unit 106b the supplier identification information and product identification information set on the screen and Sales data corresponding to the period from the start date to the end date set on the screen for the contract date with the sales destination specified in the specified file format (for example, Excel (developed and sold by Microsoft Corporation) output to a specified storage area in a file format supported by the product name of the spreadsheet software).

The fetching unit 102c fetches the purchase data or the sales data output by the output execution unit 102b, in which the revised unit price is input. The revised unit price is input by the operator through the input device 112 .

When the purchase data is imported by the importing unit 102c, the creating unit 102d performs purchase data for canceling the purchase data in which the unit price before revision is set based on the purchase data thus obtained. Red data and purchase black data in which the revised unit price is set are created, and the created data is stored in the purchase data storage unit 106a.

When the sales data is imported by the importing unit 102c, the creating unit 102d generates red sales data and revised sales data for canceling the sales data in which the unit price before the revision is set, based on the imported sales data. Sales data in which the subsequent unit price is set is created, and the created data is stored in the sales data storage unit 106b.

[2. process]
Here, an example of the unit price retrospective processing executed by the unit price retrospective processing device 100 will be described with reference to FIG. 3 and the like.

In this description, the unit price retrospective processing device 100 is used by a distributor/wholesaler (midstream company) existing between a steel manufacturer (upstream company) and a consumer (downstream company) in steel distribution. is assumed. In addition, in this explanation, the product is a steel product (steel product), and the unit price is determined by the steel manufacturer (such as a blast furnace manufacturer), which corresponds to the supplier for the distributor/wholesaler, and the sales destination for the distributor/wholesaler. It shall be determined through regular price negotiations with corresponding consumers. Also, in this description, it is assumed that Excel (a product name of spreadsheet software developed and sold by Microsoft Corporation) is installed in the unit price retrospective processing device 100 .

First, the display executing unit 102a causes the monitor 114 to display the unit price retrospective processing screen MA shown in FIG. 2 (step S1).

The operator selects the radio button corresponding to the desired retroactive pattern (any one of the first retroactive pattern to the fourth retroactive pattern), and the supplier identification information according to the selected retroactive pattern, start Set the date, end date and product identification information, and press the execution button MA6.

If the first retroactive pattern (contract-based unit price retroactive for purchase) is selected, the operator must provide the customer identification information of the steel manufacturer to be retroactive and the product identification information of the steel product to be retroactive. , and set the start date and end date of the retroactive period based on the revision date related to the revision of the unit price of the steel product.

In addition, when the second retroactive pattern (retroactive unit price based on inventory revaluation for purchase) is selected, the operator must provide the customer identification information of the steel manufacturer to be retroactive and the product of the steel product to be retroactive. Set the identification information, and set the reference date (for example, the end of the month) for inventory revaluation.

In addition, if the third retroactive pattern (retroactive unit price on a delivery basis for sales) is selected, the operator must provide the client identification information of the consumer to be retroactive and the product identification information of the steel product to be retroactive. Set the start date and end date of the retroactive period based on the revision date related to the revision of the unit price of the relevant steel product.

In addition, when the fourth retroactive pattern (contract-based unit price retroactive for sales) is selected, the operator inputs the customer identification information of the consumer to be retroactive and the product identification information of the steel product to be retroactive. Set the start date and end date of the retroactive period based on the revision date related to the revision of the unit price of the relevant steel product.

Returning to FIG. 3, when the execution button MA6 is pressed, the output execution unit 102b executes the output of purchase data or sales data based on the selection state and setting state in the unit price retrospective processing screen MA, and the output is completed. Then, the output completion is notified by a dialog or the like (step S2).

Specifically, when the first retrospective pattern is selected, the output execution unit 102b outputs the purchase data that satisfies the following conditions 11 and 12 from the purchase data storage unit 106a in xlsx format to the storage unit Output to a predetermined storage area in 106 .
Condition 11: Includes supplier identification information set in area MA2 and product identification information set in area MA5.
Condition 12: The contract date falls within the period from the start date set in the area MA3 to the end date set in the area MA3.

Further, when the second retroactive pattern is selected, the output execution unit 102b outputs the purchase data that satisfies the following conditions 21 to 23 from the purchase data storage unit 106a in the xlsx format in the storage unit 106: Output to a predetermined storage area.
Condition 21: Includes supplier identification information set in area MA2 and product identification information set in area MA5.
Condition 22: The accounting date is before the reference date set in area MA4.
Condition 23: Inventory data that includes the product identification information set in the area MA5 in the inventory data storage unit 106c, that the receipt date is the same as the reference date set in the area MA4, and that the quantity is not zero. exists.

Further, when the third retrospective pattern is selected, the output execution unit 102b outputs the sales data that satisfies the following conditions 31 and 32 from the sales data storage unit 106b in xlsx format to a predetermined Output to storage area.
Condition 31: Includes supplier identification information set in area MA2 and product identification information set in area MA5.
Condition 32: The delivery date falls within the period from the start date set in the area MA3 to the end date set in the area MA3.

Further, when the fourth retrospective pattern is selected, the output execution unit 102b outputs the sales data that satisfies the following conditions 41 and 42 from the sales data storage unit 106b in xlsx format to a predetermined Output to storage area.
Condition 41: Includes supplier identification information set in area MA2 and product identification information set in area MA5.
Condition 42: The contract date falls within the period from the start date set in the area MA3 to the end date set in the area MA3.

Via the input device 112, the operator inputs the revised unit price for the purchase data or sales data output in xlsx format to a predetermined storage area in the storage unit 106. FIG. Also, the operator instructs to start importing purchase data or sales data in which the revised unit price is entered, for example, via a predetermined import screen (not shown).

Next, when receiving an instruction to start capturing through a predetermined capturing screen (not shown), the capturing unit 102c receives a predetermined storage area in the storage unit 106 (purchased data by the output execution unit 102b or The purchase data or sales data to which the revised unit price has been input is taken in from the sales data output destination (step S3).

Next, when the purchase data is imported in step S3, the creating unit 102d creates a formula for canceling the purchase data in which the unit price before revision is set, based on the imported purchase data. Purchasing black data in which the incoming red data and the revised unit price are set are created, and the created data are stored in the purchasing data storage unit 106a (step S4).

In addition, when the sales data is imported in step S3, the creation unit 102d, based on the imported sales data, creates red sales data and revised sales data for canceling the sales data in which the unit price before revision is set. Sales data in which the subsequent unit price is set is created, and the created data is stored in the sales data storage unit 106b (step S4).

[3. Summary of this embodiment]
As described above, according to the present embodiment, four patterns of unit prices that can be performed by distributors/wholesalers (that is, creation of transaction red/black data) can be performed efficiently and conveniently for the operator.

For example, in the case of the following (A11) to (A13) situations, the following processing (A21) to (A23) is executed in the unit price retrospective processing device 100, so that the process corresponding to the first retrospective pattern The input red/black data can be generated efficiently and conveniently for the operator (see FIG. 4).
(A11) The contract date for the contract with Steelmaker X is April 1st. As a result of price negotiations between steel manufacturer X and consumer Y, the unit price of steel material for item A was revised from 10 yen to 9 yen on July 25th. The execution date of this process is 7/25.
(A12) In the unit price retroactive process screen MA, the first retroactive pattern is selected, "Steel maker X" is set as supplier identification information, "Item A" is set as product identification information, and the contract date is set as the start date. The same "4/1" is set as the end date, and "7/25", which is the same as the revision date, is set as the end date.
(A13) In the purchase data storage unit 106a, "S001 (purchase slip number), 4/10 (purchase accounting date), steel manufacturer X (customer identification information), Item A (product identification information), 100 kg (quantity), 1,000 yen (price), 10 yen (unit price), N001 (receipt slip number), 4/1 (contract date)" purchase data is stored. there is
(A21) When the first retroactive pattern is selected, the output execution unit 102b determines that "item A" is set as product identification information and "steel manufacturer X” is set and the contract date falls within the period from the start date “4/1” to the end date “7/25” is output. Here, purchase data of "S001, 4/10, steel manufacturer X, item A, 100 kg, 1,000 yen, 10 yen, N001, 4/1" is output.
(A22) The fetching unit 102c fetches the purchase data output in A21 in which the revised new unit price of 9 yen is input. Here, purchase data of "S001, 4/10, steel manufacturer X, item A, 100 kg, 1,000 yen, 10 yen, N001, 4/1, 9 yen (new unit price)" is taken in.
(A23) Based on the purchase data captured in A22 and the execution date of this process "7/25", the creation unit 102d creates purchase red data for canceling the purchase data output in A21 and the revised purchase data. Create purchase data in which the unit price is set. Here, the purchase red data of "S002, 7/25, steel maker X, item A, 100 kg, -1,000 yen, 10 yen, N001, 4/1" and "S003, 7/25, steel maker X , Item A, 100 kg, 900 Yen, 9 Yen, N001, 4/1” are created.

Further, for example, in the case of the situations shown in (B11) to (B14) below, since the following processes (B21) to (B23) are executed in the unit price retrospective processing device 100, The purchase red/black data can be created efficiently and conveniently for the operator (see FIG. 5).
(B11) The contract date for the contract with steel maker X is 2/1. As a result of price negotiations between steel manufacturer X and consumer Y, the unit price of steel material for item A was revised from 10 yen to 9 yen on July 25th. The execution date of this process is 7/25.
(B12) In the unit price retroactive process screen MA, the second retroactive pattern is selected, "steel manufacturer X" is set as the business partner identification information, "item A" is set as the product identification information, and the inventory is revalued. "3/31" is set as the reference date.
(B13) In the purchase data storage unit 106a, "S001 (purchase slip number), 2/10 (purchase accounting date), steel manufacturer X (customer identification information), Item A (product identification information), 100 kg (quantity), 1,000 yen (price), 10 yen (unit price), N001 (receipt slip number), 2/1 (contract date)" purchase data is stored. there is
(B14) Since 100 kg of the steel materials of item A purchased initially (2/10) were not sold until the execution date "7/25" of this processing and remained as inventory, the following is stored in the inventory data storage unit 106c: Inventory data as of the end of each month from February to June is stored.
・"N001 (incoming slip number), 2/10 (incoming date), item A (product identification information), 100 kg (quantity), 1,000 yen (price), 10 yen (unit price), 2/28 (creation date )” (history data)
・"N001, 2/10, item A, 100 kg, 1,000 yen, 10 yen, 3/31" (history data)
・"N001, 2/10, item A, 100 kg, 1,000 yen, 10 yen, 4/30" (history data)
・"N001, 2/10, item A, 100 kg, 1,000 yen, 10 yen, 5/31" (history data)
・"N001, 2/10, item A, 100 kg, 1,000 yen, 10 yen, 6/30" (history and current stock data)
(B21) When the second retroactive pattern is selected, the output execution unit 102b determines that "item A" is set as product identification information and "steel manufacturer X” is set, and the recording date is before the reference date “3/31”, which is linked to the receipt slip number “N001” of the purchase data and whose creation date is the reference date “3” /31" and the quantity of which is not zero exists in the inventory data storage unit 106c. Here, since the inventory data of "N001, 2/10, item A, 100 kg, 1,000 yen, 10 yen, 3/31" exists, "S001, 2/10, steel manufacturer X, item A, 100 kg , 1,000 yen, 10 yen, N001, 2/1" are output.
(B22) The fetching unit 102c fetches the purchase data output in B21 in which the revised new unit price of 9 yen is input. Here, purchase data of "S001, 2/10, steel manufacturer X, item A, 100 kg, 1,000 yen, 10 yen, N001, 2/1, 9 yen (new unit price)" is taken in.
(B23) Based on the purchase data acquired in B22 and the execution date "7/25" of this processing, the creation unit 102d creates purchase red data and purchase red data for canceling the purchase data output in B21. Create black data. Here, the purchase red data of "S002, 7/25, steel maker X, item A, 100 kg, -1,000 yen, 10 yen, N001, 2/1" and "S003, 7/25, steel maker X , Item A, 100 kg, 900 Yen, 9 Yen, N001, 2/1” are created.

Further, for example, in the case of the following (C11) to (C13) situations, the unit price retrospective processing device 100 executes the following (C21) to (C23) processes, so that it corresponds to the third retroactive pattern. It is possible to efficiently create the sales red/black data to be used, and to make it convenient for the operator (see FIG. 6).
(C11) The contract date for the contract with customer Y is 4/1. As a result of price negotiations between steel manufacturer X and customer Y, the unit price of steel material for item A was revised from 12 yen to 11 yen on July 25. The execution date of this process is 7/25.
(C12) On the unit price retroactive process screen MA, the third retroactive pattern is selected, "consumer Y" is set as the business partner identification information, "item A" is set as the product identification information, and the contract date is set as the start date. "4/1", which is the same as the revision date, is set as the end date, and "7/25", which is the same as the revision date, is set as the end date.
(C13) In the sales data storage unit 106b, "U001 (sales slip number), 4/10 (sales recording date), customer Y (customer identification information), item A (product identification information), 100 kg (quantity), 1,200 yen (price), 12 yen (unit price), 4/11 (delivery date), 4/1 (contract date).
(C21) When the third retroactive pattern is selected, the output execution unit 102b determines that "item A" is set as product identification information and "consumer Y" is set as customer identification information from the sales data storage unit 106b. is set and the delivery date falls within the period from the start date "4/1" to the end date "7/25". Here, sales data of "U001, 4/10, consumer Y, item A, 100 kg, 1,200 yen, 12 yen, 4/11, 4/1" are output.
(C22) The capturing unit 102c captures the sales data output in C21 in which the revised new unit price of 11 yen is input. Here, the sales data of "U001, 4/10, consumer Y, item A, 100 kg, 1,200 yen, 12 yen, 4/11, 4/1, 11 yen" are captured.
(C23) Based on the sales data captured in C22 and the execution date "7/25" of this processing, the creation unit 102d creates red sales data for canceling the sales data output in C21 and the revised unit price. Create the set sales data. Here, the sales red data of "U002, 7/25, customer Y, item A, 100 kg, -1,200 yen, 12 yen, 4/11, 4/1" and "U003, 7/25, customer Y, Item A, 100 kg, 1,100 Yen, 11 Yen, 4/11, 4/1” sales profit data is created.

Further, for example, in the case of the following (D11) to (D13) situations, the unit price retrospective processing device 100 executes the following (D21) to (D23) processes, so that the fourth retroactive pattern is supported. It is possible to efficiently create the sales red/black data to be used and to provide convenience for the operator (see FIG. 7).
(D11) Same as C11.
(D12) Same as C12 except that the fourth retrospective pattern is selected on the unit price retrospective processing screen MA.
(D13) Same as C13.
(D21) When the fourth retrospective pattern is selected, the output execution unit 102b determines that "item A" is set as product identification information and "consumer Y" is set as customer identification information from the sales data storage unit 106b. is set and the contract date falls within the period from the start date "4/1" to the end date "7/25". Here, sales data of "U001, 4/10, consumer Y, item A, 100 kg, 1,200 yen, 12 yen, 4/11, 4/1" are output.
(D22) Same as C22.
(D23) Same as C23.

Moreover, the present 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).

[4. 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 unit price retrospective processing 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 unit price retrospective processing 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. In addition, 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 this 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 unit price retrospective processing device 100 via any network, and it is possible to download all or part of it 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 Blu-ray (registered trademark) Disc, etc. 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 structure, but is distributed as a plurality of 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 unit price retrospective processing 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. Further, the unit price retrospective processing device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of devices is not limited to the one shown in the figure, 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 selectively implemented.

The present invention is particularly useful in the steel industry and the like.

100 unit price retrospective processing device 102 control unit
102a display execution unit
102b output execution unit
102c intake unit
102d creation unit 104 communication interface unit 106 storage unit
106a purchase data storage unit
106b sales 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 (4)

(1) An area for selecting either one of the first retroactive and second retroactive, which means retroactive of the unit price for the purchase, the supplier's business partner identification information, the start date and end of the period If the first retrospective is selected on the screen containing the date, the reference date for inventory revaluation, and the area for setting the product identification information, the business partner identification information and product identification information set on the screen and the contract date pertaining to the contract with the supplier specified by the supplier identification information falls within the period from the start date to the end date set on the screen, (2) If the second retroactive method is selected on the screen, purchase data that includes the supplier identification information and product identification information set on the screen and whose recording date is before the reference date set on the screen. an output executing means for outputting inventory data corresponding to the purchase data, having the same receipt date as the reference date, and having a non-zero quantity;
a fetching means for fetching the purchase data output by the output execution means in which the revised unit price is input;
Based on the purchase data fetched by the fetching means, purchase red data for canceling the purchase data in which the unit price is set before revision and purchase black data in which the unit price after revision is set a creation means for creating data;
A unit price retrospective processing device comprising a control unit comprising: 2. The unit price retrospective processing device according to claim 1, wherein said product is a steel product, and said unit price is determined by a steel manufacturer corresponding to a supplier. Executed by the control unit of an information processing device comprising a control unit,
(1) An area for selecting either one of the first retroactive and second retroactive, which means retroactive of the unit price for the purchase, the supplier's business partner identification information, the start date and end of the period If the first retrospective is selected on the screen containing the date, the reference date for inventory revaluation, and the area for setting the product identification information, the business partner identification information and product identification information set on the screen and the contract date pertaining to the contract with the supplier specified by the supplier identification information falls within the period from the start date to the end date set on the screen, (2) If the second retroactive method is selected on the screen, purchase data that includes the supplier identification information and product identification information set on the screen and whose recording date is before the reference date set on the screen. an output execution step of outputting inventory data that corresponds to the purchase data, has the same receipt date as the reference date, and has inventory data that is not zero in quantity;
a fetching step of fetching the purchase data output by the output execution step in which the revised unit price is entered;
Purchasing red data for canceling the purchase data with the unit price before revision and purchase black data with the unit price after the revision based on the purchase data captured by the importing step a creation step for creating data;
Unit price retroactive processing method including. For causing the control unit of an information processing device comprising a control unit to execute
(1) An area for selecting either one of the first retroactive and second retroactive, which means retroactive of the unit price for the purchase, the supplier's business partner identification information, the start date and end of the period If the first retrospective is selected on the screen containing the date, the reference date for inventory revaluation, and the area for setting the product identification information, the business partner identification information and product identification information set on the screen and the contract date pertaining to the contract with the supplier specified by the supplier identification information falls within the period from the start date to the end date set on the screen, (2) If the second retroactive method is selected on the screen, purchase data that includes the supplier identification information and product identification information set on the screen and whose recording date is before the reference date set on the screen. an output execution step of outputting inventory data that corresponds to the purchase data, has the same receipt date as the reference date, and has inventory data that is not zero in quantity;
a fetching step of fetching the purchase data output by the output execution step in which the revised unit price is entered;
Purchasing red data for canceling the purchase data with the unit price before revision and purchase black data with the unit price after the revision based on the purchase data captured by the importing step a creation step for creating data;
Unit price retroactive processing program including.

Images