JPH11338948A - Packing instruction system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate the extraction work of a small article member case which is the combination of the same members, to make it possible to cope with delivery date change and cancellation as well and to make a small article usable for another order by providing a data base for registering the item number and quantity of the small article member to be packed corresponding to a packing case item number. SOLUTION: A production instruction device 4 develops one order to a member level as member constitution data, extracts the small article member to be packet from the developed members and sends it out to a packing instruction device 5. The packing instruction device 5 registers the item number and quantity of the small article member to be packed corresponding to the packing case item number to a packing information data base 3b based on the extracted small article member and packing information data registered in the packing information data base 3b of a data base server 3.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a method for converting a single order composed of a combination of one product consisting of a main part group and one or more optional parts consisting of sub-parts into tree-like member configuration data. The present invention relates to a packing instruction system that expands to a member level as a reference and outputs the result as a packing instruction.

[0002]

2. Description of the Related Art For example, as shown in FIG. 17, a bathroom unit is composed of a combination of a product part composed of a group of main parts and optional parts composed of sub-parts. The product department consists of the basic components that make up the bathroom unit: bathtub, washroom, wall panel, ceiling panel, door, lighting equipment,
It contains a ventilation fan, a silicone agent that performs waterproofing at the time of construction, etc. The combination of bathroom dimensions, color, bathtub design etc. is determined in advance, and the combination desired by the customer is 1
You can choose one. Also, optional parts
Mirror, mixing faucet, timer switch for ventilation fan (not shown)
It is a part that adds a bathroom function, such as a bathroom function, so that only functional parts required by customers can be selected.

For example, as shown in FIG. 18, a product A is ordered from Mizuno House and a mirror and a mixing faucet are added as additional functions, and only a product A is ordered from Suzuki House. That is, by expressing the order from the customer by a combination of one product and a plurality of selectable optional parts, it is possible to respond to diversification of customer needs.

[0004] The order received at the factory is expanded to the member level as tree-like member configuration data, and the necessary member types and quantities are calculated. Then, a production instruction or a delivery instruction is created using the calculated result, necessary members are collected, shipped in a shipping form described later, and assembled into a unit at a construction site.

[0005] As shown in Fig. 17, in the shipping form, among the product sections, bathtubs, washing areas, wall panels, ceiling panels, doors, and the like are subjected to simple packing so as not to collapse, and are loaded on shipping pallets. The relatively small member is a single cardboard case (hereinafter referred to as a small member case) 33 in consideration of the loss prevention and the convenience of carrying during assembly.
And packed on a shipping pallet.

That is, two orders having the same product part and different optional parts have the same form of loading on a shipping pallet and are common, but the members to be packed in the small member case are different, so they are common. Will not be. For example, taking the Mizuno House and the Kato House shown in FIG. 18 as an example, the product part of the two houses is the same A, but the selected optional parts are different.
3 has a mirror not found in Kato's house.

FIGS. 19 (a) and 19 (b) illustrate an option pattern of a product Z shipped during a certain month and an option pattern of a product Z shipped on a certain day. For the product Z, 30 types of patterns are generated in one month, and 6 types of patterns are generated in one day.

On the other hand, the packing operation of the small member case for each house is performed by using a small member case packing material instruction system for extracting only the packing member based on the development data for each house and issuing a packing instruction. For example, a packing instruction shown in FIG. 20 is created three days before shipment. An operator of the packing line performs a packing operation based on the packing instruction.

FIGS. 2 and 3 show the order of Mizuno House shown in FIG. 18 based on actual data. FIG. 2 shows an order at the time of reception at the factory, and includes columns of order number / customer name, product number, type, quantity, and product name. FIG. 3 shows a state in which the order shown in FIG. 2 is expanded into tree-like member configuration data, and includes a product number, a child product number, a child product name,
It consists of columns of grandchild part number, grandchild part name, quantity, and type.
Among them, the numbers 1 to 5 described in the type column indicate that the member is a simple packing member, and the number 6 is a member that the member should be packed in the small member case 33. It is shown that.

