JP2001005511A - Delivery unit inventory control system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To perform a necessary quantity calculating and a stock reserving process corresponding to the purpose of use by generating and storing stock data, calculating delivery actual result data from delivery instruction data and registering the delivery actual result data in a storage device, and generating and displaying a stock consumption transition table on a display device. SOLUTION: A warehousing process part 2 adds information needed for a subsequent process to an article to be delivered based on a delivering data and then stores the article as a stock in stock data 3. A net necessary quantity calculation part 9 calculates the net necessary quantity 10 of constitution members needed by manufacture numbers. A delivery process part 14 stores the result of delivery as actual result data in delivery actual result data 15 on the basis of delivery indication data 12. A delivery actual result analysis part 16 expands the delivery actual result data 15 stored with items such as the manufacture numbers, etc., into a table which has stock numbers and article numbers on the longitudinal axis and warehousing and delivery dates on the lateral axis, and manufacture numbers and delivery quantities are calculated in a table and displayed as a stock display transition table 17 on a display device such as a CRT.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a delivery unit inventory management system, and in particular, calculates the required amount of a member or a semi-finished product whose use is limited by a purchaser, and uses the result to determine the purchase unit and delivery unit. The present invention relates to a delivery unit inventory management system for managing inventory.

[0002]

2. Description of the Related Art A conventional inventory management system manages stocks of parts and semi-finished products whose use is limited by suppliers, rather than managing the stocks by suppliers. Items that have the same functions as semi-finished products but have different uses are managed as separate items, and a bill of materials that represents the product configuration for each use is created to manage each item.

[0003]

In the above-mentioned conventional inventory management system, since the management is performed for each item, the number of items to be managed increases, and a parts table corresponding to the type of use is required. Therefore, for example, even when only one point is changed in a member / part constituting a product, a plurality of parts tables are corrected. For this reason, there is a drawback that a large amount of labor is required for the work of correcting the parts table, and the quality of the parts table is liable to be deteriorated due to a transcription error at the time of correction.

[0004] In addition, since inventory management is performed for each item, there is a drawback in that it is difficult to link and manage purchase information and inventory information attached to the purchase of a member or a semi-finished product. Specifically, when stocks of purchased materials such as parts and semi-finished products are stored and managed as inventory, it is necessary to periodically inspect materials that have passed a certain period from the time of purchase in order to maintain the quality of purchased materials. However, it is difficult to identify purchased materials that require periodic inspections because inventory is managed for multiple purchase lots with different purchase times as one item and the inventory is consumed at different times. Met. In addition, it is difficult to track the status of imported materials subject to preferential tariffs when they are required to report the consumption history and usage, etc., because they are divided into items and managed.

An object of the present invention is to provide an inventory management system that performs a required amount calculation and a stock allocation process according to a use without creating a different parts table for each use.

Another object of the present invention is to provide an inventory management system capable of easily tracking the consumption history of inventory linked to a purchase unit.

[0007]

A delivery unit inventory management system according to the present invention is based on delivery data in a delivery data storage device which describes information on a delivery article to be purchased and delivered as a single item or a plurality of items collectively. Receiving processing means for creating a stock data and storing it in a stock data storage device after giving a use category indicating conditions relating to the use of the delivered property and a stock number uniquely assigned to each delivered property unit; Using the data and the project information indicating order-related information stored in the project information storage device, a required allocation calculation is performed for each order item, and delivery instruction data or missing item data is created. Alternatively, a required quantity calculating means stored in the stockout data storage device, and a delivery result data calculated based on the delivery instruction data to obtain a delivery result data. Outgoing processing means for registering in a storage device, and outgoing performance analyzing means for creating an inventory consumption transition table from the inventory data, the outgoing instruction data, and the outgoing performance data and displaying it on a display device, I do.

