JP2000113059A - Data processing device and storage medium - Google Patents

Abstract

(57) [Summary] [Problem] To solve the problem of the present invention, even if it is a new product, it is possible to perform inventory management in the same way as a product that has already been subjected to inventory management. An object of the present invention is to provide a data processing device and a storage medium that can be performed smoothly. SOLUTION: A data processing device 1 stores a product DB 8a as a database for product inventory management in a storage medium 8, and configures a record of the product DB 8a with a registration date and an adoption flag. Even if there is, the data can be managed in the same product DB 8a as the product that has already been subjected to inventory management. Also, the CPU 2
New product registration processing, product adoption processing, order processing, acceptance processing,
In addition to executing record management processing and registering records for new products, managing data relating to new product adoption, ordering, and acceptance, as well as ordering new products to manufacturers, printing purchase orders, and Automatically print a list of

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing apparatus for performing inventory management, and more particularly, to a data processing apparatus for performing a series of processing related to goods storage management, such as new registration, order placement, and acceptance of goods.

[0002]

2. Description of the Related Art Management of merchandise in a store can be divided into receiving management by ordering and receiving goods from a maker, and outgoing management by displaying goods and sending them to customers. In addition, it is becoming common to use a computer to perform processing of merchandise that combines this warehousing management and warehousing management as inventory management. This inventory management process includes all the products that need to be ordered, such as ordering for products that need to be ordered regularly, products that are out of stock, and changing the order quantity of seasonal products. This is a process for appropriately adjusting the stock amount related to the above.

[0003] On the other hand, in a conventional store, a series of work flows relating to the receipt of a new product is as follows. First, a manufacturer proposes a new product, and then, it is determined whether or not the proposed new product can be adopted. If it is determined that the product is to be adopted, an order is placed for the product, and then the product is accepted.

[0004]

However, since it is common to start the management of the product by the inventory management processing by the computer after it is determined that the new product is to be handled continuously, it is necessary to store the new product. Such processing is usually performed as a separate processing. This is because the process of receiving a new product may be canceled after the new product has been adopted for some reason, or if there is a trial period for adoption, or if the product is subject to popularity or fashion. As a result, it may take a lot of time to judge the adoption of the product. For example, temporary registration, registration change, registration deletion, etc., which are necessary to process inventory management by computer immediately after a new product is proposed. This is because a complicated operation of (1) occurs.

[0005] Further, the ordering and acceptance processing for these new products is often performed manually, and therefore, it may take time to place an order or omission of the order may occur.

An object of the present invention is to enable a new product to be managed in the same manner as a product that has already been subjected to inventory management, and to facilitate ordering and acceptance of a new product. An object of the present invention is to provide a data processing device and a storage medium storing the inventory management program.

[0007]

According to the first aspect of the present invention,
A storage unit that stores a plurality of product records, and a product record registration unit that adds and registers unprocessed information indicating that the product record is unprocessed when newly registering the product record in the storage unit. When extracting a product record from the storage unit, a product record extraction unit that determines the unprocessed information and extracts an unprocessed product record;
Product record processing means for executing an order processing for creating and outputting a product order list for the product records extracted by the product record extraction means; and a product record processing means for executing the order processing by the product record processing means. Merchandise record re-registration means for adding the processed information indicating that the processing has been completed and re-registering the product record in the storage means.

According to the first aspect of the present invention, the storage means stores a plurality of product records, and the product record registration means, when newly registering the product record in the storage means, stores the product record in an unrecorded state. Unprocessed information indicating processing is added and registered, and when extracting a product record from the storage unit, the product record extraction unit determines the unprocessed information and extracts an unprocessed product record. Then, when the product record processing means executes an order processing for creating and outputting a product order list for the product records extracted by the product record extraction means, the product record re-registration means Processed information indicating that processing has been completed is added to the product record for which order processing has been performed, and the product record is re-registered in the storage unit.

Therefore, even when a record relating to a new product is newly registered, the product record can be managed together with the product in which the product record has already been stored. Therefore, it is possible to provide a highly practical data processing device capable of smoothly performing order processing even for a new product.

[0010]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a data processing apparatus 1 to which the present invention is applied will be described below in detail with reference to FIGS. First, the configuration will be described.

