Account book inventory management system based on cross-border transaction

Abstract

The invention relates to the technical field of cross-border trade inventory management, and discloses an account book inventory management system based on cross-border transactions, which establishes an internal inventory record in one-to-one correspondence between customs record number and account book, occupation and available three-state inventory by acquiring import declaration and warranty checking list data. According to the invention, an original opaque customs account book inventory checking and deduction process is converted into a clear, visible and traceable real-time business process at an enterprise side, so that an enterprise can visibly manage in-library assets; an internal closed-loop exception processing and data correction mechanism ensures the accuracy and reliability of inventory data when dealing with business process reversion and external information change.

Description

Technical Field

[0001] This invention relates to an inventory management system based on cross-border transactions, belonging to the field of cross-border trade inventory management technology. Background Technology

[0002] In the field of supply chain management involving cross-border transactions and bonded logistics, companies typically rely on their internal resource planning systems to manage their commodity inventory, while customs authorities use their official electronic ledger system to monitor and verify the inventory of goods under bond. These two systems coexist in practice, but their data exchange often depends on the receipt of documents in the declaration, release and other stages, rather than a real-time, two-way synchronous mechanism.

[0003] However, with the rapid development of cross-border e-commerce, transactions are characterized by high frequency, small batches, and fast turnover, which places more stringent demands on the real-time and accuracy of inventory management. Under current technological practices, when a company submits a bonded declaration list to customs, the inventory data in its internal system cannot immediately reflect the pre-positioned status of these goods in the customs register. This lag in information acquisition leads to a systemic and invisible information gap between the inventory data on which the company's operational decisions are based and the customs' statutory inventory data. Companies cannot clearly distinguish which of their book inventory is truly available for initiating a new round of declarations and which is occupied inventory that has been declared but not yet finally cleared. This ambiguity brings potential risks to the company's replenishment strategy, order response, and even compliance declarations.

[0004] At a deeper level, the root cause of this information asymmetry lies in the enterprise's establishment of a dynamic inventory status mapping mechanism that is isomorphic to the customs verification logic. This leads to a series of inherent limitations that are difficult to overcome. Specifically, existing technological practices mainly suffer from the following shortcomings: 1. Lack of transparency in inventory status: Enterprises cannot obtain real-time and accurate information about their actual material number balance in the customs ledger, nor can they track the details of inventory being used by specific business documents; 2. Lack of refined management of multiple inventory statuses: Existing systems generally fail to effectively classify inventory into different statuses such as ledger inventory, occupied inventory, and available inventory, failing to provide accurate data support for operational decisions; 3. Lack and fragility of anomaly handling mechanisms: When faced with business process reversals such as order cancellations or declaration withdrawals, there is no reliable and automated inventory rollback mechanism to ensure accurate backtracking of ledger data, making it extremely easy for data disorder and cumulative errors to occur due to human intervention oversights. Therefore, the technical problem to be solved by this invention is how to establish an inventory management mechanism that can synchronize with customs ledger verification logic, realize real-time visibility of multi-state inventory, and provide closed-loop processing capabilities for anomalies in business processes, so as to ensure the accuracy and consistency of enterprise-side inventory data. Summary of the Invention

[0005] This invention provides a ledger and inventory management system based on cross-border transactions. Its main purpose is to solve the problems in the existing technology where enterprises cannot grasp the status of customs ledger and inventory in real time and accurately due to information asymmetry, and where there is a lack of reliable inventory correction mechanism when business is abnormal.

[0006] To achieve the above objectives, the present invention provides a ledger and inventory management system based on cross-border transactions, comprising: The data acquisition module is configured to acquire import declaration data and bonded verification list data associated with customs ledgers; The ledger and inventory processing module is connected to the data acquisition module and is configured to establish inventory records based on import declaration data. The inventory records include customs filing material numbers and Jin Er serial numbers, and correspond one-to-one with ledger inventory quantity, occupied inventory quantity, and available inventory quantity. The inventory status management module, connected to the ledger inventory processing module, is configured to increase the occupied inventory and simultaneously decrease the available inventory after receiving the bonded verification list data, and to bind this inventory change to a unique business order number. The query interaction module, connected to the ledger and inventory processing module, is configured to generate and display an inventory data interface that includes ledger inventory quantity, occupied inventory quantity, and available inventory quantity.

[0007] Preferably, the system also includes an exception handling module, which is connected to the inventory status management module and is configured to: when a deletion instruction for a certain business order number is received, retrieve the inventory quantity change record bound to the business order number; and perform inventory rollback based on the quantity recorded in the inventory quantity change record, wherein the inventory rollback specifically reduces the occupied inventory quantity and increases the available inventory quantity by the same amount.

