dataEssence logo
Toggle Menu

dataEssence...the software product of choice for flavour, fragrance and essential oils companies worldwide!

A high performance software product, dataEssence can improve the profitability of your business through better sales opportunities, reduced costs and increased management control. dataEssence can also be integrated with your accounting software to provide a complete business solution from sales generation to final accounts. dataEssence is a modular system and as such is fully scaleable, so giving you the flexibility to buy as many of the modules (and user licences) as your business requires and increase this as the needs of your business grow.

Many aspects of dataEssence screens, databases, reports and documents can be tailored by you to meet the initial and evolving needs of your business, but we can also provide more extensive tailoring or integration with your existing systems if required. The rich functionality of the product is supported by the high level of security you need to protect your vital data and powered by a high performance multi user database that delivers the speed to keep pace with your business. dataEssence delivers benefits in the following areas;

 

Research and Development

You create, and let dataEssence do the rest...

Formulations & Regulatory

At the core of dataEssence is the powerful, feature rich, formula development system. This provides the essential tools to address the needs of the formulator and to develop and maintain your formulations. The automated regulatory & status calculations and documentation will be especially appreciated by those of your staff who currently produce these manually.

Key Features

  • Calculation of key regulatory issues - FEMA, IFRA, GHS / CLP.
  • Create Safety Data Sheets (SDSs), IFRA Conformity Certificate's, Allergen Analysis and Ingredient Declarations, Labels.
  • Saves time and improves accuracy by helping perfumers, flavourists and formulators to develop new formulations.
  • Keep thousands of formulas in a compact, easy to search system, with lots of user friendly tools to help manage your raw materials, ingredient lists and complex formulations.
  • Create and manipulate multi-level formulations.
  • Track the development process with full formulation history.
  • Virtual formulae, for use when the mixture is not the sum of it's parts, for example “process formulations” and spray drying.
  • Rationalise and consolidate your formulations for efficient compounding.
  • Provide the total cost per Kg whatever the total of the items.
  • Where a formulation is used as a base or a solution, it can be flagged and will remain intact.
  • Reports, including trial works orders, specification sheets.
  • Automated calculation of status for formulations, e.g. “is it organic?”.
  • User defined formulation screening scenarios.

Stock & Raw Materials Library

This module will enable you to enter and manage the stock codes required for use in raw materials and your formulations.

Key Features:

  • Comprehensive search facilities with Excel export.
  • Average, latest and forward costs.
  • Minimum stock levels & period usage.
  • Full user control over the NCS breakdowns.
  • Variable QC tests for each stock code.
  • Packing, transport & labelling information.

Back to top


Sales and Marketing

Applications and Evaluations

This module will allow you to evaluate your formulation and note its characteristics when used in a variety of applications. As formulations are developed and tested your company is building a vast library of fragrances and flavours supported by test data, which you can search when answering briefs.

Key Features:

  • Optimise your formulator’s time.
  • No more missed opportunities or developing duplicates.
  • Search based on many criteria including: cost, application area and characteristics.
  • Fragrance / flavour profile with primary and secondary characteristics.
  • Client-definable list of areas of application with sub-divisions.
  • Record the result of the evaluation.
  • Separate / Multiple evaluations possible for each area.

Briefs and Submissions

All sales activities start with a customer brief which will be the result of either direct or indirect sales activity, or from existing customers. This module provides real benefits in the initial part of the sales cycle by managing the sales projects / briefs, recording the submissions to clients and also their feedback.

Key Features:

  • Record details of your customer's Brief / Project requirements.
  • Comprehensive search of your fragrance or flavour library to assist in answering a Brief or Project ("have we created something similar before ?").
  • Search facility by Brief / Project number from a list of submissions.
  • Brief / Project reports for management control i.e. Briefs / Projects received, answered or outstanding.
  • Ability to store Windows documents against each Brief / Project.
  • Record customer feedback against your submissions.

Back to top


Business Systems

Sales Order Processing

All sales orders are based on an individual price list for each customer with the ability to record the customer’s own coding and descriptions. Multiple prices can also be recorded for each product to reflect any special terms or quantity breaks negotiated. When the products are ready for despatch the dataEssence Sales Order Processing module will allow you to produce all the relevant documentation including Invoices, Delivery Notes, Certificates of Analysis, Specifications, Address Labels and GHS/CLP Drum Labels. Generally, all dataEssence documents are custom-designed for each installation, recognising that in the sales environment it is of particular importance that these accurately reflect the image of the company.

Key Features:
  • Ability to store Windows documents against each customer and for each sales order.
  • Automated generation of the appropriate batch and stock transactions.
  • Automatic updating of all the appropriate stock levels.
  • Comprehensive sales order search facilities with Excel save feature.
  • Intrastat.
  • Optional sales contract orders.
  • Optional back to back sales and purchase orders.
  • Full and part deliveries.
  • Automatic or manual selection of batches to be despatched.
  • Printing, email and saving of sales order documents.
  • Comprehensive viewing of relevant management information including Sales History for Each Customer, Full Stock Details and Alternative Customers.


Customers and Products

All client documentation, including safety data sheets and specifications, will accurately reflect client codes and descriptions and can keep the formulation codes confidential. All sales orders are based on an individual price list for each customer with the ability to record the customer’s own coding and descriptions. Multiple prices can also be recorded for each product to reflect any special terms or quantity breaks. This gives you the ability to see who you supply, with which products and at what prices.