FIG. 1A is a block diagram showing an internal configuration of a data processing device 1 according to an embodiment of the present invention. In FIG. 1A, the data processing device 1
It comprises a PU 2, an input device 3, a RAM 4, a display device 5, a printing device 6, a storage device 7, a storage medium 8, and a communication device 9, and each part except the storage medium 8 is connected by a bus 10. Also, the data processing device 1
The ordering and acceptance of each product is performed, and the data relating to the ordering and acceptance of each product and the data such as whether or not a new product is adopted are stored in a product database 8a (hereinafter referred to as a product DB), which will be described later. It is a device that manages inventory by collectively managing all the products handled including.

CPU (Central Processing Unit) 2
Are application programs specified from various application programs corresponding to the data processing device 1 stored in the storage medium 8 in the storage device 7 and various application programs corresponding to various instruction signals input from the input device 3. Data and the like are stored in the RAM 4, various processes are executed in accordance with the application program stored in the RAM 4 according to the input instruction and the input data, and the processing results are stored in the RAM 4 and displayed on the display device 5. Then, the CPU 2 stores the processing result stored in the RAM 4 in a storage destination of the storage medium 8 in the storage device 7 which is instructed to be input from the input device 3.

The CPU 2 responds to an instruction signal input from the input device 3 to register a new product (see FIG. 3) stored in a storage medium 8 in a storage device 7 and to process a product adoption (see FIG. 4). (See FIG. 5), an ordering process (see FIG. 5), an acceptance process (see FIG. 6), and a program related to the receipt management process (see FIG. 7), and execute each process according to the read program.

Although a detailed description of each process will be described later, the CPU
2 executes a new product registration process (see FIG. 3) and executes a product DB
8a, a record of a new product is newly created and registered, a product adoption process (see FIG. 4) is executed, the availability of the new product is registered in the product DB 8a, and an ordering process (see FIG. 5) is executed. A purchase order is created for the product that has been adopted, and an e-mail is sent to the manufacturer to place an order.
Is executed, the presence / absence of acceptance of the ordered product is registered in the product DB 8a, and the receipt management process (see FIG. 7) is executed to create and print a list of unaccepted products. Thus, CP
By executing these processes, U2 performs inventory management on the same product DB 8a in the same manner as a product already managed for inventory, even for a new product.

The input device 3 includes a keyboard provided with a cursor key, numeral input keys, and the like, and a pointing device such as a mouse, and outputs to the CPU 2 a pressing signal of a key pressed on the keyboard and a mouse position signal.

A RAM (Random Access Memory) 4 is a C
When the PU 2 executes the various application programs, it forms a program storage area for expanding various data, and the CPU 2 executes the new product registration process (see FIG. 3), the product adoption process (see FIG. 4), and the ordering process. (See FIG. 5), a memory area for temporarily storing data and the like relating to the acceptance processing (see FIG. 6) and the receipt management processing (see FIG. 7).

The display device 5 is a CRT (Cathode Ray Tub).
e) and the like, and displays display data input from the CPU 2. The printing device 6 includes an ink jet printer, a laser printer, or the like, prints various data in accordance with a print signal input from the CPU 2, prints an order sheet in an order processing (see FIG. 5) executed by the CPU 2, The unaccepted merchandise list is printed in the receipt management process (see FIG. 7).

The storage device 7 has a storage medium 8 in which programs, data and the like are stored in advance, and this storage medium 8 is constituted by a magnetic or optical storage medium or a semiconductor memory. The storage medium 8 is fixedly provided in the storage device 7 or is detachably mounted. The storage medium 8 is processed by various application programs or various processing programs corresponding to the data processing device 1. Product DB8 that stores data such as the availability of new products, order data for each product, etc.
a (record structure will be described in detail later), adoption date data 8b indicating the last day of deciding whether to adopt a new product and deciding to adopt, order date data 8c indicating the last day of ordering the product, A maker-specific E-mail table 8d that stores an E-mail address for each maker of the order destination is stored.

The communication device 9 connects the bus 10 to a communication line, and sends a mail created and transmitted in the ordering process (see FIG. 5) executed by the CPU 2 to each manufacturer.

The program and data stored in the storage medium 8 may be received from another device connected to a communication line via the communication device 9 and stored.
Further, a storage device having the storage medium 8 is provided on another device connected via a communication line, and programs, data, and the like stored in the storage medium 8 are used via the communication device 9. It may be.

