JP3733447B2 - Picking list creation system, picking list creation method, and picking list creation program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a picking list creation system, a picking list creation method, and a picking list creation program at the time of delivery in a distribution system for publications.
[0002]
[Prior art]
The distribution system for publications is a system that functions mainly by a distribution warehouse so that merchandise such as books can be smoothly delivered from publishers (print bookbinding) to bookstores and general customers.
[0003]
The distribution system will be described with reference to FIGS. Orders for publications include orders from agency stores (agency orders), orders from agency stores (publishing VAN orders) via publishing VAN (Value-Added Network), orders received directly from bookstores (bookstore orders) , Orders received from brokers or bookstores (list orders), telephone orders from bookstores (telephone orders), orders sent from the dealership (strip orders), e-mail orders (text orders) , Orders to fill up the empty display shelf in the bookstore (replenishment orders), orders for customer orders to request a specific book from the bookstore (customer order), direct orders from general customers (reader orders, Web orders) ), Etc., there are various orders and order forms. Here, the case where the agency places an order based on an order from a bookstore, which is the most typical example (order with bookstore information), will be described.
[0004]
Product information to be distributed is provided from the publisher to the distribution warehouse (s1). Thereafter, when printing and bookbinding of the product is completed at the printing bookstore, distribution information is provided from the publisher (s2), and the product is carried from the printing bookstore and warehousing is performed at the distribution warehouse (s3). . Next, based on an order from a bookstore / general customer, an order is received from an agency (s4), and a distribution work is performed in the distribution warehouse based on the contents of the order (s5). Further, the goods package for which the delivery operation has been completed is delivered to the agent store by the truck (s6), and the goods are further delivered to the bookstore that has ordered, and the delivery of the ordered goods is completed (s7).
[0005]
Next, of the work procedures in the distribution warehouse, details of procedures conventionally performed from order receipt (s4) to delivery (s6) will be described with reference to FIG. In this case, it is necessary to pick up, deliver, and deliver the products ordered from multiple dealers and bookstores out of tens of thousands of items in stock. Inventories have been devised for inventory management, such as numbering each shelf (warehouse shelf) and managing the location of each product with that shelf number, checking the quantity of goods in and out, and managing the stock quantity of each product. Has been.
[0006]
First, at the stage of receiving an order (s91), the person in charge looks at the contents of the order and determines a large order or a small order (s92). The order here is an order from one agency to one bookstore. A large order is an order of a predetermined amount or more that requires one or more cardboard cases (hereinafter referred to as a case), and a small order is a single order. A small order that does not satisfy the case.
[0007]
Based on the determination in step s92, the person in charge classifies the order details into large orders and small orders and inputs the order details as order data (s93).
Next, a picking list is generated at a predetermined timing, and the contents are output by the printer (s94, 97). In step s94, the product details corresponding to one order specification are set as one picking list, and the picking list is output in the order of input as a large order. In step s97, product details corresponding to a plurality of order details from one agency are used as one picking list, and the picking list is output in the order in which the orders were entered as a small order. The predetermined timing is a timing determined by calculating backward from the shipping timing, and is usually performed once in the morning and once in the afternoon.
[0008]
In the case of the picking list for large orders (s94), the warehouse worker picks up the target product stocked on the warehouse shelf based on the picking list (s95), and the product is supplied from the ordering agency. Store in a case that is packed (s96). Depending on the agency, there may be no case supply. In that case, the goods are packed together in a quantity that can be stored in one case and tied together with a string for packing. This is called bundling. In addition, along with the packing operation, cases or bundles that have been packed are stacked on a pallet prepared for each destination (for each agency).
[0009]
In the case of the picking list for small orders (s97), a strip for each product (book) corresponding to the details of the picking list is output from the printer (s98), and the warehouse worker is stocked on the warehouse shelf based on the picking list. After picking up the target product (s99), the strip output in step s98 is inserted for each product (s9a). Here, the strip is an identification tag such as a tag attached to each product in the case of a small order, and is used when the product is distributed, and the strip is taken out from the product when the product arrives at the bookstore.
Next, the product into which the strip is inserted is stored in a bucket supplied from the agency that is the orderer and packed (s9b). A bucket is a resin container that can store a predetermined amount of merchandise. Depending on the agency, there may be no bucket supply. In that case, products are bundled together with a string so that they can be stored in one case, and packed together. In addition, along with the packing operation, buckets or bundles for which packing has been completed are stacked on a pallet prepared for each destination (for each agency).
Packing is carried out for all of the large order order picking list and the small order order picking list and all cases, buckets, and bundles are loaded on the pallet.
[0010]
Next, the case, bucket, and pallet on which the bundles are loaded are loaded (s9c), delivered to a predetermined agency and unloaded, and the delivery is completed (s9d). ).
[0011]
Recently, by picking up various publications during picking operations during shipping operations, inspections are performed while weighing, so that picking mistakes can be reduced and the picking efficiency can be improved without overlooking the quantity. A publication picking system has also been proposed (see, for example, Patent Documents 1 and 2).
[0012]
[Patent Document 1]
JP-A-8-198416
[Patent Document 2]
Japanese Patent Laid-Open No. 9-263311
[0013]
[Problems to be solved by the invention]
However, even though such a system is efficient as a single picking operation, the viewpoint of the entire shipping operation and the entire distribution system is lacking, and as a result, the inefficiency problems of conventional distribution systems remain. .
In other words, when loading the packed goods at the end of the delivery operation on the pallet, when loading the pallet with cases, buckets, and bundles loaded onto the truck, This is an inefficient problem that occurs during sorting work. The problems in each case will be described below.
[0014]
A problem in the case of dealing with a large order will be described with details of the state of each procedure shown in FIG.
23 to 26 are schematic diagrams showing the states of the respective stages from immediately after the order is inputted (s93) to the stage of loading the truck (s9c).
FIG. 23 shows a state in which the received order details T91 immediately after the order input in step s93 is stored in the order database 93b in the order of input. Next, in step s94, as shown in FIG. 24, picking lists L91 to L95 based on the order details T91 are output. In this case, the picking list is output in the input order, and a picking list is generated for each order.
Next, picking work is performed in the order of picking lists L91 to L95 in step s95, and packing work is performed in the order of picking lists L91 to L95 in step s96 in the form of simultaneous progress therewith. This state is shown in FIG. Here, the packing state by the case is shown for convenience, but the same applies to the case of binding. Next, the cases packed at the end of the packing operation are sequentially loaded on the pallet.
[0015]
In this case, when the cases are stacked on the pallet in the order in which they are completed, as shown in FIG. 26, the cases for the same agency A (C91, C93 to C95) are divided into two pallets and stacked. As a result, if it is loaded as it is, the transportation efficiency has deteriorated. In this way, the order input order is reflected in the shipping order as it is.
[0016]
In order to prevent such a situation, the person in charge actually inputs a certain amount of information for each agency in the order entry step (s93), but there is a limit in nature. Also, while looking at the situation of packing at the delivery work site, we worked as much as possible to load cases for the same agency on the same pallet, but there was a traffic jam and other agency at the delivery work site. It was the cause of an accident involving baggage for stores. Also, waiting for the case for the same agency A to accumulate, and waiting for the case for the agency B to accumulate, necessitated a space for placing the pallet for that, and it was also necessary to widen the shipping work site .
[0017]
Further, when the pallets P91 to P93 are swept out in this order of delivery, the loading operation is complicated because the loading on the truck is carried out by the dealer.
[0018]
Further, in the case of a case, since the agency stores the cases in the same state, they are shipped to the bookstore. Therefore, the delivered cases are grouped according to the route of delivery from the agency to the bookstore. Under such a system, for example, when the agency A receives the delivery in the state of the pallets P91 and P93 in FIG. 26, while looking at the delivery note, in the pallet P93, the cases C94 and C95 for the bookstore A and for the bookstore C It is necessary to divide it into case C93, and for the bookstore a, it is necessary to work with the case C91 of another pallet P91, which causes troublesome work at the agency store, which is an inefficient part of the overall logistics there were.
[0019]
Note that the large order and the small order are discriminated in consideration of the size of the product based on the number of products of the ordered product, and solely based on the empirical judgment of the person in charge. Therefore, for example, in the case of an encyclopedia with a large book size, even if the order is about 3 volumes, the person in charge at the distribution warehouse judges that it is a large order and corresponds to one case. However, there were many cases where the agency had to carry out extra work to take it out of the case and treat it with other products for small shops. Also, in the worst case, there is a problem that the data is unmatched with the delivery data in terms of data management at the agency and returned.
[0020]
Next, problems in the case of dealing with small orders will be described with details of the states of the respective procedures shown in FIG.
FIGS. 27 to 29 are schematic diagrams showing the state of each stage from immediately after an order is received (s93) to the stage of loading on a truck (s9b).
FIG. 27 shows a state in which the received order details T92 immediately after the order input in step s93 is stored in the order database 93b in the order of input. Next, in step s97, picking lists L96 to L98 based on the order details T92 are output as shown in FIG. In this case, in the order in which the order details are input, the order details are collected for each agency, and then the picking list is generated in order. Next, in step s99, picking operations are performed in the order of picking lists L96 to L98, and strips are inserted in steps s9a and packing operations in step s9b are performed in the order of picking lists L96 to L98 simultaneously with the picking lists L96 to L98. This state is shown in FIG.
[0021]
In this case, since the product b for the same agency A is divided into two buckets and stored, if it is loaded and loaded on the pallet as it is, the transportation efficiency has deteriorated. Thus, the state in which the order input order is directly reflected in the shipping order is the same as in the case of a large order, and the problem caused by this is also the same.
[0022]
Here, considering a case where a general customer orders a bookstore (ho) (customer order), the customer order item O has conventionally been a small order, and it is necessary to insert a strip into the product. Since it was included in the order, it was stored in the bucket B93 as shown in FIG.
In the case of buckets, the agent b sorts and distributes the products b in the delivered buckets by bookstore and sends them to the bookstore. In the event that it was not settled, it was to be kept at the agency until the predetermined amount was reached. Therefore, this customer order O often takes days to deliver to the bookstore, and it is in a state inconsistent with the situation that general customers want to obtain the customer order O as soon as possible and order it from the bookstore. .
[0023]
The present invention has been made in view of the above problems in the prior art, and is a picking list creation system and a picking system that can improve not only the efficiency of the work of issuing a publication in a distribution warehouse, but also the efficiency of the entire distribution system. It is an object to provide a list creation method and a picking list creation program.
[0024]
[Means for Solving the Problems]
  The picking list creation system according to the invention of claim 1 provided to solve the above-described problem is a main CPU connected to a network line so as to be able to communicate with a publisher and a distributor, and can transmit and receive data to and from the CPU. An order database that stores order details data for a specific book store that includes bibliographic information and order quantity information for order publications from the agency store, and import store data that stores the order publication destination With the master,A bibliographic master storing bibliographic data including combination data of bibliographic information and subject data of publications provided by a publisher, a reference book number table storing coefficient data for each subject of the publication, and a predetermined threshold A memory that stores a delivery master that stores data, and an output device that receives data from the CPU and outputs a picking list, wherein the CPU includes data in one order detail data stored in the order database. The item data stored in the bibliographic master is specified from the bibliographic information of the order publication, and the coefficient data stored in the reference book number table is specified based on the subject data, and the coefficient data and the order publication Calculate the number of converted books by multiplying the number of copies to be ordered, calculate the total number of converted books in the one order detail data, and calculate the total number of converted books and the predetermined number When the total number of converted books is greater than the threshold, it is determined that the order is large, and when the total number of converted books is less than the threshold, it is determined that the order is small. And the order determination data andTotal data of the converted book volume and agency data that has been orderedIs generated as a header information, and a delivery data group of large orders is obtained from the order determination data stored in the header information of each delivery data for a delivery data group in which a plurality of the delivery data is collected. And the data collection group that is divided into the large orders.The agency data as the first priority item, and the total data of the converted number of books as the second priority itemThe outgoing data group is sorted using the key as the key, and the outgoing data is sorted in the order of the outgoing data after the sorting process for the outgoing data group divided into large orders.EveryThe content of the predetermined item is displayed on the output device as a picking list.
