JPH11154280A - Real time inventory control system - Google Patents
Real time inventory control systemInfo
- Publication number
- JPH11154280A JPH11154280A JP31937897A JP31937897A JPH11154280A JP H11154280 A JPH11154280 A JP H11154280A JP 31937897 A JP31937897 A JP 31937897A JP 31937897 A JP31937897 A JP 31937897A JP H11154280 A JPH11154280 A JP H11154280A
- Authority
- JP
- Japan
- Prior art keywords
- inventory
- sales
- data
- store
- headquarters
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Cash Registers Or Receiving Machines (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
【０００１】[0001]
【本発明の技術分野】複数の店舗ＰＯＳからの売上デー
タを店舗サーバで集計し、ＬＡＮ−ＷＡＮなどの通信回
線経由で本部サーバの在庫データをリアルタイムで活用
・更新するシステムに係わる。BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system in which sales data from a plurality of stores POS are totaled by a store server, and inventory data of a head office server is used and updated in real time via a communication line such as a LAN-WAN.
【０００２】[0002]
【従来の技術】大規チェーン店では、多数の売上管理用
のＰＯＳ端末が用いられている。該ＰＯＳ端末はＬＡＮ
やＷＡＮなどの店内通信回線で、売上管理、在庫照会、
引当などを行う店舗サーバと通信接続されている。さら
に各店舗の店舗サーバはＩＳＤＮなどの公衆回線で本部
サーバ通信接続され、販売時点での売上管理データが定
時的に収集され、販売管理用データとして利用されてい
る。各店舗での商品在庫の管理は、店舗内の在庫管理サ
ーバと店舗サーバ間のみで行われる。売上管理データや
在庫管理データは、オフラインで本部サーバとの間で交
換される。この仕組みにおいては、販売時に店舗内の在
庫切れがあっても、本部在庫や他店在庫の転用などの迅
速な対応が出来ない。在庫切れ対応や商品在庫の回転率
向上のためのシステムが求められている。2. Description of the Related Art In a large chain store, many POS terminals for sales management are used. The POS terminal is LAN
Sales management, inventory inquiry,
It is communicatively connected to a store server that performs allocation and the like. Further, the store server of each store is connected to the head office server via a public line such as ISDN, and sales management data at the point of sale is collected regularly and used as sales management data. The management of the product inventory at each store is performed only between the inventory management server and the store server in the store. Sales management data and inventory management data are exchanged offline with the headquarters server. In this system, even if the stock in the store is out of stock at the time of sale, it is not possible to quickly respond to diversion of the stock of the headquarters or the stock of another store. There is a need for a system for dealing with out-of-stock and improving the turnover rate of product inventory.
【０００３】[0003]
【発明が解決しようとする課題】前記問題点に鑑み本発
明は、店舗サーバ側からリアルタイムで本部サーバの在
庫管理データを照会し、販売活用できる在庫管理システ
ムの構築を目的とする。SUMMARY OF THE INVENTION In view of the above-mentioned problems, an object of the present invention is to construct a stock management system capable of inquiring stock management data of a headquarter server from a store server in real time and utilizing the sales.
【０００４】[0004]
【課題を解決するための手段】顧客毎の売上入力処理を
行う複数のＰＯＳ端末と、ＰＯＳ端末より構内通信回線
を経由して売上商品データを送受信する通信手段と受信
した商品の店舗および本部の在庫を照会する在庫照会手
段と在庫確認された該在庫商品を売上に引当てる在庫引
当手段とを有する処理部と、売上管理データ、在庫管理
データ、引当管理データなどを記憶している主記憶部
と、各種データの入力や各種操作入力手段を有する入力
部とで構成する店舗サーバと、構内通信回線とＩＳＤＮ
などの公衆回線とを通信接続する通信ゲート機能を有す
るルータと、店舗サーバからの売上データ、在庫データ
などを送受信す通信手段と全店舗の売上管理手段と売上
商品の在庫照会手段と在庫確認された該在庫商品を売上
に引当てる在庫引当手段とを有する処理部と、全店舗の
売上管理データ、在庫管理データ、引当管理データなど
を記憶している主記憶部と、各種データの入力や各種操
作入力手段を有する入力部とで構成する本部サーバとで
構成する。A plurality of POS terminals that perform sales input processing for each customer, communication means for transmitting and receiving sales product data from the POS terminals via a local communication line, and a store and a headquarters for the received products A processing unit having inventory inquiry means for inquiring inventory and inventory allocating means for allocating the stock items whose inventory has been confirmed to sales, and a main storage unit for storing sales management data, inventory management data, allocation management data, etc. And a store server comprising an input unit having various data input and various operation input means, a private communication line and an ISDN.
A router with a communication gate function for communication connection with public lines such as, a communication means for transmitting and receiving sales data and inventory data from the store server, a sales management means for all stores, a stock inquiry means for sales products, and inventory confirmation. A processing unit having inventory allocation means for allocating the inventory products to sales; a main storage unit storing sales management data, inventory management data, allocation management data, etc. of all stores; It is composed of a head office server composed of an input unit having operation input means.
【０００５】さらに、店舗サーバを、ＬＡＮなどの構内
通信回線と通信接続制御を行う通信制御部と、受信した
受信データを種類別に分離する受信データ分離部と、Ｐ
ＯＳ端末よりの売上データに基づき売上管理処理を行う
売上管理部と、売上対象商品の店舗内の在庫照会を行う
店舗在庫照会部と、店舗在庫が確認された時に該当在庫
品を売上引当する在庫品引当部と、店舗内での在庫照会
の結果、在庫品が無い場合、本部在庫の照会を行う他店
在庫照会部と、本部在庫が確認された時に該当在庫品を
売上引当する他店在庫引当部と、これら本部在庫品の照
会および売上引当などの処理並び該当商品の在庫データ
更新などをリアルタイムで制御するリアル更新部と、本
部サーバに送信する各種データから所定の送信データを
作成する送信データ作成部と、日時データを生成するカ
レンダとを有する処理部と、売上管理データを記憶する
売上マスタと、店舗在庫データを記憶する在庫マスタ
と、売上引当する引当管理データを記憶している引当マ
スタと、オフラインで本部サーバより受信した受信デー
タを一時記憶する受信ファイルとを有する主記憶部と、
各種データの入力、オフライン処理操作およびメンテナ
ンス処理などの入力を行う入力部とで構成する。[0005] Further, a communication control unit for controlling communication connection between the store server and a private communication line such as a LAN, a received data separating unit for separating received data by type,
A sales management unit that performs sales management processing based on sales data from an OS terminal, a store inventory inquiry unit that performs inventory inquiry of in-store items for sale, and an inventory that allocates the corresponding inventory when store inventory is confirmed If there is no stock as a result of the inventory inquiry in the store and the inventory reservation in the store, another store inventory inquiry section that queries the headquarters inventory and the other store inventory that allocates the corresponding inventory when the headquarters inventory is confirmed An allocation unit, a real update unit that controls processing such as inquiry and sales allocation of the headquarters inventory and update of stock data of the corresponding product in real time, and transmission that creates predetermined transmission data from various data transmitted to the headquarters server. A processing unit having a data creation unit, a calendar for generating date and time data, a sales master for storing sales management data, an inventory master for storing store inventory data, and a reservation for sales allocation And provision master stores management data, a main storage unit and a reception file for temporarily storing the data received from the head office server offline,
It comprises an input section for inputting various data, offline processing operation, maintenance processing and the like.
【０００６】さらに、店舗サーバの処理部に、配送中の
商品を照会する配送照会部と、本部への配送中の商品を
照会する他店配送照会部と、配送中の商品を売上引当す
るため配送先を自店舗に変更する配送予約部と、本部へ
配送中の商品を売上引当するため配送先を変更する他店
配送予約部と、 同上の主記憶部に、配送品の種類、数
量、配送先などの配送データを記憶する配送マスタとを
追加設置する。[0006] Further, a delivery inquiry unit for inquiring the products being delivered to the processing unit of the store server, another store delivery inquiry unit for inquiring the products being delivered to the headquarters, and a unit for allocating sales of the products being delivered. A delivery reservation section that changes the delivery destination to its own store, a delivery reservation section that changes the delivery destination in order to allocate sales for products being delivered to the headquarters, and a main storage A delivery master that stores delivery data such as delivery destinations is additionally installed.
【０００７】さらに、店舗サーバの主記憶部に、発注商
品の発注データを記憶する発注マスタと、仕入れ中の商
品データを記憶する仕入マスタと、店舗間で移動中の商
品データを記憶している移動マスタとを追加設置する。Further, an order master for storing order data of ordered products, a purchase master for storing product data being purchased, and a product data being moved between stores are stored in a main storage unit of the store server. Additional mobile masters.
【０００８】さらに、本部サーバを、ＬＡＮなどの構内
通信回線と通信接続制御を行う通信制御部と、受信した
受信データを種類別に分離する受信データ分離部と、各
店舗よりの売上データに基づき全店舗の売上管理処理を
行う売上管理部と、店舗サーバよりの本部の在庫照会要
求に基づき本部在庫の照会を行う本部在庫照会部と、本
部在庫が確認された時には、該当在庫品を当該店舗に売
上引当する在庫品引当部と、これら本部在庫品の照会お
よび売上引当などの処理並び該当商品の在庫データ更新
などをリアルタイムで制御するリアル更新部と、各店舗
サーバに送信する各種データから所定の送信データを作
成する送信データ作成部と、日時データを生成するカレ
ンダとを有する処理部と、全店舗の売上管理データを記
憶する売上マスタと、本部在庫データを記憶する在庫マ
スタと、売上引当する本部引当管理データを記憶してい
る引当マスタと、オフラインで店舗サーバより受信した
受信データを一時記憶する受信ファイルと、全店舗の在
庫をデータを記憶している全店在庫マスタと、オフライ
ンで定時的に各店舗サーバに送信する商品データ、本部
在庫データなどの店舗サーバメンテナンスデータを記憶
しているマスターメンテナンス・ファイルとを有する主
記憶部と、各種データの入力、オフライン処理操作およ
びメンテナンス処理などの入力を行う入力部とで構成す
る。[0008] Further, the head office server is provided with a communication control unit for controlling communication connection with a private communication line such as a LAN, a reception data separation unit for separating received data by type, and a total control unit based on sales data from each store. A sales management section that performs store sales management processing, a headquarters inventory inquiry section that queries the headquarters inventory based on a headquarters inventory inquiry request from the store server, and when the headquarters inventory is confirmed, the corresponding stock is sent to the store. An inventory allocation section that allocates sales, a real update section that controls processing such as inquiry and sales allocation of headquarters inventory and update of inventory data of the corresponding product in real time, and a predetermined update from various data transmitted to each store server. A processing unit having a transmission data generation unit for generating transmission data, a calendar for generating date and time data, and a sales master storing sales management data for all stores , An inventory master that stores headquarters inventory data, an allocation master that stores headquarters allocation management data that allocates sales, a reception file that temporarily stores received data received from the store server offline, and a data file that stores inventory at all stores. And a main storage unit having a master maintenance file storing store server maintenance data such as merchandise data to be transmitted to each store server offline and on a regular basis, It comprises an input section for inputting various data, offline processing operation, maintenance processing and the like.
【０００９】さらに、本部サーバの処理部に、他店の在
庫照会を行う他店在庫照会部と、他店の在庫が確認され
た時に該当在庫品を売上引当する他店在庫品引当部とを
追加設置する。さらに、本部サーバの処理部に、本部へ
配送中の商品を照会する配送照会部と本部へ配送中の商
品を売上引当するため配送先を変更する配送予約部と、
本部サーバの主記憶部に、配送品の種類、数量などの配
送データを記憶する配送マスタとを追加設置する。Further, the processing section of the headquarters server includes a remote store inventory inquiry section for performing a remote store inventory inquiry, and a remote store inventory allocation section for allocating sales of the relevant inventory when the remote store inventory is confirmed. Additional installation. Further, the processing unit of the headquarters server includes a delivery inquiry unit that inquires about the products being delivered to the headquarters, a delivery reservation unit that changes the delivery destination in order to allocate sales of the products being delivered to the headquarters,
A delivery master for storing delivery data such as the type and quantity of delivery items is additionally installed in the main storage unit of the head office server.
【００１０】さらに、本部サーバの主記憶部に、本部で
の発注商品の発注データを記憶する発注マスタと、本部
で仕入れ中の商品データを記憶する仕入マスタと、店舗
間で移動中の商品データを記憶している移動マスタとを
追加設置する。[0010] Further, an order master for storing order data of commodities ordered at the headquarters, a purchase master for storing merchandise data being procured at the headquarters, and a product moving between stores in the main memory of the headquarters server. A mobile master that stores data is additionally installed.
【００１１】[0011]
【発明の実施の形態】図１は本発明による在庫管理シス
テムの一実施例のシステム図、図２は本発明による店舗
サーバの一実施例の要部ブロック図、図３は本発明によ
る本部サーバの一実施例の要部ブロック図である。図１
を用いて、本システムの総括的動作を説明する。店舗側
のシステムＳは、顧客毎の売上入力処理を行う複数のＰ
ＯＳ端末５と、売上商品データを送受信する通信手段と
受信した商品の店舗および本部の在庫を照会する在庫照
会手段と在庫確認された該在庫商品を売上に引当てる在
庫引当手段とを有する処理部２と、売上管理データ、在
庫管理データ、引当管理データなどを記憶している主記
憶部４と、各種データの入力や各種操作入力手段を有す
る入力部３とで構成する店舗サーバ１とを、ＬＡＮなど
の構内通信回線ＮＴ１で通信接続している。表示部Ｐは
店舗サーバの表示出力モニタとして用いられる。このＬ
ＡＮは、外部通信網との関門役のルータＲを経由して、
ＩＳＤＮのような公衆回線ＮＴ２に接続されている。こ
の公衆回線ＮＴ２には全店舗の店舗サーバ１’および本
部サーバ６がルータＲ’経由で接続され、全国規模の売
上管理ネットワークを形成している。FIG. 1 is a system diagram of an embodiment of an inventory management system according to the present invention, FIG. 2 is a block diagram of a main part of an embodiment of a store server according to the present invention, and FIG. 3 is a head office server according to the present invention. It is a principal part block diagram of one Example. FIG.
The overall operation of the present system will be described with reference to FIG. The store-side system S includes a plurality of Ps that perform sales input processing for each customer.
A processing unit having an OS terminal 5, communication means for transmitting / receiving sales product data, inventory reference means for checking the stock of the store and the headquarters of the received product, and inventory allocation means for allocating the checked inventory product to sales 2, a store server 1 including a main storage unit 4 storing sales management data, inventory management data, allocation management data, and the like, and an input unit 3 having various data input and various operation input means. Communication connection is made via a private communication line NT1 such as a LAN. The display unit P is used as a display output monitor of the store server. This L
The AN passes through the router R acting as a gateway to the external communication network,
It is connected to a public line NT2 such as ISDN. The store server 1 'and the headquarters server 6 of all stores are connected to the public line NT2 via the router R' to form a nationwide sales management network.
【００１２】本部システムＨは、本部サーバ６と物流管
理１０ａ、発注仕入管理１０ｂ、棚卸管理１０ｃ、在庫
管理１０ｄ、売上管理１０ｅなどの本部クライアンシス
テムとが、ＬＡＮやＷＡＮなどの構内通信回線ＮＴ３で
結ばれている。本部サーバ６は、店舗サーバからの売上
データ、在庫データなどを送受信す通信手段と全店舗の
売上管理手段と売上商品の在庫照会手段と在庫確認され
た該在庫商品を売上に引当てる在庫引当手段とを有する
処理部７と、全店舗の売上管理データ、在庫管理デー
タ、引当管理データなどんを記憶している主記憶部９
と、各種データの入力や各種操作入力手段を有する入力
部８とで構成される。The headquarters system H includes a headquarters server 6 and a headquarters client system such as a distribution management 10a, an order purchase management 10b, an inventory management 10c, an inventory management 10d, and a sales management 10e, and a local communication line NT3 such as a LAN or WAN. Are tied together. The headquarters server 6 includes communication means for transmitting and receiving sales data, inventory data, and the like from the store server, sales management means for all stores, inventory inquiry means for sold goods, and inventory allocation means for allocating the stock goods whose stock has been confirmed to sales. And a main storage unit 9 for storing sales management data, inventory management data, allocation management data, etc. of all stores.
And an input unit 8 having various data input and various operation input means.
【００１３】顧客への個別販売時には、ＰＯＳ端末５に
より売上処理が行われるが、販売現場に当該商品が在棚
されていない場合、店舗サーバは、ＰＯＳ端末５よりの
入力データに基づき、店舗倉庫内の在庫照会を行い、在
庫が確認されると該当の在庫品を売上引当する。在庫が
無い場合、公衆回線ＮＴ２を経由して本部サーバ６に通
信接続し、リアルタイムで本部在庫の照会を行うと共に
本部在庫品の売上引当処理を行う。同時に本部在庫管理
データを更新する。At the time of individual sales to the customer, sales processing is performed by the POS terminal 5. If the merchandise is not stored at the sales floor, the store server determines the store warehouse based on the input data from the POS terminal 5. Inquiry of the stock inside is done, and when the stock is confirmed, the corresponding stock is reserved for sales. If there is no stock, the communication is connected to the headquarters server 6 via the public line NT2, the headquarters inventory is checked in real time, and the sales allocation processing of the headquarters inventory is performed. At the same time, the headquarters inventory management data is updated.
【００１４】図２を用いて、店舗システムＨの詳細な動
作説明を行う。ＰＯＳ端末５よりの売上データは、ＬＡ
Ｎなどの構内通信回線ＮＴ１を経由して通信制御部３１
により受信される。受信データ分離部３３は受信データ
をデータの種類別に制御信号と分離し、所定の処理およ
び記憶部に分離入力する。売上管理部２１は、売上予定
商品の品目名、数量、金額などの売上データを管理入力
すると共に売上マスタ４０に追加記憶する。販売現場に
商品がない場合、店舗在庫照会部２２は、在庫マスタ４
１より該当商品在庫の有無とその数量を照会する。必要
数量が確保されると、在庫引当部２４は該在庫品を売上
引当し、引当マスタ４２に登録すると共に在庫マスタ４
１から在庫量を減数するなどの引当処理を行う。在庫が
ない場合、配送照会部２６は該当店舗に配送中の該当商
品有無を、配送マスタ４３内のデータにより照会し、配
送中の商品があると、配送予約部２８は該当品の配送予
約処理を行う。The detailed operation of the store system H will be described with reference to FIG. Sales data from the POS terminal 5 is LA
N via the local communication line NT1 such as the communication control unit 31
Is received by The reception data separation unit 33 separates the reception data from the control signal for each type of data, and separates and inputs the control data into a predetermined processing and storage unit. The sales management unit 21 manages and inputs sales data such as the item name, quantity, and amount of the planned sales product, and additionally stores the sales data in the sales master 40. If there is no merchandise at the sales floor, the store inventory inquiry unit 22 sends the inventory master 4
Inquire the presence or absence of the corresponding product stock and its quantity from 1. When the required quantity is secured, the inventory allocation unit 24 allocates the inventory to the sales, registers it in the allocation master 42, and registers the inventory in the inventory master 4
The allocation processing such as reducing the stock amount from 1 is performed. If there is no stock, the delivery inquiry unit 26 refers to the data in the delivery master 43 for the presence or absence of the corresponding product being delivered to the corresponding store, and if there is a product being delivered, the delivery reservation unit 28 performs the delivery reservation processing of the corresponding product. I do.
【００１５】店舗内の在庫が無かったり数量が不足して
いる場合、他店在庫照会部２３は、本部在庫を照会する
ため、本部在庫照会要求を出力する。送信データ作成部
３２は送信に必要な送信データを作成し、通信制御部３
１を経由して本部サーバ６にを送出する。本部サーバ６
より在庫有りの確認結果を受信すると、他店在庫引当部
２５はリアル更新部３０に本部在庫の売上引当要求を出
す。リアル更新部３０は本部サーバ６に対して在庫品の
引当処理を依頼すると共に引当マスタ４２に登録する。
さらに本部在庫がない場合、本部配送照会部２７は本部
に配送中の該当商品有無を、本部サーバに照会し、有っ
た時には、他店配送予約部２９は該当品の予約処理を行
う。If there is no stock in the store or the quantity is insufficient, the other store stock inquiry unit 23 outputs a headquarter stock inquiry request to inquire about the headquarter stock. The transmission data creation unit 32 creates transmission data necessary for transmission, and
1 to the headquarters server 6. Headquarters server 6
Upon receiving the confirmation result of the stock availability, the other store inventory allocation unit 25 issues a sales allocation request for the headquarter inventory to the real update unit 30. The real update unit 30 requests the headquarters server 6 to perform a stock allocation process and registers the stock item in the allocation master 42.
Further, when there is no headquarters stock, the headquarters delivery inquiry unit 27 inquires of the headquarters server whether there is a corresponding product being delivered to the headquarters, and if there is, the other store delivery reservation unit 29 performs a reservation process of the corresponding product.
【００１６】それでも、売上引当品が得られない場合、
入力部３より発注処理を入力する、このデータは発注マ
スタと４７と仕入マスタ４６に登録部される。売上管
理、引当管理、発注管理、配送管理、倉庫間移動管理、
在庫管理など実務的処理は、詳細が図示されていない店
舗クライアント５１で行われるが、本発明の趣旨とは直
接関係しないので説明を省略する。[0016] If the sales allowance product is still not obtained,
The order processing is input from the input unit 3. This data is registered in the order master 47 and the purchase master 46. Sales management, allocation management, order management, delivery management, warehouse transfer management,
Practical processing such as inventory management is performed by the store client 51 whose details are not shown, but the description is omitted because it is not directly related to the gist of the present invention.
【００１７】売上管理データ、在庫管理データ、仕入管
理データなどは、夜間などにオフラインで本部サーバに
送信するため、必要なデータを送信ファイル４８に一時
記憶しておき、カレンダ３４からの定時情報に基づき、
該送信ファイルのデータは本部サーバに送出される。一
方本部サーバ６からは、商品管理データ、本部在庫管理
データなどが送られ受信ファイル４９に一時記憶され
る。Since the sales management data, inventory management data, purchase management data, and the like are transmitted to the headquarters server off-line at night or the like, necessary data is temporarily stored in a transmission file 48, and the periodic information from the calendar 34 is stored. Based on
The data of the transmission file is sent to the head office server. On the other hand, merchandise management data, headquarters inventory management data, and the like are sent from the headquarters server 6, and are temporarily stored in the reception file 49.
【００１８】表示制御部３５は動作状況や手動入力中の
データより画像信号を生成し表示部Ｐに出力する。さら
に印刷制御部３６はプリントデータを生成してプリンタ
Ｐｒの印刷制御を行う。The display control unit 35 generates an image signal from the operation status and data being manually input, and outputs it to the display unit P. Further, the print control unit 36 generates print data and controls printing of the printer Pr.
【００１９】図３を用いて本部サーバ６の詳細な動作説
明を行う。全店舗の店舗サーバからの売上管理データお
よび本部在庫照会要求は、本部内のＬＡＮやＷＡＮなど
の構内通信回線ＮＴ３を経由して、通信制御８１が受信
する。受信データ分離部８３は、受信データをデータ種
類別に制御信号と分離し所定の処理および記憶部に分離
入力する。売上管理部７１は、全店舗の売上商品の品目
名、数量、金額などの売上データを管理入力すると共に
売上マスタ９０に追加記憶する。店舗サーバより本部在
庫の照会要求があった場合、本部在庫照会部７２は在庫
マスタ９１より該当商品在庫の有無とその数量を照会
し、その結果を店舗サーバ１に送出する。リアル更新部
８０は、該店舗サーバ１より該当在庫品の売上引当要求
を受信すると、在庫引当部７４および他店在庫引当部７
５に対して引当実行指令を出す。在庫引当部７４は該在
庫品を売上引当し、引当マスタ９２に登録すると共に在
庫マスタ９１から在庫量を減数し、且つ移動マスタ９１
にも登録するなどの引当処理を行う。在庫がない場合、
配送照会部７６は本部に配送中の該当商品有無を、配送
マスタ９３内のデータにより照会し、配送途中の商品が
有ると、店舗サーバ１よりの売上引当要求を受けて配送
予約部７８は該当品の予約処理を行う。The operation of the head office server 6 will be described in detail with reference to FIG. The communication control 81 receives the sales management data and the headquarters inventory inquiry request from the store servers of all the stores via the local communication line NT3 such as LAN or WAN in the headquarters. The reception data separation unit 83 separates the reception data from the control signal for each data type, and separates and inputs the control data into a predetermined processing and storage unit. The sales management unit 71 manages and inputs sales data such as the item name, quantity, and amount of sales products of all stores, and additionally stores the sales data in the sales master 90. When there is a request for inquiry of the headquarters stock from the store server, the headquarters stock inquiry unit 72 inquires of the stock master 91 about the presence or absence of the corresponding product stock and the quantity thereof, and sends the result to the store server 1. Upon receiving the sales allocation request for the corresponding stock from the store server 1, the real updating unit 80 determines whether the stock allocation unit 74 and the other store inventory allocation unit 7
Then, an allocation execution instruction is issued to 5. The inventory allocation section 74 allocates the inventory to the sales, registers it in the allocation master 92, reduces the inventory amount from the inventory master 91, and
It performs allocation processing such as registration. If there is no stock,
The delivery inquiry unit 76 inquires of the headquarters about the presence or absence of the corresponding product being delivered based on the data in the delivery master 93. If there is a product being delivered, the delivery reservation unit 78 receives the sales allocation request from the store server 1 and responds. Perform product reservation processing.
【００２０】本部に在庫が無かったり数量が不足してい
る場合、他店在庫照会部７３は、全店在庫マスタ１００
より該当商品在庫の有無とその数量を照会し、その結果
を店舗サーバ１に送出する。該店舗サーバ１より該当在
庫品の売上引当要求を受信すると、他店在庫引当部７５
は該在庫品を売上引当し、引当マスタ９２に登録し、全
店在庫マスタ１００から在庫量を減数すると共に在庫品
を持っている店舗の店舗サーバに対して該当在庫品の転
送指令を出し、店間移動マスタ１０３にも登録する。さ
らに、他店配送予約部７９は該当他店の店舗サーバに対
して、引当要求先店舗への配送予約指令を発する。If there is no stock at the headquarters or the quantity is insufficient, the other store stock inquiry unit 73 sends the all store stock master 100
The presence / absence of the corresponding merchandise inventory and its quantity are inquired, and the result is sent to the store server 1. When receiving the sales allocation request for the corresponding stock from the store server 1, the other store inventory allocation unit 75
Allocates the inventory to sales, registers it in the allocation master 92, reduces the inventory amount from the all-store inventory master 100, and issues a transfer command of the inventory to the store server of the store that has the inventory, It is also registered in the inter-movement master 103. Further, the other store delivery reservation section 79 issues a delivery reservation command to the store server of the corresponding other store to the reservation request destination store.
【００２１】最終的に売上引当品が無い場合の緊急発注
は、入力部８より手動操作により発注処理を入力する。
このデータは発注マスタ９７と仕入マスタ９６に登録部
される。売上管理、引当管理、発注管理、配送管理、倉
庫間移動管理、在庫管理など実務的処理は、詳細が図示
されていない本部クライアント１０で行われるが、本発
明の趣旨とは直接関係しないので説明を省略する。In the event of an emergency order when there is no sales allocation product, an order processing is manually input from the input unit 8.
This data is registered in the order master 97 and the purchase master 96. Practical processes such as sales management, allocation management, order management, delivery management, inter-warehouse transfer management, and inventory management are performed by the headquarters client 10 (not shown in detail), but are not directly related to the gist of the present invention. Is omitted.
【００２２】全店舗の管理データによる、本部サーバの
管理データ更新は、夜間や日常業務の閑散時間に定時的
に行われ、各店舗サーバ内の送信ファイル４８に予め更
新された所定の管理データを通信制御部８１で受信し、
受信データ分離部８３が所定の全店マスタにデータ入力
させる。更新対象は全店売上マスタ１０４、全店在庫マ
スタ１００、全店発注マスタ１０２、店間移動マスタ１
０３などである。各店舗サーバの管理データの一斉更新
は、該当する管理データをマスタメンテナンスファイル
１０１に予め記憶させ、定時的に、送信データ作成部８
２、通信制御部８１などを経由して、各店舗サーバに送
出される。The management data of the headquarters server is updated on a regular basis during the night or during off-hours of daily work, and the previously updated predetermined management data is stored in the transmission file 48 in each store server. Received by the communication control unit 81,
The received data separating unit 83 causes a predetermined all store master to input data. The update targets are all-store sales master 104, all-store inventory master 100, all-store order master 102, and inter-store transfer master 1.
03 and the like. The simultaneous update of the management data of each store server stores the corresponding management data in the master maintenance file 101 in advance, and periodically transmits the
2. It is transmitted to each store server via the communication control unit 81 and the like.
【００２３】表示制御部８５は動作状況や手動入力中の
データより画像信号を生成し表示部Ｐに出力する。さら
に印刷制御部８６はプリントデータを生成してプリンタ
Ｐｒの印刷制御を行う。The display control unit 85 generates an image signal from the operation status and data being manually input, and outputs the image signal to the display unit P. Further, the print control unit 86 generates print data and controls printing of the printer Pr.
【００２４】図４は本発明による在庫管理システムの実
施例における処理フロー図である。本図を用いて売上・
在庫管理のフローを説明する。店舗に設置されたＰＯＳ
端末５より、商品コード、商品名、数量等の売上データ
が売上管理部２１に入力ＳＴ１されると、店舗在庫照会
部２２は在庫マスタ４１の在庫データを照合ＳＴ２し
て、必要数が確保出来るかの確認を行う。必要数が確保
できると、在庫引当部２４は、在庫マスタ４１内の該当
商品の在庫数を減数し、出庫処理、配送予約などの在庫
引当処理ＳＴ３を行う。さらに売上管理部２１は、売上
マスタ４０への追加記憶などの売上計上処理ＳＴ４を行
い、通常のルーチンは終了する。FIG. 4 is a processing flowchart in the embodiment of the inventory management system according to the present invention. Using this figure,
The flow of inventory management will be described. POS installed in stores
When sales data such as a product code, a product name, and a quantity is input ST1 from the terminal 5 to the sales management unit 21, the store stock inquiry unit 22 checks the stock data of the stock master 41 in ST2 to secure the required number. Confirm whether or not. When the required number can be secured, the inventory allocation unit 24 reduces the inventory number of the corresponding product in the inventory master 41, and performs an inventory allocation process ST3 such as a delivery process or a delivery reservation. Further, the sales management section 21 performs sales accounting processing ST4 such as additional storage to the sales master 40, and the normal routine ends.
【００２５】しかしながら、しばしば店棚や店舗倉庫に
在庫が無かったり、不足する場合がある。従来の販売シ
ステムにあっては、販売員が本店や他店舗に電話やファ
クシミリなどで問い合わせて、顧客に入荷時期等を提示
するか、もしくは、後日入荷日を回答するなどしてい
る。本システムでは、他店在庫照会部２３が公衆回線Ｎ
Ｔ２経由で本部サーバ６に本部在庫の照会要求を送る。
本部サーバ６内の本部在庫照会部７２は、在庫マスタ９
１の在庫データを照合ＳＴ５して、必要数が確保出来る
かを店舗サーバ１に回答する。必要数が確保できると、
他店在庫引当部２３は、リアル更新部３０に本部在庫の
転用許可を得て、本部サーバ６に本部在庫の引当要求を
出す。本部サーバ内の在庫引当部７４は、在庫マスタ９
１内の該当商品の在庫数を減数し、出庫処理、配送予約
などの在庫引当処理ＳＴ６を行う。さらに本部倉庫から
当該店舗への移動処理ＳＴ７などを行い、その結果を店
舗サーバ１に通知する。売上管理部２１はこの通知に基
づき売上計上処理をＳＴ４を行う。[0025] However, there is often a case where inventory is lacking or lacking in store shelves or store warehouses. In a conventional sales system, a sales person makes an inquiry to the main store or another store by telephone, facsimile, or the like, and presents the arrival time or the like to the customer, or answers the arrival date at a later date. In this system, the other store inventory inquiry unit 23 uses the public line N
A request for headquarters inventory is sent to the headquarters server 6 via T2.
The headquarters inventory inquiry unit 72 in the headquarters server 6 stores the inventory master 9
The stock data of No. 1 is collated ST5, and a reply is made to the store server 1 as to whether the required number can be secured. Once you have the required number,
The other store inventory allocation unit 23 obtains the diversion of the headquarters inventory from the real update unit 30 and issues a headquarters inventory allocation request to the headquarters server 6. The stock allocation unit 74 in the head office server stores the stock master 9
The number of stocks of the corresponding product in 1 is reduced, and a stock allocation process ST6 such as a delivery process or a delivery reservation is performed. Further, the process of moving from the headquarters warehouse to the store ST7 is performed, and the result is notified to the store server 1. The sales management unit 21 performs sales accounting processing ST4 based on the notification.
【００２６】店舗在庫および本部在庫が無いか、もしく
は、不足している場合、二通りのルーチンがある。第一
は、本部サーバ内の他店在庫照会部７３が、全店在庫マ
スタ１００の他店舗の在庫データを照合ＳＴ８して、店
舗サーバ１に回答し、必要数が確保できると、他店在庫
引当部２３は、リアル更新部３０に本部在庫の転用要求
を出し、転用許可が出ると、本部サーバ６に本部在庫の
引当要求を出す。本部サーバ内の他店在庫引当部７５
は、リアル更新部８０に他店在庫の転用許可得て、他店
のサーバ１’に在庫引当処理ＳＴ９を依頼すると共に店
舗間で商品の移動処理ＳＴ１０などを行い、その結果を
店舗サーバ１に返信する。If the store inventory and the headquarters inventory are not or are short, there are two routines. First, the other store inventory inquiry unit 73 in the headquarters server checks the stock data of the other store in the all store inventory master 100 in ST8, answers the store server 1, and when the required number can be secured, the other store inventory allocation. The unit 23 issues a diversion request of the headquarters inventory to the real updating unit 30, and when the diversion permission is issued, issues a request for allocation of the headquarters inventory to the headquarters server 6. Other store inventory allocation section 75 in the head office server
Obtains permission for diversion of the inventory of another store from the real update unit 80, requests the server 1 'of the other store for the inventory allocation process ST9, performs the process of moving goods between stores ST10, and the like, and sends the result to the store server 1 Send back.
【００２７】第二は、手動操作により入力部３より、発
注照会ＳＴ１１をし、未発注の場合には、該当商品を納
期指定と共に発注マスタ４７に追加登録するなどの発注
処理ＳＴ１２を行い、顧客に引渡し期日を提示する。Second, an order inquiry ST11 is manually performed from the input unit 3 through the input unit 3, and if no order is placed, an order process ST12 such as additionally registering the product in the order master 47 together with designation of the delivery date is performed. Provide the delivery date to.
【００２８】[0028]
【発明の効果】本発明は、以上に説明した内容で実施さ
れ、以下に述べる効果を奏する。各店舗サーバは、ＰＯ
Ｓ端末より入力された売上対象商品の店舗内在庫照会を
行い、当該在庫が無い場合、本部在庫の照会をリアルタ
イムで行うと共に、本部に在庫品がある時には、該在庫
品をリアルタイムで売上引当を可能とした。さらに、配
送中の商品の照会と、売上商品の引当に際して配送途中
の商品をも対象とすることが出来る。さらに、本部在庫
品の照会結果、在庫品が無い場合、他店舗の在庫照会お
よび売上引当の管理制御を行うことが出来る。以上の如
く本発明は、店舗サーバ側からリアルタイムで本部サー
バの在庫管理データを照会し、販売活用できる在庫管理
システムを構築した。The present invention is embodied as described above, and has the following effects. Each store server is a PO
The in-store inventory of the sales target product input from the S terminal is inquired. If the inventory is not available, the headquarters inventory is inquired in real time. If the headquarters has inventory, the inventory is allocated in real time. Made it possible. In addition, it is possible to refer to the merchandise being delivered and to refer to the merchandise being delivered and to allocate the sales merchandise. Furthermore, if there is no stock as a result of the inquiry of stocks at the headquarters, it is possible to perform inventory control of other stores and management control of sales allocation. As described above, according to the present invention, the inventory management data of the head office server is queried in real time from the store server side, and the inventory management system that can be utilized for sales is constructed.
【図１】本発明による在庫管理システムの一実施例のシ
ステム図である。FIG. 1 is a system diagram of an embodiment of an inventory management system according to the present invention.
【図２】本発明による店舗サーバの一実施例の要部ブロ
ック図である。FIG. 2 is a main part block diagram of an embodiment of a store server according to the present invention.
【図３】本発明による本部サーバの一実施例の要部ブロ
ック図である。FIG. 3 is a main part block diagram of an embodiment of a headquarters server according to the present invention.
【図４】本発明による在庫管理システムの実施例におけ
る処理フロー図である。FIG. 4 is a processing flowchart in the embodiment of the inventory management system according to the present invention.
Ｈ 本部システム Ｓ 店舗システム ＮＴ１、ＮＴ２ 構内通信回線 ＮＴ２ 公衆回線 Ｒ ルータ １ 店舗サーバ ２、７ 処理部 ３、８ 入力部 ４、９ 主記憶部 ５ ＰＯＳ端末 ６ 本部サーバ １０ 本部クライアント ２１、７１ 売上管理部 ２２ 店舗在庫管理部 ２３、７３ 他店在庫管理部 ２４、７４ 在庫引当部 ２５、７５ 他店在庫引当部 ２６、７６ 配送照会部 ２７ 本部配送照会部 ２８、７８ 配送予約部 ２９、７９ 他店配送予約部 ３０、８０ リアル更新部 ３１、８１ 通信制御部 ３２、８２ 送信データ作成部 ３３、８３ 受信データ分離部 ３４、８４ カレンダ ４１、９１ 在庫マスタ ４２、９２ 引当マスタ ４３、９３ 配送マスタ ４５、９５ 移動マスタ ４６、９６ 仕入マスタ ４７、９７ 発注マスタ ４８、９８ 送信ファイル ４９、９９ 受信ファイル ５１ 店舗クライアント １００ 全店在庫マスタ １０１ マスタメンテナンスファイル １０２ 全店発注マスタ １０３ 店間移動マスタ １０４ 全店売上マスタ H Headquarters system S Store system NT1, NT2 Private communication line NT2 Public line R Router 1 Store server 2, 7 Processing unit 3, 8 Input unit 4, 9 Main storage unit 5 POS terminal 6 Head office server 10 Head office client 21, 71 Sales management Unit 22 Store inventory management unit 23, 73 Other store inventory management unit 24, 74 Inventory allocation unit 25, 75 Other store inventory allocation unit 26, 76 Delivery inquiry unit 27 Main unit delivery inquiry unit 28, 78 Delivery reservation unit 29, 79 Other stores Delivery reservation unit 30, 80 Real update unit 31, 81 Communication control unit 32, 82 Transmission data creation unit 33, 83 Received data separation unit 34, 84 Calendar 41, 91 Inventory master 42, 92 Allocation master 43, 93 Delivery master 45, 95 Transfer master 46, 96 Purchasing master 47, 97 Order master 48, 98 Transmission file 49, 99 Received file 51 Store client 100 Whole store inventory master 101 Master maintenance file 102 Whole store ordering master 103 Transfer between stores master 104 Whole store sales master
Claims (12)
rea Netowork) などの構内通信回線で結び、売上管理、
在庫管理、配送管理などの制御機能を有する店舗サーバ
と、複数の前記店舗サーバを公衆回線で結び、全店舗レ
ベルの売上管理、在庫管理、配送管理などの制御機能を
有する本部サーバとで構成する売上・在庫管理システム
において、 顧客毎の売上入力処理を行う複数のＰＯＳ端末と、 前記ＰＯＳ端末より構内通信回線を経由して売上商品デ
ータを送受信する通信手段と前記受信した商品の店舗お
よび本部の在庫を照会する在庫照会手段と在庫確認され
た該在庫商品を売上に引当てる在庫引当手段とを有する
処理部と、売上管理データ、在庫管理データ、引当管理
データなどを記憶している主記憶部と、各種データの入
力や操作入力手段を有する入力部とで構成する店舗サー
バと、 前記構内通信回線とＩＳＤＮ(Integrated Service Digi
tal Netowerk) などの公衆回線とを通信接続する通信ゲ
ート機能を有するルータと、 前記店舗サーバからの売上データ、在庫データなどを送
受信す通信手段と全店舗の売上管理手段と売上商品の在
庫照会手段と在庫確認された該在庫商品を売上に引当て
る在庫引当手段とを有する処理部と、全店舗の売上管理
データ、在庫管理データ、引当管理データなどを記憶し
ている主記憶部と、各種データの入力や操作入力手段を
有する入力部とで構成する本部サーバとで構成され、 各店舗サーバは、ＰＯＳ端末より入力された売上対象商
品の店舗内での在庫照会を行い、当該在庫が無い場合、
本部在庫の照会をリアルタイムで行うと共に、本部に在
庫品がある時には、該在庫品をリアルタイムで売上引当
を行うことを特徴とするリアルタイム在庫管理システ
ム。1. A plurality of POS terminals in a store are connected to a LAN (Local A
rea Network), sales management,
A store server having control functions such as inventory management and delivery management, and a head office server having control functions such as sales management, inventory management, and delivery management at all store levels by connecting the plurality of store servers with a public line. In the sales / inventory management system, a plurality of POS terminals for performing a sales input process for each customer, communication means for transmitting and receiving sales product data from the POS terminal via a local communication line, and a store and a headquarters for the received products A processing unit having inventory inquiry means for inquiring inventory and inventory allocating means for allocating the stock items whose inventory has been confirmed to sales, and a main storage unit for storing sales management data, inventory management data, allocation management data, etc. And a store server comprising an input unit having various data input and operation input means; and a private communication line and ISDN (Integrated Service Digit).
tal Netowerk) and a router having a communication gate function for communication connection with a public line, communication means for transmitting and receiving sales data and inventory data from the store server, sales management means for all stores, and inventory inquiry means for sales products. And a main storage unit for storing sales management data, inventory management data, allocation management data, and the like of all stores, and various data. And a head office server comprising an input unit having input means and operation input means. Each store server performs a stock inquiry in the store of the sales target product inputted from the POS terminal, and when there is no such stock. ,
A real-time inventory management system for real-time inquiry of headquarters inventory and, when there is an inventory at the headquarters, real-time sales allocation of the inventory.
制御部と、受信した受信データを種類別に分離する受信
データ分離部と、前記ＰＯＳ端末よりの売上データに基
づき売上管理処理を行う売上管理部と、売上対象商品の
店舗内の在庫照会を行う店舗在庫照会部と、店舗在庫が
確認された時に該当在庫品を売上引当する在庫品引当部
と、前記店舗在庫照会の結果、在庫品が無い場合、本部
在庫の照会を行う他店在庫照会部と、本部在庫が確認さ
れた時に該当在庫品を売上引当する他店在庫品引当部
と、これら本部在庫品の照会および売上引当などの処理
並び該当商品の在庫データ更新などをリアルタイムで制
御するリアル更新部と、前記本部サーバに送信する各種
データから所定の送信データを作成する送信データ作成
部と、日時データを生成するカレンダとを有する処理部
と、 前記売上管理データを記憶する売上マスタと、前記店舗
在庫データを記憶する在庫マスタと、前記売上引当する
引当管理データを記憶している引当マスタと、オフライ
ンで本部サーバより受信した受信データを一時記憶する
受信ファイルとを有する主記憶部と、 各種データの入力、オフライン処理操作、メンテナンス
処理などの入力を行う入力部とで構成することを特徴と
する請求項１に記載のリアルタイム在庫管理システム。2. A communication control unit for controlling the communication connection between the store server and a local communication line such as the LAN, a received data separating unit for separating received data by type, and a sales data from the POS terminal. A sales management unit that performs a sales management process based on the sales information, a store inventory inquiry unit that performs an inventory inquiry of the product to be sold in the store, an inventory allocation unit that allocates the corresponding inventory when the store inventory is confirmed, and the store If there is no inventory as a result of the inventory inquiry, another store inventory inquiry section that queries the headquarters inventory, another store inventory allocation section that allocates the corresponding inventory when the headquarter inventory is confirmed, and these headquarters inventory And a real update unit that controls in real time the processing such as inquiry and sales allocation and inventory data update of the corresponding product, and a transmission unit that creates predetermined transmission data from various data transmitted to the headquarters server. A processing unit having a credit data creation unit, a calendar for generating date and time data, a sales master storing the sales management data, an inventory master storing the store inventory data, and storing allocation management data for allocating the sales. A main storage unit having an allocation master that performs the allocation, a reception file for temporarily storing received data received from the headquarters server offline, and an input unit for inputting various data, offline processing operation, maintenance processing, and the like. The real-time inventory management system according to claim 1, wherein the system is configured.
の商品を照会する他店配送照会部と、前記配送中の商品
を売上引当するため配送先を変更する配送予約部と、前
記本部へ配送中の商品を売上引当するため配送先を自店
舗に変更する他店配送予約部と、 前記店舗サーバの主記憶部に、配送品の種類、数量、配
送先などの配送データを記憶する配送マスタとを追加設
置し、売上商品の引当に際して、配送途中の商品をも対
象とすることを特徴とする請求項２に記載のリアルタイ
ム在庫管理システム。3. A processing reference of the store server, a delivery reference unit for referring to a product being delivered, a delivery reference unit for another store referencing a product being delivered to the head office, and a sales allocation for the product being delivered. A delivery reservation unit for changing the delivery destination to perform the delivery, a delivery reservation unit for another store for changing the delivery destination to the own store in order to reserve sales of the goods being delivered to the headquarters, and a delivery item in the main storage unit of the store server. 3. A real-time inventory according to claim 2, further comprising a delivery master for storing delivery data such as the type, quantity, and delivery destination of the product, and also targeting products in the middle of delivery when allocating sales products. Management system.
れ中の商品データを記憶する仕入マスタと、店舗間で移
動中の商品データを記憶している移動マスタとを追加設
置し、売上予定商品の在庫が無い場合、前記入力部を用
いて該当商品の発注を行うと共に発注商品、仕入中もし
くは移動中の商品であっても売上引当予約することを特
徴とする請求項２に記載のリアルタイム在庫管理システ
ム。4. An order master for storing order data of unstocked products, a purchase master for storing product data being purchased, and a product data being moved between stores in a main storage unit of the store server. If there is no inventory of the product to be sold and the inventory of the product to be sold is not available, use the input unit to place an order for the product, and reserve the sales even if the product is ordered, purchased or moving. 3. The real-time inventory management system according to claim 2, wherein a reservation is made.
御部と、受信した受信データを種類別に分離する受信デ
ータ分離部と、前記各店舗よりの売上データに基づき全
店舗の売上管理処理を行う売上管理部と、店舗サーバよ
りの本部在庫照会要求に基づき本部在庫の照会を行う本
部在庫照会部と、本部在庫が確認された時には、該当在
庫品を当該店舗に売上引当する在庫品引当部と、これら
本部在庫品の照会および売上引当などの処理並び該当商
品の在庫データ更新などをリアルタイムで制御するリア
ル更新部と、前記各店舗サーバに送信する各種データか
ら所定の送信データを作成する送信データ作成部と、日
時データを生成するカレンダとを有する処理部と、 前記全店舗の売上管理データを記憶する売上マスタと、
前記本部在庫データを記憶する在庫マスタと、前記売上
引当する本部引当管理データを記憶している引当マスタ
と、オフラインで店舗サーバより受信した受信データを
一時記憶する受信ファイルと、全店舗の在庫をデータを
記憶している全店在庫マスタと、オフラインで定時的に
各店舗サーバに送信する商品データ、本部在庫データな
どの店舗サーバメンテナンスデータを記憶しているマス
ターメンテナンスファイルとを有する主記憶部と、 各種データの入力、オフライン処理操作およびメンテナ
ンス処理などの入力を行う入力部とで構成することを特
徴とする請求項１に記載のリアルタイム在庫管理システ
ム。5. The headquarters server includes: a communication control unit for controlling communication connection with a private communication line such as a LAN; a reception data separation unit for separating received data by type; and a sales data from each store. A sales management unit that performs sales management processing for all stores based on the headquarters inventory, and a headquarters inventory inquiry unit that queries headquarters inventory based on a headquarters inventory inquiry request from the store server. The inventory allocation section that allocates sales to the headquarters, a real update section that controls processing such as inquiry and sales allocation of the headquarters inventory and updates the inventory data of the corresponding product in real time, and various data transmitted to the store servers. A processing unit having a transmission data generating unit for generating predetermined transmission data, a calendar for generating date and time data, and a sales unit for storing sales management data of all the stores. And the master,
An inventory master that stores the headquarters inventory data, an allocation master that stores the headquarters allocation management data for the sales allocation, a reception file that temporarily stores received data received from the store server offline, and an inventory of all stores. A main storage unit having an all-store inventory master storing data, and a master maintenance file storing store server maintenance data such as merchandise data to be sent to each store server offline on a regular basis, 2. The real-time inventory management system according to claim 1, further comprising an input unit for inputting various data, offline processing operation, and maintenance processing.
確認された時に該当在庫品を売上引当する他店在庫品引
当部とを追加設置し、前記本部在庫品の照会の結果、在
庫品が無い場合、他店舗の在庫照会および売上引当の管
理制御を行うことを特徴とする請求項５に記載のリアル
タイム在庫管理システム。6. A processing section of the headquarters server, wherein: a remote store inventory inquiry section for inquiring the inventory of another store; and a remote store inventory allocation section for allocating the corresponding inventory when the inventory of the other store is confirmed. 6. The real-time inventory management system according to claim 5, wherein, if the inventory of the headquarters is not found as a result of the inquiry of the headquarters inventory items, inventory control of another store and management control of sales allocation are performed.
の商品を照会する配送照会部と、前記本部へ配送中の商
品を売上引当するため配送先を変更する配送予約部と、 同上の主記憶部に、配送品の種類、数量などの配送デー
タを記憶する配送マスタとを追加設置し、売上商品の引
当に際して、本部への配送途中の商品をも対象とするこ
とを特徴とする請求項５に記載のリアルタイム在庫管理
システム。7. A delivery inquiring unit for inquiring of a product being delivered to the headquarters to a processing unit of the headquarters server, a delivery reservation unit for changing a delivery destination in order to reserve sales of the products being delivered to the headquarters. In addition, a delivery master for storing delivery data such as the type and quantity of delivery items is additionally installed in the main storage section, and when allocating sales products, the products being delivered to the headquarters are also targeted. The real-time inventory management system according to claim 5.
部で仕入れ中の商品データを記憶する仕入マスタと、店
舗間で移動中の商品データを記憶している移動マスタと
を追加設置し、売上予定商品の在庫が無い場合、前記入
力部を用いて該当商品の発注を行うと共に発注商品、仕
入中もしくは移動中の商品であっても売上引当予約する
ことを特徴とする請求項５に記載のリアルタイム在庫管
理システム。8. An order master for storing order data of products ordered by the headquarters, a purchase master for storing product data being purchased at the headquarters, and a product data being moved between stores in the main storage of the headquarters server. Is added, and if there is no stock of the product to be sold, the relevant product is ordered using the input unit and the ordered product, even if the product is being purchased or is being moved. The real-time inventory management system according to claim 5, wherein a sales reservation is reserved.
品照会は、まず自店舗在庫を照会し次いで本部在庫を照
会する処理とすることを特徴とする請求項１、２、もし
くは５に記載のリアルタイム在庫管理システム。9. The real-time inventory according to claim 1, wherein the inventory inquiry of the store server and the headquarters server is a process of first inquiring own store inventory and then inquiring headquarters inventory. Inventory management system.
舗在庫を照会し次いで他店舗の在庫を照会する処理とす
ることを特徴とする請求項１、５、もしくは６に記載の
リアルタイム在庫管理システム。10. The real-time inventory management according to claim 1, 5 or 6, wherein the inventory inquiry of the head office server is performed by first inquiring the inventory of the head office and then inquiring the inventory of another store. system.
商品の売上引当は、まず自店舗在庫品を引当し、次いで
本部在庫品を引当処理とすることを特徴とする請求項
１、２、もしくは５に記載のリアルタイム在庫管理シス
テム。11. The sales allocation of inventory goods of the store server and the headquarters server is performed by first allocating the stock of the own store and then allocating the stock of the headquarters. Real-time inventory management system described in.
は、まず本部在庫品を引当し、次いで他店舗の在庫品を
引当処理とすることを特徴とする請求項１、５、もしく
は６に記載のリアルタイム在庫管理システム。12. The method of claim 1, 5 or 6, wherein the sales of the inventory of the head office server is performed by first allocating the inventory of the head office and then allocating the inventory of another store. Real-time inventory management system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP31937897A JP3777759B2 (en) | 1997-11-20 | 1997-11-20 | Real-time inventory management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP31937897A JP3777759B2 (en) | 1997-11-20 | 1997-11-20 | Real-time inventory management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| JPH11154280A true JPH11154280A (en) | 1999-06-08 |
| JP3777759B2 JP3777759B2 (en) | 2006-05-24 |
Family
ID=18109494
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP31937897A Expired - Fee Related JP3777759B2 (en) | 1997-11-20 | 1997-11-20 | Real-time inventory management system |
Country Status (1)
| Country | Link |
|---|---|
| JP (1) | JP3777759B2 (en) |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20010006788A (en) * | 1999-06-22 | 2001-01-26 | 김점두 | Process for preventing environmental contamination connected with direct transactions of agricultural, livestock, fishery, and forestry produce |
| WO2001059641A1 (en) * | 2000-02-09 | 2001-08-16 | Sony Computer Entertainment Inc. | Sale managing method, sale managing system, and commodity selling system |
| JP2001357271A (en) * | 2000-06-14 | 2001-12-26 | Mitsubishi Electric Information Systems Corp | Device and method for, stock control and computer- readable recording medium recorded with program |
| JP2002128246A (en) * | 2000-10-24 | 2002-05-09 | Nec Corp | Product repair and management system |
| JP2002145420A (en) * | 2000-11-14 | 2002-05-22 | Sagawa Express Co Ltd | Inventory management system and inventory management system using network |
| JP2002236771A (en) * | 2001-02-13 | 2002-08-23 | Four T Vision:Kk | System for selling merchandise |
| JP2003176916A (en) * | 2003-01-24 | 2003-06-27 | Finefoods Co Ltd | Cooking assisting system, and cooking assisting method |
| JP2003237946A (en) * | 2002-02-07 | 2003-08-27 | Fujitsu Ltd | Inventory allocation method |
| US7143059B2 (en) * | 2001-10-23 | 2006-11-28 | International Business Machines Corporation | Managing stock available to on-line and in-person shoppers |
| US7475024B1 (en) * | 2000-12-13 | 2009-01-06 | Microsoft Corporation | System and method for distributing in real-time, inventory data acquired from in-store point of sale terminals |
| JP2010256959A (en) * | 2009-04-21 | 2010-11-11 | Fujitsu Ltd | Inventory management device, inventory management method, and its program |
| JP2013054674A (en) * | 2011-09-06 | 2013-03-21 | Toshiba Tec Corp | Commodity order management device and program |
| JP2015130000A (en) * | 2014-01-06 | 2015-07-16 | 株式会社エヌ・ティ・ティ・データ | Inventory management supporting system, inventory management supporting apparatus, and inventory management supporting method |
| CN106097609A (en) * | 2016-07-21 | 2016-11-09 | ***股份有限公司 | The remote control administrative system of intelligence POS terminal and remote monitoring and administration method |
| JP2020035136A (en) * | 2018-08-29 | 2020-03-05 | 株式会社オービック | Inventory allocation device, inventory allocation method and inventory allocation program |
| CN113763055A (en) * | 2021-10-25 | 2021-12-07 | 金蝶软件（中国）有限公司 | Prediction method for store commodity distribution and related equipment |
| CN115512494A (en) * | 2021-06-07 | 2022-12-23 | 东芝泰格有限公司 | Sales data processing device, theft preventing device, inventory management system, and storage medium |
-
1997
- 1997-11-20 JP JP31937897A patent/JP3777759B2/en not_active Expired - Fee Related
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20010006788A (en) * | 1999-06-22 | 2001-01-26 | 김점두 | Process for preventing environmental contamination connected with direct transactions of agricultural, livestock, fishery, and forestry produce |
| WO2001059641A1 (en) * | 2000-02-09 | 2001-08-16 | Sony Computer Entertainment Inc. | Sale managing method, sale managing system, and commodity selling system |
| JP2001222577A (en) * | 2000-02-09 | 2001-08-17 | Sony Computer Entertainment Inc | Method and system for managing sale and article selling system |
| JP2001357271A (en) * | 2000-06-14 | 2001-12-26 | Mitsubishi Electric Information Systems Corp | Device and method for, stock control and computer- readable recording medium recorded with program |
| JP2002128246A (en) * | 2000-10-24 | 2002-05-09 | Nec Corp | Product repair and management system |
| JP2002145420A (en) * | 2000-11-14 | 2002-05-22 | Sagawa Express Co Ltd | Inventory management system and inventory management system using network |
| US7475024B1 (en) * | 2000-12-13 | 2009-01-06 | Microsoft Corporation | System and method for distributing in real-time, inventory data acquired from in-store point of sale terminals |
| JP2002236771A (en) * | 2001-02-13 | 2002-08-23 | Four T Vision:Kk | System for selling merchandise |
| US7143059B2 (en) * | 2001-10-23 | 2006-11-28 | International Business Machines Corporation | Managing stock available to on-line and in-person shoppers |
| JP2003237946A (en) * | 2002-02-07 | 2003-08-27 | Fujitsu Ltd | Inventory allocation method |
| JP2003176916A (en) * | 2003-01-24 | 2003-06-27 | Finefoods Co Ltd | Cooking assisting system, and cooking assisting method |
| JP2010256959A (en) * | 2009-04-21 | 2010-11-11 | Fujitsu Ltd | Inventory management device, inventory management method, and its program |
| JP2013054674A (en) * | 2011-09-06 | 2013-03-21 | Toshiba Tec Corp | Commodity order management device and program |
| JP2015130000A (en) * | 2014-01-06 | 2015-07-16 | 株式会社エヌ・ティ・ティ・データ | Inventory management supporting system, inventory management supporting apparatus, and inventory management supporting method |
| CN106097609A (en) * | 2016-07-21 | 2016-11-09 | ***股份有限公司 | The remote control administrative system of intelligence POS terminal and remote monitoring and administration method |
| JP2020035136A (en) * | 2018-08-29 | 2020-03-05 | 株式会社オービック | Inventory allocation device, inventory allocation method and inventory allocation program |
| CN115512494A (en) * | 2021-06-07 | 2022-12-23 | 东芝泰格有限公司 | Sales data processing device, theft preventing device, inventory management system, and storage medium |
| CN113763055A (en) * | 2021-10-25 | 2021-12-07 | 金蝶软件（中国）有限公司 | Prediction method for store commodity distribution and related equipment |
| CN113763055B (en) * | 2021-10-25 | 2024-03-19 | 金蝶软件（中国）有限公司 | Store commodity distribution prediction method and related equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| JP3777759B2 (en) | 2006-05-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JPH11154280A (en) | Real time inventory control system | |
| AU670879B2 (en) | Computer integration network for channeling customer orders through a centralized computer to various suppliers | |
| US6591243B1 (en) | Method and system for supply chain control | |
| US5897260A (en) | Print job allocation system | |
| CA2908123C (en) | Delivery of goods to electronic storage lockers | |
| US20030212614A1 (en) | System and method for managing inventory | |
| US20180121863A1 (en) | Barreled liquefied petroleum gas distribution system and barreled liquefied petroleum gas distribution method | |
| US20020147667A1 (en) | Distribution control system and method, and server apparatus and its control method | |
| EP1503320A1 (en) | Distribution management system | |
| WO2002099713A1 (en) | Layaway request managing system | |
| EP1580633A1 (en) | Shipment management system and shipment management method | |
| JP2000306021A (en) | Component managing device for facility equipment | |
| JPH10143568A (en) | Physical distribution information management system | |
| JP2002024603A (en) | Gift exchanging system allowing change/transfer of gift | |
| JP2002245155A (en) | Cleaning system | |
| JP2003171020A (en) | Physical distribution method and system for articles of commodities | |
| JPH09136704A (en) | Physical distribution management system | |
| JP4055366B2 (en) | Order receiving system and order processing method | |
| JP2005060108A (en) | Physical distribution management system | |
| JPH1196240A (en) | Method for ordering merchandise | |
| KR20010044414A (en) | Freight traffic system on internet | |
| JP2021051500A (en) | Stock managing device and program | |
| JP2002197266A (en) | Sales method of consumable product | |
| JP2002288488A (en) | Material procuring system by using network | |
| KR20240027419A (en) | Integrated store management system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| A977 | Report on retrieval |
Free format text: JAPANESE INTERMEDIATE CODE: A971007 Effective date: 20051121 |
|
| A131 | Notification of reasons for refusal |
Free format text: JAPANESE INTERMEDIATE CODE: A131 Effective date: 20051129 |
|
| A521 | Request for written amendment filed |
Free format text: JAPANESE INTERMEDIATE CODE: A523 Effective date: 20051206 |
|
| TRDD | Decision of grant or rejection written | ||
| A01 | Written decision to grant a patent or to grant a registration (utility model) |
Free format text: JAPANESE INTERMEDIATE CODE: A01 Effective date: 20060207 |
|
| A61 | First payment of annual fees (during grant procedure) |
Free format text: JAPANESE INTERMEDIATE CODE: A61 Effective date: 20060220 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20100310 Year of fee payment: 4 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20110310 Year of fee payment: 5 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20110310 Year of fee payment: 5 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20120310 Year of fee payment: 6 |
|
| FPAY | Renewal fee payment (event date is renewal date of database) |
Free format text: PAYMENT UNTIL: 20130310 Year of fee payment: 7 |
|
| S531 | Written request for registration of change of domicile |
Free format text: JAPANESE INTERMEDIATE CODE: R313532 |
|
| R350 | Written notification of registration of transfer |
Free format text: JAPANESE INTERMEDIATE CODE: R350 |
|
| LAPS | Cancellation because of no payment of annual fees |