JP7045812B2 - Transfer device, transfer method, and transfer program - Google Patents

Transfer device, transfer method, and transfer program Download PDF

Info

Publication number
JP7045812B2
JP7045812B2 JP2017134181A JP2017134181A JP7045812B2 JP 7045812 B2 JP7045812 B2 JP 7045812B2 JP 2017134181 A JP2017134181 A JP 2017134181A JP 2017134181 A JP2017134181 A JP 2017134181A JP 7045812 B2 JP7045812 B2 JP 7045812B2
Authority
JP
Japan
Prior art keywords
product
inventory
storage means
transfer
amount
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.)
Active
Application number
JP2017134181A
Other languages
Japanese (ja)
Other versions
JP2019016242A (en
Inventor
佑介 秋月
剛光 上野
Original Assignee
株式会社オービック
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 株式会社オービック filed Critical 株式会社オービック
Priority to JP2017134181A priority Critical patent/JP7045812B2/en
Publication of JP2019016242A publication Critical patent/JP2019016242A/en
Application granted granted Critical
Publication of JP7045812B2 publication Critical patent/JP7045812B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30—Computing systems specially adapted for manufacturing
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02T—CLIMATE CHANGE MITIGATION TECHNOLOGIES RELATED TO TRANSPORTATION
    • Y02T10/00—Road transport of goods or passengers
    • Y02T10/10—Internal combustion engine [ICE] based vehicles
    • Y02T10/12—Improving ICE efficiencies

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Description

本発明は、振替装置、振替方法、および、振替プログラムに関する。 The present invention relates to a transfer device, a transfer method, and a transfer program.

特許文献１には、精米原料のロットＮｏと、精米製品の商品コードと、を紐付けて管理することで、ユーザが商品（同一銘柄の混米等）に含まれる精米原料の正確な履歴を把握することができるシステムが開示されている。 In Patent Document 1, the lot number of the rice-polished raw material and the product code of the rice-polished product are linked and managed, so that the user can obtain an accurate history of the rice-polished raw material contained in the product (mixed rice of the same brand, etc.). A system that can be grasped is disclosed.

特開２００７－１９６１９４号公報Japanese Unexamined Patent Publication No. 2007-196194

しかしながら、上記特許文献１においては、在庫価格等を管理する仕組を備えていないことに加え、製品の製造実績の登録と商品在庫の登録とを別入力で行うため、リアルタイムで在庫確認ができないだけでなく、販売部門側にて入力を忘れた場合、正しい在庫確認ができないという課題があった。 However, in the above-mentioned Patent Document 1, in addition to not having a mechanism for managing the inventory price and the like, the registration of the manufacturing record of the product and the registration of the product inventory are performed separately, so that the inventory cannot be confirmed in real time. Instead, if the sales department forgets to enter it, there is a problem that the correct inventory cannot be confirmed.

本発明は、上記問題点に鑑みてなされたものであって、化学業等の製造業において、工場が管理する製品コードは複数コードに分けて管理され、営業が管理する商品コードは１つのコードで管理される場合であっても、製品の製造実績の登録と同時に、営業が管理する商品へ振替処理を自動で行うことができる振替装置、振替方法、および、振替プログラムを提供することを目的とする。 The present invention has been made in view of the above problems. In a manufacturing industry such as a chemical industry, a product code managed by a factory is managed by dividing it into a plurality of codes, and a product code managed by a sales person is one code. The purpose is to provide a transfer device, transfer method, and transfer program that can automatically perform transfer processing to products managed by sales at the same time as registering the manufacturing results of the product, even if it is managed by. And.

上述した課題を解決し、目的を達成するために、本発明に係る振替装置は、記憶部と制御部とを備えた振替装置であって、前記記憶部は、製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、を備え、前記制御部は、前記製品の製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替手段と、前記製品の原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替手段と、を備えたことを特徴とする。 In order to solve the above-mentioned problems and achieve the object, the transfer device according to the present invention is a transfer device including a storage unit and a control unit, and the storage unit is a product of a product managed by a manufacturing department. A product number storage means for storing a product number master that links a product number and a product product number of a product corresponding to the product managed by the sales department, and stores the product product number, the number of manufactured products, and the cost amount of the product. The control unit includes a manufacturing record storage means for storing the product product number, the stock quantity of the product, and the inventory value of the product, and the control unit stores the manufacturing record of the product. When registered in the means, the quantity transfer means for transferring the manufactured quantity to the stock quantity of the product corresponding to the product and registering it in the inventory storage means based on the product number master, and the cost amount of the product are described above. When registered in the manufacturing record storage means, it is provided with an amount transfer means for transferring the cost amount to the inventory amount of the product corresponding to the product and registering it in the inventory storage means based on the product number master. It is characterized by.

また、本発明に係る振替装置は、前記製造実績記憶手段は、更に、登録日付を記憶し、前記記憶部は、前記製品品番および前記製品の製品振替数、または、前記商品品番および前記商品の商品振替数と、前記登録日付と、を対応付けて記憶する振替実績記憶手段、を更に備え、前記数量振替手段は、前記製品の製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数から当該製品に相当する前記商品の在庫数への前記製品振替数を前記製品品番および前記登録日付と対応付けて前記振替実績記憶手段に登録し、当該在庫数に相当する前記商品振替数を前記商品品番および前記登録日付と対応付けて前記振替実績記憶手段に登録することで、当該商品振替数を当該在庫数として前記在庫記憶手段に登録することを特徴とする。 Further, in the transfer device according to the present invention, the manufacturing record storage means further stores the registration date, and the storage unit is the product product number and the number of product transfers of the product, or the product product number and the product. Further, the transfer record storage means for storing the number of product transfers and the registration date in association with each other is further provided, and the quantity transfer means is the product number when the manufactured number of the product is registered in the manufacturing record storage means. Based on the master, the number of product transfers from the number of manufactured products to the number of stocks of the product corresponding to the product is registered in the transfer record storage means in association with the product part number and the registration date, and the number of products is registered in the stock quantity. By registering the corresponding product transfer number in the transfer record storage means in association with the product product number and the registration date, the product transfer number is registered in the inventory storage means as the stock number. ..

また、本発明に係る振替装置は、前記制御部は、前記商品の売上数量に基づいて、前記在庫記憶手段に記憶された前記商品の前記在庫数および前記在庫金額を更新する在庫更新手段と、を更に備えたことを特徴とする。 Further, in the transfer device according to the present invention, the control unit has an inventory update means for updating the inventory quantity and the inventory amount of the product stored in the inventory storage means based on the sales quantity of the product. It is characterized by being further equipped with.

また、本発明に係る振替装置は、前記記憶部は、前記商品に相当する前記製品の前記製品品番、当該商品の売上日付、前記売上数量、当該商品の売上金額、当該売上数量に対応する在庫金額、および、当該商品の粗利金額を記憶する売上実績記憶手段、を更に備え、前記制御部は、前記品番マスタに基づいて、前記商品の前記売上数量を、当該商品に相当する前記製品の前記製品品番、当該商品の売上日付、当該商品の売上金額、当該売上数量に対応する在庫金額、および、当該商品の粗利金額に対応付けて前記売上実績記憶手段に登録する売上実績登録手段、を更に備え、前記在庫更新手段は、前記商品の前記売上数量、および、当該売上数量に対応する在庫金額に基づいて、前記在庫記憶手段に記憶された当該商品の前記在庫数および前記在庫金額を更新することを特徴とする。 Further, in the transfer device according to the present invention, the storage unit contains the product part number of the product corresponding to the product, the sales date of the product, the sales quantity, the sales amount of the product, and the inventory corresponding to the sales quantity. Further provided with a sales record storage means for storing the amount of money and the gross profit amount of the product, the control unit sets the sales quantity of the product to the sales quantity of the product corresponding to the product based on the product number master. A sales record registration means registered in the sales record storage means in association with the product product number, the sales date of the product, the sales amount of the product, the inventory amount corresponding to the sales quantity, and the gross profit amount of the product. Further, the inventory renewal means obtains the inventory quantity and the inventory value of the product stored in the inventory storage means based on the sales quantity of the product and the inventory value corresponding to the sales quantity. It is characterized by updating.

また、本発明に係る振替装置は、前記制御部は、前記在庫記憶手段に記憶された前記在庫数および前記在庫金額に基づいて、在庫単価を算出し、前記在庫記憶手段に登録する在庫単価算出手段、を更に備えたことを特徴とする。 Further, in the transfer device according to the present invention, the control unit calculates an inventory unit price based on the inventory quantity and the inventory amount stored in the inventory storage means, and calculates the inventory unit price registered in the inventory storage means. It is characterized by further providing means.

また、本発明に係る振替装置は、前記制御部は、前記製品の前記製造数を、当該製品の前記製品品番、登録日付、および、前記原価金額に対応付けて前記製造実績記憶手段に登録する製造実績登録手段、を更に備えたことを特徴とする。 Further, in the transfer device according to the present invention, the control unit registers the manufactured number of the product in the manufacturing record storage means in association with the product part number, the registration date, and the cost amount of the product. It is characterized by being further equipped with a manufacturing record registration means.

また、本発明に係る振替装置は、前記製造実績記憶手段は、前記製品に含まれる原価要素に対応する前記原価金額の内訳である原価内訳金額を記憶する原価内訳記憶手段、を備えたことを特徴とする。 Further, in the transfer device according to the present invention, the manufacturing record storage means includes a cost breakdown storage means for storing a cost breakdown amount which is a breakdown of the cost amount corresponding to the cost element included in the product. It is a feature.

また、本発明に係る振替方法は、記憶部と制御部とを備えた振替装置に実行させるための振替方法であって、前記記憶部は、製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、を備え、前記制御部で実行させる、前記製品の製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替ステップと、前記製品の原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替ステップと、を含むことを特徴とする。 Further, the transfer method according to the present invention is a transfer method for causing a transfer device including a storage unit and a control unit to execute the transfer method, wherein the storage unit is a product number and a sales department of a product managed by a manufacturing department. A product number storage means for storing a product number master associated with a product number of a product corresponding to the product to be managed, and a manufacturing record storage means for storing the product product number, the number of manufactured products, and the cost amount of the product. The product number, the number of stocks of the product, and the stock storage means for storing the stock amount of the product are provided, and the number of manufactured products to be executed by the control unit is registered in the manufacturing record storage means. If so, the quantity transfer step of transferring the manufactured quantity to the stock quantity of the product corresponding to the product and registering it in the inventory storage means based on the product number master, and the cost amount of the product are stored in the manufacturing record. When registered in the means, it is characterized by including a price transfer step of transferring the cost amount to the inventory amount of the product corresponding to the product and registering it in the inventory storage means based on the product number master. ..

また、本発明に係る振替プログラムは、記憶部と制御部とを備えた振替装置に実行させるための振替プログラムであって、前記記憶部は、製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、を備え、前記制御部において、前記製品の製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替ステップと、前記製品の原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替ステップと、を実行させることを特徴とする。 Further, the transfer program according to the present invention is a transfer program for being executed by a transfer device including a storage unit and a control unit, and the storage unit is a product number and a sales department of a product managed by a manufacturing department. A product number storage means for storing a product number master associated with a product number of a product corresponding to the product to be managed, and a manufacturing record storage means for storing the product product number, the number of manufactured products, and the cost amount of the product. And an inventory storage means for storing the product product number, the inventory quantity of the product, and the inventory value of the product, and the production number of the product is registered in the production record storage means in the control unit. In the case, the quantity transfer step of transferring the manufactured quantity to the stock quantity of the product corresponding to the product and registering it in the inventory storage means based on the product number master, and the cost amount of the product in the manufacturing record storage means. When registered, it is characterized in that the amount transfer step of transferring the cost amount to the inventory amount of the product corresponding to the product and registering it in the inventory storage means is executed based on the product number master.

本発明によれば、入力ミスおよび入力漏れが無くなり、リアルタイムで正しい在庫を確認することができるという効果を奏する。 According to the present invention, there is an effect that input errors and input omissions are eliminated and correct inventory can be confirmed in real time.

図１は、振替装置の構成の一例を示すブロック図である。FIG. 1 is a block diagram showing an example of the configuration of a transfer device. 図２は、本実施形態における振替装置の処理の一例を示すフローチャートである。FIG. 2 is a flowchart showing an example of processing of the transfer device in the present embodiment. 図３は、本実施形態における商品品番と製品品番との対応関係の一例を示す図である。FIG. 3 is a diagram showing an example of a correspondence relationship between a product part number and a product part number in the present embodiment. 図４は、本実施形態における品番マスタの一例を示す図である。FIG. 4 is a diagram showing an example of a product number master in the present embodiment. 図５は、本実施形態における振替処理の一例を示すフロー図である。FIG. 5 is a flow chart showing an example of the transfer process in the present embodiment. 図６は、本実施形態における製造実績テーブルおよび原価内訳テーブルの一例を示す図である。FIG. 6 is a diagram showing an example of a manufacturing record table and a cost breakdown table in the present embodiment. 図７は、本実施形態における振替実績テーブルの一例を示す図である。FIG. 7 is a diagram showing an example of a transfer record table in the present embodiment. 図８は、本実施形態における在庫テーブルの一例を示す図である。FIG. 8 is a diagram showing an example of an inventory table in this embodiment. 図９は、本実施形態における製造実績テーブルおよび原価内訳テーブルの一例を示す図である。FIG. 9 is a diagram showing an example of a manufacturing record table and a cost breakdown table in the present embodiment. 図１０は、本実施形態における振替実績テーブルの一例を示す図である。FIG. 10 is a diagram showing an example of a transfer record table in the present embodiment. 図１１は、本実施形態における在庫テーブルの一例を示す図である。FIG. 11 is a diagram showing an example of an inventory table in this embodiment. 図１２は、本実施形態における売上実績テーブルの一例を示す図である。FIG. 12 is a diagram showing an example of a sales record table in this embodiment. 図１３は、本実施形態における在庫テーブルの一例を示す図である。FIG. 13 is a diagram showing an example of an inventory table in this embodiment.

本発明の実施形態を図面に基づいて詳細に説明する。なお、本発明は本実施形態により限定されるものではない。 Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

［１．概要］
従来は、大手の化学業等の製造業において、同じ製品を製造する場合でも、製造工程が異なることで原価が異なるため、営業で管理する商品コードが１つのコードで管理されていても、工場で管理する製品コードが複数コードに分けて管理されていることがあった。そして、従来は、各製品の製造実績の登録後、営業が管理する商品へ振替処理を行う必要があった。ここで、従来の振替処理は、別入力で行うため、入力を忘れると営業側で正しい在庫が確認できない、または、リアルタイムで在庫が確認できないなどの問題が発生していた。 [1. Overview]
Conventionally, in the manufacturing industry such as major chemical industry, even if the same product is manufactured, the cost is different due to the different manufacturing process, so even if the product code managed by sales is managed by one code, the factory In some cases, the product code managed by was divided into multiple codes. In the past, after registering the manufacturing results of each product, it was necessary to transfer the products to the products managed by the sales staff. Here, since the conventional transfer process is performed by another input, there has been a problem that the sales side cannot confirm the correct inventory or the inventory cannot be confirmed in real time if the input is forgotten.

そこで、本実施形態においては、工場で管理する製品と営業で管理する商品との紐付けを品番マスタで事前に行うことで、各製品の製造実績の登録と同時に、営業が管理する商品へ振替処理を自動で行うことを可能としている。 Therefore, in this embodiment, the product managed by the factory and the product managed by the sales are linked in advance by the product number master, so that the product is transferred to the product managed by the sales at the same time as the registration of the manufacturing record of each product. It is possible to perform processing automatically.

［２．構成］
本実施形態に係る振替装置１００の構成の一例について、図１を参照して説明する。図１は、振替装置１００の構成の一例を示すブロック図である。 [2. Constitution]
An example of the configuration of the transfer device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the transfer device 100.

振替装置１００は、市販のデスクトップ型パーソナルコンピュータである。なお、振替装置１００は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、ＰＤＡ（Ｐｅｒｓｏｎａｌ Ｄｉｇｉｔａｌ Ａｓｓｉｓｔａｎｔｓ）、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。 The transfer device 100 is a commercially available desktop personal computer. The transfer device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is portable information such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, and a tablet personal computer. It may be a processing device.

振替装置１００は、制御部１０２と通信インターフェース部１０４と記憶部１０６と入出力インターフェース部１０８と、を備えている。振替装置１００が備えている各部は、任意の通信路を介して通信可能に接続されている。 The transfer device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the transfer device 100 is communicably connected via an arbitrary communication path.

通信インターフェース部１０４は、ルータ等の通信装置および専用線等の有線または無線の通信回線を介して、振替装置１００をネットワーク３００に通信可能に接続する。通信インターフェース部１０４は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク３００は、振替装置１００とサーバ２００とを相互に通信可能に接続する機能を有し、例えばインターネットやＬＡＮ（Ｌｏｃａｌ Ａｒｅａ Ｎｅｔｗｏｒｋ）等である。 The communication interface unit 104 connects the transfer device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the transfer device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like.

記憶部１０６には、各種のデータベース、テーブル、およびファイルなどが格納される。記憶部１０６には、ＯＳ（Ｏｐｅｒａｔｉｎｇ Ｓｙｓｔｅｍ）と協働してＣＰＵ（Ｃｅｎｔｒａｌ Ｐｒｏｃｅｓｓｉｎｇ Ｕｎｉｔ）に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部１０６として、例えば、ＲＡＭ（Ｒａｎｄｏｍ Ａｃｃｅｓｓ Ｍｅｍｏｒｙ）・ＲＯＭ（Ｒｅａｄ Ｏｎｌｙ Ｍｅｍｏｒｙ）等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、および光ディスク等を用いることができる。記憶部１０６は、品番マスタ１０６ａと、製造実績テーブル１０６ｂと、原価内訳テーブル１０６ｃと、振替実績テーブル１０６ｄと、在庫テーブル１０６ｅと、売上実績テーブル１０６ｆとを備えている。 Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a product number master 106a, a manufacturing record table 106b, a cost breakdown table 106c, a transfer record table 106d, an inventory table 106e, and a sales record table 106f.

品番マスタ１０６ａは、製造部門が管理する製品の製品品番と販売部門（営業部門）が管理する当該製品に相当する商品の商品品番とを紐付けたマスタである。ここで、品番マスタ１０６ａは、商品品番のマスタ、および、製品品番と振替先品番（商品品番）とを対応付けたマスタを紐付けていてもよい。また、製造部門は、工場であってもよい。 The product number master 106a is a master in which the product product number of the product managed by the manufacturing department and the product product number of the product corresponding to the product managed by the sales department (sales department) are linked. Here, the product number master 106a may be associated with a master of the product product number and a master in which the product product number and the transfer destination product number (product product number) are associated with each other. Further, the manufacturing department may be a factory.

製造実績テーブル１０６ｂは、製品品番、製品の登録日付（製造実績日付）、製品の製造数、製品の原価単価、製品の原価金額を記憶する。ここで、製品の原価単価および原価金額は、原価単価および原価金額の内訳項目毎の原価内訳金額を含んでもよい。 The manufacturing record table 106b stores the product part number, the product registration date (manufacturing record date), the number of manufactured products, the cost unit price of the product, and the cost amount of the product. Here, the cost unit price and the cost amount of the product may include the cost breakdown amount for each cost unit price and the cost amount breakdown item.

ここで、製造実績テーブル１０６ｂは、図１に示すように、原価内訳テーブル１０６ｃを備える。原価内訳テーブル１０６ｃは、製品に含まれる原価要素の名称、原価要素を製品に投入した投入日付、原価要素の使用数、原価要素の原価単価、および、原価要素に対応する原価金額の内訳である原価内訳金額を記憶する。 Here, the manufacturing record table 106b includes a cost breakdown table 106c as shown in FIG. The cost breakdown table 106c is a breakdown of the name of the cost element included in the product, the input date when the cost element was put into the product, the number of used cost elements, the cost unit price of the cost element, and the cost amount corresponding to the cost element. Cost breakdown Memorize the amount.

振替実績テーブル１０６ｄは、製品品番および製品の製品振替数、または、商品品番および商品の商品振替数と、登録日付（製造実績日付）と、を対応付けて記憶する。 The transfer record table 106d stores the product part number and the number of product transfers of the product, or the product part number and the number of product transfers of the product, and the registration date (manufacturing record date) in association with each other.

在庫テーブル１０６ｅは、商品品番、商品の在庫数、商品の在庫単価、および、商品の在庫金額を記憶する。ここで、在庫テーブル１０６ｅは、商品に振り替えられた製品の製品品番、および、原価単価を記憶していてもよい。 The inventory table 106e stores the product product number, the number of products in stock, the inventory unit price of the product, and the inventory value of the product. Here, the inventory table 106e may store the product part number of the product transferred to the product and the cost unit price.

売上実績テーブル１０６ｆは、商品に相当する製品の製品品番、商品の売上日付、売上数量、商品の売上金額、商品の在庫単価、売上数量に対応する在庫金額、および、商品の粗利金額を記憶する。 The sales record table 106f stores the product number of the product corresponding to the product, the sales date of the product, the sales quantity, the sales amount of the product, the inventory unit price of the product, the inventory amount corresponding to the sales quantity, and the gross profit amount of the product. do.

入出力インターフェース部１０８には、入力装置１１２および出力装置１１４が接続されている。出力装置１１４には、モニタ（家庭用テレビを含む）の他、スピーカやプリンタを用いることができる。入力装置１１２には、キーボード、マウス、およびマイクの他、マウスと協働してポインティングデバイス機能を実現するモニタを用いることができる。なお、以下では、出力装置１１４をモニタ１１４とし、入力装置１１２をキーボード１１２またはマウス１１２として記載する場合がある。 An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, a keyboard, a mouse, and a microphone, as well as a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

制御部１０２は、振替装置１００を統括的に制御するＣＰＵ等である。制御部１０２は、ＯＳ等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。制御部１０２は、機能概念的に、製造実績登録部１０２ａと、数量振替部１０２ｂと、金額振替部１０２ｃと、在庫単価算出部１０２ｄと、売上実績登録部１０２ｅと、在庫更新部１０２ｆとを備えている。 The control unit 102 is a CPU or the like that collectively controls the transfer device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute. The control unit 102 is functionally conceptually provided with a manufacturing record registration unit 102a, a quantity transfer unit 102b, an amount transfer unit 102c, an inventory unit price calculation unit 102d, a sales record registration unit 102e, and an inventory update unit 102f. ing.

製造実績登録部１０２ａは、製品の製造数を、当該製品の製品品番、登録日付、製造数、原価単価、および、原価金額に対応付けて製造実績テーブル１０６ｂに登録する。ここで、製造実績登録部１０２ａは、製品に含まれる原価要素の名称、原価要素を製品に投入した投入日付、原価要素の使用数、原価要素の原価単価、および、原価要素に対応する原価金額の内訳である原価内訳金額を原価内訳テーブル１０６ｃに登録してもよい。 The manufacturing record registration unit 102a registers the manufacturing number of the product in the manufacturing record table 106b in association with the product part number, registration date, manufacturing number, cost unit price, and cost amount of the product. Here, the manufacturing record registration unit 102a includes the name of the cost element included in the product, the input date when the cost element is input to the product, the number of used cost elements, the cost unit price of the cost element, and the cost amount corresponding to the cost element. The cost breakdown amount, which is a breakdown of the above, may be registered in the cost breakdown table 106c.

数量振替部１０２ｂは、製品の製造数が製造実績テーブル１０６ｂに登録された場合、品番マスタ１０６ａに基づいて、当該製造数を当該製品に相当する商品の在庫数に振り替えて在庫テーブル１０６ｅに登録する。ここで、数量振替部１０２ｂは、製品の製造数が製造実績テーブル１０６ｂに登録された場合、品番マスタ１０６ａに基づいて、当該製造数から当該製品に相当する商品の在庫数への製品振替数を製品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録し、当該在庫数に相当する商品振替数を商品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録することで、当該商品振替数を当該在庫数として在庫テーブル１０６ｅに登録してもよい。 When the manufactured quantity of the product is registered in the manufacturing record table 106b, the quantity transfer unit 102b transfers the manufactured quantity to the stock quantity of the product corresponding to the product and registers it in the inventory table 106e based on the part number master 106a. .. Here, when the manufactured quantity of the product is registered in the manufacturing record table 106b, the quantity transfer unit 102b transfers the number of products from the manufactured quantity to the stock quantity of the product corresponding to the product based on the product number master 106a. The number of product transfers is registered in the transfer record table 106d in association with the product product number and registration date, and the number of product transfers corresponding to the stock quantity is registered in the transfer record table 106d in association with the product product number and registration date. May be registered in the stock table 106e as the stock quantity.

金額振替部１０２ｃは、製品の原価金額が製造実績テーブル１０６ｂに登録された場合、品番マスタ１０６ａに基づいて、当該原価金額を当該製品に相当する商品の在庫金額に振り替えて在庫テーブル１０６ｅに登録する。ここで、金額振替部１０２ｃは、品番マスタ１０６ａに基づいて、製品の原価単価を当該製品に相当する商品の在庫単価に振り替えて在庫テーブル１０６ｅに登録してもよい。 When the cost amount of the product is registered in the manufacturing record table 106b, the amount transfer unit 102c transfers the cost amount to the inventory amount of the product corresponding to the product and registers it in the inventory table 106e based on the product number master 106a. .. Here, the amount transfer unit 102c may transfer the cost unit price of the product to the inventory unit price of the product corresponding to the product and register it in the inventory table 106e based on the product number master 106a.

在庫単価算出部１０２ｄは、在庫テーブル１０６ｅに記憶された在庫数および在庫金額に基づいて、在庫単価を算出し、在庫テーブル１０６ｅに登録する。ここで、在庫単価算出部１０２ｄは、算出した在庫単価に基づいて、在庫テーブル１０６ｅに記憶された在庫金額を更新してもよい。また、在庫単価の算出は、端数処理を含んでいてもよい。 The inventory unit price calculation unit 102d calculates the inventory unit price based on the inventory quantity and the inventory amount stored in the inventory table 106e, and registers the inventory unit price in the inventory table 106e. Here, the inventory unit price calculation unit 102d may update the inventory amount stored in the inventory table 106e based on the calculated inventory unit price. Further, the calculation of the inventory unit price may include rounding.

売上実績登録部１０２ｅは、品番マスタ１０６ａに基づいて、商品の売上数量を、当該商品に相当する製品の製品品番、当該商品の売上日付、当該商品の売上金額、当該商品の在庫単価、当該売上数量に対応する在庫金額、および、当該商品の粗利金額に対応付けて売上実績テーブル１０６ｆに登録する。 Based on the product number master 106a, the sales record registration unit 102e determines the sales quantity of the product, the product product number of the product corresponding to the product, the sales date of the product, the sales amount of the product, the inventory unit price of the product, and the sales. It is registered in the sales record table 106f in association with the inventory amount corresponding to the quantity and the gross profit amount of the product.

在庫更新部１０２ｆは、商品の売上数量に基づいて、在庫テーブル１０６ｅに記憶された商品の在庫数および在庫金額を更新する。ここで、在庫更新部１０２ｆは、商品の売上数量、および、当該売上数量に対応する在庫金額に基づいて、在庫テーブル１０６ｅに記憶された当該商品の在庫数および在庫金額を更新してもよい。 The inventory update unit 102f updates the inventory quantity and the inventory value of the product stored in the inventory table 106e based on the sales quantity of the product. Here, the inventory update unit 102f may update the inventory quantity and the inventory value of the product stored in the inventory table 106e based on the sales quantity of the product and the inventory value corresponding to the sales quantity.

［３．具体例］
本実施形態の具体例について、図２から図１３を参照して説明する。 [3. Concrete example]
Specific examples of this embodiment will be described with reference to FIGS. 2 to 13.

［振替処理］
ここで、図２を参照して、本実施形態における振替処理の一例について説明する。図２は、本実施形態における振替装置１００の処理の一例を示すフローチャートである。 [Transfer processing]
Here, an example of the transfer process in the present embodiment will be described with reference to FIG. FIG. 2 is a flowchart showing an example of processing of the transfer device 100 in the present embodiment.

図２に示すように、製造実績登録部１０２ａは、工場にて同一部材からなる製品の製造が完了した場合、当該製品の製造数を、当該製品の製品品番、登録日付、原価単価、および、原価金額に対応付けて製造実績テーブル１０６ｂに登録する（ステップＳＡ－１）。 As shown in FIG. 2, when the manufacturing of a product made of the same material is completed at the factory, the manufacturing record registration unit 102a determines the number of manufactured products, the product part number of the product, the registration date, the unit cost price, and the unit cost. It is registered in the manufacturing record table 106b in association with the cost amount (step SA-1).

そして、数量振替部１０２ｂは、品番マスタ１０６ａに基づいて、製造実績テーブル１０６ｂに登録された製品の製造数から当該製品に相当する商品の在庫数への製品振替数を製品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録し、当該在庫数に相当する商品振替数を商品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録することで、当該商品振替数を当該在庫数として在庫テーブル１０６ｅに登録する（ステップＳＡ－２）。 Then, the quantity transfer unit 102b corresponds to the product product number and the registration date with the product transfer number from the manufactured number of the product registered in the manufacturing record table 106b to the stock number of the product corresponding to the product based on the product number master 106a. By registering the product transfer number corresponding to the stock quantity in the transfer record table 106d in association with the product product number and registration date, the product transfer quantity is set as the stock quantity in the inventory table. Register in 106e (step SA-2).

そして、金額振替部１０２ｃは、品番マスタ１０６ａに基づいて、製造実績テーブル１０６ｂに登録された製品の原価金額を当該製品に相当する商品の在庫金額に振り替えて在庫テーブル１０６ｅに登録する（ステップＳＡ－３）。 Then, the amount transfer unit 102c transfers the cost amount of the product registered in the manufacturing record table 106b to the inventory amount of the product corresponding to the product based on the product number master 106a and registers it in the inventory table 106e (step SA-). 3).

