This list reports significant bug fixes and enhancements to the FORMULATOR suite added since February 2009 in addition to the improvements listed in V4.8 to V5.1.  All 5.2 fixes and new functions have been tested both by our staff and by live field installations.

GENERAL – Version 5.2  Release

Version 5.2 continues the rework of the Formulation Maintenance user interface functions changes and adds significant new utilities that enhance FORMULATOR in the Lab, for MSDS development and for small business Production & Inventory applications.  Version 5.2 has been running daily in multiple Beta sites for more than 8 months.  It was released to accounts that needed the new functions as they were added.  Accounts that updated to any version 5 upgrade will only need to upgrade their server installation.  Accounts that are still running version 4 or 3 will also have to upgrade their client computer installations.  We recommend that all accounts no matter which version they are running, including version 5.2, upgrade to the latest 5.2 release.  All upgrades update directly to the current version, there are no intermediary steps.  There is an automated database upgrade from version 5.0 or 5.1 installations.  Upgrades from version 3 or 4 will have their databases automatically converted to the new version 5 structure when first running Version 5.2 but may need some support during the upgrade.  We recommend a training session for version 3 and 4 upgrade accounts.

All new functions have been documented and HELP screens created to aid the User to better understand the new functions.   The Knowledge Base has been extended to include new features and can be called by Licensed Users from the HELP file.  The Knowledge Base is designed to answer many of the common questions asked by our clients and guide them as they grow their knowledge of FORMULATOR. Now separate HELP files for Chemical/Cosmetics vs Nutritional/Pharmacutical versions.

A Summery of Enhancements in Version 5.2 follows:

 A review of the functions and enhancements in the release of Version 5.2 follow; by module organized by menu calls:

General Functions

If a previous instance of FORMULATOR is running on start-up– now examines each running process, and shuts down with a message if another instance of the EXE is found in the process list.  NOTE: The process is the exact exe name, i.e. “FORMULATOR 5 1 195.exe” is a different process from “FORMULATOR 5 1 196.exe”, and both would be allowed to run.
Login – user name – changed to “User ID”.
Main Menu – User is allowed to run QC but not production – disallowed user permission to the batch editor
Main Menu – Production Manager – Converts menu to version 5.2 layout
Presets – Setting up presets – “Save As” – if a preset is highlighted, that preset is now the default “save as” value.
Raw Material Maintenance, Formula Maintenance, Batch Edit, Fill Ticket Edit, BOM Maintenance, Advanced Costing – Internationalization of floating point fields – no longer truncates values after the decimal place (comma).
All FIND windows – event timing caused sort column to be misidentified.
All FIND windows – event timing caused sort order to fluctuate.
FPLoadGridPreset – No longer stops when encountering an invalid column key.
New indices created for descriptions for raw materials, hazmats, BOMs, packaging, batches, and fill tickets.
NEW! - Pharmaceutical version – Now provides pharmaceutical version.  Includes active ingredients, active ingredients set-up, analyzer, controlled substances, and 21 CFR Part 11 compliance.

Lab-Book

10. Raw Material Maintenance
Multi-user mode – unlocked – cost decimal selector was mistakenly also locked.
File menu – now includes a “Renumber” option.  Renumbers the current raw material code to a different raw material code.
File menu – now includes a “Import Renumbering Spreadsheet” option.  Renumbers the current raw material code to a different raw material code based on the contents of the spreadsheet selected.  Old code goes in column “A”, new code goes in column “B”..
Renumbering spreadsheet – now supports re-numbering into existing raws if the spreadsheet cell A1 reads ”Allow Renumber Into Existing Raws”.
Options – set tab visibility incorrectly.

RM General Tab
Cost moved to new Cost Tab.

Costs Tab – New Tab includes Primary Vendor Raw Material cost.  When Advanced Cost module is added links to Advanced Costing Utility and allows adding multiple Vendor cost plus freight to be added to Cost Tab.  Links to vendor records and formula cost analysis by raw material by vendor.
NEW! - New raw material editor with separate costing tab now activated at menu level.
NEW! - Includes optional unit cost conversion during editing (enabled by default).
Vendor grid – now includes copy and print.
Vendor grid – now includes multi-line notes.
Freight costs by raw material or packaging – Are available ONLY with advanced costing.
New raw material editor – multi-vendor list – now includes document link for link to PDS, web site, etc. for each vendor cost row.
Raw material FIND window – now includes WHMIS and EU symbol fields.

