JPH01109472A - System for trace back-processing unit price in stock control system - Google Patents
System for trace back-processing unit price in stock control systemInfo
- Publication number
- JPH01109472A JPH01109472A JP62267736A JP26773687A JPH01109472A JP H01109472 A JPH01109472 A JP H01109472A JP 62267736 A JP62267736 A JP 62267736A JP 26773687 A JP26773687 A JP 26773687A JP H01109472 A JPH01109472 A JP H01109472A
- Authority
- JP
- Japan
- Prior art keywords
- unit price
- transaction
- file
- date
- storage means
- 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.)
- Pending
Links
- 238000007726 management method Methods 0.000 claims description 10
- 238000003672 processing method Methods 0.000 claims description 6
- 238000012937 correction Methods 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 4
- 230000001105 regulatory effect Effects 0.000 description 2
- 241000229094 Chordeiles Species 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
Landscapes
- Warehouses Or Storage Devices (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
【発明の詳細な説明】
〔産業上の利用分野〕
本発明は単価遡及処理方式に関し、特に購入物品の単価
の更新期日よりも決定期日が遅いときに決定単価をその
更新期日まで遡及して訂正する在庫管理システムの単価
遡及処理方式に関する。[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a unit price retrospective processing method, and in particular, when the determination date is later than the renewal date of the unit price of purchased goods, the determined unit price is corrected retroactively to the renewal date. This invention relates to a unit price retroactive processing method for an inventory management system.
従来、物品の在庫管理、特に病院などで使用する消耗品
などでは市況による価格の変動はあるが、−回ごとに契
約して購入する方法ではなくある期間を定めてその間で
購入する分については、単価をあらかじめ取決めて必要
に応じて購入している。Traditionally, inventory management of goods, especially for consumables used in hospitals etc., has been subject to price fluctuations depending on market conditions, but instead of contracting and purchasing each time, it has been possible to manage supplies over a set period of time. , unit prices are determined in advance and purchased as needed.
これは手持在庫を必要以上にかかえないようにしたり、
物品によっては使用する有効期限があり、これらに影響
されることのないようにするためにも有効な方法である
。また、最高価格や最低価格が事実上規制されているも
のもあり、この規制額の変更などで単価の改定を実施す
ることもある。This prevents on-hand inventory from taking up more than necessary,
Some products have expiration dates, and this is an effective method to avoid being affected by these expiration dates. Additionally, there are some products whose maximum and minimum prices are effectively regulated, and unit prices may be revised due to changes in these regulated amounts.
従って、比較的頻繁に単価の改定を行わざるを得ない、
しかし、単価の更新は後日の価格にも影響するので、単
価の更新が提案されても直ちに゛決定できず、単価決定
までの交渉に時間を費やし、単価更新の期日を定めても
決定までにはある程度の日数を要する。Therefore, we are forced to revise unit prices relatively frequently.
However, since unit price updates affect future prices, even if a unit price update is proposed, it cannot be decided immediately, and time is spent negotiating until the unit price is decided. takes a certain number of days.
例えば第3図に見るように、12月1日に単価の更新を
決めても単価決定が翌年の3月15日になってしまうよ
うな場合に、同図のX−1で示されるように単価未定の
ときに日常の処理を中止することは現実的でない。また
、X−2,X−3に見るように旧単価または仮単価で在
庫管理して、新単価が決定してからこれらの差額を原価
に振替えることが本来であるが、一般にはそのまま帳簿
処理がされていた。従って厳密に言えば費用の計上に問
題を生じることもあった。For example, as shown in Figure 3, even if you decide to update the unit price on December 1st, the unit price will not be determined until March 15th of the following year. It is not realistic to suspend daily processing when the unit price has not been determined. Also, as shown in X-2 and X-3, the original practice is to manage inventory using the old unit price or provisional unit price, and then transfer the difference to cost price after the new unit price is determined, but in general, it is used as is in the books. It was being processed. Strictly speaking, therefore, problems may arise in recording costs.
〔発明が解決しようとす、る問題点丁
寧発明が解決しようとする問題点は、上述のように単価
未定のときに、旧単価または仮単価で在庫管理しても新
単価の決定後に原価に振替えずそのまま帳簿処理がなさ
れていたので、本来は計上すべき費用が計上洩れを起し
たり、逆に計上すべきでない費用が計上される可能性が
生ずるという点にある。[Problem that the invention attempts to solveThe problem that the invention attempts to solve is that, as mentioned above, when the unit price is undetermined, even if inventory is managed using the old unit price or provisional unit price, the cost price will not change after the new unit price is determined. Because the books were processed without transfer, there is a possibility that expenses that should have been recorded may not be recorded, or that expenses that should not have been recorded may be recorded.
従って本発明の目的は、上記欠点を解決した夜鷹管理シ
ステムの単価遡及処理方式を提供することにある。SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide a retroactive unit price processing method for a nighthawk management system that solves the above-mentioned drawbacks.
本発明の在庫管理システムの単価遡及処理方式は、物品
の発注に必要な情報を格納した物品マスタファイルと、
前記物品の発注の内容を格納して管理する発注ファイル
と、発注した前記物品の在庫情報を格納した納品・出庫
ファイルとを含む記憶手段と、前記記憶手段に格納され
たデータに基き物品の在庫を管理すると共に、購入物品
の単価の更新期日よりも単価の決定期日が遅いときは単
価の決定時点で、あらかじめ定めらhたプログラムに従
って前記記憶手段に格納されたデータを遡及して訂正す
るデータ処理の指示を行い、その結果を出力する制御手
段と、前記制御手段の指定に基き訂正を実行する計算機
ユニットとを備えて構成さhる。The unit price retroactive processing method of the inventory management system of the present invention uses an article master file that stores information necessary for ordering articles;
storage means including an ordering file for storing and managing the contents of orders for the goods, and a delivery/shipping file storing inventory information for the ordered goods; data for retroactively correcting the data stored in the storage means according to a predetermined program at the time of unit price determination when the unit price determination date is later than the unit price update date of the purchased item. The apparatus is configured to include a control means for issuing processing instructions and outputting the results, and a computer unit for executing corrections based on the specifications of the control means.
次に、本発明について実施例を示す図面を参照して説明
する。Next, the present invention will be described with reference to drawings showing embodiments.
第1図は本発明の一実施例の構成を示すブct。FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.
り図、第2図は本発明の一実施例の作動を示すフローチ
ャート、第3図は本発明の背景と結果を示す説明図であ
る。2 is a flow chart showing the operation of an embodiment of the present invention, and FIG. 3 is an explanatory diagram showing the background and results of the present invention.
まず本発明の概要について説明する。First, an overview of the present invention will be explained.
第3図のY−1およびY−2を見るに、外周条件により
単価の変更が12月1日であったとすると、12月1日
以降の取引の単価は11月30日以前の旧単価から新単
価の決定額を予測して、なるべくこれに近い額を取引の
仮単価に設定する。Looking at Y-1 and Y-2 in Figure 3, if the unit price was changed on December 1st due to peripheral conditions, the unit price for transactions after December 1st will change from the old unit price before November 30th. Predict the amount that will be determined as the new unit price, and set an amount as close to this as possible as the tentative unit price for the transaction.
次にこの仮単価を物品マスタファイルll内の契約単価
履歴部11Aに記憶させると共に、新単価決定期日前ま
での取引に使用する。この取引の結果は、仮単価の取引
であるという指標を付するか、仮単価による取引のため
の記憶手段の格納領域を設けるか、いずれかの方法で記
憶させる。Next, this provisional unit price is stored in the contract unit price history section 11A in the article master file 11, and is used for transactions until the new unit price determination date. The result of this transaction is stored by either attaching an indicator that it is a transaction at a provisional unit price, or by providing a storage area of a storage means for transactions at a provisional unit price.
単価が決定する(すなわち新単価の決定ができる)と、
単価更新時から単価決定時までの取引について、遡及し
て新単価による取引内容として算出して、すでに格納さ
れた記憶内容を訂正している(第3図Y−1参照)。か
ようにして仮単価による日常の処理を実施しておき、単
価決定時点で改めて訂正を行って帳簿上の問題点を解決
するものである。Once the unit price is determined (that is, the new unit price can be determined),
Transactions from the time of unit price update to the time of unit price determination are retroactively calculated as transaction details based on the new unit price, and the already stored memory contents are corrected (see FIG. 3 Y-1). In this way, daily processing is carried out using provisional unit prices, and when unit prices are determined, corrections are made once again to resolve problems in the bookkeeping.
次に本発明の一実施例の構成について説明する。Next, a configuration of an embodiment of the present invention will be described.
第1図を参照するに本実施例は、契約単価履歴部11A
を含む物品マスタファイル11と発注ファイル12と納
入出庫ファイル13とを備えて成る記憶手段1と、CR
T端末21とプリンタ22とを備えて成る制御手段2と
、計算機ユニット3とで構成されデータバス100で結
ばれている。Referring to FIG. 1, in this embodiment, the contract unit price history section 11A
a storage means 1 comprising an article master file 11, an order file 12, and a delivery/issue file 13;
The control means 2 includes a T terminal 21 and a printer 22, and a computer unit 3, which are connected by a data bus 100.
これらの作動について説明する。These operations will be explained.
通常、物品マスタファイル11、発注ファイル12、納
入出庫ファイル13は磁気テープまたは磁気ディスクも
しくは光ディスクに格納されている。特に物品マスタフ
ァイル11には契約単価履歴ファイルIIAをも含んで
おり、これには時点ごとの契約単価と仮単価とが格納さ
れている。−般には、制御手段2のCTR端末21から
契約単価または仮単価を含む物品情報を入力し、物品マ
スタファイル11に格納する。そして、物品の発注をす
るときは、発注内容なCTR端末21から発注ファイル
12に格納すると共に、プリンタ22から発注伝票を出
力させる。発注した物品が納入されたときはその結果を
、物品を出庫するときはその出庫内容を、それぞれCR
T端末21から納入出庫ファイル13に格納する。ここ
で単価変更を行って一時的に仮単価を設定した場合でも
、物品マスタファイルll内の契約単価履歴部11A中
の仮単価の格納場所を他と特別に区切るなどしておくほ
かは、これまでの物品→スタフアイルと同様に扱う。そ
して新単価決定のときは、新単価と決定期日などをCR
T端末21から入力し、あらかじめ用意されたプログラ
ムに従い帳簿の遡及処理を行い、その結果をそれぞれ該
当するファイルに格納する。Usually, the article master file 11, the order file 12, and the delivery/output file 13 are stored on a magnetic tape, a magnetic disk, or an optical disk. In particular, the article master file 11 also includes a contract unit price history file IIA, which stores contract unit prices and provisional unit prices for each point in time. - Generally, article information including the contract unit price or provisional unit price is input from the CTR terminal 21 of the control means 2 and stored in the article master file 11. When ordering an article, the CTR terminal 21 stores the order details in the order file 12, and the printer 22 outputs an order slip. When the ordered goods are delivered, the results are recorded in the CR, and when the goods are shipped, the contents of the shipment are recorded in the CR.
It is stored in the delivery/issue file 13 from the T terminal 21. Even if you change the unit price here and temporarily set a provisional unit price, the storage location for the provisional unit price in the contract unit price history section 11A in the article master file ll must be specially separated from others. Items up to → are treated in the same way as staff aisle. When deciding on a new unit price, confirm the new unit price and decision date in the CR.
Input is made from the T terminal 21, retrospective processing of the ledger is performed according to a program prepared in advance, and the results are stored in respective corresponding files.
次に、本発明の一実施例の作動について順を追ってフロ
ーチャートを参照して説明する。Next, the operation of one embodiment of the present invention will be explained in order with reference to flowcharts.
まず第2図を見るに、物品の単価の規制条件が変更にな
ると(ステップ■)、単価の更新が必要となる場合が多
い。単価の更新が不要であれば従来の単価を維持し、単
価の更新を必要とするときはステップ■の作動を続ける
(ステップ■)。First, looking at FIG. 2, when the regulation conditions for the unit price of an article change (step 2), it is often necessary to update the unit price. If the unit price does not need to be updated, the conventional unit price is maintained, and if the unit price needs to be updated, the operation of step ■ continues (step ■).
契約更新期日に新単価が決定していれば(ステップ■)
、その新単価を契約単価履歴部11Aに設定格納してお
く(ステップ■)。契約更新期日に新単価が決定してい
ないときは(ステップ■)、まず新単価決定前に取引が
なければ、従来通りの単価を維持しておき、取引があっ
て(ステップ■)も旧単価と仮単価とが同一のときも、
従来通りの単価にしておき仮単価であることのみを契約
単価履歴部lIAに格納しておく(ステップ■)。If the new unit price has been determined on the contract renewal date (step ■)
, the new unit price is set and stored in the contract unit price history section 11A (step 2). If the new unit price has not been determined on the contract renewal date (step ■), first, if there is no transaction before the new unit price is determined, maintain the previous unit price, and even if there is a transaction (step ■), the old unit price will be maintained. Even when and the tentative unit price are the same,
The unit price is set as before, and only the fact that it is a provisional unit price is stored in the contract unit price history section IIA (step 2).
次に旧単価と新単価とが同一でないときは、仮単価を設
定して契約単価履歴部11Aに格納する(ステップ■)
。新単価が決定されると(ステップ■)、これも契約単
価履歴部11Aに格納する(ステップ■)。ここで、契
約更新決定から新単価決定までの取引に対して、記憶手
段に格納された項目について、遡及して計算を行う(ス
テップ0)と共に、記憶手段lに格納されている不要な
データを除去する(ステップ■)。Next, if the old unit price and new unit price are not the same, a provisional unit price is set and stored in the contract unit price history section 11A (step ■).
. When the new unit price is determined (step 2), it is also stored in the contract unit price history section 11A (step 2). Here, the items stored in the storage means are retrospectively calculated for transactions from the decision to renew the contract to the determination of the new unit price (step 0), and unnecessary data stored in the storage means l is Remove (step ■).
次に、契約更新決定から新単価決定までの取引に対して
、仮単価と新単価との相違に基づく購入金額を集計して
訂正すると同時に、旧単価と新単価との購入金額の比較
を、CRT端末21に表示すると共に、要求に応じてプ
リンタ22から出力する(ステップ[相])。Next, for transactions from the decision to renew the contract to the decision of the new unit price, we aggregate and correct the purchase amount based on the difference between the tentative unit price and the new unit price, and at the same time, compare the purchase amount between the old unit price and the new unit price. It is displayed on the CRT terminal 21 and outputted from the printer 22 in response to a request (step [phase]).
なお、CRT端末21の入力は、OCR入力またはバー
コードなどの入力に替えてもよく、制御手段2は、例え
ば管理、発注、倉庫の各部門のそれぞれにデータバス1
00で結んで設置して在庫管理を行ってもよい。Note that the input of the CRT terminal 21 may be replaced with an OCR input or a bar code input, and the control means 2 has a data bus 1 for each of the management, ordering, and warehouse departments, for example.
It is also possible to perform inventory management by connecting the numbers with 00 and installing them.
以上詳細に説明したように本発明の在庫管理システムの
単価遡及処理方式は、物品の在庫管理を実施するに当り
、購入単価の更新期日よりも単価の決定期日が遅れた時
は仮単価を設定して取引を行い、単価が決定した時点で
遡及してデータ処理を行うので、物品在庫管理業務が継
続してできると共に、新旧単価に従った購入金額の比較
ができるという効果がある。As explained in detail above, the unit price retrospective processing method of the inventory management system of the present invention sets a provisional unit price when the unit price determination date is later than the purchase unit price update date when performing inventory management of goods. Since the transaction is carried out and the data processing is performed retroactively when the unit price is determined, it is possible to continue the goods inventory management work and also to be able to compare the purchase amount according to the old and new unit prices.
第1図は本発明の一実施例の構成を示すブロック図、第
2図は本発明の一実施例の作動を示すフローチャート、
第3図は本発明の背景と結果を示す説明図。
1・・・・・・記憶手段、2・・・・・・制御手段、3
・・・・・・計算機ユニット、11・・・・・・物品マ
スタファイル、11A・・・・・・契約単価履歴部、2
1・・・・・・CRT端末、22・・・・・・プリンタ
。
代理人 弁理士 内 原 晋
ll:#品マスタフ冴ル I2;発注糸ル 13:納
品出庫ファイルtoo : デ°−y ノvス 11:
’E約単may*第1図FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention, FIG. 2 is a flowchart showing the operation of an embodiment of the present invention,
FIG. 3 is an explanatory diagram showing the background and results of the present invention. 1... Storage means, 2... Control means, 3
... Computer unit, 11 ... Goods master file, 11A ... Contract unit price history section, 2
1...CRT terminal, 22...Printer. Agent Patent attorney Susumu Uchihara: #Product master tough I2; Order thread 13: Delivery/output file too: De°-y Novus 11:
'E approx. may *Figure 1
Claims (1)
と、前記物品の発注の内容を格納して管理する発注ファ
イルと、発注した前記物品の在庫情報を格納した納品・
出庫ファイルとを含む記憶手段と、前記記憶手段に格納
されたデータに基き物品の在庫を管理すると共に購入物
品の単価の更新日よりも単価の決定期日が遅いときは単
価の決定時点で、あらかじめ定められたプログラムに従
って前記記憶手段に格納されたデータを遡及して訂正す
るデータ処理の指示を行い、その結果を出力する制御手
段と、前記制御手段の指定に基き訂正を実行する計算機
ユニットとを備えて成ることを特徴とする在庫管理シス
テムの単価遡及処理方式。An item master file that stores information necessary for ordering items, an ordering file that stores and manages the contents of orders for the items, and a delivery/delivery file that stores inventory information for the ordered items.
A storage means including a shipping file, and the inventory of goods is managed based on the data stored in the storage means, and when the unit price determination date is later than the update date of the unit price of the purchased goods, the unit price is determined in advance at the time of unit price determination. A control means for instructing data processing to retroactively correct data stored in the storage means according to a prescribed program and outputting the results; and a computer unit for executing corrections based on specifications of the control means. A unit price retroactive processing method for an inventory management system characterized by comprising:
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP62267736A JPH01109472A (en) | 1987-10-22 | 1987-10-22 | System for trace back-processing unit price in stock control system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP62267736A JPH01109472A (en) | 1987-10-22 | 1987-10-22 | System for trace back-processing unit price in stock control system |
Publications (1)
Publication Number | Publication Date |
---|---|
JPH01109472A true JPH01109472A (en) | 1989-04-26 |
Family
ID=17448861
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
JP62267736A Pending JPH01109472A (en) | 1987-10-22 | 1987-10-22 | System for trace back-processing unit price in stock control system |
Country Status (1)
Country | Link |
---|---|
JP (1) | JPH01109472A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2020038509A (en) * | 2018-09-04 | 2020-03-12 | 株式会社オービック | Unit price retroaction processing device, unit price retroaction processing method, and unit price retroaction processing program |
JP2020052488A (en) * | 2018-09-25 | 2020-04-02 | 株式会社オービック | Inventory amount adjustment device, inventory amount adjustment method and inventory amount adjustment program |
JP2022113852A (en) * | 2018-09-04 | 2022-08-04 | 株式会社オービック | Unit price retroaction processing device, unit price retroaction processing method, and unit price retroaction processing program |
-
1987
- 1987-10-22 JP JP62267736A patent/JPH01109472A/en active Pending
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2020038509A (en) * | 2018-09-04 | 2020-03-12 | 株式会社オービック | Unit price retroaction processing device, unit price retroaction processing method, and unit price retroaction processing program |
JP2022113852A (en) * | 2018-09-04 | 2022-08-04 | 株式会社オービック | Unit price retroaction processing device, unit price retroaction processing method, and unit price retroaction processing program |
JP2020052488A (en) * | 2018-09-25 | 2020-04-02 | 株式会社オービック | Inventory amount adjustment device, inventory amount adjustment method and inventory amount adjustment program |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20050182696A1 (en) | System and method for automatically controlling inventory | |
US20060149639A1 (en) | Method and system for creating a purchase suggesting list retailers | |
JP6956837B2 (en) | Sales information device, amount retroactive method and amount retroactive program | |
JP2007164361A (en) | Credit sales system, credit sales method, and credit sales program | |
JP7073066B2 (en) | Arrangement process management device, arrangement process management method, and arrangement process management program | |
JPH01109472A (en) | System for trace back-processing unit price in stock control system | |
JP2019175156A (en) | Balance management device for each store, balance management method therefor, and balance management program therefor | |
US20070265943A1 (en) | Product management system, product management apparatus, and product management method | |
US7478061B1 (en) | Automated audit process | |
JPH05324685A (en) | Stock controlling system for anticipative product | |
JP2001125976A (en) | Integration system for placement and acceptance of order of merchandise, storage medium of merchandise information management program and merchandise master data storage medium | |
JP7149088B2 (en) | Gross profit display device, gross profit display method and gross profit display program | |
JP7541909B2 (en) | Movement instruction data creation device, movement instruction data creation method, and movement instruction data creation program | |
JPH09212556A (en) | Operating instruction method in process schedule | |
JP7507932B2 (en) | Business support device, business support method, and business support program | |
Hall | What is VMI? | |
JP7543205B2 (en) | Attachment input work support device, attachment input work support method, and attachment input work support program | |
JP7542024B2 (en) | Scrap material trading support device, scrap material trading support method, and scrap material trading support program | |
JPH0690709B2 (en) | Inventory management method | |
JP7323479B2 (en) | New registration quota check device, new registration quota check method and new registration quota check program | |
JP7161333B2 (en) | Inventory valuation replacement candidate extraction device, inventory valuation replacement candidate extraction method, and inventory valuation replacement candidate extraction program | |
JP2004149262A (en) | Sales management system and method for sales management | |
JPH1139199A (en) | Job management data transaction system | |
JPH1131183A (en) | Inventory management system | |
Vihijärvi | Implementing an MRP system in a Procurement Department: Case Study: Cargotec Finland Oy |