JP2009175875A - Management system for delivery from warehouse, and management method for delivery from warehouse - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically calculate delivery quantity of shipping in the consideration of the forward delivery remainders of materials, and to drastically saving man-hours needed for the ordering processing of materials. <P>SOLUTION: A terminal 2 for claiming materials transmits shipping claim data D1 showing the article names of materials as the object of ordering and the quantity of the materials to a server 1. The server 1 acquires the forward delivery remainders of the materials and the units of packaging by referring to the list of the forward delivery remainders of the materials recorded in a DB 5, and compares the forward delivery remainders of the materials with the quantity of the materials of the shipping claim data D1, and updates the forward delivery remainders of the materials of the list of the forward delivery remainders by calculating the quantity of shipping from the units of packaging based on the comparison result. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a stock management system and a stock management method applicable to a system for managing stock and stock of forwarded power materials. For details, refer to the list of remaining delivery numbers in the recording unit to obtain the remaining delivery number and packaging unit of the material, compare the remaining delivery number of the material with the quantity of material in the ordering data, and compare the result. By automatically obtaining the delivery quantity in consideration of the forward remaining quantity of the material by obtaining the delivery quantity from the packaging unit of the material based on This makes it possible to save labor in ordering materials.

  Conventionally, for example, a person in charge of a material management department of an electric power company has requested a distribution request slip adjustment by fax or mail to the distribution center every time there is a request for the delivery of materials used for electrical work from a construction sales office. Yes. Based on the request, the person in charge at the distribution center accesses the distribution adjustment system for adjusting the distribution of the material, and confirms the remaining number of materials and the unit of delivery (packing unit). The person in charge at the distribution center adjusts the quantity of materials delivered and reports the survey results to the person in charge of material management at the power company by fax. Upon receiving a report from the person in charge at the distribution center, the person in charge of material management of the electric power company notifies the construction sales office of the result of material adjustment by telephone or fax. Further, if necessary, the person in charge of material management accesses the distribution adjustment system to change the remaining number of materials in advance.

  For example, FIG. 9 is a schematic diagram illustrating a configuration example of the material distribution adjustment support system 200 according to the above-described conventional example. The distribution adjustment support system 200 shown in FIG. 9 is a system that supports adjusting the distribution of materials based on the recorded number of remaining materials and the billing bill for materials. The distribution adjustment support system 200 includes a DB 50, a DB update terminal 53, and a DB reference terminal 54. The DB update terminal 53 is installed in the material management unit 55. The DB reference terminal 54 is installed in the distribution center 56. The terminals 53 and 54 are connected to the DB 50 via the communication line 10 and the communication line network 11.

  In this DB 50, the number of remaining materials in advance is recorded. Here, the remaining number of forward materials is, for example, the number of materials that are distributed by a predetermined unit of packing, and the number of materials that are actually used for construction is subtracted from the number of materials of the distributed unit of packing. Say. For example, when a high pressure retaining insulator having a packing unit of “20” is distributed and actually used in construction, “15” high pressure retaining insulators are used, the remaining number of forwards is “5”. The DB 50 records the remaining number of forward items.

  In this example, the person in charge of the construction sales office 52 shown in FIG. 9 mails a billing request form (designated unit price article) 57 of materials used for electrical work to the person in charge of the material management unit 55. The person in charge of the material management unit 55 faxes the received inventory request form 57 to the person in charge of the distribution center 56 and requests adjustment of the material. The person in charge of the distribution center 56 operates the DB reference terminal 54 to access the DB 50 to check the remaining number of deliveries and the packing unit of the construction sales office where the material is stored. FIG. 10 is a display example of the forward remaining number inquiry / display screen 59 displayed on the monitor 7 of the DB reference terminal 54 after accessing the DB 50. For each item name of the material displayed in the “item name” item 59b of the remaining amount inquiry / display screen 59 shown in FIG. A unit for packing (unloading) the material is displayed in the “packing unit” item 59c. For example, for the product name “high pressure retention insulator”, the remaining number of forwards “18.0” and the packing unit “20.0” are displayed. The person in charge at the distribution center 56, after investigating the remaining number of deliveries, based on the quantity used at the construction sales office at the delivery destination, the remaining number of deliveries, and the packing unit of the warehouse listing, Calculate the remaining number manually.

  For example, the person in charge at the distribution center 56 uses the high-pressure retainer used quantity “27”, the remaining number “18”, and the packing unit “20” of the warehouse item at the construction sales office of the warehouse. Since the remaining number of delivery is “9”, it is manually calculated as “20” of material stock based on the packing unit “20”. In addition, the person in charge at the distribution center 56 subtracts the used quantity “27” from the quantity “38” obtained by adding the remaining number of deliveries “18” and the warehoused quantity “20” to the destination after distribution. Manually calculate the remaining number “11”.

  This calculation result is described in the remarks column of the warehouse delivery form 58 shown in FIG. 11, and the warehouse delivery form 58 is mailed to the person in charge of the material management unit 55. In the warehouse delivery form 58 shown in FIG. 11, the column of “high pressure retention insulator” described in the “item name standard” item corresponds to the above-described example. In addition, examples of the “high-pressure pin insulator 2 type” and “electric wire” are described in the warehouse delivery form 58.

  The person in charge of the material management unit 55 receives the warehouse delivery form 58 mailed from the person in charge of the distribution center 56, and the distribution result written in the warehouse delivery form 58 is sent to the person in charge of the construction sales office 52 by telephone or fax. contact. In addition, when the person in charge of the material management unit 55 changes the number of remaining materials, the person in charge of the material management unit 55 operates the DB update terminal 53 to update the number of remaining materials in the DB 50. In this way, the distribution of materials is adjusted.

  Patent Document 1 relating to such a conventional example discloses an instrument inventory management system. According to this instrument inventory management system, the remaining effective period of the instrument is acquired, and the inventory of the instrument is managed by dividing into the instrument used for the new installation and the instrument used for replacing the defective instrument according to the effective period. Thereby, the instrument with a long effective period of an instrument can be used at the time of new installation.