[0025]
  With this system,Luggage packaged based on the created picking list is objectively divided into large orders and small orders, and can be packed with an appropriate amount of products, and can be used to improve the efficiency of the entire logistics system. A list can be generated. In other words, it is possible to perform efficient packing work without the need for extra packing work space with the minimum number of pallets simply by loading the packed goods based on the created picking list on the pallet in that order. Become. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
  Here, the output device is a printer that prints a predetermined format and instruction content as a document, but may be an image display device that displays the format and instruction content on a screen such as a CRT or a liquid crystal display.
  Further, the threshold value may be set based on the capacity of the packaging container used for large orders.
  Note that the sort processing and picking list output may also be executed for the outgoing data group classified into small orders.
[0026]
  The picking list creation system according to the invention of claim 2 provided to solve the above-mentioned problems is a main CPU connected to a network line so as to be able to communicate with a publisher and a distributor, and data can be transmitted to and received from the CPU. An order database that stores order details data for a specific book store that includes bibliographic information and order quantity information for order publications from the agency store, and import store data that stores the order publication destination Stores bibliographic data including combination data of bibliographic information and subject data of publications provided by the publisher, bookstore master storing bookstore data and shipping route data from the agency to the bookstore Bibliographic masters, reference book count tables storing coefficient data for each subject of publications, and issue masters storing predetermined threshold data. And an output device that receives data from the CPU and outputs a picking list, and the CPU uses the bibliographic information of order publications in one order detail data stored in the order database. The item data stored in the master is specified, the coefficient data stored in the reference book number table is specified based on the subject data, and the converted book number is calculated by multiplying the coefficient data and the order number of the order publication. Then, the total number of converted books in the one order detail data is obtained, the magnitude relation between the total number of converted books and the predetermined threshold value is compared, and if the total number of converted books is larger than the threshold value, a large order is received. If the total number of converted books is equal to or less than the threshold, it is determined to be a small order, and the order details data includes the order determination data.Order agency data that has been ordered, and route data from the agency to the bookstore corresponding to the order details dataIs generated as a header information, and a delivery data group of large orders is obtained from the order determination data stored in the header information of each delivery data for a delivery data group in which a plurality of the delivery data is collected. And the data collection group that is divided into the large orders.The agency data as the first priority item and the shipping route data as the second priority itemThe outgoing data group is sorted using the key as the key, and the outgoing data is sorted in the order of the outgoing data after the sorting process for the outgoing data group divided into large orders.EveryThe content of the predetermined item is displayed on the output device as a picking list.
[0027]
  With this system, packages packed based on the created picking list are objectively divided into large orders and small orders.Packing is possible with an appropriate amount of productsIn addition, it is possible to generate a picking list that can improve the efficiency of the entire logistics system.In other words, simply loading the packages packed based on the created picking list onto the pallet in that order will not only produce a pallet that can be delivered for each agency, but also after delivery to the agency. In this case, it is very easy to sort the packages according to the shipping route at the agency, and the efficiency of the entire logistics can be improved.
The present invention can be applied to both large orders and small orders. Further, it is preferable that the shipping routes are encoded and sorted by their code symbols and numbers.
Furthermore, the invention according to claim 1 and the invention according to claim 2 may be combined to perform the sort process in the order of the large number of converted books before the sort process in the order of the shipping route.
[0028]
  Also, as a picking list creation system according to the present inventionA main CPU that is connected to a network line so as to be able to communicate with the publisher and the agency, and includes bibliographic information and order quantity information of an order publication from the agency that is connected to the CPU so that data can be transmitted and received. An order database that stores order details data for bookstores, a delivery master that stores delivery data for order publications, and store route data from the store to the bookstore. The bibliographic master that stores the bibliographic data that includes the combination of the bibliographic information and subject data of the publications provided by the publisher, and the reference volume number table that stores the coefficient data for each subject of the publication And an output device that receives data from the CPU and outputs a picking list. And the CPU includes, as header information, the order store data of the large order including the order publication data with the strip output stored in the order database, and the order store data that has been ordered and the partial output data of the strip output. The output data added as is generated, and for the output data group formed by collecting a plurality of the output data, the output data group is sorted by using a part of the strip output stored in the header information of each output data as a key, The delivery data group is sorted using the agency store data stored in the header information of each delivery data as a key, and the contents of predetermined items of the delivery data are selected as a picking list in the order of the delivery data after the sort processing for the delivery data group. Display on the output deviceYou may do.
