JPH02144662A - Order entry system - Google Patents

Abstract

PURPOSE:To simplify the ordering work of a shop side by referring a preceding sales register and a current sales register stored in a center, forecasting the reference quantity of ordering in the succeeding ordering period, answering the forecasted quantity to respective shops and determining the quantity of order based upon OK or correction information. CONSTITUTION:A sales processing part 4 registers sales data informed from respective shops in the current sales register 8 and a sales forecasting processing part 5 refers the current sales register 8, the preceding sales register 9 and a commodity similar table 10 to forecast the reference ordering quantity of the succeeding ordering period. An order processing part 6 determines the reference order quantity or the order quantity obtained by correcting the reference one as the order quantity of the succeeding ordering period based upon the OK or correction information corresponding to the answer of the reference ordering quantity to respective shops and stores the determined results in an ordering master 11. Thus, the ordering work of the shop side can be simplified.

Description

[Detailed Description of the Invention] (Summary) Regarding an order entry system that performs order processing based on sales data, the standard order quantity for the next ordering period is predicted by referring to the previous year's sales ledger and current year's sales ledger held by the center. The system then responds to each store and determines the order amount based on the notification of OK or correction information.The purpose of this is to greatly simplify the ordering process for each store, and to notify each store of sales data. The sales processing section receives the information via the line and stores it in the current period sales ledger, and the sales information stored in the current period sales ledger and nij period sales ledger is used to calculate the sales information for the next ordering period (for example, the next month). In response to the sales forecast processing unit that predicts the standard order quantity and the standard order quantity predicted by this sales 1-sub-measurement processing unit being answered via the line for each store, an OK or correction information notification is sent. The order processing section fil determines the order amount for the next ordering period based on the information received via the line, and the order processing section fil is configured to place an order based on the order amount determined by the order processing section.

[Industrial application field]

The present invention relates to an order entry system that performs order processing based on sales data.

[Conventional technology and inventions attempt to solve the problem [J] Traditionally, it has been an economic burden for small-scale retail stores to have separate computers for processing orders, etc.; I use stock as a reference, and based on my years of experience, I decide on the number of pairs of products for the following month and place an order. Therefore, there was a problem in that the ordering process became complicated.

The present invention refers to the previous year's sales ledger and current year's sales ledger held by the center, predicts the standard order amount for J6 in the next ordering period, replies to each store, and in response, notifies the store of OK or correction information. The purpose of this system is to determine order quantities based on

[Means to solve problems]

FIG. 1 shows the basic structure of the present invention. In FIG. 1, a sales processing section 4 stores sales data inputted from the terminals 12 of each store in a sales ledger 8 for the current period.

The sales forecast processing unit 5 calculates the standard order amount for the next ordering period (for example, the next month) based on the sales information read from the current period sales ledger 8 and the previous period sales ledger 9 and the similar products read from the W4 product table 10. It is a prediction.

The order processing unit 6 determines the order amount for the next order period based on the notification of OK or correction information in response to the reply of the predicted standard order amount to each store, and stores it in the order master 11. [Operation] In the present invention, the sales processing section 4 registers the sales data notified from each store in the current period sales ledger 8, and the sales prediction processing section 5 registers the sales data notified from each store in the current period sales ledger 8, the previous period sales ledger 9, and the product similar to the current period sales ledger 8. The standard order amount for the next ordering period (for example, the next month) is predicted with reference to the table 10, and based on the notification of OK or correction information corresponding to the order processing unit 6 replying the standard order amount to each store, The standard order amount or a modified order amount is determined for the next order period and stored in the order master 11.

Therefore, each retail store only needs to notify center 1 of monthly sales data, for example, and the center will respond with the predicted standard order amount and display it on one screen, so it can be OKed or modified. It becomes possible to place an order for a product through the extremely simple task of notifying information.

(Embodiment) Next, the configuration and operation of an embodiment of the present invention will be explained in detail using FIGS. 1 to 8.

In FIG. 1, a center 1 is connected to each terminal 12 via a line, and is composed of terminals 2 to 11.

The communication processing unit 2 communicates with the terminal 12 via a line.

The terminal recognition unit 3 recognizes that the terminal ID notified from the terminal 12 is
This is to check whether it is registered in the ID master tough.

The sales processing unit 4 registers the sales data input from the terminal 12 into the current period sales ledger 8.

The sales forecast processing unit 5 stores a current period sales ledger 8 and a previous period sales ledger 9.
, and the similar product table 10 to predict the sales for the next ordering period (for example, the next month, etc.) to determine the standard order amount (described later).

In response to the reply of this standard order quantity to each terminal 12, the sweat processing unit 6 sends this standard order quantity or (lk corrected order quantity) to the order master 11 based on the notification of OK or reconnaissance information request. It is to be registered in .

The ID master 7 has the terminal ID of the terminal 12 registered in advance.

The current term sales table IK8 stores the current term's sales data input from the terminal 12.

The previous term sales ledger 9 stores sales data for the previous term.

The similar product table 10 is a table in which products from the previous period that are similar to new products of the current period are registered in advance.

The order master 11 stores the determined order amount for the next order period (for example, the next month).

The terminal 12 is a PO8 terminal (dedicated distribution terminal) installed in a store, retail store, or the like.

FIG. 2 shows an overall system configuration diagram according to the present invention.

In Fig. 2, the POS terminal 12-1 is used by a retail store to read the product code 1' and display/print the product name, price, number 1, total price, etc. in response to a customer's purchase of a product. It is something. These sales data are shown in the IC card 1
It is recorded in 2-2. The IC where this sales data is recorded
Car)! 2-2 as necessary, insert it into the reader/writer 12-3, and connect it to the Videotex terminal (VTX&
A) 12-4 sends the video tex communication processing via the public telephone network to the center 1 of this embodiment via a dedicated line. This center 1 has the configuration shown in FIG. 1, stores the notified sales data in the sales ledger 8, and also refers to the current sales ledger 8, the previous sales ledger 9, and the similar products table 10. Forecast the standard order amount for the next month, etc.