RM Properties Tab
10. Raw Material Maintenance – SG – new items – now defaults to 1.00.

RM Regulatory Tab new format includes symbols for Personal Protection, WIMIS, EU.  Pull down of EU risk and safety phrases.
HMIS PPE ratings – now has spy glass beside rating; opens rating selector window
Regulatory – EU Risk and Safety Phrases – now have look-ups based on EURiskPhrases.txt and EUSafetyPhrases.txt.

RM Nutritional Tab
USDA SR-22.mdb database is now available with this release
RM Active Ingredients (Pharma) Tab - 10. Raw Material Maintenance – Pharmaceutical version – now removes food related fields from nutritional tab (USDA cross reference, refuse percent).
USDA Import – Now populates USDA cross reference with itself.
USDA Import – Now populates new raw material property records with empty data

RM Inventory Tab
Inventory tab now includes an “On Order” quantity.  Units are same as the master inventory unit.
Raw materials and formulas – inventory tab – show oversold lots option – now reads “Show Zero and Oversold Lots”.
Raw Material and Intermediate FIND window – now includes Location column.

20. FORMULATION Maintenance

NEW! File menu – now includes a “Renumber” option.  Renumbers the current formula code to a different formula code.
Formula Log – Now displays the user ID responsible for the changes on the first row of the grid.

Formulation Tab
20. Formulation Maintenance – in percent mode – creating intermediate record – did not account for intermediate’s yield % in the unit cost if yield % <> 100.
Now disallows saving a formula if the formula contains itself as an ingredient.
Delete – if formula’s intermediate record has been changed to a raw material, it will no longer be deleted as part of the formula delete routine.
Calculation results – refresh button – wiped out any loss percents in the formula and replaced them with the raw material’s default loss percent.  New behavior: do not wipe out loss percents.
% versus natural modes – switching now adds to UNDO list.
Blank QC standard – no longer saves blank QC standards.
Maximum formulas in effect – prevented all formula saves
Targeted calcs, undo/redo – class copy did not copy cost units, resulting in erratic behavior in the unit cost.
Results – Redo – was not disabled when redo list empty.
BOMs – now displays capacity units as Formula Maintenance function.
BOMs – Click on code link – if not on file – now informs user BOM is not on file, and directs user to click “Create BOM” to create the BOM.
Edit mode – edit mode replace is now ON except for text lines.
Unit Cost+Freight column now totals at bottom
Vendor code, vendor name columns – if raw material has assigned vendors:  pull-down list activates with the choices pre-highlighted prior to editing.
Formula – Vendors – now supports vendor-specific unit cost and cost date based on new multi-vendor raw material costs.
Formula – Vendors – now shows raw material vendor list contents when entering a vendor name or code.  If raw has no vendors listed, all vendors will be available in the list.
Equation Results – Reverse calculation for a dilution – if ingredient was in volume, did not compute properly.
File – Print – If all ingredients have an SG of 0 – caused overflow in print routine (error 6).
BOM list - Pharmaceutical version – Eaches per Dose now included in BOM list.
Formulation tab – BOM / Packaging panel – dropped “Explode BOM” column.  No longer applicable.
Formulation tab – BOM / Packaging panel – dropped “BOM / Package” column.  No longer applicable.
Formulation tab – BOM / Packaging panel – excludes “Eaches per Dose” column when nutritional mode is inactive.
Formula text lines and batch text lines were limited to 80 characters.  New limit is > 1,000 characters.  Carriage returns are also allowed.
Text lines are unlimited in size and may contain carriage returns.  Reports have been modified to accept this change.
Formula Print – INCI Names – if no INCI name, nothing appeared for the item’s description.  New behavior: fall back to raw material’s description if no INCI name on file.
Now includes formula output.

