JP2019061569A - Retroactive unit price correction device, retroactive unit price correction method, and retroactive unit price correction program - Google Patents

Abstract

The present invention provides a retroactive unit price correction apparatus capable of simply performing retroactive correction of unit prices even when monthly processed transactions and non-monthly processed transactions are mixed.
A retroactive unit price correction apparatus according to the present invention performs red / black processing on a target item to create unit price correction information when revising a unit price of a commodity for a transaction that has been processed monthly. The correction information creation means and the target statement update means for directly updating the target statement when revising the unit price of the commodity for the transaction which has not been monthly processed, are provided.
[Selected figure] Figure 1

Description

  The present invention relates to a retroactive unit price correction apparatus, a retroactive unit price correction method, and a retroactive unit price correction program.

  As a retroactive unit price correction method of goods, there exists patent document 1, for example. The retroactive unit price correction method according to Patent Document 1 is a new billing by searching for unit price information based on unit price information management processing for setting and managing information on unit prices of each item, and input contents (item, vendor). It is comprised of a unit price information search process for registering a slip. Further, in the retroactive unit price correction method, the unit price and the valid period input by the user are received, stored in the unit price information management table, and the related transaction slip is acquired based on the registered contents of the unit price information management table. The difference between the official unit prices is calculated, and additional difference slips are registered (see paragraphs 0009, 0011, 0032, 0047).

JP, 2014-119821, A

  However, in Patent Document 1 described above, nothing is described about the revision of the unit price when the transaction for which the monthly processing has been completed and the transaction for which the monthly processing has not been mixed are mixed.

  The present invention has been made in view of the above, and it is possible to easily carry out retroactive revision of the unit price even when the monthly processed transaction and the non-monthly processed transaction coexist. An object of the present invention is to provide a correction device, a retroactive unit price correction method, and a retroactive unit price correction program.

  In order to solve the problems described above and to achieve the object, the present invention is a retroactive unit price correction device provided with a control unit, wherein the control unit is configured to calculate the unit price of the commodity for the transaction processed monthly. In the case of revision, the unit price correction information creation means for performing unit price correction information by performing red / black processing on the target item, and directly for the case of revising the unit price of goods for transactions that have not been monthly processed. Target specification update means for updating the specification.

  Further, according to the present embodiment, it is preferable that the monthly processed transactions include the current month and the monthly processed transactions before the current month.

  Further, according to the present embodiment, it is preferable that the target statement update unit further creates a journal based on the unit price correction information.

  Further, according to the present embodiment, the transaction preferably includes sales and purchases, and the unit price preferably includes a sales unit price and a purchase unit price.

  Further, according to the present embodiment, the unit price correction data creation unit comprises a commodity unit price master in which unit prices are registered on a commodity number basis, and commodity unit price master maintenance means for revising the unit price of the commodity unit price master. Preferably, the unit price correction information is created according to the unit price revised by the commodity unit price master, and the target statement updating means directly updates the target statement according to the unit price revised by the commodity unit price master.

  Further, in order to solve the problems described above and achieve the object, the present invention is a retroactive unit price correction method executed by an information processing apparatus provided with a control unit, the monthly execution performed by the control unit In the case of revising the unit price for the processed transaction, the unit price correction information creation step of red / black processing the target item to create unit price correction information, and the unit price for the transaction which has not been monthly processed In the case of revising, it is characterized by including an object statement updating step of directly updating an object statement.

  Further, in order to solve the problems described above and achieve the object, the present invention is a retroactive unit price correction program to be executed by an information processing apparatus, and the unit price is revised for monthly processed transactions. If the target item is red / black processed to create unit price correction information, and if the unit price is revised for transactions that have not been monthly processed, the target item is directly updated. And a target specification updating step to be executed by the information processing apparatus.

  According to the present invention, even when monthly processed transactions and non-monthly processed transactions are mixed, retroactive revision of the unit price can be easily performed.

