JPH052595A - Parts purchasing system - Google Patents

Abstract

PURPOSE:To accurately and efficiently form ordering data for purchasing the minimum number of parts matched with the number of parts ordered by each forming operator. CONSTITUTION:When slip data Dd are formed by a terminal equipment 1, an issuing slip data checking means 9 checks other slip data Dd stored in a data storing part 5 and an identical parts checking means 10 retrieves identical parts. When the identical parts exist, a merging checking means 11 judges whether merging is possible or not, and when merging is possible, a merging means 12 removes the parts from the slip data Dd to be merged and adds the number of parts to the merging slip data Dd. A lot number checking means 13 checks the number of ordered lots of each part, and when the number of ordered lots is less than the minimum number of lots, a lot number changing means 14 changes the number of lots to a number close to the minimum number of lots. When the number of lots is more than the minimum number, the means 14 changes the ordered number to integer times the minimum number of lots so as to approximate the changed value to the ordered value. Then the changed number of lots is sent to an ordering device 2 to form ordering data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention uses an online-connected computer to send slip data of various parts created by a terminal device to an ordering device, and the ordering device creates order data based on the slip data. Regarding the parts purchasing system.

[0002]

2. Description of the Related Art With the recent widespread use of office automation equipment, it has become possible to create slip data when purchasing goods and to create order data based on the slip data at a business office.

For example, as shown in FIG. 10, a workstation W used by a person who creates slip data (hereinafter also referred to as "part order request form") (hereinafter referred to as "creator") and an ordering device in the purchasing department. Using the component purchasing system including the computer C, the creator creates the circuit diagram 20 as shown in FIG. 11 by the circuit diagram creating unit 15 using the CAD software of the workstation W.

Next, based on the created circuit diagram data, the part number, quantity, etc. of the required electric parts are checked, and along with other necessary items, they are handwritten on a coding sheet as shown in FIG. A table is created, and the document creation unit 22 of the workstation W creates a slip D for purchasing desired parts based on the table.

After that, the slip D is sent to the purchasing department by an internal flight or the like after being stamped by the administrator, and the purchasing department creates an order data creation unit of the computer C for ordering work based on the slip D received by the operator. The order number Dh is created by manually inputting the part number, delivery destination, order quantity, desired delivery date, orderer name, etc. of the parts to 19.

Further, since it is a very troublesome work to check the part number and the quantity of the parts from the circuit diagram, in order to reduce this work, the circuit diagram data created by the document creating unit 22 of the workstation W is automatically used. In some cases, the part number, quantity, etc. of a part can be checked to create a part order request form (slip) as shown in FIG.

[0007]

However, in the parts purchasing system as described above, when, for example, two creators issue slip data for purchasing 10 parts of the same kind to the purchasing department respectively, the parts are purchased. If the minimum purchase unit number (hereinafter, referred to as “lot number”) is 100, the purchasing department creates order data for purchasing two lots of the part based on the slip data issued by each of the two persons. Sometimes.

As a result, upon delivery, each creator will receive 100 parts of the same type.
If two authors are involved in the same task or belong to the same section and both are willing to receive the desired parts in one or the other, the extra 180 Parts remain in stock.

As described above, if parts are always ordered for each slip data, as a result, more parts than necessary are purchased. Therefore, in order to prevent over-purchasing of parts as described above, the purchasing department performs work to create order data that groups together the same kind of parts in each slip data from the same work or section. If this is done, then there is a problem that the purchasing department may have trouble compiling the ordering work or may have made an error in changing the number of orders, thereby making it impossible to create order data accurately and efficiently. .

The present invention has been made in view of the above points, and accurately and efficiently creates order data for purchasing an appropriate number of parts commensurate with the number of purchases without increasing the work load. The purpose is to be able to.

[0011]

In order to achieve the above object, the present invention is sent from a terminal device for creating slip data for purchasing desired parts from CAD data of various circuit diagrams and the like and the terminal device. In a parts purchasing system including an ordering device that creates ordering data for parts based on slip data, a means for storing a plurality of slip data created in a terminal device, and a means for storing each slip data stored in the means. Merge determination means for determining whether or not the same parts can be merged, and slip data for removing and merging the part data from the slip data side to be merged with the slip data having the same parts determined to be mergeable by the means And means for adding to the side. Also,
It is preferable that the merge determination means refers to the orderer information in each slip data and determines that the merge is possible when the theme name and the desired delivery date match.