[0029]
With this system, when packing is performed based on the created picking list, it is possible to reliably respond to customer requests for general customers in a short time.
Order publications with strip output included in the order details data for large orders are customer orders, and are attached to labels attached to packages such as cases and shipment specifications sent with packages. It is only necessary to indicate that the order is included.
[0030]
  Claims provided to solve the problems3The picking list creation method according to the invention uses the order detail data for a specific bookstore including bibliographic information of the order publication from the agency store and the order quantity information of the order publication, and the inventory publication of the distribution warehouse In the picking list creation method for instructing the pick-up of the order publication by the agency from among, the item data is identified from the bibliographic information of the order publication in the order details data, and the coefficient identified based on the item data Multiplying the data and the number of copies of the ordered publication to calculate the number of converted books and calculating the total number of converted books in the order details data, and the magnitude relationship between the total number of converted books and the predetermined threshold If the total number of converted books is greater than the threshold, it is determined that the order is large, and if the total number of converted books is less than the threshold, the order is determined as a small order. And-flops, and the orders judgment data in the order item dataTotal data of the converted book volume and agency data that has been orderedA delivery data generation step for generating delivery data to which header information is added, and a delivery data group formed by collecting a plurality of the delivery data, from the order determination data stored in the header information of each delivery data, The step of dividing into an outgoing data group of orders and an outgoing data group of small orders, and the outgoing data group divided into large ordersThe agency data as the first priority item, and the total data of the converted number of books as the second priority itemSort processing step for sorting the outgoing data group using as a key, and outgoing data in the order of outgoing data after the sorting processing for the outgoing data group divided into large ordersEveryAn output step of outputting the contents of the predetermined item as a picking list.
[0031]
  This wayThe packages packed based on the created picking list can be objectively classified into large orders and small orders, and a picking list that can improve the efficiency of the entire logistics system can be generated. In other words, it is possible to perform efficient packing work without the need for extra packing work space with the minimum number of pallets simply by loading the packed goods based on the created picking list on the pallet in that order. Become. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
Note that the sort processing and picking list output may also be executed for the outgoing data group classified into small orders.
[0032]
  Claims provided to solve the problems4The picking list creation method according to the invention uses the order detail data for a specific bookstore including bibliographic information of the order publication from the agency store and the order quantity information of the order publication, and the inventory publication of the distribution warehouse In the picking list creation method for instructing the pick-up of the order publication by the agency from among, the item data is identified from the bibliographic information of the order publication in the order details data, and the coefficient identified based on the item data Multiplying the data and the number of copies of the ordered publication to calculate the number of converted books and calculating the total number of converted books in the order details data, and the magnitude relationship between the total number of converted books and the predetermined threshold If the total number of converted books is greater than the threshold, it is determined that the order is large, and if the total number of converted books is less than the threshold, the order is determined as a small order. And-flops, and the orders judgment data in the order item dataOrder agency data that has been ordered, and route data from the agency to the bookstore corresponding to the order details dataA delivery data generation step for generating delivery data to which header information is added, and a delivery data group formed by collecting a plurality of the delivery data, from the order determination data stored in the header information of each delivery data, The step of dividing into an outgoing data group of orders and an outgoing data group of small orders, and the outgoing data group divided into large ordersThe agency data as the first priority item and the shipping route data as the second priority itemSort processing step for sorting the outgoing data group using as a key, and outgoing data in the order of outgoing data after the sorting processing for the outgoing data group divided into large ordersEveryAn output step of outputting the contents of the predetermined item as a picking list.
[0033]
  By this method, it is possible to generate a picking list capable of improving the efficiency of the entire physical distribution system after objectively classifying packages packed based on the created picking list into large orders and small orders.In other words, simply loading the packages packed based on the created picking list onto the pallet in that order will not only produce a pallet that can be delivered for each agency, but also after delivery to the agency. In this case, it is very easy to sort the packages according to the shipping route at the agency, and the efficiency of the entire logistics can be improved.Note that the sort processing and picking list output may also be executed for the outgoing data group classified into small orders.
Further, it is preferable that the shipping routes are encoded and sorted by their code symbols and numbers.
Further, the invention according to claim 3 and the invention according to claim 4 may be combined, and the sorting process in the descending order of the number of converted books may be performed before the sorting process in the order of the shipping route.
[0034]
  Sorting process aboveTwo specific examples of are shown below. In addition, since all are the same until the said order determination step, the subsequent steps are shown.
(Specific example 1)
  A delivery data generation step of generating delivery data in which the total data of the converted book volume, the order determination data, and the agency data that has been ordered are added as header information to the order detail data;
  A delivery data group comprising a plurality of delivery data is classified into a delivery data group for large orders and a delivery data group for small orders based on the order determination data stored in the header information of each delivery data. Sort processing steps;
  A second sort processing step for sorting the outgoing data group in descending order of the number of converted books for the outgoing data group classified into the large order;
  A third sorting step of sorting the outgoing data group using the agency data stored in the header information of the outgoing data as a key;
  It is set as the output step which outputs the predetermined item content of delivery data as a picking list | wrist in order of the delivery data after a 3rd sort process about the said delivery data group.
[0035]
According to this method, it is possible to efficiently pack without the need for extra packing work space with the minimum number of pallets by simply loading the packages packed based on the created picking list on the pallets in that order. Work becomes possible. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
[0036]
(Specific example 2)
A delivery in which the order determination data, the agency data that has been ordered, the specified bookstore data provided from the agency, and the shipping route data from the agency to the specified bookstore are added as header information to the order details data Issue data generation step to generate data,
A delivery data group comprising a plurality of delivery data is classified into a delivery data group for large orders and a delivery data group for small orders based on the order determination data stored in the header information of each delivery data. Sort processing steps;
A second sort processing step for sorting the shipping data group classified into the large order received by using the shipping route stored in the header information of each outgoing data as a key;
A third sorting step of sorting the outgoing data group using the agency data stored in the header information of the outgoing data as a key;
It is set as the output step which outputs the predetermined item content of delivery data as a picking list | wrist in order of the delivery data after a 3rd sort process about the said delivery data group.
[0037]
According to this method, it is not only possible to collect pallets that can be delivered for each agent store, just by loading the packages packed based on the created picking list on the pallet in that order. Even after delivery to the store, it is very easy to sort the packages according to the shipping route at the agent store, and the overall distribution can be made more efficient.
The present invention can be applied to both large orders and small orders. Further, it is preferable that the shipping routes are encoded and sorted by their code symbols and numbers.
Furthermore, the invention of the specific example 1 and the invention of the specific example 2 may be combined, and the sorting process in the order of the large number of converted books may be performed before the sorting process in the order of the shipping route.
[0038]
  As a picking list creation method according to the present invention,, Using the order detail data for a specific bookstore including bibliographic information of the order publication from the agency store and order quantity information of the order publication, the order publication by the agency store from the inventory publications of the distribution warehouse In the picking list creation method for instructing pick-up and packing of goods, if there is a customer order from the specified bookstore, a short strip of the order details data that will be delivered to the specified bookstore as it is via the agency The step of adding and inputting the order publication data with output, and the generation of the output data for generating the output data by adding the ordered store data and the strip output partial presence / absence data as header information to the order detail data Step and a part of the strip data stored in the header information of each outgoing data for the outgoing data group consisting of a plurality of outgoing data. A first sort processing step for sorting the outgoing data groups, a second sort processing step for sorting the outgoing data groups using the agency data stored in the header information of each outgoing data as a key, and the outgoing data groups And outputting a predetermined item content of the outgoing data as a picking list in the order of outgoing data after the second sort process.You may do.
[0039]
When packing is performed based on the picking list created by this method, it is possible to reliably respond to customer requests for general customers in a short time.
In addition, what is necessary is just to display that the label affixed on packages, such as a case, and the customer specifications are contained in the shipping specification sent with a package.
[0040]
  Claims provided to solve the problems5The picking list creation program according to the present invention uses the order detail data for a specific bookstore including the bibliographic information of the order publication from the agency and the order quantity information of the order publication to the CPU. In a picking list creation program for creating a picking list for instructing pick-up and packing of the order publications by agent from among the goods, the CPU causes the item data from the bibliographic information of the order publications in the order details data Calculating the number of converted books by multiplying the coefficient data specified on the basis of the subject data and the number of copies of the order publication, and calculating the number of converted books in the order details data, , Compare the size relationship between the total number of converted books and a predetermined threshold, and if the total number of converted books is greater than the threshold, determine that the order is large And determining orders determining step and small orders if the sum of the converted number of books is below the threshold value, and the order determination data in the order item dataTotal data of the converted book volume and agency data that has been orderedA delivery data generation step for generating delivery data to which header information is added, and a delivery data group formed by collecting a plurality of the delivery data, from the order determination data stored in the header information of each delivery data, The step of dividing into an outgoing data group of orders and an outgoing data group of small orders, and the outgoing data group divided into large ordersThe agency data as the first priority item, and the total data of the converted number of books as the second priority itemSort processing step for sorting the outgoing data group using as a key, and outgoing data in the order of outgoing data after the sorting processing for the outgoing data group divided into large ordersEveryAn output step of outputting the contents of the predetermined item as a picking list is executed.