FIG. 1 is a block diagram showing an example of the configuration of the retroactive unit price correction apparatus. FIG. 2 is a flow chart for explaining an example of the overall processing flow of retroactive unit price correction processing executed by the control unit of the retroactive unit price correction device of FIG. 1. FIG. 3 is a diagram for explaining the revision of the unit price of the commodity unit price master of FIG. FIG. 4 is a diagram showing an example of the commodity unit price master setting screen. FIG. 5 is a view showing an example of a sales unit price revision data creation image in the cases 1 and 2. FIG. 6 is a view showing an example of a sales unit price revision data creation image in the case 3. FIG. 7 is a view showing an example of the purchase price revision data creation image in the cases 1 and 2; FIG. 8 is a view showing an example of the purchase unit price revision data creation image in case 3;

  Hereinafter, embodiments of a retroactive unit price correction apparatus, retroactive unit price correction method, and retroactive unit price correction program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
For example, in a trading company, there is a transaction form in which a product is purchased from a manufacturer and sold to a customer. For example, due to a delay in the determination of the unit price of the manufacturer, the determination of the sales unit price and the purchase unit price is delayed in the commercial company, but transactions occur. Conventionally, when correcting unit prices retroactively, if there are a large number of part numbers, for example, after manually calculating with a spreadsheet application (for example, EXEL), the result is entered grossly, or the difference in unit price revision is input. As a result, it was not possible to track the history of transactions before and after the change of unit prices. Therefore, the retroactive unit price is efficiently used for the revision of the unit price when the transaction for which monthly processing (also referred to as "monthly closing processing" or "monthly closing processing") and transaction for which processing is not monthly processing coexist is mixed. The revision process could not be performed.

  Therefore, in the present embodiment, in the case of revising the unit price for the transaction for the current month and for the target period before the current month on which monthly processing has been performed, the target item is specified as part number (also referred to as "product number"). Red-black processing is performed to create unit price correction information, and when the unit price is revised for a transaction that has not been processed monthly, the target item is directly updated. As a result, retroactive unit price revision processing can be efficiently performed with respect to the revision of the unit price when the transaction that has undergone monthly processing and the transaction that has not undergone monthly processing coexist. In addition, by creating the monthly red and black line, it became a mechanism that can be made consistent with the accounting journal. The specific configuration and operation will be described below.

