JP6300709B2 - Work management system and work management method - Google Patents

Description

  The present invention relates to a work management system and a work management method, and more specifically, to a technique that can clearly and separately execute shipping instructions at a normal time and an emergency time in a warehouse or the like.

  In retail businesses such as supermarkets and convenience stores, it is necessary to display sales products in appropriate quantities and in the appropriate positions to further increase sales of products with strong sales and to curb excess inventory of products with poor sales. It is an important matter. In order to maintain such a situation, it is necessary to perform flexible inventory management in order to avoid out-of-stocks while suppressing the inventory at each store as much as possible. On the other hand, flexible management of inventory at a store requires, in other words, efficient and quick execution of management operations in a warehouse or the like that is responsible for storage and distribution of each product.

  Therefore, in recent years, WMS (Warehouse Management System) is attracting attention among SCM solutions, and management of traceability, expiration date, expiration date, etc. is performed as well as operational efficiency.

  Such WMS-related technology includes, for example, an inventory allocation management system that allocates inventory products according to order information including customer identification information for identifying customers and product identification information for identifying products. Customer data storage unit for storing priority attribute identification information for identifying attribute information prioritized by the customer identified by the customer identification information and attribute identification information, which is information used when assigning the customer information, in association with each other Based on the customer identification information included in the order information, and an inventory data storage unit that stores inventory information including the product identification information of the inventory products and an attribute value that represents the value of the attribute information of the inventory products A priority attribute search function for extracting the priority attribute identification information from the customer data storage unit, and a pre-corresponding to the product identification information included in the order information Inventory search function for extracting inventory information from the inventory data storage unit, inventory allocation function for allocating the inventory products based on the extracted inventory information and the attribute value of the extracted priority attribute identification information And an inventory allocation management system (see Patent Document 1) and the like have been proposed.

JP 2008-105795 A

  On the other hand, in warehouses etc., on the basis of masters for normal work where the details of shipping work are determined in advance, shipping work etc. in response to customer instructions are performed, as well as emergency cases such as sudden delivery requests that occur suddenly It is necessary to respond. However, when shipping work instructions are applied by applying conventional WMS technology for such emergency cases, the contents of the shipping work being executed as a normal operation and the contents of the shipping work instruction based on the emergency case can be clearly distinguished. There is a risk that the contents of each instruction will be confused and confused.

  Workers in the warehouse premises under this situation are easily confused without knowing whether the number of shipping instructions has been changed for normal operations currently being executed or whether another work instruction has been added. This leads to confusion of each worker, an accompanying increase in work time, or a review of the provisioning work, which may lead to a delay in delivery to each customer store.

  On the other hand, if the WMS provided in such a warehouse is configured and handled separately for the above-described normal and emergency shipping operation management systems, system installation and management efforts and costs increase, and downstream It is also not practical to change the configuration of the inventory allocation function.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a technology capable of clearly distinguishing and executing each shipping instruction in a normal time and an emergency time in a warehouse or the like in parallel.

  The work management system of the present invention that solves the above problems includes a master table of normal shipping operations defined according to the shipping destination and product category of a product, and a shipping request table that stores a product shipping request from a customer. The storage device to be stored and each product shipping request in the shipping request table are collated with the master table, the shipping contents are aggregated and displayed on the display device for each normal shipping operation, and each product in the shipping request table is displayed. Product shipment requests that have not been aggregated among the shipment requests are displayed on a display device in association with emergency shipment operations, and each normal or emergency shipment operation displayed on the display device is defined as a work management unit. A process for receiving the shipped shipping operation instruction by the input device and outputting the contents of the shipping operation at the normal time or the emergency time corresponding to the shipping instruction to a predetermined inventory allocation device. Characterized in that it comprises a computing device for execution.

  In addition, the work management method of the present invention stores a master table of normal shipping work defined according to the shipping destination and product category of a product, and a shipping request table storing product shipping requests from customers. A computer system comprising a device collates each product shipment request in the shipment request table with the master table, aggregates the contents of the shipment for each normal shipment operation, and displays it on a display device. The product shipment requests that have not been aggregated among the product shipment requests are displayed on the display device in association with the emergency shipment operation, and the normal or emergency shipment operations displayed on the display device are managed. A shipping work instruction in units is received by the input device, and the contents of the shipping work at the normal time or the emergency time corresponding to the corresponding shipping instruction are determined as a predetermined inventory allocation device. And outputs.

  According to the present invention, it is possible to clearly distinguish and execute each shipping instruction in a normal time and an emergency time in a warehouse or the like in parallel.