[0008] Further, the required quantity calculation means creates a production number / stock number correspondence table showing a correspondence between a stock number and a production number matching its use using the stock data and the project information. Use determination processing means stored in a number / stock number correspondence table storage device, and production plan information stored in a production plan information storage device which holds schedules, production quantities, and serial numbers of devices to be manufactured, A net requirement calculating means for calculating a net requirement using a parts table stored in a parts table storage device indicating a member / part configuration and storing the calculated net requirement in the net requirement storage device; Using the inventory number correspondence table and the net required quantity, a required allocation calculation is performed to create the delivery instruction data or the missing item data, and the respective data are stored in the delivery instruction data storage device or A required allowance calculating means for storing the serial shortage data storage device, characterized in that it is composed of.

Further, the inventory data stored in the inventory data storage device includes a use category indicating a condition relating to a use of a delivered property, a stock number uniquely assigned to each delivered property, an item number, and a number of deliveries. , A stock quantity, a delivery date, and a purchaser.

The serial number / inventory number correspondence table stored in the serial number / inventory number correspondence table storage device may include the same inventory number as the inventory data stored in the inventory data storage device and the corresponding inventory number. And a serial number that matches the application.

[0011] Further, the project information indicating order related information stored in the project information storage device includes a project number, a serial number, manufacturing case information, and the inventory data stored in the inventory data storage device. And use categories having the same contents.

The production plan information stored in the production plan information storage device is characterized by comprising a product name, a serial number, a production quantity, and a production schedule.

Further, the parts table stored in the parts table storage device has the same product name as the production plan information stored in the production plan information storage device, an item number indicating a parts configuration, and the item list. And the number of units used for the numbered component.

Further, the net required quantity stored in the net required quantity storage device comprises a serial number, an item number indicating a component configuration, and a required number of parts of the item number. I do.

Further, the delivery instruction data registered in the delivery instruction data storage device includes a serial number, a stock number identical to the stock number stored in the inventory data storage device, and a storage number in the inventory data storage device. It is characterized by comprising the same item number as the stored item number and the number of allocations.

Further, the missing item data stored in the missing item data storage device comprises a serial number, an item number, and the number of missing items.

Further, the delivery result data registered in the delivery result data storage device includes a production number, a stock number identical to the stock number stored in the stock data storage device, and an item number indicating a delivery item. And the number of issued parts of the item number and the issued date.

Further, the inventory consumption transition table displayed on the display device includes the same inventory number as the inventory number stored in the inventory data storage device and the item number stored in the inventory data storage device. It is a table or a graph composed of the same item number, storage / delivery date, the number of stocks for each storage / delivery date, and the serial number that consumed the stock.

Furthermore, each of the above means is executed by a program for causing a computer to function.

[0020]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing one embodiment of a delivery unit inventory management system according to the present invention.

In this embodiment shown in FIG. 1, a use condition indicating a condition of use of a delivered property is described based on delivery data 1 which describes information on a delivered property purchased and delivered as a single item or a plurality of items collectively. A stock number that uniquely assigns a classification and a stock number to each delivery property unit, and a stock processing unit 2 that creates stock data 3, and uses the stock data 3 and project information 4 to match the stock number and its use Application determination processing unit 5 that creates a serial number / stock number correspondence table 6 indicating the correspondence with the serial numbers to be manufactured, production plan information 7 that holds the schedule, the production quantity, and the serial number of the production target device, and the production target device , A net requirement calculation unit 9 for calculating a net requirement 10 using the parts table 8 showing the member / part configuration, and the inventory data 3 and the serial number / stock number correspondence table 6 and the net requirement 1
A required allocation calculation unit 11 that performs a required allocation calculation by using 0 to create a delivery instruction data 12 or a missing item data 13;
The system includes an outgoing processing unit 14 that registers the outgoing performance data 15 based on the outgoing instruction data 12, and an outgoing performance analyzing unit 16 that creates a stock consumption transition table 17 from the inventory data 3, the outgoing instruction data 12 and the outgoing actual data 15. ing.

The required amount calculation is performed by a required amount calculating unit 20 including a use determination processing unit 5, a net required amount calculating unit 9, and a required allocation calculating unit 11.

Further, the above-mentioned storage processing unit 2, use determination processing unit 5, net required amount calculation unit 9, and required allocation calculation unit 11
Each of the delivery processing unit 14 and the delivery performance analysis unit 16
It is realized by a program executed in the computer system.