Further, in a parts purchasing system similar to the above, means for storing the minimum purchase unit number for various parts in the terminal device and means for comparing the order number of each part in the created slip data with the minimum purchase unit number. According to the comparison result, the order quantity is changed to the minimum purchase quantity for the parts whose order quantity is less than the minimum purchase quantity, and the order quantity for the parts exceeding the minimum purchase quantity is changed. A unit for changing the order number to a number that is larger than and closest to the order number out of the number obtained by multiplying the minimum purchase unit number by an integer may be provided.

[0013]

In the parts purchasing system according to the present invention, a plurality of created slip data are stored in the terminal device, it is judged whether or not the same parts in the respective slip data can be merged, and the same parts that can be merged are selected. By removing the parts from the slip data side to be merged with the existing slip data and adding them to the merged slip data side, the same parts in each slip data are automatically combined into one slip data. It is possible to create order data for purchasing a required amount of parts without performing the work of putting together the same parts of each slip data. Further, if the theme name and the desired delivery date of the orderer information in each voucher data are determined to be mergeable, the same parts in the voucher data having the same theme name and the desired delivery date are automatically merged into one. It becomes possible to put together the slip data.

Furthermore, in the terminal device, the minimum purchase unit number for the various stored parts is compared with the order number of each part in the created slip data, and the part with the order number smaller than the minimum purchase unit number is found. Change the order quantity to the minimum purchase unit quantity, and change the order quantity to the nearest and larger than the order quantity of the parts of the order quantity exceeding the minimum purchase unit quantity. As a result, the ordering device can create the ordering data of the number of orders commensurate with the required amount of parts without trouble.

[0015]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT An embodiment of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a block diagram showing the configuration of a parts purchasing system according to the present invention. In this system, a terminal device 1 each having a built-in microprocessor and an ordering device 2 are connected via a communication line 3, and slip data created by the terminal device 1 is sent to the ordering device 2 through the communication line 3. Then, the ordering device 2 creates ordering data based on the slip data.

The terminal device 1 includes a data input section 4 such as a keyboard for inputting various data, and slip data D.
A data storage unit 5 such as a floppy disk device or a hard disk device that stores d, etc., a data display unit 6 that is a display such as a CRT or LCD for displaying slip data and circuit diagram data, and circuit diagram data and slips. A data output unit 7 such as a laser printer for printing data and the like, and a data processing unit 8 including a CPU, a ROM, a RAM and the like for controlling the entire apparatus and the like.

The data processing section 8 has functions of the issuing slip data means 9, the same part confirmation means 10, the merge confirmation means 11, the merge means 12, the lot number confirmation means 13, and the lot number change means 14 as functions related to the present invention. Each function is stored, the created slip data is stored, and the same parts that can be merged in the respective slip data are merged before being issued to the ordering device 2, or the parts corresponding to the minimum purchase unit number are stored. Performs processing such as changing the number of orders. Although illustration is omitted, it is needless to say that the conventional workstation W also has a function of performing various processes such as circuit diagram creation as in the conventional workstation W shown in FIG.

FIG. 2 is a flow chart showing a process involved in merging the same parts of the slip data and changing the order quantity in the terminal device 1, and FIG. 3 is a flow chart showing a detailed process of changing the order quantity. The slip data of necessary parts for the circuit diagrams created by a plurality of creators using the terminal device 1 are sequentially stored in the data storage unit 5 shown in FIG.

When new voucher data is created, the issued voucher data checking means 9 checks the inside of the data storage unit 5 to check the voucher data before it is issued to the issuing device 2. When the slip data is confirmed, the same-part confirmation means 10 searches the same slip data for a part that is the same as the part in the newly created slip data. Determine if it can be merged.

Here, if merging is not possible, the process returns to the process for checking the next slip data as it is. , The data storage unit 5 returns to the process of confirming the slip data.
The same process is repeated for other slip data before issuance stored in the.

