Method for intelligent generation, dynamic maintenance and closed-loop restoration of spot contract based on roll material hash value

Abstract

This invention discloses a method for intelligent generation, dynamic maintenance, and closed-loop restoration of spot contracts based on coil hash values, belonging to the field of Enterprise Resource Planning (ERP) technology. This invention enables batch selection of coils and one-click contract generation. The coil hash values ​​are generated and automatically grouped based on four core attributes: material, thickness, width, and zinc layer. Unit prices and freight are set in batches by hash group. Coil materials are dynamically added and deleted before financial review. After a contract is deleted, the associated coil materials automatically restore their original inventory state. This invention focuses on the core need for "rapid order completion" in spot trading, with ≤3 operation steps and a 95% improvement in order completion efficiency. It solves the problems of cumbersome operation, error-prone manual calculation, inconvenient adjustment, and data corruption after deletion in traditional spot contracts. The operation is extremely simple, the calculation is accurate, the dynamic adjustment is possible, and the closed-loop system is secure. It is suitable for high-frequency, high-volume business scenarios in spot trading such as steel coils. This invention has been fully implemented in a real industrial ERP system and can run stably in a real production environment for a long time, possessing mature engineering value and industrial promotion capabilities.

Description

Technical Field

[0001] This invention relates to the field of Enterprise Resource Planning (ERP) system technology, specifically to a closed-loop intelligent processing method for coil trading scenarios, which enables one-click batch generation of spot contracts, dynamic addition and deletion of coils, maintenance of unit price and freight, and automatic restoration of coils after contract deletion. Background Technology

[0002] In the spot trading of steel coils, traditional contract creation requires manual binding of each coil, manual grouping and calculation of coils of the same specification is prone to errors, adding and deleting coils for customers is cumbersome, and entering unit price and freight line by line is inefficient. After a contract is deleted, the coil's occupied status cannot be automatically restored, which can easily cause inventory data to be disordered. There is no complete business closed-loop processing solution.

[0003] Existing technologies lack a spot contract management solution that focuses on "rapid order formation and flexible adjustment" and can achieve one-click order formation and automatic grouping and accounting for batch roll materials. Summary of the Invention

[0004] 1. Purpose of the invention Based on the hash value of the core attributes of coil materials, spot contracts can be generated in batches with one click. Data is automatically grouped and calculated. It supports dynamic addition and deletion of coil materials and batch pricing before approval. After the contract is deleted, the coil materials are automatically restored to their original state, forming a complete business loop. It focuses on the core need of "quick order completion" and improves operational efficiency and data accuracy.

[0005] 2. Technical Solution Batch roll selection: Users can select any number of target rolls at once from the inventory roll list without having to create blank spot contracts in advance; One-click contract generation: The system automatically creates a spot contract master order. The coil hash value is generated by MD5 calculation after splicing the four core attributes of "material + thickness + width + zinc layer" in a fixed order. The coils are automatically grouped according to the hash value. Coils with the same hash value are merged into one group. The number of coils and total weight of each group are automatically calculated and written into the contract details. Maintain unit price and shipping cost by hash value group: Users set unit price and shipping cost for each hash value group. The system automatically calculates the total amount for the group = total weight × unit price + corresponding shipping cost, and automatically sums up the amounts of all groups to generate the total contract amount. Dynamic addition and deletion of roll materials before financial review: When inserting roll materials, those with the same hash value are automatically merged into the corresponding group and the data is recalculated, and the new hash value is automatically added to the new group; when deleting roll materials, the system automatically deducts the roll number, weight and amount of the corresponding group, and empty groups are automatically cleaned up; Contract deletion and automatic restoration of coil stock: When a user deletes a spot contract, the system automatically removes the binding relationship between the contract and all associated coil stock, and all coil stock is restored to its original inventory state of being uncontracted and reselectable. Once approved by the finance department, the contract grouping, weight, unit price, freight, and amount are all locked, and no additions, deletions, or modifications are allowed.