[2. Constitution]
The configuration of the retroactive unit price correction apparatus 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the retroactive unit price correction apparatus 100. As shown in FIG.

  The retroactive unit price correction apparatus 100 is a commercially available desktop personal computer. The retroactive unit price correction apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a commercially available notebook personal computer, a portable digital assistant (PDA), a smartphone, a tablet personal computer, etc. It may be a type information processing apparatus.

  As shown in FIG. 1, the retroactive unit price correction apparatus 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the loan management device 100 are communicably connected via any communication path.

  The communication interface unit 104 communicably connects the retroactive unit price correction 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 communicably connecting the retroactive unit price correction apparatus 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like. Note that data stored in the storage unit 106 described later may be stored in the server 200.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that cooperates with the mouse to realize a pointing device function. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. In addition, an operation in which the user uses the input device 112 to display information on the screen of the monitor 114 or an operation input on the screen of the monitor 114 may be referred to as “a user operation via the UI”.

  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 central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  The storage unit 106 stores the commodity unit price master 106 a and the detailed data file 106 b. The commodity unit price master 106 a is for associating the commodity number of the commodity with the purchase unit price and the sales unit price for each customer and vendor. The commodity unit price master 106 a includes a group code, a group (business office), a customer (also referred to as “sold by”) code, a customer, a vendor code, a vendor, an article number, an article, a sales unit price, and a purchase unit price. It may be a table etc. which matched and registered data, such as quantity, and the application period (retroversic application start date-retroactive application end date) to apply retrospectively (refer FIG. 3).

  The item data file 106 b is for storing sales item data and purchase item data. The sales statement data may include data such as group code, group (business place), customer code, customer (sales party), sales date, product code, product, quantity, sales unit price, sales amount, etc. . Purchase specification data includes data such as group code, group (business place), vendor code, vendor, purchase date, product code, product, quantity, purchase price, purchase price, etc. It is also good.

  The control unit 106 reads and writes the sales statement data and the purchase statement data with respect to the statement data file 106 b according to the user operation via the UI. Further, the sales statement data and purchase statement data of the object stored in the statement data file 106b are read out and processed by the unit price correction information creation unit 102b and the target statement update unit 102c in the retroactive unit price correction process.

  The control unit 102 is a CPU or the like that controls the loan management apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run. The control unit 102 executes retroactive unit price correction processing, and is functionally conceptually provided with a commodity unit price master maintenance unit 102a, a unit price correction information creation unit 102b, and a target specification updating unit 102c.

  The commodity unit price master maintenance unit 102 a is for performing new registration and revision of data of the commodity unit price master 106 a according to a user operation via the UI, and for example, revision of sales unit price and purchase unit price.

  When the unit price correction information creation unit 102b revises the unit price (purchasing unit price and / or sales unit price) of the commodity for the monthly processed transaction (purchase and / or sales), Perform red / black processing to create unit price correction information. Further, the unit price correction information creation unit 102b may create unit price correction information in accordance with the unit price revised by the commodity unit price master 106a. The monthly processed transaction may include the current month and the monthly processed transactions before the current month. The unit price correction information generation unit 102b may further generate a journal entry based on the unit price correction information.

  The target item update unit 102c directly updates the target item when the unit price of the product is revised for the transaction that has not been monthly processed. Further, the target item update unit 102c may directly update the target item according to the unit price revised by the product unit price master 106a.

[3. Specific example of processing]
A specific example of the retroactive unit price correction process executed by the control unit 102 of the retroactive unit price correction apparatus 100 according to the present embodiment will be described in detail with reference to FIGS. The following specific example describes the revision of the sales unit price and the revision of the purchase unit price.

The retroactive unit price correction apparatus 100 according to the present embodiment, when the product unit price is revised, performs processing by classifying the processing into the following three cases according to the status of the monthly processing.
(1) Case 1: Monthly processed sales and purchase data generated during the current month (monthly closed, sales and purchase data generated during the current month) are subjected to red / black processing on a part number basis.
(2) Case 2: Sales and purchase data (monthly processed on the relevant month etc.) generated before this month are red / black processed on a part number basis.
(3) Case 3: Sales and purchase data for the current month not processed monthly (monthly sales and purchase data not yet closed) are directly updated to the revised unit price.

(Flow of the whole retroactive unit price correction process)
An example of the entire processing flow of retroactive unit price correction processing executed by the control unit 102 of the retroactive unit price correction apparatus 100 of FIG. 1 will be described with reference to FIG. FIG. 2 is a flowchart for explaining an example of the flow of the entire retroactive unit price correction process executed by the control unit 102 of the retroactive unit price correction apparatus 100 of FIG.

  In FIG. 2, the commodity unit price master maintenance unit 102 a revises the unit price (sales unit price / purchase unit price) of the target product number of the commodity unit price master 106 a according to the user operation via the UI (step S1). The unit price correction information creation unit 102b processes the item data (sales statement data and purchase statement data) generated monthly for the monthly processing (“Yes” in step S2) and / or the red and black processing for the statement data before the current month To create unit price correction information (step S3). The target statement update unit 102c directly updates the statement data that has not been monthly-processed ("No" in step S2) with the revised unit price (step S4). In addition, in order to determine whether monthly processing has been completed, status information indicating whether monthly processing has been performed may be added to the detailed data, for example. As a result, the unit price correction information unit 102b and the target item update unit 102c can determine whether monthly processing has been completed with reference to the status information of the detailed data.