そして、製造実績登録部１０２ａは、製品の製造数の合計が製造予定数に到達したか否かを判定する（ステップＳＡ－４）。 Then, the manufacturing record registration unit 102a determines whether or not the total number of manufactured products has reached the planned number of manufactured products (step SA-4).

そして、製造実績登録部１０２ａは、製品の製造数の合計が製造予定数に到達していないと判定した場合（ステップＳＡ－４：Ｎｏ）、処理をステップＳＡ－１に移行させる。 Then, when it is determined that the total number of manufactured products has not reached the planned number of manufactured products (step SA-4: No), the manufacturing record registration unit 102a shifts the process to step SA-1.

一方、製造実績登録部１０２ａは、製品の製造数の合計が製造予定数に到達したと判定した場合（ステップＳＡ－４：Ｙｅｓ）、処理をステップＳＡ－５に移行させる。 On the other hand, when the manufacturing record registration unit 102a determines that the total number of manufactured products has reached the planned number of manufactured products (step SA-4: Yes), the process shifts to step SA-5.

そして、在庫単価算出部１０２ｄは、在庫テーブル１０６ｅに記憶された商品の在庫数および在庫金額に基づいて、在庫単価を算出し、在庫テーブル１０６ｅに登録する（ステップＳＡ－５）。 Then, the inventory unit price calculation unit 102d calculates the inventory unit price based on the inventory quantity and the inventory value of the products stored in the inventory table 106e, and registers the inventory unit price in the inventory table 106e (step SA-5).