Next, the operation of the present embodiment will be described.

Based on the delivery data 1, the storage processing unit 2 adds information required for the subsequent processing to the delivered property, and stores the delivered property as inventory in the inventory data 3. The stock storage unit, that is, the stock management unit is not the item unit but the delivery property unit, and the stock number is assigned to the delivery property unit.
When a plurality of items are delivered at one time, a plurality of items are linked to one stock number. As basic information of the stock number, a delivery date, a purchaser, and a use category that limits the use of the delivered property are given. The use classification can be divided into, for example, production limitation for overseas, production limitation for Japan, limitation for a specific production number, no use limitation (no use classification is assigned), and the like. Used to associate with In the case of the limitation for a specific serial number, the correspondence between the serial number and the stock number is also registered directly in the serial number / stock number correspondence table 6 together with the application classification. In addition, the usage classification is not limited to the above classification, and the content can be added, changed, or deleted.
As the detailed information of the stock number, an item number for uniquely specifying the item and the number of deliveries for each item are held.

In the present embodiment, the required amount is calculated in a required amount calculating unit 20 comprising a use determination processing unit 5, a net required amount calculating unit 9, and a required allocation calculating unit 11.

The use determination processing unit 5 associates the stock with the usable serial number with respect to the stock whose use is limited,
A production number / stock number correspondence table 6 is created. The project information 4 used by the use determination processing unit 5 is information in which a plurality of manufacturing cases are bundled in order case units. Holds production case information. The use category set as the auxiliary information of the project number is the same as the use category assigned as the basic information of the stock number. The processing content of the usage determination processing unit 5 matches the usage category of the project information 4 with the usage category of the inventory data 3, and when they match, corresponds to the serial number held as the detailed information of the project information 4. The stock number is registered in the manufacturing number / stock number correspondence table 6.

The net requirement calculation unit 9 includes a production plan information 7 in which a schedule, a production quantity, and a production number of the device for which the requirement is to be calculated are registered, and a parts table 8 indicating a member / part configuration of the device. Is used to calculate the net required quantity 10 of the component required for each serial number.

The required allocation calculation unit 11 first calculates allocation of inventory having a limited usage category, and then calculates allocation of inventory having no usage limitation. In the allocation calculation of inventory limited to the use category, the inventory data 3, the serial number / stock number correspondence table 6 and the net required amount 10 are used to allocate the calculated net requirements from stocks which may be issued. The available quantity is allocated, stored in the delivery instruction data 12, and the quantity instructed to be removed is subtracted from the corresponding inventory data 3. In the allocation calculation of inventory without limitation of use, without using the serial number / inventory number correspondence table 6, only the inventory data 3 and the net required amount 10 are used, and the available amount is simply obtained by matching the items. Allotment is stored in the delivery instruction data 12, and the quantity instructed to leave is subtracted from the corresponding inventory data 3.

The retrieval processing section 14 stores the result of the retrieval based on the retrieval instruction data 12 in the retrieval result data 15 as the result data.

The delivery performance analysis unit 16 stores the delivery performance data 15 in which items such as the production number, stock number, delivery item, delivery quantity, and delivery date are stored as one record. Expand into a table with entry and exit dates,
The production number and the delivery quantity are calculated in the table and displayed as a stock consumption transition table 17 on a display device such as a CRT. This display clarifies the transition of consumption of the stock in units of the stock number, that is, the use destination where the stock is used.

Next, the operation of the present embodiment will be described in more detail with reference to FIG. 1 and FIGS.

FIG. 2 is a diagram schematically showing an example of a parts table prepared for specifically explaining the operation of the present embodiment.

The apparatus P is constituted by using 14 parts of the item number a and three parts of the item number b. Also,
The device Q is configured by using one part of the item number b and two parts of the item number c. Here, the part of the item number c further includes 10 parts of the item number d and 5 parts of the item number e. It is configured using

First, assuming that the parts having the item numbers a, b, c, d, and e are purchased from the supplier, this data is input to the system as the delivery data 1 in FIG.

