Need Help?
  • Application Remote Support
  • Infrastructure Remote Support
  • Sage HRMS Remote Support
  • Helpdesk
  • General Inquiry
1-800-719-3307
Net at Work Net at Work
  • Solutions & Services
    • ERP/Accounting

      ERP Services
      Acumatica
      NetSuite
      Sage X3
      Sage Intacct
      Sage 100 ERP
      Sage 300 ERP
      Sage 500 ERP

      CRM

      Strategic Advisory Services
      Digital Marketing Solutions
      CRM Training Camp
      Salesforce
      Microsoft Dynamics 365 CRM
      Sage CRM
      Infor CRM (formerly Saleslogix)

      Employer Solutions

      Sage HRMS
      Sage People
      Criterion
      Miviva

      Enterprise Content Management

      Imaging / Scanning
      Document Management
      Workflow Automation
      Solutions

      Nonprofit Solutions

      Abila by Community Brands
      NetSuite
      Sage
      Salesforce

      IT and Security Services

      Managed IT Services
      Fractional CIO Services
      Cloud Services
      Cloud at Work
      DR/Business Continuity Planning
      Compliance & Security
      Storage & Recovery
      Networking
      IT Security Services
      Communications

      Web Solutions

      Services Overview
      B2B Technology Suite
      Magento eCommerce
      WordPress CMS
      Systems Integration
      Website Managed Services
      Online Marketing & SEO
      ERP eCommerce Integration

      Additional Solutions

      Enterprise Business Intelligence
      Avalara Automated Tax Solutions
      Fortis Payments
      LeaseQuery Lease Accounting
      Sage Fixed Assets
      Vertex SMB Sales and Use Tax
  • Industries
    • Industries

      Healthcare
      Chemicals
      Food & Beverage
      Medical Devices
      Nonprofit
  • Learning Center
    • Online Resources

      Recorded Webinars
      Whitepapers
      Ebooks

      Upcoming Events

      Live Webinars
      Seminars
      Virtual Training Courses

      Training Courses

      View all available training course options
  • Company
    • Why Us

      Who We Are
      Management
      Our Partners
      Locations
      Careers

      News

      Press Releases
      Success Stories
      Net at Work Blog

      Contact Us

      1.800.719.3307
      Email Us

      Programs

      Alliance Partnership Program
      Women at Work
      Diversity and Inclusion
  • Blog
  • Contact Us
  • Contact Us

Home » Newsletters » Sage 300 Newsletter – December 2015 » Integrating Other Systems with Sage 300

Sage 300 Newsletter – December 2015

Keeping You Up-To-Date With Information About Sage 300

Integrating Other Systems with Sage 300

By: Feng Lin, Software Developer

featured-img-sage-300-integrationsThis short article is a brief and high level description of Integration for Sage 300.

By definition, systems integration is the process of linking together different computing systems and software applications physically or functionally, to act as a coordinated whole.

It is common for companies in all industries to have needs to integrate their systems, so that everybody in the company can work with the same data, follow the same workflow, and eliminate double data entry to improve productivity and efficiency.

Sage 300 Native Integration Capability

Sage 300 provides native data file import and export capability to allow customers to import to Sage 300 and export from Sage 300. Data files can be in Excel or other formats. Such capability is built in the product and is a manual process for Sage 300 users.


Net at Work Integration Capability

Sage 300 also provides APIs to allow our developers to develop custom integration software, to serve our customer base, which includes hundreds of companies from different industries.

Knowing that integration means different things to different companies, our Sage 300 consultants can provide guidance and support to identify the integration points, and our developers can provide options of how to best integrate systems for our customers.

Below are the major discovery questions for integration projects when we look at an opportunity to assist our customers:

  • What systems are we looking at to integrate with Sage 300?
  • Pull Sage 300 data for other system to consume? Or Push a transaction to Sage 300?
  • What system interface can the source system provide for Sage 300 to use, when data push to Sage 300 is required? E.g. SQL server database, flat\CSV files or Excel files, or system APIs
  • What system interface is expected, when data pull from Sage 300 is required? E.g. Data file with specific specifications, SQL database objects (table, views, stored procedure)
  • What Sage 300 modules to integrate with? E.g. Operational module or Accounting module
  • Manual process to execute the integration process? Or fully automated process to work seamlessly?

A lot of times, we are looking at the opportunity to eliminate double data entry and move data from a system to Sage 300. Such integration process sometimes introduces a translation process of some sort to convert data for Sage 300 to use, e.g. convert GL account by appending a GL segment for Sage 300 GL entry, or convert the product sku # to Sage 300 item number. We can also encapsulate more complicated business rules for customers in integration projects.

