JP4015306B2 - Product order management device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a merchandise ordering management apparatus that supports merchandise ordering operations at mass merchandisers.
[0002]
[Prior art]
For example, at the headquarters that oversees and manages multiple stores, product orders generated from each store are organized by suppliers such as wholesalers and wholesalers, and at mass merchandising stores that place orders from headquarters to each supplier, A product order management system using a network connecting the store and the headquarters system has been established.
[0003]
A conventional merchandise order management system has a merchandise order management apparatus mainly composed of a host computer at the headquarters, and a POS (Point Of Sales) system constructed at each merchandise order management apparatus and each store. Are connected to a store computer via a network such as ISDN (Integrated Services Digital Network). Each store is provided with an ordering terminal. This ordering terminal has an input means for inputting data of items necessary for ordering products such as a product code of the product to be ordered, the number of orders, and delivery schedule information, and product ordering data from the data input through this input means. This is a portable type having a data transmission means for generating and transmitting data, and is generally called a handy terminal.
[0004]
At each store, the product order data input using the ordering terminal is once collected by the store computer and transmitted to the headquarters via the network. At the headquarters, the product ordering data collected from each store is totaled for each supplier by the product order management device, and an order slip is created. Then, the order slip is issued to each supplier by online or facsimile communication means or by handing to place a product order.
Recently, there has been developed a product in which a modem is incorporated in an ordering terminal so that product ordering data can be transmitted directly from the ordering terminal to a product ordering management apparatus in the headquarters via a public telephone line.
[0005]
By the way, in general, in this kind of mass merchandising store, the headquarters knows the sales situation of each product for each store, and based on that, optimize the assortment of goods for each store, that is, what products should be handled at each store In addition, it manages how much each product is ordered to reduce the parting loss. Each time there is a product order from each store, it is checked whether a product that is no longer being handled has been ordered at that store, or whether an unreasonably large number of orders have been placed.
[0006]
For example, among products such as foods, there are products that are sold for a limited time, such as seasonal products, and the handling period of the limited-time sales products is determined in advance between the manufacturer and the headquarters. For this reason, every time there is a product order from each store, the headquarters has to check whether a product has been ordered after the handling period.
[0007]
Further, in general, considering the holidays of suppliers such as wholesalers and wholesalers, it is possible to place an order for each product, the day of the week, the period from ordering to delivery, the time of delivery flights, and the like. For this reason, every time there is a product order from each store, the headquarters has to check whether there is an error in the order date or delivery schedule information.
Therefore, conventionally, an ordering person in charge of the headquarters checks the above-mentioned various items based on an order slip created for each supplier by the product order management apparatus, thereby preventing an illegal order from being placed.
[0008]
[Problems to be solved by the invention]
As described above, conventionally, product ordering data generated from each store has been checked artificially, so that the work load of the person in charge of the ordering is large and ordering errors are likely to occur.
The present invention has been made based on such circumstances, and the purpose of the present invention is to automatically determine whether or not the product ordering data input at the ordering terminal is valid, and to verify the validity. An object of the present invention is to provide a merchandise order management apparatus that can perform merchandise ordering based on certain merchandise ordering data, and can reduce merchandise ordering data check work and reduce ordering errors.
[0009]
[Means for Solving the Problems]
  The invention described in claim 1 of the present application is the product code of the product to be ordered, the number of orders,Order date, delivery dateAn ordering terminal and a communication means having an input means for inputting data of items necessary for ordering goods, etc., and a data transmission means for creating and transmitting product ordering data from the data inputted through the input means In the product order management apparatus for placing an order for each product based on the product order data received from the ordering terminal via this communication means,Product files that store supplier codes, handling periods, etc. corresponding to the product codes of various products, and the days that can be ordered, delivery days by orderable days, etc. corresponding to the supplier codes of various suppliers Remembered supplier file,Receive product ordering data from ordering terminal via communication meansA product determination unit that searches the product file and determines whether or not a product code embedded in the product ordering data is registered, and the product determination unit determines that the product code is registered. A delivery date determination means for acquiring a handling period corresponding to the product code from the product file, and determining whether or not a delivery date embedded in the product ordering data is included in the handling period, and the delivery date If the decision means determines that the delivery date is included in the handling period, the supplier code corresponding to the product code is obtained from the product file, the supplier file is searched and the supplier code is handled Order date determining means for determining whether or not the day of the order date embedded in the product ordering data is the orderable day of the order. Goods orders data which day of the week for more order date has been determined to be orderable day of the weekBased on the above, each product is ordered.
  In this, like the invention of claim 2 of the present application,When the order date judging means determines that the order day is an orderable day, the delivery date calculating means for calculating the delivery date from the delivery day, the order date and the day of each order available day, and this A delivery date validity judgment means for judging whether or not the delivery date calculated by the delivery date calculation means matches the delivery date included in the product ordering data, and the delivery date validity judgment means determines the delivery date. Order each product based on the product order data determined to matchConvenient.
[0010]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
In this embodiment, at the headquarters that manages and manages multiple stores, product ordering data generated from each store is compiled by supplier such as wholesalers and wholesalers, and orders are placed from the headquarters to each supplier. The case where this invention is implemented in the mass sales store to perform is demonstrated.
[0011]
FIG. 1 is a block diagram showing a functional configuration of the present embodiment. In FIG. 1, reference numeral 1 denotes a product order management apparatus installed in the headquarters. This merchandise order management apparatus 1 is mainly composed of a host computer, and orders data for fetching and processing merchandise order data 3 transmitted from the ordering terminal (handy terminal) 2 provided in each store via the network. A capture processing unit 11 is provided.
[0012]
The order data fetch processing unit 11 refers to parameters relating to order conditions for each product set in a product file 21, a product reservation file 22, a store file 23, a store reservation file 24, and a supplier file 25, which will be described later. The validity of the product ordering data received from the ordering terminal 2 is judged (validity judging means), and the product ordering data judged to be valid is registered in the ordering data file 12 as the ordering data storage unit. The product order data determined to be absent is registered in the error data file 13 serving as an error data storage unit.
[0013]
Further, the product order management apparatus 1 is determined to have a function as an error data output means for outputting the error list 14 of the product order data registered in the error data file 13 and no validity on the error list 14. From the order data maintenance unit 15 having a function as error data correction means for correcting the product order data, the product order data registered in the order data file 12 and the product order data corrected by the order data maintenance unit 15 An order slip creation unit 16 that creates an order slip for each supplier is provided.
[0014]
The order slip creation unit 16 converts the data of the order slip created for each supplier into data for online transmission with respect to the data for the supplier who issues the purchase slip online, and the online order data file 17. The data for the supplier that temporarily stores the data in the printer and issues the purchase slip by facsimile communication is converted into data for facsimile communication, temporarily stored in the FAX order data file 18, and the purchase slip issued by hand delivery. The data for the destination is converted into printout data and temporarily stored in the slip issue data file 18.
[0015]
Then, when appropriate, an order is placed by transmitting the order slip data stored in the online order data file 17 to the corresponding supplier via a public telephone line or a network such as ISDN. Further, the product ordering is performed by transmitting the ordering slip data stored in the FAX ordering data file 18 to the corresponding supplier through the facsimile line. Further, the order slip data stored in the slip issue data file 18 is printed out by a printer, and the product can be ordered by handing.
[0016]
The order slip creation unit 16 has a function of storing the order slip data created for each supplier in the delivery processing copy data file 20 for each supplier and in the order of the slip number. Thus, by inputting the supplier code and the slip number at the time of delivery processing and acquiring the data of the corresponding order slip from the delivery processing copy data file 20, complete delivery, management of missing items, management of accounts payable, etc. It is a mechanism that can be easily done.
[0017]
As shown in FIG. 2 (b), the product file 21 includes a product code, a name, a classification code, a cost, a selling price, a supplier code, and a handling period as parameters relating to ordering conditions for various products that can be sold at the present time. This is a file in which records including items such as the number of entries and designated flight number are stored in advance. The product code is a product-specific code assigned in advance to identify each product. The supplier code is a supplier-specific code assigned in advance to identify a wholesaler, a wholesaler, etc., who is the supplier of each product. The handling period is a period during which the product can be sold, and “0” is set for an indefinite period. The designated flight number is the number of a delivery flight in which the product is delivered from the supplier to each store, and a plurality of flight numbers are set for a product having a plurality of daily deliveries.
[0018]
The product reservation file 22 starts handling (sale) of the product in the record item of the product file 21, as shown in FIG. 2 (c), as parameters relating to ordering conditions for various products scheduled to be sold in the future. This is a file in which records with date items to be stored are stored in advance.
[0019]
As shown in FIG. 2 (d), the store file 23 is a store code, a product code, and a store-by-store parameter as parameters relating to the ordering conditions of each product currently sold at the store for each store that is centrally managed by the head office. This is a file in which records including items such as cost, sales price by store, and maximum order quantity are stored in advance. The store code is a store-specific code assigned in advance to identify each store. The maximum order quantity is the maximum value allowed as the order quantity of the corresponding product at the store.
[0020]
As shown in FIG. 2 (e), the store reservation file 24 is a record item of the store file 23 as a parameter relating to ordering conditions for each product scheduled to be sold in the store for each store managed centrally. Is a file in which a record with an item of a date on which the handling (sales) of the product is started is stored in advance.
[0021]
As shown in FIG. 2 (f), the supplier file 25 includes a supplier code, an address, an account closing date, and an order as parameters relating to merchandise ordering conditions for each supplier such as wholesalers and wholesalers. It is a file that pre-stores records composed of items such as classification, order day, order day, and delivery day. The order classification is information for distinguishing whether the order slip is issued to the supplier by online transmission, facsimile communication, or hand delivery. The orderable days are days that can be ordered with respect to the supplier, and a plurality of days can be set. The delivery day is a day of the week when delivery is possible at the supplier when a product is ordered on each day set as an orderable day.
[0022]
In the present embodiment having the product order management apparatus 1 having such a configuration, when the person in charge of ordering confirms a product that needs to be ordered according to the stock status of each product at each store, Enter the product code, the number of orders, the delivery date, the flight number of the delivery flight, etc. When input of the above items is completed for all products that need to be ordered, a product order data transmission operation is performed. Thereby, in the ordering terminal, as shown in FIG. 2 (a), product ordering data including items such as a store code, a product code, the number of orders, an ordering date, a delivery date, and a flight number is stored for each ordered product. A file created and stored with the product order data is transmitted to the product order management apparatus 1 at the headquarters via communication means such as ISDN or public telephone line.
[0023]
On the other hand, when the product order management apparatus 1 receives the product order data file from the ordering terminal 2 of each store, the order data fetch processing unit 11 sequentially reads the product order data from the received file, and the read product order data. The processing shown in the flowcharts of FIGS. 3 to 4 is executed.
That is, when the order data fetch processing unit 11 reads the product order data having the record structure shown in FIG. 2A as a processing target from the received file, first, as ST (step) 1, the store code of the product order data The store file 23 is searched using the product code as a search key. If a store file record in which the search key matches the store code and the product code is detected from the store file 23 in ST2, the process proceeds to ST6.
[0024]
On the other hand, when the corresponding store file record cannot be detected from the store file 23, the store reservation file 24 is searched with the same search key as ST3. If a store reservation file record whose search key matches the store code and the product code is detected from the store reservation file 24 as ST4, the start date of the store reservation file record and the delivery of the product ordering data to be processed are processed as ST5. Compare the day. If the start date is before the delivery date (start date ≦ delivery date), the process proceeds to ST6.
[0025]
On the other hand, when the corresponding store reservation file record cannot be detected from the store reservation file 24 in ST4, or the start date of the store reservation file record is later than the delivery date of the product ordering data (start date) in ST5. > Delivery date), the product ordering data to be processed is the ordering data for products that are not handled at least by the delivery date at the ordering store. The order data is registered in the error data file 13, and the processing for the product order data is finished.
[0026]
In ST6, the product file 21 is searched using the product code of the product ordering data to be processed as a search key. If a product file record whose search key matches the product code is detected from the product file 21 in ST7, the process proceeds to ST11.
[0027]
On the other hand, when the corresponding product file record cannot be detected from the product file 21, the product reservation file 22 is searched with the same search key as ST8. Then, if a product reservation file record whose search key matches the product code is detected from the product reservation file 22 in ST9, the start date of the product reservation file record and the delivery date of the product ordering data to be processed are determined in ST10. Compare. If the start date is before the delivery date (start date ≦ delivery date), the process proceeds to ST11.
[0028]
In ST11, it is determined whether or not the delivery date of the product order data to be processed is within the handling period of the detected product file record or product reservation file record. If it is outside the handling period, the product ordering data to be processed is the ordering data for the goods outside the handling period, and therefore the product ordering data to be processed is stored in the error data file 13 together with the error code of the outside handling period as ST12. The registration and the processing for the product ordering data are finished.
[0029]
If the corresponding product reservation file record cannot be detected from the product reservation file 22 in ST9, or the start date of the product reservation file record is later than the delivery date of the product ordering data in ST10 (start date> delivery) In the same manner as described above, the product ordering data to be processed is registered in the error data file 13 together with the error code of the error outside the handling period, and the processing for the product ordering data is finished.
[0030]
If the delivery date of the product ordering data to be processed in ST11 is within the handling period of the product file record or product reservation file record detected from the product file 21 or product reservation file 22, the detected product is detected as ST13. Obtain the supplier code from the file record or product reservation file record. Then, in ST14, the supplier file 25 is searched using the supplier code as a search key, and a supplier file record whose search key matches the supplier code is read.
[0031]
When the corresponding supplier file record is read from the supplier file 25 in this way, the order date of the product ordering data to be processed on the day of the week designated as the orderable day of the supplier file record as ST15. It is judged whether or not.
Here, if the order date is a day designated as an orderable day, the delivery date of the ordered product is calculated from the delivery day corresponding to the orderable day as ST16. For example, when the orderable day is Monday and the corresponding delivery date is Tuesday, if the order date is Monday of the 16th, the delivery date is calculated as the 17th day of the next day. Similarly, if the orderable day is Saturday and the corresponding delivery date is Monday, if the order date is Saturday of the 21st, the delivery date is calculated as the 23rd day after that.
[0032]
If the delivery date is calculated in ST16, next, in ST17, it is determined whether or not the delivery date of the product ordering data to be processed coincides with the calculated delivery date.
If the delivery dates match, the designated flight number is acquired from the product file record or product reservation file record detected from the product file 21 or product reservation file 22 in ST18 or ST8 as ST18. Then, in ST19, it is determined whether or not the flight number of the product ordering data to be processed matches the acquired designated flight number.
[0033]
If the flight numbers match, the maximum order quantity is acquired from the store file record or the store reservation file record detected from the store file 23 or the store reservation file 24 in ST1 or ST3 as ST20. Then, in ST21, it is determined whether or not the maximum order quantity exceeds the order quantity of the product order data to be processed.
[0034]
As a result, if the number of orders of the product ordering data to be processed is equal to or less than the maximum number of orders, it is determined that the product ordering data to be processed is valid data without error, and the product ordering data is set as ST22. Is registered in the order data file 12. Thus, the processing for the product ordering data is finished.
[0035]
On the other hand, if the order date of the product order data to be processed in ST15 is not specified as the orderable day of the supplier file record, the product order to be processed together with the error code of the order date input error The data is registered in the error data file 13 and the processing for the product ordering data is finished.
[0036]
If the delivery date of the product ordering data to be processed in ST17 does not match the delivery date calculated in ST16, the product ordering data to be processed together with the error code of the delivery date input error is stored in the error data file 13. The registration and the processing for the product ordering data are finished.
[0037]
If the flight number of the product ordering data to be processed in ST19 does not match the specified flight number of the corresponding product file record or product reservation file record, the product to be processed together with the error code of the flight number input error The order data is registered in the error data file 13, and the processing for the product order data is finished.
[0038]
Further, when the number of orders of the product ordering data to be processed in ST21 exceeds the maximum order number of the corresponding store file record or store reservation file record, the product order to be processed together with the error code of the order quantity input error. The data is registered in the error data file 13 and the processing for the product ordering data is finished.
[0039]
As described above, in the present embodiment, the product order management apparatus 1 that can receive the product order data transmitted from the ordering terminal 2 provided in each store via the communication unit has an ordering condition for each product. As parameter storage means for storing parameters in advance, a product file 21, a product reservation file 22, a store file 23, a store reservation file 24, and a supplier file 25 are provided. In the product file 21, data of items such as a product code, a supplier code, a handling period, and a designated flight number of each product currently sold is set in advance. Further, in the product reservation file 22, data of items such as a product code, a supplier code, a handling period, and a designated flight number of each product scheduled to be sold in the future are set in advance for each sales start date. Further, in the store file 23, for each store, the product code, the maximum order quantity, etc. of each product sold at that store are set in advance for each store code. In the store reservation file 24, for each store, the product code, the maximum number of orders, etc. of each product scheduled to be sold at that store are set in advance for each sales start date and each store code. Further, in the supplier file 25, data of each item such as a supplier code of each supplier such as a wholesaler or a wholesaler, an order classification, an orderable day of the week, and a delivery day of each orderable day of the week are set in advance. Yes.
[0040]
Therefore, in the product order management apparatus 1, the order data transaction processing unit 11 functions every time the product order data having the record configuration shown in FIG. 2A is received from the order terminal 1 of each store. Then, referring to the parameters stored in the product file 21, the product reservation file 22, the store file 23, the store reservation file 24 and the supplier file 25, the validity of the received product ordering data is determined. .
[0041]
Specifically, first, it is determined whether or not the ordered product is a product to be sold at the ordering store (ST1 to ST5 in FIG. 3). If it is a product to be sold, the handling period of the ordered product is checked (ST6 to ST11 in FIG. 3). If it is within the handling period, it is next determined whether or not ordering is possible on the ordering date specified by the product ordering data (ST13 to ST15 in FIG. 4). If the order can be placed, it is next determined whether or not delivery is possible on the delivery date designated by the product order data (ST16 to ST17 in FIG. 4). If delivery is possible, it is next determined whether delivery using the flight number specified by the product ordering data is possible (ST18 to ST19 in FIG. 4). If delivery using the designated flight number is possible, it is next determined whether or not an order with the number of orders designated by the product ordering data is possible (ST20 to ST21 in FIG. 4).
[0042]
Thus, when the designated number of orders can be placed, it is determined that the received product order data is valid. Then, the product ordering data determined to be valid is registered in the ordering data file 12.
[0043]
Note that the merchandise ordering data determined to be invalid in the legitimacy determination process of the received merchandise ordering data is registered in the error data file 13 together with an error code indicating the illegal item. For example, when the ordered product is not sold at the ordering store, the corresponding product ordering data is registered in the error data file 13 together with the error code of the unhandled error. If the ordered product is outside the handling period, the corresponding product ordering data is registered in the error data file 13 together with the error code of the outside handling period error. In addition, if the order cannot be placed on the order date specified in the product order data, the delivery is not possible on the delivery date, or the delivery with the designated flight number is impossible, or If the specified number of orders cannot be placed, the corresponding product order data is registered in the error data file 13 together with an error code such as an order date error or a delivery date error.
[0044]
Thus, the product ordering data registered in the error data file 13 is printed out or displayed as an error list 14 by the function of the ordering data maintenance unit 15. Thereby, the person in charge of ordering at the headquarters causes the ordering data maintenance unit 15 to function based on the error list 14 and corrects the error in the product ordering data.
[0045]
The product order management apparatus 1 according to the present embodiment uses the function of the order slip creation unit 16 to convert the product order data registered in the order data file 12 and the product order data modified by the order data maintenance unit 15. Based on this, an order slip is created for each supplier. In this case, according to the order classification of the supplier file record set in the supplier file 25, the order slip data for the supplier who issues the purchase slip online is converted to data for online transmission. And stored in the online ordering data file 17. Further, order slip data for a supplier that issues a purchase slip by facsimile communication is converted into data for facsimile communication and stored in the FAX order data file 18. Order slip data for a supplier who issues a purchase slip by hand is converted to printout data and stored in the slip issue data file 18. Then, the order slip data stored in the online order data file 17 is transmitted to a corresponding supplier through a public telephone line or a network such as ISDN, and a product order is placed. Further, the order slip data stored in the FAX order data file 18 is transmitted to a corresponding supplier via a facsimile line to place a product order. Further, the order slip data stored in the slip issue data file 18 is printed out by a printer, and the product can be ordered by handing the order slip.
[0046]
As described above, according to the present embodiment, it is possible to automatically determine whether or not the product ordering data input at the ordering terminal 2 is valid, and the product based on the valid product ordering data. Since it is possible to place an order, it is possible to eliminate the complicated check work of the product ordering data input at the ordering terminal 2. In addition, since it is possible to eliminate the problem of placing orders with suppliers with incorrect data such as order date, delivery date, flight number, number of orders, etc., it is possible to prevent troubles with suppliers and to make ordering work. Can be performed efficiently.
[0047]
Further, the product ordering data having an error is temporarily stored in the error data file 13 together with information (error code) for identifying which part is an error, and is corrected later, so that the correction is easy. In addition, it is possible to easily diagnose from which store the ordering data has many errors.
[0048]
Needless to say, the check items of the product ordering data are not limited to those of the one embodiment. Needless to say, the order of checking is not limited to the order of the embodiment.
[0049]
【The invention's effect】
  As detailed aboveMain departureAccording to Ming, it is possible to automatically determine whether or not the product order data entered at the ordering terminal is valid, and to place a product order based on the valid product order data. We can provide a product order management device that can reduce order data check work and reduce order errors.The