Formula QC Standards Tab
Added lot QC tracking and electronic link to Vendor Certificate of Analysis with Quality Manager module purchase
.
Formula Regulatory Tab
Regulatory – Is now in three sections: shipping, hazmats/ratings, and symbols.
Regulatory – Now includes EU and WHMIS symbols.
Regulatory – EU Ratings – now has look-up list next to phrase text boxes.  Lists are taken from EURiskPhrases.txt and EUSafetyPhrases.txt.  These two files must be located in the FORMULATOR folder for the look-up windows to work properly.  The risk and safety phrase files can contain any arrangement of phrases in any language supported by the basic text file.
HazMat formula – manual – now preserves hazmat formula when selecting columns or presets.
WHMIS Symbols – Automatic – now displays symbols based on hazmats listed in the hazmat formula when WHMIS symbols are set to automatic.
 WHMIS symbols – automatic modes – now sets symbols based on the hazmats when loaded or refreshed (to refresh, move off the “Regulatory” tab and then back again).
MSDS Output – Now supports manual WHMIS symbols.

Formula Nutritional/Active Ingredients (Pharma) Tab
Calculation engine – nutrient values – with line losses – gross was not calculated correctly.  Net and Net plus Overage values were OK.
Forrmula – Nutritional – “Scale xN” button will scale formula to “N” doses or servings.
Formula – Serving size units – now converts old serving size to new serving unit when serving unit changes.

Inventory Tab – With Inventory Manager Only.
Raw materials and formulas – inventory tab – show oversold lots option – now reads “Show Zero and Oversold Lots”.
Inventory – Now includes default location field.  Free form to 25 characters.

21. Formula Compare by weight % or volume %
Now provides sorting by row and by column (raw material concentration).

25. HazMat File Maintenance
HazMat Maintenance – Hazards tab – now includes WHMIS and EU symbols.
HazMat Maintenance – Classification was not moved and resized correctly
Regulatory – EU Risk and Safety Phrases – now have look-ups based on EURiskPhrases.txt and EUSafetyPhrases.txt.

30. Edit Additional Raw Material Data – now left justifies all text/phrase and link type data.

35. Edit Additional Formula Data – now left justifies all text/phrase and link type data.

Lab-Book Plus

Raw Materials – QC standards tab – was not displayed in Lab Book PLUS.  New behavior: allow QC standards in Lab Book PLUS.

49. Packaging Maintenance
NEW! File menu – now includes a “Renumber” option.  Renumbers current package codes to different package codes.
Now includes vendor code and cost date in the general tab.
Inventory tab – now includes an “On Order” quantity.  Units are eaches.
trial period – turning off inventory did not remove inventory tab from the module.
FIND window – first time in – did not set FIND window columns correctly, causing error 5.
Vendor name – intruded across grid in inventory tab.
Packaging FIND window – cost column – was set to zero decimals.  New behavior: 4 decimals of precision will be displayed
Packaging Maintenance – Now uses new FIND window format.
Packaging Maintenance – Now includes WHERE USED capability.
Packaging Maintenance – Inventory – Now includes default location field.  Free form to 25 characters.

50. Cost Analysis/Bill of Materials
New structure allows building prefilled Bills of Materials (ProtoBOM) and filling from Formula Maintenance.  Adds materials and packaging Losses to Assemblies for fill ticket and cost analysis, adds ability to define QC tests to be run and recorded during packaging.  Displays all details and links to records for direct editing including materials, formulas and packaging.
NEW! BOM Maintenance – File menu – now includes a “Renumber” option.  Renumbers the current BOM code to a different BOM code.
NEW – BOM / Packaging control.  Allows control of serving size to meet tableting requirements, dosage and formula scaling

BOM Maintenance – Now disallows saving a BOM if the BOM contains itself as a component.
Inventory – now supports shelf life days.
Assembly – Panel widths were not saved on exit.
BOM tree – with intermediate BOM having a bulk component with a blank code – caused error 9, invalid use of null.
trial period – turning off inventory did not remove inventory tab from the module.
BOM Maintenance – Margin with overage – did not account for overage
Assembly – Components – NEW COLUMN – “Loss %”.  Allows user to indicate loss percent for bulk and packaging items.  These amounts will be added to the overall BOM cost, and also added to the final fill ticket totals when calculating initial fill ticket requirements.
Assembly – Pricing panel – now includes total cost, overage percent, and gross cost.  Gross cost = total cost * (100 + overage %)/100.  Margin is now calculated from gross cost.
Assembly – Pricing panel – BOM inside another BOM – packaging costs of the inner BOM were not being picked up in the future costing columns.
Advanced costing – BOM within a BOM – future packaging costs were not being stored within the intermediate BOM cost record.
Advanced costing – BOM Intermediate cost records – now scales the cost up according to the BOM’s overage percent.  The overage percent is found in the Assembly tab, in the Pricing panel.
BOM FIND window – now includes Location column
BOM Maintenance – Inventory – Now includes default location field.  Free form to 25 characters.