[0010]

As described above, the conventional small member case packing instruction system issues a packing instruction for each order based on the member configuration data. for that reason,
Even when a plurality of orders are small member cases made of the same combination of members, since the worker performs packing work in the order of issuing the packing instruction, the small member cases made of the same combination of members are packed together. And the workability (productivity) was poor.
In addition, in order to improve the operability (productivity), when trying to pack together small member cases made of the same combination of members, the operator checks whether the combination of the same members is the same while checking the contents of the packing instruction sheet. It is necessary to judge whether or not it is necessary to perform an operation of extracting a small member case that is a combination of the same members. Also, even if the same small member case has been packed in the past, the only way to determine which order the small member case matches is to compare the contents of the packing instruction or the small member case. When there is a change or cancellation, there is a problem that it cannot be transferred to another order.

A first object of the present invention is to provide a database for registering the part numbers and quantities of small parts to be packed in correspondence with the packing case part numbers. Accordingly, an object of the present invention is to provide a packing instruction system that facilitates the work of extracting small member cases that are a combination of the same members, can respond to a change in delivery date or cancel, and can be diverted to another order. A second object is to determine the packing case part number by expanding the order by periodically deleting unused parts of the increasing contents of the database when such a database is provided. It is an object of the present invention to provide a packing instruction system that shortens the processing time of the packing. The third purpose is to display the product name on the packing instructions,
It is an object of the present invention to provide a packing instruction system that makes it easy for an operator to make a decision.

[0012]

In order to solve the above-mentioned problems, a packing instruction system according to a first aspect of the present invention comprises a product consisting of a main part group and one or more optional parts consisting of sub-parts. Member expanding means for expanding one order constituted by the combination of the above to the member level as tree-shaped member configuration data, extracting means for extracting small members to be packed from the expanded members, A registration means for registering the part number and quantity of small parts to be packed in the database in association with the packing case part number, and a packing instruction for summing up the packing case part numbers registered in the database and indicating a required amount for each packing case part number And a packing instruction output means for outputting a list of parts for each packing case part number. Having the same combination of the part and quantity of the extracted small members retrieved from said database, if there is a combination matching registers the same packing case part and its combinations in the database,
If there is no matching combination, the newly determined packing case part number is registered in the database.

According to a second aspect of the present invention, there is provided a packing instruction system according to the first aspect, wherein a packing case part number registered in the database and date data when the packing case part number is used. A packaging case part number master for registering the packaging case part number and a deletion unit for deleting information on the packaging case part number that has not been used within a certain period of time from the database based on the date data registered in the packaging case part number master. A configuration is provided.

According to a third aspect of the present invention, there is provided a packing instruction system according to the first or second aspect, further comprising a packing case part number master capable of registering an arbitrarily determined product name with respect to the packing case part number. The packing instruction output means is configured to display the product name registered in the packing case part number master in a packing instruction sheet and output the same.

[0015]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 shows a schematic configuration of an entire system including an order entry to a packing instruction system of the present invention.

That is, an order from an order input terminal 1 installed in a sales office is received by an order entry device 2, and the received order is received by a database server 3.
Based on the member configuration data registered in the member configuration database 3a, the production instructing device 4 performs a development process,
Create production instructions and delivery instructions. The production instruction is sent to the line instruction device 6. Further, the production instruction device 4 extracts a small member to be packed from the unfolded members and sends it to the packing instruction device 5.

Based on the extracted small parts and the packing information data registered in the packing information database 3b of the database server 3, the packing instruction device 5 determines the part number and quantity of the small parts to be packed with the packing case part number. Correspondingly, a process of registering in the packing information database 3b is performed.

That is, the packing instruction system of the present invention comprises:
In the present embodiment, the processing is realized by bidirectional processing by the database server 3, the production instruction device 4, and the packing instruction device 5, and the production instruction device 4 corresponds to the component expanding means and the extracting means according to claim 1. The packing instruction device 5 corresponds to the registering means and the packing instruction output means.

