JPS62221066A - Order reception processing system - Google Patents

Abstract

PURPOSE:To shorten the long slip processing time for the reception of orders and to reduce the working load of an operator for the reception of orders, by inputting the data on the total number of orders received for each goods, the data on the number of received orders at every customer, and the prescribed distribution ratio data on distribution of short stock goods to each customer when the stock is in short. CONSTITUTION:In case the input total number of received orders are not satisfied owing to the shortage of stock, each customer code is inputted through a keyboard 1 together with the distribution ratio set previously by an operator for the reception of orders. These input codes and distribution ratio are stored in a customer code column 13 and a distribution ratio column 14 respectively of a control table 4 for customers and goods distribution ratio. When the input is completely through with the distribution ratio, the operator informs a host computer the end of input of the distribution ratio through the keyboard 1. Then the operator calculates the number of orders received at every goods and stores the corrected number of received orders in a control table for number of orders received in goods-customer correspondence.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to an order processing system using long slips used in the so-called distribution industry, particularly chain stores, in which order data for each customer is listed for each product. .

[Conventional technology]

FIG. 5 shows an example of a conventional order processing system using long slips.

The order worker manually re-invoices each customer-specific order receipt 300 based on the product-specific order receipt 200 (so-called long slip) in which order data for each customer is listed for each product.
Orders were processed by computer.

Additionally, when allocating to the right bank, in the event of a product shortage, the amount that can be allocated is distributed to each customer, but this process was also done manually by the order-receiving worker. .

[Problem that the invention seeks to solve]

As mentioned above, in the conventional order processing system using long slips, most of the order processing work, such as reprinting slips and distributing the amount reserved in case of inventory shortage, was performed by seven manual calculations. However, even when processing one long slip, it takes a very long time and requires a lot of labor on the part of the operator.

[Means for solving problems]

The system of the present invention includes input means for inputting total order quantity data for each product, order quantity data for each customer, and predetermined distribution ratio data for distributing the short-of-stock products to each customer when there is a stock shortage; A product/customer-based order quantity management table in which order quantity data for each product/customer and allocated quantity data for each product are arranged on a matrix consisting of code and customer code, and an order quantity management table for each customer entered above. A product distribution ratio management table for each customer in which distribution ratio data for products is arranged, an inventory storage means for storing inventory quantity data for each product, and said inventory storage means in response to input of total order quantity data for each product. Read the inventory quantity data of the corresponding product from the above and compare it with the total order quantity data, and if the inventory quantity data is greater than or equal to the total order quantity data, the total order quantity data is transferred to the order quantity management table corresponding to the product/customer. writes the value of (the inventory quantity data - the total order quantity data) into the inventory quantity data column of the corresponding item of the inventory storage means as new inventory quantity data; When the inventory quantity data is smaller than the total order quantity data and there is a shortage of inventory, the inventory quantity data is used as the product.
Inventory allocating means writes in the allocated quantity data column of the corresponding product in the order quantity management table corresponding to the customer, and sets the inventory quantity data of the corresponding product in the inventory storage means to zero;
The order quantity data for each customer entered when there is no inventory shortage is written in the corresponding column of the product/customer order quantity management table, and when there is an inventory shortage, the input distribution ratio data for the corresponding product is written to the customer. Write to the separate product distribution ratio management table, determine the new order quantity for each customer from the distribution ratio and the allocated quantity data of the corresponding product in the order quantity management table for the product/customer, and determine the new order quantity for each customer. Write in the corresponding column of the corresponding order quantity management table, compare the sum of the new order quantity and the reserved quantity, and if a difference occurs, write the quantity of the reserved quantity 1 and the stock quantity of the corresponding product in the inventory storage means. an editing means for updating the data based on the difference, reading out the order quantity of the product for each customer in the product/customer order quantity management table in response to an external output request, and editing the order slip for each customer; It consists of:

〔Example〕

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention, in which inventory allocation processing is also performed at the same time as order slip creation for each customer. In Fig. 1, 1 is a keyboard, 2 is a display screen, 3 is a product/customer-based order quantity management table, 4 is a product distribution ratio management table for each customer, 5 is an inventory file that manages inventory quantities for each product, Reference numeral 6 denotes an editing means for editing order slips for each customer, 7 an inventory allocation means for performing allocation processing based on inventory amount and order amount, and 8 a printer.

Next, the functions of each part will be explained. Keyboard 1 is used to input the total number of orders for each product, the order quantity for each customer, the product distribution ratio for each customer, etc.0 Display screen 2 displays the confirmation of input from keyboard 1 and the result of inventory allocation. It is something to do.

The product/customer-based order quantity management table 3 manages the order quantity using a matrix of products and clients, and its details will be explained using FIG. 3. 9 stores the ordered product code.

10 stores the total quantity of each ordered product. 1.

In this table, the order quantity of each customer is stored for each product (vertical direction), and after the table is completed, the order quantity of each product is retrieved for each customer (horizontal direction). You can create order slips.

The product distribution ratio management table 4 for each customer temporarily stores the allocation ratio when an inventory shortage occurs, and its details will be explained using FIG. 4. 13 stores customer codes to which products should be distributed based on the ratio. 14 stores the distribution ratio. 15 stores an address indicating which product of product code 9 is to be distributed.

The inventory file 5 is a file that has the product code of each product as a search key and manages the product name, inventory quantity, and unit price of each product.

The printer 6 is used to print out the customer-specific order receipt edited by the editing means 6.

Next, the operation will be explained based on the processing flow shown in FIG.

In FIG. 2, an order-receiving worker inputs the product code of each product and the total order quantity from the keyboard 1. Search the inventory file 5 using the input product code, and if there is information on the corresponding product, compare the input total order quantity with the inventory quantity in the inventory file 5, and if the corresponding product code exists in the inventory file 5. If not, a warning will be displayed on display screen 2. 6. When comparing the above-mentioned total ordered quantity and stock quantity, if total ordered quantity ≦ stock quantity, the total ordered quantity will be allocated to display screen 2 as the reserved quantity. The quantity is displayed, and the inventory quantity in the inventory file 5 is decreased from the total ordered quantity. If the total quantity of orders is greater than the quantity in stock, the quantity in stock is displayed on the display screen 2 as the allocated quantity 7, and at this time, the reason for the stock shortage is also displayed. Further, 0 is stored in the inventory quantity of the inventory file 5. After the inventory allocation process, the product code inputted in the product code column 9 of the product/customer-based order quantity management table 3 is stored, and the allocated quantity is stored in the allocated quantity column 10.

Based on the information displayed on display screen 2, the order-receiving worker can confirm that if the total order quantity entered has been allotted,
Using the keyboard 1, enter the customer code and order quantity for each customer. The host computer searches the customer code column 11 of the product/customer order quantity management table 3 using the input customer code, and if the customer code is found as a result of the search, it corresponds to the product code being input. Store the order quantity in the order quantity ll 112, and if the customer code is not found as a result of the search, add and store the customer code in the customer code field 11, and store the order quantity corresponding to the product code being input. Store the ordered quantity in quantity 1fil12.

If the entered total order quantity is not allotted due to inventory shortage, the customer code of each customer and the distribution ratio set in advance by the order-receiving worker are input using the keyboard 1. The entered customer code and distribution ratio are in the product distribution ratio management table 4 by customer.
are stored in the customer code field 13 and the distribution specific gravity unit 14, respectively. When all the distribution ratios have been input, the order receiving worker notifies the host computer from the keyboard 1 that the input of the distribution ratios has ended.

As a result, each order quantity is calculated using the following formula.

k Total EC of distribution ratio.

