TWI662487B - Enterprise resource management system - Google Patents

Enterprise resource management system Download PDF

Info

Publication number
TWI662487B
TWI662487B TW107114951A TW107114951A TWI662487B TW I662487 B TWI662487 B TW I662487B TW 107114951 A TW107114951 A TW 107114951A TW 107114951 A TW107114951 A TW 107114951A TW I662487 B TWI662487 B TW I662487B
Authority
TW
Taiwan
Prior art keywords
product
information
basic
production process
data table
Prior art date
Application number
TW107114951A
Other languages
Chinese (zh)
Other versions
TW201947467A (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 TW107114951A priority Critical patent/TWI662487B/en
Application granted granted Critical
Publication of TWI662487B publication Critical patent/TWI662487B/en
Publication of TW201947467A publication Critical patent/TW201947467A/en

Links

Landscapes

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

Abstract

企業資源管理系統,其包括有:一資料管理模組,其係具有至少一列表清單,該列表清單中具有至少一新增鍵,該新增鍵具有一下拉式選單,該下拉式選單中具有至少一產品,藉由選擇該產品後,開啟一產品基本資料表;以及一雲端資料庫,其係與該資料管理模組連線,該雲端資料庫中具有至少一對應該產品的結構基本資訊及一對應該產品的生產流程資訊,該結構基本資訊包括該產品的複數原物料資訊及該產品的複數配件資訊,藉由選擇該產品使該結構基本資訊及該生產流程資訊傳輸並顯示於該BOM基本資料表中,而達到自動生成結構基本資訊及對應該產品的生產流程資訊,提高工作效率。An enterprise resource management system, including: a data management module, which has at least one list, the list has at least one new key, the new key has a pull-down menu, and the drop-down menu has At least one product, after selecting the product, opening a product basic data table; and a cloud database, which is connected to the data management module, and the cloud database has at least one pair of product basic structural information And the corresponding production process information of the product, the basic information of the structure includes the original material information of the product and the multiple accessory information of the product. By selecting the product, the basic structural information and the production process information are transmitted and displayed in the The BOM basic data table can automatically generate basic structural information and production process information corresponding to the product, improving work efficiency.

Description

企業資源管理系統Enterprise Resource Management System

本發明係關於一種企業管理系統,尤指一種應用於印刷包裝產業的企業資源管理系統。The invention relates to an enterprise management system, in particular to an enterprise resource management system applied to the printing and packaging industry.

任何企業在產品生產之前,必須先規劃料件需求與計劃,除了提供生產部門進行採購料件的依據,同時也進行料件生產的排程規劃。Before any product is produced, any enterprise must first plan the requirements and plans for the parts. In addition to providing the basis for the procurement of parts and components by the production department, it also plans the scheduling of the parts and components.

產品的構成是由各種採購來的料件搭配,經由生產的過程產出半成品,再由各種半成品與所採購的料件搭配,進一步生產出半成品或成品。因此必須事先描述要製成某產品是由那些料件、多少數量組成,以及這些料件又個別是由那些料件所組成,如此層層建立料件的組成結構。這些資料的描述與設定,一般稱之為料件構成表(Bill ofMaterials, BOM)。料件構成表是料件需求計劃的基礎,產品訂單透過料件構成表展開成各料件的需求之後,方能決定料件的採購以及生產的排程。The composition of the product is matched with various purchased materials and parts, and semi-finished products are produced through the production process, and then various semi-finished products are matched with the purchased materials to further produce semi-finished products or finished products. Therefore, it must be described in advance which materials and quantities are to be made into a product, and these materials are individually composed of those materials, so that the component structure of the materials is established layer by layer. The description and setting of these materials are generally called Bill of Materials (BOM). The material component composition table is the basis of the material component demand planning. After the product order is developed into the requirements of each material component through the material component composition table, the procurement of the material components and the production schedule can be determined.

習知的料件構成表及其建檔方法具有下列的缺點:1.在習知的料件構成表及其建檔方法中,必須將生產每一種料件所有使用到的各層級子料件一一建檔,使得使用者建檔時的負荷相當重。特別是在變更設計、更改料件構成表或是料件設計、特性、品質等變動造成標準用量或耗損率等改變時,必須將整個料件構成表查出來一一修改,其修改的步驟不僅十分繁雜,並且非常容易出錯,往往造成工作人員相當大的困擾。2.在習知的料件構成表及其建檔方法中,必須將生產每一種料件所有使用到的各層級子料件進行多層級編碼,亦沒有區分哪些子料件是生產料件,哪些是採購料件。對於因某料件的設計、特性、品質等變更,造成生產母料件時該料件的標準用量或耗損率等資料需要改變時,企業內的物流管理皆必須針對每一子料件重新計算,其修改的步驟同樣地繁雜又容易出錯。The conventional material and component composition table and its filing method have the following disadvantages: 1. In the conventional material and component composition table and its filing method, it is necessary to produce all levels of sub-materials used in the production of each type of material. Creating files one by one makes the user's load very heavy when creating files. In particular, when changing the design, changing the composition table of materials, or changing the standard usage or depletion rate due to changes in materials design, characteristics, quality, etc., the entire material structure table must be identified and modified one by one. Very complicated and error-prone, which often causes considerable distress to staff. 2. In the conventional material component composition table and its filing method, multi-level coding must be performed on all levels of sub-materials used in the production of each type of material, and there is no distinction between which sub-materials are production materials. Which are purchased materials. For changes in the design, characteristics, quality, etc. of a certain material, which causes changes in the standard consumption or loss rate of the material when producing the master material, the logistics management within the enterprise must be recalculated for each sub-material , Its modification steps are equally complicated and error-prone.

有鑑於此,如何將上述缺失加以摒除,即為本案發明人所欲解決之技術困難點之所在;是而,本案發明人基於多年從事相關業界的經驗,經多年苦心孤詣潛心研究,試作改良,終於成功研發完成本案,並使本發明得以誕生,以增進功效者。In view of this, how to eliminate the above-mentioned shortcomings is the technical difficulty that the inventor intends to solve; however, based on years of experience in the related industry, the inventor of the present case has made painstaking efforts and researched for years to make improvements. Those who have successfully completed the case and made the present invention to improve the efficacy.

鑑於上述習知技術之缺點,因此本發明提供一種企業資源管理系統,其包括:一資料管理模組,其係具有至少一列表清單,該列表清單中具有至少一新增鍵,該新增鍵具有一下拉式選單,該下拉式選單中具有至少一產品,藉由選擇該產品後,開啟一產品基本資料表;以及一雲端資料庫,其係與該資料管理模組連線,該雲端資料庫中具有至少一對應該產品的結構基本資訊及一對應該產品的生產流程資訊,該結構基本資訊包括該產品的複數原物料資訊及該產品的複數配件資訊,藉由選擇該產品使該結構基本資訊及該生產流程資訊傳輸並顯示於該BOM基本資料表中,而達到自動生成結構基本資訊及對應該產品的生產流程資訊,提高工作效率。In view of the shortcomings of the above-mentioned conventional technologies, the present invention provides an enterprise resource management system, which includes: a data management module having at least one list, and the list has at least one new key, the new key There is a pull-down menu with at least one product in the drop-down menu. After selecting the product, a basic product data table is opened; and a cloud database that is connected to the data management module and the cloud data The library has at least one pair of basic information about the structure of the product and one pair of products' production process information. The basic information of the structure includes the raw material information of the product and the multiple accessory information of the product. The structure is selected by selecting the product. The basic information and the production process information are transmitted and displayed in the BOM basic data table, so that the structural basic information and the production process information corresponding to the product are automatically generated, which improves the work efficiency.

請參閱第一圖,本發明企業資源管理系統1,其包括有:一資料管理模組10及一雲端資料庫20。Referring to the first figure, the enterprise resource management system 1 of the present invention includes: a data management module 10 and a cloud database 20.

請參閱第二圖,資料管理模組10,其係具有至少一列表清單11,該列表清單11的欄目包括有序號、客戶、產品ID、產品名稱、產品類型、產品規格、產品單價、產品條碼、展開規格、成品重量、單位、裝箱單位、禁用及操作。Please refer to the second figure, the data management module 10, which has at least one list 11 whose columns include serial number, customer, product ID, product name, product type, product specification, product unit price, product barcode , Unfolding specifications, finished product weight, unit, packing unit, disable and operation.

請參閱第二圖至第四圖,該列表清單11中具有至少一新增鍵111,該新增鍵111具有一下拉式選單112,該下拉式選單112中具有至少一產品113,藉由選擇該產品113後,開啟一產品基本資料表12,該產品基本資料表12中具有一下一步鍵,該BOM基本資料表的欄目包括有產品規格、產品單價、產品條碼、展開規格、成品重量、誤差值、裝框數量、單位、裝箱單位、包裝說明、產品備註、外箱標籤條碼、保價規格及是否禁用,提供使用者操作輸入,並於輸入完成後點選下一步鍵。Please refer to the second to fourth figures. The list 11 has at least one new key 111, the new key 111 has a pull-down menu 112, and the drop-down menu 112 has at least one product 113. After the product 113, a product basic information table 12 is opened. The product basic information table 12 has a next button. The columns of the BOM basic information table include product specifications, product unit prices, product barcodes, expanded specifications, finished product weight, and errors Value, packing quantity, unit, packing unit, packing instructions, product remarks, outer box label barcode, insured specifications and whether to disable, provide user operation input, and click the next button after the input is completed.

使用者輸入完成產品基本資料表12,並點選下一步鍵後,生成一BOM基本資料表13,該BOM基本資料表13的欄目包括一與該產品113對應的配件欄131、一生產流程欄132及一參數欄133。After the user enters the product basic data table 12 and clicks the next button, a BOM basic data table 13 is generated. The columns of the BOM basic data table 13 include an accessory column 131 corresponding to the product 113 and a production process column. 132 and a parameter column 133.

請參閱第五圖,雲端資料庫20,其係與該資料管理模組10連線,該雲端資料庫20中具有至少一對應該產品113的結構基本資訊21及一對應該產品113的生產流程資訊22,該結構基本資訊21即俗稱的BOM表(物料清單表bill of materials,縮寫 BOM),包括該產品的複數原物料資訊及該產品的複數配件資訊;Please refer to the fifth figure. The cloud database 20 is connected to the data management module 10. The cloud database 20 has at least one pair of product basic information 21 and a production process of the corresponding product 113. Information 22, the basic information of the structure 21 is commonly known as the bill of materials (BOM of bills of materials, abbreviation BOM), including the product's multiple original material information and the product's multiple accessories information;

該生產流程資訊的欄目包括裁紙、正面印刷、背面印刷、正面上光、軋盒(模切)及打紙。The columns of the production process information include paper cutting, front printing, back printing, front glazing, rolling (die cutting) and papermaking.

請參照第五圖及第六圖,由雲端資料庫20將對應產品113的結構基本資訊21與生產流程資訊22匯入BOM基本資料表13中,該結構基本資訊21與生產流程資訊22係分別傳輸並顯示於該配件欄131與生產流程欄132中,簡化工作流程,提高工作效率。Please refer to the fifth and sixth figures. The cloud database 20 imports the basic structural information 21 and production process information 22 of the corresponding product 113 into the BOM basic data table 13. The structural basic information 21 and the production process information 22 are respectively It is transmitted and displayed in the accessory column 131 and the production process column 132, which simplifies the work process and improves work efficiency.

換言之,該下拉式選單中具有至少一產品(即成品類型),藉由選擇該產品113後,系統則根據用戶選擇之產品113連接至雲端資料庫20中搜尋符合該產品113之BOM模板,其模板已為用戶定義出該產品113的組成所需生產的半成品以及對應的生產工藝流程,用戶則只需根據實際成品中所使用的材料及其用量,以及各項採購類料件之採購來源即可生產完整的BOM基本資料表13。In other words, the drop-down menu has at least one product (that is, the finished product type). After selecting the product 113, the system connects to the cloud database 20 according to the product 113 selected by the user to search for a BOM template that matches the product 113. The template has defined the semi-finished products required by the composition of the product 113 for the user and the corresponding production process. The user only needs to use the materials and their amounts used in the actual finished product, as well as the source of the procurement materials. Can produce complete BOM basic data sheet 13.

請參照第七圖,本發明企業資源管理系統1的雲端資料庫20更連接一後端資料處理模組30,用以建立或更新該結構基本資訊21及該生產流程資訊22。Referring to the seventh figure, the cloud database 20 of the enterprise resource management system 1 of the present invention is further connected to a back-end data processing module 30 for establishing or updating the structural basic information 21 and the production process information 22.

上述詳細說明係針對本發明之可行實施例之具體說明,惟該等實施例並非用以限制本發明之專利範圍,凡未脫離本發明技藝精神所為之等效實施或變更,均應包含於本案之專利範圍中。The above detailed descriptions are specific descriptions of the feasible embodiments of the present invention, but these embodiments are not intended to limit the patent scope of the present invention, and any equivalent implementations or changes that do not depart from the technical spirit of the present invention should be included in this case Within the scope of patents.

1‧‧‧企業資源管理系統1‧‧‧ Enterprise Resource Management System

10‧‧‧資料管理模組10‧‧‧Data Management Module

11‧‧‧列表清單11‧‧‧List list

111‧‧‧新增鍵111‧‧‧Add key

112‧‧‧下拉式選單112‧‧‧drop-down menu

113‧‧‧產品113‧‧‧Products

12‧‧‧產品基本資料表12‧‧‧Product Basic Data Sheet

13‧‧‧BOM基本資料表13‧‧‧BOM Basic Information Sheet

131‧‧‧配件欄131‧‧‧Accessories

132‧‧‧生產流程欄132‧‧‧Production process column

133‧‧‧參數欄133‧‧‧parameter column

20‧‧‧雲端資料庫20‧‧‧Cloud Database

21‧‧‧結構基本資訊21‧‧‧ Structure Basic Information

22‧‧‧生產流程資訊22‧‧‧ Production Process Information

30‧‧‧後端資料處理模組30‧‧‧Backend data processing module

第一圖為本發明之架構示意圖。 第二圖為本發明之列表清單示意圖。 第三圖為本發明之下拉式選單示意圖。 第四圖為本發明之產品基本資料表示意圖。 第五圖為本發明之雲端資料庫與BOM基本資料表連接示意圖。 第六圖為本發明之BOM基本資料表示意圖。 第七圖為本發明之另一架構式意圖。The first figure is a schematic diagram of the architecture of the present invention. The second figure is a schematic diagram of a list of the present invention. The third figure is a schematic diagram of a pull-down menu of the present invention. The fourth figure is a schematic diagram of the basic data sheet of the product of the present invention. The fifth figure is a schematic diagram of the connection between the cloud database and the BOM basic data table of the present invention. The sixth diagram is a schematic diagram of the BOM basic data table of the present invention. The seventh diagram is another architectural intention of the present invention.

Claims (1)

一種企業資源管理系統,其包括有:一資料管理模組,其係具有至少一列表清單,該列表清單的欄目包括有序號、客戶、產品ID、產品名稱、產品類型、產品規格、產品單價、產品條碼、展開規格、成品重量、單位、裝箱單位、禁用及操作,該列表清單中具有至少一新增鍵,該新增鍵具有一下拉式選單,該下拉式選單中具有至少一產品,藉由選擇該產品後,開啟一產品基本資料表,該產品基本資料表中具有一下一步鍵,並於輸入後點選該下一步鍵,以生成一BOM基本資料表,該BOM基本資料表的欄目包括一配件欄、一生產流程欄及一參數欄;一雲端資料庫,其係與該資料管理模組連線,該雲端資料庫中具有至少一對應該產品的結構基本資訊及一對應該產品的生產流程資訊,該生產流程資訊的欄目包括裁紙、正面印刷、背面印刷、正面上光、軋盒(模切)及打紙,該結構基本資訊包括該產品的複數原物料資訊及該產品的複數配件資訊,選擇該產品使該結構基本資訊及該生產流程資訊傳輸並顯示於該BOM基本資料表中,該結構基本資訊與該生產流程資訊係分別傳輸並顯示於該配件欄與生產流程欄中;以及一後端資料處理模組,其係與該雲端資料庫連線,用以建立或更新該結構基本資訊及該生產流程資訊。An enterprise resource management system includes: a data management module, which has at least a list, and the columns of the list include a serial number, a customer, a product ID, a product name, a product type, a product specification, a product unit price, Product barcode, expanded specifications, finished product weight, unit, packing unit, disabling and operation, the list has at least one new key, the new key has a pull-down menu, and the drop-down menu has at least one product, By selecting the product, a product basic data table is opened, and the product basic data table has a next button, and after inputting, the next button is clicked to generate a BOM basic data table. The columns include an accessory column, a production process column, and a parameter column; a cloud database, which is connected to the data management module, and the cloud database has at least one pair of basic structural information and one pair of corresponding products Product production process information. The columns of the production process information include paper cutting, front printing, back printing, front coating, rolling (die cutting), and Paper-cutting, the basic information of the structure includes multiple raw material information of the product and multiple accessory information of the product. Select the product to transmit and display the basic structural information and the production process information in the BOM basic data table. The basic structure of the structure is The information and the production process information are transmitted and displayed in the accessory column and the production process column, respectively; and a back-end data processing module, which is connected to the cloud database to establish or update the basic information of the structure and The production process information.
TW107114951A 2018-05-02 2018-05-02 Enterprise resource management system TWI662487B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW107114951A TWI662487B (en) 2018-05-02 2018-05-02 Enterprise resource management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW107114951A TWI662487B (en) 2018-05-02 2018-05-02 Enterprise resource management system

Publications (2)

Publication Number Publication Date
TWI662487B true TWI662487B (en) 2019-06-11
TW201947467A TW201947467A (en) 2019-12-16

Family

ID=67764528

Family Applications (1)

Application Number Title Priority Date Filing Date
TW107114951A TWI662487B (en) 2018-05-02 2018-05-02 Enterprise resource management system

Country Status (1)

Country Link
TW (1) TWI662487B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110428180A (en) * 2019-08-06 2019-11-08 罗玉清 ERP System
CN112801609A (en) * 2021-01-19 2021-05-14 深圳市墨工智云科技有限公司 System for managing data and working in coordination based on BOM

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW569117B (en) * 2002-07-22 2004-01-01 Inventec Micro Electronics Cor Real-time management method and system for production message
TW200411489A (en) * 2002-12-27 2004-07-01 Inventec Corp Material application method and system
US20150066180A1 (en) * 2012-05-09 2015-03-05 Vayo (Shanghai) Technology Co., Ltd. Quick processing system and method for smt equipment

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW569117B (en) * 2002-07-22 2004-01-01 Inventec Micro Electronics Cor Real-time management method and system for production message
TW200411489A (en) * 2002-12-27 2004-07-01 Inventec Corp Material application method and system
US20150066180A1 (en) * 2012-05-09 2015-03-05 Vayo (Shanghai) Technology Co., Ltd. Quick processing system and method for smt equipment

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110428180A (en) * 2019-08-06 2019-11-08 罗玉清 ERP System
CN112801609A (en) * 2021-01-19 2021-05-14 深圳市墨工智云科技有限公司 System for managing data and working in coordination based on BOM

Also Published As

Publication number Publication date
TW201947467A (en) 2019-12-16

Similar Documents

Publication Publication Date Title
Wignaraja Firm size, technological capabilities and market-oriented policies in Mauritius
Chen et al. A linear programming model for integrated steel production and distribution planning
TWI662487B (en) Enterprise resource management system
CN110796416B (en) Industrial networking based order processing method and computer storage medium
CN106408435A (en) Process compiling system and process compiling method
CN106326243A (en) Data processing method and apparatus
Kaewchur Role of inventory management on competitive advantage of small and medium companies in Thailand
CN108228156A (en) For the system and application method of the movement distribution of e-commerce the whole network
Kock Implementation considerations for activity‐based cost systems inservice firms: the unavoidable challenge
JP6216055B2 (en) Supply chain business process optimization device, supply chain business process optimization method and program
Farrell et al. A relational database approach to a linear programming-based decision support system for production planning in secondary wood product manufacturing
WO2017077920A1 (en) Management assistance device and management assistance method
Gervais et al. Costing in the early Industrial Revolution: gradual change to cost calculations at US cloth mills in the 1820s
CN107301211B (en) Online data processing method
CN104732319A (en) Computer program for business management contract review process control
US11415961B1 (en) Automated correlation of modeled product and preferred manufacturers
Alcorta New economic policies and the diffusion of machine tools in Latin America
CN104408550A (en) Commodity specification processing method
JP2009080530A (en) Integrated component table preparation system, and integrated component table preparation method
CN110163565A (en) The creation method and device of new product
Saxena et al. Supply chain management research in India: A quantitative & qualitative assessment of publication output during 2006–15
TWI756832B (en) New product intelligent ordering system and method of using the same
CN109923484A (en) Technological design supports device, technological design to support methods and procedures
Dennis et al. Structural change and global trade flows: Does an emerging giant matter?
Hole et al. Re‐designing a complex, multi‐customer supply chain

Legal Events

Date Code Title Description
MM4A Annulment or lapse of patent due to non-payment of fees