JPH0628373A - Slip balance controller - Google Patents

Abstract

PURPOSE:To provide a method to simultaneously process the slips of the present month and the delayed slips of the precedent month when various types of balance control including the stock control, the credit control, the debt control, etc., are processed by a computer in a corporation. CONSTITUTION:A control file 6 storing the date/calendar information is provided together with a balance file 7 stroring the balance control information, and a detailed file 8 storing the details of 2 months or more. Also the balance calculation processing 100 to update the balance records of the present and precedent months based on the input data, a data updating processing 200 which updates the date record of the file 6, a monthly carry-over processing 300 which carry over the balance records of the precedent and present months to the next month at the end of each month, and a ledger output processing 400 which outputs the ledger of the precedent month, are provided.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a slip balance management apparatus for managing balances such as inventory management, accounts receivable management, accounts payable management, etc. using a computer in a company.

[0002]

2. Description of the Related Art Various balance managements such as inventory management, accounts receivable management, accounts payable management, etc. have been managed as an indispensable and indispensable thing in a production activity of a company by a handwritten ledger, but a computer is relatively inexpensive. After it became available, it was always subject to computer processing, and many processing systems were actually constructed.

However, it is difficult for a conventional computer to secure a necessary and sufficient storage capacity in terms of price and performance, and therefore, it is designed how to effectively utilize a small storage capacity when constructing a processing system. It was also one of the points, and sometimes the function had to be reduced.

In the conventional balance management method designed in such a background, it is best to have the balance management information for one month in the current month (balance carried forward in the previous month, amount received in the month, amount paid out in the month, balance in the month, etc.). Even when a delayed slip occurs, the first method is to correct the occurrence date of the delayed slip to the current month and process it, or as the second method,
Even if the month changes, you can leave it as the previous month on the processing system for several days even if the month changes, and carry out the monthly carry-forward processing at some point by human judgment. Came.

[0005]

In the prior art, since the computer has only the balance information for the current month, it is necessary to manually change the operation of the processing system in order to incorporate the late slip into the actual result of the previous month. is there. In addition, even if the operation of the processing system is changed, it is not possible to completely capture the delay slip, so the delay slip that occurred after performing the monthly carry-forward processing must be captured as the actual result for the current month, and the accuracy of the balance information is There was a drawback that it would be lacking.

[0006]

SUMMARY OF THE INVENTION According to the present invention, in a slip balance management apparatus using a computer, a date record storing the current day / previous day and the next day of the processing date and the current month / previous month and the next month of the processing year, and one record. A control file that holds a calendar record that stores the operating schedule of the processing system for each day for one month, and the balance carried over to the previous month for the preceding month based on the processing date and the day, the received amount for the month, and the payment for the month A balance file that stores a balance record that keeps the balance of high, the balance of the month and the balance of the month, the balance of the month, the received amount of the month, the amount of payment of the month, and the balance of the month in one management unit, and the source file that updates the balance file. It has a detail file that holds the contents of data as a detail record for at least two months. If the previous month is found by matching the slip date of the data with the date record held in the control file when updating the file, the balance for the previous month based on the previous month's carry-forward balance of the balance record After performing the calculation, the current month's balance is transferred to the previous month's balance carried forward to calculate the balance for the current month, and if applicable, the current month's balance in the balance record is used as the basis for the current month. The balance calculation means for calculating the balance of minutes and the processing date / the day of the date record held in the control file on a daily basis are transferred to the processing date / the previous day and the processing date / the next day are transferred to the processing date / the current day. On the processing date / next day, the next scheduled operating date is searched from the calendar record, and the date of the scheduled date is transferred, and the processing date / previous day and the processing date / current day differ. In this case, the processing year and the current month are transferred to the processing year and the previous month, and the processing year and the next month are transferred to the processing year and the current month, and the processing year and the next month are set to the processing year and the next month. Then, for all the balance records in the balance file at the end of the month, all the items for the current month are transferred to all the items for the previous month, and the balance carried forward to the previous month for the current month and the current month. After transferring the current month's balance to the balance, after zeroing the current month's received amount and current month's paid amount for the current month, all records in the detailed file can be compared with the date record held in the control file. , A monthly carry-forward means for canceling data whose slip date is older than the processing year / previous month from the detailed file and carrying forward the month,
Processing the date record held in the control file Matches the detail record in the detail file having the slip date corresponding to the year and the previous month with the balance information for the previous month in the balance file, and outputs the ledger for the previous month. It is characterized by comprising a ledger output means.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an embodiment of the balance management apparatus of the present invention will be described with reference to the drawings.

FIG. 1 is a processing block diagram showing an embodiment of the balance management apparatus of the present invention, and FIG. 2 is a flow chart for explaining the operation in the embodiment shown in FIG.

The product inventory management apparatus shown in FIG. 1 has a keyboard 1 as an input means and a printer 2 as an output means.
And a control device 3 having means described later, and a main storage device 4
And an auxiliary storage device 5.