In this way, when the merge processing for the same parts of the newly created slip data and all the slip data before issuance is completed or when the merge processing is not necessary, an order is placed in the lot number of each part. Perform the process of matching the numbers. That is, as shown in FIG. 3, the lot number confirmation means 13 confirms the number of parts ordered in the slip data.

Next, the number of orders confirmed by the lot number changing means 14 and the minimum purchase unit number of the part stored in advance in the lot master (hereinafter referred to as "minimum lot number").
Compared with, it is not larger (smaller) than the minimum lot number
In that case, change the order number of the part to the minimum lot number, and if it is larger than the minimum lot number (exceeds the minimum lot number),
The minimum lot number is sequentially multiplied by an integer (n = 1, 2, ...) and compared with the order number. When the lot number obtained by multiplying the minimum lot number by an integer becomes larger than the original order number, the lot number is updated. Change the order quantity.

That is, the number of orders is changed to a number which is larger and closer to the original number of orders out of the number obtained by multiplying the minimum lot number by an integer. Then, when these processes are completed, the respective slip data are stored in the data storage unit 5 again.

Therefore, before ordering a plurality of slip data created in the terminal device 1 to the ordering device 2, mergeable parts of the same parts of each slip data are merged, and the number of orders of each part is also stored in advance. It is possible to change to the smallest number for each smallest lot number.

Next, an example of the case where the above-described parts purchasing system is operated in an actual business place will be described. FIG. 4 is a block diagram corresponding to FIG. 10 showing the configuration of the parts purchasing system in this embodiment, in which a workstation W ′ corresponding to the terminal device 1 of FIG. 1 and a computer C ′ corresponding to the ordering device 2 are networked. Are connected via a communication line 3 for communication.

That is, the workstation W'is a circuit diagram creation unit 15 for creating various circuit diagrams, a circuit diagram file 16 for storing the data of the created circuit diagrams, and parts purchase based on the circuit diagram data. Has the functions of an issue support unit 17 for creating a parts order request form for merging, merging the same parts and changing the number of parts orders related to the present invention, and an order file 18 for storing the data of the parts order request form. is doing

The issue support unit 17 prepares information such as the theme name, creator name, affiliation, desired delivery date, etc. of the stamped part order request form, part number, maker name, maker model number, and the number of orders. The parts information such as the above is managed as data of the order file 18. On the other hand, the computer C'includes an order data creating section 19 'therein and creates the order data Dh based on the data of the parts order request form transferred from the workstation W'through the communication line 3 through the network.

Here, when creating a parts ordering request form in the workstation W ', if the work is selected, for example, a standard frame of the parts ordering request form as shown in FIG. 5 is displayed. Necessary items such as the name of the creator, the theme name, the desired delivery date, etc. are input, and then a predetermined operation is performed to automatically input the type of parts and the number of orders from the desired circuit diagram data.

The part order request form thus created is temporarily stored in the memory in the workstation W ', but when the boss in charge receives the stamp, the order file 1
8 is stored. At that time, the above-described merge process and order number change process are performed. For example, if the creator (orderer) Mr. Tanaka creates and issues the parts ordering request form as shown in FIG. 7 by the creator (orderer) Suzuki, they have the same theme. Name and desired delivery date.

Then, since it is judged that the same parts can be merged, the part with the part number "11111111" is deleted from Mr. Tanaka's part order request form shown in FIG. 6, and the part with Mr. Suzuki shown in FIG. Add 2 to the order request form
The number is changed from three to three, and they are stored in the order file as a parts order request form as shown in FIGS. 8 and 9, respectively.

After that, when the computer C'sends a request for transfer of ordering data once a day, the workstation W'transfers the data in the ordering file 18 to the computer C ', and the computer C'orders by the data. Data Dh is created and an order is placed with the supplier. In addition,
Do not transfer the parts order request form that is being created, and a printing device (not shown) such as a laser printer is connected to the outside of the workstation W'to print the circuit diagram and the parts order request form on paper. it can.