51. Advanced Cost Analysis Utility
Now includes Packaging Materials as well as raw materials.
Freight costs by raw material or packaging – Are available ONLY with advanced costing.
Generate cost records – now allows generation for secondary vendor records if they exist for a given raw material.  This does NOT apply if all vendors are chosen.
 Generating records – generated records for items with 0 cost, resulting in 0 cost future records.  New behavior: current cost must be > 0.
Advanced Costing – Multi-sheet – changed label for raws from “Bulk” to “Raw Materials”.
cost update – ignored primary vendor assigned to raw material, and just used first cost record it came to.  New behavior: if raw has primary vendor, use matching vendor or blank vendor records only during update.
cost update – Now also updates raw material vendor cost list.
Packaging – Now includes purchasing factor and purchase cost.

52. Analyzer – new engine released for multi-variable formulation development
Analyzer Objective Ingredients Builder expanded (Nutritional & Pharma ONLY). Includes Supplement and Fortify modes.

Analyzer – Now has NEW and FORTIFY modes.  FORTIFY mode adds nutrients on top of an existing formula (i.e. uses most concentrated nutrients to increase potency).  NEW mode formulates to meet the objectives from scratch (i.e. when building a tablet or supplement).
Analyzer – FORTIFY mode – if any objective cannot be reached (too low) – now suggests increasing the serving size.
Objectives – Ingredient Builder and Analyzer – I.U.s – Fortify mode – wiped out original ingredient quantity in some circumstances. Fixed.
Objectives – Ingredient Builder and Analyzer – now has a “Working…” window with a cancel button.
Objectives – Analyzer - Fortify mode – Iterates 20 times for each objective or until the objective is reached or the user clicks “Stop Working”.
Objectives – Analyzer - Fortify mode – Now re-scales to total formula to its prior total when the fortify cycle is complete.
Ingredients Builder – Now includes menu option Select, First ingredient for all option.  Selects first ingredient listed for each objective.
Formula – Objectives – Ingredients Builder – with BOM selected – now automatically adds a filler objective if one does not exist.  If no filler item is specified, asks user to specify the filler material.  If no material is selected, user is told that target BOM size may not be met.
Formulation Maintenance / Analyzer – Objectives - Ingredients Builder – non-standard unit nutrients, i.e. IUs, RAEs, etc. – are now displayed as units per gram.
Objectives – Toolbar – now includes Overage setting, “Ov%”.  Sets overage of all nutrient objectives.  Also – Build is now a toolbar icon, “B”.
Objectives - Ingredient Builder – previously set serving units to grams.  New behavior: if serving units are valid, convert from grams to formula’s serving size.
Objective select – mass select – now beautifies rows added after selection is complete.
Objectives – Builder – now sorts by potency with highest potency materials listed first
Objectives – FIND – now provides checklist of all selected objectives.  User can then select any number of objectives all at once.
Objectives – Now includes INERT and FILLER objectives.  FILLER will increase to meet BOM capacity.  INERT is a fixed initial percent in relation to the unpackaged formula.  The overall INERT percentage may decrease if filler is increased to meet fill capacity.

53. Nutrient Labels
Print – Now renders graphic to output device at device’s resolution.
Utility now available to output to jpg and other print graphics.
If nutrient had a 2000 calorie diet guideline – and “No Daily Value” was checked – still displayed daily value.  New behavior: do not display daily value if nutrient has “No daily value” checked.
Added jurisdiction selector above serving size grid.  Now allows toggle between US and Canadian DVs and diet recommendations.
Nutritional labels – objectives – it was possible to leave a space at the end of a nutrient’s description, causing the nutritional routines to “miss” any nutrients that has a space at the end.  New behavior: Do not allow spaces at end of nutrient descriptions.  Data update corrects any existing data issues.

62. Customer Maintenance
62. Customer Maintenance – Customer specific QC – “Conditions” and “Notes” are now “Standard” and “Conditions”.

64. Vendor Maintenance
Now linked to Vendor Cost in Advanced Costing raw materials and formulas.

