JPH0573591A - Selling management system based on preceding arrangement managing master - Google Patents

Abstract

PURPOSE:To prevent the generation of a miss such as double production by preparing a preceding arrangement managing master in addition to an arrangement master, always grasping relation between preceding arrangement and determined arrangement, and even when distribution is divided at the time of its determination, executing processing without changing the preceding arrangement of a production process. CONSTITUTION:This selling management system is provided with the arrangement master 2 for storing and managing an arrangement record 4 including the ordering numbers, article names and the number of articles whose order has been determined, the preceding arrangement managing master 3 for storing and managing a preceding arrangement management record 5 including the article names and the number of articles precedently arranged and a determination processing means 8 to be started at the time of changing preceding arrangement to determined arrangement. The record 14 is stored in the master 2 based on the ordering number to be identified as an item relating to preceding arrangement at the time of determining ordering and a preceding arrangement drawing record 6 including the ordering number and the number of articles to be drawn is simultaneously registered in relation to the record 5 in the article corresponding to the preceding arrangement number concerned in the master 3. When required, a preceding arrangement drawing list 7 is outputted from the master 3.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a sales management system based on a pre-order management master, and more particularly to a sales management system based on a pre-order management master that does not cause an error when used as production order information for products based on build-to-order manufacturing. ..

[0002]

2. Description of the Related Art Conventionally, in a computer-based sales management system for products, which is based on build-to-order manufacturing, there is only one master that stores and manages necessary order information used for product production arrangements, etc. In order to make an advance order before the order is confirmed, a temporary order number is set and registered in the same master as in the case of the confirmed order. Although it is possible to change the order quantity registered in this master, if one advance order is divided into multiple orders when the order is confirmed, the order quantity of the order number set at the time of the advance order can be reduced. In addition, a new fixed order is processed by using a different order number.

[0003]

As described above, according to the conventional sales management method, the advance order and the fixed order by the fixed order are not managed separately, and therefore the advance order is divided into a plurality of fixed orders. In that case, it is not clear whether the order quantity set for the order number set at the time of advance order is changed and there is another new order or the advance order is divided into a plurality of confirmed orders. Therefore, when making production arrangements in an actual factory based on these order information, only the production for the slips of the new order number issued at the time of division is added, forgetting to change the quantity for the order number at the time of prior order. It was not uncommon to make mistakes such as heavy production and excess inventory.

It is an object of the present invention to provide a sales management system by the advance order management master which can prevent the double production error as described above.

[0005]

[Means for Solving the Problems] The sales management system using the advance order management master according to the present invention stores the order information including the product name and quantity of the confirmed order and manages the order by assigning the order number and the order master. The advance order management master that stores the order information including the item name and quantity for the order and manages it by assigning the advance order number and the advance order started in the order master when the contents of the advance order are changed to a confirmed order. An order number that can identify the relationship is given and the order information for the confirmed order is stored, and at the same time, the order number and allocation are associated with the preceding order management record of each item corresponding to the corresponding preceding order number in the preceding order management master. Confirm to output the advance reservation allocation list that shows the allocation information for each order number of each item from the advance order management master by registering the advance order allocation record including the quantity It is configured to include a physical means.

[0006]

Embodiments of the present invention will now be described with reference to the drawings.

FIG. 1 is an explanatory diagram showing the structure and operation of an embodiment of the present invention.

As shown in FIG. 1, the sales management system based on the advance order management master according to the present embodiment stores an order record 4 including an order number, a product name, and a quantity of fixed orders, and manages the order master 2. The advance order management master 3 that stores and manages the advance order management record 5 including the item name and the quantity of the advance order, and the order master 2 that is activated when the advance order is changed to the fixed order and is related to the advance order. The order record 4 is stored by giving an identifiable order number, and at the same time, the advance order allocation record 6 including the order number and the allocated quantity is preceded in association with the advance order management record 5 of each corresponding item of the corresponding advance order number. It is provided with a confirmation processing means 8 which is registered in the order management master 3 and outputs the advance order allocation list 7 from the advance order management master 3 if requested.

When the ordering information relating to the advance ordering is input from the input terminal 1, the advance ordering management master 3 is provided with the advance ordering number and information necessary for production such as delivery date and the advance ordering management record for each item. 5 is registered. The advance order management record 5 stores the item code and the ordered quantity of the ordered product expected to be ordered.

On the other hand, when a normal fixed order is input from the input terminal 1, an order record 4 is stored in the order master 2 in which information necessary for production and shipping such as items, quantities and delivery dates is registered together with the order number. ..

Next, when the advance order is confirmed and the orders are confirmed and the advance order is changed to the fixed order, the confirmation processing means 8 is activated. The confirmation processing means 8 gives an order number (for example, with a flag) capable of identifying an order related to advance order, and together with information indicating which advance order number the order number is related to, a normal fixed order. The order record 4 similar to the case of is registered in the order master 2. At the same time, the advance order management master 3 is associated with the advance order management record 5 of each item of the related advance order number, and the advance order allocation record 6 of this order number is registered to store the necessary allocation quantity. That is, each advance reservation allocation record 6
Has a parent-child relationship with the advance order management record 5 (the advance order management record is a parent), and when the advance order is divided into a plurality of fixed orders, a plurality of advance order management records 5 are provided. Advance reservation allocation record 6 is created.

After the completion of the above processing, if there is a request, the advance order management master 3 is referred to, and the advance order recording the item code and the reserved order number for each item of each advance order number. The allocation list 7 is output. In this case, the ordered quantity and the allocated quantity may be described together.

Regarding the production arrangement, the arrangement master 2
The order information of the order number (order number that is not flagged) unrelated to the preceding order in the order information and the advance order information of the advance order management master 3 are used. Perform necessary processing by using the ordering information of the order number. As a result, division processing at the time of a confirmed order can be performed without causing unnecessary confusion in production arrangements. If there is a difference between the pre-ordered quantity and the quantity when the order is confirmed and it is necessary to notify the production department of the change, create a pre-ordered allocation list including the ordered quantity and the allocated quantity from the pre-ordered management master. You can contact them at any time.

[0014]

As described above, according to the sales management system of the prior arrangement management master of the present invention, in addition to the arrangement master for storing the arrangement information of fixed orders, the advance arrangement management master for storing the arrangement information of the prior arrangement is provided. Since the relationship between advance orders and fixed orders is managed by the advance order management master, which fixed order corresponds to which fixed order even if there are multiple fixed orders when changing from advance order to fixed order Can be easily related. This has the effect of preventing mistakes such as double production during actual production in a factory.

[Brief description of drawings]

FIG. 1 is an explanatory diagram showing the configuration and operation of one embodiment of the present invention.

[Explanation of symbols]

 1 input terminal 2 ordering master 3 advance ordering management master 4 ordering record 5 advance ordering management record 6 advance ordering allocation record 7 advance ordering allocation list 8 confirmation processing means

Claims (1)

[Claims] 1. An order master that stores order information including the name and quantity of fixed orders and manages them by giving order numbers,
The advance order management master that stores the order information including the item name and quantity of the advance order and manages it by giving the advance order number, and is started when the contents of the advance order are changed to a confirmed order, and the advance order is placed in the order master. The order number that can identify the relationship with the order number is stored to store the order information for the confirmed order, and at the same time, the order number is associated with the preceding order management record of each item corresponding to the corresponding preceding order number in the preceding order management master. It is characterized by further comprising a confirmation processing means for registering a pre-arrangement reservation record including a reservation quantity and outputting a pre-arrangement reservation list showing reservation information from the preceding arrangement management master to each order number of each item according to an instruction. Sales management system based on advance order management master.