It is a figure which shows the example of whole structure of the distribution and warehouse management system in this embodiment. It is a figure which shows the hardware structural example of DB server in the physical distribution management system of this embodiment. It is a figure which shows the hardware structural example of the Web * AP server in the physical distribution management system of this embodiment. It is a figure which shows the example of a data structure of the shipping request table with which DB server of this embodiment is equipped. It is a figure which shows the example of a data structure of the shipping work group master which the DB server of this embodiment comprises. It is a figure which shows the example of a data structure of the shipping destination master which the DB server of this embodiment comprises. It is a figure which shows the data structural example of the merchandise category master which the DB server of this embodiment comprises. It is a figure which shows the data structural example of the numbering master which the DB server of this embodiment comprises. It is a figure which shows the example of a data structure of the user table which the DB server of this embodiment comprises. It is a sequence diagram which shows the operation | movement of the normal time shipping work instruction | indication instruction | indication of the physical distribution management system of this embodiment. It is a flowchart which shows operation | movement of the shipping operation instruction | indication reception function in the normal time called from the normal shipping operation instruction | indication screen with which the Web * AP server of this embodiment is equipped. It is a figure which shows the normal shipping work instruction | indication screen which the client terminal of this embodiment comprises. It is a figure which shows the data structural example of the normal time shipping work instruction | indication data which the DB server of this embodiment comprises. It is a sequence diagram which shows the operation | movement of the emergency shipping work instruction | indication instruction | indication of the physical distribution management system of this embodiment. It is a flowchart which shows operation | movement of the emergency shipping work instruction | indication reception function called from the emergency shipping work instruction | indication screen with which the Web * AP server of this embodiment is equipped. It is a figure which shows the emergency shipping work instruction | indication screen which the client terminal of this embodiment comprises. It is a figure which shows the data structural example of the emergency shipment work instruction data which the DB server of this embodiment comprises. It is a figure which shows the shipping operation inquiry screen (result screen) which the client terminal of this embodiment has.

--- System configuration ---

  Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a diagram showing an example of the overall configuration of a physical distribution / warehouse management system 100 including a physical distribution management system 101 (hereinafter referred to as a physical distribution management system) which is a work management system of the present embodiment. A physical distribution management system 101 shown in FIG. 1 is a computer system that can execute distinct shipping instructions at the normal time and emergency time in a warehouse or the like while clearly distinguishing them in parallel.

  In addition to the above-described distribution management system 101, the distribution / warehouse management system 100 illustrated in FIG. 1 includes a backbone system 106 having an ordering server 107 and a plurality of client terminals 104 used by a user in charge of management in a distribution warehouse. A computer system connected via a network 105 such as the Internet. The physical distribution management system 101 includes a DB server 102 that stores data necessary for processing, and a Web / AP server 103 that executes appropriate processing using data held by the DB server 102.

  The above-described core system 106 is, for example, a business management system provided in a retailer's head office system, and is a computer system including an ordering / ordering server 107 as a system related to ordering / ordering business among the business of the corresponding retailer. This ordering / order receiving server 107 has at least a function of transmitting a product shipping request to the DB server 102 via the network 105 for a product to be delivered to each retail store under the corresponding retailer. On the other hand, the DB server 102 receives this product shipment request and stores it in the shipment request table 211. A configuration in which the function of the ordering server 107 is provided in the DB server 102 or the WEB / AP server 103 may be assumed.

  The client terminal 104 is a general computer terminal, and is a terminal used by a user in charge of management in a distribution warehouse, as described above. The client terminal 104 is connected from the WEB / AP server 103 of the distribution management system 101 via the network 105. It has at least a function of displaying a predetermined screen to be provided on a display device, receiving a designation of a shipping work instruction from a user in charge of management, and transmitting this to the WEB / AP server 103. Instead of the client terminal 104, a configuration in which an input device and a display device in the WEB / AP server 103 are employed may be assumed.

  Next, an example of a hardware configuration of the physical distribution management system 101 that is an execution subject of the work management method in the present embodiment in the above-described physical distribution / warehouse management system 100 will be described. As described above, the physical distribution management system 101 according to this embodiment includes the DB server 102 and the WEB / AP server 103.

  Among these, the DB server 102 is configured by a server device that is a general computer, as illustrated in FIG. 2, and is configured by an appropriate nonvolatile storage element such as an SSD (Solid State Drive) or a hard disk drive. The apparatus 201, a memory 203 composed of a volatile storage element such as a RAM, and a program 202 held in the storage apparatus 201 are read out and executed in the memory 203 to perform overall control of the apparatus itself, as well as various determinations, calculations, and A CPU 204 that performs control processing and a communication device 205 that performs communication control with other devices via the network 105 are provided. In addition, each apparatus 201-205 is connected by BUS etc.

  The storage device 201 stores a database 210 in addition to the program 202 described above. The database 210 includes a shipping request table 211, a shipping work group master 212, a shipping destination master 214, a merchandise category master 216, a numbering master 218, and a user table 219. A specific example of the data structure of each of these tables 211 to 219 will be described later.

  An example of the hardware configuration of the WEB / AP server 103 that accesses the above-described DB server 102 to acquire information and executes necessary processing is as shown in FIG. Similar to the above-described DB server 102, the WEB / AP server 103 is also configured by a server device that is a general computer, and is configured by an appropriate nonvolatile storage element such as an SSD (Solid State Drive) or a hard disk drive. A storage device 301, a memory 303 composed of a volatile storage element such as a RAM, and a program 302 held in the storage device 301 are read and executed in the memory 303 to perform overall control of the device itself, and various determinations and calculations And a CPU 304 that performs control processing, and a communication device 305 that performs communication control with other devices via the network 105. The devices 301 to 305 are connected by BUS or the like.

  Note that the storage device 301 stores programs corresponding to the shipping work instruction receiving function 311, the inventory allocation function 314, and the sorting order setting function 315 as the above-described program 302. Among these, the shipping work instruction receiving function 311 is a function implemented by executing a program called from a normal shipping work instruction screen and an emergency shipping work instruction screen described later. In addition, the inventory allocation function 314 includes an order quantity (planned quantity to be shipped) indicated by a merchandise shipment request from a store or the like serving as a customer, output work instruction data 313 that is an output result of the shipping work instruction reception function 311 described above, and inventory merchandise. This function is implemented by executing a program that maps the number and calculates the number of shipping instructions and the number of missing items. The stock allocation function 314 may adopt existing technology as appropriate. Further, the sorting order setting function 315 is implemented by executing a program for setting the order of goods for picking the goods in the warehouse for the number of shipment instructions described above and the order for sorting the picked goods described above. It is a function. As for the sorting order setting function 315, an existing technique that has existed in the past may be appropriately adopted.

  Next, functions provided in the physical distribution management system 101 of this embodiment will be described. As described above, the functions described below can be said to be functions that are implemented by, for example, each server of the physical distribution management system 101 executing a program. Each function illustrated here corresponds to the shipping work instruction receiving function 311 in the WEB / AP server 103 described above. In this case, the computing device of the physical distribution management system 101 as the work management system is the WEB / AP server 103 and the storage device is the DB server 102. Of course, the actual work management system is not a configuration in which the functions are separately allocated to these two servers, but a single server device may constitute the physical distribution management system 101 as a work management system.

  The WEB / AP server 103 in the physical distribution management system 101 of the present embodiment sends each product shipping request in the shipping request table 211 in the DB server 102 to each of the above masters, that is, the shipping work group master 212, the shipping destination master 214, the product category. It has a function of collating with the master 216, collecting the contents of shipment such as the planned number of shipments for each normal shipment operation (hereinafter referred to as “shipment operation group”), and displaying this on the display device of the client terminal 104. .

  In addition, the WEB / AP server 103 is a product shipping request for which the shipping content aggregation processing based on the masters 212, 214, and 216 is not performed among the product shipping requests in the shipping request table 211 in the DB server 102. Is provided on the display device of the client terminal 104 in association with an emergency shipping work group. For example, the product shipment request that has not been subjected to the process of consolidating the shipment contents is extracted from the shipment request table 211 such as immediately before the business start time in one day in the corresponding warehouse, and the master 212, 214, 216 It is stored in the shipping request table 211 at a timing different from the periodic timing for executing each processing of collation and aggregation. For example, it corresponds to an urgent product shipment request from a store that requires the same day delivery of the product.

  In addition, as a product shipment request to be displayed on the display device of the client terminal 104 in association with such an emergency shipment work group, the client terminal 104 or the irregular timing different from the regular timing as described above, or A product shipment request acquired from an input device input by an administrative user who has received an emergency telephone call can also be assumed. Therefore, in this case, the WEB / AP server 103 has a function of displaying such a product shipment request on the display device of the client terminal 104 in association with an emergency shipping work group.

  Further, the WEB / AP server 103 sends a shipping work instruction with each shipping work group in a normal time or an emergency time displayed on the display device of the client terminal 104 as a work management unit to the input device of the client terminal 104. And the contents of the above-mentioned normal or emergency shipping work group corresponding to the corresponding shipping instruction are output to the inventory allocation function 314. The inventory allocation process associated with the shipping instruction itself can be realized by a general function existing in the WMS.

