JPH06131374A - Buying/selling control system - Google Patents

Abstract

PURPOSE:To provide a buying/selling control system which automatically fetches various information supplied for the buying/selling control of commodities and can produce even the information needed for the account processing. CONSTITUTION:When the information that sorting the slips to be processed is supplied, the information on the counting items are converted into the sorting data and stored in a sorting data file 16 by referring to a counting item master file 13. Then a counting processing system carries out the counting processing based on the sorting data stored in the file 16. A client master file 11 is connected to the counting processing system and previously stores the information on the opposite party of transaction. Then a commodity master file 12 which previously stores the information on the commodities to be treated is added together with an input device 1 which inputs the sales slips of the commodities related to the opposite party of transaction, and a processor which converts the input sales slips into the sales data by referring to both files 11 and 12 and then converting the sales data into the sorting data by referring to the file 13 to store these data in the file 16 of the counting processing system.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a trading management system, and more specifically, a trading management system connected to an accounting processing system and automatically fetching and processing information on trading of goods into the accounting processing system. Regarding

[0002]

2. Description of the Related Art With the progress of microelectronics in recent years, accounting systems, which were conventionally used only by large-scale businesses, are now widely used by relatively small-scale businesses and private shops. It has become. Such an accounting processing system usually performs subsequent processing by inputting slips describing individual transactions and cash in and out to a computer constituting the system, for example, a journal entry diary, cash accounting book in a unit of one month, Not only accounts receivable, accounts payable, etc., but also general account ledgers, etc. are automatically created, and balance sheets, income statements, etc. are automatically created at the time of settlement of accounts.

By the way, as described above, in the conventional accounting system, the accounting process, which has conventionally required a huge amount of manual calculation using at least an electronic desk calculator, can be performed even by inputting a slip that is generated every day. For example, it is processed almost automatically. However, since a large number of vouchers relating to the sale and purchase of merchandise are generated in a store or a sales company that sells goods, the input process is very troublesome.

On the other hand, a trade management system for managing a business partner has been put into practical use for a business operator who mainly sells and sells products as described above. This is a system that processes and manages purchase slips from business partners or sales slips to customers. By setting payment methods, due dates, etc. for each business partner in advance, for example, on a monthly basis, etc. Invoices are created or sales details, deposit and withdrawal details, etc. are created within the prescribed period.

[0005]

Therefore, although various information input and created by the trading management system as described above is naturally processed by the accounting processing system, both of them have conventionally been treated as separate systems. It is operated. Therefore, it is necessary to input and process the same information in both systems, which increases the amount of input work.

The present invention has been made in view of the above circumstances, and various kinds of information input and created by a commodity trading management system are automatically fetched and processed by an accounting processing system. The purpose is to provide a trading management system that can be centrally processed with an accounting processing system.

[0007]

In the trading management system of the present invention, when the information in which the slip to be processed is entered is entered, the entry management is performed by referring to the account item master file in which the information related to the account item is stored in advance. It is converted to data and stored in a journal data file, and is connected to an accounting system that performs accounting processing according to the journal data stored in this journal data file. A master data file that stores the information, a product master file that stores information about the products handled in advance, a trading data file that stores information about the trading of the products handled as trading data, and the sales of the products targeted at the trading partner. Input device for inputting slips or purchase slips, and input master slips for sales slips or purchase slips And transaction data by referring to the product and product master file, accumulate in the transaction data file, and convert the obtained transaction data into journal data by referring to the account master file of the accounting system And a processing device for accumulating in the journal data file of the system.

[0008]

In the trading management system of the present invention, when the sales slip or the purchase slip of the product targeted for the trading partner is input, the input sales slip or the purchase slip is the supplier master file and the product master file. Is converted into transaction data and stored in a transaction data file, and the obtained transaction data is converted into journal data by referring to the account master file of the accounting system and converted into a journal data file of the accounting system. It is accumulated and journal data is automatically created.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below in detail with reference to the drawings showing the embodiments thereof.

FIG. 1 is a block diagram showing a device configuration of a trading management system according to the present invention. In FIG. 1, reference numeral 1 indicates an input device such as a keyboard,
It is connected to a processing device using a microcomputer or the like. Reference numerals 3 and 4 indicate a display device such as a CRT display and an output device such as a printer, respectively.

