JP2009026030A - Order receipt and distribution management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a system by which loss due to lost sales opportunity in a shop can be regained on the next day or later, when the amount of agricultural products distributed to the shop in intermediate distribution is insufficient for an expected amount. <P>SOLUTION: A computers system, for managing order receipt/load distribution states of agricultural products in distribution stages, includes: an order receipt information storage section storing order receipt information specifying a desired delivery of an agricultural product shop and a desired amount for delivery; an arrival-of-product information storage section storing arrival-of-product information on agricultural products from a production district; a processing section for determining distribution to shops according to the order receipt information and the arrival-of-product information; a processing section comparing an acceptable amount obtained by multiplying a desired amount for delivery at each shop by a certain ratio with a distributed amount; and a creation section which takes a difference amount between the distributed amount and the desired amount for delivery as a new desired amount for delivery when the acceptable amount is smaller than the desired amount for delivery, and creates reorder receipt information setting the next delivery for desired delivery as new desired delivery. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to an order distribution management system for supporting and managing the distribution and delivery of agricultural products in the distribution stage of agricultural products such as vegetables and fruits such as vegetables and fruits (hereinafter simply referred to as agricultural products).

  Agricultural products vary in quantity, size, quality, etc., depending on the season and weather. Some of the weather fluctuations are relatively easy to deal with, which occur slowly over a long period of time, and some are sudden and unaccountable, such as arare and leopard, which occur suddenly near the day of harvest of agricultural products. In addition, the number of agricultural products shipped from production sites (farmers and agricultural cooperatives) varies depending on the shipping adjustments of farmers, etc. with an eye on market conditions, and there are also mistakes in quality and number counting when packaging by farmers etc. Often occurs. In addition, accidents during the transportation of agricultural products, and deterioration of quality such as decay, sag, and melting occur. For these reasons, in agricultural distribution, it is very common that the quality and number of delivered agricultural products cannot be confirmed unless the boxes are actually opened. And, due to these phenomena, the quantity of agricultural products shipped from the production area often leads to a situation where the number is less than the planned number.

  Also, at the stores where agricultural products are consumed, by referring to the actual number of daily sales and the weather forecast for the next day for each agricultural product, the grade and number of agricultural products to be ordered for the next day are determined. Since delivery is made on multiple flights per day (for example, 7 o'clock and 12 o'clock, etc.), determine how much produce will be delivered on which flight, while looking at the daily sales hours It is normal to place an order. In this case, the total order quantity for the next day may increase or decrease from the previous day. And if the amount of agricultural products that actually arrived at the dealer is less than the number of orders or is missing due to the above situation, the dealer will not lose the opportunity to make sales. The result was not obtained.

  In distribution centers that handle intermediate logistics between production areas and sales outlets, the production areas and sales outlets receive and distribute while adjusting the quantity and quality of agricultural products that vary according to the above circumstances. It is necessary to repeat complicated logistics management related to loading and shipping every day in units of one day. Furthermore, even if the agricultural products arrive at the distribution center, even if they are of the same type, the color, size, number, quality, etc. are different for each agricultural product, so it is not suitable for uniform management like industrial products. Under such circumstances, the distribution management of agricultural products has been empirically performed for many years using slips and hands. However, it is easy to make mistakes such as missing parts, and it is difficult to reliably keep a record of shipments, so it is difficult to use them for production plans and sales plans for the next year.

  In recent years, various attempts have been made to carry out distribution management of agricultural products using a computer system, but agricultural products are different from ordinary industrial products that can be identified only by model numbers and are unlikely to cause quality degradation, and even the same agricultural products can be colored. The shape, size, quality, etc. are normally different, and after harvesting, the quality deteriorates from moment to moment. Therefore, even if the same agricultural products are shipped from the same production area, there is a special situation that the value as an agricultural product is completely different if the shipping date is different. Therefore, various ideas have been made for the distribution management of agricultural products by the computer system.

For example, Patent Document 1 discloses a production and distribution management system for agricultural products that provides a network between producers and purchasers, etc., and adjusts production reservations and purchase requests. Similarly, Patent Document 2 discloses a support system for an agricultural product distribution operation in which the planned shipment amount and the arrival amount of agricultural products are compared and the planned shipment amount is updated based on a predetermined algorithm. Patent Document 3 discloses a distribution system that automatically assigns a minimum amount of agricultural products to each store in order to prevent out-of-stock items from being distributed during intermediate distribution. Further, Patent Document 4 discloses a logistics management system that generates a warning message without delay and reduces losses when the quantity of agricultural products fluctuates immediately after harvesting of agricultural products or immediately before shipment to a dealer. Has been.
JP-A-11-175609 JP-A-10-222558 JP 2003-141224 A JP 2004-1909 A

  In the present invention, when the quantity of agricultural products allocated to a store becomes smaller than the planned number as a result of the distribution of the agricultural product in the intermediate distribution, the loss due to the loss of the sales opportunity of the store can be recovered after the next flight. It is an object of the present invention to provide an order shipment management system for the purpose.

  The present invention is a computer system for managing the order delivery status of agricultural products at the distribution stage, and includes an order information storage unit storing order information specifying a desired delivery flight and a desired delivery amount from an agricultural product store, An arrival information storage unit storing the arrival information of agricultural products from the ground, an unloading processing unit that reads out the order information and the arrival information and allocates an unloading amount to each of the sales stores, and each of the sales The desired delivery amount and the delivery amount at the store are read out, and the allowable number obtained by multiplying the desired delivery amount at any store by a predetermined ratio is compared with the delivery amount at the sale store. And a comparison determination unit that performs the comparison, and as a result of the comparison, for a store whose allowable number is smaller than the desired delivery amount, the difference between the desired delivery amount and the delivery amount is set as the new delivery desired amount, and the desired delivery Next flight A order partial load management system, characterized in that it comprises a re-order information generating unit to the new desired or not to generate deliveries and the re-order information or can generate.

  Here, the information processing apparatus further includes a special dealer information storage unit that stores special contract information that identifies a special contract dealer that allows re-orders among the dealers, and the processing in the comparison determination unit or the re-order information generation unit includes It is preferable that the processing is limited to a store that matches the special contract information. Further, the re-order information includes a flag indicating that the order is re-ordered, and the load processing unit reads the flag and does not include the flag in the load of the next flight. It is preferable to perform the assignment in preference to other order information. Further, it is preferable that the re-order information generation unit does not generate re-order information again when the re-order flag is included in the order information. Moreover, when generating the said re-order information, it is preferable that the newly allocated agricultural products are different in the arrival information from the agricultural products that should have been allocated based on the original order information. Furthermore, when the above-mentioned load processing unit has performed the above-mentioned priority allocation, a re-order receiving notification unit that notifies the dealer that has received the priority allocation that the re-order information has been generated. Is preferably provided.

  Due to the shortage of agricultural products in the intermediate distribution, the shortage of agricultural products can be preferentially allocated after the next flight even if the number of deliveries to the dealer is less than the desired delivery amount of the dealer. The dealer can recover the loss due to the loss of the sales opportunity due to the shortage after the next flight.

  Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows an example of a hardware configuration of an order distribution system constructed in a distribution center in charge of intermediate distribution between a production area and a store. This system example includes a distribution management database and a management server 10 that is the center of distribution management, a router 11, an order receiving terminal 12 that accepts a shipment request from a store and inputs order information, and the arrival of agricultural products to the distribution center. Receiving terminal 13 for receiving the arrival information, bar code reader 14 for reading the barcode on the shipping sticker connected to the arrival terminal 13 and affixed to the agricultural product, and for the delivery information used for the unloading operation. A shipping terminal 16 for managing shipping of agricultural products and inputting shipping information, and a dedicated printer 17 connected to the shipping terminal 16 for printing a shipping slip, connected by a LAN (Local Area Network). Yes. Further, the system is connected to the Internet 20 from the router 11 and can communicate with the store terminal 21. The management server 10 may be outside the distribution center.

  As a terminal, not only those that carry out the above-mentioned logistics work, but also an ordering terminal that is in charge of ordering processing to agricultural producers, an incoming inspection terminal that is in charge of input of inspection results of agricultural products that have arrived at the distribution center, etc. Also good. Each terminal is a general-purpose personal computer, but is not necessarily limited thereto, and may be a mobile phone, a PDA (Personal Digital Assistance), or a dedicated network terminal. In addition to the above, an input device, a display, a printer, and the like are connected to each terminal as necessary. Here, the input device refers to an input device such as a keyboard and a mouse. The display refers to a liquid crystal display device, a CRT (Cathode Ray Tube), or the like.

  The order shipment management system will be described by explaining the configuration and functions of the management server 10 which is the center of this system. FIG. 2 is a block diagram showing a schematic configuration of the management server 10 as viewed from the control side. The storage unit 30 is provided with a distribution management database. Specifically, the order information storage unit 31 stores information on shipment requests for agricultural products from a plurality of stores, and the receipt of agricultural products from the production area to the distribution center. A stock information storage unit 32 that stores information, a stock information storage unit 33 that stores information on how the agricultural products that have been received are differentiated, and information that specifies a special contract dealer that connects the distribution center and a special contract described later are stored. A special dealer information storage unit 34, a re-order information storage unit 35 that stores information necessary for performing a re-order process, which will be described later, and a shipping information storage unit 36 that stores information about shipment of agricultural products from the distribution center to the store. Is provided. These storage units will be described with reference to FIGS. In the following description, a code corresponding to each name, a table for associating a code with a name, etc. will not be mentioned one by one.

  The order information storage unit 31 stores order information which is a set of agricultural product shipment requests from each store to the distribution center. FIG. 3 is a conceptual diagram of a table in which order information is stored. Here, items such as an order number, a re-order flag, and a store name are provided, and information corresponding to each item is stored as a group of order information. When an order is received from each store, it is often specified that multiple agricultural products are shipped to multiple stores in one order. However, the order number is automatically assigned when data is entered, and is one order. However, a different number is assigned to each store for each agricultural product. The order date is the date when the order is received from the dealer. Agricultural product names are those that roughly classify agricultural products, such as “mandarin oranges” and “apples”, and are added with the size and grade of agricultural products according to the customs of the industry, and to some extent processing conditions. It is also possible to use. For example, “apple (M size)”, “wild vegetable mix”, and the like.

  The production area indicates the range of the prefecture. This is because various prefectures can identify the production areas of various agricultural products. The size and grade indicate the size and quality of the agricultural product, and specify the spec of the agricultural product desired by each store. The reason why size and grade are included is that if you do not include them, the agricultural products that should be distributed cannot be determined simply by specifying the names of agricultural products. The desired delivery amount is a quantity in a desired delivery unit. A delivery unit is a unit when a single or a plurality of agricultural products such as one bag or one are physically provided to consumers. The desired delivery date designates the date on which the dealer wants to receive delivery of agricultural products. The desired delivery flight designates which flight on the delivery desired date is desired to be delivered among a plurality of predetermined flights delivered to the respective dealers in one day. The field of a completed shipment flag is a column in which a flag is stored when an agricultural product is assigned to an order number by a distribution operation. In the shipment date column, the shipment date is stored when the shipment is actually finished.

  The arrival information storage unit 32 stores information on agricultural products that have arrived at the distribution center from the production area, and FIG. 4 is a conceptual diagram of a table in which the arrival information is stored. In this table, arrival information determined by inspection at the time of arrival of agricultural products such as arrival date, arrival number, and agricultural product name for each agricultural product is stored in each column. The arrival number is automatically assigned in accordance with the data input at the time of arrival of agricultural products. When a plurality of agricultural products are received from one arrival source, the arrival number is assigned to each agricultural product. The arrival source is a collection agricultural cooperative or a collection company that handles agricultural products in each production area. The unloading remaining quantity is a quantity when a part of the agricultural products received at the distribution center has been unloaded, but the remaining part has not been unloaded. A flag is set in the column of the already-shipped flag when the shipment of agricultural products corresponding to one row is confirmed.

  The unloading information storage unit 33 stores unloading information which is a result of unloading the agricultural products received at the distribution center corresponding to the order number. FIG. 5 is a conceptual diagram of a table storing shipment information. For each order number, shipment information is stored in one line. The number of agricultural products delivered from a producer (agricultural cooperative, etc.) at a time (number specified by 1 arrival number) is usually larger than the number of agricultural products requested by the dealer (number specified by 1 order number) In many cases, it is only necessary to assign an agricultural product having an arrival number of 1 to order information. However, in FIG. 5, 1 and 2 are provided from the arrival number to the unit of shipment for one column of the shipment information. The number of agricultural products received from one production site after repeated shipments. If there is not enough, it will not be possible to assign the necessary number for one order number, but even in that case, it is only necessary to assign another product of the arrival number.

  In addition, the shortage amount (or difference amount) means that the number of agricultural products that can be delivered by the desired delivery service on the desired delivery date is insufficient with respect to the quantity requested by one order number. It is the quantity that has fallen short. Agricultural product distribution is usually carried out while balancing the arrival of goods from the manufacturer and the shipment to the dealers from time to time due to the freshness of agricultural products. As a general rule, agricultural products delivered in Japan must remain in short supply.

  The contract dealer information storage unit 34 stores data on whether or not there is a special contract in a dealer table that stores information necessary for transactions by specifying a dealer. FIG. 6 is a conceptual diagram of a dealer table in which special dealer information is stored. The special contract here refers to the new number corresponding to the shortage when the actual number of shipments on the desired delivery flight is insufficient compared to the number requested in the agricultural product shipment request (order received) from a certain store. It is considered that orders (re-orders) have been received immediately, the next flight after the desired delivery flight is regarded as the new desired delivery flight, and the shortage is regarded as the new delivery desired amount, and the agricultural products are shipped to the distributor. The contract is acceptable to the center. As a result, the store can compensate for the loss of the opportunity to make sales due to the shortage by the delivery of the next flight (the flight after the current day or the first flight of the next day). In this case, the dealer does not make an actual shipment request (order) to the distribution center, and the value of agricultural products changes greatly when the harvest date changes one day, so the distribution center ships the next flight to the dealer. To do so, it is necessary to have a special agreement with the dealer.

  Based on the above special agreement, the re-order information storage unit 35 regards as many shipment requests (re-orders) for the number of agricultural products corresponding to the shortage of shipment as received from the dealer, and generates new order information. Stores necessary information. This is because, as will be described later, the management server 10 automatically generates new order information necessary for shipping agricultural products based on a special contract, instead of newly receiving information from the dealer. This eliminates the need for the store to check the shortage of the received amount and make a new shipping request.

  The shipping information storage unit 36 stores data on agricultural products actually shipped from the distribution center to each store. FIG. 7 is a conceptual diagram of a table storing shipping information. The shipping number is automatically assigned when shipping data is input.

  In addition, the storage unit 30 of the management server 10 stores screen information for displaying a standard screen necessary for each process of order reception, arrival, shipment, and shipment on the display of the center terminal, and shipping request at the store. 2 includes a screen information for displaying a standard screen for inputting the information on the display of the store terminal, an OS for operating the management server, a screen information for its operation, and the like. Is not specifically shown.

  Next, the processing unit 20 of the management server 10 will be described using a flowchart and the like as needed. When the agricultural product is actually received from the production area to the distribution center, the arrival reception unit 21 sends the arrival information, which is information on the arrival contents, to the arrival information storage unit 32 of the management server 10 via the barcode reader 14 or the like. Store.

  The processing performed from the unloading processing unit 22 to the reorder receiving notification unit 25 of the processing unit 20 is a series of processing accompanying the unloading of agricultural products, and a schematic flowchart of this flow is shown in FIG. The unloading processing step S10 of FIG. 8 is a step of performing a process of unloading the agricultural products received at the distribution center to each store, and is executed by the unloading processing unit 22 of FIG. The comparison determination processing step S20 of FIG. 8 is a step of determining whether or not an unacceptable shortage has occurred due to the shipment and whether or not to generate reorder information when the shortage has occurred. The comparison / determination unit 23 in FIG. The re-order information generation processing step S30 in FIG. 8 is a step for generating re-order information for the order number for which re-order information should be generated, and is executed by the re-order information generation unit 24 in FIG. The reorder receiving notification processing step S40 of FIG. 8 is a step of transmitting the fact to the corresponding store terminal when the reorder receiving information is generated, and is executed by the reorder receiving notification section 25 of FIG.

  8 will be described in detail with reference to the flowchart of FIG. Since the unloading process is performed sequentially by specifying one kind of many kinds of agricultural products, the unloading process of any one kind of agricultural product will be described below. When the unloading process is started, the standard screen information for searching for agricultural products to be unloaded is read from the storage unit 30 and displayed on the display of the unloading terminal 15 (step S11). When the commodity number or name of the agricultural product is input, and information specifying the type of agricultural product such as the size, quality, and production area of the agricultural product is input on the screen if necessary, and the search button on the search screen is clicked (step S12), the agricultural product If the search conditions of are matched, the shipment is in stock at the scheduled delivery time of the desired delivery flight, the shipment completed flag is not set, and the shipment desired date is the shipment processing date (or the next day), etc. The arrival information storage unit 32 and the order information storage unit 31 are searched (step S13). The reason for using such a search step is that, unlike industrial products that can be specified only by model number, agricultural products must include the same agricultural product name (agricultural product code) that has different sizes and quality (grades). Because there is no.

  Subsequently, the arrival information and order information of the agricultural products hit in the search are read out, and the standard unloading screen information is read from the storage unit, and the unloading screen is configured by combining them, and the unloading terminal Is displayed on the display (step S14). An example of the shipment screen is shown in FIG. By using such a distribution screen, it is possible to execute accurate distribution to each store while comparing a plurality of arrival information related to a specific agricultural product and a plurality of order information. In FIG. 10, the conditions for searching for agricultural products are displayed at the top, and a receipt information display section in a list form for displaying the agricultural products searched for as a shipment target is provided in the upper half. On the right is a column that displays the total number of searched agricultural products. This total number is not the number of agricultural products but the number of individuals. This is because there are various packing forms for each production area, so that the required amount of shipment can be easily compared. However, items that are sold only in cases, such as processed products and strawberries, are packaging units.

  Below that, when the number of agricultural products does not reach the minimum quantity required for distribution, search for similar agricultural products that differ in size, quality, and production area from the agricultural products searched for distribution in the distribution center inventory. And the search addition button which transfers to the flow for adding to an agricultural produce list is provided (Description of a search addition flow is abbreviate | omitted). The reason why such a button is provided is that agricultural products are remarkably different from industrial products and can meet actual demand even if they are not exactly the same standard. If the number of agricultural products that arrived at the distribution center for various reasons is less than the required number, it is not desirable that the grades and sizes of the agricultural products that have been ordered and the agricultural products that are actually shipped differ, but nothing will be shipped. It is better than not, and the situation that must be dealt with in this way can also occur in real logistics. Therefore, the retrieved similar agricultural products are handled as incoming agricultural products and can be shipped as alternatives. Furthermore, to the left of the search addition button is an additional order button for shifting to a flow for newly placing an order for the production area and ending the distribution work when there is not enough similar agricultural products in the inventory. (The explanation of the additional ordering flow is also omitted).

  In the lower half of the delivery screen, the name of the delivery destination dealer, the desired delivery quantity and delivery unit of the dealer are displayed as the contents of the order information received from the dealer, and the delivery information is entered on the screen. The shipment information input fields are provided in the form of a list as shipment information. In the list, the fields of the arrival number 1, the shipping packing number 1, the receiving number 2, and the shipping packing number 2 are fields that can be entered on the screen. While referring to the arrival information, the shipment information is generated by inputting in these fields. The priority presence / absence column is a column for displaying information for preferential distribution when the order information displayed in the column is the order information re-ordered by a special agreement. When priority is displayed, it is displayed that distribution should be performed in preference to a column that is not displayed. The desired delivery date is displayed as the desired delivery date read from the order information. The same applies to the desired delivery flight. Below the list of shipment information, a shipment confirmation button is provided. When this button is clicked after the shipment information is input, the shipment information is stored in the shipment information storage unit 33.

  When the shipment information is entered on the screen and the amount of produce that can be delivered is inevitably insufficient relative to the required amount, it is unavoidable that the shipment will be confirmed in an insufficient state. In this case, the sales opportunity of agricultural products is lost at a store that delivers less than the order quantity. When the shipment confirmation button is clicked (step S15), the shortage amount in the shipment is calculated for each order number (step S16), and the shortage amount is included as part of the shipment information along with other shipment information. Stored in the shipment information storage unit 33. This will be specifically described with reference to the figure. While the desired delivery amount of the order number “02145679” related to “broccoli” from “B department store” in the fourth column in FIG. 3 is 100 orders, Based on the arrival information of 5 cases of 10 pieces of “broccoli” in the fourth row in FIG. 4 and the arrival information of 6 bags of 5 pieces in the fifth row (assuming there is no other arrival of broccoli) When loading, the total amount of arrival is 80 and 20 shortages occur. This shortage amount is stored as 20 shortage amounts in the fifth column of FIG.

  When the distribution process for all the order numbers displayed on the distribution screen is completed, a distribution completed flag is set in the corresponding order number column (see FIG. 3) of the order information storage unit 31. As a result, when the entire amount of the agricultural products that have arrived has been delivered, a delivery completion flag is set in the corresponding arrival number column (see FIG. 4) of the arrival information storage unit 32 (step S17). In this way, the S10 step of FIG.

  Subsequently, a comparison determination process is executed as to whether or not re-order information is generated (step S20). This step will be described in detail with reference to the flowchart of FIG. When the unloading process S10 step ends, the unloading process data that has just ended is selected (step S21), and the first one of the plurality of order numbers included in the unloading process (i = 1) is selected (step S22). The dealer of the selected order number is identified with reference to the order information, and further, with reference to the dealer information, it is determined whether or not the identified dealer is a dealer (whether there is a special contract). (Step S23). If it is not a special dealer, the flow branches to the right and proceeds to step S27. If there is a next order number, the process returns to step S22 and the comparison determination process is executed for the next order number, and there is no next order number. In the case (when the comparison determination process is completed for all the ordered orders that have been delivered), the comparison determination process ends.

  On the other hand, if the specified dealer is a special dealer, the flow branches downward from step S23 to determine whether or not a re-order flag is set in the order information (step S24). This re-order flag means that the order information is generated as re-order information by the management server based on the fact that the delivery quantity is insufficient on the previous day. For example, the re-order flag is stored in the second row in the order information table of FIG. If the re-order flag is set, the flow branches to the right and proceeds to step S27, and returns to step S22 as described above or ends the comparison determination process. On the other hand, if the re-order flag is not set, it is normal order information that is not a re-order, so the flow branches down and proceeds to the subsequent step S25.

  The reason for changing the processing with reference to the reorder flag in this way is that the reorder information was generated in response to the shortage of shipments, but the amount of shipments to the dealer was not enough for the next day. This is to prevent the accumulation of re-order information by preventing the re-order information from being generated again if it is insufficient again. In such a case, the overall yield of the agricultural product is sluggish due to some cause such as bad weather, or the consumption of the agricultural product is suddenly increased due to broadcasting of related TV programs, etc. This is because accumulating the re-order information will eventually make many dealers a priority object and there is no meaning to give priority.

  Subsequently, in step S25, it is determined whether or not the delivery amount is smaller than an allowable number obtained by multiplying the desired delivery amount by a predetermined ratio previously determined for each store and stored in the store table. If the amount of shipment is equal to or greater than the number obtained by multiplying the desired delivery amount by a predetermined percentage, the flow branches to the right and again proceeds to step S27. On the other hand, when the amount of shipment is smaller than the number obtained by multiplying the desired delivery amount by a predetermined ratio, the flow branches downward from step S25 and proceeds to step S26.

  This judgment step is included even if the delivery quantity is insufficient, but if the delivery quantity is relatively close to the desired delivery quantity of the dealer, the delivery quantity is insufficient. This is because the influence on sales of a store is considered to be small, and the need to generate reorder information is considered to be small. On the other hand, if the reorder information is generated even when the shortage amount is relatively small, the processing is likely to be complicated and the delivery cost increases. Therefore, in such a case, this is a step for preventing the generation of reorder information. Accordingly, a constant ratio of 1 is possible, but it is preferable to set the ratio to about 0.75 to 0.95 according to the demand of the store. FIG. 11 shows a case where the constant ratio is 0.9.

  In step S <b> 26, the order number and the shortage data for which reorder information is to be generated are stored in the reorder information storage unit 35. Then, the comparison determination process is executed for all the order numbers included in the shipment number that is the target of the comparison determination process, and the comparison determination process in step S20 is completed.

  Subsequently, returning to FIG. 8, a re-order information generation process is executed (step S30). In the reorder information generation process, the data stored in the reorder information storage unit 35 is read to generate reorder information and store it in the order information storage unit 31. At that time, the shortage amount is set as a new delivery desired amount, the desired delivery flight is set as the next flight, and a reorder flag is set and stored. By setting a reorder flag, cumulative generation of reorder information is prevented.

  An example of the case where the reorder information is generated can be seen in the column of “radish” of the order number “02145678” in the third column of FIG. In this case, the re-order flag column on the second line is “Yes” and the flag is set, so there is a shortage of 100 shipments in the previous flight (1 flight), and you want to deliver that quantity. It can be seen that the reorder information is generated as an amount and stored in the order information storage unit. Further, in the distribution information of FIG. 5, the distribution information in the fourth column corresponds to the same order number “02145678”. Here, since two arrival numbers are used for the shipment, it can be seen that although the radishes from the two production sites are being delivered to the dealer, 20 shortages have occurred again. In this case, in order to avoid the cumulative generation of the reorder information, the reorder information is not generated again.

  As can be typically understood from this example, the agricultural product to be unloaded by the re-order information is different from the agricultural product that should have been unloaded by the original order information. That is, the type and grade of the agricultural product may be the same, but at least the arrival information of the agricultural product is different.

  At the end of the flow of FIG. 8, the fact that re-order information has been generated, the name of the produce, the new delivery desired amount (shortage of the previous day), the scheduled delivery date, the new desired delivery flight (the next flight of the original desired delivery flight) ) And the like can be read from the storage unit, the notification screen information to the dealer is constructed, and the reorder information is generated and transmitted to the dealer terminal of the dealer. By receiving this notification, the store can easily determine what should be newly requested for shipping. Moreover, it becomes possible to regain the sales opportunity due to the shortage of the previous day.

  The shipping processing unit 26 of the processing unit 20 of the management server 10 reads the confirmed shipment information and performs shipping processing as needed. Specifically, when the shipment target agricultural product corresponds to the shipment information, the shipping slip is printed from the dedicated printer, pasted on the packaging of the agricultural product and shipped, and the shipping information is stored in the shipping information storage unit 36. . This completes a series of orders, receipts, shipments, and shipments.

  By using the system as described above, it is possible to minimize the loss of sales opportunities suffered by the dealer even if the amount of the agricultural product is insufficient due to an unexpected cause.

  As mentioned above, although this invention was demonstrated using the embodiment of an order delivery system, this invention is not limited to this, A various deformation | transformation is possible within the range which does not deviate from a technical thought. For example, various modifications can be made to the way of holding data of each table, the order of processing in each processing unit, and the like.

  Further, in the above description, when the shipment amount of a certain flight to an agricultural dealer is insufficient, the management server generates new order information and notifies the dealer to that effect. Alternatively, a notification indicating that the shipping amount is insufficient may be specified by the management server, and the management server may transmit the notification to the dealer terminal, and receive corresponding new order information from the dealer terminal. In this case, the management server of the distribution center does not need the authority to generate new order information, but requires a special agreement to receive a notification to that effect. The notification that the shipping amount is insufficient is not reorder information itself, but can be considered as a notification that enables generation of reorder information. In the first aspect of the invention, “making it possible to generate” means to include such a case.

  Moreover, in the above description, only the description that the information indicating that the shipment should be preferentially displayed on the shipment screen is performed at the time of the shipment, but the shipment information actually input on the screen is further described. However, a check flow may be provided to determine whether or not the input is performed according to the priority information. Further, when generating reorder information, new order information may be newly generated as described above, or may be generated by transferring from original order information.

  The physical distribution management database may be configured as a relational database or may be configured as an XML (eXtensible Markup Language) type database. The physical distribution management database may be built in the server, or may be in another device and accessed from the server by communication. The storage unit or database may be a hard disk device, a magneto-optical disk device, a non-volatile memory such as a flash memory, a recording medium that can only be read such as a CD-ROM, a volatile memory such as a RAM, or a combination thereof. Composed. The same is true for each terminal.

  The present invention can also be understood as a program for causing a computer to execute. For example, in accordance with the first aspect of the invention, a program for causing a computer to execute a management function of the order shipment status of agricultural products at the distribution stage, which specifies a desired delivery flight from the agricultural product store and a desired delivery amount An order information storage step storing the received order information, an arrival information storage step storing the arrival information of the agricultural products from the production area, and the order information and the arrival information are read out and distributed to each of the dealers. A load processing step for allocating a quantity, an allowance obtained by reading out the desired delivery quantity and the delivered quantity at each of the dealers and multiplying the desired delivery quantity at any dealer by a predetermined ratio A comparison judgment step for comparing the number of goods with the amount of goods delivered at the store, and the result of the comparison with respect to a store where the allowable number is smaller than the delivery desired amount. A re-order information generating step for generating or enabling generation of re-order information in which a difference amount from the delivery amount is a new delivery desired amount and the next flight of the desired delivery flight is a new desired delivery flight. This is an order shipment management program characterized by this. Other inventions can be similarly regarded as programs.

  These programs may be stored in a computer-readable recording medium. Here, the recording medium refers to a recording medium such as a flexible disk, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system. Further, the program can be arbitrarily divided and the divided programs can be stored in the storage medium.

