JP7316342B2 - Receivables Retroactive Correction Processing Device, Receivables Retroactive Correction Processing Method, and Receivables Retroactive Correction Processing Program - Google Patents

Description

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus for retroactively correcting claims, a method of retroactively correcting claims, and a program for retroactively correcting claims.

In Patent Document 1, even after the monthly closing process of receivables, it is possible to perform payment operations for the closed month during the period when the accounting classification is not yet closed, and it is possible to update the receivable-related balance in the closed period according to the transaction. . In addition, if the beginning of the next month is not the end of the accounting period, the processing from the previous month can be carried over and distributed to the next month, which makes it possible to reduce the load of end-of-month payment operations. In addition, receivables reconciliation processing is used to reduce the possibility of discrepancies between receivables system data and actual transaction status, as it is possible to correct misoperations in deposit operations that are discovered after receivables monthly closing processing.

JP 2016-151943 A

However, in Patent Document 1, when the billing details for the previous month are corrected after the monthly closing process, it is not possible to eliminate the complexity of the billing work while grasping the monthly accounting performance without delaying the monthly settlement. rice field. In particular, when making corrections after monthly close processing, there was a risk that the history of the corrections would become unclear in terms of accounting because receivables are written off.

The present invention has been made in view of the above, and even if the claim amount and payment amount are fixed after the accounting closing process and the claim is updated, it is possible to correct the claim amount and payment amount before the closing process. To provide a credit retroactive correction processing device, a credit retroactive correction processing method, and a credit retroactive correction processing program capable of eliminating the complexity of correction work while grasping monthly accounting results without delaying settlement work. aim.

In order to solve the above-mentioned problems and achieve the object, a credit retroactive correction processing apparatus according to the present invention includes a storage unit and a control unit, and after accounting closing processing , at least order data, sales data, order placement data, A credit retroactive correction processing device that retroactively corrects accounting data that is data or purchase data when there is an update, wherein the storage unit includes an accounting data storage unit that stores the accounting data , and the control unit comprises accounting data acquisition means for acquiring the accounting data relating to the transaction and storing it in the accounting data storage unit; accounting year and month determination means for determining the precedence and succession of accounting years and months in the accounting data; update type judging means for judging whether or not the accounting data has been updated to result in a difference; red slip processing for canceling the original amount for the difference in the updated accounting data ; and red/black processing means for correcting the amount by performing black slip processing for recording the amount.

Further, the credit retroactive correction processing apparatus according to the present invention is characterized in that the update of the accounting data is an update of an accounting amount for which sales are recorded and invoiced for the received order.

In addition, in the claim retroactive correction processing device according to the present invention, when the accounting amount is updated after accounting closing processing and the amount is corrected, the original "billing reference date" and the accounting It is characterized in that the accounting data is managed by using "sales year and month" indicating the year and month.

Further, in the credit retroactive correction processing apparatus according to the present invention, when the red/black processing means manages sales data as the accounting data, if there is new sales for the order number, it is combined with the new sales number to create a history. If the classification is set to "latest" and the red slip process is performed, the history classification is set to "red history", and if the black slip process is performed, the history classification is set to "history black" and the order number and sales number are linked and managed. characterized by

Further, in the credit retroactive correction processing apparatus according to the present invention, the control unit creates an invoice by aggregating the sales data whose billing reference date is the same year and month and whose history classification is the "latest". do.

Further, in the credit retroactive correction processing apparatus according to the present invention, when the red/black processing means manages sales data as the accounting data, if there is new sales for the order number, the new sales number is combined for processing. If the classification is set to "new" and the sales amount is canceled before the accounting closing process, the processing classification is set to "delete". "before correction", and when the sales amount after correction is recorded for the canceled order number, the processing classification is set to "after correction after closing", and the difference in the sales amount is used as the correction amount for red and black processing. .