As the input device 1, the processing device 2, the display device 3 and the output device 4 described above, it is possible to use a system which is commercially available as an ordinary general microcomputer system. Reference numerals 11 to 16 represent a customer master file (MF), a product master file, an account item master file, an auxiliary item master file, a sales data file (DF), and a journal data file, respectively. Each of these files 11 to 16 can be constructed by using a storage device, such as a floppy disk or a hard disk, which can be generally connected to the microcomputer system.

The customer master file 11, the product master file 12, and the sales data file 15 are files provided for the trading management system of the present invention.
Account item master file 13, Sub item account file 14
The journal data file 16 is a file originally provided for the accounting system.

A program for controlling the entire trading management system of the present invention is usually recorded on a floppy disk, and the system operates by loading this program into a memory built in the processing unit 2. Similarly, by loading the program of the accounting processing system recorded on the floppy disk into the processing device 2, the device configuration shown in FIG. 1 can be directly operated as the accounting processing system.

In the accounting system, in addition to the account item master file 13, the auxiliary item master file 14 and the journal data file 16 among the files shown in FIG. 1, various other files unique to the accounting process are provided. Create and use. On the other hand, in the trading management system, a customer master file 11, a product master file 12, and a sales data file that are unique to the trading management system among the files shown in FIG.
In addition to 16, some files (not shown) are created and used. Further, in the trading management system of the present invention, the account item master file 13, the auxiliary item master file 14 and the journal data file 16 peculiar to the accounting system are used. Also used.

The account item master file 13, auxiliary item master file 14 and journal data file 16 used by the trading management system of the present invention are created by an accounting processing system having a common data structure with the trading management system of the present invention. Has been done. Further, in the following description, for the sake of convenience, only the case of processing the sales management information of the product will be described, but it is possible to process only the sales management information, to process only the purchase management information, or both, that is, Of course, it is also possible to process information on trade management.

Next, each master file and data file shown by reference numerals 11 to 16 will be described.

Reference numeral 11 is a customer master file. FIG. 2 is a schematic diagram of a screen of a customer ledger displayed on the display device 3 for inputting individual customer data accumulated in the customer master file 11. One customer file is registered in the customer master file 11 by the operator previously operating the input device 1 to input the following information for each customer in this customer ledger.

The information to be entered in the customer ledger is the customer code, supplementary subject code, customer name, postal code, address, telephone number, closing date, collection date (payment date of the other party), billing category, tax rate. , Tax calculation classification, less than yen processing method, title classification
(Mr., Ms., Ms., etc.), Person in charge, Bank of transfer, Date of final invoice, etc.

Each customer file once registered in the customer master file 11 is specified only by inputting the customer code, and various information necessary at that time is read from the customer master file 11. It

By inputting the various information as described above into each column of the customer ledger displayed on the display device 3, one file for each customer is created, and such a file is created. A plurality of customer master files 11 are formed by accumulating.

Reference numeral 12 is a product master file.
FIG. 3 is a schematic diagram of a screen of a product ledger displayed on the display device 3 for inputting individual product data accumulated in the product master file 12. An operator operates the input device 1 in advance to input the following information for each product into the product register, thereby creating a product master file.
One product file is registered in 12.

The information to be input is a product code, product name, unit (piece, book or kg, t, etc.), price digit, quantity digit, merchandise tax category, purchase cost tax category, purchase cost, These are sales unit price, sales item code, discount item code, returned item code, etc.

The file of each product once registered in the product master file 12 is specified only by inputting the product code, and various information necessary at that time is read from the product master file 12.

By inputting the various information as described above into each column of the product ledger displayed on the display device 3, one file is created for each product, and a plurality of such files are stored. As a result, the product master file 12 is constructed.

Reference numeral 13 is an account item master file. The account item master file 13 contains account items used in normal accounting and their abbreviations, codes for specifying them, loan categories, subcategory numbers, consumption tax categories, carry forward amounts for the previous year, and aggregated amounts for each month. The final registration record and the like are stored in advance. These can be displayed on the display device 3 via the input device 1 in a window display if necessary.
By referring to it and selecting a code, it is possible to input on the screen of the display device 3 displayed at that time.