(Setting of unit price master)
FIG. 3 is a diagram showing an example before and after revision of data of the commodity unit price master 106a. The commodity unit price master maintenance unit 102a revises the data of the commodity unit price master 106a according to the user operation through the UI when the unit price is revised by the customer or the vendor. As shown in FIG. 3A, for example, before the revision, the commodity unit price master 106 a includes the group “business office A”, the customer code “T1000000-1”, the supplier code “S1000000-1”, the commodity For the number “10001”, a sales unit price “¥ 100”, a purchase unit price “¥ 80”, and an application period “2016/04/01 to 2016/06/30” are registered. Further, for the product number “10002”, the sales unit price “¥ 150”, the purchase unit price “¥ 100”, and the application period “2016/06/01 to 20/06/30” are registered.

  After the revision, as shown in Fig. 3 (B), for the product number "10001", the sales unit price is applied from "¥ 100" to "¥ 105", and the purchase unit price is applied from "¥ 80" to "¥ 82". The period has been changed from “2016/06/01 to 20/06/30” to “2016/07/01 to 2016/12/31”. Also, for the product number “10002”, the sales unit price is “¥ 150” to “¥ 160”, the purchase unit price is “¥ 100” to “¥ 90”, and the application period is “2016/06 / 01-2016 / It has been changed from “06/30” to “2016/07/01 to 2016/12/31”.

  The unit price correction information creation unit 102b and the target statement update unit 102c perform retroactive unit price revision processing using the sales unit price and the purchase unit price of the commodity unit price master 106a after the revision.

  The commodity unit price master maintenance unit 102a may display a commodity unit price master setting screen in response to a user operation via the UI. The user may newly register data in the commodity unit price master 106 a on the commodity unit price master setting screen, or may revise the registered data. For example, when at least one of a group, a customer code, a vendor code, a product number, etc. is input as a search condition on the product unit price master setting screen, the corresponding data is read out from the product unit price master 106a. It may be displayed and the user may revise the sales unit price and the purchase unit price on this screen. FIG. 4 is a diagram showing an example of the commodity unit price master setting screen. In the example shown in FIG. 4, the sales unit price and the purchase unit price as shown in FIG. 3 are changed according to the user operation.