Key Features:
  • Control over who you supply, with which products and at what prices.
  • Multiple delivery addresses per customer.
  • Multiple negotiated prices per material or product sold per customer.
  • Multiple customers for any material or product.
  • Export invoices and credit notes to external accounts system (Optional).
  • Comprehensive viewing of relevant management information including Sales History for Each Customer, Full Stock Details and Alternative Customers.

Suppliers and Purchase Order Processing

Details of products, pricing and supplier information are held against each supplier within dataEssence thus allowing purchase orders to be raised. This allows not only individual pricing and coding details but also the recording of material approvals and the automatic production of the material specifications. All purchase orders are based on an individual price list for each supplier with the ability to record the supplier’s own coding and descriptions. Multiple prices can also be recorded for each product to reflect any special terms or quantity breaks. dataEssence can display all the potential suppliers and historic purchase orders to help in the choice of supplier for the next order.

Key Features:
  • Control over who supplies you with which raw materials and at what prices.
  • Add, amend and delete details of suppliers of materials and products.
  • Ability to store Windows documents against each supplier and each purchase order.
  • Multiple prices per material or product bought per supplier.
  • Records the suppliers’ stock code in addition to the dataEssence stock code.
  • Automated generation of the appropriate batch and stock transactions.
  • Automatic updating of all the appropriate stock levels.
  • Optional back to back sales and purchase orders.
  • Full and part deliveries.
  • Printing, email and saving of sales order documents.
  • Recording of added delivery costs on receipts.
  • Reflection of added costs in batch costs.
  • Purchase order returns for unacceptable deliveries.
  • Comprehensive viewing of relevant management information including Purchase History for Each Supplier and Alternative Suppliers.

Works Orders

Products may be manufactured for stock or linked to a specific Sales Order item. Prior to raising a full Works Order, dataEssence can display or print Trial Works Orders to show the quantity of each stock item required for manufacture to indicate any potential shortages.

For each Works Order, the user can specify the batches to be used (where Batch Tracking is in operation) or allow batches to be automatically allocated by dataEssence. Details of the batches to be used are printed on the Works Order documentation and material usage is recorded in the stock system. The raw materials are listed on the Works Order in the order in which they should be prepared and mixed, thus ensuring the compounder can work in the most efficient way. Additionally, any special mixing or safety instructions are clearly printed on the Works Order. Once the Works Order has been completed the QC results for this batch can be recorded against the product.

Key Features:
  • Create Works Order’s either back to back against Sales Order items or for stock.
  • Rationalise and consolidate your formulations for easy compounding.
  • Any special mixing or safety instructions are clearly printed on the Works Order.
  • Automatic adjustment for yield quantities – total or Works Order items.
  • Optional warehouse location for manufacture.
  • Packaging details and comments on each Works Order.
  • Optional expansion of bases & sub formulas within Works Order’s.
  • Optional automatic generation of auto production instruction file.
  • Automated generation of all the appropriate batch and stock transactions.
  • Automatic adjustment transactions for over/under manufacturing and yields.
  • Automatic updating of all the appropriate stock levels.
  • Comprehensive viewing of relevant management information.

Stock Control and Batch Tracking

This module provides a simple method for recording such items as: stock levels, costs, ordering details, physical properties, risks & hazards, QC tests, specifications and transport information.

Key Features:
  • Management of Stock at Batch level for raw materials and mixes
  • Control of Stock at Drum level (Optional)
  • Powerful search facilities with MS Excel support
  • Key identification codes for each batch, user input (or automatically generated)
  • Date when the batch was received or created
  • Expiry date
  • Sundry transactions (in, out and transfer)
  • Quantity In, Out (Optional; and In QC, )
  • Ability to block the use of specific drums within a batch (Optional)
  • QC test results against each batch
  • Certificate of Analysis
  • Comprehensive stock and batch traceability
  • Multiple warehouse locations (Optional)
  • Comprehensive viewing of relevant management information including Stock Valuation, Out of Stock and Stock Transaction History.

Back to top


System & Utility Manager

The System and Utility manager provides controlled access to the following features:

  • View current system users and system log of all key actions within dataEssence.
  • Edit System and user parameters.
  • Maintain regulatory, security and support tables.
  • Setup and run automated reports.
  • Update foreign currency costs based on exchange rates.


Backup Manager

Powerful yet easy to use backup & restore system providing single click full backups and restores of the dataEssence database. An essential addition to the system, so you can be confident that your precious data is safely backed up in the event of a problem.


More Reasons to Choose dataEssence

  • Designed and written specifically for your industry.
  • A complete business solution, which works the way you work.
  • dataEssence has the capability to fully translate your SDS and labels for your international customers.
  • Report and form designers to enable you to customise your solution to your individual needs.
  • Ability to link to other business systems for seamless integration.
  • Regular software updates to maintain your regulatory compliance.
  • Links to MAPI compliant email software to provide email capability to get your documents to your customers and suppliers faster whilst saving you money.
  • Data stored in Microsoft SQL Server, making your data easy to access and located on your PC or server, putting you in control of data security.

Tell us what systems you currently have in place, so we can better understand your specific business needs and provide you with the best solution to address these requirements. To find out more about dataEssence and how it can benefit your flavour, fragrance or essential oil business please call us on 0118 929 8216, or email us at streatley@streatley.co.uk

Streatley Software logo

Picture of a scientific flask

Microsoft logo

UK Flavour Association logo

IFRA logo

Microsoft SQL Server 2014 logo