Multi-dimensional docking system and method for retail side and supply side

Abstract

According to the retail end and supply end multi-dimensional docking system and method provided by the invention, real-time integration with multi-dimensional data sources such as ERP, a financial system and an electronic member system is realized through the data synchronization module, and a data island is broken; a coupon deduction sharing model in the intelligent accounting module is used for self-adaptively calculating the cost, so that the accounting precision and flexibility are improved; the compliance and the real-time performance of cost input are ensured by means of balance constraint and a multi-stage approval process of the cost management module; real-time pushing and state tracking of reconciliation information are realized through butt joint of a push notification module and instant messaging tools such as a nail driver; meanwhile, the system security module ensures data security and operation traceability through role authority management and operation log auditing. Particularly, the system optimizes the whole reconciliation process through a multi-dimensional docking method, significantly reduces manual intervention, shortens the reconciliation period, and improves the supply chain collaboration efficiency and transparency.

Description

Technical Field

[0001] This invention relates to the field of enterprise management technology, and in particular to a multi-dimensional system and method for connecting the retail and supply sides. Background Technology

[0002] With the rapid development of the retail industry and the increasing complexity of supply chain structures, reconciliation and payment management between retail enterprises and suppliers have become crucial links in ensuring the efficient operation of the supply chain. Currently, retail enterprises typically rely on Enterprise Resource Planning (ERP) systems to manage sales, inventory, and financial data, while the reconciliation process is mostly completed manually or through semi-automated platforms based on a single system. Existing reconciliation platforms generally involve basic functions such as transaction data extraction, cost calculation, rule-based allocation, and notification push. For example, they obtain transaction records through database interfaces, allocate costs according to a fixed ratio, and send reconciliation results to suppliers via email or traditional messaging systems. While these systems improve data processing efficiency to some extent, they still have many shortcomings due to limitations in technical architecture and functional design.

[0003] Existing reconciliation systems generally rely on a single data source, such as ERP systems, lacking real-time integration with multi-dimensional data sources like financial systems, electronic membership systems, and mobile office platforms (such as DingTalk). This results in delayed data updates, poor consistency, and the formation of data silos. Furthermore, cost allocation rules (such as coupon deduction rules) often depend on manual, static settings, making them unable to be dynamically adjusted based on business needs. This leads to cumbersome and error-prone accounting processes. For example, coupon deduction allocation often uses fixed ratios, making it difficult to adapt to the complex allocation requirements arising from fluctuations in coupon usage during promotional activities. Regarding information delivery, most systems use non-real-time communication methods, lacking immediate feedback and status tracking, preventing suppliers from receiving reconciliation information promptly. Simultaneously, lax access control and weak security auditing functions fail to meet enterprise data security and compliance requirements. These drawbacks result in long reconciliation cycles, high error rates, and excessive manual intervention, increasing operational costs for enterprises, potentially triggering supply chain disputes, and reducing supplier satisfaction.

[0004] Therefore, there is an urgent need in this field for a system and method that can achieve real-time connection, intelligent accounting and automated push of multi-dimensional data between the retail and supply sides, in order to solve problems such as data isolation, low processing efficiency, poor accuracy and insufficient security control. Summary of the Invention

[0005] The purpose of this invention is to provide a multi-dimensional docking system and method between the retail end and the supply end to solve the problems existing in the prior art.