(Example of sales unit price revision)
The revision of the sales unit price will be described with reference to FIGS. 5 and 6. FIG. 5 is a view showing an example of a sales unit price revision data creation image in the cases 1 and 2. The revision of the sales unit price in the cases 1 and 2 will be described with reference to FIG. The unit price correction information creation unit 102b reads out the sales statement data to be processed monthly from the specification data file 106b, and performs red / black processing.

  In FIG. 5, the retroactive accounting date is July 1, 2016, the target period is April 1 to 2016, June 30, 2016, and the retroactive unit price revision process is performed after the monthly process in June. Do. In the example shown in FIG. 5, the sales unit price of the product number “10001” was changed to “¥ 105” from 2016/7/1, and the sales unit price of the product number “10002” was changed to “¥ 160” from 2016/7/1. The case will be described (see FIG. 3).

  In FIG. 5 (A), for the period from April 1, 2016 to June 30, 2016, the products of the establishment "A" and the sales partners "対 応 commercial corresponded to the customer code" T1000000-1 "" " For the numbers “10001” and “10002”, examples of sales date, quantity, unit price, and sales amount are shown.

  If it totals for every goods number, it will become as shown in FIG. 5 (B). In FIG. 3B, for the product number “10001” of the establishment “A” and the sales destination “o Shoji”, the quantity is “66,000” and the sales amount is “¥ 6,804,000”. For the product number “10002”, the quantity is “15,000” and the sales amount is “¥ 2,264,000”.

  As shown in FIG. 5C, red and black processing is performed on the counting result of FIG. 5B. Instead of directly correcting the tabulation results in FIG. 5B, two new values are added: a negative amount (red) for writing back the original amount and a positive amount (black) corrected retrospectively. This allows a record of the correction to be kept.

  Specifically, in red processing, for the product number “10001”, the sales date is “July 1, 2016”, the quantity is “-66,000”, and the sales amount is ¥ 6,804,000. For the number “10002”, the sales date “July 1, 2016”, the quantity “−15,000”, and the sales amount “¥ -2,264,000”.

  In black processing, for the product number “10001”, the sales date “July 1, 2016”, the quantity “66,000”, the unit price “¥ 105”, and the sales amount “¥ 6,930,000” For the number “10002”, the sales date is “July 1, 2016”, the quantity is “15,000”, the sales unit price is “¥ 160”, and the sales amount is “¥ 2,400,000”. Journals may be created from red-black processed items.

  FIG. 6 is a view showing an example of a sales unit price revision data creation image in the case 3. With reference to FIG. 6, the revision of the sales unit price in case 3 will be described. The target statement updating unit 102c reads out target sales statement data from the statement data file 106b and directly updates the sales statement data of the target when the sales unit price of the product is revised with respect to the transaction that has not been processed monthly.

  In FIG. 6, the retroactive accounting date is July 31, 2016, the target period is from July 1, 2016 to July 31, 2016, and the retroactive unit price revision processing is performed after the monthly processing in July. Do. In FIG. 6, when the sales unit price of the product number "10001" is changed to "¥ 105" from 2016/7/31, and the sales unit price for the part number "10002" is changed to "¥ 160" from 2016/7/31. It will be described (see FIG. 3).

  FIG. 6A shows an example of sales statement data for the period from July 1st, 2016 to July 31st, 2016. The product numbers of the office "A" and the sales destination "〇" are shown. The sales date, the unit price of sales, the quantity, and the sales amount are shown for 10001 and 10002, respectively.

  In FIG. 6A, for the product number “10001”, the sales date “July 10, 2016” is the quantity “10,000”, the sales unit price “100”, and the sales amount “¥ 1,000,000”. The sales date “July 26, 2016” is the quantity “12,000”, the unit price “104”, and the sales amount “¥ 1,248,000”. As for the product number "10002," the sales date "July 15, 2016" is the volume "5,000", the unit price "150", and the sales amount "750,000".

  As shown in FIG. 6 (B), the unit price is directly updated (corrected) with respect to the data shown in FIG. 6 (A). In FIG. 6B, the unit price is corrected to “¥ 105” for the product number “10001”. Specifically, the sales date "July 10, 2016" is corrected to the sales unit price "¥ 105" and the sales amount "¥ 1,050,000", and the sales day "July 26, 2016" is Correct the sales unit price to ¥ 105 and the sales amount to ¥ 1,260,000. Also, for the product number "10002", the unit price is corrected to "¥ 160." Specifically, the sales date “July 15, 2016” is corrected to a sales unit price “160” and a sales amount “¥ 80,000”.