[0008] Preferably, the exception handling module is further configured to: when manual inventory adjustment is activated due to the lack of receipt of a bonded verification list acknowledgment from the customs system, receive a manual confirmation instruction for a specific bonded verification list; and, based on the quantity of goods recorded in the bonded verification list confirmed by the manual confirmation instruction, perform inventory deduction, with the update of available inventory following the rules: ,in, To update the available inventory after performing inventory deduction, To determine the available inventory level before inventory deduction, The quantity of goods recorded in the bonded verification list.

[0009] Preferably, the exception handling module is also configured to: upon receiving a material number disabling instruction triggered by the customs' modification of the filing information, update the corresponding customs-filed material number record in the ledger inventory processing module to a disabled state; and while the customs-filed material number record is in a disabled state, grant editing permissions to the fields of commodity name, HS code, country of origin, declaring unit, and legal unit of measurement associated with that record.

[0010] Preferably, the query interaction module is also configured to: perform an inventory data screening operation, the execution rule of which is to filter out inventory records with occupied inventory greater than zero or available inventory less than zero from all inventory records; and to centrally display the filtered inventory records in the inventory data interface.

[0011] Preferably, the query interaction module is further configured to: after receiving a query request for the exit record of a certain Jin Er serial number, aggregate all the exit records of the bonded verification list associated with that Jin Er serial number; and generate and display an exit details interface containing the business order number, list number, verification list number, creation time and exit quantity of each exit record.

[0012] Preferably, the inventory record data structure also includes a unified part number field; the ledger inventory processing module is also configured to respond to import operations and establish a batch data mapping between customs-registered part numbers and unified part numbers.

[0013] Preferably, the inventory data interface generated by the query interaction module also includes a batch operation function area, which is configured to: after receiving the user's selection operation and activation instruction for multiple inventory records, set the corresponding Jin Er serial number of the multiple inventory records to a status that can be used for declaration.

[0014] Preferably, the ledger inventory processing module is also configured to record a log of each inventory change. The log includes at least the business type, business number, change quantity, available inventory after the change, and change time. The business type is used to indicate whether the source of the change is an import declaration or a parcel exit deduction.

[0015] Preferably, the data acquisition module is also configured to acquire release order data; the ledger and inventory processing module is also configured to integrate the release order data with the import declaration data and the bonded registration list data to form a unified inventory flow record.

[0016] Compared with the prior art, the beneficial effects of the present invention are: 1. This invention establishes a data acquisition module, an inventory processing module, and an inventory status management module, and enables these three modules to work together to transform the previously discrete and static customs declaration data into a dynamic, multi-dimensional, real-time inventory view for the enterprise. The system does not simply synchronize data, but rather immediately deconstructs the acquired bonded verification list data into synchronized adjustments to the two states of occupied inventory and available inventory, and binds them to specific business order numbers. This transforms the previously opaque customs inventory verification process for enterprises into a clearly visible and traceable business process within the enterprise's internal system. As a result, enterprises can accurately perceive the actual impact of each order on future available inventory at the time the business occurs, thereby upgrading the previously lagging and passive inventory management method to an in-stock asset management method that is closely coupled with the business flow.

[0017] 2. This invention provides a self-correcting closed-loop management mechanism by linking the inventory status management module and the exception handling module through their inherent logic. This mechanism addresses common anomalies in cross-border business, such as order deletion or customs rejection. Since the inventory status management module pre-binds each inventory change to a unique business order number when performing outbound occupancy operations, when the exception handling module receives a deletion instruction for that business order number, the system does not perform a vague inventory addition. Instead, it accurately traces the original inventory change record and executes an inventory rollback operation equal to but opposite in direction to the original change. This mechanism ensures that inventory data maintains its accuracy and consistency even after the business process has reversed, avoiding errors and discrepancies between records and actual inventory that may be introduced by manual intervention.

[0018] 3. This invention combines the enabling of manual modification permissions for part numbers after they have been disabled in the exception handling module with the inventory data screening function in the query interaction module to jointly construct an inventory data governance system that combines the flexibility of data correction with the ability to proactively warn of risks. On the one hand, when an external event such as a change in customs filing information occurs, the system provides enterprises with a standardized channel to keep data synchronized with customs through a controlled approach of first disabling and then enabling editing permissions. On the other hand, by continuously screening the logical relationship between occupied and available inventory, the system can proactively expose and alert to potential logical contradictions in the inventory data. This combination of external synchronization and internal self-checking mechanisms ensures the dual robustness of the inventory ledger in dealing with changes in external rules and internal data anomalies. Attached Figure Description

[0019] Figure 1 This is a functional module architecture diagram of an inventory management system based on cross-border transactions according to the present invention. Figure 2 This is a performance comparison test graph of the response time of the system of the present invention and the control group system; Figure 3 This is a data processing flowchart for an inventory management system based on cross-border transactions according to the present invention.

[0020] The objectives, features, and advantages of this invention will be further explained in conjunction with the embodiments and with reference to the accompanying drawings. Detailed Implementation

