SYSPRO Customization
Overview
This document details the customizations made to SYSPRO for the EFT Remittance Dashboard, including custom tables, forms, reports, and scripts.
Key Concepts
- Custom Tables: Application-specific database objects
- Custom Forms: UI extensions in SYSPRO
- Custom Reports: SSRS report definitions
- SQL Scripts: Database deployment scripts
- Configuration Files: XML and JSON configurations
Custom Tables
MepAppsApEftRemittanceAudit
Audit table for tracking remittance activities with comprehensive logging of user actions and system events.
Custom Forms Integration
The dashboard registers as a custom form in SYSPRO's menu system, appearing under Accounts Payable > Reports.
Report Customizations
Custom SSRS reports for remittance advices with dynamic formatting and company branding.
Deployment Scripts
SQL scripts for creating custom database objects and initial data setup.
Configuration Management
XML and JSON files for configuring dashboard behavior and integration points.
Best Practices
- Document all customizations
- Version control custom objects
- Test in multiple environments
- Maintain upgrade compatibility
Summary
Customizations extend SYSPRO's capabilities while maintaining compatibility and upgradeability, providing specific functionality for EFT remittance processing.