そして、売上実績登録部１０２ｅは、営業部門により商品の販売が行われた場合、品番マスタ１０６ａに基づいて、当該商品の売上数量を、当該商品に相当する製品の製品品番、当該商品の売上日付、当該商品の売上金額、当該商品の在庫単価、当該売上数量に対応する在庫金額、および、当該商品の粗利金額に対応付けて売上実績テーブル１０６ｆに登録する（ステップＳＡ－６）。 Then, when the product is sold by the sales department, the sales record registration unit 102e determines the sales quantity of the product based on the product number master 106a, the product product number of the product corresponding to the product, and the sales date of the product. , The sales amount of the product, the inventory unit price of the product, the inventory amount corresponding to the sales quantity, and the gross profit amount of the product are registered in the sales record table 106f (step SA-6).

そして、在庫更新部１０２ｆは、売上実績テーブル１０６ｆに記憶された商品の売上数量、および、当該売上数量に対応する在庫金額に基づいて、在庫テーブル１０６ｅに記憶された当該商品の在庫数および在庫金額を更新する（ステップＳＡ－７）。 Then, the inventory update unit 102f has the inventory quantity and the inventory amount of the product stored in the inventory table 106e based on the sales quantity of the product stored in the sales record table 106f and the inventory amount corresponding to the sales quantity. Is updated (step SA-7).

そして、在庫更新部１０２ｆは、在庫テーブル１０６ｅに記憶された商品の在庫数に基づいて、当該商品の在庫が存在するか否かを判定する（ステップＳＡ－８）。 Then, the inventory update unit 102f determines whether or not the inventory of the product exists based on the inventory quantity of the product stored in the inventory table 106e (step SA-8).

そして、在庫更新部１０２ｆは、商品の在庫が存在すると判定した場合（ステップＳＡ－８：Ｙｅｓ）、処理をステップＳＡ－６に移行させる。 Then, when the inventory update unit 102f determines that the product is in stock (step SA-8: Yes), the process shifts to step SA-6.

一方、在庫更新部１０２ｆは、商品の在庫が存在しないと判定した場合（ステップＳＡ－８：Ｎｏ）、処理を終了する。 On the other hand, when the inventory update unit 102f determines that the product is out of stock (step SA-8: No), the process ends.

ここで、図３から図１３を参照して、本実施形態に係る振替処理の具体例について説明する。 Here, a specific example of the transfer process according to the present embodiment will be described with reference to FIGS. 3 to 13.

まず、図３および図４を参照して、本実施形態に係る品番紐付けの一例について説明する。図３は、本実施形態における商品品番（商品コード）と製品品番（製品コード）との対応関係の一例を示す図である。図４は、本実施形態における品番マスタ１０６ａの一例を示す図である。 First, an example of product number association according to the present embodiment will be described with reference to FIGS. 3 and 4. FIG. 3 is a diagram showing an example of a correspondence relationship between a product product number (product code) and a product product number (product code) in the present embodiment. FIG. 4 is a diagram showing an example of the product number master 106a in the present embodiment.

図３に示すように、本実施形態においては、販売時には同じ商品となる、実質的に同じ製品が製造される場合であっても、原料（部品）となる部材、および／または、製造方法等が異なる場合があるため、工場では、部材および／または製造方法等が異なる製品を別々の品番（製品コード）で管理している。すなわち、図３に示すように、本実施形態において、商品Ａ（商品コードも商品Ａ）に対応する製品としては、自社工場にて内作される内製の部材１と内製の部材２とから構成される製品Ｂ（製品コードも製品Ｂ）、および、外注先の工場にて外作される自社から提供する部材１と外注先が自社以外から調達する部材２とから構成される製品Ｃ（製品コードも製品Ｃ）であってもよい。なお、本実施形態において、製品Ｂと製品Ｃとは、原価が異なる場合がある。 As shown in FIG. 3, in the present embodiment, members that are raw materials (parts) and / or manufacturing methods, etc., even when substantially the same products are manufactured, which are the same products at the time of sale. In the factory, products with different parts and / or manufacturing methods are managed by different product numbers (product codes). That is, as shown in FIG. 3, in the present embodiment, the products corresponding to the product A (the product code is also the product A) include the in-house manufactured member 1 and the in-house manufactured member 2 manufactured in-house at the company's own factory. Product B (product code is also product B), and product C consisting of parts 1 provided by the company that are outsourced at the subcontractor's factory and parts 2 that the subcontractor procures from other than the company. (The product code may also be product C). In this embodiment, the cost of the product B and the product C may be different.