Production Manager – Consolidated Batch Edit, Batch QC and Batch Close

130. Cut Production Tickets –
Batch Ticket Print – If no fill ticket included – hides fill ticket checkbox and locks down batch ticket check box.
Cutting batch tickets (all types) – If batch is on file – if formula is different from original batch – warns user
Over an existing ticket – now deletes old formula output and creates new output records if formula is not going directly into filling.
Batch detail – new includes raw material inventory location, Default Location (BatchItems.ttx).  Can be customized in the batch ticket output.
130. Cut Batch Tickets – link to 135.Cut Fill Tickets – now limits BOM selection to those BOMs that contain the bulk formula.

131. Material Requirements
Material Requirements tab – now includes an “On Order” quantity for raw materials and packaging items.  Raw material and package “on order” quantities can be entered directly into the grid.  All changes will be automatically saved to the item’s “on order” quantity field.
Material Requirements tab – Requirements detail – now provides a link (single click editing) to listed batch and fill tickets.
Material Planning – Fill Ticket FIND – bad SQL column QC Pass caused SQL error during load
TYPE filter – now saves filter setting (raw, formula, BOM, packaging, all).
Material Requirements – Building demand – now displays a “Working – One moment, please” window while building demand. User can select All, raw materials, BOM, Packaging.
Material Requirements – WIP – now has option to display either committed WIP or all WIP.
Material Requirements – WIP – now displays in a single column titled “Work In Process”.
Material Requirements – Raw/Formula launch link corrected.
 Material Requirements – Month selector – did not disappear when focus was lost.
Material Requirements – Now saves window dimensions on exit.
Material Requirements – Select block option turned off for all grids.

135. Cut Fill Tickets
Called from cut batch tickets – with filter set on BOM find window – caused SQL syntax error when limiting list to BOMs containing the cut batch.  New behavior: do not cause syntax error.
Cut Fill Tickets – BOM Find – now uses new FIND window.

145. Batch Edit & Close – New Consolidated Section, includes all batch editing, close functions and QC module multi-cycle functions for accounts with QC Manager Module.

Batch Edit, Batch Completion – Labels – Now includes QC by/approved/rejected and dates, QC status, formula trade name and project code, batch project code, batch gross, net, and units.
Now named “Batch Edit and Close” regardless of intermediate upgrades.
Ready to Post – now checks to see that all bulk output items are on file.  If not, will disallow posting with message to correct.
Batch FIND – now includes (posted) unit cost and total batch cost, if user has permission to view costs.
Batch FIND – Did not set number of decimals for floating point values.
Fill Ticket FIND - now includes (posted) unit cost each, if user has permission to view costs.
Fill Ticket FIND - Did not set number of decimals for floating point values.
Raw material FIND– Did not set number of decimals for floating point values.
Batch posting status, start date, committed checkbox, post button – moved out of batch output tab and placed at top of tab area.
Batch FIND – now includes “updated” and “updated by” columns.
Batch Items table – Total quantity column – was not being filled in during batch save.
Main Menu – Administrators – now supports “CALL SBIT” – re-calculates batch item total fields to remediate error in 5.1 batch completion.
Batch Output – Unit Cost column – changed name to “Unit Cost Override”.
Unit Cost Override – now not visible by default.  Can be seen by selecting the “View – Unit Cost Override” menu item.
window – column layout was not saved on exit.
empty batch output – reported all costs assigned, preventing batch save.  New behavior: don’t prevent batch save.
Batch Ticket Manager – Batch status – can now be up to 255 characters.
Output tab – Posted batches – batch status “POSTED” label added in build
Load sequence was incorrect, status from previously loaded batch was used during load.
Output tab – toolbar – now includes FIND icon for finding bulk items to output.
Output tab – Posted batches – batch status now displays a “POSTED” label.
QC Results – grid click – now loads 5.2 batch editor in version 5.2.
Batch FIND – now retains QC and inventory status filters
Batch Input - Lot number – click on lot number and then click on empty lot selection – lot assigned is “Click lot number to select”.
Batch input – lot tracked items – item code is now green to match the description.
QC Results – now has calendar icon tool for setting QC date.
QC Results – Pass/Fail – now toggles so that both cannot be selected at the same time.
Batch FIND window – now includes pull-downs to filter for QC status (in process, passed, failed) and batch inventory status (In process, ready to post, posted).
Batch Maintenance – Equation Results – Reverse calculation for a dilution – if ingredient was in volume, did not compute properly.
QC results – if a numeric results was entered – did not return the value with the same number of decimal places when ticket was reloaded.
QC results – Did not save column width changes.
Text lines are unlimited in size and may contain carriage returns.
Had lost the ability to print a batch additions ticket.  Now lets user choose between printing an additions ticket or re-printing the batch ticket.
Batch output tab – now includes decimals selector in batch output toolbar.
Input – Lot Number Info Panel – Intermediates – With batches in process – now includes second sheet within lot detail window to allow selection of a batch to provide property variant batch blending.
Input – Lot Number Info Panel – Raw materials – With incoming QC or manual lot-specific property variants - now includes second sheet within lot detail window to allow selection of a property variant by lot number.