Note that the WEB / AP server 103 described above receives a shipping operation instruction from the client terminal 104, and performs a work management number along the numbering master 218 for each normal or emergency shipping operation that receives the shipping operation instruction. And a function of associating the work management number assigned here with the contents of the normal or emergency shipping work group corresponding to the corresponding shipping instruction and outputting to the above-described inventory allocation function 314. Yes.
--- Data structure example ---

  Next, a data structure of tables held by the DB server 102 of this embodiment and used for processing by the WEB / AP server 103 will be described. FIG. 4 is a diagram illustrating a data configuration example of the shipping request table 211 included in the DB server 102. The shipping request table 211 in this embodiment is a table that stores the data of the product shipping request transmitted from the ordering / receiving server 107 as a record, and includes a shipper code 701, a company code 702, which uniquely indicates the shipper who is the main body of the shipping instruction. And a supplier code 703 as a key, a shipping destination code 704 that uniquely indicates a store to which the product is shipped, a product category code 705 that indicates a category of the product to be shipped, and a slip No. issued by the shipper regarding the corresponding product shipping request. 706, slip line NO. 707, a work date 708 indicating the date of shipment from the warehouse, a product code (JAN code) 709 of the product to be shipped, a planned shipping number 710, a shipping instruction number 711, and a missing item number 712 corresponding to each value It is an aggregate. The data item itself of each record in the shipping request table 211 is the same as the data handled in the existing WMS.

  FIG. 5 is a diagram showing a data configuration example of the shipping work group master 212 provided in the DB server 102 of the present embodiment. The shipping work group master 212 in the present embodiment is a table that defines the contents of each type of normal shipping work, which is routine work in the corresponding warehouse, and uses the shipper code 801 and the shipping work group 802 as keys. This is a set of records in which the values of the group name 803, the shipping destination category 804, the product category category 805, and the shipping priority category 806 are associated with each other. Among these, the shipping destination category 804 has a value associated with the shipping destination 901 of the shipping destination master 214 described later with reference to FIG. The product category category 805 is a value associated with a product category category 1001 of a product category master 216 described later with reference to FIG. Further, the shipping priority classification 806 is a value indicating the priority related to the corresponding shipping work group.

  Next, FIG. 6 is a diagram showing a data configuration example of the shipping destination master 214 provided in the DB server 102 in the present embodiment. The shipping destination master 214 of the present embodiment uses the shipping destination classification 901 as a key, and a shipping code that uniquely indicates an operating company of the corresponding store, that is, a company code 902 that uniquely indicates a customer company, and a store that is an actual product shipping destination. This is a set of records in which each value of the destination code 903 is associated.

  FIG. 7 is a diagram illustrating a data configuration example of the product category master 216 included in the DB server 102 according to the present embodiment. The merchandise category master 216 of the present embodiment is a table that defines the category of merchandise to be shipped, and is a collection of records in which the merchandise category classification 1001 and each value of the merchandise category code 1002 are associated with each other. .

  FIG. 8 is a diagram illustrating a data configuration example of the numbering master 218 provided in the DB server 102 according to the present embodiment. The numbering master 218 of the present embodiment is a table in which a list of work management numbers to be assigned for each shipping work in a normal time or an emergency when receiving a shipping work instruction from the client terminal 104 is described. The numbering master 218 has a data configuration in which work management numbers are registered in ascending order as illustrated in FIG.

  FIG. 9 is a diagram illustrating a data configuration example of the user table 219 included in the DB server 102 according to the present embodiment. The user table 219 of the present embodiment is a table that stores information registered for user authentication regarding a user in charge of management who operates the client terminal 104. As illustrated in FIG. 10, the user table 219 is a collection of records associated with passwords using a user ID as a key.