Here, the record configuration of the product DB 8a will be described with reference to FIG. FIG. 1B is a diagram illustrating a record configuration of the product DB 8 a stored in the storage medium 8.

In FIG. 1B, the record structure of the product DB 8a is a JAN (Ja) for uniquely identifying each product.
panese Article Number), the product name, the manufacturer name of the product, the registration date when the record was first registered after the manufacturer proposed the product, and the order date of the product And an adoption flag indicating whether or not to adopt, an order flag indicating whether or not an order has been placed, and an acceptance flag indicating whether or not acceptance has been performed. Each corresponds to one record.

The adoption flag, the order flag, and the acceptance flag each store either "ON" or "OFF". When the flag is "ON", the respective flags are employed,
Ordered and accepted are shown, and "OFF" indicates rejected, unordered, and unaccepted.

FIG. 2A shows an order form printed by the order processing (see FIG. 5) executed by the CPU 2 and a list of unaccepted goods printed by the receipt management processing (see FIG. 7). This will be described with reference to FIG. FIG.
FIG. 2A is a diagram illustrating an example of an order sheet printed by an order process executed by the CPU 2, and FIG.
It is a figure showing an example of an unaccepted goods list printed by arrival management processing performed by CPU2.

In FIG. 2A, the order form is a list in which a product code, a product name, and a quantity are listed for each maker. In the order processing (see FIG. 5) executed by the CPU 2, Created. The created order form is attached to an e-mail by the CPU 2 in the order processing, transmitted to each manufacturer, and printed as a copy.

In FIG. 2B, an unaccepted product list is a list displaying product codes, product names, and order dates, and is created in the receipt management process (see FIG. 7) executed by the CPU 2. -Printed and used for unaccepted product management.

Next, the operation will be described. With reference to FIGS. 3 to 7, respective operations of a new product registration process, a product adoption process, an order placement process, an acceptance process, and a receipt management process executed by the CPU 2 will be sequentially described. The product DB 8a as described above
Contains data on products that have already been subjected to inventory management. Processing such as ordering and acceptance of these products can be included in the processing described below. Therefore, the description of the processing relating to a product for which inventory management is already performed is omitted.

First, the operation of the new product registration process will be described with reference to FIG. FIG. 3 is a flowchart showing a new product registration process executed by the CPU 2.

First, the CPU 2 reads the new product registration processing program stored in the storage medium 8 and stores the read program in the RAM.
4 and starts a new product registration process according to the new product registration process program, reads out the product DB 8a stored in the storage medium 8, and opens the product DB 8a (step S1). Next, the user operates the input device 3
When a product code, a product name, and a maker name of a new product are input (step S2), the CPU 2 sets the adoption flag, order flag, and acceptance flag to "OFF" based on the input data. A record is created (step S3). Then, the CPU 2 inputs the date when this process was executed on the record registration date (step S4), adds the record to the product DB 8a, and updates the product DB 8a (step S5).

When the user inputs further registration of a new product (step S6), the CPU 2 shifts to step S2 and repeatedly executes the processing of steps S2 to S6. Further, when an input to end the registration of the new product is made in step S6, the CPU 2 closes the product DB 8a (step S7) and ends the new product registration process.

Next, the operation of the product adoption process will be described with reference to FIG. FIG. 4 is a flowchart showing the product adoption process executed by the CPU 2.

First, the CPU 2 reads out the product adoption processing program stored in the storage medium 8 and
And starts the product adoption process according to the product adoption process program, and stores the product D stored in the storage medium 8.
B8a is read, and the commodity DB 8a is opened (step S11). Next, the CPU 2 reads the last employment decision date from the employment date data 8b stored in the storage medium 8, and stores the record whose registration date is after the employment decision date in the product DB.
8a (step S12), and the extracted records are displayed on the display device 5 (step S13).

When the user selects and inputs a record corresponding to the product to be adopted from the input device 3 (step S14), the CPU 2 updates the record by setting the adoption flag of the selected and inputted record to "ON". (Step S15). The CPU 2 repeatedly executes the processing of steps S14 to S15 until the user finishes selecting and inputting a record to be adopted (step S14).
16).

When the user inputs an instruction to end the selection input, the CPU 2 overwrites the adoption date data 8b stored in the storage medium 8 with the date at which the present process was executed, and records the data (step S1). S17), the product DB 8a is closed (step S18), and the product adoption process ends.