[0041]
  This programThe packages packed based on the created picking list are objectively classified into large orders and small orders, and a picking list that can improve the efficiency of the entire logistics system can be generated. In other words, it is possible to perform efficient packing work without the need for extra packing work space with the minimum number of pallets simply by loading the packed goods based on the created picking list on the pallet in that order. Become. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
Note that the sort processing and picking list output may also be executed for the outgoing data group classified into small orders.
[0042]
  Claims provided to solve the problems6The picking list creation program according to the present invention uses the order detail data for a specific bookstore including the bibliographic information of the order publication from the agency and the order quantity information of the order publication to the CPU. In a picking list creation program for creating a picking list for instructing pick-up and packing of the order publications by agent from among the goods, the CPU causes the item data from the bibliographic information of the order publications in the order details data Calculating the number of converted books by multiplying the coefficient data specified on the basis of the subject data and the number of copies of the order publication, and calculating the number of converted books in the order details data, , Compare the size relationship between the total number of converted books and a predetermined threshold, and if the total number of converted books is greater than the threshold, determine that the order is large And determining orders determining step and small orders if the sum of the converted number of books is below the threshold value, and the order determination data in the order item dataOrder agency data that has been ordered, and route data from the agency to the bookstore corresponding to the order details dataA delivery data generation step for generating delivery data to which header information is added, and a delivery data group formed by collecting a plurality of the delivery data, from the order determination data stored in the header information of each delivery data, The step of dividing into an outgoing data group of orders and an outgoing data group of small orders, and the outgoing data group divided into large ordersThe agency data as the first priority item and the shipping route data as the second priority itemSort processing step for sorting the outgoing data group using as a key, and outgoing data in the order of outgoing data after the sorting processing for the outgoing data group divided into large ordersEveryAn output step of outputting the contents of the predetermined item as a picking list is executed.
[0043]
  With this program, it is possible to generate a picking list that can improve the efficiency of the entire logistics system after objectively classifying packages packed based on the created picking list into large orders and small orders. .In other words, simply loading the packages packed based on the created picking list onto the pallet in that order will not only produce a pallet that can be delivered for each agency, but also after delivery to the agency. In this case, it is very easy to sort the packages according to the shipping route at the agency, and the efficiency of the entire logistics can be improved.Note that the sort processing and picking list output may also be executed for the outgoing data group classified into small orders.
Further, the invention according to claim 5 and the invention according to claim 6 may be combined to perform the sort process in the order of the large number of converted books before the sort process in the order of the shipping route.
[0044]
  As a picking list creation program according to the present invention,, By using the order details data for a specific bookstore including bibliographic information of the order publication from the agency and the order quantity information of the order publication to the CPU, the above-mentioned for each agency from among the inventory publications in the distribution warehouse In a picking list creation program for creating a picking list for instructing pick-up and packing of order publications, the CPU stores the order data of large orders including order publication data with strip output in the CPU. And a delivery data generation step for generating delivery data to which header output is added as header information, and a delivery data group formed by collecting a plurality of the delivery data, stored in the header information of each delivery data. A first sort processing step for sorting the outgoing data group using a part of the strip output as a key, and the outgoing data Contents of predetermined items of the outgoing data in the order of the second sort processing step for sorting the outgoing data group using the agency data stored in the header information of the key as a key and the outgoing data after the second sort processing for the outgoing data group Output step to output as a picking listYou may do.