Japanese Patent Laid-Open No. 2007-4214

  Incidentally, the distribution adjustment support system 200 according to the conventional example has the following problems (1) to (3). (1) Since the warehouse request slip 57 and the warehouse delivery form 58 are exchanged by fax or mail, there is a risk of omission or loss of delivery. (2) The person in charge of the distribution center 56 refers to the forward remaining number inquiry / display screen 59 displayed on the monitor 7 of the DB reference terminal 54 and confirms the forward remaining number and the packing unit of the warehouse item. Because it is necessary, there is a risk of mistaking the remaining number of forwards and the packaging unit. In addition, the person in charge at the distribution center 56 manually calculates the quantity of materials delivered and the number of deliveries after distribution based on the quantity used at the construction sales office at the warehouse destination, the remaining number of deliveries, and the packing unit of the warehouse listing. Since the calculation is performed, there is a risk of causing a calculation error. (3) The person in charge of the material management section 55 notifies the person in charge of the construction sales office 52 by telephone or fax of the distribution result described in the warehouse delivery form 58 mailed from the person in charge of the distribution center 56. It may take time to respond when the person is absent.

  Therefore, the present invention solves such a problem related to the conventional example, makes it possible to automatically calculate a warehouse quantity in consideration of the remaining number of forward materials, and performs an ordering process for the materials. An object of the present invention is to provide an inventory management system and an inventory management method that can greatly save labor.

  In order to solve the above-described problems, in the stock management system according to the present invention, the item name of the material, the packaging unit of the material, and the remaining number of forwarded materials are recorded as a forward remaining number list for each material. A recording unit, an information processing device for obtaining a stocking amount for stocking materials based on the list of remaining remaining in the recording unit, and an ordering process indicating the product name and quantity of materials to be ordered An ordering terminal that transmits data to the information processing device, the information processing device refers to a list of remaining numbers in the recording unit, obtains the number of remaining materials and the packing unit of the material, Compare the remaining number of materials in advance with the quantity of materials in the ordering data, and calculate the unloading quantity from the packaging unit of the materials based on the comparison result, and forward the materials in the list of remaining numbers in the forwarded number The remaining number is updated.

  According to the inventory management system according to the present invention, the product name of the material, the packaging unit of the material, and the remaining number of the forwarded material are recorded in the recording unit as a forward remaining number list for each material. The information processing apparatus obtains a stock quantity for stocking the material based on the remaining number list of the recording unit, and performs a stock management process. The ordering terminal transmits ordering data indicating the name of the material to be ordered and the quantity of the material to the information processing apparatus. In this case, the information processing apparatus refers to the transfer remaining number list in the recording unit, acquires the remaining transfer number of the material and the packing unit, and compares the remaining transfer number of the material with the quantity of the material in the ordering data. Then, based on the comparison result, the storage quantity is obtained from the packaging unit of the material, and the forward remaining number of the material in the forward remaining number list is updated. For example, when the information processing apparatus determines that the remaining number of materials in advance is compared with the quantity of materials in the order remaining data after comparing the number of materials remaining in the list of materials remaining in the list of remaining materials, If the quantity stored is determined from the packing unit, and if it is determined that the remaining number of forward materials is sufficient, the quantity delivered is set to zero. As a result, it is possible to automatically obtain a stock quantity that takes into account the remaining number of materials.

  In order to solve the above-described problems, the inventory management method according to the present invention includes a step of transmitting order data indicating the name of the material to be ordered and the quantity of the material, the name of the material, the packaging unit of the material, and the delivery. Recording a forward remaining number of materials as a forward remaining number list for each material; obtaining a forward remaining number and a packaging unit of the material with reference to the recorded forward remaining number list; The step of receiving the order data is compared with the quantity of the material of the received order data and the acquired remaining number of the material, and based on the comparison result, the material is unloaded from the packaging unit of the material. The method includes a step of obtaining a quantity, and a step of updating a remaining number of materials in the list of remaining number of forwards after obtaining the stock quantity. According to the inventory management method according to the present invention, the inventory quantity in consideration of the remaining number of materials in advance can be automatically obtained.

  According to the inventory management system and inventory management method according to the present invention, the forward remaining number and the packing unit of the material are obtained with reference to the forward remaining number list of the recording unit, and the forward remaining number of the material The quantity of materials in the ordering data is compared, the quantity delivered from the packaging unit of the materials is obtained based on the comparison result, and the forward remaining number of materials in the forward remaining number list is updated.

  With this configuration, it is possible to automatically obtain a warehoused quantity in consideration of the remaining number of forward materials. As a result, the material ordering process can be greatly saved.

  Hereinafter, an example of an embodiment of a warehouse management system and a warehouse management method according to the present invention will be described with reference to the drawings.

  FIG. 1 is a schematic diagram showing a configuration example of a storage management system 100 for electric power materials according to the present invention. The inventory management system 100 shown in FIG. 1 is a system that automatically manages the inventory of materials based on the registered remaining number of materials and the input material billing data. The warehouse management system 100 includes a server 1, a material billing terminal 2, a material management terminal 3, a material transport terminal 4, and a DB 5.

  Each of the terminals 2 to 4 is connected to the server 1 (an example of an information processing apparatus) via the communication line 10 and the communication line network 11. Each of the terminals 2 to 4 is, for example, a notebook personal computer, and includes a monitor 7, a keyboard 8, a mouse 9, and a USB (Universal Serial Bus) interface (not shown). A mouse 9 is connected to the USB interface. As the mouse 9, for example, an optical mouse is used in which the optical sensor detects movement by intermittently scanning the ground plane. When the mouse 9 is moved vertically and horizontally on the plane, the cursor 2c (see FIG. 4) displayed on the screen of the monitor 7 moves vertically and horizontally. As the keyboard 8, for example, a 106-type keyboard provided with a key top for use in Kana-Kanji conversion or the like is used.

  A DB 5 is connected to the server 1. In this DB 5, the remaining number of forward materials is recorded. Here, the remaining number of forward materials is, for example, the number of materials that are distributed by a predetermined packing unit, and the remaining number of materials that are actually used for construction is subtracted from the materials of the distributed packing units. Say. For example, when a high pressure retaining insulator having a packing unit of “20” is distributed, and in actual construction, “15” high pressure retaining insulators are used, the remaining number of forwards is “5”. The remaining number of forwards for each material is recorded in the DB 5.

  The material requesting terminal 2 is an example of a terminal for ordering. For example, the material requesting terminal 2 is installed at a sales office that undertakes electric power construction, and bills materials used for the electric power construction. In this example, the material billing terminal 2 is operated by an operator of the sales office, and sends to the server 1 warehouse billing data D1 (an example of ordering data) indicating the item name of the material to be ordered and the quantity of the material. For example, the material billing terminal 2 transmits to the server 1 warehouse billing data D1 for billing “three high-voltage pin insulators 2” as materials for power construction. Note that only one material requesting terminal 2 is provided for easy understanding of the explanation. However, when there are a plurality of construction sales offices, the number of construction sales offices is the same.

  The server 1 obtains a stock quantity for stocking materials based on the forward remaining number list 6 (see FIG. 3) in the DB 5 and updates the forward remaining number list 6. In this example, the server 1 refers to the forward remaining number list 6 in the DB 5 to obtain the forward remaining number and the packaging unit of the material, and the forward remaining number of the material and the quantity of the material in the warehouse billing data D1. And the quantity in stock is determined from the packaging unit of the material based on the comparison result.

  In this example, the server 1 compares the quantity of the material in the warehouse billing data D1 with the forward remaining number data D2 in the forward remaining number list 6 acquired from the DB 5, and the forward remaining number of the material is determined. Determine if it is missing. When the server 1 determines that the remaining number of forward materials is insufficient, the server 1 calculates the shortage of the materials and performs control so as to newly obtain the storage quantity from a predetermined packing unit and distribute the materials. In addition, when it is determined that the remaining number of materials in advance is sufficient, the server 1 performs control so that the material is distributed from the material in advance by setting the storage quantity to zero.

  For example, the content of the stocking request data D1 from the material requesting terminal 2 indicates that “only 3 high-pressure pin insulators 2 are charged”, and the content of the forward remaining number data D2 of DB5 is “high-pressure pin insulator” When the remaining number of type 2 is “2”, the server 1 determines that there is a shortage of high voltage pins and one type 2 type. In this case, the server 1 uses the distribution request data D3 (an example of the output quantity data) for distributing the high-pressure pin insulator 2 in 10 packing units, the material requesting terminal 2, the material management terminal 3, and It transmits to the material conveying terminal 4.

  The material transport terminal 4 of the distribution center is an example of a terminal for stocking, and receives the distribution adjustment data D3 and performs the material stocking process. For example, the material transport terminal 4 displays the material stock information on the monitor 7. The operator confirms the contents displayed on the monitor 7 and carries out a material transport procedure. In addition, the operator of the distribution center may target, for example, the warehouse billing data D1 only three business days before the desired delivery date when carrying out the warehouse of materials. In this case, the operator of the distribution center operates the material transfer terminal 4 and transmits to the server 1 request data D4 for targeting the warehouse billing data D1 only three business days before the desired delivery date. When the server 1 receives the request data D4, the server 1 creates distribution adjustment data D3 for the delivery request data D1 only three business days before the desired distribution date, and transmits it to the material transport terminal 4.

  The material billing terminal 2 of the construction sales office receives the distribution adjustment data D3 and displays the contents on the monitor 7. The operator confirms the content displayed on the monitor 7 and confirms the stock of the material.

  The material management terminal 3 of the material management unit is an example of a management terminal, and receives the distribution adjustment data D3 and performs material management processing. For example, the material management terminal 3 receives the distribution adjustment data D3 and displays the contents on the monitor 7. The operator confirms the content displayed on the monitor 7 and confirms the stock of the material. In this manner, the power material storage management system 100 is configured.

  FIG. 2 is a block diagram illustrating a configuration example of the power material storage management system 100. The server 1 shown in FIG. 2 includes a warehouse information input unit 1a, a calculation unit 1b, a distribution result transmission unit 1c, and a hard disk 1d. A storage control program is stored in the hard disk 1d. When the power supply (not shown) of the server 1 is turned on, the computing unit 1b accesses the hard disk 1d to start the warehouse control program.

When the warehouse billing data D1 is transmitted from the material billing terminal 2 after starting the warehouse control program, the warehouse information input unit 1a of the server 1 inputs the warehouse billing data D1 to the calculation unit 1b. Output. The calculation unit 1b compares the delivery request data D1 with the remaining transfer number data D2 acquired from the DB 5, and determines whether or not the material is insufficient. When it is determined that the material is insufficient, the arithmetic unit 1b calculates the shortage of the material and newly generates distribution adjustment data D3 for distributing the material in a predetermined packing unit. When it is determined that the material is not insufficient, the calculation unit 1b generates distribution adjustment data D3 for distributing the material from the forwarded material.
Thereafter, the calculation unit 1b outputs the distribution adjustment data D3 to the distribution result transmission unit 1c. The distribution result transmitting unit 1c transmits the distribution adjustment data D3 to the material requesting terminal 2, the material management terminal 3, and the material transporting terminal 4.

  Next, a configuration example of the remaining remaining number list 6 indicating the remaining remaining number data D2 recorded in the DB 5 will be described. FIG. 3 is an explanatory diagram showing a configuration example of a part of the forward remaining number list 6. The forward remaining number list 6 shown in FIG. 3 is formed in a matrix, and its column direction is at least a “product name” item 6a, a “unit” item 6b, a “distribution destination” item 6c, and a “delivery destination” item 6d. , The “remaining delivery number” item 6e, the “application category” item 6f, and the “packing unit” item 6g.

  In the “item name” item 6a of the forward remaining number list 6, data indicating the item name code of the material and its item name standard is set. In the “unit” item 6b, data (for example, the number) indicating the unit is set. In the “distribution destination” item 6c, data indicating the distribution destination code of the material and the name of the distribution destination is set. In the “delivery destination” item 6d, data indicating the name of the delivery destination of the material is set. Data indicating the remaining number of forward materials is set in the “number of remaining forwards” item 6e. In the “application category” item 6f, data indicating the application category of the material is set. In the “packing unit” item 6g, data indicating the packing unit of the material is set.

  For example, referring to the third items 6a to 6g from the top of the forward remaining number list 6, data indicating “2230002 high-pressure pin insulator 2 type” is set in the “item name” item 6a, and the “unit” item Data indicating “piece” is set in 6b, data indicating “Hiroshima” is set in “distribution destination” item 6c, and data indicating “construction office” is set in “delivery destination” item 6d. Is set, data indicating “3.0” is set in the “remaining delivery number” item 6e, data indicating “2” is set in the “application category” item 6f, and “packing unit” item Data indicating “10.0” is set in 6g. As a result, it can be seen that the construction office has three high-pressure pins and 2 types of insulators. Furthermore, it can be seen that the high-pressure pin insulator type 2 is packed in units of 10 at the time of distribution.

  Next, an example of actually requesting material stock from the material billing terminal 2 of the construction sales office will be described. 4 and 5 are explanatory diagrams showing display examples of the monitor 7 of the material requesting terminal 2. On the enlarged monitor 7 shown in FIG. 4, a warehouse output screen before input is displayed. This storage / delivery screen is displayed when the storage control program stored in the hard disk 1d shown in FIG. 2 is started. Further, the monitor 7 shown in FIG. 5 displays a warehouse transfer screen after input.

  The first input area 2a and the second input area 2b are displayed on the warehouse transfer screen shown in FIG. In the first input area 2a, an input item "Billing location" is displayed. For example, when the operator specifies a construction sales office that requests materials, the operator operates the mouse 9 to move the cursor 2c, and selects by clicking the input frame 2f of the “code” item in the “charged item” item of the input area 2a. To do. Thereafter, for example, a code “5100070” is input by the keyboard 8 as shown in FIG. By inputting this code “5100070”, the “construction sales office underground line section” corresponding to the code is automatically displayed in the adjacent input frame 2g as shown in FIG. Subsequently, the operator clicks and selects the input frame 2h of the “desired delivery date” item in the input area 2a, and inputs the date on which delivery is desired as shown in FIG. As a result, the input of the construction business office that requests the material and the desired delivery date is completed.

  Next, for example, when requesting three high pressure pin insulators 2 type, the operator clicks and selects the input box 2r of the “product name code” item in the second input area 2b, and inputs the code “2230002”. By inputting the code “2230002”, “high-pressure pin insulator 2 type” corresponding to the code is automatically displayed in the input box adjacent thereto as shown in FIG. Thereafter, the operator clicks and selects the input frame 2s of the “quantity” item, and inputs “three”. As a result, the high-voltage pin wheel 2 type input is completed.

  For example, when requesting 27 high-pressure retaining insulators, the operator clicks and selects the input box 2t of the “item name code” item in the input area 2b, and inputs the code “2200004”. When the code “2200004” is input, the “high-pressure retaining insulator” corresponding to the code is automatically displayed in the input box adjacent thereto as shown in FIG. Thereafter, the operator clicks and selects the input box 2u of the “quantity” item, and inputs the quantity “27”. Thereby, the input of the high pressure retaining insulator is completed.

  Further, for example, when charging an electric wire of 100 meters, the operator clicks and selects the input frame 2v of the “item name code” item in the input area 2b, and inputs the code “2200005”. When the code “2200005” is input, the “wire” corresponding to the code is automatically displayed in the adjacent input frame as shown in FIG. Thereafter, the operator clicks and selects the input box 2w of the “quantity” item, and inputs the quantity “100 m”. Thereby, the input of an electric wire is complete | finished. Finally, the operator places the cursor 2c on the send button 2d shown in FIG. 5 and clicks to send the input data shown in FIG. 5 to the server 1 shown in FIG. In addition, when ending the billing of the material, the operator places the cursor 2c on the end button 2e and clicks.

  The server 1 shown in FIG. 1 receives the warehouse request data D1 transmitted and adjusts the quantity of materials to be distributed. FIG. 6 is a table showing an example of the material distribution adjustment list 12. The distribution adjustment list 12 shown in FIG. 6 is created for the case where the data on the warehouse delivery screen shown in FIG. 5 is transmitted as the delivery request data D1. The distribution adjustment list 12 includes a “product name standard” item 12 a, “invoiced warehouse quantity” item 12 b, “construction office delivery remaining quantity” item 12 c, “distribution center warehouse quantity” item 12 d, and “post-delivery quantity”. It consists of the items of “remaining delivery number” item 12e.

  In this example, when the calculation unit 1b of the server 1 shown in FIG. 2 receives the warehouse billing data D1, the DB 5 is accessed and the forward remaining number list 6 recorded in the DB 5 is referred to (see FIG. 3). To do. For example, when calculating the quantity of the high-pressure pin insulator 2 type indicated by the warehouse billing data D1, the computation unit 1b calculates the code list of the “product name” item 6a in the forward remaining number list 6 and the high voltage of the warehouse billing data D1. The code “2230002” indicating the pin insulator type 2 is sequentially compared. When the comparison results in a match, the calculation unit 1b obtains the code list of the “distribution destination” item 6c in the remaining delivery list 6 and the first three digits of the code “5100070” indicating the billing location of the warehouse billing data D1. Compare. When the comparison results in a match, the calculation unit 1b refers to the “remaining forward number” item 6e in the remaining forward number list 6 illustrated in FIG. 3 and acquires data of the remaining number “3.0”. To do.

  After obtaining the data of the remaining number of forwards “3.0”, the calculation unit 1b subtracts the quantity “3.0” of the high-pressure pin insulator 2 type of the shipping request data D1 from the remaining number of forwards “3.0”. Then, the remaining number of deliveries after distribution is calculated as “0”. Further, the calculation unit 1b calculates the distribution center storage quantity as “0” because the high pressure pin insulator 2 need not be newly stored and can be covered by the remaining number of forwards.

  The calculation unit 1b creates these calculation results as a material distribution adjustment list 12 shown in FIG. In this example, the calculation unit 1b sets “high-pressure pin insulator 2 type” in the “item name standard” item 12a, “3.0 pieces” in the “invoiced quantity” item 12b, and “construction office” Is set to “3.0 pieces” in the “Remaining forward delivery number” item 12c, “0” is set in the “Distribution center storage quantity” item 12d, and “No. Set “0”.

  Next, when calculating the quantity of the high-pressure retention insulator indicated by the delivery request data D1, the operation unit 1b calculates the code list of the “product name” item 6a of the forward remaining number list 6 and the high-pressure retention of the delivery request data D1. The code “2200004” indicating the insulator is sequentially compared. When the comparison results in a match, the calculation unit 1b obtains the code list of the “distribution destination” item 6c in the remaining delivery list 6 and the first three digits of the code “5100070” indicating the billing location of the warehouse billing data D1. Compare. When the comparison results in a match, the calculation unit 1b refers to the “remaining forward number” item 6e in the remaining forward number list 6 illustrated in FIG. 3 and acquires data of the remaining number “18.0”. To do.

  After obtaining the data of the remaining number of forwards “18.0”, the calculation unit 1b subtracts the quantity “27.0” of the high-pressure detention insulator of the warehousing request data D1 from the remaining number of forwards “18.0”. , It is calculated that the remaining number of forwards is “9”. Here, since the remaining number of deliveries is “9”, the calculation unit 1b refers to the “packing unit” item 6g in the remaining number list 6 and stores the data of the packing unit “20.0”. To get. Then, the calculation unit 1b controls to newly unload the high pressure retaining insulator in the packing unit “20.0”, and subtracts “9” from the “20” newly unloaded. Then, the remaining number of deliveries after distribution is calculated as “11”.

  The calculation unit 1b creates these calculation results as a material distribution adjustment list 12 shown in FIG. In this example, the calculation unit 1b sets “high pressure retention insulator” in the “item name standard” item 12a, sets “27.0 pieces” in the “invoiced quantity” item 12b, “18.0 pieces” is set in the “remaining delivery number” item 12c, “20.0 pieces” is set in the “distribution center warehouse quantity” item 12d, and “remaining delivery number after distribution” item 12e is set to “ 11.0 "is set.

  Next, when calculating the number of electric wires indicated by the warehouse billing data D1, the computing unit 1b includes a code list of the “item name” item 6a in the remaining transfer list 6 and a code indicating the wires in the warehouse billing data D1. “2200005” is sequentially compared. When the comparison results in a match, the calculation unit 1b obtains the code list of the “distribution destination” item 6c in the remaining delivery list 6 and the first three digits of the code “5100070” indicating the billing location of the warehouse billing data D1. Compare. When the comparison results in a match, the calculation unit 1b refers to the “forward remaining number” item 6e in the forward remaining number list 6 illustrated in FIG. 3 and acquires data of the remaining forward number “0.0 m”. To do.

  After obtaining the data of the remaining number of forwards “0.0 m”, the calculation unit 1b subtracts the quantity “100.0 m” of the electric wire of the warehouse billing data D1 from the remaining number of forwards “0.0 m”. It is calculated that the remaining number is insufficient of “100 m”. Here, since the remaining number of deliveries is insufficient by “100 m”, the calculation unit 1 b refers to the “packing unit” item 6 g of the remaining number list 6 and stores the data of the packing unit “600.0 m”. get. And the calculating part 1b is controlled to newly unload an electric wire for every drum by packing unit "600.0m", and is short from "600.0m" newly unloaded to "100.0m". Is subtracted and the remaining number of deliveries after distribution is calculated as “500.0 m”.

  The calculation unit 1b creates these calculation results as a material distribution adjustment list 12 shown in FIG. In this example, the calculation unit 1b sets “electric wire” in the “item name standard” item 12a, sets “100.0 m” in the “invoiced quantity” item 12b, "0.0m" is set in the "item 12c", "600.0m" is set in the "distribution center warehouse quantity" item 12d, and "500.0m" is set in the "remaining number of deliveries after distribution" item 12e. Set. As described above, the calculation unit 1b creates the distribution adjustment list 12 including a total of three items of the high-pressure pin insulator 2, the high-voltage retaining insulator, and the electric wire.

  After the creation, the calculation unit 1b outputs the distribution adjustment list 12 as distribution adjustment data D3 to the distribution result transmission unit 1c (see FIG. 2). The distribution result transmitting unit 1c transmits the distribution adjustment data D3 to the material requesting terminal 2, the material management terminal 3, and the material transporting terminal 4.

  Next, a series of operations of the server 1 in the material stocking process will be described. 7 and 8 are flowcharts illustrating an operation example of the server 1. In the server 1, a power supply (not shown) is turned on, and the storage control program stored in the hard disk 1d of the server 1 shown in FIG. 2 is activated by the arithmetic unit 1b. In addition, the DB5 shown in FIG. 2 records the remaining number list 6 of the remaining number of forwards shown in FIG. Further, the server 1 receives the warehouse request data D1 from the material request terminal 2 of the construction sales office as needed, and stores the inventory request data D1 in the hard disk 1d shown in FIG.

  In this example, the operator of the distribution center operates the material conveying terminal 4 and takes in only the warehouse billing data D1 three business days before the desired distribution date. Thereafter, the operator of the distribution center carries out material stock based on the distribution adjustment data D3.

  In step ST1 shown in FIG. 7 with these as the conditions of the stock removal process, the server 1 receives the request data D4 from the material transfer terminal 4, and three business days before the desired distribution date from the hard disk 1d based on the request data D4. Only the inventory request data D1 is extracted, and the process proceeds to step ST2.

  In step ST <b> 2, the server 1 compares the stock quantity for each product name standard to be stocked with the remaining number of deliveries at the construction sales office that is the stock destination. In this example, the calculation unit 1b of the server 1 accesses the DB 5 and refers to the remaining number list 6 (see FIG. 3) recorded in the DB 5. For example, when calculating the quantity of the high-pressure pin insulator 2 type indicated by the inventory request data D1, the calculation unit 1b displays the code list of the “product name” item 6a in the forward remaining number list 6 and the inventory request data D1. The code “2230002” indicating the type 2 high-pressure pin insulator is sequentially compared. When the comparison results in a match, the calculation unit 1b obtains the code list of the “distribution destination” item 6c in the remaining delivery list 6 and the first three digits of the code “5100070” indicating the billing location of the warehouse billing data D1. Compare. When the comparison results in a match, the calculation unit 1b refers to the “remaining forward number” item 6e in the remaining forward number list 6 illustrated in FIG. 3 and acquires data of the remaining number “3.0”. To do. After obtaining the data of the remaining number of forwards “3.0”, the calculation unit 1b determines that the number of remaining forwards “3.0” and the high-pressure pin insulator 2 type quantity “3.0” of the shipping request data D1. Compare Subsequently, the process proceeds to step ST3.

  In step ST <b> 3, the server 1 determines whether or not the remaining number of forwards is equal to or greater than the stored quantity. When the server 1 determines that the remaining number of deliveries is equal to or greater than the stored quantity, for example, the calculation unit 1b of the server 1 indicates that the high-pressure pin insulator DB2 type 2 remaining type "3.0" is stored in the warehouse. When it is determined that the high-pressure pin of the billing data D1 is greater than or equal to the quantity “3.0” of the wheel 2 type, the process proceeds to step ST4.

  In step ST4, the server 1 subtracts the stored quantity from the remaining number of forwards at the construction office. For example, the calculation unit 1b of the server 1 subtracts the quantity “3.0” of the high-pressure pin insulator 2 type of the warehouse billing data D1 from the remaining number “3.0” of the high-pressure pin insulator 2 type of DB5. The remaining number of forwards after distribution is calculated as “0”. In addition, since the calculation unit 1b does not need to newly unload the high-pressure pin insulator 2 and can cover it with the remaining number of forwards, the unloading amount is calculated as “0”. The calculation unit 1b creates these calculation results as the material distribution adjustment list 12 (distribution adjustment data D3) shown in FIG. 6, and proceeds to step ST5.

  In step ST5, the server 1 transmits the distribution adjustment data D3 to the material management terminal 3 of the material management unit, and proceeds to step ST6. In step ST6, the server 1 transmits the distribution adjustment data D3 to the material billing terminal 2 of the construction sales office, and proceeds to step ST7.

  In step ST7, the server 1 updates the forward remaining number data of the “forward remaining number” item 6e in the remaining number list 6 recorded in the DB 5 shown in FIG. For example, when “three” high-pressure pin insulators 2 are distributed, the computing unit 1b of the server 1 sets “3.0” in the “advance remaining number” item 6e of the high-pressure pin insulator 2 type in the remaining number list 6 of forwards. "Is updated to" 0.0 "and the process proceeds to step ST8.

  In step ST8, the server 1 stores the updated remaining number list 6 in the DB 5 and ends the stock removal process. The above storage process is a process in the case where it is determined in the above-described step ST3 that the remaining number of deliveries is equal to or greater than the storage quantity (the same number). When the server 1 determines in the above-described step ST3 that the remaining number of deliveries is not equal to or greater than the stocked quantity, the process proceeds to step ST9 shown in FIG.

  In step ST9, the server 1 determines whether or not the packing unit of the product name standard to be stored is a single product. In this example, when the packing unit is a single item, the item “packing unit” item 6g of the remaining number list 6 shown in FIG. 3 indicates “1.0”. Further, when the packing unit is a plurality of products, the item of the “packing unit” item 6g indicates a value larger than “1.0”. The server 1 refers to the item of the “packing unit” item 6g in the forward remaining number list 6 and when the value is “1.0”, the server 1 determines that the packing unit of the product name standard to be delivered is a single item. Then, the process proceeds to step ST10.

  In step ST10, the server 1 applies all the remaining delivery numbers of the construction sales office, and controls so that only the quantity that is insufficient for the warehoused quantity is delivered from the distribution center, and proceeds to step ST11.

  In step ST11, the server 1 transmits distribution adjustment data D3 indicating the quantity of goods delivered to the material management terminal 3 of the material management unit. In this example, the total number of warehoused goods is the quantity obtained by adding the remaining number of deliveries from the construction office and the quantity delivered from the distribution center. Subsequently, the process proceeds to step ST12.

  In step ST12, the server 1 transmits distribution adjustment data D3 indicating the quantity of goods delivered to the material billing terminal 2 of the construction sales office. In this example, the total number of warehoused items is a value obtained by adding the number of remaining delivery at the construction office and the number of warehoused items at the distribution center as in step ST11. Subsequently, the process proceeds to step ST13.

  In step ST <b> 13, the server 1 transmits distribution adjustment data D <b> 3 indicating the quantity of goods delivered to the material transfer terminal 4 in the distribution center. The operator of the distribution center carries out material stock based on the distribution adjustment data D3. In this example, the total number of warehoused items is a value obtained by adding the number of remaining delivery at the construction office and the number of warehoused items at the distribution center as in step ST11. Subsequently, the process proceeds to step ST14.

  In step ST14, the server 1 updates the forward remaining number data of the “forward remaining number” item 6e in the remaining number list 6 recorded in the DB 5 shown in FIG. 3, and step ST8 shown in FIG. The forward remaining number list 6 updated after being transferred to is stored in the DB 5 and the exit processing is terminated. The above warehousing process is a process in the case where it is determined in step ST9 described above that the packaging unit of the product name standard to be garnished is a single product. When the server 1 determines in step ST9 described above that the package unit of the product name standard to be stored is composed of a plurality of products, the process proceeds to step ST15.

  In step ST15, the server 1 applies all the remaining number of deliveries of the construction sales office, and calculates the delivery unit for the quantity that is not enough for the delivery quantity from the distribution center by calculating the delivery unit by the packing unit of the warehouse entry name. Control to do. Here, the distribution quantity (storage unit) of the distribution center is a quantity obtained by subtracting the remaining number of forwards from the invoiced shipment quantity and divided by the packing unit of the warehouse exhibition name. Round up after the decimal point.

  In this example, the calculation unit 1b of the server 1 accesses the DB 5 and refers to the remaining number list 6 (see FIG. 3) recorded in the DB 5. For example, when calculating the quantity of the high-pressure detainer indicated by the unloading request data D1, the calculation unit 1b displays the code list of the “product name” item 6a of the remaining transfer list 6 and the high-pressure detainment of the unloading request data D1. Are sequentially compared with the code “2200004”. When the comparison results in a match, the calculation unit 1b obtains the code list of the “distribution destination” item 6c in the remaining delivery list 6 and the first three digits of the code “5100070” indicating the billing location of the warehouse billing data D1. Compare. When the comparison results in a match, the calculation unit 1b refers to the “remaining forward number” item 6e in the remaining forward number list 6 illustrated in FIG. 3 and acquires data of the remaining number “18.0”. To do. After obtaining the data of the remaining number of forwards “18.0”, the calculation unit 1b subtracts the number of forwards remaining “18.0” from the quantity “27.0” of the high-pressure retention insulator of the warehouse request data D1. Thus, it is calculated that the remaining number of forwards is “9”. Divide the remaining number of “9” by the packing unit “20.0” of the high-pressure detention insulator and round the number up to one decimal place. (Unit of warehouse).

  Then, the calculation unit 1b controls to newly unload the high pressure retaining insulator in the packing unit “20.0”, and subtracts “9” from the “20” newly unloaded. Then, the remaining number of deliveries after distribution is calculated as “11”. The calculation unit 1b creates these calculation results as the material distribution adjustment list 12 (distribution adjustment data D3) shown in FIG. 6, and proceeds to step ST16.

  In step ST <b> 16, the server 1 transmits distribution adjustment data D <b> 3 indicating the quantity of goods delivered to the material management terminal 3 of the material management unit. In addition, the total quantity of warehouses is the quantity obtained by adding the number of remaining deliveries from the construction sales office and the quantity delivered from the distribution center. For example, the total number of warehouses for high-pressure detention insulators is the quantity “38.0”, which is the sum of the remaining number “18.0” at the construction office and the warehouse quantity “20.0” at the distribution center. . Actually, the output quantity of the high-pressure retaining insulator requested from the construction sales office is “27.0”, so the remaining number of forwards after distribution is “11.0”. In this example, the storage quantity “27.0” of the high-pressure detention insulator is equal to the remaining number “18.0” of the construction office, and the distribution quantity “20.0” of the distribution center. Subsequently, the process proceeds to step ST17.

  In step ST <b> 17, the server 1 transmits distribution adjustment data D <b> 3 indicating the quantity of goods delivered to the material billing terminal 2 of the construction sales office. Note that the total number of warehoused items is substantially equal to the number obtained by adding the remaining number of forwards from the construction office and the number of warehoused items at the distribution center, as in step ST16. Subsequently, the process proceeds to step ST18.

  In step ST18, the server 1 transmits distribution adjustment data D3 indicating the quantity of goods delivered to the material transfer terminal 4 of the distribution center. The operator of the distribution center carries out material stock based on the distribution adjustment data D3. Note that the total number of warehoused items is substantially equal to the number obtained by adding the remaining number of forwards from the construction office and the number of warehoused items at the distribution center, as in step ST16. Subsequently, the process proceeds to step ST19.

  In step ST19, the server 1 updates the forward remaining number data in the “forward remaining number” item 6e of the remaining forward number list 6 recorded in the DB 5 shown in FIG. For example, when “27” high-pressure retained insulators are distributed, “20” is delivered, and therefore, the remaining number “18.0” to “7.0” in the “remaining number of forwards” item 6e of this high-pressure retained insulator. ”Is updated to the remaining number of forwards“ 11.0 ”. Subsequently, the process proceeds to step ST8 shown in FIG. 7 and the updated remaining number list 6 is stored in the DB 5 to end the warehouse process. In addition, the above warehousing process is a process in the case where it is determined in the above-described step ST9 that the packaging unit of the product name standard to be ware-out is a plurality of products.

  As described above, according to the storage management system 100 and the storage management method according to the present invention, the forward remaining number and the packing unit of the material are obtained with reference to the forward remaining number list 6 of the DB 5, and the material The forward remaining number is compared with the quantity of the material in the warehouse billing data D1, and the inventory quantity is obtained from the packaging unit of the material based on the comparison result, and the forward remaining number of the material in the forward remaining number list 6 is obtained. It is to be updated.

  Accordingly, it is possible to automatically obtain the stock quantity considering the number of remaining materials. As a result, the material ordering process can be greatly saved.

  The present invention is suitable for application to a system for managing the storage and stock of forwarded power materials.

It is the schematic which shows the structural example of the warehouse management system 100 of the electric power material which concerns on this invention. It is a block diagram which shows the structural example of the storage management system 100 of electric power material. It is explanatory drawing which shows the example of a structure of a part of forward remaining number list | wrist 6. FIG. It is explanatory drawing which shows the example of a display (uninput) of the monitor 7 of the terminal 2 for material requests. It is explanatory drawing which shows the example of a display (after input) of the monitor 7 of the terminal 2 for material request. It is a table | surface figure which shows an example of the distribution adjustment list | wrist 12 of materials. 6 is a flowchart illustrating an operation example (part 1) of the server 1; 6 is a flowchart illustrating an operation example (part 2) of the server 1; It is the schematic which shows the structural example of the distribution adjustment assistance system 200 of the material which concerns on a prior art example. It is a display example of the forward remaining number inquiry and display screen 59 displayed on the monitor 7 of the DB reference terminal 54 according to the conventional example. It is explanatory drawing which shows the structural example of the warehouse delivery form 58 which concerns on a prior art example.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Server (information processing apparatus), 2 ... Material billing terminal (ordering terminal), 3 ... Material management terminal (management terminal), 4 ... Material conveyance terminal ( Terminal for storage), 5 ... DB (recording unit), 6 ... list of remaining number of forwards, 12 ... distribution adjustment list of materials,
100 ... Electrical material storage management system, D1 ... Storage request data (ordering data)

