JPH1040320A - Method and device for processing credit account claim - Google Patents

Abstract

PROBLEM TO BE SOLVED: To rationally reduce the claim cost. SOLUTION: A customer table 20 has fields of a customer code, balance reference sum, limited frequency of balance, balance counter, balance inhibiting period, balance starting time, balance limited period, and balance information necessity/unnecessity flags. A claim table 30 has fields of a claim No., customer code, sum of credit account claim, claim description, claiming date, and claimed balance flags. A record to be claimed this time is extracted from the claim table 30, and a record on the customer table 20 matched with the customer code in it is read out. Then, when account claimed sum 34 is more than balance reference sum 24, or when this date is included in a balance inhibiting period 27, the value of a balance counter 26 is beyond a limited frequency 25, or a period since the balance starting period until this date is beyond the balance limited period, processing for issuing credit account bill is carried out, and the balance counter 26 and the balance starting period are initialized. Otherwise, the balance processing is conducted, the balance counter 26 is counted, and when the balance starting period is not initialized, the balance starting period is stored.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method and an apparatus for processing accounts receivable.

[0002]

2. Description of the Related Art In a conventional receivable billing process, when a billing time arrives, a bill is issued or an automatic debit process is performed from a financial institution regardless of the receivable bill amount.

[0003]

However, billing costs such as the mailing cost of bills and the automatic debiting fee at a financial institution are higher than the receivable billing amount, and vice versa. However, there was a problem that the company sometimes became deficit. This problem is no longer negligible due to thin margins due to intensified competition. On the other hand, even if your invoicing is temporarily in the red,
You may need to issue an invoice for your or your client's account.

An object of the present invention is to provide a method and an apparatus for processing accounts receivable bills, which can reduce the billing cost rationally in view of such problems.

[0005]

In the receivables claim processor according to the first aspect of the present invention, a billing table in which a bill number, a customer identification code, and a receivable billing amount are stored as fields of a record. A storage means, a carry-over reference amount storing means for storing a carry-over reference amount, and if the receivable bill amount of a record of the current bill read from the billing table is equal to or less than the carry-over reference amount, an invoice issuance is performed next time. And processing means for performing the carry-over process.

According to the first aspect of the invention, when the receivable invoice amount is equal to or less than the carry-forward reference amount, the receivable processing is performed without issuing the receivable invoice, so that the bill mailing cost, the automatic debit fee at the financial institution, etc. Is higher than the receivable billing amount, and vice versa, it is possible to prevent a loss due to the billing cost.

In the first aspect of the first invention, there is provided a carry-over exception time storage means for storing carry-over exception time, and the processing means issues a bill when the current billing time is included in the carry-over exception time. Is not carried over to the next time. This first
According to the aspect, there is an effect that it is possible to prevent troublesome customers from being settled.

In a second aspect of the first invention, there is provided a carry-over number storing means for storing a carry-over number and a carry-over limit, and the processing means counts the carry-over number each time the carry-over process is performed. If the number of times of transfer has reached the limit of number of times of transfer before performing the carry-over process, the process of carrying over the next billing is not performed, and the number of times of carry-over is initialized.

According to the second aspect, it is possible to prevent the customer from forgetting the accounts receivable. According to a third aspect of the first invention, there is provided a carry-over period storing means for storing a sale or provision date and time of an article or service corresponding to a billing process for which a carry-forward process is performed for the first time, and a carry-over limit period. When the carry-over process is performed for the first time, the carry-over start time is stored, and if the carry-over period has reached the carry-over period limit before the carry-over process is performed, the process of carrying over the billing is not performed next time, and Initialize the carry-over start time.

According to the third aspect, it is possible to prevent the customer from forgetting the accounts receivable and to prevent the statute of limitations from being overdue.
In a fourth aspect of the first invention, when performing the carry-over processing, the processing means performs a receivables bill carry-forward notice creation processing. According to the fourth aspect, although an account receivable billing carry-over notification cost is required, an automatic withdrawal fee or the like at a financial institution is not required, so that the billing cost can be reduced and the receivable can be prevented from being forgotten by a customer. Play.