Next, the operation of the order processing will be described with reference to FIG. FIG. 5 is a flowchart showing the order processing executed by the CPU 2.

First, the CPU 2 reads out the order processing program stored in the storage medium 8 and stores it in the RAM 4, starts the order processing in accordance with the order processing program, and stores the product DB 8 a stored in the storage medium 8. Read and open the product DB 8a (step S2)
1). Next, the CPU 2 extracts, from the product DB 8a, records in which the adoption flag is “ON” and the order flag is “OFF” (step S22). Create a purchase order sheet,
It is stored in the RAM 4 (step S23).

Then, the CPU 2 extracts all records for any one maker from the records extracted in step S22 (step S24). Then, based on the product code, product name, and quantity of the extracted record, the CPU 2 reads out the purchase order sheet of the corresponding maker from the RAM 4 from the purchase order sheet created in step S23, and creates an order form. (Step S25). Next, the CPU 2 reads the E-mail address of the maker from the maker-specific E-mail table 8d stored in the storage medium 8, creates an e-mail for ordering (step S26), and sends the order form to the e-mail. Is stored in the RAM 4 (step S27), and the created purchase order is output to the printing device 6 and printed (step S28). Then, the CPU 2 determines in step S
At 24, the order flags of all the records extracted for any one manufacturer are set to "ON", and the records are updated (step S29).

Then, the CPU 2 executes steps S24 to S24.
After the process of step S29 is performed on all manufacturers of the record extracted in step S22 (step S3
0), read out all the mails stored in RAM4,
Transmission to each maker via the communication device 9 (step S3
1). After the transmission of the e-mail, the CPU 2 closes the product DB 8a (step S32), overwrites and saves the ordering date with the ordering date data 8c stored in the storage medium 8, and ends the ordering process.

Next, the operation of the acceptance processing will be described with reference to FIG. FIG. 6 is a flowchart showing the acceptance processing executed by the CPU 2.

First, the CPU 2 reads the inspection processing program stored in the storage medium 8 and stores it in the RAM 4, starts the inspection processing in accordance with the inspection processing program, and reads the product DB 8 a stored in the storage medium 8. To open the product DB 8a (step S4
1). Next, when the user inputs the product code of the inspected target product (step S42), the CPU 2 reads a record including the input product code from the product DB 8a (step S43), and sets an inspection flag of the record. The record is updated to "ON" (step S44).

Then, when the user inputs that the acceptance process for another product is to be performed, the CPU 2 shifts to step S42 and repeatedly executes the processes of steps S42 to S44 (step S45). Further, when an input indicating that the acceptance processing is to be terminated is made, the CPU 2 closes the product DB 8a (step S45) and terminates the acceptance processing.

In step S44, the CPU 2
By setting the acceptance flag to "ON" and then turning the order flag of the record to "OFF", it is possible to repeatedly execute the order processing for the product, but mainly for the process relating to the new product. For the sake of explanation, the description of this operation in the order processing and the acceptance processing is omitted.

Next, the operation of the receipt management processing will be described with reference to FIG. FIG. 7 is a flowchart showing the arrival management processing executed by the CPU 2.

First, the CPU 2 reads the receipt management processing program stored in the storage medium 8 and
And the receipt management processing is started according to the receipt management processing program. Then, the CPU 2 reads the product DB 8a stored in the storage medium 8, and reads the product DB 8a.
When a is opened (step S51), a record in which the order flag is "ON" and the acceptance flag is "OFF" is extracted from the product DB 8a (step S52). And
The CPU 2 determines the product code, product name,
A non-accepted product list is created based on the order date (step S53), and printed from the printing device 6 (step S5).
4) After the printing is completed, the product DB 8a is closed (step S55), and the receiving management process is ended.

As described above, the data processing apparatus 1 to which the present invention is applied stores the product DB 8a in the storage medium 8 as a database for product inventory management.
, The registration date and the adoption flag are configured in the record, so that even if it is a new product, data can be managed in the same product DB 8a as the product whose inventory management is already performed. Further, the CPU 2 executes a new product registration process, a product adoption process, an order process, an acceptance process, and a receipt management process to register a record relating to a new product and to acquire data relating to the adoption, ordering, and acceptance of a new product. At the same time as management, it automatically orders new products to the manufacturer, prints out purchase orders, and prints a list of unaccepted products.

