JPH07129685A - Collation system for sales credits - Google Patents

Abstract

PURPOSE:To constitute the system so that a user can obtain a desired result of collation with regard to the result of collation of sales credits. CONSTITUTION:Sales data 200 corresponding to a delivery number and acceptance data 201 of a purchaser side are displayed on a screen 204 of a display device through a computer, the sales data and the acceptance data are collected automatically with the computer, and coincident data and noncoincident data are stored in a data 206 as matching data and difference data, respectively. The difference data is divided into a quantity difference, a unit price difference and an amount difference.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an accounts receivable collation system for collating whether or not the data of the accounts receivable of a product match between the seller side and the purchaser side.

[0002]

2. Description of the Related Art As shown in FIG. 19, a conventional collation system of this kind is one 100 selected by a shipping date based on a seller's receivable ledger, and customer inspection statement data 101.
It was designed such that the difference and the difference between the two are listed on the paper, the difference investigation report 103 is created, and the invoice 104 is issued based on the difference investigation report 103. There is also a personal computer that performs the above-mentioned collation, but it is only possible to print out a list in which each data is matched or unmatched as a matching result.

[0003]

As in the former conventional example, it is inconvenient to visually check on paper, and there is a drawback that efficiency is low. Further, in the case of the conventional example of collating with the latter personal computer, it is only possible to print out a list in which each data is matched or unmatched,
Since there was no function of processing or editing the collation result, it was not possible to meet the demand for obtaining a desired collation result depending on the application.

An object of the present invention is to provide an accounts receivable collation system capable of obtaining a desired collation result by processing and holding the collation result in a plurality of forms.

[0005]

In order to achieve the above object, according to the present invention, as described in claim 1, a display device for displaying sales data corresponding to a delivery number and acceptance data on the purchaser side via a computer. The sales data and the inspection data are automatically collated by the computer, and the matching data is stored as matching data and the non-matching data is stored as difference data in the database. The difference data is divided into quantity difference, unit price difference, and amount difference.

Further, according to the present invention, as described in claim 4, the sales data corresponding to the delivery number is displayed on the display device via the computer, and the computer operates the order of the displayed sales data. A function of rearranging according to the items designated by the operation of the means, a function of making the display of the sales data designated by the operating means on the display device different from other displays, and further deleting from the screen by the operation of the operating means, It has a function of storing the sales data erased from the screen in the database as the inspection data on the purchaser side and a function of storing the data remaining without being erased from the screen as the difference data in the database.

[0007]

According to the system of claim 1, the sales data and the inspection data are both input to the computer as data. In this case, the collation is automatically performed. Then, the collation result is processed into one in which the sales data and the inspection data match and one in which they do not match, and is stored in the database as the collation history information. Further, the non-coincidences can be classified into those based on the difference in quantity, those based on the difference in unit price, and the ones based on the amount difference, so that much matching result data desired by the user can be provided.

The system of claim 4 is used when only the sales data is given to the computer and the inspection details are in the form of paper. At that time, it is easier to visually check if the order of sales data and inspection details are the same, but in this system, the displayed sales data are arranged in the same order as the inspection details by operating the operation means. Can be changed. Furthermore, by deleting the coincident ones from the screen by operating the operation means, the coincident ones and the non-matching ones can be sorted. The sorted items are stored in the database and used.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the embodiments shown in the drawings. FIG. 1 is a schematic diagram of an accounts receivable collation system embodying the present invention, in which sales data 200 on the seller side and inspection data 201 on the purchaser side are collated by a collation system 203, and collation results of various forms are stored in a database 206. Is stored as collation history information, or the data from the database 206 is taken into the collation system 203 to be reprocessed or edited. The collation system 203 is the screen 2 of the display device.
04, and if necessary, the difference status table 205 is output via the printer.