[0045]
With this program, when packing is performed based on the created picking list, it is possible to reliably respond to customer requests for general customers in a short time.
Order publications with strip output included in the order details data for large orders are customer orders, and are attached to labels attached to packages such as cases and shipment specifications sent with packages. It is only necessary to indicate that the order is included.
[0046]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, a configuration in an embodiment of a picking list creation system according to the present invention will be described with reference to the drawings.
FIG. 1 is a system configuration diagram of an embodiment of a picking list creation system according to the present invention.
As shown in FIG. 1, the picking list creation system includes a main CPU 2 that stores a picking generation program 1 and is connected to a network line N1 so as to be communicable with a publisher, a publishing VAN, an agency, and a bookstore. A memory 3 connected to the CPU 2 so as to be able to transmit and receive data, a terminal 4 connected to the main CPU 2 so as to be able to transmit and receive data, and keyed-in to order data, and a picking list by receiving data from the main CPU 2 The printer 5 for output is connected to the main CPU 2 and the wireless communication devices 6 and 7 so as to be able to transmit and receive data, and includes a warehouse-side terminal 8 having a printer 9 and a barcode reader 10. This configuration is a minimum unit configuration, and it is possible to add the main CPU 2, the memory 3, the terminals 4 and 8, the printer 5, and the like according to the scale of the distribution warehouse.
[0047]
In memory 3,
An event master 31 that holds the classification data of the order form as a table;
A delivery-destination master 32 that holds agency data, which is a delivery destination of merchandise,
A bookstore master 33 having bookstore data associated with the agency data and shipping route data from the agency;
A basic bibliographic master 34 holding various bibliographic data of the distributed products;
A reference book number table 35 that holds reference book number data associated with the bibliographic data item;
A shipment control master 36 which holds strip output, shipment details output, and shipping label output conditions for each event as a table;
An inventory master 37 that holds product inventory data of the distribution warehouse;
An order master 38 that displays an order entry screen connected to a related master,
A delivery master 39 holding the delivery item data as a table;
Packing specification master 3a having a relationship table between the agency and the case specification, a relationship table between the agency and the bucket specification, and a binding specification;
Order database 3b that holds the input order data;
A delivery database 3c having delivery data generated based on the order data;
Picking list master 3d holding sort instruction content data for outgoing data and format data for picking list;
Is stored.
[0048]
Note that the bookstore data and the shipping route data stored in the bookstore master 33 are data set by the agency concerned with the bookstore, and are provided from the agency via the network N1. The bibliographic data of the distribution product stored in the basic bibliographic master 34 is data such as the bibliographic code, book name, main unit price, item, size, and number of pages created by the publisher, from the publisher via the network N1. Provided. Further, the inventory master 37 stores data such as inventory quantity (number of copies), warehouse storage bins, etc. for each product stocked in the distribution warehouse, and is updated each time a product entry / exit is checked.
[0049]
Next, a procedure from order reception to delivery in an embodiment of the picking list creation system according to the present invention will be described with reference to FIG. The order received here refers to an order from one agency to one bookstore.
First, at the stage of receiving an order (s11), data relating to the contents of the order is input to the main CPU 2 (s12). Regarding orders received via the network N1 such as publishing VAN orders and text orders, the order data is automatically converted into predetermined order details data and taken into the main CPU 2. For other orders, the order data is input by the operation of the terminal 4 of the operator, and the order data is converted into predetermined order details data and taken into the main CPU 2. The input may be a terminal key input, but the digitizer input method using a prescribed order form is suitable for processing large orders. Here, an example in which an order entry menu is displayed on the screen of the terminal 4 by the order master 38 is shown in FIG. Each input section on the input screen is directly or indirectly connected to various data tables stored in the memory 3 by the order master 38, and the order detail data is determined based on the order data entered, and the order details The data is stored in the order database 3b. Note that orders received via the network N1 are not displayed on the screen, and similar processing is performed.
[0050]
The details of the order detail data are performed as follows in detail in FIG.
The event input unit 101 is directly connected to the order data classification data (order received event) table of the event master 31, and the event is determined when the operator confirms the order received and selects the type of event.
The supplier code input unit 102 is connected to the delivery destination master 32, and the agency data relating to the order is determined from the inputted agency code number, and the agency name is displayed.
The bookstore code input unit 103 is connected to the bookstore master 33, and the bookstore data relating to the received order is determined from the inputted bookstore code number, and the district name and bookstore name are displayed. At the same time, the shipping route display unit 104 extracts and confirms shipping route data from an agency corresponding to the confirmed bookstore data from the bookstore master 33, and displays the contents in a predetermined format.
In the order product input field 100, the bibliographic code number, the number of copies, and the delivery location for each ordered product are entered, and the results are displayed in a list form in the bibliographic code display portion 105, the order quantity display portion 106, and the delivery location display portion 107. Is displayed. At the same time, the bibliographic code number and the number of copies of the target product are compared with the inventory data held in the inventory master 37 and the result (inventory presence / absence) is displayed on the inventory status display unit 109. At this time, shelf number data in which products are in stock may be acquired. Note that in the order product input field 100, strip output can be specified, and the input result is displayed on the strip presence / absence display unit 107. By the way, customer-customized products are input with the specification of strip output as one of the details of large orders using this.
Therefore, one order detail data includes: order event (order form), agency store, book store, shipping route from the agency store, data for each product (bibliographic code, title, number of copies, delivery location, inventory presence, shelf number, strip Data).
[0051]
Based on the order details data, the delivery data is generated (s13). Next, a picking list is generated in a format stored in the picking list master 3d at a predetermined timing, and the contents are output by the printer 5 (s14, 19). A display example of the picking list is shown in FIG. For example, the work name column displays large-order order work and small-order order work, the strip output column indicates whether or not a strip is output, the agency name is in the agency name column, and the shipping route from the agency is in the number line column. The name of the bookstore is displayed in the bookstore name column, and the location (warehouse, shelf number), bibliographic code, signature, number of shipments, etc. of the product to be picked are displayed in a list form.
[0052]
In step s14, the outgoing data is first classified into a large order and a small order according to the output instruction, and then the outgoing data relating to the large order is sorted based on the contents of a predetermined sort instruction and stored in the outgoing data in that sort order. Order details (product details) are sequentially output as a picking list. In step s19, the outgoing data is first classified into a large order and a small order according to the output instruction, and then the outgoing data relating to the small order is sorted based on the contents of a predetermined sort instruction and stored in the outgoing data in that sort order. Several order details (product details) are combined into one picking list, and the picking list is output in the sorted order.
[0053]
In the case of a large order picking list (s14), if there is a customer order, a strip is output from the printer 9 (s15), and the warehouse worker is stocked on the warehouse shelf in the order described in the picking list. After picking up the target product (s16) and inserting the strip output in step s15 into the customer-ordered product (s17), the product is stored in a case or bound and packed (s18). ). By checking the barcode on the picking list for which packing has been completed with the barcode reader 10, the product details on the picking list are confirmed as being issued, and the inventory data in the inventory master 37 is updated. In addition, along with the packing operation, cases or bundles that have been packed are stacked on a pallet prepared for each destination (for each agency).
[0054]
In the case of a small order picking list (s19), a strip for each product corresponding to the details of the picking list is output from the printer 9 (s1a), and the warehouse worker is stocked on the warehouse shelf based on the picking list. After picking up the target product (s1b), the strip output in step s1a is inserted for each product (s1c). Next, the product into which the strip is inserted is stored in a bucket or bound and packed (s1d). By checking the barcode on the picking list for which packing has been completed with the barcode reader 10, the product details on the picking list are confirmed as being issued, and the inventory data in the inventory master 37 is updated. In addition, along with the packing operation, buckets or bundles for which packing has been completed are stacked on a pallet prepared for each destination (for each agency).
Packing is carried out for all of the large order order picking list and the small order order picking list and all cases, buckets, and bundles are loaded on the pallet.
[0055]
Next, the case, bucket, and pallet loaded with bundles are loaded (s1e) corresponding to the trucks dispatched to each delivery destination, and delivered to a predetermined agency to be unloaded (s1f). ).
[0056]
Next, a procedure for generating the outgoing data from the order detail data will be described with reference to FIGS. In addition, as shown to Fig.9 (a), the generated delivery data D3 takes the structure where the delivery data header D2 was added to the order details data D1. This process may be performed any time as long as there is order detail data. However, it is preferable to automatically perform this process at the same time as the order detail data is generated in response to the order entry because the burden on the system is small.
[0057]
(Intermediary store data)
First, one piece of order detail data is acquired from the order database 3b in the main CPU 2 (s100). The acquired order details data D1 is classified into an order received from an agency, a VAN order, and a bookstore / personal order based on the order event data held therein, and the subsequent processing is divided (s101). In the case of an order from an agency, the agency data is extracted from the order details data and stored in the agency data area d1 of the delivery data header D2. Here, VAN orders and bookstore / individual orders are omitted, and the following description will be limited to orders from agency stores.
[0058]
(Bookstore data, shipping route data)
Next, the order details data D1 is classified according to the presence or absence of bookstore data held therein, and the subsequent processing is divided (s102). When there is bookstore data, the bookstore data and the shipping route data from the agency are taken out and stored in the bookstore data region d2 and the shipping route data region d3 of the delivery data header D2, respectively. Hereinafter, the description will be given only when there is bookstore data.
[0059]
(Large / small data, conversion volume data)
Next, determination of large order and small order for one order detail data is performed by the following procedure (s103).
(1) By referring to the bibliographic data of the basic bibliographic master 34 from the bibliographic code of the product, the item data is acquired for each product. An event is a type of product, including magazines, encyclopedias, books, and paperbacks.
(2) Based on the item data, the reference book number of the product is acquired from the relationship table between the item and the reference book number set in the reference book number table 35. The reference number of books is a conversion coefficient for uniformly determining the volume of the product, and is set in consideration of the average size of the product for each item and the volume of one standard case. This is set as follows, for example.
Magazine = 1, Encyclopedia = 4, Book = 1, Bunko = 0.25
The reference number of books may be set based on the average weight of products for each item.
(3) The number of converted books is obtained by multiplying the number of reference books and the number of copies received for each product, and the total number of converted books in the order details data is obtained.
(4) The total number of converted books is compared with the converted book number threshold set in the delivery master 39. This conversion volume threshold is set based on the volume of one standard case, for example, 19 volumes.
(5) If the total number of converted books is greater than the converted book number threshold, it is determined as a large order, and if the total number of converted books is less than or equal to the converted book number threshold, it is determined as a small order. That is, it can be objectively determined from the relationship between the volume of the packing means and the volume of the product of one order detail whether the order for each agency is a large order or a small order.
(6) The large order and small order determination results obtained here and the total number of converted books are stored in the large / small data area d4 and converted book data area d5 of the delivery data header D2, respectively.
[0060]
(Strip output, shipping label output, delivery statement output data)
Next, when it is determined that the order is large and there is no strip output (FIG. 6), it is determined that the order is large and there is a strip output (FIG. 7), and when it is determined that the order is small (FIG. 8), each is shipped. Based on the shipment control table set in the control master 36, conditions for strip output, shipment label output, and delivery statement output are set (s105, s106, s111 to s113, s117). Here, a shipping label is a label that is attached to the outside of a case or a binding that conforms to the case and displays the name of the agent or bookstore. The delivery statement is delivered with a binding that conforms to the case or the case. This is a product list.
[0061]
Specifically, when it is determined that the order is a large order and there is no strip output (FIG. 6), the strip output data area d6 of the shipping data D2 has the conditions of no strip output, shipping label output, and delivery statement output. These are stored in the shipping label output data area d7 and the delivery statement output data area d8 (s105, s106).
[0062]
When it is determined that the order is large and there is strip output (FIG. 7), the strip output part, shipping label output, and delivery statement output conditions are strip output data area d6 of shipping data D2, shipping label, respectively. The data is stored in the output data area d7 and the delivery statement output data area d8 (s111 to s113).
[0063]
If it is determined that the order is small (FIG. 8), the strip output, no shipping label output, and no delivery statement output conditions are the strip output data area d6, the shipping label output data area d7 of the shipping data D2, and the delivery. It is stored in the specification output data area d8 (s117).
[0064]
(Packaging data)
Next, when it is determined that the order is a large order and there is no strip output (FIG. 6), it corresponds to the agency data set in step s101 in the relationship table between the agency and the case specifications held in the package specification master 3a. The presence / absence of a case specification is determined (s107).
If there is a corresponding case specification, the case specification data is stored in the packing form data area d9 of the outgoing data header D2 (s108).
If there is no corresponding case specification, the binding specification data held in the packing form specification master 3a is stored in the packing form data area d9 of the delivery data header D2 (s110).
[0065]
When it is determined that the order is large and there is a strip output (FIG. 7), the case specification corresponding to the agency data set in step s101 in the relationship table between the agency and the case specifications held in the packing form specification master 3a. The presence or absence is determined (s114).
If there is a corresponding case specification, the case specification data is stored in the packing form data area d9 of the outgoing data header D2 (s115).
If there is no corresponding case specification, the binding specification data held in the packing form specification master 3a is stored in the packing form data area d9 of the outgoing data header D2 (s116).
[0066]
When it is determined that the order is small (FIG. 8), it is determined whether or not there is a bucket specification corresponding to the agency data set in step s101 in the relationship table between the agency and the bucket specifications held in the packing specification master 3a. (S118).
If there is a corresponding bucket specification, the bucket specification data is stored in the packing form data area d9 of the outgoing data header D2 (s119).
If there is no corresponding bucket specification, the binding specification data held in the packing form specification master 3a is stored in the packing form data area d9 of the outgoing data header D2 (s120).
[0067]
When the data is stored in all the data areas d1 to d9 of the outgoing data header D2 through the above procedure, the generated outgoing data header D2 is finally added as a header of the order detail data D1, and the outgoing data D3. And stored in the delivery database 3c (s109).
[0068]
In outputting the picking list, the above-mentioned delivery data is used, and data processing proceeds in the following procedure.
The contents of the data stored in the large / small data area d4 of the outgoing data header D2 are confirmed by the picking list output instruction, and are classified into two outgoing data groups of large order and small order according to the contents (s200).
[0069]
Next, the sorted outgoing data group is sorted based on the predetermined sort instruction content (s201). The sort instruction content is an instruction to sort on a predetermined condition for some of the data area items of the outgoing data input at the time of the picking list output instruction or in advance.
[0070]
Next, in the case of a large order, the order details (product details) corresponding to the outgoing data in the sort order are sequentially generated as a picking list (s202). The picking list is generated in a format in which the data areas d1 to d9 of the outgoing data header D2 and the order details are stored in the picking list master 3d. Specifically, in the picking list shown in FIG. 4, the work name column displays the classification of the large order receiving work and the small order receiving work from the data stored in the large / small data area d4, and the strip output field outputs the strip. Data stored in the delivery statement output data area d8 in the shipping specification column, indicating whether or not strip data is output from the data stored in the data region d6, and whether data is output from the data stored in the shipping label output data region d7 in the label column The presence / absence of output is stored in the agency name data field in the agency data area d1, the agency data stored in the agency data area d1 in the agency name field, and the bookstore data stored in the bookstore data area d2 in the bookstore name field. The data shows the code number and place name related to the shipping route from the agency, and the location of the product to be picked up (warehouse, storage bin), bibliographic code, book name, number of shipments Etc. are displayed in a list format from the sales order item data.
[0071]
Further, in the case of a small order, some of the order details (product details) corresponding to the outgoing data in the sort order are combined into one picking list, and the picking list is output in the sorted order (s203). ). Each picking list is displayed in the same manner as in the case of the large order received.
[0072]
Since packing is performed according to the sorted order based on the contents of the sorting instruction, it is possible to improve the efficiency of packing and loading work, and further work after delivery to the dealer.
[0073]
Below, the example implemented with the picking list creation system which concerns on this invention for every sort instruction | indication content is demonstrated.
Example 1
The procedure of the first embodiment from the picking list output instruction to the picking list output is shown in FIG. Here, a procedure in the case of instructing to output only a large order is shown. It is assumed that the sort instruction content is set in advance with the following content.
(Sort instruction content)
First priority: agency (alphabetical order)
Second priority item: Number of converted books (in descending order)
[0074]
First, in accordance with the large order picking list output instruction (s21), the contents of data stored in the large / small data area d4 of the outgoing data header D2 stored in the outgoing database 3c are confirmed. It is divided into two outgoing data groups with small orders.
Next, only the outgoing data group of large orders is picked up (s22), and the outgoing data group is sorted based on the sort instruction content of the second priority item (s23). Specifically, the sorting is performed in the descending order of the number of converted books based on the data stored in the converted book number data area d5 of each outgoing data head D2.
Next, after completion of the sorting in step s23, the outgoing data group is subsequently sorted based on the sort instruction content of the first priority item (s24). Specifically, the data stored in the agency data area d1 of each outgoing data head D2 is sorted in alphabetical order.
When step s24 ends, display data corresponding to the format of the picking list stored in the picking list master 3d is acquired from each delivery data D3, and picking list data is generated (s25).
Finally, the contents of the picking list data generated in step s25 are output as a picking list from the printer 5 in the order of the end of step s24 (s26).
[0075]
An example of the delivery data storage state, picking list output state, and delivery state when the above procedure is actually applied will be described with reference to FIGS. Here, packing is done in case specifications.
FIG. 11 shows the outgoing data storage state in the outgoing database 3c. Here, the outgoing data group D31 is divided into large orders only, and the outgoing data is stored in a state in which the outgoing data are arranged in the order input order.
[0076]
FIG. 12 shows the result of sorting the delivery data group D31 according to the procedure shown in FIG. 10 and outputting the picking list. The output order of the picking lists L1 to L5 is different from the input order of the shipping data group D31 in FIG. 11, and is first output in the order of the agency A (L1 to L4) and B (L5) as a large division. The picking lists L1 to L4 of the agency A are output in the order of the number of converted books.
[0077]
When packing is performed based on the picking lists L1 to L5, as shown in FIG. 13, cases for the agency A and B are gathered and loaded on the minimum necessary number of pallets P and can be delivered in order. In addition, the case with a large number of converted books is preferentially loaded as the loading state of the case for the agent A on the pallet.
[0078]
As described above, according to the sort instruction contents shown in FIG. 10, it is possible to efficiently carry out the packing operation with the minimum number of pallets only by loading the packed packages on the pallets in that order and without requiring an extra packing work space. Is possible. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
[0079]
Although this is limited to large orders, this procedure can also be applied to small orders. Further, the sort instruction contents regarding the agency may be sorted with a priority order such as “in order of the number of handled books”.
[0080]
(Example 2)
The procedure of the second embodiment from picking list output instruction to picking list output is shown in FIG. Here, a procedure in the case of instructing to output only large orders is shown. It is assumed that the sort instruction content is set in advance with the following content.
(Sort instruction content)
First priority: agency (alphabetical order)
Second priority: Shipping route (in district order)
[0081]
First, in accordance with the large order order picking list output instruction (s31), the contents of data stored in the large / small data area d4 of the outgoing data header D2 stored in the outgoing database 3c are confirmed. It is divided into two outgoing data groups with small orders.
Next, only the outgoing data group of large orders is picked up (s32), and the outgoing data group is sorted based on the sort instruction content of the second priority item (s33). Specifically, sorting is performed in order of districts based on the data stored in the shipping route data area d3 of each outgoing data head D2. For example, the order is from Hokkaido to Okinawa.
Next, after completion of the sorting in step s33, the outgoing data group is subsequently sorted based on the sort instruction content of the first priority item (s34). Specifically, the data stored in the agency data area d1 of each outgoing data head D2 is sorted in alphabetical order.
When step s34 ends, display data corresponding to the format of the picking list stored in the picking list master 3d is acquired from each delivery data D3, and picking list data is generated (s35).
Finally, the contents of the picking list data generated in step s35 are output from the printer 5 as a picking list in the order of the end of step s34 (s36).
[0082]
An example of the outgoing data storage state, picking list output state, and outgoing state when the above procedure is actually applied will be described with reference to FIGS. Here, packing is done in case specifications.
FIG. 15 shows the outgoing data storage state in the outgoing database 3c. Here, the outgoing data group D32 is divided into large orders only, and the outgoing data is stored in the order input order.
[0083]
FIG. 16 shows the result of sorting the delivery data group D32 according to the procedure shown in FIG. 14 and outputting the picking list. The output order of the picking lists L6 to L13 is different from the input order of the delivery data group D32 in FIG. 15, and the picking lists L6 to L13 of the agency A are output in the order of the districts of the shipping route. Here, only the agency A is displayed, but depending on the contents of the order, the picking list of another agency is subsequently output after these picking lists.
[0084]
When packing is performed on the basis of the picking lists L6 to L13, as shown in FIG. 17, the cases are classified according to the shipping route from the agency in units of pallets.
[0085]
As described above, according to the sort instruction contents shown in FIG. 14, not only the pallets that can be unloaded are collected for each dealership just by loading the packed packages on the pallet in that order, but also to the dealership. Even after delivery of goods, it is very easy to sort the packages according to the shipping route at the dealership, and the efficiency of the entire logistics can be improved.
[0086]
Although this is limited to large orders, this procedure can also be applied to small orders. Further, the shipping routes may be encoded and sorted by their code symbols and numbers.
Furthermore, it is good also as the procedure which combined Example 1 and Example 2. FIG. That is, in the procedure of FIG. 14, the sorting process in the order of the large number of converted books in step s23 of FIG. 10 may be performed before the sorting process in order of the shipping route in step s33.
[0087]
(Example 3)
The procedure of the third embodiment from picking list output instruction to picking list output is shown in FIG. Here, a procedure in the case of instructing to output only a large order is shown. It is assumed that the sort instruction content is set in advance with the following content.
(Sort instruction content)
First priority: agency (alphabetical order)
2nd priority item: Customer order (priority is given)
[0088]
First, in accordance with the large order order picking list output instruction (s41), the contents of data stored in the large / small data area d4 of the outgoing data header D2 stored in the outgoing database 3c are confirmed. It is divided into two outgoing data groups with small orders.
Next, only the outgoing data group of large orders is picked up (s42), and the outgoing data group is sorted based on the sort instruction content of the second priority item (s43). Specifically, sorting is performed with “partial output priority” based on the data stored in the strip output data area d6 of each outgoing data head D2. This is because products with large strip orders and strip output are customer-ordered products.
Next, after completion of the sorting in step s43, the outgoing data group is sorted based on the sort instruction content of the first priority item (s44). Specifically, the data stored in the agency data area d1 of each outgoing data head D2 is sorted in alphabetical order.
When step s44 ends, display data corresponding to the format of the picking list stored in the picking list master 3d is acquired from each delivery data D3, and picking list data is generated (s45).
Finally, the contents of the picking list data generated in step s45 are output as a picking list from the printer 5 in the order of the end of step s44 (s46).
[0089]
When the above procedure is applied and the picking list is output, the picking list output order is first output for each agency as a major division, and if there is a customer order from that agency, each agency is A picking list including customer orders at the top of the picking list group is output.
FIG. 19 shows an output example of a picking list including customer orders. “Partially present” is displayed in the strip output column, and “Short” indicating that there is a strip is displayed in the chuck column (CK) on the right side of the customer order item in the product specification list. Based on this picking list, the warehouse worker inserts a strip into the target product and stores it in a case or a bundle together with other products.
[0090]
In the case of large-order orders that use cases, the agency will immediately ship to the bookstore in the same state as the case, so customer orders stored inside will be delivered to the bookstore without staying at the agency. . Thereby, it can respond to the general customer's desire for acquisition in a short time.
This procedure is limited to large orders because it aims to arrive at the bookstore in a short time. Moreover, what is necessary is just to display that the customer order item is contained in the label affixed on packages, such as a case, and the shipping specification sent with a package.
[0091]
【The invention's effect】
  Claim 1, 2Depending on the system,The packages packed based on the created picking list are objectively classified into large orders and small orders, and a picking list that can improve the efficiency of the entire logistics system can be generated.
  That is, according to the system of claim 1, the packages packed based on the created picking list are simply loaded on the pallets in that order, and the minimum number of pallets is used, and no extra packing work space is required. Packing work is possible. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
  Further, according to the system of claim 2,By simply loading the packages packed based on the picking list created on the pallet in that order, not only the pallets that can be shipped out come out for each agency, but also after delivery to the agency. It is very easy to sort the packages according to the shipping route at the agency, and the overall logistics can be made more efficient.