[0006] 3. Core Innovation Points Based on the four core attributes of coil material—material, thickness, width, and zinc layer—hash values ​​are generated to achieve automatic grouping and one-click contract generation. This eliminates the traditional manual binding mode for each coil, reducing the operation steps to ≤3 steps and improving order completion efficiency by 95%. Set unit price and freight in batches according to hash value groups, automatically calculate the total amount within the group and the contract, and eliminate manual calculation errors; Before financial review, the system allows for the free addition and deletion of roll materials, and automatically adapts and recalculates data to meet the needs of dynamic business adjustments. After the contract is deleted, the coil material automatically returns to its original inventory state, forming a closed business loop and preventing discrepancies between inventory and business data. Focusing on the core scenario of "rapid order processing in bulk", the operation is extremely simple and adapted to the high-frequency and high-volume business characteristics of spot trading.

[0007] 4. Beneficial effects Supports batch selection of roll materials for one-click ordering, with ≤3 operation steps, greatly improving contract creation efficiency; The system automatically calculates data, achieving zero errors; Dynamic addition and deletion of roll materials can meet customers' temporary needs, and the operation is flexible; Bulk pricing significantly improves pricing efficiency; Contract deletion automatically restores coil stock, ensuring accurate inventory data; It enables full lifecycle management of contracts and is suitable for all scenarios involving high-frequency, high-volume spot trading of steel coils. Detailed Implementation

[0008] Users can select 20 target coils at once on the inventory interface and click the "Generate Spot Contract with One Click" button; The system automatically creates the master contract. The coil hash value is generated based on four core attributes: "material + thickness + width + zinc layer". The coils are automatically divided into three groups according to the hash value. The system automatically calculates and fills in the number of coils and the total weight for each group. Users set a uniform unit price and shipping cost for each hash value group, and the system automatically calculates the total amount for each group and generates the total contract amount. The customer requests an additional 5 rolls of material. The user selects the corresponding rolls and inserts them into the contract. The system automatically merges them into the corresponding hash group and recalculates the grouping and total contract data. The customer requested to cancel 3 rolls of material. After the user deletes them, the system will automatically deduct the corresponding group data and automatically clean up empty groups. If the cooperation is terminated, the user can directly delete the contract, and the system will automatically unbind all 22 rolls of material, restoring the rolls to their original uncontracted inventory state. Once the financial review is approved, the system automatically locks all contract data, prohibiting any additions, deletions, or modifications, and the process is complete.

Claims

1. A method for intelligent generation, dynamic maintenance, and closed-loop reconstruction of spot contracts based on roll hash values, characterized in that, Including the following steps: (1) Users can select target rolls in batches from the inventory roll list without having to create blank spot contracts in advance; (2) After one-click triggering, the system automatically generates spot contract master order. The coil hash value is generated by MD5 calculation after splicing the four core attributes of "material + thickness + width + zinc layer" in a fixed order. The coils are automatically grouped according to hash value, and coils with the same hash value are merged. The number of coils and total weight of each group are automatically calculated. (3) Set the unit price and freight in batches according to hash value groups. The system will automatically calculate the total amount of each group and generate the total contract amount. (4) Before financial review, the system supports inserting and deleting rolls of contract data. After the operation, the system will automatically recalculate the grouping and total contract data. (5) When a contract is deleted, the system will automatically unbind all associated rolls and restore the rolls to their original uncontracted inventory state.

2. The method according to claim 1, characterized in that, When inserting a roll, rolls with the same hash value are automatically merged into existing groups and their data is recalculated, while rolls with a new hash value are automatically added to new groups.

3. The method according to claim 1, characterized in that, When deleting rolls of material, the system automatically deducts the number of rolls, weight, and amount for the corresponding group, and empty groups without rolls of material are automatically cleared.

4. The method according to claim 1, characterized in that, It supports selecting dozens to hundreds of rolls of material at once, with ≤3 operation steps, enabling batch one-click order processing and significantly improving contract creation efficiency.

5. The method according to claim 1, characterized in that, After the financial review is completed, the system automatically locks all contract data, prohibiting any form of addition, deletion, or modification.

6. The method according to claim 1, characterized in that, The total amount for each group is automatically calculated as "total weight × unit price + corresponding shipping fee". The total contract amount is the sum of the total amounts of all hash value groups, eliminating the need for manual calculation.