ここで、図４に示すように、図３に示す対応関係において、品番マスタ１０６ａは、商品Ａの品番マスタに、製品Ｂと振替先品番（商品Ａ）とを対応付けた品番マスタ、および、製品Ｃと振替先品番（商品Ａ）とを対応付けた品番マスタを紐付けていてもよい。これにより、本実施形態においては、工場にて製品Ｂまたは製品Ｃのどちらで製造実績が登録された場合でも、商品Ａへの振替受払を自動で発生させることができる。 Here, as shown in FIG. 4, in the correspondence relationship shown in FIG. 3, the product number master 106a is a product number master in which the product B and the transfer destination product number (product A) are associated with the product number master of the product A, and the product number master. A product number master in which the product C and the transfer destination product number (product A) are associated with each other may be associated. Thereby, in the present embodiment, the transfer receipt / payment to the product A can be automatically generated regardless of whether the manufacturing record is registered in the product B or the product C at the factory.

そして、図５を参照して、本実施形態における振替処理の一例について説明する。図５は、本実施形態における振替処理の一例を示すフロー図である。 Then, an example of the transfer process in the present embodiment will be described with reference to FIG. FIG. 5 is a flow chart showing an example of the transfer process in the present embodiment.

図５に示すように、本実施形態においては、工場にて製品Ｂの製造が完了し、工場にて製品Ｂの製造実績が製造実績テーブル１０６ｂおよび原価内訳テーブル１０６ｃに入力（登録）された場合、品番マスタ１０６ａに基づいて、製品Ｂの製造数から商品Ａの在庫数への製品振替数を製品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録し、当該在庫数に相当する商品振替数を商品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録することで、当該商品振替数を当該在庫数として在庫テーブル１０６ｅに登録し、且つ、品番マスタ１０６ａに基づいて、製品Ｂの原価単価および原価金額を商品Ａの在庫単価および在庫金額に振り替えて在庫テーブル１０６ｅに登録し、製品Ｂの原価単価を商品Ａの在庫単価に振り替えて在庫テーブル１０６ｅに登録する（ステップＳＢ－１）。 As shown in FIG. 5, in the present embodiment, when the production of the product B is completed at the factory and the production results of the product B are input (registered) in the production results table 106b and the cost breakdown table 106c at the factory. , Based on the product number master 106a, the number of product transfers from the number of manufactured products B to the number of stocks of product A is registered in the transfer record table 106d in association with the product number and registration date, and the product transfer corresponding to the number of stocks is made. By registering the number in the transfer record table 106d in association with the product product number and registration date, the product transfer number is registered in the inventory table 106e as the stock quantity, and the cost of the product B is based on the product number master 106a. The unit price and the cost amount are transferred to the inventory unit price and the inventory amount of the product A and registered in the inventory table 106e, and the cost unit price of the product B is transferred to the inventory unit price of the product A and registered in the inventory table 106e (step SB-1).

ここで、図６から図８を参照して、本実施形態における製品Ｂの製造実績登録の一例について説明する。図６は、本実施形態における製造実績テーブル１０６ｂおよび原価内訳テーブル１０６ｃの一例を示す図である。図７は、本実施形態における振替実績テーブル１０６ｄの一例を示す図である。図８は、本実施形態における在庫テーブル１０６ｅの一例を示す図である。 Here, an example of the manufacturing record registration of the product B in the present embodiment will be described with reference to FIGS. 6 to 8. FIG. 6 is a diagram showing an example of the manufacturing record table 106b and the cost breakdown table 106c in the present embodiment. FIG. 7 is a diagram showing an example of the transfer record table 106d in the present embodiment. FIG. 8 is a diagram showing an example of the inventory table 106e in the present embodiment.

まず、図６に示すように、本実施形態においては、工場にて製品Ｂの品番、実績日付、製造数、原価単価および原価金額が製造実績テーブル１０６ｂに登録され、製品Ｂの原価要素（部材１、部材２、労務費および経費）、原価要素の投入日付、原価要素の使用数、原価要素の原価単価および原価要素の原価金額（原価内訳金額）が原価内訳テーブル１０６ｃに登録される。ここで、原価単価は、製品品番等に基づいて、自動的に入力されてもよく、原価金額および／または原価内訳金額は、製造数等に基づいて、自動的に算出されてもよい。そして、図７に示すように、本実施形態においては、品番マスタ１０６ａに基づいて、製品Ｂの製造数から商品Ａの在庫数への振替数（製品振替数）が品番（製品品番）および実績日付（登録日付）と対応付けて振替実績テーブル１０６ｄに登録され、商品Ａの在庫数に相当する振替数（商品振替数）が品番（商品品番）および実績日付（登録日付）と対応付けて振替実績テーブル１０６ｄに登録される。更に、図８に示すように、本実施形態においては、振替実績テーブル１０６ｄに記憶された商品振替数が商品Ａの在庫数として在庫テーブル１０６ｅに登録され、且つ、品番マスタ１０６ａに基づいて、製品Ｂの原価金額が商品Ａの在庫金額に振り替えて在庫テーブル１０６ｅに登録され、製品Ｂの原価単価が商品Ａの在庫単価に振り替えて在庫テーブル１０６ｅに登録される。 First, as shown in FIG. 6, in the present embodiment, the product number, actual date, manufacturing quantity, cost unit price and cost amount of product B are registered in the production actual table 106b at the factory, and the cost elements (members) of product B are registered. 1. Material 2, labor cost and expense), input date of cost element, number of used cost element, cost unit price of cost element and cost amount (cost breakdown amount) of cost element are registered in cost breakdown table 106c. Here, the cost unit price may be automatically input based on the product part number or the like, and the cost amount and / or the cost breakdown amount may be automatically calculated based on the number of manufactured products or the like. Then, as shown in FIG. 7, in the present embodiment, the number of transfers (number of product transfers) from the number of manufactured products B to the number of stocks of product A is the product number (product number) and the actual results based on the product number master 106a. Transfers are registered in the transfer record table 106d in association with the date (registration date), and the number of transfers (product transfer number) corresponding to the stock quantity of product A is associated with the product number (product product number) and the actual date (registration date). It is registered in the achievement table 106d. Further, as shown in FIG. 8, in the present embodiment, the product transfer number stored in the transfer record table 106d is registered in the inventory table 106e as the inventory number of the product A, and the product is based on the product number master 106a. The cost amount of B is transferred to the inventory amount of product A and registered in the inventory table 106e, and the cost unit price of product B is transferred to the inventory unit price of product A and registered in the inventory table 106e.

図５に戻り、本実施形態においては、工場にて製品Ｃの製造が完了し、工場にて製品Ｃの製造実績が製造実績テーブル１０６ｂおよび原価内訳テーブル１０６ｃに入力（登録）された場合、品番マスタ１０６ａに基づいて、製品Ｃの製造数から商品Ａの在庫数への製品振替数を製品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録し、当該在庫数に相当する商品振替数を商品品番および登録日付と対応付けて振替実績テーブル１０６ｄに登録することで、当該商品振替数を当該在庫数として在庫テーブル１０６ｅに登録し、且つ、品番マスタ１０６ａに基づいて、製品Ｃの原価金額を商品Ａの在庫金額に振り替えて在庫テーブル１０６ｅに登録し、在庫テーブル１０６ｅに記憶された商品Ａの在庫数および在庫金額に基づいて、端数処理を適宜適用して在庫単価を算出し、在庫テーブル１０６ｅに登録し、端数処理を適用した場合、当該在庫単価に基づいて、在庫テーブル１０６ｅに記憶された在庫価格を更新する（ステップＳＢ－２）。 Returning to FIG. 5, in the present embodiment, when the production of the product C is completed at the factory and the production record of the product C is input (registered) in the production record table 106b and the cost breakdown table 106c at the factory, the product number Based on the master 106a, the number of product transfers from the number of manufactured products C to the number of stocks of product A is registered in the transfer record table 106d in association with the product product number and registration date, and the number of product transfers corresponding to the number of stocks is registered. By registering the product transfer number in the transfer record table 106d in association with the product product number and registration date, the product transfer number is registered in the inventory table 106e as the stock quantity, and the cost amount of the product C is set based on the product number master 106a. It is transferred to the inventory value of the product A and registered in the inventory table 106e, and based on the inventory quantity and the inventory value of the product A stored in the inventory table 106e, the fraction processing is appropriately applied to calculate the inventory unit price, and the inventory table 106e When the fraction processing is applied, the stock price stored in the stock table 106e is updated based on the stock unit price (step SB-2).