[0092]
  Claim3, 4By the way,The packages packed based on the created picking list are objectively classified into large orders and small orders, and a picking list that can improve the efficiency of the entire logistics system can be generated.
  That is, by the method of claim 3,By simply loading the packages packed based on the created picking list onto the pallets in that order, the minimum number of pallets can be used, and an efficient packing operation can be performed without requiring an extra packing work space. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
  Claims4With this method, it is not only possible to collect pallets that can be delivered for each dealership by loading the packages packed based on the created picking list on the pallet in that order, but also to the dealership. Even after delivery, it is very easy to sort the packages according to the shipping route at the agency, and the overall logistics can be made more efficient.
[0093]
  Claim5, 6Programs,The packages packed based on the created picking list are objectively classified into large orders and small orders, and a picking list that can improve the efficiency of the entire logistics system can be generated.
  That is, according to the program of claim 5, it is possible to efficiently load a package packed based on the picking list created on the pallet in that order, with the minimum number of pallets and without requiring an extra packing work space. Packing work is possible. In addition, since pallets that can be delivered are continuously collected at each dealership, it is also efficient when loading pallets loaded with luggage (cases, buckets, bundling) on trucks. Furthermore, since the truck can be loaded in the order of the large number of books, the storage efficiency in the loading platform is improved.
  Claims6By the program ofBy simply loading the packages packed based on the picking list created on the pallet in that order, not only the pallets that can be shipped out come out for each agency, but also after delivery to the agency. It is very easy to sort the packages according to the shipping route at the agency, and the overall logistics can be made more efficient.