Claims (5)

A recording section in which the name of the material, the packaging unit of the material, and the remaining number of forwarded materials are recorded as a forward remaining number list for each material,
An information processing apparatus for obtaining a stock quantity for stocking materials based on a list of remaining transfer numbers of the recording unit, and performing a stock management process;
An ordering terminal for transmitting ordering data indicating the name of the material to be ordered and the quantity of the material to the information processing apparatus;
The information processing apparatus includes:
Refer to the list of remaining transfer numbers in the recording unit to obtain the remaining transfer number and packaging unit of the material, compare the remaining transfer number of the material with the quantity of the material in the ordering data, and the comparison result The inventory management system, wherein the inventory quantity is obtained from the packaging unit of the material based on the inventory quantity, and the inventory quantity of the inventory in the inventory quantity list is updated. The information processing apparatus includes:
After comparing the forward balance of the material indicated by the forward balance list and the quantity of the material in the ordering data,
When it is determined that the number of remaining forward items is insufficient, the shortage of the material is calculated to obtain the unloading quantity from the packaging unit of the material,
The warehouse management system according to claim 1, wherein, when it is determined that there is a sufficient remaining number of forward materials, the warehouse quantity is set to zero.   The said information processing apparatus is provided with the terminal for warehousing which receives the said warehousing quantity calculated | required as warehousing quantity data, and performs the warehousing process of material based on the said warehousing quantity data. The warehouse management system described in 1.   The warehouse management according to claim 3, further comprising a management terminal that receives the warehouse quantity data transmitted from the information processing apparatus and manages materials based on the warehouse quantity data. system. Sending ordering data indicating the item name and quantity of materials to be ordered;
Recording the name of the material, the packaging unit of the material, and the remaining number of forwarded materials as a forward remaining number list for each material;
Obtaining a forward remaining number and a packing unit of the material with reference to the recorded forward remaining number list;
Receiving the order data;
Comparing the received quantity of the material of the ordering data with the acquired remaining number of the material, and obtaining a stock quantity of the material from the packaging unit of the material based on the comparison result;
And a step of updating a forward remaining number of materials in the forward remaining number list after obtaining the warehoused quantity.

Images