This invention discloses a
fully automated management method and
system for procurement settlement based on transactions and table-value parameters, relating to the field of industrial digital management. This invention achieves batch contract settlement, batch unit price modification, batch invoicing and reversal through table-value parameters. It employs
database transactions to ensure synchronous updates of the main
purchase order table, detail table, settlement table, final unit price table, and warehouse physical inventory table. Any failed operation automatically rolls back, avoiding data inconsistency. The
system automatically arranges settlement order numbers, implements closed-loop
order status flow, binds contract and
raw material roll hashes for
traceability, differentiates and tracks final unit price entry and modification, automatically rolls back invoicing and reversal status, and batch refreshes global receiving information. It also records the operator,
operation time, and operation address throughout the process. This invention is applicable to integrated management of procurement, settlement, unit price, and invoicing in industrial enterprises such as
metallurgy and
new materials, solving the technical pain points of low efficiency, data chaos, difficulty in
traceability, and susceptibility to errors in traditional manual operations. It features high stability, strong
traceability, closed-loop business, and suitability for large-scale industrial applications. The technical solution described in this invention has been officially implemented in actual industrial production environments, operating stably and reliably.