The keyboard 1 is a so-called keyboard / display device connected to a display device, which is a device for inputting a primitive slip relating to the entry and exit of products.
The original slip is input according to each item of the slip displayed on the display device, and is connected to the control device 3.

The printer 2 is a device for outputting an inventory ledger, is generally a kanji printer device, and is connected to the control device 3.

The main storage device 4 is a device for holding the contents of the original data input from the keyboard 1 and the contents of various files read from the auxiliary storage device 5, and the control device 3
It is connected to the.

The auxiliary storage device 5 is generally a magnetic disk device, and stores a control file 6, a balance file 7, and a detailed file 8 which will be described later, and is connected to the control device 3.

The control file 6 stores date information and operation schedule information of the processing system, and as shown in FIG. 3, the processing date (previous day / present day / next day) and processing year (previous month) of the processing system. / Current month / next month) data,
Monthly processing system operation schedule information, "working days", "holidays", "calendar days that do not exist" in the location corresponding to that date
The data of the calendar represented by the category is stored.

The balance file 7 stores the monthly stock status of each product. As shown in FIG. 4, the product code, the balance carried over from the previous month as the information for the previous month, the amount of goods received in the current month,
Stores the data for the current month's return amount, current month's output amount, current month's sales amount, current month's balance, current month's balance carried forward as information for the current month, current month's receipt amount, current month's returned amount, current month's issue amount, current month's sales, current month balance .

The detail file 8 stores the contents of various primitive slips for warehousing / delivery / sales / returns when the balance file is updated by inputting from the keyboard 1 as detail data, and as shown in FIG. It stores the data of slip number, slip date, data classification (representing four types of classification of "goods receipt", "delivery", "sales", and "return"), quantity, unit price, amount, summary, input date.

Next, the operation of the present invention will be described with reference to FIGS. (1) Balance calculation 100 The control device 3 reads a date record from the control file 6 and inputs it into the main storage device 4 before the operator inputs the original slip (step 101).

The operator inputs the original slip from the keyboard 1, and the contents are input data as the main storage device 4.
Held in. At this time, the control device 3 makes a correct / wrong judgment from the physical and logical aspects such as the number of digits of the input data and the range of the data, and if the input data is invalid as a result, it notifies the operator by an error message or the like. Prompt for re-entry. Further, the control device 3 reads the balance record of the “product code” which is the same as the “product code” of the input data from the balance file 7 and holds it in the main storage device 4. At this time, if there is no balance record for the "product code" in the balance file 7, zero is set for each item of the balance information, and a new balance record for the "product code" is newly created and held (step 102). ).

The operator at the keyboard 1 at 102
When the input end is instructed from, the control device 3 ends the process.

The control unit 3 compares the slip date of the input data held in the main storage unit 4 with the processing year / current month and the previous month of the date record, and when the input data is generated in this month, the main storage unit 3 The quantity and amount of input data are added to the current month's balance of the balance record held in 4 respectively, and the data classification is further determined, and the current month's receipt amount for this month, return amount for this month, issue amount for this month, this month After adding the quantity and amount of input data to any of the sales, the balance file 7 is updated. If the record does not exist in the balance file 7, it is newly written.

When the input data is generated in the previous month, the quantity and amount of the input data are added to the current month's balance of the balance record held in the main storage device 4, and the data classification is determined. , The current month's receipt amount for the current month
Add the quantity and amount of the input data to any of the current month's return amount, current month's output amount, or current month's sales, and then transfer the previous month's balance to the previous month's balance carried forward to the current month's balance. Add the quantity and amount of input data respectively, and further determine the data classification, and add the quantity and amount of input data to any of the current month's receipt amount, this month's returned amount, this month's issued amount, and this month's sales amount. After that, the balance file 7 is updated. If the record does not exist in the balance file 7, it is newly written (step 104).

The control device 3 edits the input data held in the main storage device 4 into a detail record and edits the detail file 8
Is additionally output (step 105). (2) Date update 200 The control device 3 reads the date record from the control file 6 and holds it in the main storage device 4, and then
Transfers the current day to the processing day / previous day, the processing day / the next day to the processing day / the same day, and calculates the processing day / the next day to the processing day / the next working day of the day from the working schedule information in the calendar record of the control file 6. Transfer. Further processing date
If the date of the previous day is different from the processing date / date of the current day, the processing year / current month is treated as the month-changed processing.
The processing year and the next month are transferred to the processing year and the current month in the previous month, and the processing year and the next month of the current year are calculated and transferred to the processing year and the next month, and then the date record of the control file 6 is updated (step 201). (3) Monthly carry-forward 300 Prior to the monthly carry-over processing, the control device 3 reads the date record from the control file 6 and loads it into the main storage device 4 (step 301).

