FORMULATOR™ ERP INTEGRATOR

ERP INTEGRATOR is a series of ODBC proprietary mapping utilities designed to work with most inventory and manufacturing accounting systems.  The concept is to use FORMULATOR to do all development testing and documentation of formulas.  When a formula is ready to release for manufacturing and sales new and revised raw materials and formulas are selectively sent from FORMULATOR to the ERP Manufacturing software database.  INTEGRATOR is also designed to update cost data from the ERP accounting database of raw materials and container components to the cost records in a FORMULATOR database.  Data exchange has also been custom created to marry batch records in an ERP database with Quality Control records in FORMULATOR Quality Manager. FORMULATOR Quality Manager can also create Certificates of Analysis, then INTEGRATOR can select customer contact information from the ERP open orders by order line item & pick up customer information; and also record which customers received MSDS forms created in REGULATOR.  Currently INTEGRATOR is successfully integrated with Microsoft SQL, MySQL Pervasive SQL, Oracle, and DBII and can be integrated with most ODBC databases.  Specific integrations are available for Sage PFW (with BatchMasterPFW), CIMPRO, Adonix X3, IFS, Infinium, ACCPAC Mysis Manufacturing, Business One (SAP) Manufacturing, MS DynamicsGP Horizons Manufacturing, Ross.

What is INTEGRATOR™?

  • A Utility to allow data exchange via any ODBC-compliant data source* between transactional ERP software based on formulas and materials and cost used or developed in FORMULATOR™ and cost updates from ERP data sources.
  • Data Exchange Mapping  designed to allow the Formulating Chemist to exchange data with transaction software used in Manufacturing operations, Packaging Lines, Inventory Control, Certificate of Analysis, and Quality Control.
  • Creates a library of key data exchange points that will serve as the basis for your data exchange with full security control by those with administrative rights.
  • Allows "automatic Cost update" of your raw materials on demand from a variety of Accounting Programs.
  • Intuitive set of computer tools that makes data exchange easy to manipulate, easy to change and easy to control.

 

Why Consider INTEGRATOR™?
  • Updates materials and cost as they occur to assure that new formulations and formula modifications consider all materials and package components and that cost analysis is accurate.
  • Speed Product releases once a new formula is approved, can easily be transferred to the Operational Batch Manufacturing system, along with all of the testing and performance requirements*
  • Low cost, makes it easy to own.
  • Validates New Data, assuring accurate data entry of approved materials and formulas.
  • Fully compatible Microsoft ODBC connectivity assures ease of integration and minimum administrative requirements.
  • Can be used as formula development release historical archive for compliance validation.
  • In Most Cases INTEGRATOR can be customized and proven with your current operational transaction database**.

* Depending on the capabilities of your particular ERP system **Typical databases would include Microsoft SQL, Pervasive SQL, Oracle, Unix, DBII
This is a typical INTEGRATOR functional set-up screen. Once the logic and information to be transferred is set, INTEGRATOR will transfer materials and approved FORMULA data from FORMULATOR to a Transactional ODBC ERP Data Base and current cost back to FORMULATOR.Additional integration points with ERP Batch Tickets to FORMULATOR QC Tickets and ERP Orders to QC results Certificate of Analysis in FORMULATOR Quality Manager is available as required.

Formulator™, Regulator™, & Integrator™ are registered trademarks of Formulator Software LLC. All other manufacturers’ trademarks acknowledged.
 CAS® is a registered trademark of the American Chemical Society. Copyright © 2009 Formulator Software LLC.  All rights reserved.

28 Center Street · Clinton, NJ 08809 
 (908) 735-2248   · (908) 236-7865 FAX
EMAIL: sales@formulatorus.com

WWW.COLOR-TEC.COM
Color Instruments & Software
Batch Manufacturing Software
Learn About Color