Data Linkage Support System for Accounting Consolidation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The existing data conversion systems for consolidating accounting data between parent and subsidiary companies face high costs and inefficiencies due to frequent changes in data definitions and specifications across different countries, requiring frequent system updates and modifications.
Innovation Solution
A data linkage support system that includes a storage device for process object and specification tables, allowing users to select and correlate data items through an interface, generating conversion parameters for accounting data between subsidiary and parent companies, thereby simplifying data conversion and reducing the need for extensive system modifications.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a data conversion process is established to handle different data specifications across countries, then data consolidation between parent and subsidiary companies is enabled, but the system requires frequent updates and modifications due to changing data definitions, resulting in high costs and efforts
Solution Approach 1:
The patent introduces an interface table as an intermediary structure between the transaction data table and the accounting data table. This interface table stores conversion parameters that map source data items to target data items, allowing the system to adapt to different data specifications across countries without modifying the core conversion logic. The intermediary layer absorbs the complexity of data specification changes while maintaining a stable overall system architecture.
Solution Approach 2:
The patent implements parameter-based configuration where data conversion rules are stored as conversion parameters in the interface table. Instead of hardcoding conversion logic, the system uses configurable parameters (source item name, target item name, conversion formula) that can be easily changed to accommodate different country-specific data specifications. This allows flexible adaptation through parameter modification rather than system reconfiguration.
2Productivity
If the system is designed with fixed data conversion rules, then the conversion process is simple and efficient, but it cannot adapt to frequent changes in data definitions across different countries
Solution Approach 1:
The patent transforms the static data conversion rules into a dynamic configuration system. The interface table stores conversion parameters that can be dynamically updated based on changing data definitions in different countries. The system maintains efficient conversion processing while introducing flexibility through configurable parameters, allowing conversion rules to adapt to new requirements without performance degradation.
Solution Approach 2:
The patent creates a universal data conversion framework that can handle multiple data specifications from different countries through a single interface table structure. The same conversion mechanism serves multiple purposes by storing different conversion parameters for different country-specific data definitions, eliminating the need for separate conversion systems for each country while maintaining efficient processing.
3Adaptability or versatility
If frequent system updates are performed to accommodate changing data definitions, then the system can adapt to new data specifications, but it requires considerable costs and efforts from system developers
Solution Approach 1:
The interface table serves as a mediator that isolates the core conversion logic from data specification changes. When data definitions change in different countries, only the conversion parameters in the interface table need to be updated, not the entire conversion system. This intermediary structure protects the main system from frequent updates while maintaining adaptability to new data definitions.
Solution Approach 2:
The patent uses the interface table as a copy of conversion parameters that can be independently modified. Instead of modifying the original conversion logic, the system creates and maintains a copy of conversion rules in the interface table that can be easily updated to match new data specifications. This copying approach allows flexible adaptation without affecting the core system stability.
4Adaptability or versatility
If the system architecture is made flexible to handle various data specifications, then adaptability to different countries is improved, but the technical restriction and complexity of the system increases
Solution Approach 1:
The patent segments the data conversion function into two distinct parts: a stable core conversion logic and a flexible parameter configuration layer (interface table). This segmentation allows the system to maintain simple, stable core logic while introducing flexibility only where needed in the parameter configuration layer. The separated architecture reduces overall system complexity while maintaining adaptability.
Solution Approach 2:
The interface table acts as an intermediary that bridges the stable core conversion logic and the variable data specifications. By placing conversion parameters in this intermediate layer, the system achieves flexibility in handling different country-specific data definitions without increasing complexity in the core conversion logic. The intermediary absorbs the variability while protecting the core system from complexity.
Data Source
AI summary
A data linkage support system is disclosed that includes a storage device storing a process object table and a specification table, and an arithmetic device that displays a screen including display of a data item prescribed by specification information of the specification table and an item selection interface accepting selection of a corresponding data item in the process object table to be correlated with the data item and that correlates the corresponding data item selected in the item selection interface with the data item prescribed by the specification information to generate and store a conversion parameter of accounting data between the consolidated subsidiary company and the parent company into the storage device.