The storage processing unit 2 of FIG. 1 assigns a stock number and a use category to the delivery data 1 and stores the delivery data 1 in the stock data 3. FIG. 3 shows an example of the contents of the inventory data.

In FIG. 3, a delivery number A is assigned to a delivery case A as a delivery property, and a usage category of production limited to overseas is assigned as basic information, and a part of an item number a is provided as detailed information of the inventory number A. Are delivered, five item numbers b and fifteen item numbers c are delivered. At the same time, the same number as the number of deliveries is given to the number of stocks, and necessary information such as the delivery date and purchaser is also given.

If the delivery case B is limited to a specific production number X, the stock number A and the production number X corresponding to the delivery case B are also directly registered in the production number / stock number correspondence table 6. FIG. 4 shows an example of the contents of the serial number / stock number correspondence table at this time.

When the delivery case C is not limited to the use, the use classification is not assigned, the stock number c is assigned, and stored in the stock data 3 together with the basic information.

The use judging processing section 5 shown in FIG. 1 compares and compares the use class held as the basic information of the inventory data 3 with the use class preset for each serial number in the detailed information of the project information 4. And associates the stock number and production number that match the application category with the production number /
It is registered in the stock number correspondence table 6. At this time, the stock data 3 for which the usage classification is not set is excluded from comparison and collation. FIG. 5 shows an example of the contents of the project information.

In FIG. 5, the order number of the project number α is associated with the inventory number A (FIG. 3) of the inventory data 3 because the production number is Y and the use category is limited to overseas production. It is registered in the / stock number correspondence table 6. FIG. 6 again shows an example of the contents of the serial number / stock number correspondence table at this time. The stock number c (FIG. 3) in the stock data 3 having no use limitation is not registered in the serial number / stock number correspondence table 6.

The net required quantity calculation unit 9 in FIG. 1 uses the production plan information 7 and the parts table 8 to multiply the production quantity of the apparatus by the number of units used for the parts and components, and to use the parts and materials used for each production number. The net required quantity of the component is calculated and registered in the net required quantity 10.

FIG. 7 shows an example of the contents of the production plan information. FIG. 7 shows that one device is manufactured from June 4, 1999, with the product name of the device P being the serial number Y. FIG. 8 shows an example of the contents of the parts table. FIG. 8 shows FIG.
In the schematic diagram of the parts table shown in FIG. 1, only the part of the device P is taken out, and the device P is manufactured using 14 parts of the item number a and three parts of the item number b. Which indicates that.

Using the information of FIGS. 7 and 8, the net requirement calculator 9 calculates and creates the net requirement 10. FIG.
An example of the content of the net required amount obtained as a result of this calculation is shown below. FIG. 9 shows that the item number a is 14
And three item numbers b are required.

In the required allocation calculating section 11 in FIG. 1, first, allocation calculation is performed on the data registered in the serial number / stock number correspondence table 6. In the specific example of the present embodiment, the serial number Y, the used member a,
Referring to the serial number / stock number correspondence table 6 (FIG. 6), the required number of 14 items is related to the stock number a. Ten pieces are allocated from the number a. Next, allocation calculation is performed for the inventory whose usage category of the inventory data 3 is not limited, and the remaining required allocation is performed, and the required portion that cannot be allocated is registered in the stockout data 13. In the stock data of FIG. 3, since there are three item numbers a in the stock number c with no usage limitation, three items are assigned as the item number a of the production number Y, and the remaining one is registered in the stockout data 13. You. These allocation results are based on the delivery instruction data 12 and the shortage data 1
3 is registered. FIG. 10 is a diagram showing an example of the contents of the delivery instruction data in FIG. 10, showing the allocation result in a specific example of the present embodiment.
11 and FIG. 11 show examples of the contents of the missing item data. Further, the allocation result is subtracted from the stock quantity of the stock data 3.