Reference numeral 14 is a supplementary subject master file. The auxiliary subject master file 14 is a master file for storing auxiliary information about each account item stored in the account subject master file 13 described above. That is, for example, the account name of “transfer” in the account master file 13 is prepared in order to set the bank name and the like in advance. This sub-item master file 14 contains each account item number, sub-item number, sub-item name, sub-item abbreviation, consumption tax category, usage flag (which will be described later) stored in the account master file 13. The amount carried over from the previous year, the monthly total amount, the final registration record, etc. are stored in advance.

Reference numeral 15 is a sales data file.
The sales data file 15 stores information about each sales transaction input in the form of a sales slip.

FIG. 4 is a schematic diagram showing a sales slip displayed on the display device 3. The information that should be entered into this sales slip via the input device 1 is the slip date, slip number, slip classification, tax classification, cover rate, slip details, less than yen processing, vendor classification,
The person in charge. If the customer code is entered, information such as the name, billing category, closing date, tax category, etc. is automatically read from the customer master file 11 and set as described above.

In this embodiment, the slip details are prepared for five lines, and the categories are sales, returned goods, discount, and application. When sales and returns are entered in the category, simply enter the product code and quantity, and the product master file 12 will contain information such as the product name, product tax category, sales unit price, unit price, and purchase price for the product with that code. It is read out from and set automatically, and the consumption tax amount, the total amount of money, etc. are automatically calculated and entered in the predetermined fields.

When a discount is entered in the slip item category, the product tax amount, the discount summary, the discount amount, etc. are entered through the input device 1. Further, when the description is input to the slip description category, an arbitrary character string can be input to the field via the input device 1.

Reference numeral 16 is a journal data file.
The journal data file 16 basically stores, as journal data, information input in the form of a deposit / withdrawal slip, a transfer slip, etc. sorted by the operator on the screen displayed on the display device 3. Journal data consists of information such as slip number, debit item code, debit item code, credit item code, credit item code, amount, debit tax category, credit tax category, consumption tax amount, summary, additional type information, etc. .

FIG. 5 is a schematic diagram showing an example of inputting a transfer slip. Here, the utility bill is the debit item, the current account is the credit item, and ABC Bank is the credit sub-item, and the consumption tax is entered. ing. In addition, in the actual input, if you enter the debit item code "733", the debit item "Utilities" will be credit item code "110" and credit assistance code "
If you input "1" respectively, the credit item "Checking account" and the credit sub-item "ABC Bank" are read from the account item master file 13 and the sub-item master file 14, respectively, and are automatically entered.

In the journal data file 16, the journal data input by the daily journaling work in this way is accumulated and used as basic data for the processing on a monthly basis or the processing at the end of the period. However, in the accounting system of the present invention, in addition to directly inputting the sorted slips as described above, information regarding the sales amount that should be sorted and input in the form of the deposit slip is displayed on the screen of the display device 3. It is automatically converted into journal data and stored in the journal data file 16 only by inputting it in the form of a sales slip.

The processing of the sales slip, which is a feature of the trading management system of the present invention, will be described below.

FIG. 6 is a flow chart showing a procedure for converting the input of the sales slip into the journal data of the accounting processing system and processing by the trading management system of the present invention.

First, a sales slip is input (step S
1). FIG. 7 shows an example of input of a sales slip on the screen of the display device 3. Here, two kinds of products (product codes 10101 and 10102) are sold to the customer code "006".

Conversion to journal data is performed according to each information in the sales slip input in this way (step S2). Here, the data is converted into journal data according to the item code for each classification already registered in the product master file 12, and further converted into the tax classification of the journal according to the product tax classification. In the example shown in FIG. 7, since the slip classification is credit, the debit item is "accounts receivable (debit subsidy item is the customer name of the customer)" and the credit item is "sales".

Next, the journal data is added up if necessary (step S3). This is a process to combine data in which the same loan item, sub item, and tax item in the same sales slip match. The sales slip shown in FIG. 7 is finally put together in the form of a journal diary as shown in FIG.

Next, the date is determined (step S).
Four). This is the case for a sale as shown in Figure 7,
Compare the closing date of the customer (monthly, weekly, or today) with the accounting closing date, and change the date to the closer one. In the case of cash sales, the slip date is used as it is.

