Link Technologies - LinkSOFT Documentation Link Technologies - LinkSOFT Documentation Overview
Integration within the LinkWeb Application Portal is a fundamental module designed to facilitate seamless data exchange and synchronisation between LinkSOFT applications and various external systems. This crucial functionality enables businesses to maintain consistent information, streamline operational workflows, and achieve compliance across diverse financial, human resource, and operational platforms. It encompasses a range of methodologies, allowing for robust and efficient data flow to support integrated business environments.
Integration Methodologies and Supported Systems: LinkSOFT supports various integration methodologies, including file export for Financial Management Information Systems (FMIS), direct SQL API connections, and Web API for more advanced integrations. It integrates with a broad spectrum of external FMIS and Enterprise Resource Planning (ERP) systems, such as Netsuite, MYOB AccountRight V2, Xero, Epicor 10, Sage 300, and JIWA 7.2. These integrations facilitate both one-way data import, for instance, from FMIS to LinkSOFT for inventory master files, and two-way data synchronisation for various transactional and master data.
Integrated LinkSOFT Modules: The module allows key LinkSOFT functions to interact with external systems. Asset Management sends asset activities and journal entries. Payroll pushes payroll journals and creditor invoices to external systems, handles various statutory submissions like ATO Single Touch Payroll (STP), and generates electronic files for banks such as ANZ, BRED, BSP, HFC, and WBC, as well as superannuation funds like FNPF and SINPF, incorporating country-specific rules, including new file formats for BRED bank. Time Management creates billable time entries as sales orders for external invoicing, with TNA device setup migrated to Integration Setup. Point of Sale integrates with financial systems for sales orders, receipts, adjustments, inventory adjustments, shift variances, and cash movements, supporting scenarios where inventory control is managed either within LinkSOFT or the financial system, and can restrict data flow by customer category and location. Tax Monitoring System (TMS) integration, such as FRCS SDC for Fiji, is used by LinkSOFT to sign tax invoices, including those raised in external systems, managing invoice numbers, QR codes, and integration failures, as well as VMS certification for Samoa. The Helpdesk module can also integrate via Mail Web API for efficient email import.
LinkSOFT API and Data Transmission: The LinkSOFT API serves as a modern framework for data transmission, specifically designed to handle data exchange between two LinkSOFT databases, replacing older methods that relied on "Linked Servers." This API supports integration with Time & Attendance devices for importing timesheet data and is built to accommodate integration with other external systems. It offers configurable settings, including Base URL, API Key, Username, start and end times, delay between calls to handle throttle limits, and payload size to manage the volume of data transmitted in each API call, with a cap, for instance, at 20MB. Security for the API is based on Security Tokens defined and managed within the system, and a health check verifies the SQL API version before integration continues.
Configuration and Management: The "Integration Setup" menu is the central point for configuring all integration rules. This includes enabling specific integration rules, configuring parameters like the "Last Read Date from FMIS" and "Last Read Record Number" to manage data synchronisation, and setting up any additional integration-specific settings. The Integration module in the Web framework has been redesigned to improve traceability and simplify workflow. The system ensures that only relevant data flows to designated locations, such as restricting specific data types from flowing to all branches in a replicated environment.
Data Consistency and Error Handling: LinkSOFT's integration capabilities are designed with data accuracy in mind. It includes features to prevent duplicate transactions from external systems and validates data to ensure consistency, for example, checking for valid tax codes or creditor currencies. Integration failures are meticulously recorded in "Integration Notes" within the framework, providing traceability and enabling administrators to re-process failed transactions or take corrective action. The module also features health checks to verify the SQL API version before continuing with integration processes.
Licensing: An API license is required to access various integration functionalities. This includes integration between LinkSOFT and external applications like MYOB, Netsuite, Xero, SAGE, JIWA, and Epicor, as well as for Time & Attendance devices to import data into timesheets, and for Replication to create server connections for data replication in LinkPOS. If the necessary license is not active, these functionalities are automatically hidden.
Integration contains the following menus: