Skip to main content

SYSPRO Integration Overview

Overview​

The MepApps.Dash.Inv.Batch.MiniMrpOrderCreation dashboard integrates deeply with SYSPRO ERP version 7/8, leveraging the MepDash module infrastructure to provide seamless inventory management and purchase order creation capabilities. The integration uses SYSPRO's E.net architecture for business object posting and direct database access for real-time data queries.

Key Integration Points​

  • Purchase Order Creation: PORTOI business object for order posting
  • Inventory Management: Direct access to InvMaster, InvWarehouse tables
  • Supplier Management: Integration with ApSupplier and related tables
  • Custom Tables: CG_InventoryOrdering_View for MRP calculations
  • Session Management: SYSPRO E.net session handling

Architecture Overview​

The integration follows a layered approach:

  1. Data Layer: Entity Framework and Dapper for database access
  2. Business Object Layer: XML-based communication with SYSPRO
  3. Session Layer: Authentication and session management
  4. Transformation Layer: Data mapping between .NET and SYSPRO formats

Implementation Details​

SYSPRO Version Compatibility​

  • Supports SYSPRO 7.x and 8.x
  • Uses E.net Business Objects
  • Compatible with SQL Server 2016+
  • Requires appropriate SYSPRO licenses

Database Integration​

Direct database access for read operations:

  • InvMaster: Stock master data
  • InvWarehouse: Warehouse-specific stock data
  • ApSupplier: Supplier information
  • PorSupStkInfo: Supplier stock information
  • Custom views for MRP calculations

Business Object Integration​

XML-based posting through PORTOI:

  • Purchase order header creation
  • Multiple line item support
  • Tax code handling
  • Due date management

Best Practices​

  • Always validate SYSPRO session before operations
  • Use transactions for multi-step operations
  • Handle SYSPRO-specific errors gracefully
  • Log all integration events for audit trails