This predicted standard order quantity is displayed on the screen of the Videotex terminal 12-4 following the reverse route. The retail store looks at the displayed standard order quantity, and if it determines that the order quantity for the next month is acceptable, it is OK; if not, it inputs the revised order quantity and notifies the center 1. Center 1 is
In response to the OK or revised order quantity, the standard order quantity or the corrected order quantity is stored in the order master 1]. Then, the UL sales company is notified of this order amount via a specific line, etc., and the order is placed.

Next, the operation of the configuration shown in FIG. 1 will be explained according to the order shown in FIG.

In FIG. 3, ■ indicates that the terminals 12 of each store access the center 1.

(2) is a terminal registered in advance in the ID master with the terminal ID notified from the terminal 12 by the terminal recognition unit 3 in FIG. 1 on the center side! It compares with D and recognizes which terminal (store) it is.

In case (2), since the terminal +D was recognized on the center side, OK was returned to the terminal 12 at each store.

(2) inputs sales data from the terminal 12 of the famous store. This is, for example, the IC extracted from Figure 2 PO3ll-1.
This means that the card 12-2 is loaded into the reader/writer 12-3 and the Videotex terminal 12-4 inputs sales data to the center 1.

■ is received by the "sales" processing unit 4, and new data is added to the current period's orders/sales/out of stock file (current period sales ledger 8). For example, the values for May and June shown in the current term actual values of the sales table Φ length for the session in Figure 5 are added as shown.

For ■, at the same time as the processing for ■, the sales forecast processing unit 5 generates the previous term's order/sales/out of stock file (previous term's sales ledger 9, see Figure 4).
Based on this, the latest sales forecast is output by taking into account the current term's orders/sales 7' out-of-stock file (current term's sales ledger 8, see Figure 5) (referring to the similar product table 10 if necessary). The information is transmitted to the order processing unit 6 (described later).

■ At the same time, the order processing unit 6 replies to the terminal 12 with the standard order quantity based on the sales forecast data, and at the same time, the order master 11
Hefail.

(2) The center 1 sends the latest standard order quantity to the terminal 12 of each store.

■After checking the standard order quantity sent from center 1 at each store (for example, after checking the seventh drawing), ■the number i
If OK, send a confirmation signal to center 1 with O). On the other hand, if you wish to make any changes to the order quantity due to store-level or other special characteristics, enter them on the correction screen (see Figure 8).
(e Notify the center of the correct information.

0 means - bulk ordering (per store). This registers the standard order quantity in the order master 11 in response to an l811 confirmation signal from the terminal 12 of each store indicating that the standard order quantity is sufficient.

(2) In response to the zero correction information from the terminal 12 of each store indicating that the standard order quantity will be revised, the ordered quantity of masks is replaced with a new order quantity and filed (registered).

Through the above procedure, the month is entered into the order master 11, and the center 1 side refers to the current period's sales ledger 8, the previous period's sales table [9, and the similar product table 10, and calculates the predicted standard order amount or the store's circumstances. It becomes possible to register the order amount after correction in the order mask 11 by a simple operation.

Next, regarding sales forecasts, we will talk about summer products (available from May to August).
Let's specifically explain summer foundation foundations (month) in (column).

(11) The forecast of the order amount for this season's summer products at the stage before the start of this season's summer product handling period is referred to as the ``beginning forecast.'' This will be explained below.

Sales target for each month of this term = (sales results for the same month of the previous term, out-of-stock results from the previous term one month ago) x
Head office correction value・・・・・・・・・・・・(1)Here, the head office correction value is a correction value that corrects the differences in climate, fashion, distribution status, etc. between the previous year and this year (here, for convenience, - 1.1). Then, each month's sales data registered in the first half sales ledger in FIG. 4 is substituted into Equation 10 to obtain each month's sales target.

NowyI May sales target - (previous May sales result 80 units + previous term April out-of-stock result)
) Xl, 1-811・・・・・・・・・・・・(2)
Sales target for June of this term - 99 (3) Sales target for July of this term - 154 (4) Sales target for August of this term - 110・・・・・・(5) Therefore, orders for this period 1'-88+99+154+110-451
...(6).

(2) The forecast of the order amount for this season's summer products for the remaining months of the current season's summer product sales period is called the "period forecast." This will be explained below.

Error correction value - Total of current fiscal year's actual months (sales, out of stock) / Total sales target for each month of current fiscal year's actual months at the time of the initial forecast...
・・・・・・・・・・・・・・・(7) For example, in May of this term,
When forecasting the remaining months of July and August when the sales results for June are available, the error correction value - (sales results for May and June of the current period + out-of-stock results for April and May) / beginning forecast Sales target for May and June = (100+100÷10)/(8B÷99)-21
0/187 ±1.12・・・・・・・・・・・・・・・fil
becomes.

New sales target for each remaining month - sales target for each remaining month at the beginning of the period x error correction value x short-term correction (head office)...
・・・・・・・・・・・・・・・(9) Here, short-term correction is a short-term correction amount, and depends on climatic conditions such as short summer or cool summer in the remaining months, and is as follows. - Calculations are carried out using the rule as 0.9.

For example, when calculating (8) above, new sales target for July = 154 Xl, 12X0.9 (short-term correction) = 155
・・・・・・・・・・・・・・・QOI new sales target for August -11, OXl, 12X0.9 (short-term correction) -111・
・・・・・・・・・・・・・・・・aI].

Total new remaining monthly orders = Σ New remaining sales for each month” 2 targets・・
・ ・ ・ ・ ・ ・ ・ ・ ・ ・ ・ ・
・ ・ ・ ・ ・ ・ ・Oa For example, the above a0, αυ
In the case of , new remaining monthly order quantity 81 -155 + 111 M7C3・・・・・・・・・・・・・・・・・・ Q31 Based on the above steps, new The standard order quantity for July and August is predicted to be QOI, a value of 0υ.