It is the conceptual diagram which showed an example of the hardware constitutions of the order distribution system constructed | assembled in the distribution center. It is the block diagram which showed schematic structure which looked at the management server 10 from the control surface. It is a conceptual diagram of the table in which order information is stored. It is a conceptual diagram of the table in which the arrival information was stored. It is a conceptual diagram of the table in which shipping information is stored. It is a conceptual diagram of a store table in which special dealer information is stored. It is a conceptual diagram of the table in which shipping information is stored. It is a schematic flowchart of a series of processing flows accompanying the distribution of agricultural products. It is the flowchart which showed in detail the process of the unloading process step S10 of FIG. It is the schematic diagram which showed the example of a shipment screen. It is the flowchart which showed the process of comparison judgment step S20 of FIG. 8 in detail.

Claims (6)

  This is a computer system that manages the order distribution status of agricultural products at the distribution stage, and includes an order information storage unit that stores order information specifying the desired delivery flights from the agricultural store and the desired delivery amount, and agricultural products from the production area. A receipt information storage unit storing the receipt information, a shipment processing unit that reads the order information and the receipt information and allocates a shipment amount to each of the dealers, and the delivery at each of the dealers A comparison / determination unit that reads out the desired amount and the amount of shipment, and compares an allowable number obtained by multiplying the desired amount of delivery at a given store by a predetermined ratio with the amount of shipment at the store. As a result of the comparison, for a store whose allowable number is smaller than the desired delivery amount, the difference between the desired delivery amount and the unloading amount is set as the new delivery desired amount, and the next flight of the desired delivery flight New hope Order partial load management system, characterized in that it comprises a re-order information generating unit to or can generate generating a re-order information with feces.   Furthermore, a special contract dealer information storage unit that stores special contract information that identifies a special contract dealer that allows re-orders from among the dealers, and the processing in the comparison determination unit or the re-order information generation unit includes the special contract 2. The order distribution management system according to claim 1, wherein the system is performed only for a store that matches the information.   The re-order information includes a flag indicating that the order has been re-ordered, and the load processing unit reads the flag and does not include the flag in the load of the next flight. 3. The order distribution management system according to claim 1 or 2, wherein the allocation is performed with priority over the order information.   4. The received order quantity according to claim 1, wherein when the received order information includes the re-ordered flag, the re-order received information generation unit does not generate the re-order received information again. Load management system.   5. Any one of claims 1 to 4, wherein when generating the re-order information, the newly assigned agricultural product is different in arrival information from the agricultural product that should have been assigned according to the original order information. Order shipment management system described in Crab.   Furthermore, when the above-mentioned load processing unit has performed the above-mentioned priority assignment, a re-order reception notification unit for notifying the store that has received the priority assignment that the re-order information has been generated is provided. The order distribution management system according to any one of claims 1 to 5, characterized in that:

Images