FIG. 2 shows an example of an order received by the order entry device 2. That is, the order No. (F519
80328), customer name (Mizunote), and product number (A, mirror A, mixing faucet B). For the product number (A), type (product), quantity (1), product name (B2-H1
116-SC4). The product number (mirror A) is the type (option), the quantity (1), and the product name (Counter Tsukikagami). Further, the product number (mixed faucet B) is the type (option), quantity (1), and product name (congo narcissus).

FIG. 3 shows the order of the contents illustrated in FIG.
The figure shows a state where the data is expanded to the member level based on the member structure data registered in the member structure database 3a of the database server 3. That is, the product number (A) is
The child part number (U1) is composed of two grandchild parts, the child part number (U2) is composed of two grandchild parts, and the child part number (U3) is seven grandchild parts. The child part number (U4) is composed of two grandchild parts, the child part number (U5) is composed of three grandchild parts, and the child part number (U6) is composed of eighteen grandchild parts. U7) is composed of one grandchild product number. And child part number (U
The two grandchild product numbers (HHH004, HHH4
75) and one grandchild part number (G
99000) and all the grandchild part numbers included in the child part number (U5) and the child part number (U6) are of type 6, and are members to be packed in the small member case.

FIG. 4 shows only the members (members of type 6) to be packed in the small member case from the member configuration data shown in FIG. 3, and stores the packing information in the packing information database 3b of the database server 3. This shows the contents registered as data. That is, a unique packing case number indicating the contents of the packing, and a packing member number indicating the combination of the members to be packed and data on the number of packing members are registered. Here, (% 1
0010) is registered, the grandchild part number of the member extracted from the member configuration data shown in FIG. 3 is registered as the packaging member part number, and the quantity corresponding to the grandchild part number is registered as the packing member quantity as it is. In addition, the next packing case part number (% 10020) is developed at the member level in the same manner as another order, and only the members to be packed in the small member case are extracted from the developed members, and the database server 3
3 shows the contents registered as packing information data in the packing information database 3b. Packing information database 3b
Each time an order is received from the order input terminal 1, the packing information data having the contents shown in FIG. 4 (packing information data for each packing case part number) is sequentially registered by performing the processing described below. .

Next, a process of registering packing information data in the packing instruction system having the above configuration will be described with reference to a flowchart shown in FIG.

When the order from the order input terminal 1 is received by the order entry device 2, the production instruction device 4 receives the received order based on the member configuration data registered in the member configuration database 3a of the database server 3. 3 (step S1), extracting data on the part number and quantity of small members (members whose type is 6) to be packed from the expanded members, and instructing packing. To the device 5 (step S
2).

The packing instruction device 5 sequentially compares the data on the extracted part numbers and quantities of the small parts with the data on the part numbers and quantities of the small parts read for each packing case part from the packing information database 3b of the database server 3. Then, data (packing case part number) having the same part number and quantity is searched (step S3). here,
In the comparison procedure, first, it is determined whether or not the extracted part number of the small member matches the part number of the small member read from the packing information database 3b (step S4). It is determined whether both part numbers match (step S5). If they match, it is next determined whether the number of members used for each part number all match (step S6).

The packing instruction device 5 repeats the loop in which the determination in steps S4 to S6 is No for all packing case numbers registered in the packing information database 3b (step S7).

When the loop in which the determination in steps S4 to S6 is No is repeatedly performed for all packing case part numbers, the part numbers and quantities of the small members extracted this time are made to correspond to the newly determined packing case part numbers. Then, it is registered in the packing information database 3b of the database server 3 (step S8). On the other hand, steps S4 to S
If the determination in step 6 is Yes (that is, if the data match in all cases), the part number and quantity of the matching accessory parts and the same packing case part number indicating the combination thereof are stored in the packing information database of the database server 3. 3b
(Step S9).

By performing such a process each time an order is received from the order input terminal 1, an initially empty packing information database 3b stores a unique packing case part number indicating the contents of the packing and a member to be packed. The data on the packing material number and the packing material quantity indicating the combination of
Only the received order will be registered. Thereby, the combination of the members to be packed can be represented by one packing case part number, and the combination having the same part number and quantity of the members can be represented by the same packing case part number.

On the other hand, before the shipment of the received order (for example, three days before), the packing instruction system counts the packing case part numbers registered in the packing information database 3b, and calculates the required amount for each packing case part number. The printer 5a outputs (prints out) a small box packing instruction (see FIG. 6) from the printer 5a, and outputs (prints out) a component list for each packing case part number (see FIG. 7). The accessory box packing instruction is represented by information of a packing case part number and the case quantity, and the parts list (packing contents) is represented by information of a member part number, a member part name, and a quantity.

Therefore, the field worker determines the packing case part number to be packed from the accessory box packing instruction shown in FIG.
The necessary members are picked and packed while looking at the member list shown in FIG. In this example, for the case number (% 10010) of the packing case, two small member cases in which the members shown in FIG. 7 are packed are made.

As described above, according to the packing instruction system of the present invention, the accessory box packing instruction shown in FIG. 6 and the parts list shown in FIG. 7 can be output, so that accessory member cases made of the same member are packed together. Therefore, even if the orders are different, if the packing case part numbers are the same, diversion is possible. Further, since the database server 3 itself is automatically updated during the processing, no additional work such as maintenance occurs.

FIG. 8 is a schematic configuration diagram showing another embodiment of the packing instruction system of the present invention. In the present embodiment, the database server 3 is provided with a new packing case part number master 33c for registering a date.
The other configuration is the same as that shown in FIG. 1, and the same devices are denoted by the same reference numerals here.

As shown in FIG. 9, the packing case part number master 33 includes a packing case part number column and a date column.
In the date field, the date of last use is registered.

Next, a procedure for registering a date in the date column of the packing case part number master 33 will be described with reference to a flowchart shown in FIG.

In the processing for registering the date, the processing from step S11 to step S17 is the same as the processing from step S1 to step S7 of the packaging information data registration processing shown in FIG. Then, step S14
If there is any data that does not match in the determination in step S17, the packing case part number that is newly determined and is the same as the packing case part number registered in the packing information database 3b is displayed together with the processing date. A new registration is made in the master 33 (step S18). on the other hand,
If the data match in all the determinations from step S14 to step S17, the date information of the matching packing case part number already registered in the packing case part number master 33 is updated to the processing execution date (step S
19).

By performing such processing every time an order is received from the order input terminal 1, the packaging case part number and the packaging case part number are finally used in the initially empty packaging case part number master 3c. Dates are registered sequentially.

Next, a processing procedure for deleting data relating to a packing case part number from the packing information database 3b of the database server 3 will be described with reference to a flowchart shown in FIG.

This processing procedure is performed at regular intervals (for example, once a month). In the present embodiment, the data to be deleted is date data six months or more before the present. Data that has not been used for more than 6 months
This is because it can be determined that the order is not used much and the repeatability is small.

That is, when the delete operation starts,
The production instruction device 4 extracts date data six months or more before the current date from the packing case number master 3c of the database server 3 (steps S21 and S22), and corresponds to the extracted date data and the date data. The packing case part number is deleted from the packing case part number master 3c (step S23). Further, the production instruction device 4 searches the packing information database 3b of the database server 3 and deletes all data relating to the same packing case part number as deleted from the packing case part number master 3c from the packing information database 3b (step). S24). When such processing is performed for all packing case part numbers registered in the packing case part number master 3c (step S2).
5), end the processing.