Part 4!7I shows an example of the previous year's sales ledger. Kosai 1 is Mi
+ Sales of the 11 poems of the month - ■ - Data 2 is what the center has, AA store, AB store... YX store, Y
Z stores are maintained for each store called Y store. As sales data, order amount, sales, hffi, and product t13 weight are registered as shown in the figure.

Figure 5 shows an example of the sales ledger for the current term. This is the monthly sales data for the current term and the one held by L7 center 1, including AA store, AB store, YX store, YY store, etc. It is maintained for each store, such as a store. Here, April, May, June
Monthly sales data has been registered.

FIG. 6 shows an example of a similar product table, in which relationships between similar products are registered. For example, in the case of a new product,
``××Fundesin'' and “××゛Fandemi・
``Shin'' (new product) are considered to be the same product, and the above-mentioned predictions are made by regarding them as the same product.

Therefore, by registering, for example, similar product names and new product names in this similar product table 10, even if a similar new product is released in the current period, it will be different from the old product from the previous period. By making the association, it becomes possible to easily perform sweat pre-cleaning.

FIG. 7 shows an example of a standard order quantity confirmation screen 7 This is an example of a screen in which the standard order quantity 711 predicted and answered by the center 1 is displayed on the terminal 12 of each store. This screen displays the store name,
Item number, product name, previous term total (sales, out of stock), current term May results (
Sales, out of stock), now! ! Jl June results (sold) 2, out of stock
, the July sales forecast for the current term, the August sales forecast for the current term, and the standard order quantity are calculated as described above or calculated from FIGS. 4 and 5, and are displayed as shown in the figure. Look at this standard order confirmation screen, and if OK, send the sulfur approval signal shown in Figure 3 [Phase] to Center 1.
send to

On the other hand, if it is desired to modify the standard order quantity, enter the ordering company on the 8M modification input screen and send it to the center 1 as the modification information shown in FIG. In response to this, the center 1 registers the standard order quantity or the revised new order quantity in the order master 11, as described above. The order amount registered in the order master 11 is then transferred to a sales company or the like via a specific line, and the order is placed.

〔Effect of the invention〕

As explained above, according to the present invention, the standard order quantity for the next order quantity ■11 is predicted by referring to the current term sales table IIKB, the previous term sales ledger 9, and the similar product table 10 held by the center 1, We have adopted a configuration in which each store responds to the request and determines the order amount based on the OK or correction information, so each store only needs to notify center 1 of sales data for each month, for example. Since the standard order quantity predicted by the center is answered and displayed on the screen, it is possible to place an order for the product by an extremely simple task of looking at the answer and notifying the customer of the OK or correction information. This greatly simplifies the store's ordering process.

Example of data confirmation procedure, Figure 4 is an example of the previous term's sales ledger, Figure 5 is an example of the current term's sales ledger, Figure 6 is an example of a similar product table, and Figure 7 is an example of the sales ledger for the current term.
The figure shows an example of the standard order quantity confirmation screen, and FIG. 8 shows an example of the correction input screen.

In the figure, 1 is the center, 4 is the sales processing section, 5 is the sales forecast processing section, 6 is the order processing section, 8 is the current sales ledger, 9 is the sales ledger, 10 is the similar product table, 11 is the ordering mask, 1
2 represents a terminal.

Claims (2)

[Claims] (1) In an order entry system that processes orders based on sales data, there is a sales processing unit (4) that receives notifications of sales data for each store via a line and stores them in the current period sales ledger (8); A sales forecast processing unit (5) that predicts the standard order amount for the next ordering period (for example, next month, etc.) based on the sales information stored in the current period sales ledger (8) and the previous period sales ledger (9).
In response to the standard order amount predicted by this sales forecast processing unit (5) being answered via the line for each store, OK is sent.
Alternatively, the order processing unit (which determines the order amount for the next order period based on the notification of modification information received via the line)
6), and is configured to place an order based on the order amount determined by the order processing unit (6). (2) When predicting the above standard order quantity, refer to the similar product table (10) in which similar products for a certain product are registered in advance, obtain sales information including the similar products, and place the next order based on this. The order entry system according to item (1), wherein the order entry system is configured to predict the order amount for a period.