In addition, the method for retroactively correcting claims according to the present invention comprises a storage unit and a control unit, and at least accounting data such as order reception data, sales data, ordering data, or purchase data can be updated after accounting closing processing. A credit retroactive correction processing method executed by a credit retroactive correction processing device that retroactively corrects claims, wherein the storage unit includes an accounting data storage unit that stores the accounting data , and is executed by the control unit an accounting data acquisition step of acquiring the accounting data relating to the transaction and storing the accounting data in the accounting data storage unit; an accounting year and month determining step of determining the precedence of the accounting year and month in the accounting data; an update type determination step of determining whether or not the accounting data has been updated to result in a difference; a red slip process of canceling the original amount for the difference in the updated accounting data ; and a red/black processing step of correcting the amount of money by performing a black slip processing of recording the amount of money.

Further, the program for retroactively correcting claims according to the present invention comprises a storage unit and a control unit, and updates at least accounting data, which is received order data, sales data, order data, or purchase data, after accounting closing processing. A credit retroactive correction processing program to be executed by a credit retroactive correction processing device that retroactively corrects claims, wherein the storage unit includes an accounting data storage unit that stores the accounting data , and is executed by the control unit an accounting data acquisition step of acquiring the accounting data related to the transaction and storing it in the accounting data storage unit; an accounting year and month determining step of determining the precedence and succession of accounting years and months in the accounting data; an update type determination step of determining whether or not the accounting data has been updated after the processing and a difference has occurred; red slip processing of canceling the original amount for the difference in the updated accounting data ; and post-update and a red/black processing step of correcting the amount of money by performing a black slip processing of recording a new amount of money.

According to the present invention, even if the billed amount or payment amount is determined and the claim is renewed after accounting closing processing, it is possible to correct the billing amount or payment amount before closing processing, without delaying settlement work. This has the effect of eliminating the complexity of correction work while capturing the monthly accounting results.

FIG. 1 is a block diagram showing an example of the configuration of an apparatus for retroactive correction of claims and obligations according to this embodiment. FIG. 2 is a flow chart showing an example of the processing flow of the device for retroactive correction of claims and obligations according to this embodiment. FIG. 3 is a diagram showing an example of data handling and update control for realizing retroactive correction processing of credits and debts. FIG. 4 is a diagram showing an example of data transition when retroactive correction processing is performed using sample data. FIG. 5 is a diagram showing an example of a bill issued in the case of FIG. FIG. 6 is a diagram showing an example of sales data billed in September of FIG. FIG. 7 is a diagram showing an example of the accounts receivable management table for September 2016. As shown in FIG. FIG. 8 is a diagram showing an example of a sales record table for September 2016. As shown in FIG. FIG. 9 is a diagram showing an example of sales data for September 2016. As shown in FIG. FIG. 10 is a diagram showing an example of the accounts receivable management table for October 2016. As shown in FIG. FIG. 11 is a diagram showing an example of a sales record table for October 2016. As shown in FIG. FIG. 12 is a diagram showing an example of sales data for October 2016. As shown in FIG. FIG. 13 is a diagram showing an example of additional notation in the processing divisions of the sales history data in FIG. FIG. 14 is a diagram showing an example of the relationship between the sales history data of FIG. 4 and the sales record table of FIG.

An embodiment of the present invention will be described in detail based on the drawings. In addition, this invention is not limited by this embodiment.

[1. overview]
In the conventional transportation and service industries, when the timing of billing settlement with the billing destination was later than the timing of the monthly settlement of accounts within the company, the monthly settlement was prioritized. It was necessary to manually manage the documents using spreadsheet software (eg, Excel (registered trademark)).

Therefore, in the receivables and payables retroactive correction processing device according to the present embodiment, by separately considering the recognition of the date standard from the viewpoint of monthly settlement of accounts within the company and the viewpoint of fixing the billing amount with the billing party, Even after the monthly closing process, it is possible to correct the billing details of the previous month. In other words, the credits and debts retroactive correction processing device of the present embodiment has a mechanism for automatically generating red and black slips in the next month with the sales amount of the accounting difference when the details of the monthly settlement and the details of the billing amount are different. It is constructed. As a result, it has become possible to eliminate the complexity of billing operations while grasping the monthly accounting results without delaying the monthly accounting.