[Brief description of the drawings]
FIG. 1 is a system configuration diagram in an embodiment of a picking list creation system according to the present invention.
FIG. 2 is a flowchart showing a procedure from order reception to delivery in an embodiment of a picking list creation system according to the present invention.
FIG. 3 is a schematic diagram showing an order entry screen in an embodiment of a picking list creation system according to the present invention.
FIG. 4 is a diagram showing a format of a picking list in an embodiment of a picking list creation system according to the present invention.
FIG. 5 is a flowchart (1) showing a delivery data generation procedure in an embodiment of a picking list creation system according to the present invention.
FIG. 6 is a flowchart (2) showing a delivery data generation procedure in the embodiment of the picking list creation system according to the present invention.
FIG. 7 is a flowchart (3) showing a delivery data generation procedure in the embodiment of the picking list creation system according to the present invention.
FIG. 8 is a flowchart (4) showing a delivery data generation procedure in the embodiment of the picking list creation system according to the present invention.
FIG. 9 is a configuration diagram of outgoing data in an embodiment of a picking list creation system according to the present invention.
FIG. 10 is a flowchart of Example 1 according to the present invention.
FIG. 11 is a conceptual diagram showing input order data in the first embodiment.
FIG. 12 is a conceptual diagram illustrating a state of an output picking list according to the first exemplary embodiment.
FIG. 13 is a conceptual diagram showing a leaving state in the first embodiment.
FIG. 14 is a flowchart of Embodiment 2 according to the present invention.
FIG. 15 is a conceptual diagram showing input order data in the second embodiment.
FIG. 16 is a conceptual diagram illustrating a state of an output picking list according to the second embodiment.
FIG. 17 is a conceptual diagram showing a leaving state in the second embodiment.
FIG. 18 is a flowchart of Embodiment 3 according to the present invention.
FIG. 19 is an example of a picking list according to the third embodiment.
FIG. 20 is a conceptual diagram showing a configuration of a publication distribution system.
FIG. 21 is a flowchart showing a work procedure of a distribution warehouse in a publication distribution system.
FIG. 22 is a flowchart showing a procedure from order reception to delivery.
FIG. 23 is a conceptual diagram showing input order data for large lots in a conventional picking list creation system.
FIG. 24 is a conceptual diagram showing a state of a large picking list output in a conventional picking list creation system.
FIG. 25 is a conceptual diagram showing a large packing state in a conventional picking list creation system.
FIG. 26 is a conceptual diagram showing a large exit state in a conventional picking list creation system.
FIG. 27 is a conceptual diagram showing small-order order data input in a conventional picking list creation system.
FIG. 28 is a conceptual diagram showing a state of a fore-face picking list output in a conventional picking list creation system.
FIG. 29 is a conceptual diagram showing a packing state for a small package in a conventional picking list creation system.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 ... Program, 2 ... Main CPU, 3 ... Memory, 4,8 ... Terminal, 5,9 ... Printer, 6,7 ... Wireless communication apparatus, 10 ... Bar code reader, 31 ... Event master, 32 ... Delivery destination master, 33 ... Bookstore master, 34 ... Basic bibliographic master, 35 ... Basic book number table, 36 ... Shipping control master, 37 ... Inventory master, 38 ... Order master, 39 ... Delivery master, 3a ... Packing specification master, 3b, 93b ... Order received Database, 3c ... Delivery database, 3d ... Picking list master, N1 ... Network, 100 ... Order product input field, 101 ... Event input section, 102 ... Supplier code input section, 103 ... Bookstore code input section, 104 ... Shipping route display 105: Bibliographic code display unit 106: Order number display unit 107: Delivery location display unit 108: Strip presence display unit 109: Stock status display section, b: Product (book), d1 ... Distributor data, d2: Bookstore data, d3: Shipping route data, d4: Large and small data, d5: Converted book data, d6: Strip output setting data, d7 ... Shipping label output setting data, d8 ... Invoice specification output setting data, d9 ... Packing form data, B91-B93 ... Bucket, C1-13, C91-C95 ... Case, D1 ... Order data, D2 ... Shipping data header, D3 ... Delivery data, D31, D32 ... Delivery data group, L1-L13, L91-L98 ... Picking list, P ... Pallet, T91, T92 ... Order details table

Claims (6)