[0021] To make the objectives, technical solutions, and advantages of the present invention clearer, the present invention will be described in further detail below. However, it should be understood that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments in this specification without creative effort are within the scope of protection of the present invention.

[0022] This invention provides a ledger and inventory management system based on cross-border transactions. Through a collaborative architecture consisting of a data acquisition module, a ledger and inventory processing module, an inventory status management module, an anomaly handling module, and a query interaction module, it transforms the non-real-time data interaction between the customs supervision system and the enterprise's internal systems, which relies on document receipts, into a dynamic inventory status mapping mechanism that is isomorphic to the customs verification logic at the enterprise level. The system first acquires import declaration data and bonded verification list data through the data acquisition module. Then, the ledger and inventory processing module transforms this data into a multi-dimensional status record containing ledger inventory, occupied inventory, and available inventory. The inventory status management module dynamically adjusts the inventory status based on business processes. Finally, the query interaction module presents a real-time, transparent, and traceable inventory view, while the anomaly handling module provides data for the business flow. The system provides closed-loop data correction capabilities for process reversals and external information changes. In the supply chain management practice of cross-border bonded logistics, enterprises generally face a technical challenge: there is a systemic data gap caused by the lag in information acquisition between the data on which their internal inventory system is based and the electronic ledger data legally supervised by customs. To address this challenge, the data acquisition module of this invention is configured to establish a continuous information channel with the external interface of the customs system. This channel can be implemented as a periodically polling application programming interface or a message queue-based subscription and push mechanism to continuously acquire import declaration data and bonded verification list data associated with the customs ledger. In this way, the system obtains a raw data input source synchronized with customs business activities, laying the foundation for subsequently building an internal mirror record on the enterprise side that corresponds to the real-time inventory status of the customs ledger.

[0023] Given that simply acquiring raw declaration data is insufficient to directly support enterprise operational decisions, the system needs to establish a mechanism to transform discrete data into a structured inventory asset view. To this end, the ledger inventory processing module is configured to execute an initialization or incremental update procedure for inventory records upon receiving import declaration data from the data acquisition module. The inventory records operated on by this module are a specific data structure, with core fields including at least the customs-registered material number and the "Golden II" serial number, as well as three numerical fields representing different inventory states: ledger inventory quantity, occupied inventory quantity, and available inventory quantity. When a new import declaration arrives, the module checks for a corresponding record based on the customs-registered material number. If it does not exist, a new record is created, and the quantity of goods recorded in the declaration data is simultaneously assigned to the ledger inventory quantity and available inventory quantity, while the occupied inventory quantity is initialized to zero. If the record already exists, the declared quantity is synchronously added to the existing ledger inventory quantity and available inventory quantity. Through this deterministic data processing flow, the system transforms the static import declaration behavior into a dynamic internal enterprise view of ledger inventory. The asset accounting process involves synchronizing inventory with available inventory. However, when a company submits a bonded verification list, its inventory status in the customs ledger changes. If the company's internal system fails to reflect this in a timely manner, it will lead to distortion of the available inventory data used for operational decisions. To address this scenario, the inventory status management module is configured to perform an in-transit inventory status occupancy operation upon receiving the bonded verification list data. This operation follows an atomic transaction processing procedure, which synchronously increases the occupied inventory in the corresponding inventory record based on the goods and quantities specified in the list, and decreases the available inventory by the exact same amount. Furthermore, to ensure the traceability of every inventory status change, the module also forcibly binds each executed inventory change operation to a unique business order number originating from the bonded verification list. The introduction of this mechanism transforms the previously opaque customs ledger inventory pre-deduction process into a real-time occupancy status that is clearly visible within the company's internal system and strongly correlated with specific business documents, thus providing a data foundation for inventory management and business anomaly handling.