150. Fill Edit & Close – New module now includes consolidation of all packaging functions, allows modification of Assembly, Qulality Control during packaging for accounts having Quality Manager module.

145. –150. – Now named “Fill Edit and Close” regardless of intermediate upgrades.
Now supports lot numbers for BOM and packaging items.
Now includes expiration date.
Assembly – Panel widths were not saved on exit.
Fill Ticket FIND – now includes QC and inventory status selectors.

160. Post Fill Tickets  
Expires Date – if fill ticket’s “Expires date” is empty, and the BOM specifies a shelf life days, then the expires date will be set for the fill ticket during posting.  If the fill ticket has a valid QC date, the shelf life days will be added to that to establish the Expires date.  Otherwise, the shelf life days will be added to the current date.

PRODUCTION REPORTS – All New

170 – Production History – lists batch and fill tickets by ticket range, by time period, in summary or detail.
Fill detail – SQL error on lot number corrected.

171 – Production Usage – new output

Quality Manager  

Production QC

181. Manage QC Results -
QC Results – grid click – now loads 5.2 batch editor in version 5.2.

182. Batch QC Results – Now linked with Batch Edit and Close

Incoming Material Testing

201. Material Sampling and Results – linked with Raw Materials QC.

QC Reports

210. QC Result Report – Subreport database assign error on older reports.  New behavior: trap error

211. Certificates of Analysis
Formulation Master and Customer record set binding – now set via subroutine with trapping to avoid errors to old custom certificate of analysis reports.
 Second time through – formula master record set was left open, causing an error.
Certificate of Analysis – Now includes lot number entry.  Lot number will appear on sub-report “LotNo”.

Inventory Manager

Inventory Transaction editors – added option for File- Print and Edit – Copy Grid to Clipboard.

230./240. Bulk Inventory Adjustments Journal – Did not refresh description when grid was clicked.
231./241. BOM Adjustments Journal – lot number pull-down – now pulls down the last 10 posted fill tickets for that BOM.

232./242. Packaging Inventory Adjustments Journal – Did not refresh description when grid was clicked
251. Post Packaged Adjustments:

Physical Inventor Count

260. Bulk Physical Inventory
261. Packaged Inventory Manager

INTEGRATOR

Main Menu – Now includes inventory synchronization within the accounting INTEGRATOR.
Main Menu – Now includes ERP item transfer in the ERP menu.

2010 versions of Peachtree, QuickBooks, Business Works Accounting integration fully tested and supported.

ERP integrations with Sage PFW, Horizons (Dynamics GP), Oracle, DBII, Cimpro, Macola and several MSSQL applications upgraded and supported.

324, 325, 326: ERP Integrator – On Main Menu –now allows labeling of ERP menu items via the INTEGRATOR.INI file.
Integrator – Now supports flat file interface.
NEW!  370. Create Local Database Copy – INTEGRATOR Takeaway – Creates local copy of master database for takeaway purposes.

REGULATOR
 
Integration with LOLI (Regulatory List of Lists Database)  - upgraded to current version.

405. Lists of Regulations Maintenance – SQL Server < 2005 – server side cursor refused to return data; would randomly disconnect from client.  New behavior: now uses client side cursor to load data.
multi user mode – when loading a regulation – left the preamble and footer fields unlocked

415. ISO-16 Template Maintenance – Loading template – without consolidation of effects of overexposure – did not un-check option.
Fixed OLEDB error in regulation maintenance.