A main CPU connected to a network line so as to be able to communicate with a publisher and an agency;
An order receiving database connected to the CPU so that data can be transmitted and received, including order bibliographic information of order publications from the agency store and order copy data for a specific book store, and an agency where the order publications are delivered Stores data at the delivery destination master , bibliographic data that contains the combination of bibliographic information and subject data of publications provided by publishers, and stores coefficient data for each subject of publications. A reference book number table and a memory storing a delivery master storing predetermined threshold data;
An output device that receives data from the CPU and outputs a picking list;
The CPU identifies item data stored in the bibliographic master from bibliographic information of order publications in one order detail data stored in the order database, and is stored in the reference volume table based on the subject data. The coefficient data is identified, and the converted data is calculated by multiplying the coefficient data and the number of copies of the ordered publication, and the total number of converted books in the one order detail data is obtained. Compare the magnitude relationship with a predetermined threshold, and if the total number of converted books is greater than the threshold, determine that it is a large order, and if the total number of converted books is less than the threshold, determine that it is a small order.
Generating order data in which the order determination data, the total data of the converted book volume, and the agency data that has been ordered are added as header information to the order detail data;
For the outgoing data group formed by a plurality of the outgoing data, the order determination data stored in the header information of each outgoing data is divided into a outgoing data group for large orders and a outgoing data group for small orders, For the outgoing data group divided into large orders, the outgoing data group is sorted by using the agency data as the first priority item and the total data of the converted number of books as the second priority item as a key. A picking list creation system for causing a predetermined item content to be displayed as a picking list for each outgoing data in the order of outgoing data after the sorting process for a data group. A main CPU connected to a network line so as to be able to communicate with a publisher and an agency;
An order receiving database connected to the CPU so that data can be transmitted and received, including order bibliographic information of order publications from the agency store and order copy data for a specific book store, and an agency where the order publications are delivered Combined data of the delivery destination master in which the data is stored, the bookstore data and the bookstore master in which the shipping route data from the agency to the bookstore is stored, and the bibliographic information and subject data of the publication provided by the publisher A bibliographic master storing bibliographic data, a reference book number table storing coefficient data for each subject of a publication, a memory storing a delivery master storing predetermined threshold data, and
An output device that receives data from the CPU and outputs a picking list;
The CPU identifies item data stored in the bibliographic master from bibliographic information of order publications in one order detail data stored in the order database, and is stored in the reference volume table based on the subject data. The coefficient data is identified, and the converted data is calculated by multiplying the coefficient data and the number of copies of the ordered publication, and the total number of converted books in the one order detail data is obtained. Compare the magnitude relationship with a predetermined threshold, and if the total number of converted books is greater than the threshold, determine that it is a large order, and if the total number of converted books is less than the threshold, determine that it is a small order.
Generating order data in which the order determination data, the agency data that has been ordered, and the shipping route data from the agency to the bookstore corresponding to the order details data are added as header information;
For the outgoing data group formed by a plurality of the outgoing data, the order determination data stored in the header information of each outgoing data is divided into a outgoing data group for large orders and a outgoing data group for small orders, For the outgoing data group divided into large orders, the outgoing data group is sorted using the agency data as the first priority item and the shipping route data as the second priority item as a key, and the outgoing data group divided into the large orders The picking list creation system is characterized in that the contents of predetermined items are displayed on the output device as a picking list for each outgoing data in the order of outgoing data after the sorting process. Using the order detail data for a specific bookstore including bibliographic information of the order publication from the agency store and the order quantity information of the order publication, the order publication by the agency store from the inventory publications of the distribution warehouse In the picking list creation method instructing the pickup of
Item data is identified from the bibliographic information of the order publication in the order detail data, and the converted book number is calculated by multiplying the coefficient data identified based on the subject data and the number of copies of the order publication, A conversion volume calculation step for calculating the total number of conversion volumes in the detail data;
Compares the size relationship between the total number of converted books and a predetermined threshold. If the total number of converted books is greater than the threshold, it is determined that the order is large. If the total number of converted books is less than the threshold, a small order is received. An order determination step for determining
A delivery data generation step of generating delivery data by adding the order determination data, the total data of the converted number of books, and the agency data that has been ordered as header information to the order detail data;
A step of classifying a delivery data group of a plurality of delivery data into a delivery data group for large orders and a delivery data group for small orders from the order determination data stored in the header information of each delivery data; ,
Sorting step of sorting the outgoing data group with the agency data as the first priority item and the total data of the converted number of books as the second priority item for the outgoing data group classified into the large order,
A picking list creation method comprising: outputting a predetermined item content as a picking list for each outgoing data in the order of outgoing data after the sort processing for the outgoing data group classified into the large order. Using the order detail data for a specific bookstore including bibliographic information of the order publication from the agency store and the order quantity information of the order publication, the order publication by the agency store from the inventory publications of the distribution warehouse In the picking list creation method instructing the pickup of
Item data is identified from the bibliographic information of the order publication in the order detail data, and the converted book number is calculated by multiplying the coefficient data identified based on the subject data and the number of copies of the order publication, A conversion volume calculation step for calculating the total number of conversion volumes in the detail data;
Compares the size relationship between the total number of converted books and a predetermined threshold. If the total number of converted books is greater than the threshold, it is determined that the order is large. If the total number of converted books is less than the threshold, a small order is received. An order determination step for determining
A delivery data generation step of generating delivery data in which the order determination data, the agency data that has been ordered, and the shipping route data from the agency to the bookstore corresponding to the order details data are added as header information. When,
A step of classifying a delivery data group of a plurality of delivery data into a delivery data group for large orders and a delivery data group for small orders from the order determination data stored in the header information of each delivery data; ,
Sort processing step for sorting the outgoing data group as a first priority item and the outgoing route data as a second priority item for the outgoing data group classified into the large order,
A picking list creation method comprising: outputting a predetermined item content as a picking list for each outgoing data in the order of outgoing data after the sort processing for the outgoing data group classified into the large order. Using the order detail data for a specific bookstore including bibliographic information of the order publication from the agency and the order quantity information of the order publication to the CPU, the order is ordered for each agency from the inventory publications in the distribution warehouse. In a picking list creation program that creates a picking list that directs picking up and packing a publication,
The CPU identifies item data from the bibliographic information of the order publication in the order details data, and calculates the number of converted books by multiplying the coefficient data identified based on the subject data and the number of copies of the order publication. A conversion volume number calculating step for calculating the total number of conversion volume numbers in the order detail data,
Compares the size relationship between the total number of converted books and a predetermined threshold. If the total number of converted books is greater than the threshold, it is determined that the order is large. If the total number of converted books is less than the threshold, a small order is received. An order determination step for determining
A delivery data generation step of generating delivery data by adding the order determination data, the total data of the converted number of books, and the agency data that has been ordered as header information to the order detail data;
A step of classifying a delivery data group of a plurality of delivery data into a delivery data group for large orders and a delivery data group for small orders from the order determination data stored in the header information of each delivery data; ,
Sorting step of sorting the outgoing data group with the agency data as the first priority item and the total data of the converted number of books as the second priority item for the outgoing data group classified into the large order,
A picking list creation program that executes an output step of outputting predetermined item contents as a picking list for each outgoing data in the order of outgoing data after the sort processing for the outgoing data group classified into large orders . Using the order detail data for a specific bookstore including bibliographic information of the order publication from the agency and the order quantity information of the order publication to the CPU, the order is ordered for each agency from the inventory publications in the distribution warehouse. In a picking list creation program that creates a picking list that directs picking up and packing a publication,
The CPU identifies item data from the bibliographic information of the order publication in the order details data, and calculates the number of converted books by multiplying the coefficient data identified based on the subject data and the number of copies of the order publication. A conversion volume number calculating step for calculating the total number of conversion volume numbers in the order detail data,
Compares the size relationship between the total number of converted books and a predetermined threshold. If the total number of converted books is greater than the threshold, it is determined that the order is large. If the total number of converted books is less than the threshold, a small order is received. An order determination step for determining
A delivery data generation step of generating delivery data in which the order determination data, the agency data that has been ordered, and the shipping route data from the agency to the bookstore corresponding to the order details data are added as header information. When,
A step of classifying a delivery data group of a plurality of delivery data into a delivery data group for large orders and a delivery data group for small orders from the order determination data stored in the header information of each delivery data; ,
Sort processing step for sorting the outgoing data group as a first priority item and the outgoing route data as a second priority item for the outgoing data group classified into the large order,
A picking list creation program that executes an output step of outputting predetermined item contents as a picking list for each outgoing data in the order of outgoing data after the sort processing for the outgoing data group classified into large orders .

Images