JPH056383A - Sales management system - Google Patents

Abstract

PURPOSE:To make it possible to draw stocks based upon the number of effective stocks at a certain future point. CONSTITUTION:A stock master file 2 time-sequentially manages the number of stocks by a time-sequential stock record 22. An ordering means 1 refers the file 2 and draws a stock corresponding to ordering information outputted from a customer. A production managing means 4 manages production in a plant 5 or the like and issues a product manufacturing command to the plant 5 or the like. An interface means 3 registers the record 22 corresponding to the product concerned in the file 2 when the means 4 issues the command.

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 (electronic computer system for sales management), and more particularly to product inventory management and inventory allocation in a sales management system.

[0002]

2. Description of the Related Art In a conventional sales management system, only the stock quantity of each product at the present time is managed.
The production volume of each product in the future was not controlled. Therefore, stock allocation has also been processed based only on the number of stocks at the present time.

[0003]

In the above-mentioned conventional sales management system, only the stock number of each product at the current point of time is managed. Therefore, when inventory of products with future delivery dates is reserved, , Only the current inventory quantity is referenced, and the inventory allocation is performed. Even if the delivery date is in the future, the inventory allocation is not performed if the inventory quantity is insufficient at the current point (at the future point in time). There is a drawback that it is not possible to make an appropriate stock allocation because the effective stock quantity is unknown.

In view of the above points, an object of the present invention is to provide a sales management system capable of stock allocation based on the number of stocks effective in the future.

[0005]

The sales management system of the present invention is an inventory master file for managing the number of stocks in a time series by a time series inventory record, and an order information from a customer by referring to the inventory master file. Ordering means for allocating inventory according to the above, production management means for managing production in a factory etc. and issuing a product production instruction to the factory, etc. And an interface means for registering a time series inventory record corresponding to the product in the master file.

[0006]

In the sales management system of the present invention, the inventory master file manages the number of stocks in time series by the time series inventory record, and the order receiving means refers to the inventory master file to inventory according to the order information from the customer. Allocation, production control means manage production in factories, etc., issue product production instructions to factories, etc., interface means issue the product production instructions by the production control means in the inventory master file Register the time series inventory record corresponding to.

[0007]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of the sales management system of the present invention. The sales management system according to this embodiment includes an order receiving unit 1 and an inventory master file 2.
, An interface means 3, a production control means 4, and a factory 5.

The inventory master file 2 has a product management record 21 (having product identification information (product name) etc.) corresponding to each product and some time-series inventory records under the product management record 21. 22 and manages the inventory numbers of a plurality of products in chronological order.

The time-series inventory record 22 under the product management record 21 relating to a certain product includes the date (the expected date of receipt of the product as inventory) and the number of stocks (the expected date of receipt). It has the number of products to be stored and the number of already allocated products (the number of products already allocated in the number of stocks, the initial value is 0).

Next, the operation of the sales management system of this embodiment constructed as described above will be described.

The production control means 4 controls production by the production activities in the factory 5, and issues a production instruction for producing each product as a part of the production control.

The interface means 3 is the production control means 4
Timing of issuing product production instructions by
Then, receipt information (information consisting of product name, expected receipt date and number of receipts) is received from the production control means 4, and the time series inventory record 22 in the inventory master file 2 is registered based on the receipt information. That is, under the product management record 21 related to the product name in the receipt information, the scheduled receipt date in the receipt information is set in the “year / month / date” item, and the number of receipts in the receipt information is set in the “inventory number” item. Register a time-series record 22 having “0” in the “already allocated number” item (several time-series inventory records 22 under the order of one product management record 21 in the order of “year / month / day” (in chronological order) ) Register to be linked to)).

The order receiving means 1 receives the order information (information consisting of product name, delivery date and number of orders) from the customer and performs the following processing.

The inventory master file 2 is searched based on the order information, and the time-series inventory records 22 under the product management record 21 related to the product name in the order information are sequentially searched to meet the delivery date from the customer. The time series inventory records 22 having the item “date” are detected one by one.

The effective stock quantity (stock quantity-already allocated quantity) is calculated based on the “stock quantity” and the “allocated quantity” in the detected time series inventory record 22.

If the inventory allocation corresponding to the number of orders is possible by the calculation of, the inventory allocation corresponding to the number of orders is performed, and the “already allocated number” in the time-series inventory record 22 is counted by the number of orders (number of inventory allocation). Upload and end the process.

When the stock allocation can be performed only for a part of the order number in the order information from the customer in the calculation of (including the case where the effective stock number is 0 and the stock allocation cannot be performed at all), the stock allocation is performed. The inventory allocation is performed by as many as possible, the next (sequentially next) time-series inventory record 22 satisfying the search condition of is detected, and calculation of and / or processing is performed.

Even if the above processing is repeated, it is not possible to allocate all the inventory corresponding to the number of orders, and when there is no time-series inventory record 22 that satisfies the search condition, inventory allocation cannot be performed. The fact is returned to the customer or the like, and the processing is ended.

[0020]

As described above, according to the present invention, inventory management in sales management is effective not only at the current inventory quantity but at the future moment by managing the inventory quantity at the future moment by the time series inventory record. There is an effect that it can be performed based on the number of stocks.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of an exemplary embodiment of the present invention.

[Explanation of symbols]

 1 Ordering means 2 Inventory master file 3 Interface means 4 Production management means 5 Factory 21 Product management record 22 Time series inventory record

Claims (1)

[Claims] [Claim 1] An inventory master file that manages the number of inventory in time series by a time series inventory record, and an inventory allocation according to order information from a customer by referring to the inventory master file. An order receiving means, a production management means for managing production in a factory or the like and issuing a product production instruction to the factory, and the product concerned in the inventory master file at the time of issuing the product production instruction by the production management means. And a means for registering a time-series inventory record corresponding to the sales management system.