[Example of purchase price revision]
The revision of the purchase price will be described with reference to FIGS. 7 and 8. FIG. 7 is a view showing an example of the purchase price revision data creation image in the cases 1 and 2; The revision of the purchase unit price in the cases 1 and 2 will be described with reference to FIG. The unit price correction information creation unit 102b reads out purchase specification data to be processed monthly from the specification data file 106b, and performs red / black processing.

  In FIG. 7, the retroactive accounting date is July 1, 2016, and the target period is April 1, 2016 to June 30, 2016, and retroactive unit price correction processing is performed after the monthly processing in June. When the purchase unit price of the product number "10001" is corrected to "¥ 82" from 1 July 2016 and the purchase unit price of the product number "10002" is changed to "¥ 90" from 1 July 2016 Will be described (see FIG. 3).

  In FIG. 7A, for the period from April 1, 2016 to June 30, 2016, the establishment "A" and the supplier "□ commercial (corresponding to the supplier code" S1000000-1 ")" For the item numbers “10001” and “10002” of the item, an example of the purchase date, the purchase unit price, the quantity, and the purchase price is shown.

  If it totals for every goods number, it will become as shown in FIG. 7 (B). In FIG. 7 (B), for the product number “10001” of the establishment “A” and the supplier “□”, the quantity is “66,000” and the purchase price is “¥ 5,144,000”. For the product number “10002”, the quantity is “15,000” and the purchase price is “¥ 1,506,000”.

  As shown in FIG. 7 (C), red-black processing is performed on the counting result of FIG. 7 (B). Instead of directly correcting the tabulation results in FIG. 7B, two new values are added: a negative amount (red) for writing back the original amount and a positive amount (black) corrected retrospectively. This allows a record of the correction to be kept. Specifically, in red processing, with regard to the product number “10001”, the purchase date “July 1, 2016”, the quantity “-66,000”, and the purchase price “¥ -5,144,000”. For the product number "10002," the stock date "July 1, 2016", the quantity "-15,000", and the purchase price "¥ -1, 506,000".

  In black processing, for product number “10001”, the purchase date “July 1, 2016”, quantity “66,000”, purchase price “¥ 82”, purchase price “¥ 6,930,000” As for the product number “10002”, the purchase date “July 1, 2016”, the quantity “15,000”, the purchase unit price “¥ 90”, and the purchase price “¥ 2,400,000” .

  FIG. 8 is a view showing an example of the purchase unit price revision data creation image in case 3; The revision of the purchase price in case 3 will be described with reference to FIG. In the case of revising the purchase price of a product for a transaction that has not been monthly processed, the target item update unit 102c reads out target purchase item data from the item data file 106b and directly updates the target item update data.

  In FIG. 8, the retroactive accounting day is July 31, 2016, the target period is from July 1, 2016 to July 31, 2016, and retroactive unit price correction processing is performed after the monthly processing in July. When the purchase unit price of the product number "10001" is changed to "¥ 82" from 2016/7/1, and the purchase unit price of the product number "10002" is changed to "¥ 90" from 2016/7/1 It will be described (see FIG. 3).

  FIG. 8A shows the product numbers “10001” and “10002” of the establishment “A” and the supplier “〇” for the period from July 1st, 2016 to July 31st, 2016. It shows an example of the entry date, purchase price, quantity, and purchase price.

  In FIG. 8A, for the product number “10001”, the purchase date “July 10, 2016” is the quantity “10,000”, the purchase price “¥ 80”, the purchase price “¥ 800, The purchase date “July 26, 2016” is the quantity “12,000”, the purchase price “¥ 77”, and the purchase price “¥ 924,000”. For the product number "10002," the purchase date "July 15, 2016" is the volume "5,000", the purchase price "¥ 100", and the purchase price "¥ 500,000".

As shown in FIG. 8 (B), the unit price is directly updated (corrected) as shown in FIG. 8 (B). In FIG. 8B, the purchase unit price is corrected to “¥ 82” for the product number “10001”. Specifically, the purchase date “July 10, 2016” is corrected to the purchase price “¥ 82” and the purchase amount “¥ 820,000”, and the purchase date “July 26, 2016” Is corrected to purchase price “¥ 82” and purchase price “¥ 984,000”. Also, for the product number “10002”, the purchase price is corrected to “¥ 90”. Specifically, the purchase date “July 15, 2016” is corrected to the purchase price “¥ 90” and the purchase price “¥ 450,000”.

  As described above, according to the present embodiment, in the case of revising the unit price of the commodity for the monthly processed transaction, the unit price for performing the red / black processing on the target item and creating the unit price correction information Since the correction information creation unit 102b and the target item updating unit 102c that directly updates the target item when revising the unit price of the product for the monthly processed transaction, the monthly processing is completed. Even in the case where the transaction portion and the transaction portion before the monthly processing coexist, retroactive revision of the unit price can be easily performed.

  Also, according to the present embodiment, since the monthly processed transactions include the current month and the transactions before the current month, the transactions for the current month and the previous month are collectively processed into red and black It is possible to

  Further, according to the present embodiment, the unit price correction information creation unit is provided with a commodity unit price master 106a that registers a unit price per commodity number, and a commodity unit price master maintenance unit 102a that revises the unit price of the commodity unit price master 106a. Since 102b creates unit price correction information according to the unit price revised by the unit price master 106a, the target item update unit 102c directly updates the target statement according to the unit price revised by the unit price master 106a. By revising the unit price of the product unit price master 106a, retroactive unit price correction can be easily performed.