Next, FIG. 2 shows a hardware configuration of the matching system 203. In the figure, the workstation 1 performs operations such as collation. This workstation 1
The host computer 10 can input sales data, inspection data, and the like via the personal computer 7 and the modem 8. Here, the personal computer 7 serves as a data bridge between the host computer 10 and the workstation 1, and does not process or control the data. Workstation 1
The difference data of the previous month stored in the internal hard disk 13 can also be used in the collation processing of this month in the workstation 1. The magneto-optical disk 12 is used for storing a ledger.

2 to 5 are terminal devices connected via a communication line 6, and these terminal devices 2 to 5 are, as shown in FIG. 3, a terminal main body 19, a television device 20, and a mouse 22.
And a keyboard 23. Here, the terminal main body 19 does not have a collating function, and relays data from the mouse or the workstation 1 to the television device 21, drives the television device 21, and transmits command data to the workstation 1 associated with mouse operation. Send, etc.

In the system shown in FIG. 2, for example, a plurality of persons in charge in the same department in a company operate the terminals 2 to 5 individually while watching the screen of the television set and relate to the workstation 1 to the customer of each person in charge. It is suitable for checking accounts receivable and processing data. In this case, the host computer 1
Since 0 is connected by a telephone line or a dedicated communication line, it may be located at a distant place (for example, the head office). Hereinafter, the accounts receivable collation processing in this system will be described separately for automatic collation and manual collation. It is assumed that the seller side collates the accounts receivable, and the purchaser side does not participate in the collation operation.

[0013] When the inspection details of the automatic collation destination (purchaser) are stored in the form of data in the host computer 10, this can be input to the workstation 1 and automatically collated with the sales data.
Naturally, the sales data is entered. This is because it is assumed that the seller collates the system of this example. Now, a case will be described in which the workstation 1 is driven by an operation of any of the terminal devices 2 to 5 to automatically collate sales data relating to accounts receivable on the seller side and acceptance data on the other side (purchaser) side. First, in the state where the initial screen (FIG. 5) is displayed on the television device screen 21 of the terminal devices 2 to 5 shown in FIG. 3, the customer code 41 and the verification date 42
By inputting, the sales data of the seller and the inspection data of the other party are extracted at the designated customer and verification date, and the verification process is executed.

As shown in FIG. 4, the screen (image) of the television device 20 in the collation is the main screen 31 and the sub screen 32.
And consists of. Data on the seller side is displayed on the left side of the main screen 31, and data on the purchaser side is displayed on the right side (FIG. 6). Along with the execution of the above collation processing, unaccepted / unaccounted data (that is, data that could not be collated) as shown in FIG. 6 is displayed on the main screen 31. At this time, is displayed on the collation mark display portion 43 indicating the collation month. From the screen of FIG. 6, it is possible to know the unaccepted / unaccounted items, but it is also possible to send this data to the printer 11 and make a hard copy.

When the cursor is moved to the icon display portion 44 in the state of FIG. 6 and the left button 22a of the mouse 22 is clicked, the screen of FIG. 7 is displayed. This screen is a screen for the quantity difference in the matching result. This is displayed when the amounts of data on the seller side and the data on the purchaser side are different based on the difference in quantity. In FIG. 7, part (A) is a group in which there is one seller's data and two in the recipient's acceptance data, and part (B) is one seller's data and one recipient's acceptance data. It is a difference in the group. Both (A) and (B) are collation using the purchase order number as a collation key, and the collation column 45 is automatically provided with a collation mark for June.

In the screen of FIG. 7, the icon display section 44
When the cursor is moved to and the left button 22a of the mouse 22 is clicked, the screen changes to the screen of FIG. This screen is a screen when the amount of money differs depending on the unit price difference. Since the part (C) is the difference carried over from the previous month (May), “May” is displayed in the collation column 45. On the other hand, the part (D) is a new difference that occurred this month (June), and the check mark of is displayed. When the cursor is placed on the icon display portion 44 on this screen and the mouse is clicked, the screen changes to the screen of FIG.

In FIG. 9, a collation key (order NO in this case)
The data is correct, but the quantity and unit price are different. When the cursor is moved to the icon display portion 44 on this screen and the mouse is clicked, the screen changes to the screen of FIG. 10 and the screens of FIG. 10 to FIG. 6 to FIG. 9 are displayed. The data (matching data) is displayed. These matched data will not be carried forward to the next month.