[0011] In a fifth aspect of the first invention, in the case where at least one of the above-mentioned carry-over base amount, the above-mentioned carry-over exception time, the above-mentioned carry-over limit and the carry-over limit period is included and the carry-over limit or carry-over limit period is included, Has customer table storage means for storing a customer table including a record of the carry-over determination data also including the number of times of carry-over or the start time of carry-over, and a customer identification code, wherein the processing means reads out the current billing read from the billing table. The billing table is searched using the customer code included in the record for the minute as a key, and it is determined whether or not the carryover processing is to be performed based on the carryover determination data included in the searched record.

According to the fifth aspect, since the carry-over determination data is set for each customer, the difference is determined according to the difference in the mailing cost of the invoice depending on the customer location, the difference in the automatic debit fee at the financial institution, and the presence / absence of the fee. An appropriate value can be set as data, and the effect of reducing the billing cost is improved. In the receivables claim processing method according to the second invention,
A billing table including an invoice number, a customer identification code, and a receivable billing amount as record fields, and a carry-forward reference amount are stored in a storage device in advance, and a record for the current billing included in the billing table is stored. And the carry-over reference amount are read from the storage device, and if the receivable invoice amount of the read record is equal to or less than the carry-over reference amount, the invoicing is carried forward next time.

[0013]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to the drawings. FIG. 4 shows a hardware configuration of the receivable request processing device. This configuration is a general computer system, and includes a CPU 10, a ROM 11, a RAM
The I / O interface 13 and the I / O interface 13 are connected by a bus 14, and the I / O interface is connected to an external storage device 15, a manual input device 16, a display device 17, and a printer 18. It is connected by an O interface 13. The external storage device 15 stores an OS, a billing program operating under the OS, and a customer table and a billing table accessed by the billing program. These tables may be integrated with the billing program. FIG. 3 shows the customer table 2
0 and a configuration example of the billing table 30 are shown.

The customer table 20 is read out on a record-by-record basis. This record includes a customer code 21 that does not overlap with each other, a customer name 22 corresponding to the customer code 21, a customer address, a department and a name of a person in charge, and the like. Statement 23 (which generally consists of multiple fields), carry-forward threshold 24 to be compared to accounts receivable billed, carry-over limit 25 which must not be exceeded, carry-over counter 26 indicating the number of consecutive carry-overs, carry-over such as settlement period Carry-over prohibition period 2 when trouble occurs
7, carry-over start time 54, carry-over limit period 29, and carry-over notification necessity flag 28 fields. The initial value of the carry-over counter 26 is 0. The billing table 30 is read out on a record-by-record basis. The record includes a billing number 31, a delivery date 32 for a customer, a customer code 33, a receivable billing amount 34, and a billing statement 35 (which generally includes a plurality of fields). ), The fields of a billing date 36 and a bill carryover flag 37. The initial value of the bill carryover flag 37 is 0.

The customer table 20 and the billing table 30 are logically connected by a customer code 21 and a customer code 33, and have a one-to-many relationship. In FIG. 4, the OS is read from the external storage device 15 into the RAM 12 by the IPL stored in the ROM 11, and
S causes the external storage device 15 to send the billing program to the RA.
M12, and the customer table 20 and the billing table 3 are read from the external storage device 15 by the billing program.
0 is read into the RAM 12, and the processing shown in FIGS. 1 and 2 is performed.

FIG. 1 shows the processing executed by the billing program in functional blocks. Based on the delivery date 32 of the billing table 30, a record of what should be billed this time is extracted, and a record on the customer table 20 that matches the customer code 33 of the extracted record is read. For the records in both tables, the carry-forward reference amount 24 and the receivable demand amount 34 are compared (40), the carry-over limit number 25 and the carry-over counter 26 are compared (41), and the carry-over prohibition timing 27
Is compared with today's date held by the OS (42),
The carry-over start time 54 is compared with the carry-over period obtained from today's date held by the OS and the carry-over limit period 29 (5
2). Based on these comparison results, it is determined whether or not billing processing should be performed (43).