Therefore, even if it is a new product, inventory management can be started and executed in the same manner as a product that has already been subjected to inventory management, and a new product can be automatically ordered, a purchase order can be printed, and Since the list of the accepted products is printed, it is possible to provide a highly practical data processing device capable of smoothly ordering and accepting new products.

It should be noted that the present invention is not limited to the contents of the above-described embodiment, but can be appropriately changed without departing from the spirit of the present invention. May be added to enhance the items to be printed, or the CPU 2 may periodically and automatically execute the receipt management process based on the order date of the order date data 8c updated in the order process.

[0048]

According to the first and fourth aspects of the present invention, even when a record relating to a new product is newly registered, it can be managed together with a product whose product record is already stored. In addition, since a newly registered record can be extracted and an ordering process can be performed, a highly practical data processing device and a product inventory management program capable of smoothly performing an ordering process even for a new product. Can be provided.

According to the second aspect of the invention, in addition to the effect of the first aspect of the present invention, since a product order list is created for each supplier, a more convenient data processing apparatus can be provided. It is possible.

According to the third aspect of the invention, in addition to the effect of the first aspect of the present invention, a newly registered record can be extracted and the acceptance process can be performed, so that even a new product can be smoothly processed. It is possible to provide a highly practical data processing device capable of performing the acceptance processing.

[Brief description of the drawings]

FIG. 1A is a block diagram illustrating an internal configuration of a data processing device 1 according to an embodiment of the present invention. (B)
The figure which shows the record structure of the goods DB8a memorize | stored in the storage medium 8. FIG.

FIG. 2A is a diagram illustrating an example of an order form printed by an order processing executed by a CPU 2; (B) CPU 2
The figure which shows an example of the uninspected merchandise list printed by the receiving management process which is performed by.

FIG. 3 is a flowchart showing a new product registration process executed by a CPU 2;

FIG. 4 is a flowchart illustrating a product adoption process executed by a CPU 2;

FIG. 5 is a flowchart showing order processing executed by the CPU 2;

FIG. 6 is a flowchart showing an inspection process executed by the CPU 2;

FIG. 7 is a flowchart showing an arrival management process executed by the CPU 2;

[Explanation of symbols]

 Reference Signs List 1 data processing device 2 CPU 3 input device 4 RAM 5 display device 6 printing device 7 storage device 8 storage medium 8a product DB 8b adoption date data 8c ordering date data 8d E-mail table for each manufacturer 9 communication device 10 bus

Claims (4)

[Claims] 1. A storage unit for storing a plurality of product records, and a product to be registered by adding unprocessed information indicating that the product record is unprocessed when newly registering the product record in the storage unit. Record registering means, when extracting a product record from the storage means, a product record extracting means for determining the unprocessed information and extracting an unprocessed product record, and a product record extracted by the product record extracting means A product record processing means for executing an order processing for creating and outputting a product order list for the product record processing information indicating that processing has been performed on the product record for which the order processing has been performed by the product record processing means; A data record re-registering means for adding and re-registering the product record in the storage means. 2. The merchandise record is configured to include merchandise information indicating merchandise to be ordered and supplier information indicating an orderee. The merchandise record processing means includes: 2. The data processing apparatus according to claim 1, wherein the extracted merchandise records are classified according to supplier information, and the merchandise records are individually output for each classified supplier to create a merchandise order list. 3. The storage means stores the product record with identification information for identifying the presence or absence of product acceptance, and the product record extraction means sets the identification information from the storage means as no product acceptance. The merchandise record processing means executes merchandise inspection processing on the merchandise records without merchandise inspection extracted by the merchandise record extraction means, and the merchandise record re-registration means includes 2. The data processing apparatus according to claim 1, wherein the identification information of the commodity record for which the commodity inspection has been performed by the record processing means is set to the presence of the commodity inspection, and the commodity record is re-registered in the storage means. 4. A storage medium storing a computer-executable program, wherein the computer-executable program code for storing a plurality of product records in a storage means, and a product record newly registered in the storage means. A program code executable by a computer for adding and registering unprocessed information indicating that the product record is unprocessed; and extracting the product record from the storage means, A computer-executable program code for determining information and extracting an unprocessed product record, and a computer for executing an order process of creating and outputting a product order list for the extracted product record Has been processed for the program code executable for the Storage medium having a computer executable program code, and characterized by storing a program including the order to re-register in the storage means adds the processed information indicating that it is.