The delivery processing section 14 in FIG. 1 registers the actual delivery processing result in the delivery result data 15. As a result of performing the allocation, that is, the stock removal operation based on the shipping instruction of the shipping instruction data 12, the necessary allocation calculating unit 1 may be lost due to the loss of the inventory.
If the calculation result of No. 1 does not match the actual stock quantity and the payout cannot be made, the correction is made here, and the data for the unpayable is registered in the stockout data 13. The data actually paid out is registered in the delivery result data 15. Looking at an example of payout for the serial number Y in the specific example of the present embodiment,
As shown in FIG. 12, which shows an example of the delivery result data, the production number Y is changed from the stock number a to the item number a.
, Three item numbers a from stock number c, and three item numbers b from stock number a are registered.

The delivery performance analysis unit 16 of FIG. 1 uses the delivery performance data 15 which is the delivery work record for each production number and for each item number, and records the inventory consumption history as an inventory consumption transition table 17 in time series for each production number. The calculated values are displayed on a display such as a CRT in a table format or a graph format. FIG. 13 shows an example of the inventory consumption transition table. In the table of FIG. 13, the transition of the consumption status of the stock by the stock number and the item number is shown by a line graph, and the production number Y that consumed the stock is displayed.

[0049]

As described above, the delivery unit inventory management system of the present invention, even when dealing with purchased materials with limited uses, stores information about the use in the purchase unit of the material.
Because it is stored as data for each delivery unit, there is no need to create a different parts list for each use, and there is no need to assign different item numbers for each use to the same item, and to create and maintain a parts list This has the effect of reducing the number of steps and improving the quality of the parts table.

Further, since inventory can be managed in purchase units and delivery units, there is an effect that tracing of inventory consumption history in delivery units and management of inventory storage expiration can be easily performed.

[Brief description of the drawings]

FIG. 1 is a block diagram showing one embodiment of a delivery unit inventory management system of the present invention.

FIG. 2 is a diagram schematically illustrating an example of a parts table prepared for specifically explaining the operation of the present embodiment.

FIG. 3 is a diagram showing an example of the contents of inventory data.

FIG. 4 is a diagram showing an example of the contents of a serial number / stock number correspondence table.

FIG. 5 is a diagram showing an example of the contents of project information.

FIG. 6 is a diagram again showing an example of the contents of a manufacturing number / stock number correspondence table.

FIG. 7 is a diagram showing an example of the content of production plan information.

FIG. 8 is a diagram showing an example of the contents of a parts table.

FIG. 9 is a diagram showing an example of the content of a net required amount.

FIG. 10 is a diagram showing an example of the contents of the delivery instruction data.

FIG. 11 is a diagram showing an example of the content of missing item data.

FIG. 12 is a diagram showing an example of the contents of delivery result data.

FIG. 13 is a diagram showing an example of an inventory consumption transition table.

[Explanation of symbols]

 1 Delivery Data 2 Receiving Processing Unit 3 Inventory Data 4 Project Information 5 Usage Judgment Processing Unit 6 Serial Number / Stock Number Correlation Table 7 Production Planning Information 8 Parts List 9 Net Requirement Calculation Unit 10 Net Requirement Calculation 11 Required Reserve Calculation Unit 12 Outgoing instruction data 13 Out of stock data 14 Outgoing processing section 15 Outgoing actual data 16 Outgoing actual analysis section 17 Inventory consumption transition table 20 Required amount calculating section

Claims (13)