[2. composition]
An example of the configuration of the credit retroactive correction processing apparatus 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 an apparatus for retroactive correction of claims and obligations according to this embodiment.

The receivables and payables retroactive correction processing device 100 is a commercially available desktop personal computer. Note that the credits and debts retroactive correction processing device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smart phone, a tablet personal computer, or the like. may be a portable information processing apparatus.

The credit retroactive correction 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 credit retroactive correction processing apparatus 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 communicably connects the credit retrospective correction 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 device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

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. Here, the storage unit 106 includes an accounting data storage unit 106a and the like.

The accounting data storage unit 106a stores accounting data relating to transactions. Accounting data includes information on accounting dates and accounting amounts. Sales data for recording sales and issuing invoices when shipments are made for order entries, or receipts for order entries. There is purchase data for recording purchases and creating withdrawal slips.

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 cooperates with the mouse to provide a pointing device function. 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 control unit 102 is a CPU or the like that controls the credit retroactive correction processing device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS, a program defining various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute. Here, the control unit 102 functionally conceptually includes an accounting data acquisition unit 102a as accounting data acquisition means, an accounting year/month determination unit 102b as accounting year/month determination means, and an update type determination unit 102c as update type determination means. , and a red/black processing unit 102d as a red/black processing means.

The accounting data acquisition unit 102a acquires accounting data on transactions and stores the acquired accounting data in the accounting data storage unit 106a. For example, a series of transaction actions such as shipping for an order entry, recording sales and issuing an invoice, or recording a purchase and creating a payment slip when receiving an order is received. is generated, the accounting data is sequentially acquired and stored in the accounting data storage unit 106a.

The fiscal year/month determination unit 102b determines the antecedent relationship of the fiscal year/month in the accounting data. The accounting dates include, for example, order data, sales data, ordering data, purchase data, accounting dates of an accounting system, etc., and their precedence and succession are determined. For example, in relation to the timing of monthly settlement, recording sales for the current fiscal year and month, negative sales due to revision of existing sales data within the current fiscal year and month, sales due to revision of existing sales data before the previous fiscal year, Alternatively, it determines whether to cancel the sales recorded in the previous accounting year and month.

The update type determination unit 102c determines whether or not there is a difference in the accounting amount due to the update of the credits and liabilities after the accounting closing process. In other words, if receivables and payables are recorded before the accounting closing process and the receivables and payables data is updated within the current accounting year and month, the same amount of negative receivables and payables data should be recorded, but after the accounting closing process If the credits and debts before the previous fiscal year are updated and there is a difference, it is necessary to make corrections using red and black slips. For this reason, in the present embodiment, based on the chronological relationship of the accounting data determined by the accounting year/month determining unit 102b, the update type determining unit 102c updates the credits and liabilities after the accounting closing process, and the accounting amount is calculated. It is determined whether or not there is a difference in

The red/black processing unit 102d corrects the amount by performing red slip processing for canceling the original amount for the updated difference between the credits and debts and black slip processing for recording the new amount after the update. In other words, if there is an update of credits and liabilities after the accounting closing process, first process the red slip to cancel the original amount, and then process the black slip to record the new amount after the update. , since the revision history remains, it is possible to verify the revision process even if the credits and debts are updated after the closing process.