[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

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

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, with regard to the retroactive unit price correction apparatus 100, each component in the drawing is functionally conceptual, and does not necessarily have to be physically configured as illustrated.

  For example, all or some of the processing functions of the retroactive unit price correction apparatus 100, in particular each processing function performed by the control unit 102, are realized by a CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded in a non-temporary computer-readable recording medium that includes a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and the loan management apparatus as needed. Mechanically read to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, this computer program may be stored in the application program server connected to the retroactive unit price correction apparatus 100 via any network, and it is also possible to download all or part of it as needed. It is.

  Further, the program for executing the processing described in the present embodiment may be stored in a non-temporary computer readable recording medium, or may be configured as a program product. Here, the "recording medium" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (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. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like, a known configuration and procedure can be used.

  The various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, storage means such as optical disks, etc. Stores programs, tables, databases, files for web pages, etc.

  Further, the retroactive unit price correction apparatus 100 may be configured as an information processing apparatus such as a known personal computer or a workstation, or may be configured as the information processing apparatus to which any peripheral device is connected. In addition, the retroactive unit price correction apparatus 100 may be realized by mounting software (including a program or data, etc.) that causes the apparatus to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is particularly useful in the fields of advertising production, consultants, manufacturing or wholesale, etc., which is a field where business is often outsourced to other companies having consolidated relationships.

100 retroactive unit price correction device
102 control unit
102a Commodity unit price master maintenance department
102b Unit Price Correction Information Creation Department
102c Target item update part
104 Communication interface
106 storage unit
106a Item Unit Price Master
106b Detail data file
108 Input / output interface section
112 input device
114 output device 200 server 300 network

Claims (7)

A retroactive unit price correction apparatus comprising a control unit,
The control unit
When the unit price of the product is revised for the monthly processed transaction, a unit price correction information creation unit that performs unit process correction information by performing red / black processing on the target item;
In the case of revising the unit price of a product for a transaction that has not been monthly processed, a target statement update means that updates the target statement directly;
A retroactive unit price correction device characterized by comprising.   The retroactive unit price correction apparatus according to claim 1, wherein the monthly processed transaction includes a current month and a monthly processed transaction before the current month. The retroactive unit price correction apparatus according to claim 1 or 2, wherein the target statement updating unit further creates a journal entry based on the unit price correction information.   The retroactive unit price correction apparatus according to claim 1, wherein the transaction includes sales and purchases, and the unit price includes a unit price of sales and a unit price of purchase. Product Unit Price Master, in which unit prices are registered in product item units,
Item price master maintenance means for revising the unit price of the item price master;
Equipped with
The unit price correction information creation unit creates the unit price correction information according to the unit price revised by the commodity unit price master,
The retroactive unit price correction apparatus according to any one of claims 1 to 4, wherein the target item update means directly updates the target item in accordance with the unit price revised by the commodity unit price master. A retroactive unit price correction method executed by an information processing apparatus having a control unit, comprising:
Executed by the controller
In the case of revising a unit price for a transaction that has been monthly processed, a unit price correction information creation step of performing unit processing on the target item to create unit price correction information;
In the case of revising the unit price for a transaction that has not been monthly processed, the target statement update step of updating the target statement directly;
A retroactive unit price correction method characterized by including. A retroactive unit price correction program to be executed by an information processing apparatus, comprising:
In the case of revising a unit price for a transaction that has been monthly processed, a unit price correction information creation step of performing unit processing on the target item to create unit price correction information;
In the case of revising a unit price for a transaction that has not been monthly processed, a target item update step of directly updating a target item;
Retroactive unit price correction program for causing an information processing apparatus to execute

Images