That is, if the receivable demand amount 34 is greater than the carry-forward reference amount 24, or even if the receivable demand amount 34 is less than or equal to the carry-over reference amount 24,
7 or the value of the carry-over counter 26 exceeds the carry-over limit number 25, or if the carry-over period obtained from the carry-over start time 54 and today's date has passed the carry-over limit period 29, an account receivable request is made. The issue processing of the book 45 is performed (4
4) The carry-over counter 26 is initialized (46), and the carry-over start time 54 is initialized (46). Otherwise,
Carry-over processing is performed by setting the billing carry-over flag 37 to "1" (47), the carry-over counter 26 is counted by 1 (48), and the necessity of carry-over notification is determined based on the carry-over notification necessity flag 28. (49), if it is determined that it is necessary,
That is, when the flag value is “1”, the carry-over notice 51
Is issued (50).

It should be noted that the carry-forward reference amount 24 and the receivable demand amount 34
In the comparison (40), the total value of the original receivable amount and the receivable amount in which the invoice date 36 is not entered and the billing carry flag 37 is “1” is defined as the comparative receivable amount. Used. In the process of issuing the receivable invoice 45, the total value is set as the receivable invoice amount, and all the billing details 35 relating to the total are set as print data.
The billing date of the same day is entered in all of the billing dates 36 relating to this total. In this case, since the billing carry flag 37 is held without being initialized, it is possible to know how much carry-over processing has been performed in the past and the amount of reduction in the billing cost due to the carry-over processing. Then, the values of the carry-over reference amount 24 and the carry-over limit number 25 are updated.

FIG. 2 is a flowchart showing the receivable request processing as described above. The reference numerals in each step correspond to those in FIG. Since this can be easily understood from this correspondence, the description of FIG. 2 is omitted. According to the present embodiment, when the accounts receivable billing amount 34 is less than or equal to the carry-forward reference amount 24, in principle, carry-forward processing is performed without issuing an accounts receivable bill, so that the bill mailing cost and the automatic withdrawal fee at a financial institution, etc. Can be prevented from becoming higher than the receivable billing amount, and vice versa. Further, even if the receivable demand amount 34 is less than or equal to the carry forward reference amount 24,
7 or the value of the carry-over counter 26 is 2
5 or the elapsed time from the carry-over start time 54 to the present exceeds the carry-over limit period 29, an invoice will be issued in exceptional cases, which may inconvenience or forget the customer. Can be prevented.

Further, since the carry-over reference amount 24 is set for each customer, an appropriate value is set according to the difference in bill mailing cost depending on the customer location and the difference and presence / absence of the automatic debit fee at the financial institution. And the effect of reducing the billing cost is improved. The same applies to the carry-over limit number 25, carry-over prohibition time 27 and carry-over limit period 29 set for each customer. As for the carry-over limit number 25, the customer's consent can be obtained in advance and the customer can select the set value. At this time, the customer can also select whether or not the carry-over notification is necessary. The present invention also includes various modified examples.

For example, customer code 0 in billing table 30
0001 is defined as the company's own company, and the date of today is included in the company's prohibition period 27, and the case of today's date is included in the customer's company prohibition period 27 in relation to the company's accounting period. You may make it handle similarly. In addition, in order to uniformly raise (lower) the carry-over reference amount 24 for all customers due to special circumstances, if the company's carry-over reference amount 24 is larger (smaller) than the customer's carry-over reference amount 24, the company's carry-over reference amount 24 24 may be compared with the receivable billing amount. In this case, uniform change processing of the carry-forward reference amount 24 due to special circumstances can be easily performed. Similarly, in order to uniformly increase (decrease) the carry-over limit number 25 for all customers due to special circumstances, the company's carry-over limit number 25
Is larger (smaller) than the customer's carry-over limit number 25, the company's carry-over limit number 25 may be compared with the carry-over counter 26.