[0006] To achieve the above objectives, the present invention provides the following solution: This invention provides a multi-dimensional docking system between the retail and supply sides, comprising: The data synchronization module is used to collect data from multiple data sources, including ERP systems, financial systems, and electronic membership systems, and synchronize store information, store location information, supplier information, transaction data, coupon data, and gift data in real time through interfaces. The intelligent accounting module is used to calculate transaction data and coupon usage data. It includes a coupon deduction rule management unit, a transaction deduction details unit, a coupon usage log query unit, and a coupon return log query unit. The coupon deduction rule management unit adopts multiple allocation algorithms and dynamically adjusts the rule parameters. The expense management module is used to manage the entry, approval and query of supplier expenses. It includes an expense entry unit, an expense approval unit and an expense history query unit. The expense entry unit is constrained based on the supplier's current period balance. The financial reconciliation module is used to process financial balances and generate reconciliation vouchers, including a balance import unit and a voucher management unit. The voucher management unit generates multiple types of vouchers according to the repayment cycle. The push notification module is used to push reconciliation information and documents to suppliers, including a refund push unit and a push history unit, which are pushed in real time through the DingTalk interface. The system security module is used to manage user permissions, login history, and operation logs, and includes a role management unit, a permission allocation unit, an administrator settings unit, a login history unit, and an operation log unit.

[0007] Preferably, the data synchronization module further includes a data range management unit for defining the data query range, enabling and disabling the data range through keyword fuzzy search and dynamic activation and deactivation of the data range, wherein the data range is composed of a combination of stores and shopping malls.

[0008] Preferably, the coupon deduction rule management unit adopts three allocation algorithms: allocation by a fixed ratio, allocation by the number and amount of coupons used, and allocation by the number of sales contracts. The algorithm formula for allocating costs based on the number and amount of coupons used is as follows: ; Where C is the total amount of coupons used, T is the number of coupons used, N is the preset threshold, α and β are the sharing ratio parameters, and α+β=1. The parameters are optimized through training with historical data.

[0009] Preferably, the formula for calculating the supplier's current period balance in the expense entry unit is as follows: Current period balance = Financial system balance + Sales revenue - Suspended payments - Handling fees - Coupon deductions - Gift deductions - Other expenses; Among them, the suspended amount is sales revenue paid through a designated payment method, and the system verifies the balance in real time when the expense is entered.

[0010] Preferably, the voucher items generated by the voucher management unit include voucher allocation vouchers, voucher return allocation vouchers, gift allocation vouchers, other expense vouchers, and current period balance vouchers. Voucher allocation vouchers are summarized by shopping mall and supplier, while gift allocation vouchers are generated as individual records, and records with zero amounts are automatically removed.

[0011] Preferably, the refund push unit includes batch push and individual push, the push status is fed back in real time and recorded in the push history unit, and the retraction operation of reconciliation files is supported.

[0012] Preferably, the role management unit includes role creation, permission selection and enabling / disabling, permission allocation unit based on the role dynamic configuration module access permissions, and operation log unit records all user operations and supports time range and keyword search.

[0013] This invention also provides a method for multi-dimensional integration between the retail and supply sides, comprising the following steps: S1. Collect and clean data in real time from the ERP system, financial system and electronic membership system through the data synchronization module, including store, store location, supplier, transaction records, coupon usage records and gift records; S2. The intelligent accounting module is used to calculate transaction and coupon usage data. The coupon deduction allocation adopts a multi-rule dynamic model, which selects the allocation algorithm and calculates the allocation amount according to the coupon usage method. S3. Enter supplier expenses through the expense management module, verify them based on the current period balance, and submit them to a multi-level approval process; S4. Import the financial system balance through the financial reconciliation module and generate reconciliation vouchers periodically, including summary and detailed vouchers; S5. Push reconciliation documents and notifications to supplier DingTalk contacts via the push notification module, and track the push status; S6. Manage user roles, permissions, and operation logs through the system security module to ensure secure system access.

[0014] Preferably, in step S2, the parameters of the coupon deduction allocation model are optimized using the gradient descent method, and the objective function is: ; Where M is the number of training samples, and α and β are the amortization ratio parameters.

[0015] Preferably, in step S4, the voucher period, data date range, purpose, business date and settlement date are automatically filled in when the voucher is generated, and a voucher fingerprint is generated by a hash algorithm to ensure data integrity.