[0024] In real-world business processes, order cancellations or customs returns leading to declaration withdrawals are common boundary conditions. Without a reliable mechanism to release occupied inventory, this can cause data corruption in the ledger. To address this, the system's exception handling module has implemented a closed-loop inventory rollback mechanism based on business order numbers. When a deletion command for a specific business order number is received, the system doesn't perform a fuzzy inventory addition. Instead, it first precisely retrieves the original inventory change record bound to that business order number in the inventory status management module. Subsequently, based on the direction and exact quantity of the change recorded in that record, the exception handling module performs a completely equivalent reverse inventory adjustment. This inventory rollback specifically reduces the occupied inventory and increases the available inventory by the same amount. Through this precise tracing and reverse operation... The system ensures that inventory data can be accurately restored to its initial state after a business process reversal, avoiding cumulative errors that may be introduced by manual intervention. Furthermore, occasional failures to issue receipts due to network or internal processing delays in the customs system pose a practical obstacle to the system's stable operation. Therefore, the exception handling module provides a backup interaction path to ensure inventory deduction is achieved. Specifically, if the customs system fails to issue a bonded verification list receipt within a configurable waiting period, a manual inventory adjustment interface will be activated. On this interface, users can issue a manual confirmation command for a specific bonded verification list. Upon receiving this command, the exception handling module will perform an inventory deduction based on the quantity of goods recorded in the list. The update of available inventory follows the following procedure: ,in, To update the available inventory after performing inventory deduction, To determine the available inventory level before inventory deduction, This refers to the quantity of goods recorded in the bonded verification list. This primary and backup interactive solution ensures that even if the preferred automated information link is blocked, the core inventory verification business can still be completed through a controlled manual intervention channel, proactively eliminating the risk of business interruption due to the unreliability of external systems. In addition, to cope with the data synchronization requirements triggered by the customs' modification of the filing information, the exception handling module is also configured to, upon receiving a material number disabling instruction, first update the corresponding customs filing material number record in the ledger inventory processing module to a disabled state. This state will prevent the material number from being used for any new cross-border import declaration and bonded verification declaration. Correspondingly, when the customs filing material number record is in a disabled state, the system will selectively open editing permissions for specific fields associated with the record, such as commodity name, HS code, country of origin, declaring unit, and legal unit of measurement. This controlled process of disabling first and then opening editing provides enterprises with a standardized channel to keep data synchronized with the customs, preventing data inconsistencies during information changes.

[0025] To provide users with structured data for business analysis based on the aforementioned multi-dimensional inventory status data, the query interaction module is configured to generate and display a multi-functional inventory data interface. Users can not only see a complete list including ledger inventory, occupied inventory, and available inventory, but also perform an inventory data screening operation. This operation filters out inventory records with occupied inventory greater than zero or available inventory less than zero from all inventory records. By centrally displaying these records with potential logical inconsistencies or those in transit within the inventory data interface, the system helps users quickly locate inventory anomalies requiring attention, enabling targeted analysis of specific inventory issues. The inventory status filtering and prompts help users identify risks. Meanwhile, to meet the need for in-depth traceability of the circulation history of specific material numbers, the query interaction module is also configured to respond to query requests for outbound records of a specific "Golden II" serial number. Upon receiving such a request, the module aggregates all bonded verification and registration list outbound records associated with that "Golden II" serial number and generates a dedicated outbound details interface. This interface displays the business order number, list number, verification and registration list number, creation time, and outbound quantity of each outbound record in a list format. This allows users to completely trace the entire business footprint of any material number from warehousing to final outbound, providing data support for refined analysis of the supply chain.

[0026] To further enhance the system's flexibility and data management efficiency, the ledger and inventory processing module is also configured to respond to import operations, enabling batch establishment of data mappings between customs-registered material numbers and internally defined unified material numbers. Furthermore, the inventory data interface generated by the query interaction module includes a batch operation function area. This function area is configured to, upon receiving user selection and activation instructions for multiple inventory records, batch set the corresponding "Golden II" serial numbers for multiple inventory records to a status suitable for declaration. These batch processing functions significantly reduce the complexity of manual operations. Finally, to ensure the integrity and auditability of all inventory changes, the ledger and inventory processing module is also configured to record a log of each inventory quantity change. This log includes at least the business type, business order number, changed quantity, changed ledger inventory, occupied inventory, available inventory, and change time. The business type indicates whether the change stems from an increase in inventory due to import declarations or a decrease in inventory due to actual deductions for parcels leaving the zone. This constructs a complete, granular, and tamper-proof inventory change history, providing a data foundation for subsequent financial reconciliation, business review, and compliance audits.

[0027] Example 1: In a bonded warehousing application handling high-frequency, small-batch cross-border e-commerce orders, the inventory management system based on cross-border transactions is experiencing peak business periods. A customs-registered material number within the system corresponds to a usable inventory of 1,000 units. During this period, to respond to the concentrated outbound demand, the operations team generates multiple bonded verification lists in a short time, pre-occupying a total of 998 units. Based on its inventory status management module, the system transfers these 998 units from usable inventory to occupied inventory. At this point, the system's inventory data interface displays two units of usable inventory and 998 units of occupied inventory. Subsequently, the system's data... The data acquisition module received an instruction from customs, requesting the deletion of an import declaration that had already been entered into the warehouse. This declaration included twenty items with the aforementioned customs-registered material number. This situation presented a technical challenge: with only two items remaining in available inventory, directly deducting twenty items from the inventory register would result in a negative available inventory. Furthermore, this reverse operation, coupled with the ongoing removal of 998 items from the warehouse, created high concurrency, potentially leading to data conflicts and discrepancies between the inventory register and physical inventory. This intertwining of reverse and forward concurrency in the business process tested the data consistency and processing logic stability of the inventory management system.