On the screen of FIG. 10, the icon display section 4
Move the cursor to 4 and click the mouse 22
Return to the screen of FIG. That is, five types of screens are prepared as the screens after the collation is performed, and the icon display unit 4
Click 4 to unaccept / unaccount them (Figure 6)
→ Quantity difference (Fig. 7) → Unit price difference (Fig. 8) → Amount difference (Fig. 9) → Matching (Fig. 10) → Unaccepted / Not recorded (Fig. 6)
The screens are cyclically displayed in the order of ... The order of the data on any screen is instantly changed by clicking the “sort” icon and clicking an item (delivery note NO, amount, etc.).

FIG. 11 shows the flow of collation work. First, in S1, the sales data on the seller side for the current month is received from the host computer 10 to the workstation 1 and input. Further, in S2, the other party's acceptance data for the current month is read. After that, the collation is performed in S3. At this time, the difference data of the previous month is also fetched from S5. Collation is S4
It can be adjusted by sorting, searching, combining, copying, etc. In S5, the difference information and the matching as the matching result are stored in the database. The difference here will be used for the next month's verification. In S6, the difference list is output. The output form may be displayed on the screen 21 of the television device 20, or may be hard-copied by the printer 11.

FIG. 12 is a flow chart showing the general operation flow of the workstation 20 relating to collation. First, when this flow starts, in step # 5, it is determined whether or not the inspection data of the other side of the data on the seller side exists,
If it does not exist, the process proceeds to step # 10 to perform unaccepted / unaccounted processing and return. If the data of the other party exists, it is determined in step # 15 whether the amounts match. If they match, the matching process is performed in step # 20 and the process returns.

If they do not match, the next step # 25.
Check if the quantities match. If the quantities match, the amounts match, but the quantities do not match because the unit prices are different, and the unit price difference is processed in step # 30, and the return is returned. To do. If the quantities do not match, the process proceeds to step # 35 to determine whether the unit prices match, and if the unit prices match, there is a difference in the quantities, so the quantity difference is processed in step # 40, and the return is returned. To do. Step # 3
If the unit prices do not match in 5, the amount difference is processed in step # 45 and the process returns.

Steps # 20, # 30, # 40, #
In the process of 45, the data of the process result is stored in the memory (database). Unaccepted in Step # 10
The unaccounted data is displayed as an initial screen in the matching result on the television device screen, as described with reference to FIGS. 6 to 10. Also, steps # 20, # 30, # 4
The processing result data of 0 and # 45 can be sequentially and selectively displayed on the screen by clicking the icon display portion 44.

Manual Collation Next, the manual collation performed when the prior inspection details are not in the form of data but paper is described. When the customer code 41 and the collation date 42 are input from the terminal device 2 side to the workstation 1 on the initial screen of FIG. 5, only the seller side data is displayed as shown in FIG. Since the acceptance data of the other party has not been input, it remains blank. However, if there is a difference carryover in the collation of the last month, that is the hard disk 13 of the workstation 1.
Stored in, the difference data is called,
It is displayed on the right side of the main screen 31. In this example, since it is assumed that the difference data of the previous month (May) is not carried over, each column on the right side of the main screen 31 is left blank.

In this state, the display data of FIG. 13 is rearranged by using the sort function so as to match the data order of the prior inspection details written on the paper 50 as shown in FIG. In this way, by making the data on the seller side in FIG. 13 in the same order as the data on the other side, it becomes easy to perform visual collation.

Next, comparing the data on the screen and the data on the paper 50, if there is matching data in the seller's data, the seller's data collation field on the screen is clicked with a mask. By this click, the collation column and each column related thereto are reversed as shown in FIG. 15 (for example, the background is black and the characters are white), and when it is clicked again, it disappears from this screen.