[3. Concrete example]
As for a specific example of this embodiment, an example of the processing of the device 100 for retroactive correction of claims and obligations according to this embodiment will be specifically described with reference to FIGS. 2 to 14. FIG. FIG. 2 is a flow chart showing an example of the processing flow of the device for retroactive correction of claims and obligations according to this embodiment. FIG. 3 is a diagram showing an example of data handling and update control for realizing retroactive correction processing of credits and debts. FIG. 4 is a diagram showing an example of data transition when retroactive correction processing is performed using sample data. FIG. 5 is a diagram showing an example of a bill issued in the case of FIG. FIG. 6 is a diagram showing an example of sales data billed in September of FIG. FIG. 7 is a diagram showing an example of the accounts receivable management table for September 2016. As shown in FIG. FIG. 8 is a diagram showing an example of a sales record table for September 2016. As shown in FIG. FIG. 9 is a diagram showing an example of sales data for September 2016. As shown in FIG. FIG. 10 is a diagram showing an example of the accounts receivable management table for October 2016. As shown in FIG. FIG. 11 is a diagram showing an example of a sales record table for October 2016. As shown in FIG. FIG. 12 is a diagram showing an example of sales data for October 2016. As shown in FIG. FIG. 13 is a diagram showing an example of additional notation in the processing divisions of the sales history data in FIG. FIG. 14 is a diagram showing an example of the relationship between the sales history data of FIG. 4 and the sales record table of FIG.

[Process flow]
The accounting data acquisition unit 102a of the device 100 for retroactive correction of claims and obligations according to the present embodiment, for example, when receiving an order entry, performs shipment, records sales, issues an invoice, and enters an order to receive goods. Accounting data is generated based on a series of transactions in which purchases are accounted for and payment slips are created, and is acquired and stored in the accounting data storage unit 106a (step S1).

Subsequently, the accounting year/month determination unit 102b determines the chronological relationship of the accounting data stored in the accounting data storage unit 106a, and records the recorded sales data and purchase data within the current accounting year/month. It is determined whether correction or cancellation is to be performed, or correction or cancellation is to be performed as the data of the previous accounting year and month after closing processing (step S2).

Then, the update type determination unit 102c, if the credits and debts are recorded before the accounting closing processing, and the credits and debts are updated after the closing processing of the current accounting year and month, and there is a difference in the accounting amount (Yes in step S3), red and black processing is performed in the next stage. Further, if there is no update of credits and payables after accounting closing processing, or if there is no difference in the accounting amount even if updated (No in step S3), red-black processing is not performed.

When the update type determination unit 102c determines that the credits and debts have been updated after the closing process and that there is a difference in the accounting amount, the red/black processing unit 102d replaces the updated credits and debts with the original amount. Red slip processing for cancellation is performed, followed by black slip processing for recording the new amount after the update (step S4). In this way, even if credits and payables before the previous fiscal year are updated after the accounting closing process, the red and black processing is automatically performed, so the revision history remains and it is possible to verify the revision process. becomes.

[Data Handling and Update Control for Retroactive Correction Processing of Claims and Debts]
In the past, when the timing of finalizing the billing amount with the billing recipient was later than the timing of the monthly settlement of accounts within the company, the monthly settlement was given priority. managed by work. On the other hand, in this embodiment, by considering the recognition of the date standard separately from the viewpoint of internal settlement of accounts and the viewpoint of determining the billing amount with the billing party, even after the monthly closing process, the previous month's It is possible to correct the billing content of Specifically, we have built a mechanism to automatically generate red-and-black slips in the following month for the difference in sales amounts that arise in accounting. As a result, it is possible to eliminate the complexity of the billing work while grasping the monthly accounting results without delaying the monthly accounting. Although such a mechanism can be applied to any industry or business, in this embodiment, a company that operates truck transportation will be described as an example.

In the example of FIG. 3, when a freight forwarding company receives an order from a shipper, after shipping by vehicle and recording sales, a series of transaction actions such as issuing an invoice is performed. Whether to revise the sales data within the same fiscal year or to revise the sales data before the previous fiscal year after the closing process is determined by judging the precedence of the fiscal year and month.

The processing categories shown in FIG. 3 are divided into “when recording sales” for recording sales and “when deleting sales” for deleting sales. For the "category name" of ~ 3, "0: Incomplete", which means that sales have not been recorded yet only for orders received, "1: Completed", that sales have been recorded, and "2: Recorded change", which changes the recorded contents. , and “3: Deletion of recorded content” to delete recorded contents. The "processing" in each category includes "black" for recording sales and "red" for canceling the recording of sales. "Fiscal year/month determination" compares the fiscal year/month of the order data and sales data with the system fiscal year/month that performs the closing process, and determines whether the revision is within the current fiscal year/month or before the previous fiscal year/month. do. The “update type” determines what kind of update process is to be performed based on the “fiscal year/month determination”. If "Update type" is "black", it means the sales recorded in the current fiscal year. In the case of "", it is the sales due to the correction of the existing sales data before the previous fiscal year, and in the case of "History red", it is the cancellation of the sales recorded in the previous fiscal year. "Update target" includes "sales data", "sales history", "vehicle sales", "vehicle history", "collection schedule", "balance T (total)", "order data", "transportation data", etc. , and "add", "update", and "delete" are performed for each update target.

[Example of data transition by operation sample]
The credits and obligations retroactive correction processing device 100 according to the present embodiment performs data processing as shown in FIG. 4 based on operation samples based on the following stories (a) to (f). The timing chart of stories (a) to (f) is executed in the order of (a), (b), and (c) within the frame of 2016/9 in the upper right of FIG. are executed in the order of (d), (e), and (f). Note that story (d) indicates the timing of the monthly update in September.

(a) 2016/09/25
Closing on the 31st, (2016/09/25 ¥ 100,000 Order No.: J5001) was recorded as sales by the shipper.
(b) 2016/09/27
Order No: J5001 was corrected to (¥120,000) and recorded as sales.
(c) 2016/09/28
(2016/09/28 ¥150,000 Order No.: J5201) was recorded as sales by the same shipper.
(d) 2016/10/05
(2016/September) "Monthly closing process" is executed. *Deadline here for credit management.
(e) 2016/10/07
2016/09/25 Corrected sales to (¥80,000). → Correction after monthly closing (f) 2016/10/10
Create an invoice for the above shipper.

First, the sales data as of 9/25/2016 is shown in the upper left part of FIG. "¥100,000", accounting date is "2016/9", order No. is "J5001", history classification is "latest", billing reference date is "2016/09/25", sales date is "2016/ 9”. The sales year and month are just the year and month for business account management.

As shown on the right side of the upper part of FIG. 000", scheduled collection date is "2016/11/10", billing reference date is "2016/09/25", and collection is "not yet". The state of "uncollected" is a state of accounts receivable whose sales have been recorded but have not yet been received.

Next, the sales data on the left side of the middle part of FIG. 100,000” within the same month, it is replaced with the latest sales number “2201”, and its history category is “history black”. However, at the stage of story (b), sales are newly recorded, so the history classification should be "latest". However, for sales numbers "2301" and "2302" in story (e), which will be described later, the sales amount "¥120,000" for sales number "2201" is reduced to "¥80,000" for sales number "2302" after the monthly closing. ”, it is necessary to cancel the sales number “2201” to correspond to the “history red” of the history classification of the sales number “2301”. It becomes "history black". Therefore, as shown on the left side of the middle part of FIG. On the other hand, since the fiscal year and month after the monthly closing process is "2016/10", the retroactive correction process is performed by the red-black process. At that time, the red/black processing unit 102d automatically creates "Δ¥40,000", which is the difference data of the sales number "2301". In this way, if the sales amount is corrected after the monthly closing process, the sales date will be replaced with the 1st day of the next month (here, "2016/10/1"), so the billing process will not be possible. , Invoicing is managed using the “billing reference date”. However, the date of sales on the order data is replaced with the original "2016/10/1" when the sales recording process is performed.

In addition, regarding the story (c) of the sales data on the left side of the middle part of FIG. 28”, the sales number becomes “2253”, and the history classification becomes “latest”.

The collection schedule data on the right side of FIG. 4 is the same as the sales data on the left side of FIG. 4 in terms of story, sales No., sales amount, and billing reference date, and the sales date is the recording date. Here, the scheduled collection date for this sales data is all 2016/11/10, and the details that have been collected as "Completed" have been collected by the red and black processing, and the "collection" is " Items marked as "unpaid" (sales numbers "2253" and "2302") are subject to payment reconciliation.

As shown in the lower part of FIG. 4, the sales history data, which records the transition of the above sales data, is as shown in the sales No. "1001" of story (b) even when the sales amount is revised within the same accounting year and month. , the previous sales amount is canceled and "Δ¥100,000" is recorded, and the corrected sales amount of "¥120,000" is recorded as shown in the sales No. "2201" of story (b). In this sales history data, an item called "processing classification" is added, and "10: new" indicates that sales are newly recorded, and sales that were recorded within the same fiscal year and month are deleted. "30: Delete", and if the sales amount recorded before the previous accounting year and month is canceled after the closing process, "24: Before correction", and the sales amount recorded before the previous accounting year is corrected after the closing process The case is distinguished as "25: after correction".

[Create invoice]
As explained in the transition example of the operation sample data in FIG. After doing so, it becomes possible to retroactively adjust the sales in the previous accounting year and month. For this reason, there is no need to delay the timing of the monthly settlement of accounts in line with the timing of the settlement of the billing amount with the billing party. Since the sales amount is automatically generated as a red and black slip in the next month, it is possible to eliminate the complexity of billing work.

A bill issued by the accounting process of the operational sample in FIG. 4 is as shown in FIG. The original data of this invoice is the sales data for the September invoice shown in FIG. This time, the sales amount is corrected after the monthly closing process in September, but the target data is controlled based on the billing reference date, and the sales amount after the monthly closing process is also taken into account. can be invoiced. In the correction after this monthly closing process, there is a correction history in the same billing period, but only the latest data is used to create the bill. In other words, the changed data (history black, history red) after the monthly closing process is subject to the temporary closing process, but is excluded from printing.

[Example of record for credit management]
The final bill will be as shown in FIG. 5, and examples of accounts receivable management forms such as the accounts receivable management table and the sales performance table are shown below. First, the accounts receivable management table for September 2016, as shown in FIG. 7, shows the status of accounts receivables that have been recorded as sales in September of the fiscal year and month and have not yet been deposited. In other words, among the sales data shown in FIG. The sales No. "2253" in c) is "¥150,000", which is the target sales data for the current month shown in FIG. Therefore, the total sales amount for September 2016 is "¥270,000", which matches the sales record table for September 2016 shown in FIG. Therefore, as shown in Fig. 7, the accounts receivable management table for September 2016 shows that the total sales amount for the current month is "¥270,000" and the consumption tax (8%) "¥21,600" is added. Therefore, the current month balance of accounts receivable is “¥291,600”. In this manner, the accounts receivable management table shown in FIG. 7 and the actual sales table shown in FIG. 8 are controlled based on the accounting year and month rather than the billing reference date, so they are synchronized with the accounting.

On the other hand, the accounts receivable management table for October 2016, as shown in FIG. 10, shows the situation of accounts receivables that have been recorded in October of the fiscal year and months but have not yet been received. In other words, among the sales data shown in FIG. 12. This is the target current month sales data in FIG. Therefore, the total sales amount for October 2016 is "Δ¥40,000", which matches the actual sales table for October 2016 shown in FIG. Therefore, the accounts receivable management table for October 2016, as shown in FIG. By adding the consumption tax (8%) of "△¥3,200", the current month balance of sales receivable becomes "¥248,400". In this way, the accounts receivable management table shown in FIG. 10 and the actual sales table shown in FIG. 11 are controlled based on the accounting year and month rather than the billing reference date, so they are synchronized with the accounting.

[Sales history data processing category]
In the processing classification of sales history data shown in Fig. 4, when the sales amount recorded before the previous accounting year and month is canceled after the closing process, it is set as "24: Before revision", and the sales amount recorded before the previous accounting year is The case of correction after the closing process is distinguished as "25: After correction". However, with this description alone, it is unclear whether or not the data will be corrected after the monthly closing process. It is possible to change or add to For example, change "24: before revision" to "24: after revision (before revision)", and "25: after revision" to "25: after revision (after revision)". A processing category of "32: Correction after closing (deletion)" may be added for the case where correction is made only by deleting the accounted amount after the closing process.

[Sales history data and sales performance table]
Further, as shown in FIG. 14, the red/black processing unit 102d, when calculating the correction amount of the previous month in the sales record table, uses the processing classifications "24: before correction" and "25: after correction" of the sales history data. Alternatively, it can be calculated automatically by using the data of "24: post-tightening correction (before correction)" and "25: post-tightening correction (after correction)" changed in FIG.

As described above, the credits and debts retroactive correction processing device 100 according to the present embodiment can be used even when the billing amount is finalized with the billing party after the closing process of the month in which the sales are recorded, and the sales amount is updated. By automatically generating the difference between the sales amount before processing and the sales amount before processing in the next month as a red and black slip, it is possible to correct the billing details retroactively before the closing process, so the monthly accounting results can be captured without delaying the settlement work. At the same time, the complexity of correction work can be eliminated.

In the above embodiment, an example of updating the amount of receivables for which sales are recorded and billed for orders has been described, but the present invention is not necessarily limited to this, and the amount of obligations for which purchases are recorded and paid for orders is not necessarily limited to this. Even in the case of updating , the liability amount can be retroactively revised by using similar logic.

Further, in the above-described embodiment, an example of a transportation industry in which a freight forwarding company receives an order for a freight forwarding contract from a shipper, instructs shipment, records sales, and issues an invoice has been described, but the present invention is limited to this. It is possible to apply the present invention to all industries and types of business such as the service industry.