[0016] The present invention achieves the following beneficial technical effects compared to the prior art: This invention provides a multi-dimensional integration system and method for retail and supply chain integration. Through a data synchronization module, it achieves real-time integration with multi-dimensional data sources such as ERP, financial systems, and electronic membership systems, breaking down data silos. The intelligent accounting module utilizes a coupon deduction and allocation model for adaptive cost calculation, improving accounting accuracy and flexibility. The cost management module's balance constraints and multi-level approval processes ensure the compliance and real-time nature of cost entry. The push notification module integrates with instant messaging tools such as DingTalk, enabling real-time push notifications and status tracking of reconciliation information. Simultaneously, the system security module ensures data security and operational traceability through role-based access control and operation log auditing. In particular, this system optimizes the entire reconciliation process through multi-dimensional integration, significantly reducing manual intervention, shortening the reconciliation cycle, and improving supply chain collaboration efficiency and transparency. Attached Figure Description

[0017] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0018] Figure 1 This invention provides a flowchart of a multi-dimensional docking method between the retail and supply sides. Detailed Implementation

[0019] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0020] The purpose of this invention is to provide a multi-dimensional system and method for connecting the retail and supply sides. By integrating Enterprise Resource Planning (ERP) systems, financial systems, electronic membership systems, and third-party platforms such as DingTalk, it achieves efficient data synchronization, intelligent accounting, automated reconciliation, and real-time communication between the retail and supply sides. The system adopts a modular design, with each module interacting with data through standardized interfaces to ensure the consistency and integrity of the data flow.

[0021] like Figure 1As shown, this method mainly includes steps such as data collection and synchronization, intelligent accounting, expense management, financial reconciliation, information push and system security management. The following will provide a detailed explanation of each part in conjunction with the system structure.

[0022] Specifically, the data synchronization module, as the foundation of the system, is responsible for real-time data collection from multiple heterogeneous data sources. This module connects to ERP systems, financial databases, and electronic membership systems through predefined API interfaces, periodically or triggered to retrieve key business data such as store information, store configurations, supplier master data, transaction records, coupon usage records, and gift distribution records. After data collection, the module's built-in data cleaning component performs preprocessing operations on the raw data, including deduplication, format standardization, and missing value imputation. For example, it unifies date formats from different sources to "YYYY-MM-DD" to ensure data quality. The data scope management unit allows users to dynamically define data query scopes based on dimensions such as stores and shopping malls, supports fuzzy searches using keywords, and allows enabling or disabling specific data scopes as needed, thus flexibly adapting to the management needs of retail enterprises of different sizes.

[0023] Furthermore, the intelligent accounting module is the core processing unit of this system, focusing on solving the complexity of coupon deduction cost allocation. The coupon deduction rule management unit supports three allocation algorithms: fixed-ratio allocation is suitable for scenarios with simple promotional activity rules; allocation based on the number and amount of coupons used is suitable for situations where the amount of coupons used fluctuates greatly during the activity period, and its algorithm formula is as follows: ; Where C is the total amount of coupons used, T is the number of coupons used, N is the preset threshold (e.g., 100 coupons), and α and β are proportional parameters obtained through training with historical data (e.g., α=0.7, β=0.3), satisfying α+β=1; apportionment by sales contract quantity is suitable for large transactions or contract-based suppliers. This module optimizes the model parameters using gradient descent, and the objective function is: ; Where M is the number of training samples, and α and β are the allocation ratio parameters to minimize the prediction error. The transaction deduction details unit and coupon usage log query unit provide detailed data query and accounting functions, support both full accounting and incremental accounting modes, and allow users to cancel the calculated records with one click after the rules are adjusted, ensuring data traceability.

[0024] Furthermore, the expense management module enables fully electronic processing of supplier expenses. When a user adds a fixed expense, the expense entry unit calculates the supplier's current period balance in real time using the formula: Current Period Balance = Financial System Balance + Sales Revenue - Suspended Payments (e.g., amounts from payment methods like Silver Beans, Scratch Cards, etc.) - Transaction Fees - Coupon Deductions - Gift Deductions - Other Expenses. The system checks if the total amount exceeds the current balance when submitting expenses; if so, it rejects the submission and prompts the user to refresh the data. The expense approval unit supports multi-level approval processes. Appraisers can view expense details and approval history through the system and fill in their comments. After approval, the system automatically generates an encrypted and signed PDF voucher for the supplier to download. The expense history query unit provides multi-dimensional query functions by time, store, and approval status, and supports batch export of vouchers.

[0025] Furthermore, the financial reconciliation module is responsible for integrating financial data and generating standardized reconciliation vouchers. The balance import unit allows finance personnel to batch import supplier financial system balances into the system by uploading Excel files that meet the required format. The system overwrites old records with the last imported data. When generating vouchers, the voucher management unit automatically fills in fields such as voucher period, data date range, purpose, business date, and settlement date. Users can customize voucher items (such as voucher allocation vouchers, voucher return allocation vouchers, and gift allocation vouchers). Voucher allocation vouchers are summarized by the "shopping mall + supplier" dimension, while gift allocation vouchers are generated on a per-record basis, and the system automatically filters entries with zero amounts. To ensure data integrity, each voucher generates a digital fingerprint using the SHA-256 hash algorithm to prevent tampering.

[0026] Furthermore, the push notification module enables real-time interaction with suppliers through the DingTalk enterprise interface. After the user selects the data range and date range, the reimbursement push unit automatically generates an Excel reconciliation file containing bill summaries, transaction details, coupon deductions, and gift details. This file, along with the notification message, is then pushed to the supplier's linked DingTalk contact via the reconciliation interface. Push notifications support single or batch operations, with real-time feedback on the sending status (success / failure). The push history unit records all push operations, supports queries by time, supplier, and status, and allows users to retract sent files in case of accidental operation, ensuring flexible information management.

[0027] Furthermore, the system security module is integrated throughout the entire system lifecycle, providing comprehensive access control and operation auditing. The role management unit allows system administrators to create different roles (such as expense entry clerks, auditors, and financial personnel) and select accessible modules and operation permissions for each role. The permission allocation unit dynamically configures user access to stores, data ranges, and function menus based on roles. The administrator settings unit supports account activation, deactivation, and password reset, and forces first-time users to change their passwords and linked email addresses. The login history and operation log units record all users' login times, IP addresses, operation types (such as add, modify, and delete), and operation details, supporting audit queries by time range and keywords to meet enterprise compliance requirements.

[0028] The method flow of the present invention is as follows: Figure 1 As shown, the system first collects and cleans multi-source data through a data synchronization module to ensure the accuracy and real-time nature of the basic data. Then, an intelligent accounting module dynamically allocates and calculates transaction and coupon usage records to improve accounting accuracy. In the expense management phase, the system uses balance constraints to enable expense entry and multi-level approval, ensuring fund security. The financial reconciliation module automatically generates standardized vouchers, simplifying the reconciliation process. The push notification module integrates with DingTalk to achieve instant information delivery and status tracking. Finally, the system security module manages role permissions and operation logs to ensure the security and controllability of the entire process. This method, through end-to-end automation and intelligent design, significantly reduces the intensity of manual intervention and improves reconciliation efficiency and supply chain collaboration.

[0029] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0030] It should be noted that the components mentioned in the above embodiments are all general standard parts or components known to those skilled in the art. Their structures and principles can be learned by those skilled in the art through technical manuals or conventional experimental methods.

[0031] This invention has illustrated its principles and implementation methods using specific examples. The descriptions of these embodiments are merely illustrative of the method and its core ideas; furthermore, those skilled in the art will recognize that modifications may be made to the specific implementation methods and application scope based on the principles of this invention. Therefore, the content of this specification should not be construed as limiting the invention.

Claims