420. Edit Additional Hazmet Data
430. MSDS Output
EU ISO 16 report is now available using the GHS layout (ISO16GHS.rpt).
430. MSDS Output – formula not on file – did not notify user, crashed with error 91.
430. MSDS Output – Hazmats with ecotoxicity – caused SQL error generating data sets
430. MSDS Output – fixed error 5 handling risk and safety phrases.
430. MSDS Output – fixed error handling null risk and safety phrases.
430. MSDS Output – New subreport available – “RiskPhrases” – Lists formula’s assigned risk phrases.
430. MSDS Output – New subreport available – “SafetyPhrases” – Lists formula’s assigned safety phrases.
430. MSDS Output – New subreport available – “CASRiskPhrases” – summarizes all risk phrases for all hazmats in a formula.
430. MSDS Output – SELECT ALL REGS button – selects all listed regulations.
430. MSDS Output – SELECT NO REGS button – de-selects all listed regulations.
430. MSDS Output – cleaned up flash point calculation (checks formula flash point first, and if not specified, uses lowest raw flash point; reports “N/A” if none).
430. MSDS Output – Now supports manual HazMat formula override
430. MSDS Output – MSDSFormulaMaster.ttx – Now includes EU flags and other new fields for customization of MSDS forms output.
430. MSDS Output – ISO16*.rpt – now includes MSDSFormulaMaster.ttx as table number 2 in the database location set-up.  Provides EU risk, safety, and other formula data fields.

431. Label Output – Links to Bartender Labeling Software V9.2.
HazMat labels – with BarTender – now loads new BarTender HazMat print module if BarTender installed and licensed.
Label output – with BarTender – Now includes batch project code, customer code, and quantity.
Label output – with BarTender – referenced invalid column when a batch was specified.
Label output – with BarTender – Additional data elements – now follow defined elements.

Reports
Formula Print - FPDetail.ttx – Comment field is now MEMO.
Batch Print - BatchItems.ttx – Comment field is now MEMO.
Formula Listing – FormulaDetail.ttx – Comment field is now MEMO.

Maintenance

810 Data Update
810. Data Update / Recalculation – now sets formula total and net.
Database update has been improved version 5.35 is part of update from version 180 up.
Removed transaction begin and commit.  Log space was inadequate on some MS-Access databases.

840 Equation Maintenance – Further simplified.
Calculation engine – Categories – were not initialized properly, resulting in all formulas coming up as not in category in all cases.
Decimals – now defaults to 2 decimal places.

SETUP

920. Physical Property Set-up

Physical Properties Set-Up – Basis – Now includes two new bases, “% Weight Surfactant” and “HLB Number”.  Both properties are required to compute the HLB number of a mixture.  % Weight Surfactant indicates the total percent weight of a surfactant in a given blend.  The HLB number is the hydrophilic lipophilic balance number of the surfactant portion of the mixture (base of 0-20 is arbitrary, any basis is valid).  For “pure” surfactants, the % weight surfactant is 100, and the HLB number is the HLB number of the surfactant.  If the surfactant portion is less than 100%, the HLB number should reflect the HLB number of just the surfactant portion of the mixture.  Only ONE HLB number property is supported per database at this time.
Saving a second (or more) copy of NCO, OH, surfactant, or HLB properties – now warns user that multiple properties of these types are not currently supported.
Physical Properties Set-Up – FIND window – did not initialize column locations correctly.

940. Nutrient Set-Up
Rounding rule combo box was cut off due to an error in the form resize method.
2000 calorie diet recommendations – now supports Canadian daily value set-up per nutrient.  New fields includes 2000 calorie diet DV, 2500 calorie diet DV, no DV flag, and flag to put nutrient into diet statement.  The Canadian values will be set to match the US values during database conversion.  All changes to meet actual Canadian standards must be made manually (i.e. Potassium DV, etc.).
Nutrient I/O – Now uses rawnutr_val for raw materials and formulanutr_val for intermediates

Main Menu – Administrator level users – NEW MODULE – View, Active Users – Displays a list of users currently logged in to the system, their log in time, and session ID.  Users can also be terminated with this module.  Any killed sessions will notify the user to save their work, and then terminates FORMULATOR in 60 seconds.  The kill switch may take up to 90 seconds to be activated on the targeted client.

Sample window: