Configure notifications when data changes
Customise Sage 300 business logic without complex code
Develop your own Views and Screens without the complexity of SDK

Do you have business or integration requirements that can’t be met by ‘out of the box’ Sage 300 functionality?

  • Are you shocked by high costs associated with software development and upgrades, or worried about adding complexity and risk by introducing solutions that sit outside your ERP system?
     
  • Did you know there is now a cost-effective way to introduce bespoke business logic, from simple validations and alerts through to custom screens and tables, or integration with external applications, all held within your Sage 300 database?

What is it?

Extender allows you to extend the functionality of Sage 300 (Accpac) in many different ways.

It is available in four versions:

Runtime

Load and run Extender Certified Apps

Configurator

Configure Events to monitor changes in Sage 300 data, log changes, enable alerts (via email or Orchid Notes), or trigger an external application.

Customizer

Customize Python scripts to automate business processes, enhance systems integration, develop Custom Screens, and provide tailored validation and alerting by extending Sage 300 business logic (Views).

Developer

Develop Custom Tables that form part of the Sage 300 database and database dictionary, tailoring the core system to meet the user's exact needs.

Benefits
  • Enhance the value of existing Sage 300 implementations through cost-effective customization.
  • A simple way to create new screens without the need for complicated programming.
  • Allows you to easily apply company-specific customizations to a Sage 300 View.
  • Save time and money with version independent enhancements.
  • Provides SDK customization, without needing to understand all the complexity of the Sage 300 SDK.
  • Enhanced auditing capability on any table, any field, at any time, logging what changed, by whom, and when.
  • Context sensitive drill down into changes recorded in Logs – without leaving the screen or running reports.
  • Python scripts & Custom Tables are preserved as part of the Sage 300 company database, and can be Dumped and Loaded.
  • Configurable security – per user per Sage 300 View.
  • Synchronize between systems more efficiently, in real time. Only update data that has changed.
  • Operates across all Sage 300 modules, as well as third party modules written in the Sage 300 SDK.

Extender business logic

 

    Features

    HOW IT WORKS

    Extender monitors changes made to specific data in a Sage 300 View in real time, and triggers user-defined actions when nominated Events occur.

    Available actions depend on the Extender version:

    Configurator

    Based on the configuration of Events for the particular View Field or View Operation (insert, update, delete or insert/update), Extender can:

    • Send an email using a pre-configured email template, which can contain any pre or post update value of the View fields.
    • Create or maintain a Note (Orchid Information Manager Note) using a pre-configured Note template, which can contain any pre or post update value of the View fields.
    • Log a change (log the date/time/user doing the change, what the original field value was, and what the new field value is).
    • Call an external program.

    Customizer

    In addition to Configurator functionality, Customizer augments Sage 300 business logic (View) functionality and facilitates the creation of new screens by providing two APIs:

    • View API – allows custom Python scripts to subclass Sage 300 business logic (Views), make use of a collection of SDK View calls, and implement business specific logic at the View level.
      (E.g. Check which View fields are changing, or which View operation is occurring, and apply the required logic.)
    • Screen API – allows custom screens to be constructed using Python scripts, making use of Sage 300 Screen controls, without the need to develop the UIs in the traditional Sage 300 way (using VB or VBA).

    The Python scripts are imported into the company database, so the customizations are backed up with the company data, and will Dump & Load with the company data.

    Developer

    In addition to Customizer functionality, Developer provides an integrated development environment, allowing you to:

    • Create your own Sage 300 business logic (Views), with associated View calls and underlying database tables in the Sage 300 company database.
    • Maintain the Sage 300 database dictionary without being an expert Sage 300 SDK developer.
    • Use the Custom Table Editor to create, update and delete the data in your Custom View – or write a script for a tailored screen.
    • Amend Custom Tables (e.g. add or remove fields) while preserving existing data.
    • Associate Custom Tables, Scripts, Screens and Events by Module ID for easy deployment between companies on one site, or across sites.

    Runtime

    Users can run only the functionality included in the Extender App they are licensed to use. Sage 300 partners can build Extender Certified Apps using  the underlying Extender functionality.

    Click here for more information

    Screenshots

    Click any image below for a larger view.

    What do our clients think?

    "I am VERY, VERY happy with the results...Having now used Extender as an Audit Logger, UI control tool, and Custom Table tool it really is the bomb!"

    IAN COOK, KERR CONSULTING, THE WOODLANDS, TEXAS, USA

    “Orchid Extender just might be the most powerful third party app ever. The sky's the limit.”

    IAN COOK, KERR CONSULTING, THE WOODLANDS, TEXAS, USA

    "Truly, my mind is overflowing with all of the possibilities of the interplay between Extender and Notes. This new relationship between them feels like such a game-changer! Sincerest kudos to you and your team - both of these modules are rapidly becoming 'must-quote' for me on new sales as it’s turning so many previous 'no's into 'yes's!"

    DAVID GELULA, GELULA CONSULTING, ILLINOIS, USA

    "Orchid's Extender, Info-Explorer and Information Manager Suite add-ons have taken Sage 300 to the next level. It's like Sage 300 on steroids!"

    NKOSIYABO SIBANDA, CCMA (THE COMMISSION FOR CONCILIATION, MEDIATION & ARBITRATION), SOUTH AFRICA

    "Thanks again for introducing me to Orchid Extender…that’s quite an incredible product you have there!"

    SCOTT DAVIES, EQUATION TECHNOLOGIES, ENCINATAS, CA, USA

    “Orchid Extender empowered me to develop simple Sage 300 customizations that would otherwise have needed to go to our development team.  With only a basic knowledge of Python, and almost no exposure to Sage 300 SDK, I was able to implement on screen validations that were very important for my customer, but not available out of the box.”

    HAYK ZARGARYAN, SYSTRONICS