1. A retail end and supply end multi-dimension interfacing system, characterized in that, Comprise: Data synchronization module, the data synchronization module is used for collecting data from multiple data sources, including ERP system, financial system, electronic member system, and synchronizing store information, commercial site information, supplier information, transaction data, coupon data, gift data in real time through interface; Intelligent accounting module, the intelligent accounting module is used for accounting transaction data and coupon data, including coupon deduction rule management unit, transaction deduction detail unit, coupon log query unit and return coupon log query unit, the coupon deduction rule management unit adopts multiple allocation algorithms and dynamically adjusts rule parameters; Cost management module, the cost management module is used for managing the entry, approval and query of supplier cost, including cost entry unit, cost approval unit and cost history query unit, the cost entry unit is constrained based on supplier current balance; Financial reconciliation module, the financial reconciliation module is used for processing financial balance and generating reconciliation vouchers, including balance import unit and voucher management unit, the voucher management unit generates multiple types of vouchers according to return payment period; Push notification module, the push notification module is used for pushing reconciliation information and files to suppliers, including return payment push unit and push history unit, which is pushed in real time through Dingding interface; System security module, the system security module is used for managing user permissions, login history and operation logs, including role management unit, permission allocation unit, administrator setting unit, login history unit and operation log unit.

2. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The data synchronization module further comprises a data range management unit for defining data query range, which is dynamically enabled and disabled through keyword fuzzy query and data range, the data range is composed of store and mall combination.

3. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The coupon deduction rule management unit adopts three allocation algorithms, which are: allocation according to fixed proportion, allocation according to coupon quantity and amount, and allocation according to sales contract quantity; The formula of the algorithm according to coupon quantity and amount is: ； Wherein, C is the total amount of coupons, T is the number of coupons, N is the preset threshold, and α and β are allocation proportion parameters, and α+β=1, the parameters are optimized through historical data training.

4. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The calculation formula of supplier current balance in the cost entry unit is: Current balance = financial system balance + sales revenue - suspension payment - commission fee - coupon deduction allocation - gift allocation - other costs; Wherein, suspension payment is the sales revenue of specified payment method, and the system verifies the balance in real time when the cost is entered.

5. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The voucher items generated by the voucher management unit include coupon allocation voucher, return coupon allocation voucher, gift allocation voucher, other cost voucher and current balance voucher, wherein the coupon allocation voucher is summarized according to mall and supplier, the gift allocation voucher is generated according to single record, and the record with zero amount is automatically removed.

6. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The return payment push unit includes batch push and individual push, the push state is fed back in real time and recorded in the push history unit, and the withdrawal operation of reconciliation file is supported.

7. The retail and supply multi-dimensional interfacing system of claim 1, wherein, The role management unit includes role creation, permission checking and enabling, disabling, the permission allocation unit dynamically configures module access permission based on role, and the operation log unit records all user operations and supports time range and keyword query.

8. A method for multi-dimension interfacing of retail end and supply end, characterized in that, Comprise the following steps: S1. Collect and clean data from ERP system, financial system and electronic membership system in real time through data synchronization module, including store, business location, supplier, transaction record, coupon record and gift record; S2. Use intelligent accounting module to account for transaction and coupon data, where coupon deduction allocation uses a multi-rule dynamic model to select allocation algorithm and calculate allocation amount according to coupon usage method; S3. Enter supplier expenses through the expense management module, verify based on the current balance, and submit a multi-level approval process; S4. Import financial system balance through the financial reconciliation module, generate reconciliation vouchers by period, including summary and detailed vouchers; S5. Push reconciliation files and notifications to DingTalk contacts of suppliers through the push notification module, and track the push status; S6. Manage user roles, permissions and operation logs through the system security module to ensure system access security.

9. The retail end and supply end multi-dimension interfacing method according to claim 8, wherein, In step S2, the coupon deduction allocation model parameters are optimized by gradient descent method, and the objective function is: ； Where M is the number of training samples, and α and β are allocation proportion parameters.

10. The retail end and supply end multi-dimension interfacing method according to claim 8, wherein, In step S4, the voucher generation automatically fills in the voucher period, data date range, purpose, business date and settlement date, and generates a voucher fingerprint through a hash algorithm to ensure data integrity.

Images