Print Page E-mail Page Link

0 Customer Ratings
N/A
Extender
Click to view the help.
Configure, Customize, Develop - Manage Sage 300 business logic
Real time updates to integrated solutions simpler, faster
Added security, validation of data
Monitor changes to data & initiate events - alerts
Create "SDK" modules
Compatible With: Sage 300 ERP [Accpac], Versions 6.1 , 2014
Created by:

Retail Price: Request a price list by emailing info@orchidsystems.biz
Price for Add. User: N/A Uses Sage 300 Lanpaks
Demo Price: No charge


DetailsProduct SpecificationReviewsAdditional Documents
Extender, developed by Orchid Systems, is a multi function module that allows you to extend the functionality of Sage 300 in many different ways. Extender allows you to:
  • Configure events to enable alerts, log changes and monitor changes in Sage 300 Data.
  • Customize scripts to automate business processes, enhance systems integration & provide tailored validation & alerting by extending Sage 300 Business Logic (Views).
  • Develop Custom Tables and Custom Screens which form part of the Sage 300 database and database dictionary to tailor the core system to meet a Customer's exact needs.
Extender is available in three versions:
Configurator - features available with no coding required:
  • Track Sage 300 tables & fields - for integration, monitoring and logging purposes
  • Trigger events when tables/fields change, eg send email, run a program
  • Drill down into changes recorded in Logs  - without leaving the screen or running reports
  • Notes to be created for Orchid Notes, based on tables/fields changing
Customizer - includes Configurator and enables company specific functionality to be applied via scripts to any Sage 300 View. e.g.
  • Check mandatory fields, apply specific field validation or defaulting initial field values
  • Create files based on the insertion or change of a Sage 300 View or View field
  • Configurable security - per user per Sage 300 View
Developer - includes Customizer and allows:
  • Create your own Sage 300 Views - with associated View calls, underlying database table in the Sage 300 Company database and maintain the Sage 300 database dictionary
  • Use the Custom Table editor to create, update and delete the data in your Custom View - or write scripts to tailor the Custom Table editor
  • Associated Custom Tables, Scripts and Events by Module ID for easy deployment
Extender operates across all Sage 300 modules, and 3rd party modules written in the SDK 

FEATURES & BENEFITS
Configurator

Alerting, Monitoring, Logging
  • Enhanced auditing capability on any tables, any field, at any time, logging what changed, by whom, and when
  • Alerting nominated party via email or Note when data changes
Integration
  • Synchronize faster, more efficiently, in real time between systems, only update the changes but not unchanged data
  • Conserve bandwidth when synchronizing to Cloud solutions
Customizer
Automation

  • Facilitate automation of linked processes & triggering events
  • Save time reporting changes to critical fields
Validation of Data
  • Improve accuracy & reliability of captured information by using scripts to validate and/or provide default data for required fields
Security
  • Enhance security with system logging & custom security scripts
  • e.g. Apply security at a Field level
Developer
Database Consistency

  • Custom tables preserved as part of the Sage 300 company database
  • Thus included in Database Dump & Load operations, & other database backup methods
All Versions
Cost effective Customization

  • Enhance the value of existing Sage 300 implementations in a simple, economical way, such as creating new screens without needing complicated programming
  • Save time & cost with version independent scripts accessible in all Sage 300 modules, & 3rd party applications written in the Sage SDK
  • Provide SDK customization without needing to know all the components of the Sage 300 SDK
HOW IT WORKS
Extender monitors changes made to specific data in a Sage 300 (Accpac) View as it happens. 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 of the view fields.
  • Create or maintain a Note (Information Manager Note) using a pre-configured Note template which can contain any pre or post update 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 augments View functionality, and facilitates the creation of new screens by providing two APIs:
  • View API – allows custom Python® scripts to subclass Sage 300 Views, make use of a suite of SDK View calls, and implement business specific logic at the data-level.
  • Screen API – allows custom VB screens to be constructed through the use of Python scripts, making use of Sage 300 Screen controls, without the need to develop the UIs using VB or VBA.
Through the View API, an Extender script can perform the following on a View:
  • Check which View fields are changing, and apply the required logic.
  • Check which View operation is occurring, and apply the required logic.
Developer (in addition to Customizer functionality) can:
  • Create tables in the associated Sage 300 company database and database dictionary.
  • Provide View functionality for your custom tables.
  • Amend custom tables (such as resizing, adding or removing fields) while preserving existing data.
EXAMPLES
Examples of logic which can be applied are:
  • Create a CSV file for the external warehouse showing the shipment address and included products when a OE Shipment record is created.
  • Check who the logged on user is when the AR Credit limit is changed.  If the user doing the change is “Joe”, only allow the Credit limit up to a value of $10,000.  But if the user is “Jack”, allow the Credit limit up to a value of $20,000.
  • Only respond to changes to a Vendor’s name, address, or contact information and execute external applications that synchronize the Vendor’s on-line details.
  • Create a table to store comment templates for items, to be auto-inserted onto Order Item comment or instruction lines when the Item is added to the order.

Industries: Non-Industry Specific

Business Needs: Integration/Synchronization, Security, Productivity Tools, Security, Usability Improvements