If there is a difference between the data on the seller side and the data on the other side, the numerical value of the data on the other side is input on the data on the side of the seller and the data is collated. Then, when the icon display portion 44 on the right side of the sub screen 32 is clicked four times, the matching screen is displayed as described above. FIG. 16 shows the matching screen at this time. In the figure, on the right side of the main screen, the data in which the seller side data and the partner side data match is displayed. The difference data screen can also be displayed by clicking the icon display section 44 a required number of times. These means that the destination data is generated by the seller side data.

In the above-mentioned hand verification, the recipient's acceptance details are paper, but the recipient's acceptance details are not paper,
The hand verification in the case of being input in the form of data will be described below. In the screen of FIG. 6 described about the automatic collation, the left and right data of the main screen 31 are compared and the seller side data and the partner data are grouped (combined)
Is performed by clicking the verification column with the mouse.

In FIG. 17, the inverted portion is the grouped portion. In this inverted state, if the collation column is clicked again with the mouse, a collation mark is added and each inverted portion disappears from this screen. When the icon display portion 44 is clicked four times, the matching screen shown in FIG. 18 is displayed. In this way, the user can manually create a new combination, or cancel the collation mark on the collation data to create a new combination with other data, etc. I can go.

[0029]

As described above, according to the present invention, the collation result is processed by using a computer, and the collation result is processed into a plurality of forms and stored, so that the collation result desired by the user is obtained. The effect is that it is easy to provide.

[Brief description of drawings]

FIG. 1 is a schematic diagram of an accounts receivable matching system embodying the present invention.

FIG. 2 is a diagram showing a hardware configuration of the accounts receivable matching system.

FIG. 3 is a block diagram of a terminal device used in the accounts receivable matching system.

FIG. 4 is a diagram illustrating a screen of a television device of the terminal device.

FIG. 5 is a diagram showing an initial screen for receivables matching.

FIG. 6 is a diagram showing a screen of unaccepted / unaccounted.

FIG. 7 is a diagram showing a screen for quantity difference.

FIG. 8 is a diagram showing a unit price difference screen.

FIG. 9 is a diagram showing a screen for difference in amount.

FIG. 10 is a view showing a matching screen.

FIG. 11 is a diagram showing a flow of collation work in this system.

FIG. 12 is a diagram showing a collation operation flow of a workstation.

FIG. 13 is a diagram showing an operation when hand verification is performed using the system of the present invention.

FIG. 14 is a diagram showing an operation when hand verification is performed using the system of the present invention.

FIG. 15 is a diagram showing an operation when hand verification is performed using the system of the present invention.

FIG. 16 is a diagram showing an operation when hand verification is performed using the system of the present invention.

FIG. 17 is a diagram showing an operation in the case of performing more advanced hand verification in the system of the present invention.

FIG. 18 is a diagram showing an operation in the case of performing more advanced hand verification in the system of the present invention.

FIG. 19 is a schematic view showing a conventional collation system.

[Explanation of symbols]

 1 workstation (computer) 2 to 5 terminal equipment 10 host computer 12 magneto-optical disk 19 terminal body 20 television device 21 television screen

Claims (4)

[Claims] 1. The sales data corresponding to the delivery number and the inspection data on the purchaser side are displayed on a display device via a computer, and the computer automatically collates the sales data and the inspection data, and the matching data is matched. A data receivable matching system that stores inconsistent data as difference data in a database. 2. The accounts receivable collation system according to claim 1, wherein the difference data is classified by quantity difference, unit price difference, and amount difference. 3. The accounts receivable collation system according to claim 1, wherein the data of the collation result selected by the operation of the operation means is displayed on the display means. 4. A function of displaying sales data corresponding to a delivery number on a display device via a computer, and the computer rearranging the order of the displayed sales data according to an item designated by an operation of an operation means. A function that makes the display of the sales data specified by the operating means on the display device different from other displays and further deletes it from the screen by operating the operating means, and the sales data deleted from the screen is checked by the purchaser side. An accounts receivable collation system having a function of storing the data as a data in a database and a function of storing the data remaining without being erased from the screen as difference data in the database.