The control device 3 judges that the month change is made only when the processing date / previous day is different from the processing date / date of the date record held in the main storage device 4, and steps 303 and 304 are executed. The operation of. If the month is not changed, the process ends (step 302).

The control device 3 updates the balance file 7 by performing the following three operations for all the balance records of the balance file 7 (step 303). The balance record is read from the balance file 7 and held in the main storage device 4. -Transfer all items for the current month to all items for the previous month of the balance record held in the main storage device 4. Furthermore, the balance of the previous month, which was previously transferred, is transferred to the balance of the previous month and the balance of the current month, and zero is set for the current month's receipt amount, this month's return amount, this month's issue amount, and this month's sales amount. -The balance record on the main storage device 4 for which the monthly carry-forward processing has been performed is restored to the balance file 7.

The control device 3 deletes, from the detail file 8, the detail records having the slip date earlier than the processing year / previous month of the date record held in the main storage device 4 among the detail records of the detail file 8. Yes (Step 30)
4). (4) Ledger output 400 The control device 3 reads a date record from the control file 6 and takes it into the main storage device 4 prior to creating the inventory ledger. Further, from the detail records of the detail file 8, data having a slip date of the same year / month / month as the processing date / month of the date record taken in the main storage device 4 is extracted, and the balance file 7 and the product code are compared. While performing, the inventory ledger for the previous month is output to the printer 2 (step 401).

[0026]

The voucher balance management device of the present invention is
The balance information for the two months of the previous month is held, and data that occurred this month and so-called delayed slips that occurred during the previous month but were not processed during the previous month can be processed at the same time without entrusting the operation of the processing system to humans. There is an effect.

Further, since the data of the late slip can be taken in as the result of the previous month, there is an effect that the accurate balance management information can always be held.

Furthermore, during the current month, the ledger for the previous month can be output any number of times at any time, so there is an effect that it is possible to have a grace period of one month before the balance of the previous month is fixed. .

[Brief description of drawings]

FIG. 1 is a configuration diagram showing an embodiment of the present invention.

FIG. 2 is a flowchart of an embodiment of the present invention.

FIG. 3 is a diagram showing an example of a control file of the present invention.

FIG. 4 is a diagram showing an example of a balance file of the present invention.

FIG. 5 is a diagram showing an example of a detail file of the present invention.

[Explanation of symbols]

 1 Keyboard 2 Printer 3 Control Device 4 Main Storage Device 5 Auxiliary Storage Device 6 Control File 7 Balance File 8 Detail File 100 Balance Calculation Processing 200 Date Update Processing 300 Monthly Carryover Processing 400 Ledger Output Processing

Claims (1)

[Claims] 1. A voucher balance management device using a computer, which stores a day record, a previous day and a next day of a processing day and a current month, a previous month and a next month of a processing year, and one day for one month in one record. Control file that holds the calendar record that stores the operating schedule of the processing system, and the balance carried forward from the previous month for the previous month, the amount received in the month, the amount paid out in the month, the balance in the month, and the month for the month based on the processing date and the day. The balance file storing a balance record that holds the balance carried forward, the amount received in the current month, the amount paid out in the month, the amount paid out in the month, and the balance in the month in one record for each management unit, and the content of the original data that updates the balance file as a detail record. It has a detailed file that is held for two months, and when updating the balance file with data based on the original slip, the data If the previous month corresponds to the previous month by comparing the slip date of the data with the date record held in the control file, the previous month's balance is calculated after performing the balance calculation for the previous month based on the previous month's balance carried forward of the balance record. Balance of the current month is transferred to the previous month's balance carried forward to calculate the balance for the current month, and if applicable to the current month, the balance for the current month is calculated based on the previous month's balance carried forward in the balance record. The calculation means and the processing date / current day of the date record held in the control file on a daily basis are transferred to the processing date / previous day, and the processing date / next day is processed /
Moved to the current day, processing date / the next day, the next scheduled operation date is searched from the calendar record, and the date of the scheduled date is transferred, and the processing date / previous day is different from the processing date / current day. If this is the case, the processing year / current month is transferred to the processing year / previous month and the processing year / next month is transferred to the processing year / current month, and the processing year / month is the year following the processing year / current month. Set the date update means for updating the processing system and at the end of the month, for all the balance records of the balance file, transfer all items for the current month to all items for the previous month, and carry forward the balance for the previous month for the current month. After transferring the current month's balance to the current month's balance, after setting the current month's received amount and current month's withdrawal amount to zero, all the records in the detailed file are date records held in the control file. In this case, the monthly carry-over means that cancels the data whose slip date is older than the processing year / month and is carried out from the above-mentioned detail file and carries forward the month, and the processing year / month of the date record held in the control file The balance management of the slip, which comprises a ledger output means for collating a detail record on the detail file having a corresponding slip date with the balance information for the previous month of the balance file and outputting a ledger for the previous month. apparatus.