II Snow 1 The above-mentioned newly corrected order quantity is stored in the order quantity management table corresponding to the product customer using the above-described storage method. In addition, the new order quantity obtained by calculation is added up one by one, and finally, if there is a difference between the two, which is compared with the allocated quantity on the allocated quantity meter 10 (in this case, (allocated quantity < calculation However, the difference is returned to the stock quantity in the inventory file 5, and the total ordered quantity is stored again in the allocation quantity meter 10.

The order-receiving worker repeats the above-mentioned process for all ordered products and completes the product/customer-based order quantity management table 3. The host computer extracts the order quantity of each product for each customer based on the completed product/customer order quantity management table 3, and edits the order slip for each customer based on this information. do. The edited order receipt is printed out by a printer.

In this manner, in this embodiment, it is possible to automatically create an order receipt for each customer from an order receipt for each product.

〔Effect of the invention〕

As explained hereafter, the present invention enables processing of product-specific slips without having to manually reissue slips for each customer, and also processes order quantity distribution calculations when inventory is insufficient. It is possible to create order slips for each customer and also perform inventory allocation processing at the same time, reducing processing time for long slip order processing.
This has the effect of reducing the work of order-receiving workers.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing one embodiment of the present invention, and FIG. 2 (
a) and (b) are process flowcharts of the present invention, FIG. 3 is a diagram showing an order quantity management table for products and customers, and FIG.
The figure shows the product distribution ratio management table for each customer.
The figure shows a conventional order processing system using long slips. 1... Keyboard, 2... Display screen, 3... Order quantity management table for products and customers, 4... Product distribution ratio management table by customer, 5... Inventory file, 6
...Editing means, 7.Inventory allocation means, 8.Printer, 9.Product code column, 10.Allocation quantity meter, 11.Customer code column, 12.. -Order number shelf, 13...Customer code column, 14...Product distribution densitometer, 15...Product code column, 100...Computer system, 200...Order slip by product, 300.・
・Orders by customer Figure 2 ((L) Figure 2 (b)

Claims (1)

[Scope of Claims] Input means for inputting total order quantity data for each product, order quantity data for each customer, and predetermined distribution ratio data for distributing out-of-stock products to each customer in the event of inventory shortage; A product/customer-based order quantity management table in which ordered quantity data for each product/customer and allocated quantity data for each product are arranged on a matrix consisting of codes and customer codes, and for each customer entered above. a product distribution ratio management table for each customer in which distribution ratio data for each product is arranged; an inventory storage means for storing inventory quantity data for each product; The inventory quantity data of the corresponding product is read from the above and compared with the total order quantity data, and if the inventory quantity data is greater than or equal to the total order quantity data, the total order quantity data is transferred to the order quantity management table corresponding to the product/customer. writes the value of (the inventory quantity data - the total order quantity data) into the inventory quantity data column of the corresponding item of the inventory storage means as new inventory quantity data; When the inventory quantity data is smaller than the total order quantity data and there is a shortage of inventory, the inventory quantity data is written in the allocated quantity data column of the corresponding product in the product/customer-based order quantity management table, and the inventory storage means is stored. An inventory allocation means that sets the inventory quantity data of the corresponding product to zero, and writes the order quantity data for each customer, which was input when there is no shortage of inventory, into the corresponding column of the order quantity management table for the product/customer, and stores the inventory. When there is a shortage, the entered distribution ratio data for the corresponding product is written to the customer-specific product distribution ratio management table, and the distribution ratio is combined with the allocated quantity data for the corresponding product in the product/customer-based order quantity management table. Determine the new order quantity for each customer, write it in the corresponding column of the product/customer order quantity management table, compare the total of the new order quantity with the allocated quantity, and if a difference occurs, The allocated quantity and the inventory quantity data of the corresponding product in the inventory storage means are updated based on the difference, and in response to an external output request, the inventory quantity data of the corresponding product and customer is updated for each customer in the product/customer-based order quantity management table. An order processing system comprising: editing means for reading order quantities and editing order slips for each customer.