ここで、図９から図１１を参照して、本実施形態における製品Ｃの製造実績登録の一例について説明する。図９は、本実施形態における製造実績テーブル１０６ｂおよび原価内訳テーブル１０６ｃの一例を示す図である。図１０は、本実施形態における振替実績テーブル１０６ｄの一例を示す図である。図１１は、本実施形態における在庫テーブル１０６ｅの一例を示す図である。 Here, an example of the manufacturing record registration of the product C in the present embodiment will be described with reference to FIGS. 9 to 11. FIG. 9 is a diagram showing an example of the manufacturing record table 106b and the cost breakdown table 106c in the present embodiment. FIG. 10 is a diagram showing an example of the transfer record table 106d in the present embodiment. FIG. 11 is a diagram showing an example of the inventory table 106e in the present embodiment.

まず、図９に示すように、本実施形態においては、工場にて製品Ｃの品番、実績日付、製造数、原価単価および原価金額が製造実績テーブル１０６ｂに登録され、製品Ｃの原価要素（部材１および外注費）、原価要素の投入日付、原価要素の使用数、原価要素の原価単価および原価要素の原価金額（原価内訳金額）が原価内訳テーブル１０６ｃに登録される。そして、図１０に示すように、本実施形態においては、品番マスタ１０６ａに基づいて、製品Ｃの製造数から商品Ａの在庫数への振替数（製品振替数）が品番（製品品番）および実績日付（登録日付）と対応付けて振替実績テーブル１０６ｄに登録され、商品Ａの在庫数に相当する振替数（商品振替数）が品番（商品品番）および実績日付（登録日付）と対応付けて振替実績テーブル１０６ｄに登録される。更に、図１１に示すように、本実施形態においては、振替実績テーブル１０６ｄに記憶された商品振替数が商品Ａの在庫数として在庫テーブル１０６ｅに登録され、且つ、品番マスタ１０６ａに基づいて、製品Ｂの原価金額が商品Ａの在庫金額に振り替えて在庫テーブル１０６ｅに登録され、在庫テーブル１０６ｅに記憶された商品Ａの在庫数および在庫金額に基づいて、端数処理を適用して在庫単価が算出され、在庫テーブル１０６ｅに登録し、当該在庫単価に基づいて、在庫テーブル１０６ｅに記憶された在庫価格が更新される。 First, as shown in FIG. 9, in the present embodiment, the product number, the actual date, the number of manufactured products, the cost unit price, and the cost amount are registered in the manufacturing record table 106b at the factory, and the cost elements (members) of the product C are registered. 1 and the outsourcing cost), the input date of the cost element, the number of times the cost element is used, the cost unit price of the cost element, and the cost amount (cost breakdown amount) of the cost element are registered in the cost breakdown table 106c. Then, as shown in FIG. 10, in the present embodiment, the number of transfers (number of product transfers) from the number of manufactured products C to the number of stocks of product A is the product number (product number) and the actual results based on the product number master 106a. It is registered in the transfer record table 106d in association with the date (registration date), and the number of transfers (product transfer number) corresponding to the stock quantity of product A is associated with the product number (product product number) and the actual date (registration date). It is registered in the achievement table 106d. Further, as shown in FIG. 11, in the present embodiment, the product transfer number stored in the transfer record table 106d is registered in the inventory table 106e as the inventory quantity of the product A, and the product is based on the product number master 106a. The cost amount of B is transferred to the inventory amount of product A and registered in the inventory table 106e, and the inventory unit price is calculated by applying fraction processing based on the inventory quantity and inventory amount of product A stored in the inventory table 106e. , The inventory price stored in the inventory table 106e is updated based on the inventory unit price registered in the inventory table 106e.

図５に戻り、本実施形態においては、営業部門により商品Ａの販売が行われ、営業部門により商品Ａの売上実績が売上実績テーブル１０６ｆに入力（登録）された場合、売上実績テーブル１０６ｆに記憶された商品Ａの売上実績に基づいて、在庫テーブル１０６ｅに記憶された商品Ａの在庫数および在庫金額を更新し（ステップＳＢ－３）、処理を終了する。 Returning to FIG. 5, in the present embodiment, when the sales department sells the product A and the sales department inputs (registers) the sales record of the product A into the sales record table 106f, it is stored in the sales record table 106f. Based on the sales result of the product A, the inventory quantity and the inventory value of the product A stored in the inventory table 106e are updated (step SB-3), and the process is terminated.

ここで、図１２および図１３を参照して、本実施形態における売上実績登録の一例について説明する。図１２は、本実施形態における売上実績テーブル１０６ｆの一例を示す図である。図１３は、本実施形態における在庫テーブル１０６ｅの一例を示す図である。 Here, an example of sales record registration in the present embodiment will be described with reference to FIGS. 12 and 13. FIG. 12 is a diagram showing an example of the sales record table 106f in the present embodiment. FIG. 13 is a diagram showing an example of the inventory table 106e in the present embodiment.

図１２に示すように、本実施形態においては、営業部門により商品Ａの品番（商品品番）、売上日付、売上数、売上単価、売上金額、在庫単価、在庫金額および粗利金額が売上実績テーブル１０６ｆに登録される。ここで、売上単価および／または在庫単価は、商品品番等に基づいて、自動的に入力されてもよく、売上金額、在庫金額および／または粗利は、売上数等に基づいて、自動的に算出されてもよい。そして、図１３に示すように、本実施形態においては、売上実績テーブル１０６ｆに記憶された商品Ａの売上数および在庫金額に基づいて、在庫テーブル１０６ｅに記憶された商品Ａの在庫数および在庫金額を更新する。 As shown in FIG. 12, in the present embodiment, the product number (product product number), sales date, number of sales, sales unit price, sales amount, inventory unit price, inventory amount, and gross profit amount of the product A are the sales performance table depending on the sales department. It is registered in 106f. Here, the sales unit price and / or the inventory unit price may be automatically input based on the product part number or the like, and the sales amount, the inventory amount and / or the gross profit may be automatically entered based on the number of sales or the like. It may be calculated. Then, as shown in FIG. 13, in the present embodiment, the inventory quantity and the inventory value of the product A stored in the inventory table 106e are based on the sales quantity and the inventory value of the product A stored in the sales record table 106f. To update.