If this deletion process is automatically executed on the first day of every month using a program execution scheduling function provided in the production instruction device 4 in advance, Only information that has never been used in the past six months can be deleted.

FIG. 12 is a schematic configuration diagram showing still another embodiment of the packing instruction system of the present invention. In the present embodiment, the database server 3 is provided with a packaging case part number master 33d that can register an arbitrarily determined product name for the packaging case part number. Other configurations are shown in FIG.
The same devices are denoted by the same reference numerals here.

As shown in FIG. 13, the packing case part number master 33d includes a packing case part number column and a product name column, and the product name column is initially registered blank.

Next, a procedure for registering the packing case part number and the product name in the packing case part number master 3d will be described.

This registration procedure is executed when there is at least one data that does not match in the determination in steps S4 to S6 of the packaging information data registration processing shown in FIG. That is, when there is even one data that does not match in the determinations in steps S4 to S6,
The production instruction device 4 newly registers a packaging case part number, which is the same as the packaging case part number newly determined and registered in the packaging information database 3b, together with the blanked product name in the packaging case part number master 3d. In FIG. 13, a packaging case part number (% 10012) and a product name (blank) are newly registered. This item name field can be freely edited by an operator or an operator, and an arbitrarily determined item name is registered. The product name is a small part + material case that packs similar members,
Create and register so that they are adjacent when sorted.