---- Example procedure of work management method (normal time) ---

  Hereinafter, the actual procedure of the work management method in the present embodiment will be described with reference to the drawings. Various operations corresponding to the work management method described below are realized by a program that is read into a memory or the like and executed by the WEB / AP server 103 of the physical distribution management system 101 as a work management system. And this program is comprised from the code | cord | chord for performing the various operation | movement demonstrated below.

  FIG. 10 is a flowchart showing a processing procedure example 1 of the work management method in the present embodiment. Specifically, FIG. 10 is a sequence diagram showing an operation related to a normal shipment work instruction in the physical distribution management system 100. For the sake of explanation, in addition to the operation of the WEB / AP server 103 that is the execution subject of the work management method of the present embodiment, the operations of the DB server 102, the ordering server 107, and the client terminal 104 are also shown.

  Further, here, it is assumed that the management user described above operates the client terminal 104 to perform maintenance of the shipping work group master 212, the shipping destination master 214, and the product category master 216 in the DB server 102. .

  In this case, the client terminal 104 displays a login screen in response to a predetermined instruction received from the management user through the input interface, and issues a login request including authentication information such as the ID and password of the management user received on this screen. The WEB / AP server 103 is transmitted (s100).

  On the other hand, the WEB / AP server 103 executes authentication processing by comparing authentication information included in the login request with each record of the user table 219 in the DB server 102 (s101), and when the result is successful authentication. (S102: y), data of a predetermined master maintenance screen (held in advance in the storage device; hereinafter the same for each screen data) is returned to the client terminal 104 (s103).

  On the other hand, the client terminal 104 displays the above-mentioned master maintenance screen on the output interface, and any one of the shipping work group master 212, the shipping destination master 214, and the product category master 216, which are maintenance targets, is displayed on the master maintenance screen. The DB server 102 according to various instructions such as registration reception of the corresponding master, display of the contents of the corresponding master read from the DB server 102 in response to the selection, registration of a new record for the displayed corresponding master and change of the contents of the existing record, etc. A series of processes associated with maintenance such as process execution is executed (s104). Such a maintenance process is appropriately executed by a user in charge of management who determines when various masters need to be corrected, such as when a new customer is registered or when the form of shipping work is changed. In response to the master maintenance request from the client terminal 104, the DB server 102 executes the master update process (s105).

  On the other hand, in a situation where each master has an appropriate content through the master maintenance process as described above, the DB server 102 relates to a retail store under the customer company, for example, from the ordering server 107 of the customer company. The shipping request is received and registered in the shipping request table 211 (s106). For example, the shipping request registration process is repeated during a predetermined time such as one day, whereby a plurality of shipping requests are accumulated in the shipping request table 211. A specific example of the shipping request registered and stored in the shipping request table 211 is as already described with reference to FIG.

  After that, the client terminal 104 automatically detects the arrival of the corresponding timing by a timer function or the like that is generally provided in a computer device at an appropriate timing such as the business start time of each day in a warehouse, etc., or an instruction from a user in charge of management Is received at the input interface, and a normal shipping work instruction screen 414 (FIG. 4), which will be described later, is displayed on the output interface (s107). It transmits to 103 (s108).

  Further, the shipping work instruction receiving function 311 of the WEB / AP server 103 receives from the client terminal 104 the instruction contents of the management user on the normal shipping work instruction screen 414 described above, and generates the shipping work instruction data 313 (FIG. 13). The process is executed (s109), and this is transferred to the inventory allocation function 314 (s110). Details of step s109 described above will be described later.

  On the other hand, the inventory allocation function 314 in the WEB / AP server 103 obtains the above-described shipping operation instruction data 313, and determines the number of products in stock in the corresponding warehouse (the distribution management system 101 uses WMS as the planned shipment number of the products to be shipped indicated by this. After specifying the number of shipping instructions, which is the number of commodities that can be shipped, by matching with generally available inventory management data or the like, the sorting order setting function 315 is called (s111).

  Also, the sorting order setting function 315 of the WEB / AP server 103 determines the picking order and sorting order in the warehouse based on the number of shipping instructions specified in step s111 for the goods to be shipped, using the existing algorithm in WMS. Is set in the result screen 634 (FIG. 18) and returned to the client terminal 104 (s112), and the flow ends. On the other hand, the client terminal 104 displays the result screen 634 (s113).

  Here, the details of a series of processes accompanying the generation of the normal shipment work instruction data 313 via the above-described step s109, that is, the normal shipment work instruction screen 414 will be described. FIG. 11 is a flowchart showing a processing procedure example 2 of the work management method in the present embodiment. Specifically, a flowchart showing a normal processing procedure by the shipping work instruction receiving function 311 of the WEB / AP server 103. It is.

  In this case, the shipping work instruction receiving function 311 of the WEB / AP server 103 is set to the scheduled work date 402 and the shipper code 403 selected by the management user via the normal shipping instruction screen 414 displayed on the client terminal 104. , And / or the shipment work group code 404 is acquired (1501).

  A specific configuration example of the normal shipment work instruction screen 414 is as shown in FIG. The normal shipment work instruction screen 414 in the present embodiment includes a search unit 401 and a detail unit 405. The search unit 401 is an area in which an interface for a user in charge of management to specify an attribute of a shipping request that is a shipping instruction target is displayed. The scheduled operation date 402 and the shipper 403 corresponding to the shipping date from the warehouse. , And an interface that allows input or selection for each attribute of the shipping work group 404.

  In addition, the detail unit 405 has a shipping work instruction reception function 311 of the WEB / AP server 103 for each shipping work group regarding a common shipping request regarding the attribute designated by the user in charge of management in the interface of the search unit 401 described above. This is an area for displaying the collected records. Each value of the selection column 406, scheduled work date 407, shipper code 408, shipper name 409, shipping work group code 410, shipping work group name 411, number of slips 412 and planned shipping total 413 It is the structure which displays the record containing "in table format".

  Among these, the selection column 406 is an interface such as a check box for designating a record to be selected as a shipping instruction target by the user in charge of management. Of each record, the number of slips 412 is a value corresponding to the number of records that can be searched in the shipping request table 211 on the condition of the corresponding shipping work group (“B1”, “B2”, etc. in the example of FIG. 12). Is stored. This is because each shipment request in the shipment request table 211 is associated with one slip. The shipping schedule total 413 stores each record that can be searched in the shipping request table 211 on the condition of the above-described shipping work group, that is, the total value of the shipping schedule number indicated by each shipping request.

  Returning to the description of the flow of FIG. Following the above-described step 1501, the shipping work instruction reception function 311 of the WEB / AP server 103 stores the shipper code 403 and the shipping work group code 404 acquired in step 1501 in each record of the shipping work group master 212 in the DB server 102. Collation is performed, and among the records in the shipping work group master 212, the shipper code 801 and the shipping work group 802 are identified with the shipper code 403 and the shipping work group code 404 described above, and the shipping priority is determined from the identified records. The value of the category 807 is acquired (1502).

  Subsequently, the shipping work instruction receiving function 311 acquires each value of the shipping destination category 805 and the product category category 806 for the record whose shipping priority category 806 has the highest priority among the records specified in step 1502. (1503).

  Next, the shipping work instruction reception function 311 is a processing target in the above-described steps 1502 and 1503 and is specified by the shipper code 801 and the shipping work group 802 (the contents of each work request are aggregated, and the shipping work instruction is collected). In order to perform management with a work management number, an unused work management number such as “00000001” is acquired from the numbering master 218 (1504). Since the work management number indicated by each record of the numbering master 218 is deleted from the numbering master 218 when used, the numbering master 218 includes only records corresponding to unused work management numbers. Yes. Alternatively, unused management may be performed using a flag.

  Subsequently, the shipping work instruction reception function 311 performs a check against the shipping destination category 901 in each record of the shipping destination master 214 on the condition of the shipping destination category 804 acquired in step 1503, and obtains the value of the shipping destination code 903 from the corresponding record. Obtain (1505).

  In addition, the shipping work instruction reception function 311 checks the product category classification in each record of the product category master 216 on the condition of the product category classification 805 acquired in step 1503, and acquires the value of the product category code 102 from the corresponding record. (1506).

  Next, the shipping work instruction reception function 311 acquires the scheduled work date 402 and the shipper code 403 acquired in step 1501, the shipping destination code 903 acquired in step 1505, and the product category acquired in step 1506. Based on each value of the code 1002, a record that matches the same item among the records of the shipping request table 211 is specified, and the normal shipment work instruction data 313 is generated from the data included in the corresponding record, and the step is performed. The shipping work group code 410 acquired in 1501 is assigned and stored in the storage device 301 (1507). If there are a plurality of records specified in this step 1507, the shipping work instruction receiving function 311 counts the total number of the corresponding records as the number of slips, and the value of the planned shipping number among the data included in the corresponding records. And a normal shipment operation instruction data 313 including each value obtained by the aggregation processing is generated.

  A specific example of the normal shipment work instruction data 313 is as shown in FIG. The shipping work instruction data 313 is a collection of records in which various items 1202 are associated with the work management number 1101 obtained in step 1504 described above as a key.

  Subsequently, the shipping work instruction receiving function 311 receives a plurality of sets of the scheduled work date 402, the shipper code 403, and the shipping work group code 404 from the client terminal 104 in the above-described step 1501 (1508: y). The processing is returned to step 1502 described above, and the subsequent steps 1502 to 1507 are sequentially repeated. On the other hand, if a plurality of sets of the scheduled work date 402, the shipper code 403, and the shipping work group code 404 have not been received from the client terminal 104 in step 1501 described above (1508: n), the shipping work instruction receiving function 311 End the process.

---- Example procedure of work management method (emergency) ---

  FIG. 14 is a flowchart showing a processing procedure example 3 of the work management method in the present embodiment, specifically, a sequence diagram showing the operation of the emergency shipping work instruction 522 in the physical distribution management system 100. Here, unlike the above-described normal time, the DB server 102 receives a shipping request at an irregular timing from the ordering server 107 by a sudden delivery request on the same day, and registers this in the shipping request table 211. The flow to be executed will be described. Alternatively, a case may be assumed in which a shipping request that is not subject to a normal shipping operation instruction and remains in the shipping request table 211 is processed as an emergency shipping request.

  In such a case, the DB server 102 receives, for example, a shipping request related to same-day delivery for a retail store under the customer company from the ordering server 107 of the customer company, and registers this in the shipping request table 211 (s200). Although it is an urgent shipping request, its data items and configuration are the same as those in the above-described normal shipping request.

  For example, when the DB server 102 monitors the registration of the shipping request at such irregular timing and detects the registration of the shipping request, that is, when it recognizes that the emergency shipping request has been received, It is preferable to notify the client terminal 104 of the fact. The client terminal 104 receives the notification or receives an instruction from the user in charge of management through the input interface, displays the emergency shipping work instruction screen 522 (FIG. 16) on the output interface (s201), and performs an emergency shipping work. A specification relating to the instruction is received from the user in charge of management and is transmitted to the WEB / AP server 103 (s202). Of course, since this is an emergency shipping request, not only WEB-based data registration processing but also a case where a telephone contact is directly received from a client company to an administrative user, in such a case, the administrative user The user inputs an output instruction on the emergency shipping work instruction screen 522 through the input interface of the client terminal 104.

  Further, the shipping work instruction receiving function 311 of the WEB / AP server 103 receives the instruction contents of the user in charge of management on the emergency shipping work instruction screen 522 described above from the client terminal 104, and the emergency shipping work instruction data 313 (FIG. 17). Is generated (s203), and this is transferred to the inventory allocation function 314 (s204). Details of step s203 described above will be described later.

  On the other hand, the inventory allocation function 314 in the WEB / AP server 103 obtains the above-mentioned emergency shipping operation instruction data 313 and determines the number of products in stock in the corresponding warehouse (the distribution management system 101 determines the planned shipment number of products to be shipped indicated by this. After specifying the number of shipping instructions, which is the number of commodities that can be shipped, by matching with inventory management data or the like generally provided as WMS, the sorting order setting function 315 is called (s205).

  Further, the sorting order setting function 315 of the WEB / AP server 103 determines the picking order and sorting order in the warehouse based on the number of shipping instructions specified in step s205 with respect to the shipping target product, using the existing algorithm in WMS. Is set in the result screen 634 (FIG. 18) and returned to the client terminal 104 (s206), and the flow ends. On the other hand, the client terminal 104 displays the result screen 634 (s207).

  Since the normal shipment work instruction data 313 shown in FIG. 14 and the emergency shipment work instruction data 313 shown in FIG. 17 have the same layout, the inventory allocation function 314 performs the normal allocation and emergency It is possible to carry out inventory allocation without distinguishing between them.

  Here, the details of a series of processes accompanying generation of the emergency shipping work instruction data 313 via the above-described step s203, that is, the emergency shipping work instruction screen 522 will be described. FIG. 15 is a flowchart showing a processing procedure example 4 of the work management method in the present embodiment. Specifically, a flowchart showing a processing procedure in an emergency by the shipping work instruction receiving function 311 of the WEB / AP server 103. It is.

  In this case, the shipping work instruction reception function 311 of the WEB / AP server 103 uses the condition (work) selected by the manager in charge via the emergency shipping instruction screen 522 displayed on the client terminal 104 in step s201 described above. (Schedule date 502, shipper 503, company 504, shipping destination 505, product 506, product category 507, slip 508, slip row 509), and urgent shipping request corresponding to the conditions is sent to the DB server. The information is read from 102 and displayed on the emergency shipping instruction screen 522, and the values of the shipper code 512, the company code 514, the product code 518, the slip NO 516, and the slip row No 517 are acquired (1601). Alternatively, instead of acquiring each value from the urgent shipment request according to the above-described conditions, each time the urgent shipment request is stored in the DB server 102, the corresponding shipment request is displayed on the emergency shipment instruction screen 522. Each of the above values may be acquired from this shipping request.

  A specific configuration example of the emergency shipment work instruction screen 522 is as shown in FIG. The emergency shipment work instruction screen 522 in the present embodiment includes a search unit 501 and a specification unit 510. Of these, the search unit 501 is an area in which an interface for a user in charge of management to specify an attribute of a shipping request to be an urgent shipping instruction target is displayed, and a scheduled work date 502 corresponding to a shipping date from the warehouse. The interface includes an interface for inputting or selecting each attribute such as a shipper 503, a company 504, a shipping destination 505, a product 506, a product category 507, a slip 508, and a slip row 509.

  The detail unit 510 is an area in which the shipping work instruction reception function 311 of the WEB / AP server 103 displays the contents of an urgent shipping request corresponding to the attribute designated by the management user in the interface of the search unit 501 described above. Each value of the selection column 511, the shipper code 512, the shipper name 513, the company code 514, the company name 515, the slip No. 516, the slip line 517, the product code 518, the product name 519, the shipping destination 520, and the planned shipping number 521 It is the structure which displays the record containing "in table format". Among these, the selection column 511 is an interface such as a check box for designating a record to be selected by the user in charge of management as a target of an emergency shipping instruction.

  Returning to the description of the flow of FIG. Following the above-described step 1601, the shipping work instruction receiving function 311 of the WEB / AP server 103 manages the urgent shipping request to be processed in the above-described step 1601 with the work management number. An unused work management number, for example, “00000003” is acquired from (1602).

  Further, the shipping work instruction receiving function 311 selects one of the urgent shipping requests whose values have been acquired in the above-described step 1601 (1603). If there is only one urgent shipment request whose value is acquired in step 1601, the corresponding item is of course selected.

  Subsequently, the shipping work instruction reception function 311 sets “emergency” as the shipping work group for the shipper code 512, the company code 514, the product code 518, the slip NO 516, and the slip row 517 of the matter selected in the above step 1603. “99” indicating “1” and “emergency 1” as the shipping work group name are assigned, and emergency shipping work instruction data 313 is generated and stored in the storage device 301 (1604).

  FIG. 17 is a diagram illustrating a data configuration example of the emergency shipping work instruction data 313 included in the DB server 102. The emergency shipment work instruction data 313 is a collection of records in which various items 1202 are associated with the work management number 1201 obtained in step 1602 as a key. Note that the normal shipment work instruction data 313 shown in FIG. 13 and the emergency shipment work instruction data 313 shown in FIG. 17 are all the same items because they are data to be passed to the inventory allocation function 314.

  Next, the shipping work instruction reception function 311 has a plurality of urgent shipping requests whose values have been acquired in the above-described step 1601, and those that have not been processed remain (for example, unprocessed flag management is performed for each shipping request). (1605: y), the process is returned to step 1603, and the subsequent steps 1603 to 1605 are sequentially repeated. On the other hand, when there is one urgent shipment request whose value is acquired in step 1601 described above (1605: n), the shipping work instruction reception function 311 ends the process.

  FIG. 18 shows a shipping operation inquiry screen (result screen) 634 provided in the client terminal 104. The shipping operation inquiry screen 634 according to the present embodiment includes a shipping operation inquiry screen (basic) 601 and a shipping operation inquiry screen (details) 602. The shipping operation instruction data 313 ( The screen is displayed in response to a request from the management user.

  Among these, the search unit 603 on the shipment work inquiry screen (basic) 601 manages the condition designation for each of the scheduled work date 604, the shipper 605, the company 606, and the shipment work group 607 for specifying the shipment work instruction data 313. It has an interface to accept from the user in charge. On the other hand, the detail section 608 includes a selection field 609 such as a check box, work management number 610, scheduled work date 611, shipper code 612, company code 613, shipping work group code 614, shipping work group name 615, scheduled shipping total 616, A record in which the shipment instruction total 617 and the shortage total 618 are associated with each other is shown in a table format. The shipping work instruction reception function 311 displays a shipping work inquiry screen (details) 602 in response to pressing of the detail button 680 for the shipping work instruction data checked by the user in charge of management in the selection field 609 described above. Detailed information of the corresponding shipping operation instruction data is displayed on the shipping operation inquiry screen (details) 602.

  The search unit 619 in the shipping work inquiry screen (details) 602 is an area for displaying the scheduled work date 620, the shipper 621, and the shipping work group 622 in the corresponding shipping work instruction data 313 checked in the selection field 609. . The detail unit 623 also includes the work management number 624, the slip No. 625, the slip line 626, the product code 627, the product name 628, the shipping destination code 629, the product category 630, the planned shipping number 631, the shipping operation instruction data 313. This is an area for displaying each value of the instruction number 632 and the shortage number 633.

  The user in charge of management views these shipping operation inquiry screens 601 and 602 on the client terminal 104 and finally confirms the contents of the shipping operation instruction.

  Although the best mode for carrying out the present invention has been specifically described above, the present invention is not limited to this, and various modifications can be made without departing from the scope of the invention.

  According to this embodiment, in the distribution and warehouse management system in the retail industry, on the premise of the common inventory allocation function in the normal time and the emergency time, the daily normal shipping work instruction and the emergency shipping work instruction are provided. Although it is parallel, it can be clearly distinguished and executed efficiently. Even a worker who performs each work according to such a normal shipping instruction and an emergency shipping instruction can easily recognize each shipping instruction and can proceed with each work separately without complication of the instruction. That is, an increase in work efficiency of each worker and shipping management with higher accuracy are achieved together.

  On the other hand, retail stores that receive deliveries from such warehouses, etc., request the warehouse for the distribution of hot selling products that differ from store to store, for example, as a normal shipping operation, while increasing the ability to attract customers, such as opening new stores and special sales. By requesting the warehouse for the same day delivery work according to the various measures aimed at, the warehouse side can easily realize flexible inventory management, making it difficult to miss sales opportunities.

  Therefore, it is possible to clearly distinguish and execute the shipping instructions at the normal time and the emergency time in the warehouse etc. in parallel.

  At least the following will be clarified by the description of the present specification. That is, in the work management system according to the present embodiment, the arithmetic device, in the process of displaying the product shipment request on the display device in association with the emergency shipment work, out of each product shipment request in the shipment request table. A product shipment request that has not been aggregated or a product shipment request obtained at a predetermined timing from a predetermined terminal or input device may be displayed on a display device in association with an emergency shipping operation.

  According to this, a product shipment request transmitted from a customer at a time other than the periodic timing when the product shipment request is stored in the shipment request table, that is, an urgent timing is sent to the client terminal of the customer or an emergency telephone contact. It can be obtained from an input device that has been input by an administrator who has received it, classified as an urgent shipping operation, and presented as an object of a shipping operation instruction.

  In the work management system according to the present embodiment, the computing device performs work management in accordance with a predetermined rule for each shipping work in a normal time or an emergency time when the shipping work instruction is received when the shipping work instruction is received by the input device. A number is assigned, and the assigned work management number is associated with the contents of the normal or emergency shipping work corresponding to the relevant shipping instruction, and the process of outputting to a predetermined inventory allocation device is executed. It is good also as.

  According to this, the shipping work instruction can be explicitly specified and distinguished by the work management number. Note that the data output to the inventory allocation device can be specified by the work management number in both normal and emergency situations, and the data items themselves are common. There is no need to configure each of the functions and interfaces in. As an administrator of a warehouse or the like, the instruction operation itself can be performed in common while recognizing the distinction between the normal time and the emergency on the interface for instructing the shipping operation.

  Further, in the work management method of the present invention, when the computer system displays the product shipment request on the display device in association with an emergency shipment operation, the aggregation is performed among the product shipment requests in the shipment request table. The merchandise shipment request that has not been made or the merchandise shipment request obtained at a predetermined timing from a predetermined terminal or input device may be displayed on the display device in association with an emergency shipping operation.

  Further, in the work management method of the present embodiment, when the computer system receives the shipping work instruction with the input device, the computer system follows a predetermined rule for each shipping work in a normal time or an emergency when the shipping work instruction is received. A work management number is assigned, and the given work management number is associated with the contents of the normal or emergency shipping work corresponding to the relevant shipping instruction and output to a predetermined inventory allocation device. You may do that.

100 Logistics / Warehouse Management System 101 Logistics Management System (Work Management System)
102 DB server 103 WEB / AP server 104 Client terminal 105 Network 106 Core system 107 Order server 211 Shipping request table 212 Shipping work group master 214 Shipping destination master 216 Product category master 218 Numbering master 219 User database 201, 301 Storage device 202 , 302 Program 203, 303 Memory 204, 304 CPU (arithmetic unit)
205, 305 Communication device 210 Database

Claims (6)

A storage device for storing a master table of normal shipping operations defined in accordance with a shipping destination and a product category of a product, and a shipping request table storing a product shipping request from a customer;
Each merchandise shipment request in the shipment request table is collated with the master table, the contents of shipment are aggregated and displayed on a display device for each normal shipment operation, and the aggregation among the merchandise shipment requests in the shipment request table is performed. The product shipment request that was not made is displayed on the display device in association with the emergency shipment operation, and the shipping operation instruction is entered with each normal or emergency shipment operation displayed on the display device as a work management unit. An arithmetic unit that executes processing for receiving the contents of the normal or emergency shipping work corresponding to the relevant shipping instruction and outputting the contents of the shipping operation to a predetermined inventory allocation device,
A work management system comprising: The arithmetic unit is
In the process of displaying the product shipment request in association with an emergency shipment operation on the display device, the product shipment request that has not been aggregated among the product shipment requests in the shipment request table, or a predetermined terminal or input device The product shipment request obtained at a predetermined timing from the display is displayed on the display device in association with the emergency shipping operation.
The work management system according to claim 1. The arithmetic unit is
When receiving the shipping work instruction with the input device, a work management number is assigned according to a predetermined rule for each normal or emergency shipping work received the shipping work instruction, and the given work management number and the corresponding Corresponding to the contents of the shipping operation at the normal time or the emergency time corresponding to the shipping instruction, to execute processing to output to a predetermined inventory allocation device,
The work management system according to claim 1. A computer system comprising a storage device for storing a master table of normal shipping operations defined according to a shipping destination and a product category of a product, and a shipping request table storing a product shipping request from a customer,
Each merchandise shipment request in the shipment request table is collated with the master table, the contents of shipment are aggregated and displayed on a display device for each normal shipment operation, and the aggregation among the merchandise shipment requests in the shipment request table is performed. The product shipment request that was not made is displayed on the display device in association with the emergency shipment operation,
The input device accepts a shipping operation instruction with each shipping operation displayed on the display device as a unit of work management at the normal time or emergency time, and the contents of the normal or emergency shipping operation corresponding to the corresponding shipping instruction are predetermined. Output to the inventory allocation device
A work management method characterized by that. The computer system is
In the process of displaying the product shipment request in association with an emergency shipment operation on the display device, the product shipment request that has not been aggregated among the product shipment requests in the shipment request table, or a predetermined terminal or input device The product shipment request obtained at a predetermined timing from the display is displayed on the display device in association with the emergency shipment work.
The work management method according to claim 4. The computer system is
When receiving the shipping work instruction with the input device, a work management number is assigned according to a predetermined rule for each normal or emergency shipping work received the shipping work instruction, and the given work management number and the corresponding Executing a process of associating with the contents of the shipping operation at the normal time or the emergency time corresponding to the shipping instruction and outputting to the predetermined inventory allocation device;
The work management method according to claim 4.

Images