Patent TW-535086-B (TW)
Title: System and method of computing bonded material
Inventor: HUNG RUNG-JIUN
Filed: 2001-10-12
Granted: 2003-06-01
Abstract: The present invention discloses a system and method of computing bonded material, the system of computing bonded material comprises a computer device and a computing system based on the computer for accounts of last month, the changes computing system of this month, and scraping system, the computation module for the whole bonded material, the completed computation data of this month and other computer-related peripheral equipments, etc. The computing system for accounts of last month comprises the computing unit for product accounts of last month, computing unit for material accounts of last month, classification material number computation module, etc. The computing unit for product accounts of last month is formed of the data file of the product accounts of last month, the first product/semi-product BOM expansion module, material computation module, the first bonded material capturing module, etc. The computing unit for material accounts of last month is formed of the data file of material accounts of last month, the second bonded material capturing module, etc. The changes computing system of this month is formed of the data file of import/export changes of this month, reading module, bonded material distinguishing module, import/export distinguishing module, the first classification material number computation module, export computation module, and computing module for changes data of this month, etc. The export computation unit comprises the second product/semi-product BOM expansion module, the second classification material number computation module, the third bonded material capturing module. The scraping system comprises the scraping data file, categorizing module, the third product/semi-product BOM expansion module, the fourth bonded capturing module and the third classification material number computation module. In addition, the method to ensure computing the material correctively of the present invention comprises the following steps: Let the product/semi-product BOM expansion module display the product/semi-product BOM of the product accounts of last month in the data file of the product accounts of last month; compute the total quantity of each material in the product accounts of last month by the material summation module; let the first bonded material capturing module capture the item and quantity of the total quantity of each material which belongs to the bonded material, and which is computed by the material summation module; let the second bonded material capturing module capture the portion of material quantity of last month in the data file of the material accounts of last month which belongs to the bonded material; let the classification material number computation module compute the total quantity of the bonded material with different material numbers in the factory last month; the reading module reads each import/export data in the import/export changes data file of the current month one by one; let the bonded material distinguish module distinguish if each import/export data of the current month contains the bonded material, if not, read again; if yes, let the import/export distinguishing module distinguish if the import/export data containing bonded material is import or export. If it is import, let the first classification material number computation module compute the total quantity of the import bonded material with different material numbers. If it is export, let the second product/semi-product BOM expansion module display the BOM of export product/semi-product; let the second classification material number computation module compute the total quantity of the material in the product/semi-product with different material numbers; let the third bonded material capture module capture the portion containing the bonded material in the export product/semi-product, so as to obtain the total quantity of the bonded material of each material number in the export bonded material; let the current-month changes data computation module compute the total quantity of the bonded material with the same material number of the changes in the current month; let the categorizing module in the scraping system separate the data of scraped product, scraped semi-product and raw material data in the scrap data file; let the third product/semi-product BOM expansion module display the BOM of scraped product or scraped semi-product; let the fourth bonded material capture module capture the portion that belongs to the bonded material from the scraped product or scraped semi-product, and capture the portion that belongs to the bonded material from the scraped material; let the third classification material number computation module compute the total quantity of the bonded scrap material with each material number; let the computation module for the whole bonded material compute the quantity of the bonded material with the same material number, and compute the quantity of the bonded material with different material numbers in the same fashion, and store the total quantity of the bonded material with different material numbers into the monthly accounts file of this month.