[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 credit/debt retroactive correction processing device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, all or any part of the processing functions provided in the retroactive correction processing device 100, particularly each processing function performed by the control unit 102, is executed by the CPU and a program interpreted and executed by the CPU. It may be implemented as hardware by 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 mechanically read by the correction processing 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 the control section 102 in cooperation with the CPU.

In addition, this computer program may be stored in an application program server connected to the credit retroactive correction processing device 100 via any network, and may be downloaded in whole or in part as necessary. is also possible.

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 and the like stored in the storage unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks. programs, tables, databases, and files for web pages.

Further, the credit retroactive correction 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 credit retroactive correction processing device 100 may be realized by installing software (including programs, data, etc.) for realizing the processing described in the present embodiment in the information processing device.

Furthermore, the specific form of distribution and integration of the device is not limited to the one shown in the figure, and all or part of it can be functionally or physically arranged in arbitrary units according to various additions or functional additions. It can be distributed and integrated. In other words, the embodiments described above may be arbitrarily combined and implemented, or the embodiments may be implemented selectively.

INDUSTRIAL APPLICABILITY The present invention is applicable to all types of business and industries, but is particularly useful in general distribution and service industries in which billing amounts and payment amounts are updated after accounting closing.

100 Credits and Debts Retrospective Correction Processing Device 102 Control Unit 102a Accounting Data Acquisition Unit 102b Fiscal Date Determination Unit 102c Update Type Determination Unit 102d Red/Black Processing Unit 104 Communication Interface Unit 106 Storage Unit 106a Accounting Data Storage Unit 108 Input/Output Interface Unit 112 Input Device (keyboard, mouse)
114 output device (monitor)
200 Server 300 Network

Claims (8)

A receivables retroactive correction processing device comprising a storage unit and a control unit, and retroactively correcting accounting data, which is at least order receiving data, sales data, ordering data or purchase data, after accounting closing processing. There is
The storage unit
an accounting data storage unit that stores the accounting data ;
The control unit
accounting data acquisition means for acquiring the accounting data related to transactions and storing the accounting data in the accounting data storage unit;
Accounting year/month determination means for determining the precedence/consecutive relationship of the accounting year/month in the accounting data;
update type determination means for determining whether or not the accounting data has been updated after accounting closing processing and a difference has occurred;
Red-black processing means for correcting the amount by performing red slip processing for canceling the original amount for the difference in the updated accounting data and black slip processing for recording the updated new amount;
having
A credit retroactive correction processing device characterized by: Updating the accounting data includes :
It is an update of the accounting amount that records sales and invoices for the order,
2. The credit retroactive correction processing apparatus according to claim 1, characterized by: The red-black processing means is
When the accounting amount is updated after the accounting closing process and the amount is corrected, the accounting data is managed using the original "billing base date" and the "sales month and year" indicating the accounting year and month. matter,
3. The credit retroactive correction processing apparatus according to claim 1 or 2, characterized by: The red-black processing means is
When managing sales data as accounting data, if there is new sales for an order number, it is combined with the new sales number and the history classification is set to "latest". red", and when the black slip processing is performed, the history classification is set to "history black" and the order number and the sales number are linked and managed;
The claim retroactive correction processing apparatus according to any one of claims 1 to 3, characterized by: The control unit
Creating an invoice that aggregates the sales data whose billing reference date is the same month and year and whose history classification is the "latest";
5. The credit retroactive correction processing apparatus according to claim 4, characterized by: The red-black processing means is
When managing sales data as the accounting data, if there is new sales for the order number, the new sales number is combined with the new sales number, the processing classification is set to "new", and the sales amount is canceled before the accounting closing process. Then, the processing classification is set to "delete", and if the sales amount before closing processing is canceled after accounting closing processing, the processing classification is set to "before correction after closing", and the sales amount after correction is set for the canceled order number. When recording, the processing classification is set to "after correction after closing", and the difference in the sales amount is the corrected amount for red and black processing,
The claim retroactive correction processing apparatus according to any one of claims 1 to 5, characterized by: A receivables retroactive correction processing device comprising a storage unit and a control unit, and retroactively correcting accounting data, which is at least order receiving data, sales data, ordering data or purchase data, after accounting closing processing. A receivables retroactive adjustment processing method to be executed,
The storage unit
an accounting data storage unit that stores the accounting data ;
executed by the control unit;
an accounting data acquisition step of acquiring the accounting data related to the transaction and storing it in the accounting data storage unit;
a fiscal year/month determining step for determining the precedence/consecutive relationship of fiscal years/months in the accounting data;
an update type determination step for determining whether or not the accounting data has been updated after accounting closing processing and a difference has occurred;
a red-black processing step of correcting the amount by performing red slip processing for canceling the original amount for the difference in the updated accounting data and black slip processing for posting the updated new amount;
including
A credit retroactive correction processing method characterized by: A receivables retroactive correction processing device comprising a storage unit and a control unit, and retroactively correcting accounting data, which is at least order receiving data, sales data, ordering data or purchase data, after accounting closing processing. A receivables retroactive adjustment processing program for execution,
The storage unit
an accounting data storage unit that stores the accounting data ;
for execution by the control unit,
an accounting data acquisition step of acquiring the accounting data related to the transaction and storing it in the accounting data storage unit;
a fiscal year/month determining step for determining the precedence/consecutive relationship of fiscal years/months in the accounting data;
an update type determination step for determining whether or not the accounting data has been updated after accounting closing processing and a difference has occurred;
a red-black processing step of correcting the amount by performing red slip processing for canceling the original amount for the difference in the updated accounting data and black slip processing for posting the updated new amount;
including
A receivables retroactive correction processing program characterized by

Images