[Claims] [Claim 1] Based on delivery data of a delivery data storage device that describes information on a delivered property to be purchased and delivered as a single item or a plurality of items collectively, a use category indicating conditions regarding use of the delivered property, and delivery. Warehousing processing means for creating a stock data after adding a stock number uniquely assigned to each property unit and storing the stock data in a stock data storage device, and received order related information stored in the stock data and a project information storage device A required amount calculation means for performing a required allocation calculation for each order case using the project information indicating the order information, creating delivery instruction data or missing item data, and storing them in the delivery instruction data storage device or the missing item data storage device, respectively. Outgoing processing means for calculating outgoing performance data based on the outgoing delivery instruction data and registering it in the outgoing performance data storage device; A delivery result analyzing means for creating a stock consumption transition table from the delivery instruction data and the delivery result data and displaying the table on a display device. 2. A manufacturing number / stock number correspondence table showing a correspondence between a stock number and a manufacturing number matching its use using the stock data and the project information. Use determination processing means stored in a number / stock number correspondence table storage device, and production plan information stored in a production plan information storage device which holds schedules, production quantities, and serial numbers of devices to be manufactured, A net requirement calculating means for calculating a net requirement using a parts table stored in a parts table storage device indicating a member / part configuration and storing the calculated net requirement in the net requirement storage device; Using the inventory number correspondence table and the net required quantity, a required allocation calculation is performed to create the delivery instruction data or the missing item data, and the data is stored in the delivery instruction data storage device or the missing item data, respectively. 2. The delivery unit inventory management system according to claim 1, further comprising: a required allocation calculating unit that stores the product data in a product data storage device. 3. The inventory data stored in the inventory data storage device includes a use category indicating a condition relating to a use of a delivered property, a stock number uniquely assigned to each delivered property, an item number, and the number of deliveries. 3. The delivery unit inventory management system according to claim 1, wherein the delivery unit inventory management system comprises information indicating a stock quantity, a delivery date, and a purchaser. 4. The serial number / stock number correspondence table stored in the serial number / stock number correspondence table storage device includes a stock number identical to the stock data stored in the inventory data storage device, and The delivery unit inventory management system according to any one of claims 1 to 3, wherein the delivery unit inventory management system is constituted by a serial number matching a use. 5. The project information indicating order item related information stored in the project information storage device,
5. The apparatus according to claim 1, comprising a project number, a serial number, manufacturing case information, and a use category having the same contents as the inventory data stored in the inventory data storage device. Delivery unit inventory management system described in. 6. The production plan information stored in the production plan information storage device includes a product name, a production number, a production quantity, and a production schedule. Item 5. The delivery unit inventory management system according to any one of item 5. 7. The parts table stored in the parts table storage device includes the same product name as the production plan information stored in the production plan information storage device, an item number indicating a parts configuration, and the item The delivery unit inventory management system according to any one of claims 1 to 6, wherein the delivery unit inventory management system is configured by: 8. The net requirement stored in the net requirement storage device comprises a serial number, an item number indicating a component configuration, and a required number of parts of the item number. The delivery unit stock management system according to any one of claims 1 to 7, wherein 9. The delivery instruction data registered in the delivery instruction data storage device includes a production number, a stock number identical to the stock number stored in the inventory data storage device, and a storage number in the inventory data storage device. The delivery unit inventory management system according to any one of claims 1 to 8, comprising: an item number that is the same as the stored item number; and a reserved number. 10. The missing item data stored in the missing item data storage device includes a serial number, an item number, and the number of missing items.
Delivery unit inventory management system described in any of the above. 11. The delivery result data registered in the delivery result data storage device includes a production number, the same stock number as the stock number stored in the stock data storage device, and an item number indicating a delivery item. The delivery unit inventory management system according to any one of claims 1 to 10, wherein the delivery unit inventory management system comprises: a delivery number of a part having the item number; and a delivery date. 12. The inventory consumption transition table displayed on the display device includes the same inventory number as the inventory number stored in the inventory data storage device and the item number stored in the inventory data storage device. 12. A table or a graph comprising the same item numbers as those described above, the entry / exit date, the number of stocks for each entry / exit date, and the production number that consumed the inventory. Delivery unit inventory management system described in any of the above. 13. A use category indicating conditions related to the use of a delivered property based on delivery data of a delivered data storage device that describes information on a delivered property purchased and delivered as a single item or a plurality of items collectively, and a delivery. Warehousing processing means for creating a stock data after adding a stock number uniquely assigned to each property unit and storing the stock data in a stock data storage device, and received order related information stored in the stock data and a project information storage device A required amount calculation means for performing a required allocation calculation for each order case using the project information indicating the order information, creating delivery instruction data or missing item data, and storing them in the delivery instruction data storage device or the missing item data storage device, respectively. A delivery processing means for calculating delivery performance data based on the delivery instruction data and registering the delivery performance data in a delivery performance data storage device; And a delivery result analysis means for creating a stock consumption transition table from the delivery instruction data and the delivery result data and displaying the table on a display device, and a program for causing a computer to function.