It is a matter of course that, instead of using the specific customer code of the billing table 30 as the company code, a data table of the company may be created and the same processing as described above may be performed. Regarding the carry-forward reference amount 24, carry-over limit number 25, carry-over prohibition time 27, and carry-over notification necessity flag 28 in the customer table 20, instead of holding these data in the customer's mind,
It may be held as data common to all customers or a specific customer group.

The customer code 21 only needs to identify the customer, and the customer name 22 itself may be used as the customer code 21. In addition, instead of outputting the receivable invoice 45 by the printer 18 and mailing the receivable invoice 45, the receivable invoice 45 may be output in the form of a text file and notified by e-mail of personal computer communication. . The record input of the billing table 30 may be an input from a recording medium such as magnetism or light, or an input from a communication line.

[Brief description of the drawings]

FIG. 1 is a functional block diagram showing a receivable requesting process.

FIG. 2 is a flowchart showing a receivable requesting process.

FIG. 3 is a diagram illustrating a configuration example of a table used for accounts receivable request processing;

FIG. 4 is a block diagram showing a schematic configuration of hardware of the receivable request processing device.

[Explanation of symbols]

 20 Customer Table 21 Customer Code 22 Customer Name 23 Customer Details 24 Carryover Standard Value 25 Carryover Limit Number 26 Carryover Counter 27 Carryover Prohibition Timing 28 Carryover Notification Required Flag 29 Carryover Limit Period 30 Billing Table 31 Billing No. 32 Delivery Date 33 Customercode 34 Accounts receivable billing amount 35 Billing statement 36 Billing date 37 Billing carryover flag 45 Accounts receivable bill 51 Carryover notice 54 Carrying start timing

Claims (7)

[Claims] 1. A billing table storage means for storing a billing table including a customer identification code and a receivable billing amount as fields of a record; a carry-over reference amount storing means for storing a carry-over reference amount; and reading from the billing table. A receivable billing processing device for performing a process of carrying over the billing issuance next time if the receivable bill amount of the record of the current bill is equal to or less than the carry-forward reference amount. 2. The system according to claim 1, further comprising a carry-over exception time storing means for storing a carry-over exception time, wherein the processing means issues a bill when the current billing time is included in the carry-over exception time. A receivables claim processing device, which does not carry over the next time. 3. The method according to claim 1, further comprising: a carry-over number storing means for storing a carry-over number and a carry-over limit, wherein the processing means counts the carry-over number each time the carry-over process is performed. If the number of transfers has reached the limit of the number of transfers before performing the transfer process, the process of transferring the invoice to the next time is not performed, and the number of transfers is initialized. apparatus. 4. The system according to claim 1, further comprising means for storing a carry-over start time and a carry-over limit period. Before carrying out the carry-over processing, there is carry-over from the previous time or earlier, and the current billing time is set. If the rollover limit period has been reached, do not carry over the invoicing process next time.
Also, the carry-over start time is deleted. Also, when performing the carry-over process, it is determined whether or not there is carry-over from the previous time, and if there is no carry-over, that is, if this is the first carry-over, the carry-over start time is set. A receivables claim processor. 5. The receivables claim processing apparatus according to claim 1, wherein said processing means performs a receivables carry forward notice creating process when performing the carryover processing. . 6. The system includes one or more of the carry-over base amount, the non-carriage period, the carry-over limit, and the carry-over period limit. A customer table storing means for storing a customer table which includes a carry-over determination data including a carry-over start time when the limit is included and a customer identification code in a record; and wherein the processing means reads out from the billing table. Searching the billing table using the customer code included in the record for the current bill as a key, and determining whether to perform the carryover processing based on the carryover determination data included in the searched record. An accounts receivable claim processing device according to any one of claims 1 to 5, characterized in that: 7. A billing table including a customer identification code and a receivable billing amount as record fields, and a carry-forward reference amount are stored in a storage device in advance, and the current billing amount included in the billing table is stored. A receivable billing processing method, comprising: reading out a record and the carry-over reference amount from the storage device; and if the read-out receivable amount of the record is equal to or less than the carry-over reference amount, invoicing is carried forward next time.