Therefore, according to the conventional parts purchasing system, Mr. Tanaka and Mr. Suzuki are given the part number "11" at the desired delivery date.
Since the parts of "111111" arrive at 100 pieces, which is the minimum lot number, although two people can share the parts, they have an extra inventory of 99 pieces and 98 pieces, respectively. According to the embodiment, if Tanaka goes to pick up the parts that arrive at Mr. Suzuki, the extra inventory will be 97 pieces.

As described above, the criterion for merging the same parts is that the theme name and the desired delivery date are the same. In that case, creators with the same theme are often in close proximity, so either one can easily get the parts, and one creator can wait for the parts because the desired delivery time of both parties is kept. There is nothing to do.

Further, since the parts are generally purchased in the minimum lot unit number, if the order number of each part is automatically changed to the number closest to the order number among the integral multiples of the minimum lot unit number, the order is placed. The processing load of creating data can be reduced,
You can prevent mistakes in changing the number of orders.

[0035]

As described above, according to the parts purchasing system of the present invention, the number of orders for each kind of parts is reduced as much as possible without increasing the work load of creating order data for purchasing parts. be able to.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a parts purchasing system according to the present invention.

FIG. 2 is a flowchart showing a process related to merging of the same parts of the slip data and changing the order quantity in the terminal device 1 of FIG.

FIG. 3 is a flowchart showing the details of the order number change process.

FIG. 4 is a block diagram showing a configuration of a parts purchasing system similar to that of FIG. 10 when this embodiment is applied.

FIG. 5 is a diagram showing an example of a fixed frame displayed when creating a parts order request form.

FIG. 6 is a diagram showing an example of a created parts order request form.

FIG. 7 is a diagram showing another example of a component order request form that is also created.

8 is a diagram showing a parts order request form after the same parts are merged with the parts order request form shown in FIG. 6;

9 is a diagram showing a parts order request form after the same parts are merged with the parts order request form shown in FIG. 7;

FIG. 10 is a block diagram showing a configuration of a conventional parts purchasing system.

11 is a diagram showing an example of a circuit diagram created by the workstation W in FIG.

FIG. 12 is a diagram showing an example of a coding sheet used when creating a conventional parts order request form.

13 is a diagram showing an example of a parts order request form created by the workstation shown in FIG.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 Terminal device 2 Ordering device 3 Communication line 4 Data input unit 5 Data storage unit 6 Data display unit 7 Data output unit 8 Data processing unit 9 Issue slip data confirmation means 10 Same part confirmation means 11 Merge confirmation means 12 Merge means 13 Lot number Confirmation unit 14 Lot number changing unit 15 Circuit diagram creation unit 16 Circuit diagram file 17 Issuance support unit 18 Ordering file 19 Order data creation unit 20 Circuit diagram W, W'Workstation C, C'Computer Dd Voucher data Dh Order data

Claims (3)

[Claims] 1. A terminal device for creating slip data for purchasing desired parts from CAD data such as various circuit diagrams, and an ordering device for creating order data for parts based on the slip data sent from the terminal device. In the parts purchasing system, the means for storing a plurality of created slip data in the terminal device, and a merge judgment for judging whether or not the same parts in each slip data stored in the means can be merged Means for removing the component data from the merged slip data side and adding to the merged slip data side with respect to the slip data having the same component determined to be mergeable by the means. Parts purchase system. 2. The parts purchasing system according to claim 1, wherein the merge determination means refers to the orderer information in each slip data and determines that the theme name and the desired delivery date are mergeable. A parts purchasing system characterized by being means. 3. A terminal device that creates slip data for purchasing desired parts from CAD data such as various circuit diagrams, and an ordering device that creates order data for parts based on the slip data sent from the terminal device. In the parts purchasing system consisting of, the terminal device, means for storing the minimum purchase unit number for various parts, means for comparing the order number of each part in the created slip data with the minimum purchase unit number, According to the comparison result, the order quantity is changed to the minimum purchase quantity for the parts whose order quantity is less than the minimum purchase quantity, and the minimum purchase quantity for the parts whose order quantity exceeds the minimum purchase quantity. A parts purchasing system, comprising means for changing the number of orders to a number that is larger than and closest to the number of orders, which is obtained by multiplying the number by an integer.