［４．他の実施形態］
本発明は、上述した実施形態以外にも、特許請求の範囲に記載した技術的思想の範囲内において種々の異なる実施形態にて実施されてよいものである。 [4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

例えば、実施形態において説明した各処理のうち、自動的に行われるものとして説明した処理の全部または一部を手動的に行うこともでき、あるいは、手動的に行われるものとして説明した処理の全部または一部を公知の方法で自動的に行うこともできる。 For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all of the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

また、本明細書中や図面中で示した処理手順、制御手順、具体的名称、各処理の登録データや検索条件等のパラメータを含む情報、画面例、データベース構成については、特記する場合を除いて任意に変更することができる。 In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

また、振替装置１００に関して、図示の各構成要素は機能概念的なものであり、必ずしも物理的に図示の如く構成されていることを要しない。 Further, with respect to the transfer device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

例えば、振替装置１００が備える処理機能、特に制御部１０２にて行われる各処理機能については、その全部または任意の一部を、ＣＰＵおよび当該ＣＰＵにて解釈実行されるプログラムにて実現してもよく、また、ワイヤードロジックによるハードウェアとして実現してもよい。尚、プログラムは、本実施形態で説明した処理を情報処理装置に実行させるためのプログラム化された命令を含む一時的でないコンピュータ読み取り可能な記録媒体に記録されており、必要に応じて振替装置１００に機械的に読み取られる。すなわち、ＲＯＭまたはＨＤＤ（Ｈａｒｄ Ｄｉｓｋ Ｄｒｉｖｅ）などの記憶部などには、ＯＳと協働してＣＰＵに命令を与え、各種処理を行うためのコンピュータプログラムが記録されている。このコンピュータプログラムは、ＲＡＭにロードされることによって実行され、ＣＰＵと協働して制御部を構成する。 For example, with respect to the processing functions included in the transfer device 100, particularly each processing function performed by the control unit 102, even if all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. Well, it may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the transfer apparatus 100 is required. Is read mechanically. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form a control unit.

また、このコンピュータプログラムは、振替装置１００に対して任意のネットワークを介して接続されたアプリケーションプログラムサーバに記憶されていてもよく、必要に応じてその全部または一部をダウンロードすることも可能である。 Further, this computer program may be stored in an application program server connected to the transfer device 100 via an arbitrary network, and all or part of the computer program may be downloaded as needed. ..

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、ＵＳＢ（Ｕｎｉｖｅｒｓａｌ Ｓｅｒｉａｌ Ｂｕｓ）メモリ、ＳＤ（Ｓｅｃｕｒｅ Ｄｉｇｉｔａｌ）カード、フレキシブルディスク、光磁気ディスク、ＲＯＭ、ＥＰＲＯＭ（Ｅｒａｓａｂｌｅ Ｐｒｏｇｒａｍｍａｂｌｅ Ｒｅａｄ Ｏｎｌｙ Ｍｅｍｏｒｙ）、ＥＥＰＲＯＭ（登録商標）（Ｅｌｅｃｔｒｉｃａｌｌｙ Ｅｒａｓａｂｌｅ ａｎｄ Ｐｒｏｇｒａｍｍａｂｌｅ Ｒｅａｄ Ｏｎｌｙ Ｍｅｍｏｒｙ）、ＣＤ－ＲＯＭ（Ｃｏｍｐａｃｔ Ｄｉｓｋ Ｒｅａｄ Ｏｎｌｙ Ｍｅｍｏｒｙ）、ＭＯ（Ｍａｇｎｅｔｏ－Ｏｐｔｉｃａｌ ｄｉｓｋ）、ＤＶＤ（Ｄｉｇｉｔａｌ Ｖｅｒｓａｔｉｌｅ Ｄｉｓｋ）、および、Ｂｌｕ－ｒａｙ（登録商標） Ｄｉｓｃ等の任意の「可搬用の物理媒体」を含むものとする。 Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Program Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Protocol Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

また、「プログラム」とは、任意の言語または記述方法にて記述されたデータ処理方法であり、ソースコードまたはバイナリコード等の形式を問わない。なお、「プログラム」は必ずしも単一的に構成されるものに限られず、複数のモジュールやライブラリとして分散構成されるものや、ＯＳに代表される別個のプログラムと協働してその機能を達成するものをも含む。なお、本実施形態に示した各装置において記録媒体を読み取るための具体的な構成および読み取り手順ならびに読み取り後のインストール手順等については、周知の構成や手順を用いることができる。 Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium and the installation procedure after reading in each device shown in the present embodiment.

記憶部１０６に格納される各種のデータベース等は、ＲＡＭ、ＲＯＭ等のメモリ装置、ハードディスク等の固定ディスク装置、フレキシブルディスク、および、光ディスク等のストレージ手段であり、各種処理やウェブサイト提供に用いる各種のプログラム、テーブル、データベース、および、ウェブページ用ファイル等を格納する。 Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

また、振替装置１００は、既知のパーソナルコンピュータまたはワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、振替装置１００は、当該装置に本実施形態で説明した処理を実現させるソフトウェア（プログラムまたはデータ等を含む）を実装することにより実現してもよい。 Further, the transfer device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the transfer device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

更に、装置の分散・統合の具体的形態は図示するものに限られず、その全部または一部を、各種の付加等に応じてまたは機能負荷に応じて、任意の単位で機能的または物理的に分散・統合して構成することができる。すなわち、上述した実施形態を任意に組み合わせて実施してもよく、実施形態を選択的に実施してもよい。 Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

本発明は、業界を問わず、営業部門と製造部門とで商品の管理体系が異なる製造業等の業界において有用である。 The present invention is useful in industries such as the manufacturing industry, in which the product management system differs between the sales department and the manufacturing department, regardless of the industry.

１００ 振替装置
１０２ 制御部
１０２ａ 製造実績登録部
１０２ｂ 数量振替部
１０２ｃ 金額振替部
１０２ｄ 在庫単価算出部
１０２ｅ 売上実績登録部
１０２ｆ 在庫更新部
１０４ 通信インターフェース部
１０６ 記憶部
１０６ａ 品番マスタ
１０６ｂ 製造実績テーブル
１０６ｃ 原価内訳テーブル
１０６ｄ 振替実績テーブル
１０６ｅ 在庫テーブル
１０６ｆ 売上実績テーブル
１０８ 入出力インターフェース部
１１２ 入力装置
１１４ 出力装置
２００ サーバ
３００ ネットワーク 100 Transfer device 102 Control unit 102a Manufacturing record registration unit 102b Quantity transfer unit 102c Amount transfer unit 102d Inventory unit price calculation unit 102e Sales record registration unit 102f Inventory update unit 104 Communication interface unit 106 Storage unit 106a Product number master 106b Manufacturing record table 106c Cost breakdown Table 106d Transfer record table 106e Inventory table 106f Sales record table 108 I / O interface section 112 Input device 114 Output device 200 Server 300 Network

Claims (8)

記憶部と制御部とを備えた振替装置であって、
前記記憶部は、
製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、
前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、
前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、
を備え、
前記制御部は、
前記製品の製造数を、当該製品の製品品番、登録日付、および、原価金額に対応付けて前記製造実績記憶手段に登録する製造実績登録手段と、
前記製品の前記製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替手段と、
前記製品の前記原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替手段と、
を備えたことを特徴とする振替装置。 It is a transfer device equipped with a storage unit and a control unit.
The storage unit is
A product number storage means for storing a product number master that links the product product number of a product managed by the manufacturing department and the product product number of the product corresponding to the product managed by the sales department.
A manufacturing record storage means for storing the product part number, the number of manufactured products, and the cost amount of the product.
An inventory storage means for storing the product part number, the inventory quantity of the product, and the inventory value of the product,
Equipped with
The control unit
A manufacturing record registration means for registering the number of manufactured products in the manufacturing record storage means in association with the product part number, registration date, and cost amount of the product.
When the manufactured quantity of the product is registered in the manufacturing record storage means, the quantity to be registered in the inventory storage means by transferring the manufactured quantity to the inventory quantity of the product corresponding to the product based on the part number master. Transfer means and
When the cost amount of the product is registered in the manufacturing record storage means, the amount of the cost amount is transferred to the inventory amount of the product corresponding to the product and registered in the inventory storage means based on the product number master. Transfer means and
A transfer device characterized by being equipped with. 前記記憶部は、
前記製品品番および前記製品の製品振替数、または、前記商品品番および前記商品の商品振替数と、前記登録日付と、を対応付けて記憶する振替実績記憶手段、
を更に備え、
前記数量振替手段は、
前記製品の製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数から当該製品に相当する前記商品の在庫数への前記製品振替数を前記製品品番および前記登録日付と対応付けて前記振替実績記憶手段に登録し、当該在庫数に相当する前記商品振替数を前記商品品番および前記登録日付と対応付けて前記振替実績記憶手段に登録することで、当該商品振替数を当該在庫数として前記在庫記憶手段に登録することを特徴とする請求項１に記載の振替装置。 The storage unit is
A transfer record storage means for storing the product product number and the product transfer number of the product, or the product product number and the product transfer number of the product and the registration date in association with each other.
Further prepare
The quantity transfer means is
When the number of manufactured products is registered in the manufacturing record storage means, the number of products transferred from the number of manufactured products to the number of stocks of the product corresponding to the product is calculated by the product number and the product number master. By registering the product in the transfer record storage means in association with the registration date and registering the product transfer number corresponding to the stock quantity in the transfer record storage means in association with the product product number and the registration date, the product is registered. The transfer device according to claim 1, wherein the number of transfers is registered as the number of stocks in the stock storage means. 前記制御部は、
前記商品の売上数量に基づいて、前記在庫記憶手段に記憶された前記商品の前記在庫数および前記在庫金額を更新する在庫更新手段と、
を更に備えたことを特徴とする請求項１または２に記載の振替装置。 The control unit
An inventory update means for updating the inventory quantity and the inventory value of the product stored in the inventory storage means based on the sales quantity of the product.
The transfer device according to claim 1 or 2, further comprising. 前記記憶部は、
前記商品の前記商品品番、当該商品の売上日付、前記売上数量、当該商品の売上金額、当該売上数量に対応する在庫金額、および、当該商品の粗利金額を記憶する売上実績記憶手段、
を更に備え、
前記制御部は、
前記品番マスタに基づいて、前記商品の前記売上数量を、当該商品の前記商品品番、当該商品の売上日付、当該商品の売上金額、当該売上数量に対応する在庫金額、および、当該商品の粗利金額に対応付けて前記売上実績記憶手段に登録する売上実績登録手段、
を更に備え、
前記在庫更新手段は、
前記商品の前記売上数量、および、前記売上数量に対応する在庫金額に基づいて、前記在庫記憶手段に記憶された当該商品の前記在庫数および前記在庫金額を更新することを特徴とする請求項３に記載の振替装置。 The storage unit is
A sales record storage means for storing the product number , the sales date of the product, the sales quantity, the sales amount of the product, the inventory amount corresponding to the sales quantity, and the gross profit amount of the product.
Further prepare
The control unit
Based on the product number master, the sales quantity of the product is the product product number of the product, the sales date of the product, the sales amount of the product, the inventory amount corresponding to the sales quantity, and the gross profit of the product. Sales record registration means, which is registered in the sales record storage means in association with the amount of money.
Further prepare
The inventory update means is
3. The third aspect of the present invention is to update the inventory quantity and the inventory value of the product stored in the inventory storage means based on the sales quantity of the product and the inventory amount corresponding to the sales quantity. The transfer device described in. 前記制御部は、
前記在庫記憶手段に記憶された前記在庫数および前記在庫金額に基づいて、在庫単価を算出し、前記在庫記憶手段に登録する在庫単価算出手段、
を更に備えたことを特徴とする請求項１から４のいずれか一つに記載の振替装置。 The control unit
An inventory unit price calculation means that calculates an inventory unit price based on the inventory quantity and the inventory amount stored in the inventory storage means and registers the inventory unit price in the inventory storage means.
The transfer device according to any one of claims 1 to 4, further comprising. 前記製造実績記憶手段は、
前記製品に含まれる原価要素に対応する前記原価金額の内訳である原価内訳金額を記憶する原価内訳記憶手段、
を備えたことを特徴とする請求項１から５のいずれか一つに記載の振替装置。 The manufacturing record storage means is
A cost breakdown storage means for storing a cost breakdown amount, which is a breakdown of the cost amount corresponding to the cost element included in the product.
The transfer device according to any one of claims 1 to 5 , wherein the transfer device is provided. 記憶部と制御部とを備えた振替装置に実行させるための振替方法であって、
前記記憶部は、
製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、
前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、
前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、
を備え、
前記制御部で実行させる、
前記製品の製造数を、当該製品の製品品番、登録日付、および、原価金額に対応付けて前記製造実績記憶手段に登録する製造実績登録ステップと、
前記製品の前記製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替ステップと、
前記製品の前記原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替ステップと、
を含むことを特徴とする振替方法。 It is a transfer method for causing a transfer device having a storage unit and a control unit to execute the transfer.
The storage unit is
A product number storage means for storing a product number master that links the product product number of a product managed by the manufacturing department and the product product number of the product corresponding to the product managed by the sales department.
A manufacturing record storage means for storing the product part number, the number of manufactured products, and the cost amount of the product.
An inventory storage means for storing the product part number, the inventory quantity of the product, and the inventory value of the product,
Equipped with
It is executed by the control unit.
A manufacturing record registration step for registering the number of manufactured products in the manufacturing record storage means in association with the product part number, registration date, and cost amount of the product.
When the manufactured quantity of the product is registered in the manufacturing record storage means, the quantity to be registered in the inventory storage means by transferring the manufactured quantity to the inventory quantity of the product corresponding to the product based on the part number master. Transfer step and
When the cost amount of the product is registered in the manufacturing record storage means, the amount of the cost amount is transferred to the inventory amount of the product corresponding to the product and registered in the inventory storage means based on the product number master. Transfer step and
A transfer method characterized by including. 記憶部と制御部とを備えた振替装置に実行させるための振替プログラムであって、
前記記憶部は、
製造部門が管理する製品の製品品番と販売部門が管理する当該製品に相当する商品の商品品番とを紐付けた品番マスタを記憶する品番記憶手段と、
前記製品品番、前記製品の製造数、および、前記製品の原価金額を記憶する製造実績記憶手段と、
前記商品品番、前記商品の在庫数、および、前記商品の在庫金額を記憶する在庫記憶手段と、
を備え、
前記制御部において、
前記製品の製造数を、当該製品の製品品番、登録日付、および、原価金額に対応付けて前記製造実績記憶手段に登録する製造実績登録ステップと、
前記製品の前記製造数が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該製造数を当該製品に相当する前記商品の在庫数に振り替えて前記在庫記憶手段に登録する数量振替ステップと、
前記製品の前記原価金額が前記製造実績記憶手段に登録された場合、前記品番マスタに基づいて、当該原価金額を当該製品に相当する前記商品の在庫金額に振り替えて前記在庫記憶手段に登録する金額振替ステップと、
を実行させるための振替プログラム。 It is a transfer program to be executed by a transfer device equipped with a storage unit and a control unit.
The storage unit is
A product number storage means for storing a product number master that links the product product number of a product managed by the manufacturing department and the product product number of the product corresponding to the product managed by the sales department.
A manufacturing record storage means for storing the product part number, the number of manufactured products, and the cost amount of the product.
An inventory storage means for storing the product part number, the inventory quantity of the product, and the inventory value of the product,
Equipped with
In the control unit
A manufacturing record registration step for registering the number of manufactured products in the manufacturing record storage means in association with the product part number, registration date, and cost amount of the product.
When the manufactured quantity of the product is registered in the manufacturing record storage means, the quantity to be registered in the inventory storage means by transferring the manufactured quantity to the inventory quantity of the product corresponding to the product based on the part number master. Transfer step and
When the cost amount of the product is registered in the manufacturing record storage means, the amount of the cost amount is transferred to the inventory amount of the product corresponding to the product and registered in the inventory storage means based on the product number master. Transfer step and
A transfer program to execute.
JP2017134181A 2017-07-07 2017-07-07 Transfer device, transfer method, and transfer program Active JP7045812B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2017134181A JP7045812B2 (en) 2017-07-07 2017-07-07 Transfer device, transfer method, and transfer program

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2017134181A JP7045812B2 (en) 2017-07-07 2017-07-07 Transfer device, transfer method, and transfer program

Publications (2)

Publication Number Publication Date
JP2019016242A JP2019016242A (en) 2019-01-31
JP7045812B2 true JP7045812B2 (en) 2022-04-01

Family

ID=65359325

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2017134181A Active JP7045812B2 (en) 2017-07-07 2017-07-07 Transfer device, transfer method, and transfer program

Country Status (1)

Country Link
JP (1) JP7045812B2 (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7198706B2 (en) * 2019-03-29 2023-01-04 株式会社オービック INVENTORY INQUIRY DEVICE, INVENTORY INQUIRY METHOD, AND INVENTORY INQUIRY PROGRAM

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001318953A (en) 2000-03-03 2001-11-16 Ns Solutions Corp Cost data management system, cost data managing method and its recording medium
JP2001325329A (en) 2000-05-17 2001-11-22 Corona Corp Cost estimating device
JP2016126393A (en) 2014-12-26 2016-07-11 株式会社タツノ Oil supply place management system
JP2017072870A (en) 2015-10-05 2017-04-13 三菱電機インフォメーションシステムズ株式会社 Profit and loss forecasting device and profit and loss forecasting program

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH064558A (en) * 1992-06-24 1994-01-14 Hokuriku Nippon Denki Software Kk Cost controller

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2001318953A (en) 2000-03-03 2001-11-16 Ns Solutions Corp Cost data management system, cost data managing method and its recording medium
JP2001325329A (en) 2000-05-17 2001-11-22 Corona Corp Cost estimating device
JP2016126393A (en) 2014-12-26 2016-07-11 株式会社タツノ Oil supply place management system
JP2017072870A (en) 2015-10-05 2017-04-13 三菱電機インフォメーションシステムズ株式会社 Profit and loss forecasting device and profit and loss forecasting program

Also Published As

Publication number Publication date
JP2019016242A (en) 2019-01-31

Similar Documents

Publication Publication Date Title
JP7020898B2 (en) Channel-based revenue management device, channel-based revenue management method, and channel-based revenue management program
JP7048299B2 (en) Order registration device, order registration method, and order registration program
JP7046153B2 (en) Work completion control device, work completion control method, and work completion control program
JP7045812B2 (en) Transfer device, transfer method, and transfer program
JP7197989B2 (en) Progress rate calculation device, progress rate calculation method, and progress rate calculation program
JP2020004213A (en) Sales transfer classification apparatus, sales transfer classification method and sales transfer classification program
JP7073066B2 (en) Arrangement process management device, arrangement process management method, and arrangement process management program
JP6887264B2 (en) Inventory management device, inventory management method and inventory management program
JP6997513B2 (en) Numbering control device, numbering control method and numbering control program
JP7502206B2 (en) Consigned item management device, consigned item management method, and consigned item management program
JP7104817B2 (en) Voucher registration control device, voucher registration control method, and voucher registration control program
JP7335220B2 (en) Purchase order issuance management device, purchase order issuance management method, and purchase order issuance management program
JP2020030537A (en) Data generation device and data generation method and data generation program
JP7303089B2 (en) Order schedule data creation device, order schedule data creation method, and order schedule data creation program
JP7481193B2 (en) Procurement management device, procurement management method, and procurement management program
JP7235522B2 (en) Payment record issuing device, payment record issuing method, and payment record issuing program
JP7274380B2 (en) Commercial distribution management device, commercial distribution management method, and commercial distribution management program
JP7183034B2 (en) Unit price management device, unit price management method, and unit price management program
JP7042079B2 (en) Human Resources Contract Management Equipment, Human Resources Contract Management Method, and Human Resources Contract Management Program
JP7198706B2 (en) INVENTORY INQUIRY DEVICE, INVENTORY INQUIRY METHOD, AND INVENTORY INQUIRY PROGRAM
JP2022084427A (en) Inventory management device, inventory management method, and inventory management program
JP2023098347A (en) Order item configuration management device, order item configuration management method and configuration management program
JP2022082056A (en) Manufacturing instruction/repair instruction slip creation device, manufacturing instruction/repair instruction slip creation method, and manufacturing instruction/repair instruction slip creation program
JP2024022260A (en) Order plan formulating device, order plan formulating method and order plan formulating program
JP6850162B2 (en) Business data change check device, business data change check method, and business data change check program

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20200702

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20210721

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20210907

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20211022

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: 20220222

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20220322

R150 Certificate of patent or registration of utility model

Ref document number: 7045812

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150