The application discloses a kind of based on unified identification's cross-
library ERP-MES fusion
single product cost accurate
accounting method, it is related to industrial
informatization, cross-
database data fusion, production financial integration and fine cost accounting technical field.The application is directly cross-
library joint calculation by constructing the global unified unique
identification system throughout
raw material, procurement, production, sales whole process under the premise of without
data synchronization, intermediate
library, ETL tool and interface service, realizes MES production library,
raw material management library, ERP procurement library, ERP sales library;Adopt lightweight temporary table and extremely simple step-by-step batch update mechanism, based on finished product output proportion realizes
single product level
raw material cost automatic accurate allocation, completes raw material cost, sales income, additional cost whole process
automation accounting and whole link
traceability.The application solves traditional multi-
system data island, cross-library development complex,
data synchronization delay, cost accounting extensive,
code redundancy, maintenance cost is high, poor generalization and other technical pain points from architecture root, has no invasion access, real-time calculation, accounting precision, high performance, easy maintenance, cross-industry generalization and other outstanding advantages, can be widely applied to the ERP and MES depth fusion and fine
cost control scene of various
manufacturing enterprises.