[Brief description of the drawings]
FIG. 1 is a block diagram showing a functional configuration of an embodiment of the present invention.
FIG. 2 is a diagram showing a record configuration of product ordering data and various data files used in the embodiment.
FIG. 3 is a flowchart showing the first half of the processing procedure of the ordering data transaction processing unit in the embodiment;
FIG. 4 is a flowchart showing the latter half of the processing procedure of the ordering data transaction processing unit.
[Explanation of symbols]
1. Product order management device
2 ... Ordering terminal
11 ... Order data acquisition processing section
12 ... Order data file
13 ... Error data file
15. Order data maintenance department
16 ... Order slip creation department
21 ... Product file
22 ... Product reservation file
23 ... Store file
24 ... Store reservation file
25 ... Supplier file

Claims (2)

Create the product order data from the input means to input the data of the items necessary for ordering the product such as the product code, order quantity, order date, delivery date, etc. A merchandise ordering management apparatus that connects to an ordering terminal having a data transmission means for transmission and output via a communication means and places an order for each merchandise based on the merchandise ordering data received from the ordering terminal via the communication means In
A product file that stores the supplier code, handling period, etc. corresponding to the product code of various products,
In correspondence with the supplier codes of various suppliers, a supplier file that stores the days of the order that can be ordered, the days of delivery by orderable days of the week, and the like,
Product determining means for receiving product ordering data from the ordering terminal via the communication means and searching the product file to determine whether or not a product code embedded in the product ordering data is registered; ,
When it is determined that the product code is registered by the product determination means, a handling period corresponding to the product code is acquired from the product file, and the delivery date incorporated in the product ordering data within the handling period Delivery date judgment means for judging whether or not included,
If it is determined by the delivery date determination means that the delivery date is included in the handling period, a supplier code corresponding to the product code is obtained from the product file, and the supplier file is searched to search for the supplier. An order date determination means for obtaining an orderable day corresponding to the destination code and determining whether or not the order date embedded in the product ordering data is the orderable day;
Comprising
A product order management apparatus characterized in that an order is placed for each product based on the product order data determined by the order date determination means that the day of the order date is an orderable day of the week . A delivery date calculating means for calculating a delivery date from a delivery day of each orderable day, a date of the order date and a day of the week when the order day judging means judges that the order day is an orderable day; ,
Delivery date validity judgment means for judging whether the delivery date calculated by the delivery date calculation means coincides with the delivery date included in the product ordering data;
2. The product order management apparatus according to claim 1 , wherein an order for each product is placed based on the product order data determined by the delivery date validity judgment means to match the delivery date .

Images