[0028] The system did not treat this as two events requiring independent coordination. Its internal mechanism began to handle the event collaboratively. The inventory status management module bound each operation to a unique business order number when initially executing inventory changes, providing an unambiguous operational anchor for the subsequent intervention of the exception handling module. When the deletion instruction for the import declaration triggered the exception handling module, the inventory rollback executed by the module was based on the transaction log bound to the import declaration number, deducting the inventory quantity in the ledger. Since these twenty items were logically never occupied by any bonded verification list for outbound business, this deduction operation only affected the inventory quantity in the ledger and the available inventory quantity, and was data-isolated from the occupied inventory quantity of up to 998 items. Ultimately, the inventory quantity in the ledger was reduced by 20 items, and the available inventory quantity was updated from two items to negative 18 items. This result was immediately identified and displayed through the inventory data screening function in the query interaction module.

[0029] The negative 18 units shown in the available inventory is not an error, but a quantitative reflection of the actual business status. It reveals to managers that the inventory currently committed to or occupied by subsequent business processes exceeds the legally mandated 18 units in stock. Through its three-state inventory data structure—ledger, occupied, and available—the system unifies the conflict between front-end sales speed and back-end compliance accuracy in inventory management into a measurable data view. Enterprises can simultaneously address both needs within a single architecture, eliminating the need for fragmented processes or redundant manual verification to resolve this contradiction. Furthermore, this process provides a different operational method from traditional inventory management. Because the system's ledger inventory processing module and inventory status management module are structurally consistent with customs verification logic, the management challenges faced by enterprises are significantly reduced. The task of managing inventory is no longer about spending time identifying and correcting inventory discrepancies after peak business periods; the core of operations shifts to dynamically adjusting work plans based on real-time feedback of available inventory data, which includes information on inventory in transit and potential shortages. When available inventory is negative, companies can anticipate risks and take proactive measures without waiting for delayed notifications from customs, such as communicating with customers, adjusting the delivery schedule for subsequent batches, or initiating new import declarations. Throughout the entire process in this embodiment, the system's data structure maintains consistency under the pressure of business processes. Concurrent and reverse operations that might have previously caused data chaos are handled through the system's internal mechanisms and multi-state inventory model. Ultimately, the company's inventory data remains synchronized with the logical state of customs ledgers, providing operational decisions with inventory data reflecting inventory in transit.

[0030] Example 2: To objectively verify the ability of the ledger and inventory management system to maintain synchronization between its internal inventory data and the logical state of the customs ledger when facing high-throughput transactions and external communication anomalies, this example constructs a dedicated digital simulation experiment. Its purpose is to quantitatively evaluate the differences in real-time performance and consistency of data synchronization between the present invention's solution and the traditional inventory management model. The experimental platform consists of the ledger and inventory management system as the system's functional entity, a transaction event generator to simulate real business traffic, and a simulated customs interface whose behavior can be programmed to control. The transaction event generator... The system is configured to inject a mixed business flow, including import declarations, bonded verification lists, and deletion instructions, into the system at a rate of fifty concurrent transactions per second. This rate is based on stress testing the system's maximum throughput capacity and taking 95% of the load point to ensure that the test environment can reflect the working conditions during peak business periods while avoiding functional failures due to pure server resource exhaustion. The simulated customs interface is set to introduce a 5% bonded verification list receipt loss rate after a certain point in the test to verify the system's backup interaction path and manual inventory adjustment procedures.

[0031] To establish a performance benchmark, a control group was set up in the experiment. This control group adopted a simplified inventory management logic, which only deducted a single inventory quantity after receiving a receipt from the simulated customs interface representing the end of the business process. It did not have the multi-state division of occupied and available inventory as proposed in this invention, nor did it have an automatic rollback mechanism based on the business order number. At the start of the experiment, the proposed system and the control group system were loaded with the same initial conditions, that is, for the same customs-registered material number, an initial ledger inventory quantity and available inventory quantity of 10,000 units were set. After the experiment started, the transaction event generator began. During the initial phase of the test, the available inventory of the system decreases in real time as the bonded declaration list is generated, while the occupied inventory increases accordingly. The sum of the inventory in the ledger, the available inventory, and the occupied inventory remains constant, while the available inventory of the control group system remains unchanged. When the test runs for 100 seconds, the transaction event generator injects a deletion instruction for the initial inventory, requiring the deduction of 500 items. At the same time, the simulated customs interface begins to execute the receipt loss policy. At this time, the key data of the two systems and the simulated customs ledger are observed, and the status comparison is shown in Table 1.

[0032] Table 1: Comparison of status data of the test system at key time nodes.

[0033] According to the status recorded in Table 1, after the deletion command was issued at the 100th second, the exception handling module of the present invention responded immediately, and the available inventory was updated synchronously from 4,500 pieces to 4,000 pieces. Its total inventory in the ledger was 9,500 pieces, which was consistent with the balance of the simulated customs ledger. However, the available inventory of the control group system was still 10,000 pieces, which had deviated from the balance of the customs ledger. At the 105th second, when the operators processed the lost receipts through the manual inventory adjustment function of the present invention system, the available inventory was further accurately deducted. The control group system did not update the inventory based on the partial receipts it received until the 120th second, and its data status was delayed and uncertain. The discrepancy in this state arises from the multi-state inventory model and event-driven update mechanism of the system of this invention, which enables it to absorb state changes in the business process in real time. The exception handling procedure based on the business order number provides a deterministic path for accurate data rollback. Experimental data shows that the technical solution adopted by the ledger inventory management system can maintain the synchronization between internal inventory records and external regulatory logic status under high-concurrency business and external communication anomalies. Its real-time availability of inventory and data consistency have verifiable differences compared with the simplified reference model. This result confirms that the solution provides a feasible technical path for bridging the information gap between enterprises and customs systems.

[0034] Example 3: This example combines Figures 1 to 3This section describes the implementation of a ledger and inventory management system based on cross-border transactions, such as... Figure 1 As shown, the system obtains import declaration data and bonded verification list data from the customs system, which serves as an external data source, as raw data input via the data acquisition module. This data is then transmitted to the ledger and inventory processing module, which is responsible for establishing and managing inventory records with three states: ledger, occupied, and available, and recording a complete inventory change log. On the one hand, the ledger and inventory processing module transmits inventory data to the query interaction module, which generates a multi-dimensional inventory view, outbound details, and risk warning interface to respond to enterprise users' query requests and operation instructions. On the other hand, this module interacts with the inventory status management module and the exception handling module. The inventory status management module dynamically updates the occupied / available inventory based on the verification list and binds it to a unique business order number, while responding to requests to query the inventory status. The exception handling module is responsible for performing closed-loop correction operations such as inventory rollback, manual adjustment, and disabling of part numbers. Upon receiving a deletion instruction or manual confirmation instruction from the enterprise user, it issues an instruction to the ledger and inventory processing module to perform inventory correction, thus forming a data-driven inventory management system with closed-loop exception handling capabilities.

[0035] like Figure 2 As shown, the horizontal axis represents the test time (seconds) since the start of the test, and the vertical axis represents the system response time (milliseconds). The solid line trajectory marked with circles in the figure represents the response time of the system of the present invention, which remains at a low level throughout the entire test period, demonstrating stable and efficient processing capabilities. The dashed line trajectory marked with triangles represents the response time of the control group system, whose response time shows an exponential increase as the test time progresses. This intuitively proves that the technical solution of the present invention has significant performance stability and better real-time processing efficiency compared with the traditional mode when processing continuous business requests.

[0036] like Figure 3As shown, the process begins with step 1.0, data acquisition and initialization, where the system obtains import declaration / verification list data from the customs system and generates new inventory records or pending lists, storing them in the core data storage D1: the three-state inventory ledger. Step 2.0, dynamic inventory status management, reads the pending list from this ledger and performs an update on the occupied / available inventory status, writing the changed status back to the ledger. When the business process reverses, step 3.0, exception and reverse process handling, is activated. Upon receiving a deletion command or confirmation command from the enterprise user, this step reads the records to be rolled back from the ledger and issues an inventory rollback / correction command to the ledger. Finally, step 4.0, data query and interactive response, responds to the enterprise user's query request or batch operation command, performs an inventory record query from the ledger, and organizes the query results into an inventory view, outbound details, and risk warnings for the user, collectively forming a complete business processing closed loop centered on the three-state inventory ledger.

[0037] Example 4: In an application environment where an inventory management system has been deployed and is running continuously, the static parameters initially configured in the system gradually deviate from the actual operational rhythm due to the periodic fluctuations in the processing efficiency of the external customs interface and the evolution of internal business processes. Specifically, the fixed waiting period built into the system, which is used to trigger manual inventory adjustments when no customs receipt is received, is set too sensitively and frequently triggers alarms. At the same time, its inventory anomaly screening function also generates a large number of invalid prompts about inventory occupied in normal circulation due to the broad logic rules. This kind of alarm redundancy caused by parameter mismatch and the limitations of logic rules is evident. This poses a challenge to system availability. To address the technical issue of system performance drift caused by dynamic environmental changes, the system integrates a set of parameter adaptation and logic refinement calibration procedures. Regarding the setting of the waiting period, the system abandons fixed time values ​​and instead adopts a dynamic threshold calculation method based on historical data statistics. Its ledger and inventory processing module continuously records the time interval from sending each bonded declaration list to receiving the customs receipt, forming a time delay sample sequence. The system performs statistical analysis on the most recent 1,000 valid delay samples at a 24-hour cycle and uses its 99th percentile value... Determine the waiting period threshold for the next cycle. This procedure enables the threshold to be automatically adjusted to follow macro-level changes in customs processing speed.

[0038] Accordingly, for the judgment logic of inventory anomalies, the system adds a time-based constraint on the original screening rules. A record with a greater than zero occupied inventory will only be considered as an anomaly if the duration of its occupied state exceeds a dynamically calculated occupation timeout threshold. Only then is it finally marked as an inventory anomaly; The determination of this threshold is based on the analysis of historical data. The system statistically analyzes the time span from the start of the occupancy status of all outbound occupancy transactions to the final deduction or rollback of inventory. The 99.5th percentile of this time span sequence is combined with a business grace period defined as six hours to jointly determine the threshold. This refined judgment logic effectively distinguishes between normal in-transit occupancy and abnormal occupancy that requires manual intervention due to long-term delays.

[0039] When executing an inventory rollback operation triggered by a delete command, to ensure data consistency in a high-concurrency environment, the exception handling module is configured to follow an operation sequence that includes transaction locking. When a delete command for a specific business order number is received, the system first applies an exclusive write lock to the inventory record of the customs-registered material number corresponding to that business order number to prevent any other process from concurrently modifying that record. After successful locking, the module performs a reverse reversal of occupied and available inventory based on the original change record and records the complete information of this rollback operation in the transaction log. After the operation is completed, the module performs a database verification read operation. The system compares the current inventory record status with the expected status after rollback. Only after verification is the exclusive write lock on the record released. This series of procedures ensures the atomicity and isolation of inventory rollback operations. Through the built-in adaptive and verification mechanisms, the system evolves from a tool dependent on static configuration into a self-regulating system that dynamically adapts to the external environment. The accuracy of its alarms is improved, reducing redundant information that operators need to process. They only need to focus on those real anomalies that the system verifies as high-probability through refined logic. As a result, the overall operational efficiency and data management reliability of the system are enhanced.

[0040] Example 5: Before deploying the inventory management system to a new business entity or accessing a new customs ledger, a standardized data infrastructure construction procedure must be executed. This procedure first involves the offline filling of the mapping relationship between customs-registered material numbers and the enterprise's internal unified material numbers. The system provides a data import interface to receive and process the material master data exported from the enterprise resource planning system, which contains unified material numbers and corresponding commodity specifications, and the complete ledger body filing data obtained from the customs system, which contains customs-registered material numbers and gold II serial numbers. Internally, the system automatically compares and associates these two data sources based on preset fields such as commodity name, HS code, and declaration specifications. Entries that cannot be automatically associated through rules are handed over to system engineers for manual review and confirmation.

[0041] After completing the construction of the part number mapping table, the system will enter a baseline inventory synchronization phase before switching to real-time transaction processing mode. During this phase, the system's data acquisition module is configured to acquire, in one go, complete snapshot data of the ledger inventory provided by the customs system up to a specific point in time. This snapshot data includes the current legal balance quantity of all Gold II serial numbers under the ledger. The ledger inventory processing module will parse this snapshot data one by one and directly write the balance quantity of each Gold II serial number into the ledger inventory quantity and available inventory quantity fields of the corresponding inventory record, while setting the occupied inventory quantity to zero. This operation aims to ensure that the underlying inventory base recorded by the system at the initial moment of its online operation is consistent with the baseline state of the official customs ledger, thereby providing a verified starting point for the accurate processing of all subsequent incremental transactions.

[0042] Example 6: After the initial deployment and baseline data synchronization of the ledger and inventory management system are completed, and before delivery to the production environment, a standardized system verification and optimization procedure needs to be executed to ensure that its built-in algorithms and parameters are adapted to specific business scenarios. This procedure first deepens the mapping logic between customs-registered part numbers and enterprise-wide unified part numbers. For items that fail to match completely during the automated comparison process, the system will initiate a data standardization and similarity scoring process before submitting them for manual review. In this process, the product name and product specification fields to be matched are uniformly converted to lowercase characters, and preset punctuation marks and whitespace characters are removed. Then, the Jaro-Winkler distance algorithm is used to calculate the similarity score between the standardized strings. Only when the score is higher than a threshold defined as 0.95 will the system classify this pair of part numbers as high-confidence potential matches.

[0043] The next step in this procedure involves the aforementioned dynamic threshold parameter, namely the waiting period threshold. With the timeout threshold An offline sensitivity analysis and optimization were performed. The verification engineer used the experimental platform of Example 2 to inject simulated historical transaction data and systematically adjusted the percentile parameters used to calculate the two thresholds within a preset interval, from the 90th percentile to the 99.9th percentile, in increments of 0.1. In each parameter Under the given value, the system runs a complete simulation cycle and records the false alarm rate caused by an overly tight threshold. The false negative rate due to overly lenient thresholds Ultimately, through a cost function To quantify the overall risk, and to use the parameters at which the function reaches its minimum value. As the optimal percentile parameter The weighting coefficient and Based on the business's tolerance for the two types of risks, the system pre-configures the parameters. After parameter optimization, to address potential issues with concurrent external data writing during baseline inventory synchronization, the procedure includes an incremental data synchronization verification step. After the baseline inventory snapshot data is loaded, the system's data acquisition module initiates a targeted query request to the customs system. The query condition for this request is to retrieve all ledger transaction records that occurred between the baseline snapshot generation time and the current time. The system then processes these incremental transaction records sequentially, performing a final calibration of the established inventory baseline. Through this final calibration, the system ensures that its initial state fully incorporates all external state changes that occurred during the synchronization window, thereby logically closing the initial data risk exposure.

[0044] It will be apparent to those skilled in the art that the present invention is not limited to the details of the exemplary embodiments described above, and that the present invention can be implemented in other specific forms without departing from the spirit or essential characteristics of the present invention.

[0045] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and are not intended to limit it. Although the present invention has been described in detail with reference to preferred embodiments, those skilled in the art should understand that modifications or equivalent substitutions can be made to the technical solutions of the present invention without departing from the spirit and scope of the technical solutions of the present invention.

Claims

1. A ledger and inventory management system based on cross-border transactions, characterized in that, include: The data acquisition module is configured to acquire import declaration data and bonded verification list data associated with customs ledgers; The ledger and inventory processing module is connected to the data acquisition module and is configured to establish inventory records based on import declaration data. The inventory records include customs filing material numbers and Jin Er serial numbers, and correspond one-to-one with ledger inventory quantity, occupied inventory quantity, and available inventory quantity. The inventory status management module, connected to the ledger inventory processing module, is configured to increase the occupied inventory and simultaneously decrease the available inventory after receiving the bonded verification list data, and to bind this inventory change to a unique business order number. The query interaction module, connected to the ledger and inventory processing module, is configured to generate and display an inventory data interface that includes ledger inventory quantity, occupied inventory quantity, and available inventory quantity.

2. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The system also includes an exception handling module, which is connected to the inventory status management module and is configured to: when a deletion instruction for a specific business order number is received, retrieve the inventory quantity change records bound to that business order number; And based on the quantity recorded in the inventory change record, perform an inventory rollback, which specifically reduces the occupied inventory and increases the available inventory by the same amount.

3. The ledger and inventory management system based on cross-border transactions according to claim 2, characterized in that, The exception handling module is also configured to: when manual inventory adjustment is activated due to the lack of receipt of the bonded verification list acknowledgment from the customs system, receive a manual confirmation instruction for a specific bonded verification list; and, based on the quantity of goods recorded in the bonded verification list confirmed by the manual confirmation instruction, perform inventory deduction, with the update of available inventory following the rules below: ,in, To update the available inventory after performing inventory deduction, To determine the available inventory level before inventory deduction, The quantity of goods recorded in the bonded verification list.

4. The ledger and inventory management system based on cross-border transactions according to claim 2, characterized in that, The exception handling module is also configured to: after receiving a material number disabling instruction triggered by the customs' modification of the filing information, update the corresponding customs filing material number record in the ledger inventory processing module to the disabled state; In addition, when the customs filing material number record is in a disabled state, the editing permissions of the associated commodity name, HS code, country of origin, declaring unit and legal unit of measurement fields are enabled.

5. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The query interaction module is also configured to perform an inventory data screening operation, the execution rule of which is to filter out inventory records from all inventory records where the occupied inventory is greater than zero or the available inventory is less than zero. And the selected inventory records will be displayed centrally in the inventory data interface.

6. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The query interaction module is also configured to: after receiving a query request for the exit record of a certain Jin Er serial number, aggregate all the exit records of the bonded verification list associated with that Jin Er serial number; and generate and display an exit details interface containing the business order number, list number, verification list number, creation time and exit quantity of each exit record.

7. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The inventory record data structure also includes a unified part number field; the ledger inventory processing module is also configured to respond to import operations and establish data mappings between customs-registered part numbers and unified part numbers in batches.

8. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The inventory data interface generated by the query interaction module also includes a batch operation function area, which is configured to: after receiving the user's selection operation and activation instruction for multiple inventory records, set the corresponding Jin Er serial number of multiple inventory records to a status that can be used for declaration.

9. The ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The ledger and inventory processing module is also configured to record a log of each inventory change. The log includes at least the business type, business number, change quantity, available inventory after the change, and change time. The business type indicates whether the source of the change is an import declaration or a parcel exit deduction.

10. A ledger and inventory management system based on cross-border transactions according to claim 1, characterized in that, The data acquisition module is also configured to acquire release order data; the ledger and inventory processing module is also configured to integrate release order data with import declaration data and bonded registration list data to form a unified inventory flow record.

Images