In response to long-standing development challenges encountered when working with integrated external systems, we recognized the need for a solution to manage external keys, such as customer numbers, sales order numbers, and invoice numbers, within CyberStore for SYSPRO.

Problem

Working with integrated external systems, particularly SYSPRO, has posed challenges in managing formatting rules for external keys. For example, numeric keys with leading zeros are stored in SYSPRO databases but need to be displayed differently in CyberStore. Manually managing these formatting rules has introduced complexity and potential errors in development.

Solution

To address these challenges, we've introduced the ReferenceKey Module in CyberStore. This module functions without a user interface and utilizes definitions from the external system, such as SYSPRO configuration, to manage formatting rules for external keys. The module loads the definitions, stores the information, and utilizes the ReferenceKey class to transform keys between systems logically.

The ReferenceKey class includes methods for formatting and naturalizing key values, ensuring accurate representation across the application. Additionally, the module synchronizes formatting rules from SYSPRO to maintain alignment between systems.