Next, the journal data is searched (step S5). Here, it is searched whether or not the journal data having the same date, loan item, sub-item, and tax type is already registered in the journal data file 16. This is the step
Other journal data that can combine the journal data corresponding to the sales slips shown in FIG. 7 entered in S1 as one journal data, specifically, the same date for the same seller. If journal data that can be processed in (1) is already registered in the journal data file 16, this is done to combine them.

For example, as shown in the schematic diagrams of the sales slips of FIGS. 9 and 10, the same customer whose closing date is the end of the month is in the same month (in the sales slip of FIG. Figure
Consider the case where there are two sales transactions on October 20th with 10 sales slips. In this case, the sales slip shown in FIG. 9 is first converted into journal data and registered in the journal data file 16, so that the sales slip shown in FIG. 10 is converted into journal data thereafter. In this case, the journal data of both parties are put together in the form of a journal diary as shown in FIG.

Therefore, when the batchable journal data is not already registered in the journal data file 16 (step S
In 6), new journal data is added to the new journal data file.
Register in 16 (step S9). On the other hand, if the batchable journal data is already registered in the journal data file 16
In (step S6), they are collectively tabulated (step S7) and the data in the journal data file 16 is updated (step S8).

Thereafter, the sales data is converted into a sales data file.
Register to 15 and update (step S10). As described above, the information entered in the form of the sales slip is accumulated as sales data in the sales data file 15, and the journal data for accounting processing is automatically created so that the journal data file 16
Accumulated in.

In the above embodiment, a keyboard is used as the input device 1, and various information is input on the screen of the display device 3 by the input device 1 so that various slips are created and input on the screen. However, for example, so-called OCR (Optica) that automatically reads and inputs handwritten slips
It goes without saying that a Character Recognition device may be used.

Further, in the above embodiment, an example in which only the sales slip is converted into journal data and used is shown, but the present invention is not limited to this, and the purchase slip is converted into journal data and used. It is also possible to convert both into journal data for use.

[0046]

As described in detail above, according to the trading management system of the present invention, the information entered in the form of a slip representing the trading of goods is automatically converted into journal data for accounting processing. Since the data is stored in the journal data file, it is not necessary to process the input slip and the transaction slip separately when a commodity transaction occurs.

[Brief description of drawings]

FIG. 1 is a block diagram showing a device configuration of a trading management system according to the present invention.

FIG. 2 is a schematic diagram of a screen of a customer ledger displayed on a display device for inputting individual customer data accumulated in a customer master file.

FIG. 3 is a schematic diagram of a screen of a product ledger displayed on a display device for inputting individual product data accumulated in a product master file.

FIG. 4 is a schematic diagram showing a sales slip displayed on a display device.

FIG. 5 is a schematic diagram showing an example of input of a transfer slip.

FIG. 6 is a flowchart showing a procedure of converting an input of a sales slip into journal data and processing the same by the trading management system of the present invention.

FIG. 7 is a schematic diagram showing an input example of a sales slip on the screen of the display device.

8 is a schematic diagram showing a state in which the sales slips shown in FIG. 7 are put together in the form of a journal diary.

FIG. 9 is a schematic diagram showing an example of a sales slip.

FIG. 10 is a schematic diagram showing an example of a sales slip to be collectively processed with FIG. 9.

FIG. 11 is a schematic diagram showing a journal diary in which the sales slips shown in FIGS. 9 and 1 are collectively processed.

[Explanation of symbols]

 1 Input device 2 Processing device 3 Display device 11 Customer master file 12 Product master file 13 Account master file 15 Sales data file 16 Journal data file

Claims (1)

[Claims] [Claim 1] When information obtained by journalizing a slip to be processed is input, the account data is converted into journal data by referring to the account master file in which information about the account is stored in advance, and is accumulated in the journal data file. It is connected to an accounting system that performs accounting processing according to the journal data stored in this journal data file, and stores a supplier master file in which information about trading partners is stored in advance and information about products handled. A product master file stored in advance, a trade data file for accumulating information on trade of the handled product as trade data, and means for inputting a sales slip or purchase slip of the product targeted at the trading partner , Refer to the supplier master file and product master file for the input sales slip or purchase slip A means for converting into buying data and accumulating in the trading data file, converting the obtained trading data into journal data by referring to the account master file of the accounting system, and journal data of the accounting system A trading management system comprising means for accumulating in a file.