With many custom integration applications being used by many customers, our custom developed integration projects can be one of these options to fit customers’ needs:

  • Sage 300 VBA macro
    • Capability natively shipped with Sage 300 product
    • VBA programming skills
    • Manual process to execute by Sage 300 users
  • Microsoft .NET windows application
    • More complicated windows application to allow Sage 300 users to select and set parameters before execute the import or export
    • Complicated customers’ business rules can be encapsulated, e.g. data translation or filtering
    • Current in technology
    • Provide system longevity
  • Microsoft .NET windows service application
    • For fully automated and close to real time integration process
    • Complicated customers’ business rules can be encapsulated, e.g. data translation or filtering
    • Current in technology
    • Provide system longevity

Below are some of the screenshots of our integration projects:

Sage 300 macro

.NET windows application

.NET windows service application

Have an integration requirement? We can help. Call us today (800.719.3307) to find out how our custom development team can help you improve efficiency by reducing or eliminating redundant data entry tasks.

« Return to Newsletter

In This Issue
  • From the Desk of the Sage 300 Practice Director
  • Sage 300 Report Writing
  • Sage CRM 7.3 New Features Overview
  • Integrating Other Systems with Sage 300
  • Sage 300 Tips and Tricks: Searching in Sage 300 – Advanced!
  • Warehouse Management for Sage 300 by AccellosOne
  • What About Windows 10?
  • Sage 300 General Ledger Year End Steps
  • Sage 300 Support

    Helpdesk:
    P: 888.494.9479
    E: helpdesk@netatwork.com

    Sage 300 Webinar Series

    Tips for Sage Users to Improve Data-Driven Decision-Making
    March 28 | 2pm ET
    Register Here

    Recruiting & Quiet Hiring: What Quiet Quitting / Hiring Means for 2023 & How Technology Can Help
    March 28 | 2pm ET
    Register Here

    Sage-Integrated Document Management: From Chaos to Control
    April 7 | 2pm ET
    Register Here

    Sage Intacct Overview Demo
    April 7 | 2pm ET
    Register Here

    Popular Recorded Webinars

    Sage Cloud Hosting: Moving On-Premise Sage 300 to the Cloud

    Building a Next Generation Finance Organization with Next Gen ERP Tools

    Reducing Manual Tasks in Your Sage Accounting & Shipping Processes

    Bridge Your Sage 300 Gaps

    Sage 300 Webinar Archive

    View our library of on-demand recorded webinars.

    Newsletter Archive

    Read our previous Sage 300 Newsletters here

    Connect With Us

    Business Applications

    • Overview
    • ERP/Accounting
    • Cloud ERP
    • CRM
    • Employer Solutions
    • ECM
    • Nonprofit Solutions

    Learning Center

    • White Papers & Guides
    • Ebooks
    • Training Courses
    • Virtual Training Courses
    • Success Stories
    • Live Webinars
    • Recorded Webinars
    • Trials

    Infrastructure Solutions

    • Overview
    • Solutions
    • Managed IT Services
    • Fractional CIO & Advisory Services
    • Cloud Services
    • Cloud at Work
    • Compliance & Security
    • DR/Business Continuity

    Support

    • Application Remote Support
    • Infrastructure Remote Support
    • Sage HRMS Remote Support
    • General Inquiry
    • Helpdesk

    Web Development

    • Services Overview
    • Magento eCommerce
    • WordPress CMS
    • Systems Integration
    • Website Managed Services
    • ERP eCommerce Integration

    Company Information

    • Why Us
    • Alliance Partnership Program
    • Women at Work
    • Diversity and Inclusion
    • Partners
    • Careers
    • News
    • Blog
    • Privacy Policy
    • Contact Us

    Additional Solutions

    • Enterprise Business Intelligence
    • Avalara Automated Tax Solutions
    • Fortis Payments
    • LeaseQuery Lease Accounting
    • Sage Fixed Assets (Sage FAS)
    • Vertex SMB Sales and Use Tax

    Industries

    • Healthcare
    • Chemicals
    • Food & Beverage
    • Medical Devices
    • Nonprofit
    Net at Work
    Net at Work (HQ)
    575 8th Ave
    New York, NY 10018

    P: (800) 719-3307
    info@netatwork.com
    Locations Across North America »
    Visit our sister companies:
    Cloud at Work - Sage Application Hosting
    Pixafy - An eCommerce Agency
    Docutrend
    WordPress Image Lightbox Plugin