Here, the rule for determining the product name is determined based on the properties of the packaging member of the bathroom unit. The packing member is determined by the product part and the optional part as described above, but the product part determines 80% of the packing member, and the optional part determines the remaining 20%. In addition, there is another classification called product type, and the product division belongs to one of the product types. In one product type, the members packed in the product section are almost the same. Based on this property,
The product name of the packaging case part number is created according to a rule that a character string representing a product type is followed by a three-digit number arbitrarily determined by an operator or an operator.

FIG. 14 shows a screen image for registering such a product name. The selection box of the packing case part number is displayed on the upper left of the screen, the registration screen of the packing case product name (the product name is input from the keyboard) is displayed below it, and the material list of the selected packing case part number is displayed on the right side of the screen Is displayed. The product name registration can be arbitrarily determined by the operator or the operator, and can be changed at any time. Also,
Even if you do not register, you will not interfere with packing work.

FIG. 15 shows an example of a packing instruction in which a product name is blank, and FIG. 16 shows an example of a packing instruction in a case where an operator or an operator registers a product name. The packing instruction shown in FIG. 15 is an example of a case where the sorting method is such that the product name is printed from the blank data. In the item name column, a newly determined (registered) item name is described.

When issuing a packing instruction,
It is also possible to sort using not only the packing case part number but also the part name as a key.

[0049]

According to the first aspect of the present invention, there is provided a packing instruction system for a single order constituted by a combination of one product consisting of a main part group and one or more optional parts consisting of sub-parts. Is extracted to the component level as component configuration data, extracting means for extracting small members to be packed from the expanded members, and the packaging case part number and the number of small components to be packed. A registration means for registering in the database in correspondence with the above, and a packing instruction output means for summing up the packing case part numbers registered in the database and outputting a packing instruction indicating the required amount for each part number and a component list for each packing case part number The registration means stores, for an arbitrary order, a database of the same combination as the item number and the quantity of the small member extracted by the extraction means. And al search, if there is a combination matching registers the same packing case part and its combinations in the database, if there is no combination that matches is configured so as to register the packing case part which is newly determined in the database. Thus, the small member cases for packing the same member can be packed together, so that the workability and productivity can be improved. In addition, since the packed small member case is directly linked to the order, even if the delivery date is changed or canceled after packing, it can be easily diverted to another order. In addition, if spare parts cases of a packing case part number that are often shipped are prepared when the work is free, etc., it is possible to prepare for a time when shipment is concentrated, so that packing work can be leveled. .

The packing instruction system according to a second aspect of the present invention is a packing case part number master for registering a packing case part number registered in a database in association with date data when the packing case part number was used. And a deletion means for deleting information on a packaging case part number that has not been used within a certain period from the database based on the date data registered in the packaging case part number master. As a result, the amount of packing information data registered in the database does not increase more than necessary, and the processing time for expanding the order and determining the packing case part number can be maintained at the expected level.

The packing instruction system according to a third aspect of the present invention includes a packing case part number master capable of registering an arbitrarily determined product name with respect to the packing case part number. Since the configuration is such that the product name registered in the master is displayed and output in the packing instruction, it is not necessary to determine the product name from the packing instruction, and it is possible to prevent a packaging error due to a determination error.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram of an entire system from an order entry to a small component packing instruction system according to the present invention.

FIG. 2 is a diagram illustrating an example of a received order.

FIG. 3 is a diagram showing a state in which the order illustrated in FIG. 2 is developed to a member level based on member configuration data.

FIG. 4 is a diagram showing contents registered in a packing information database by extracting only members to be packed in a small member case from the member configuration data shown in FIG. 3;

FIG. 5 is a flowchart illustrating a registration process of packing information data in the packing instruction system of the present invention.

FIG. 6 is a diagram showing an example of a packing instruction.

FIG. 7 is a diagram showing an example of a parts list corresponding to one packing case part number.

FIG. 8 is a schematic configuration diagram showing another embodiment of the packing instruction system of the present invention.

FIG. 9 is a diagram showing the contents of a packaging case part number master.

FIG. 10 is a flowchart showing a processing procedure for registering a date in a date column of a packing case part number master.

FIG. 11 is a flowchart showing a processing procedure for deleting data relating to a packing case part number from a packing information database of a database server.

FIG. 12 is a schematic configuration diagram showing still another embodiment of the packing instruction system of the present invention.

FIG. 13 is a diagram showing the contents of a packaging case part number master.

FIG. 14 is a diagram showing an example of a screen image for registering a product name.

FIG. 15 is a diagram illustrating an example of a packing instruction sheet in which a product name is blank.

FIG. 16 is a diagram illustrating an example of a packing instruction when an operator or an operator registers a product name;

FIG. 17 is an explanatory diagram showing components of a bathroom unit and shipping modes.

FIG. 18 is an explanatory diagram showing an example of an order.

19A is a diagram showing an option pattern of a product Z shipped during a certain month, and FIG. 19B is a diagram showing an option pattern of a product Z shipped on a certain day.

FIG. 20 is a diagram showing an example of a conventional packing instruction sheet.

[Explanation of symbols]

 3 Database Server 3a Material Configuration Database 3b Packing Information Database 3c, 3d Packing Case Part Number Master 4 Production Instruction Device 5 Packing Instruction Device 5a Printer

Claims (3)

[Claims] 1. A product comprising a group of main parts,
A member expanding means for expanding one order composed of a combination of one or a plurality of optional parts composed of sub-parts to a member level as member configuration data, and a small member to be packed from among the expanded members Extraction means for extracting the number of small parts to be packed, registration means for registering the part number and quantity of the small parts to be packed with the packing case part number in the database, and counting the packing case part numbers registered in the database for each packing case part number And a packing instruction output means for outputting a packing instruction indicating a required amount of the packing material and a list of parts for each packing case part number, wherein the registration means sets an article number of the small member extracted by the extracting means for an arbitrary order. And search the database for the same combination as the quantity, and if there is a matching combination, A packaging instruction system, wherein a packaging case part number is registered in the database, and if there is no matching combination, a newly determined packaging case part number is registered in the database. 2. A packaging case part number registered in the database and registered in association with date data when the packaging case part number is used, and date data registered in the packaging case part number master 2. The packing instruction system according to claim 1, further comprising a deletion unit configured to delete, from the database, information on a packing case part number that has not been used within a predetermined period based on the information. 3. A packing case part number master capable of registering a part number arbitrarily determined for the packing case part number, wherein the packing instruction output means displays the part name registered in the packing case part number in a packing instruction sheet. The packing instruction system according to claim 1, wherein the packing instruction system is configured to output the package instruction.