***************************************************************** Emerald change history for versions 5.x (All Platforms) ***************************************************************** Modified: 7/10/2010 Copyright (c) 1996-2010 IEA Software, Inc. All rights reserved worldwide. This file contains important, late-breaking information about changes made within Emerald. We recommend that you read this file and keep a printed copy with your Emerald documentation. Tip: If necessary, choose Word Wrap from the Notepad Edit menu or Wrap To Window from the WordPad View/Options menu to wrap the text within the document window. ---------------------------------------------- CHANGES.TXT CONTENTS ---------------------------------------------- . KNOWN PROBLEMS . RELEASE CHANGES ---------------------------------------------- KNOWN PROBLEMS ---------------------------------------------- * None at this time ---------------------------------------------- RELEASE CHANGES ---------------------------------------------- Emerald 5.0.70 - 7/10/2010 -- * Added external invoice field Invoices.ExtInvoiceNum to enable search and display of origional invoice numbers imported from external systems * Added error_include handler now supported for all ews exec functions which set EXEC_RETCODE (See exec_error.ews) * Added tsgraph enhanced with new graphing system * Added churn by service type reporting * Added verify invoices check to make sure there is agreement between the amount of an invoice line item and its corresponding charge adjustment * Added DAN WiMax RADIUS VSA attributes * Added syslog filter administration improved to show severity labels and allow matching without explicit severity level * Added support for Chargeback Guardian realtime credit card processing gateway * Added churn report now produces figures exclusivly from invoicing histories over time to improve reporting accuracy * Added record count fields for GL invoiced and GL Payments report procedures * Added summary function now supports matchcolumn and matchvalue parameters for restricting aggregate calculation to rows with matching values * Added 'graph' graphing function to render line and bar charts based on source table x/y data * Added EmerAuth support for Imail 11.02 * Fixed when adding a new MBR with a package the starting date of the package is not set to the starting date of the MBR * Fixed charge type listing when creating adjustments or POS invoices may not include charge types associated via service groups * Fixed new account with time left field set to replenish daily is not refreshed on the first day at midnight because a 24-hour period had not yet been reached * Fixed when credit card show last four field hiding is enabled and an effected operator applies payment depending on unrelated configuration the payment may be submitted with the invalid digit hiding value known to the operator instead of actual card number on file * Fixed operators should not be allowed to remove the priority 0 default priority * Fixed expired accounts report should not filter out inactive or deleted accounts * Fixed orbital paymenttech batch processor configuration errors * Fixed statement batch short term exclusion lookahead for pending invoices should be supressed when MBR or service level cancel date is equal or less than the current billed thru date of the service * Fixed voiding of invoices with credit charge adjustments duplicate the adjustments so they can be applied to a future replacement invoice. During duplication the distribution flag field must not be copied for credit adjustments as this will prevent credit amount from being automatically distributed to invoice line items * Fixed multi-value-attribute rfc822mailbox query missing for NIS and Communigate Pro LDAP sync profiles * Fixed Everyone.Net, Helm and CPanel, Diino and Generic WS suspend status for expired accounts occurs a day too soon. Account should be usable for the duration of the expiration date * Fixed RADIUS client did not properly display values for VSAs of type tag attribute * Fixed export system SSL session cache was not thread safe sometimes leading to AV when multiple exports with SSL sessions run concurrently * Fixed transaction list for realtime CC/EFT transactions should be refreshed if an imported transaction id is not recognized to prevent import failure in the rare case a new transaction is added between batch processor initialization and transaction export Emerald 5.0.69 - 5/10/2010 -- * Added query and prefix parameters support for all ews exec functions * Added reduced count of preparsed emerweb functions and switched from optout to optin by default * Added multiple 'with' parameters to check function for match against any available 'with' parameter * Added glcodes selection listing parameter for accounting reports * Added all parameters within the Variables table can now be passed to reports where previously only a select few were allowed * Added SNMP query and walk emerweb functions * Added payment receipt report now includes billing group address information if a report logo is not present * Added emernet debug formatting enhanced to consistantly display flow summaries for concurrent IPv6 and IPv4 collection * Added payment distribution procedures changed to reduce possibility of SQL Server 2000 optimizer choosing a non optimal plan * Added external system provisioning support for the Diino backup service * Added notice type to schedule email sending of any parameter free report to an operator * Added monthly data usage warning notice type based on rating summaries * Fixed improved numeric query parameter restrictions for null matching, trailing/leading spaces and negative numbers * Fixed local group dependancy checking for add and update functions can fail * Fixed when adding new records the system must first make sure at least one field parameter is present * Fixed adding new columns to existing emerweb tables must include all rows of the table instead of just the initial row * Fixed expiring cached queries in the currently active removal exclusion list can lead to AV during load test if multiple expired versions exist concurrently * Fixed checkoperator added debug log message should not be displayed if the operation failed * Fixed emernet promiscuous mode data collection of IPv4 flows may not be captured properly * Fixed post payments billing menu should include additional fields in tab order * Fixed ignore negative quantity POS items * Fixed mime version field now included for messages which do not contain file attachments such as html reports * Fixed while removing external systems any external syncs dependancies should be removed first preventing dependancy error from being displayed * Fixed charge type listing displayed in the accounting admin menu was not sorted by sort order and charge type description * Fixed removed coloring for incident action state in MBR history menu prevent confusion with current state of incident * Fixed new accounts provisioned to CPanel control panel do not initially have passwords set properly until the provisioned account is updated * Fixed wrong billing cycle may be used to calculate service expiration when sending a time left or data left notice based on service time banking Emerald 5.0.68 - 3/10/2010 -- * Added IPv6 native transport for all Emerald modules * Added recursive 802.1q header support for emernet promiscuous mode data collection * Added emernet IPv6 traffic rating for NetFlow v9, IPFIX and promiscuous mode * Added when requesting data from a remote web server where no form parameters are to be sent use method GET instead of POST * Added short term local DNS caching for outgoing SMTP and HTTP connections. Clicking 'Apply' in the Emerald admin resets cache * Added while attempting an outgoing request to a DNS name with multiple IP addresses try subsequent addresses if the connection attempt to previous fails * Added if response to an HTTP request is an error code the code is reported as an error and message content is not parsed by the export system * Added operator IP security access list accepts DNS names and IPv4/IPv6 CIDR notation * Added remove stored session cookies immediately on operator logout * Added changed secondary ordering for incident search results such that open incidents are ordered oldest first and closed incidents are ordered newest first * Added session management system coalesces duplicate operator sessions for operator and web service requests * Added persistent session management for end user access to customer center enabling web server instances to be treated as a stateless system * Added improved language translation lookup * Added integrated operator authentication when emerweb hosted under IIS * Added configuration servers prevent duplicate items from being added to list input box * Added listing of available local IP interfaces are provided during listener configuration * Added operator listing in the Emerald admin security menu is now sortable by column and ordered by active status followed by operator name by default * Added creating new incident using an incident type having an email address and show email enabled the types email is filled into the new incidents email field automatically as an operator clicks the email field * Added creating new incident the assignment role can now be defaulted automatically if available to the operator based on the incident types default role when applicability is set to Customers & Operators * Added incident assignment roles now ordered alphabetically in the operator and admin interfaces * Added incident types and statse with negative sort orders are removed from availability when creating new incidents * Added post payments billing menu supports hotkey navigation (C - Customer ID, A - Amount, I - Invoice ID, S - Statement ID, K - Check Number, P - Make Payment) and auto clearing of previous values when entering subsequent payments * Added statement line items displayed within the MBR statements menu now appear in the inactive background color in the case where an invoice was both created and voided within the same statement * Added region and billing group selection lists have been reordered such that inactive entries with negative sort orders appear last within the list * Added active expire minutes field for prepaid card batches to configure fractional day card expiration * Added email field to MBR account report * Added customer id to default invoice report * Added operator or user created by field to new action notice types * Added operator home page theme based open incident list secondary sort of create date now in ascending order and results display incident creation date * Added when opening an MBR or service require the starting date must not be covered by the terms of an non-voided invoice and non-canceled invoice line item * Added check numbers can be stored when applying payments using payment types other than check payment * Added local concurrent access locking for CC/EFT transactions as a backup measure to the database global lock * Added large CC/EFT batch transactions may now automatically temporarily suspend to allow time sensitive operator or customer submitted manual transactions to process without waiting for batch completion * Added POS invoices with negative credit amounts now allowed by automatic association of a charge with the invoice * Added notice types for sending new incident assignments and new actions can now be restricted to specific incident types * Added total invoice amount including tax line items associated with paid tax line items now reported via additional columns in the tax payments report * Added smartermail web service sync can now request deletion of accounts directly without first requiring a transition to the deactivated state * Added customer center option for users to change their accounts send method. Customer access must be enabled at send method level and web interface / customer settings / allow send method option set 'Yes' to enable this feature * Added improved storage efficiency of clustered indexes for Calls and payment distributions on the Oracle platform * Fixed reseller invoices queued to be generated when the reseller billing feature is not license enabled should be skipped allowing other types of invoices to be processed rather than preventing invoice processing * Fixed access denied error message is displayed when adding an action to an existing incident and the operator does not have modify access to the incident * Fixed credit adjustments unapplied to invoices reflect a negative amount when edited. Amount displayed when the edit from is loaded must always be a positive value as credit/charge radio buttons determine sign of the amount * Fixed audit logging parameters when deleting a service for Login, FirstName and LastName are not set * Fixed emernet promiscuous mode collection now counts byte statistics based on actual L2 payload size rather than IPv4/IPv6 header length field * Fixed workaround for IE problem where onChange event is not triggered by cut and paste or autocomplete to input fields preventing change detection from saving the contents of custom data fields * Fixed when upgrade_go is run to distribute payments after an upgrade or data import the normal distribution rules ordering POS invoices last for CC/EFT auto-pay customers must be ignored so that redistribution is only done in chronological order * Fixed removed option to print payment receipt from the MBR payment menu for Credit Card and EFT transactions as no payment is available to print until the transaction is fully processed and has been approved these types must be printed from the MBR history menu or emailed via the approved batch transactions notice to automatically issue payment receipts * Fixed incidents associated with deleted services should not appear in incident search results * Fixed should scheduled invoice processing fail more specific cause information may be replaced with a generalized message appearing in the scheduled task log * Fixed security and configuration reload when clicking 'Apply' in the Emerald admin may display an error message but still appear besides a green checkbox * Fixed tab orders in post payments form not properly ordered * Fixed failed transactions associated with inactive MBRs should not be displayed in the failed transaction report * Fixed warning should be logged if the global batch lock transaction commit fails * Fixed starting and ending availability settings for service types are not saved when a service type is updated * Fixed daily payments report now presents adjusted payment totals separately. Previously total summaries were calculated incorrectly in the case where a payment amount was changed during periods not covered by the report * Fixed MBRs having a temporary cancellation status should be excluded from automatic deactivation * Fixed updating service information associated with change of recurring package type may fail while the packages extension field is blank * Fixed recurring revenue forecast report should not include services with a cancellation date prior to the reporting period * Fixed avs transaction information may not be sent with credit card transactions processed using the NELiX TransaX gateway Emerald 5.0.67 - 1/11/2010 -- * Added export system remove periods from keys of url encoded response allowing variable names to be referenced * Added allow theme selection for customers visiting the customer center at the billing group level * Added bind failure messages for web listener have been improved to be more specific * Added reporting option to control automatic closing of reports when not in focus * Added allow rated usage charges to be applied earlier than start of services next billing month in cases where the MBR or service has been canceled * Added unsynced history checking before applying late fees if MBRs current balance is zero or credit do not generate late fees even if associated line items are unpaid * Fixed web server rx/tx operations must be aware of anti-dos async connection closures to prevent rare probability of interference with unrelated connections in event of rapid socket reuse * Fixed improved compatibility with RIM Blackberry devices using OS version 4.6 and earlier * Fixed custom data field search results should contain matches only for active or inactive accounts * Fixed AV possible copying SQL message state for display of database related error messages * Fixed collision check warnings may prevent rollup of some usage charges with large amounts over ~20000 * Fixed initial invoice created during signup where a non-recurring invoice is created for a service type the service types AccountTypeID is not set at the invoice line item level * Fixed if the MBR active status field has been disabled from the billing group visible field options an error message is displayed when saving new MBRs * Fixed corrected ordering of html elements within header sections of the signup server and customer account center * Fixed canceled MBRs should not be included in the expired accounts report Emerald 5.0.66 - 11/10/2009 -- * Added service type setting to schedule inactivation of canceled services within an active MBR * Added support for display of IPv6 prefix attributes via the services RADIUS / Auth test menu * Added improved detail for invoice over commit messages * Added rating engine support for dynamic costing of data rates in time dimension * Added revenue by service type report can now be filtered by region * Added operator email address can now be used as a login to access Emerald operator interface * Added generic web service export system to synchronize Emerald account information via user provided web service request * Fixed change of service and closing service credit calculation have been improved to mirror invoice costs * Fixed export system status matching of less than greater than was reversed * Fixed AV possible in export systems using an export template that does not define all variables referenced in the template * Fixed display of currency figures using the currency format specifier to round to two decimal places may not follow asymmetric rounding rules in all cases * Fixed control symbols visible throughout the Emerald client UI when the firefox web browser is used * Fixed table of results presented when the Emerald Admin / Database / SQL Query menu is used should escape any html formatted data output * Fixed customer settings option to disable purchase time menu in the customer center when one or more one-time charges have customer access enabled was ignored * Fixed when services assigned to packages have been canceled and the cancellation date has passed the canceled service should no longer count against the packaged maximum * Fixed should void invoice fail template processing was not canceled * Fixed canceled services should not be included in the expired accounts report * Fixed revenue by service type report should not include unprocessed invoices * Fixed correct instances of mistyped case of column labels for case sensitive databases * Fixed fractional cent over commit warnings when running payment distribution for inconsistent (imported) invoice data * Fixed Imail user configured preferences such as calendar display settings were not stored within Emerald * Fixed packages should not be billed after the only associated services have all been canceled * Fixed applying payment to one-time charge invoice items leading to recharging of time data and or expire fails with a null billed thru date error when the expiration field is left blank * Fixed when voiding invoices having a balance forward cycle type the expiration field should be cleared when updating service billed thru date * Fixed closing MBRs where all invoiced service types have prorate closing service option of "unused months" rarely not all invoices eligible to be automatically voided are voided * Fixed group concurrency control configured on the Oracle platform results in database error being displayed during group concurrent access checking * Fixed forecast report shows invalid quantity information for accounts having pay periods based on a count of days instead of months * Fixed invoiced GL report incorrectly reported adjusted invoice entries based on payment status of adjusted entries rather than reporting only invoice activity Emerald 5.0.65 - 9/10/2009 -- * Added ODBC version 3 is now requested on all applications to workaround Oracle ODBC driver connection handle bug on some Linux platforms * Added include fax phone fields in MBR phone search criteria when substring phone number searching is enabled * Added eight additional cash payment types for processing custom payment methods * Added allow zero cost authorize only batch transactions to be submitted for customer validation purposes even when a minimum transaction limit is enabled * Added dictionary attribute type of IPv6 Prefix now supported via RADIUS dictionary attribute editor * Added statement triggering option to prevent new payment activity from directly triggering statement creation * Added support for beanstream realtime credit card processing gateway * Fixed blank matched data fields during RADIUS log search matching deleted services for operators with global MBR access * Fixed RADIUS log search results present a login search hyperlink which may not include the full login username contained in search results * Fixed relaxed incorrect export system transaction response processing requirement validation when processing credit transactions * Fixed if there is a database related error uploading binary files to the database the error message presented may not be descriptive * Fixed domain metarule validation incorrectly included constraint checking of login rules * Fixed options to add new package to existing MBR may not be visible if the package is made available exclusively via service group membership * Fixed new signups on the Oracle platform may sometimes schedule and run batch processing for new MBRs before there are any transactions available to process * Fixed service expiration customer notice may trigger two days earlier than configured * Fixed SSL CA certificate configuration on Linux platform is ignored using global defaults unless configured from the listener settings menu Emerald 5.0.64 - 7/23/2009 -- * Added options enabling display of currency codes from the organization level for operator client UI, reporting and customer center * Added recently failed transactions are now displayed from the account status dialouge with options to update card information on file or make a new payment * Added while a customer with CC Auto Pay enabled updates their card on file from the customer center and the lastest card transaction has recently failed it can now be automatically voided when the customers card account information is updated * Added customer center card account update can now trigger scheduling of a batch export for the customers MBR * Added RADIUS disconnect messaging from the users online list and session manager now support optional sending of Framed-Address and NAS-Port-DNIS * Added automatic void accounting menu setting for CC/EFT transactions of accounts having zero or credit balance * Added recurring revenue forecast detail report showing per day invoicing forecast * Added sort service and MBR custom data fields having selection lists alphabetically by their list of values * Added introductory offers now supported at the package level * Added set default values for new packaged service associations when configuring new package types * Added improved theme folder inheritance system to search underscore delimited paths. For example a theme labled group_subgroup causes a search using the following folder order 'group_subgroup', 'group' , 'default' * Added emerweb radlogin function can now send the framedip attribute as a request parameter * Fixed cPanel web service synchronization did not set cplan values when changing between service types * Fixed auth address and auth name fields not sent properly to the viaWARP credit card processing gateway * Fixed changed label of service type related field validation errors from 'account type' to 'service type' * Fixed unable to void transactions awaiting import from the billing menu for batch file based CC/EFT batch processors * Fixed signup server package selection display did not use sort order of one-time charges associated with a package as a secondary sort * Fixed introductory offer configuration for service types was not saved when its configuration is updated * Fixed AV when displaying the results of queries returning date formatted data when no operator context is available * Fixed anniversary period aligned cycle types with pay periods larger than one month may incorrectly bill for a single month when the manual invoice next option is used Emerald 5.0.63 - 6/17/2009 -- * Added support for viaWARP realtime credit card processing gateway * Added service expiration notices can now be configured on a per billing group basis * Added MBR option to to hold new CC/EFT payment creation until the holding date has passed for customers on CC/EFT auto pay * Added billing cycle setting to control creation of CC/EFT auto transactions independent of the EFT/CC Bill Days setting * Added send bill for services created via the signup server now default to the service types send bill setting * Added service template option to allow custom changes to accounts created via the signup server directly before the account is invoiced * Added new signup form variable prefix "SP_" enabling variables containing the prefix to be passed unconditionally throughout the signup process * Added IE8 browser compatibility * Added export system parser to extract data from HTML pages with form fields * Added inline support for license checking ews template commands * Fixed AV when verifying operator credentials and password unavailable * Fixed possibility of the wrong meta rule being applied to validate input form data * Fixed billing day field was not shown when enabled in the billing group for MBRs with a period-aligned anniversary billing cycle * Fixed crediting existing CC/EFT payments from the MBR history menu should not allow entry of a negative credit amount * Fixed service expiration notices should not be sent after the service cancellation date has passed * Fixed when adding a new MBR from the operator interface the sales person in the service form does not inherit the sales person selected from the MBR form * Fixed summary template command now assumes numeric type for average function on non timestamp fields and assume integer type when the count function is used * Fixed export errors when synchronizing with cpanel hosting control panel Emerald 5.0.62 - 5/21/2009 -- * Added anniversary accounts billing day can now be changed from the 'Edit MBR' menu. Requires 'Billing Day' visibility setting to be enabled within the billing group * Added users language preference can now be configured from the 'Edit MBR' menu. Requires 'Language' visibility setting to be enabled within the billing group * Added invoiced GL summary report to show charge summaries by GL cateogory * Added emerweb function 'lineinput' used to import the contents of a list of items with acceptable character filtering into an emerweb table structure * Added SMTP configuration option to disable 8-BITMIME option from being set when sending outgoing messages. Not recommended for non-latin based alphabets * Added prohibit negotiation of certain weak ciphers for Emerald SSLv3/TLSv1 sessions allowing the system to pass overzealous (cipher suites are always securly negotiated) compliance scans * Added rating system option allowing authentication to be rejected when a default cost is not configured and there are no matching rating rules for the given authorization parameters * Added external system synchronization for VOP/ModusMail by synchronizing Emerald account information with the VOPMail table schema * Added when rating RADIUS accounting data count both upload and download byte counts rather than download only for all data usage calculations * Fixed listing of avaliable service types in the accounts service menu was too restrictive. It may not have included service types assigned specifically to billing groups to which a non global operator was allowed access * Fixed minor display problem possible with some web browsers when displaying the status of changes made to a customers notification preferences * Fixed error message displayed in certain cases when creating new external systems based on external web service provisioning * Fixed prevent binary contents of forms using the emerweb update function from being changed when new binary data is not uploaded when the form is saved * Fixed compatibility problem when using SMTP authentication with CRAM-MD5 for outgoing email messages to some email servers * Fixed period aligned anniversary billing cycle did not properly align with other services in the same MBR sharing a common pay period * Fixed error message displayed when attempting to apply a payment using a prepaid card with an amount greater than the remaining balance of the card incorrectly displays the MBRs credit limit as the cards remaining balance * Fixed unlikely AV when a rating data source is processed from the Emerald UI and the system is not licensed to use rating features * Fixed when sending email notices filter characters forming the emails name field that can cause the delivery of messages to fail with some email systems * Fixed database error on case sensitive databases when upgrading the stored procedures ErrorHistory and ESEnom used by the daily error summary report and ENom domain service synchronization * Fixed daily error summary report restricted search for 'MBR /w Email send method has no Email' to exclude all canceled MBRs rather than excluding only those canceled accounts with a cancel date in the past * Fixed when accessing send method fees for postal delivery the associated charge adjustment was not created with the flag to inhibit itself from triggering creation of interim invoices * Fixed corrected error in the use of Emerald managed IP Pools on the ORACLE database platform * Fixed direct use one-time accounts created by logging on with the credentials of a prepaid card having a prepaid balance to be distributed to the MBR was incorrectly applied as a charge rather than a credit * Fixed external system web service provisioning sync for data updated via the Aux6 transition type was incorrectly posted to the Aux7 field * Fixed when synchronizing Everyone.Net forwarding information the empty value '' is now used rather than '""' to prevent mail forwards change sync from failing Emerald 5.0.61 - 2/22/2009 -- * Added replaced multipart request parser and a new binary data meta rule to better support binary data * Added geodistance emerweb function to find distance between two lat/long points in decimal degrees * Added operator preferences to select metric and imperial units of measure * Added upgraded SSL support libraries used to provide HTTPS access to Emerald and RADIUS EAP-PEAP/EAP-TTLS protocol support * Added selection list report search fields for regions, incident types, incident states, service types and package types * Added reporting data fields for ews reporting: SalesPersonID, AccountTypeID, PackageTypeID, ChargeTypeID, IncidentTypeID, IncidentStateID, ServerGroupID, RegionID * Added support for SecureNet realtime ACH processing gateway * Added when no default sales person is assigned to a signup server the sales person associated to the signup operator will now be used to set sales person for new signups * Added card accountid search field to the prepaid card account search form * Added when making one time purchases via the customer center and only a single option for purchase is avaliable set its quantity to 1 by default * Added service type configuration options to independently choose between daily or monthly replenish of time left and data left limits * Added configuration option to enable or disable invoice void chronological order enforcement for recurring invoices to accounting settings menu. Disabling this feature is not recommended * Added changed calls trigger to debit data usage from service data left field based on sum of input and output bytes where previously only output bytes were used * Fixed transaction error displayed when applying credits to a SecureNet credit card processing gateway * Fixed custom footer in customer center should not be presented when custom header was not also displayed * Fixed hide operator hyperlinks with a negative sort order * Fixed error displayed when manually adding a new table via the meta table editor from advanced options * Fixed when multiple rating rule sets have been defined with the voice destination rating type - destination rates specific to other rule sets should not be displayed * Fixed when configuring file based external system exports the option to configure export file overwrite vs append behavior were not avaliable * Fixed send method charges were not being assessed when an invoice or statement print batch has been marked as sent * Fixed churn report now supported on Oracle platform and improved accuracy for MBRs having been canceled and reopened more than once over their lifetimes * Fixed DD variable used to set current day of month when generating an export file from the export system was instead reflecting day of week Emerald 5.0.60 - 12/24/2008 -- * Added support for IP Pay realtime credit card and ACH processing gateway * Added SMTP authentication (CRAM-MD5 and LOGIN) when sending email messages thru an SMTP server from Emerald * Added checking to prevent operators from crediting CC/EFT transactions when the MBR is on auto bill and the amount of the credit would lead to a positive balance * Added configurable operator role incident assignment strategy. Currently avaliable options include unfair distribution based on count of each operators of open incidents or fair round-robin distribution * Added change conflict detection for standard incident fields when updating an existing incident * Added notification for missing CC/EFT data when CC/EFT automatic billing is enabled for an MBR via the daily error summary * Added session manager can now disconnect all balance based concurrent sessions within an MBR when their current combined usage exceeds the MBR credit limit in a single pass * Added allow subsequent SSL connections to Emerald web server to choose different protocol versions and ciphers * Added export system support for size limiting evaluated constants for web service requests * Fixed automatic rebatch options configured with the batch processor for failed transactions created automatically via auto bill have no effect * Fixed early checking to prevent new automatic transactions from being created when there is incomplete CC/EFT data avaliable to process * Fixed session manager over limit disconnect determination may reflect DA error when balance limited concurrent sessions from same account are calculated for complex rates with change points based on time of day or aggregate usage * Fixed session manager memory leak when disconnecting sessions * Fixed broken hyperlink when voiding a pending CC/EFT credit transaction from the MBR history menu * Fixed MBR history menu display may display a duplicate entry for the same payment * Fixed javascript warning when login fields are disabled via the signup server contact form * Fixed deadlock on MSSQL and Sybase platforms when using the payment import file feature from the billing / post payments menu * Fixed signup server account creation transaction should fail if the CC card type / card length process does not complete successfully * Fixed make sure both service last modify date and last modify user are updated when closing an MBRs service * Fixed avaliable incident type listing shown in the incident search form should exclude types associated to a specific billing group where the operator does not have MBR access * Fixed when doing an account simple search with the Normal checkbox unchecked a blank screen is displayed instead of search results on the Oracle platform * Fixed rating engine memory leak when reconfiguring active rating rules and a custom classifier query has been associated with a rate Emerald 5.0.59 - 11/22/2008 -- * Added callerid and error type selections when searching RADIUS failure logs from the Emerald reports menu * Added create date in operator service display also shows the operator who created the service * Added bulk email recipient list can now be restricted by region * Added login and passwords fields in the signup server contact form can now be hidden or marked optional * Added multiple packages can now be assigned to individual signup servers, previously only all avaliable or a single package was avaliable for assignment * Added when configuring CC/ACH batch processors system specific labels are now displayed rather than internal generic labels such as Login and Password * Added support for FirstData PayPoint realtime credit card and ACH processing gateway * Added Transaction Central support of credits and voids for realtime credit card and ACH transactions * Added export system support for wildcard server certificates * Added RadiusNT/X advanced menu option to enable WISPr-Session data limit VSAs for NAS enforcement of data left restrictions * Added EmerAuth support for Imail 10 for listing emerald accounts from the Imail admin UI * Fixed receipt of accounting stop records with no input or output byte statistics may cause the services data left field to blank out when data banking is enabled (Does not effect rating system) * Fixed MBR recurring service listing for packages with services assigned to them may show the first service pay period rather than the package pay period if service pay period is not synchronized with package * Fixed commissions report now uses the MBRs sales person for any line items that cannot be directly associated to an individual service or package sales person * Fixed when an account has been canceled as of a past date and an adjustment not yet applied to an invoice exists the interim look-ahead hold period should not apply * Fixed error adding new custom reports from the admin report groups on the Oracle platform * Fixed when rating requests containing usage for both time and data dimensions data only rates previously required a dummy zero cost time rate to prevent the data only rate from being ignored * Fixed operators with restricted billing group access may not see all failed CC/ACH transactions avaliable to them from the billing / failed transactions menu * Fixed provide 405 response to web server HEAD method requests for dynamic content rather than blocking them * Fixed EmerAuth administrator not installed as a service when the EmerAuth optional component is selected from the Emerald installer Emerald 5.0.58 - 10/25/2008 -- * Added hyperlinks to asscociated MBRs from the billing / credit card and bank trans menus when previewing a batch export * Added when changing an incidents type, custom data values are preserved for custom data fields in the destination type labled the same as custom fields in the source type * Added row at the end of the global aging report showing amount totals for each aging bucket * Added four additional auxiliary transition types for external system synchronization * Added RADIUS attribute types for octets, integer64, tag_tunnelpw and tunnelpw * Added notice to send daily summary of operators open incidents and allow notice type queries to specify OperatorID in lieu of CustomerID/AccountID * Added summary emerweb function to apply grouped results for min, max, avg, sum and count against an internal query similiar to SQL aggregate functions * Added calendar emerweb function to render a month calendar for reference and scheduling * Added httpget emerweb function to post requests to a remote server and process the response in urlencoded, xml, ini and raw formats * Added scheduled log trimming now also trims expired one time tasks from scheduling and log tables * Added mail aliases provisioning for the Everyone.Net external system * Added eNom external system for provisioning new domains and renewing currently registered domains with eNom * Fixed when showing incident actions from the customer center for an incident with customer access enabled only actions created with customer access checked should be displayed * Fixed minutes displayed in the online session report is not accurate when viewed by an operator without global MBR access to all billing groups * Fixed cumulative monthly tax types calculated against recurring line items billed for dates starting and ending in the same month may not be applied * Fixed recently added fields were not copied when an export configuration for CC/EFT and provisioning is duplicated using ExportCopy * Fixed when rating external VoiceCalls CDR table using the built in voice calls rating source results may not be commited to the database * Fixed modifying an MBR assigned to a billing group having since been disabled results in the MBRs billing group being changed when the MBR is saved Emerald 5.0.57 - 9/20/2008 -- * Added checks to prevent operators from submitting more than one pending credit against an existing credit card transaction * Added credit card and scheduler related alerts to the daily error summary and reordered alerts so that the more important messages are displayed first * Added allow operators to search incidents assigned specifically to other operators sharing common roles or all operators based on search incident assignment operator group rights * Added enable incident assignment for operators within roles where target/max open incident loads have not been defined * Added phone number search option in web interface / client settings menu to enable slower but thorough pattern matching of entered phone numbers against MBRs and additional address fields * Added support for external linking to specific Packages (pkg.ews?PackageID=x) * Added client side validation support for domain name acceptable character rules * Added when an operator session is established via HTTPS Emerald assigned cookies are marked to prevent them from being used via HTTP in the future * Added improved compatibility with some debian based x64 Linux distributions * Fixed configured operator home page incident listing should not show open incidents for accounts that have since been removed * Fixed floor and ceiling values shown in the admin / accounting / tax configuartion summary display were transposed * Fixed cumulative monthly tax type with a configured floor calculates an extra taxable month for recurring services with pay periods greater than one month * Fixed created operator name not set when creating a new adjustment within an MBR * Fixed Everyone.Net new domain provisioning and change of service type (offers) may fail to properly synchronize with the Everyone.Net web service * Fixed path column bind error reported when using the IIS export synchronization to provision IIS services * Fixed when distributing credits to invoice line items in cases where the credit amount has already been distributed and later revoked due to prior invoice voids the full amount of the credit may not be fully applied to avaliable line items until verify invoices is run Emerald 5.0.56 - 8/20/2008 -- * Added simplify service expiration warning notice parameters * Added support for ANZ eGate realtime credit card processing gateway * Added when removing an operator from an existing incident role a dialouge to reassign any of the operators existing open incidents is displayed * Added incident templating feature enabling incident type specific configuration throughout the operator and customer interfaces * Added allow custom messages to be displayed in the customer center change password form via the theme file custom_cust_passwd.ews * Added reset last modify user and last modify date fields when deleting an MBR * Added emerauth serv-u integration has been updated to support 6.x API version * Fixed failed batch transactions notice did not notify end user on CC/EFT processing failures in most cases * Fixed prevent unecessary void and reinvoicing when canceling service types configured to not calculate credit pro-rate on service cancellation * Fixed intermittent SSL message authentication check failures or AV can occur with high numbers of concurrent SSL connections * Fixed automatic new statement creation can be held up by canceled serviced in an active state * Fixed allow select list emerweb function to be used in situations where no operator context is available * Fixed logging of messages to the Emerald audit table for message types having no description failed * Fixed when adding a range of addresses to the RADIUS managed pool a javascript validation error may be incorrectly displayed for certain valid range combinations Emerald 5.0.55 - 7/22/2008 -- * Added prevent POS payments from being ordered non chronologically for MBRs having a non CC/EFT payment type * Added commission detail report providing commission summaries at the MBR level by sales person * Added deferred revenue by GL summary report to show current deferred revenue * Added MBR history report is now sortable by column heading * Added allow four digit accuracy when creating adjustments or POS items for stored charge type amounts * Added changes in Emerald configured offers or service types and new domains are now synchronized to accounts provisioned via Everyone.net * Added option to hide the make payment menu item from the customer account center while the MBR has a zero or credit balance * Added sync procedure import configuration object enabling dynamic external system synchronization update procedure selection * Added type=word parameter to emerweb decode function to support inline word or phrase level substitutions * Added ungroup emerweb function now supports column prefix matching * Added service templating feature enabling service type specific configuration throughout operator, customer and signup interfaces * Added domain expiration field and the ability to sort by column to domain list * Fixed Static-IP reservations for MBRs or Services that have been deleted rather than inactivated may not be automatically returned to the address pool * Fixed when canceling an MBR from the customer account center clicking the cancel date calendar button results in a javascript error * Fixed clearing a non-operator user session from the active sessions listing may fail redirecting the operator to the operator home page * Fixed pay periods configured to be accessable only to a specific service type were still assignable to other services * Fixed synchronize last modify user field with the operator closing an MBR Emerald 5.0.54 - 6/12/2008 -- * Added export system import variable support for fixed width and delimited responses when processing CC/EFT or export transactions * Added support for Sage Payment Solutions realtime credit card processing gateway * Added assigned mail domain now displayed from the service detail screen * Added additional unescaped character exceptions when URL-Encoding data throughout Emerald for improved compatibility with systems which may not properly decode URL-Encoded data * Added upgraded SSL support libraries used to provide HTTPS access to Emerald and RADIUS EAP-PEAP/EAP-TTLS protocol support * Added substring matching of Login, Caller-ID and DNIS data within the call search report * Added commissions report was updated to reflect total adjusted monies paid over the reporting period separate from amounts invoiced * Added web server receive side improvements to better handle large amounts of received http request data * Added display void status for voided invoices shown via the MBR invoice detail display * Added MBR contact list report providing basic address and telephone contact information for active accounts * Added reduce RadiusNT/X and external system change synchronization overhead on large databases * Added static IP addresses can now be anchored to accounts from the RadiusNT/X managed IP pooling system * Added support for storage of encryption secret key via operating systems secure key store * Added customer settings option to hide display of avaliable credit from the customer account center billing information menu * Fixed when opening a new recurring account having an open pro-rate setting of 'full months' using a monthly billing cycle the pro-rated ending date is off by a day into the future * Fixed an error is displayed when adding a new non-packaged account from the manage accounts area of the end-users customer account center * Fixed cancel reasons configured with a negative sort order should be hidden from view while canceling an open account * Fixed custom data field labels displayed in the MBR edit form were not assigned to the CSS 'label' class * Fixed added workaround of firefox compatibility problem preventing rates and standard rating groups from being managed using the firefox browser * Fixed grandfathering of service group option inclusion throughout the admin UI preventing cases where existing configuration may not reflect the currently assigned service group * Fixed rating source attributes defined under the rating sources advanced menu option could not change or remove attributes added with labels containing non-alphanumeric characters * Fixed text alignment of the default themes service detail has been updated to match the alignment of the MBR detail display * Fixed when making one-time purchases from the end user customer account center package specific options should not be available for purchase if the MBRs package has no active services assigned to it * Fixed statement previews may incorrectly display additional items such as unprocessed or estimate invoices that do not appear on an actual account statement * Fixed statement preview should show starting date in the date column instead of invoice date for recurring invoice line items * Fixed controlled shutdown of the Emerald web server may fail on the UNIX platform if clients are still connected during shutdown * Fixed web server setting to disable SSL by setting the SSL Ports value to -1 was ignored * Fixed session manager fails to disconnect sessions when password field encryption is enabled in the Emerald database Emerald 5.0.53 - 5/9/2008 -- * Added dishonor payment option in case of EFT NSF or CC charge back * Added translation updates for all languages * Added changed expire coloring in simple and service account searches of recurring MBRs to match coloring rules of the MBR service listing * Fixed callerid search phone number lookup may take too long to complete on large databases * Fixed allow credit amount to be entered against an ACH payment from the history menu if the batch processor supports ACH credit * Fixed service custom data fields were ordered by name first instead of configured sort order * Fixed removed unecessary single day invoicing delay for non-usage based reseller invoices * Fixed reseller invoices configured to charge fractional amounts for partial months usage can sometimes be billed at the full months rate * Fixed if the allow custom charge type for adjustments accounting setting is disabled the last charge type avaliable when creating a new adjustment or POS invoice does not apply its default settings when selected Emerald 5.0.52 - 4/23/2008 -- * Added operator group rights preventing operators from choosing a preferred theme or language from the client options menu * Added external system synchronization messages are now included in the daily global sourced error summary report * Added RadiusNT/X DNIS checking rules have been modified so that DNIS groups only apply to service types with a DNIS group selected unless reverse DNIS checking is enabled * Added compatibility with Microsoft SQL Server 2008 while creating a new Emerald database * Added browser title displayed during end user signup can now be customized from the signup server configuration menu * Added MBR custom data fields can now be assigned to service groups * Added incident custom data fields with value lists referenced by incidents can now be removed from the incident type configuration menu * Added secondary setup charge for new accounts at the service type and package type levels * Added Custom Charge Type can now be removed from the type listing when creating an adjustment or adding POS invoice line items * Added changed automatic payment ordering to apply payment to recurring line items in chronological order before applying payment to outstanding POS invoices * Added domains can now be assigned to individual MBRs * Added new accounts added from the customer account center manage accounts menu can now choose from a list of avaliable domains when adding a new account * Fixed corrected minor rounding problem where the actual subtotal amount of invoice line items is rounded directly to two digits rather than rounded to 4 digits and then rounded to two digits matching displayed line item subtotal amounts * Fixed SMTP client has been updated to parse SMTP status response codes crossing packet boundaries * Fixed if the same notice is delivered to multiple recipients and delivery to all receipients fail the notice was added to actives anyway * Fixed after scheduling the external system synchronization from the external systems menu the operator is redirected to the operator home page * Fixed in rare cases unecessary pro-rates may be generated when invoicing recurring accounts with anniversary billing cycles * Fixed malformed web server post request may cause AV * Fixed final userexport synchronization summary counters displayed in scheduler execution log may not be accurate * Fixed when adding a note to an existing assistance request from the customer account center on the Oracle platform the additional note is not saved Emerald 5.0.51 - 3/27/2008 -- * Added Cisco Netflow V9 and IPFIX (RFC 5101) flow format support to the emernet collector * Added support for proxying Asterisk CDR data via Asterisk Manager API to RadiusNT/X for realtime CDR accounting * Added crystal reports activex print server control integration * Added allowed flow export host access control list to the emernet collector * Added custom_pkg_save.ews is now called from a package edit and a package add so custom code from custom_pkg_edit.ews can be processed during an add/edit. * Added enforce short term password lockouts for invalid accounts to prevent leaking valid account names * Added incident custom data fields can now be deleted even if they are currently referenced by an incident * Added custom queries can now be defined to populate the selection list of incident custom data fields * Added configurable client side regular expression field validation patterns and required status for MBR, service and incident custom data fields * Added allow login field parameter to be passed into the signup server contact form without being overwritten by the login field autofill feature * Added incident states can now be configured to apply only to actions within an existing incident * Fixed credit card expiration fields changed in the MBR edit form may revert to a previous value if a different country is selected after changing the expiration field * Fixed changing the amount of an existing check or cash payment from the MBR history menu fails only when the Oracle database platform is used with Emerald on the windows operating system * Fixed possibility of AV during garbage collection of operator sessions Emerald 5.0.50 - 2/11/2008 -- * Added scaling improvements to support large numbers of active accounts * Added enforce print batch limits for invoices and statements * Added current package status to MBR package display * Fixed when auto-voiding a CC/EFT realtime transaction due to permanent error or temporary error during task shutdown the void process may fail due to an unavaliable referenced transaction id * Fixed do not enforce task shutdown request during import phase of realtime transactions * Added support for USA ePay realtime credit card and ACH processing gateway * Added support for NELiX TransaX realtime credit card and ACH processing gateway * Added support for Protx realtime credit card processing gateway * Added rating engine options for voice sessions to include 60/30 and 30 second rounding * Added inactive batches shown in the prepaid batch menu are removed from the batch listing after two months * Added workaround for problem preventing Emerald web server service from shutting down using the SQL Native Client ODBC driver * Added license manager prepaid features * Added three sided conflict detection to MBR package configuration menu * Added primary service automatically updated for packaged services when moving between packages with different primary service types * Added hotkey navigation support for the oracle database platform * Fixed when voiding a pending transaction from the MBR history menu the user is redirected to the operator home page * Fixed when updating package settings the packages creation date and operator is reset * Fixed when voiding an invoice containing a recurring package line item - associated expiration and billed-thru information is not immediatly propagated to the packages services * Fixed when issuing a change of service credit for recurring services the resulting billed-thru date is off one day into the future * Fixed when applying service change credit adjustments the credited amounts were not immediatly avaliable to be distributed to subsequent invoices without clicking verify invoices Emerald 5.0.48 - 1/22/2008 -- * Added VoiceCalls table and datasource configuration for rating and displaying externally imported call records * Added invoice_cdr.ews and statement_cdr.ews reports to include CDR detail when the VoiceCalls table is used for Voice/VoIP rating * Added geographic updates for several countries * Added alternate coloring based on active status when searching accounts via the caller-id popup application * Added prevent unneeded package information from being displayed in the customer account center when a package is used exclusivly for providing customer access control * Added rating datasource configuration option to enable a re-rating procedure controlled from the Emerald Admin / Rating / Rating Datasources menu * Added signup options to enable collection of an alternate address during the end-user signup process * Fixed RadiusX database driver compatibility problem with Sybase ASE 15.0.2 or later on the Linux platform * Fixed automated product update fails refreshing procedures on the Sybase ASE platform * Fixed online session report does not limit view to only accounts within billing groups the operator is allowed access * Fixed display based table security checks failed to enforce all table + group access restrictions * Fixed malformed web server post request may cause AV * Fixed automated product update may fail on the Oracle platform depending on the configured database connection limit and other applications accessing Oracle * Fixed query error displayed while clearing online session status manually using the online report on the Oracle platform * Fixed provisioning of direct use prepaid accounts via RadiusNT/X first login may fail on the Oracle platform * Fixed no matching result warning displayed with search results when results are avaliable from the scheduler log search menu Emerald 5.0.46 - 12/28/2007 -- * Added SmarterMail email account provisioning via SmarterMail web service API * Added new check to the daily error summary report to display MBRs with an email send method who have no accounts configured to receive invoices and statements * Added workaround for IE7 browser problem on some systems where when generating a prepaid batch a blank screen is displayed * Added custom emerweb template custom_mbr_save.ews is now also run when saving changes to an existing MBR * Added Tropos RADIUS VSA attributes * Added operator audit logging to the Emerald administrator * Added trim options to the log trimming menu allowing after a period of time automatic removal of sensitive information from inactive or deleted MBRs and completed CC/EFT transactions * Added workaround for Oracle ODBC driver interfering with SSL operations on the Linux platform * Fixed Emerald admin UI Oracle updates to correct errors adding a new web url link and applying group level config setting defaults * Fixed update service last modify date when opening or closing a service * Fixed database error may be displayed when creating invoices for billing groups having the renewal move expiration strategy of proportional to payment * Fixed database error displayed when editing an MBR using Sybase ASE with a case sensitive character set * Fixed Emerald syslog server displays a database error on startup on the Oracle platform * Fixed cancellation date of an MBRs service is not enforced for RADIUS authentication unless expiration date is less than or equal to the service cancellation date * Fixed when manually adding a non bulk IP Address to an Emerald managed IP group a data validation error is displayed and the new address is not added to the group Emerald 5.0.44 - 11/23/2007 -- * Fixed call search report assumes input as default RDBMS date format for starting and ending search dates * Fixed javascript error noticed when applying a manual credit card payment from within an MBRs payment menu * Fixed end user signup fails when choosing the credit card pay method with a signup server configured to not request address information * Fixed rating engine AV when processing some configurations of realtime call records having no applicable rule sets * Added one time charge descriptions now included with initial package selection options displayed in the new customer signup process * Added default theme updates to support firefox version 3 * Added additional validation when assigning service types to package types via the package type configuration admin menu * Fixed validate all static length table elements to prevent memory overwrite * Fixed error processing credit transactions against previous payments with Authorize.NET in AIM mode * Added accounting settings to automatically close recurring renewal based MBRs after having been expired for a period of time * Added batch manager interface to the general admin menu enabling batch searching with option of resetting a batches print status Emerald 5.0.42 - 11/07/2007 -- * Fixed sortable tables displayed when there is no data avaliable lead to javascript error reported in the browser * Fixed after successfully scheduling a new notice the operator is taken to the operator home page rather than the scheduled task configuration dialouge * Fixed when signing up for a new account via the Emerald signup server no error handlers were assigned to verify credit card data for recurring billing was successfully recorded to the database * Fixed after upgrading from Emerald 4.5 the taxable MBR settings from 4.5 are not imported as tax exemptions in version 5 * Added package type listing in the Emerald Admin / Services menu are now sortable by clicking the columns description * Added account synchronization for CPanel provisioning control panel * Added account synchronization for DirectAdmin provisioning control panel * Added automatic voiding of failed auto bill CC and EFT transactions where new CC/EFT data is avaliable or manual payments are made * Added support for keyboard interfaced credit card readers enabling automatic (track 1) account lookup by credit card swipe or manual payment assisted by card swipe * Added scannable barcodes now displayed on invoice and statement reports * Added support for keyboard interfaced barcode readers to lookup invoices and statements via barcode scan and support for scanned payment posting from the Emerald billing menu Emerald 5.0.41 - 10/17/2007 -- * Fixed file not found error displayed while removing a tax associated to a tax group from the Admin / Accounting menu * Fixed possible AV when opening an account if there is a database connection error preventing the billing engine from loading * Added taxes can now be defined at the city and or postal code levels * Added tax type configuration providing logical groupings of tax rules so that only the most specific match within a group of like taxes is applicable * Added default character set of all outgoing email notifications are now unicode / utf-8 and require SMTP server support of the 8BITMIME ESMTP extension * Added allow batch processors to be assigned globally to all organizations and billing groups * Added reseller billing is now supported at the service and package level, previously services within a package were billed from the reseller billing pov as services * Added callerid search application will now pass credentials to new browser windows opened in a separate process if a session was not already established * Added price inclusive tax structures are now supported enabling disaggregation of the tax component of taxable one-time and recurring charges * Added display MBR current balance in payment import preview * Added prepaid card search options now avaliable from the Emerald client / Accounts / Prepaid Search menu * Added allow custom information to be displayed in the credit card payment form in the customer account center * Added support third party caller lookup URLs from the callerid search application if no matches to the calling number are avaliable Emerald 5.0.40 - 9/23/2007 -- * Fixed when running a bulk payment import from the billing payments menu no preview information is displayed and only the first item of the batch is imported * Added RadiusNT/X now supports RFC 4590 for SIP/HTTP Digest authentication * Added processing of multiple result sets for transactions processed through the export system * Added notice type to send contents of new incidents to those listed in the incidents email field * Added menu option under Emerald Admin / RADIUS / Auth Fail Attributes to provide customization of attributes sent during an authentication failure * Fixed when adding or changing RADIUS reject settings the operator is incorrectly redirected to the operator home page * Fixed page shown directly after operator login may not display correctly for non english translations * Added show notice log detail if avaliable in customer history * Fixed session manager based time left limit enforcement was not done for accounts not having a login limit defined * Added historical time and data left tracking enabling expiration of purchased prepaid time and data for one time charges and direct use prepaid cards * Fixed saving changes to an MBR package fails when the extension field is set to a empty value * Fixed when monthly time and data left updates are enabled services under MBRs assigned a non recurring billing cycle should not have their usage replenished * Fixed honor auth name and address field size restrictions when exporting CC transactions to an orbital paymentech gateway * Added when associating external systems to service types comment and external reference fields have been added * Added allow initial prepaid card direct use account setup to ignore the domain part of the login request * Added export system support for staging of multi-step provisioning tasks * Fixed scheduler AV when an error occurs obtaining a database lock for CC/EFT processing via the export system * Added account synchronization for WebHost Automations Helm provisioning control panel * Fixed when creating a new service the list of avaliable service types may contain duplicate entries * Added xmlinput emerweb function for processing external XML formatted data Emerald 5.0.39 - 9/3/2007 -- * Added improved included random batch card number sequence algorithms to make best use of avaliable number space * Added allow individual prepaid card batches to create up to 100k accounts from the previous limit of 1k * Fixed manual or periodic statements are prevented from being generated while there is no new invoice or payment activity * Fixed compatibility problems during new database install with sybase ASE 15 * Fixed prevent empty queries from being sent to the database for execution * Fixed global group settings in billing group configuration may not display the correct option status depending on the group avaliability of discounts * Added support for the Oracle database platform. Requires version 10g or later /w ODBC driver 10.02.00.03 or later * Added credit card expiration date is now also checked earlier via javascript throughout the operator and customer interfaces * Added workaround for Microsoft Internet explorer bug showing non secure content warning when using SSL with Emerald * Fixed when adding a new package through the operator interface the starting date is always today rather than the start date entered when the package is created * Fixed if multiple packages allowing the same service types are active in an account and a service of the same type is added to a package via the package interface the new service may not be assigned to the correct package * Fixed when changing passwords from the customer account center the last modify date and username are not set for the effected service * Fixed when using the Emerald voice rating UI static and bong charges may not be applied correctly to all prefix matches * Fixed when rating a record with multiple rates or a single rate with time and data rates static cost values may be applied to previously rated items * Added RadiusNT/X now supports EAP-TTLS with the TTLS authentication methods CHAP, PAP, MSCHAPv1 and MSCHAPv2 * Added configuration constraints to the Emerald voice rating UI * Fixed invoices may be created even when having no active invoice line items * Added support for localization of package name and customer description fields in the package type configuration * Added package type invoice and customer facing descriptions can now be set independantly of the package type label * Fixed allow MBRs with a zero credit limit to be included in the Overdue MBR advanced search results * Fixed when removing a roam server from the Emerald admin UI proxy attributes associated with other roam servers may also be removed * Fixed statement aging shows negative values for aging buckets containing credits * Fixed removed unusable global billing group option from the Accounts menu Simple, MBR and Service searches Emerald 5.0.37 - 7/31/2007 -- * Fixed new automatic credit card transactions are not checked for card expiration and marked as declined before being added to the transaction export queue * Fixed after canceling a service the termination reason described in the service detail view may not match the actual termination reason * Fixed when making a manual payment from the client operator interface masked credit card numbers are not accepted for payment * Fixed after reopening an MBR with an anniversary billing cycle that was previously closed the MBR billing day should reflect the opening starting date instead of the day the MBR was origionally created * Fixed AV when processing notices where no required from or subject data is avaliable * Fixed late payement fees were not being properly assessed based on statement aging * Fixed after successfully printing an invoice or statement batch from the print queue for postal mailing the print date on the effected invoices or statements was not set * Added prevent unsent invoices from being batch emailed or batch printed if they were created 45 days or more in the past * Fixed create statements menu showed pending CC/EFT transactions for accounts having been inactivated or deleted Emerald 5.0.36 - 7/12/2007 -- * Fixed show transactions awaiting import report should not display transaction warnings for deleted MBRs * Added upgrade invoice consistancy check procedure CheckInvoices can now adjust line items to match invoice amount on unknown cause when the mode parameter is 2 * Fixed reseller billing attempts to create duplicate invoices during a single invoicing run and correctly fails with a data consistancy error * Fixed informational messages from the emernet rating system should not be logged to disk unless the detail debug level is enabled * Added column headings of search results and data displays throughout emerald can now be sorted alphabetically or numerically * Fixed when forcing invoice next the invoice process should allow itself to be triggered by pending interim charges * Added current database activity display now shows blocked / blocking coloring if there are blocked processes * Added support for SecureNet realtime credit card processing gateway * Fixed invoicing may display a change conflict error when generating reseller invoices Emerald 5.0.35 - 6/27/2007 -- * Fixed default email field value when editing a service reflects the selected domains label rather than the domains DNS mail domain * Fixed when rating external data sources the StaticCost and InitialCost fields were not being honored if a rule set did not first upload them * Fixed rating engine IPv4 address range resolution error * Added removed support for SSLv2 from the Emerald web server. TLSv1 and SSLv3 are now the only encryption protocols supported * Added improved detail of SSL related error messages and prevent logging for some classes of expected connection related failure conditions * Fixed AV when canceling an account while there is an error validating the cancel request * Fixed replaced escape parser used for login and account search operations to prevent last character truncation * Fixed static tax amounts were not assigned to non-cumulative monthly tax types when invoiced for a single month or less * Added static tax amount prorate for non-cumulative monthly tax types of invoice line items covering less than a month * Added ability to target a different request URLs of the same protocol from the exports column editor * Added support for IntelliPay realtime credit card processing gateway * Added improved Show MBR field display for some types of MBR items that may not normally be configured * Added when configuring exports from the advanced menu all avaliable custom filters are now displayed in a selection list * Fixed advanced serviceless MBR search was displaying results for records that did not fit the proper critera Emerald 5.0.33 - 6/7/2007 -- * Fixed when editing an MBR within a country that does not support zipcodes a blank input box appears above the main MBR edit form * Fixed when adding a new service and selecting the cancel button at the bottom of the new service form an error message is displayed * Added support for full range of IPv4 CIDR prefixes to the rating engine * Fixed RADIUS server access configurations having a global service type selected where being ignored and allow configurations with no time of day specs were incorrectly treated as deny rules * Added Req/Resp code search source for RADIUS attribute filtering UI allowing matching of rules based on the request or response type of the RADIUS packet being processed * Fixed rating classifiers may incorrectly assume the MBRs billing day for MBRs assigned a non-anniversary billing cycle * Fixed service level call search report may not always display results in chronological order Emerald 5.0.32 - 5/23/2007 -- * Added new notice type to email payment receipts to customers who have made cash or check payments * Fixed IP access security if the administrator group allows all IP addresses access all other operator groups are granted the same access * Fixed radlogs search report showing duplicate results for operators having MBR Global access where there are not duplicate matching services * Added TLS certificate and host validation for transactions processed through export system * Fixed some classes of TLS handshake errors through the export system did not present a descriptive failure reason * Added when creating a new database if the query to retreieve an avaliable list of databases fails an input box is displayed for manual entry of database name * Added when adding an MBR assigned to a package a new services service type defaults to the primary service type for the selected package * Added include database owner information when creating a new Emerald 5 database on the Microsoft SQL and Sybase ASE platforms * Fixed when an account is invoiced for a future period under renewal billing where the previous invoice had not been paid if the previous invoice is paid and the latest invoice is not the expiration date of the service may not change to reflect payment of previous invoice * Added allow operators and sales persons to be removed from the system in cases where the operator being removed is still referenced * Added when an operator changes their theme the theme database is now also refreshed allowing operator theme selections to take effect without having to use "Apply" changes * Added incident ordering is now influenced by priority for open incidents and priority is now shown in incident search results * Added when creating a new account through the end user signup-server the payment options form is skipped provided the only avaliable payment option is renewal billing * Added show pending time and or data totals for realtime usage fees in the billing status display of the customer account center * Added log trimming option for FTP transfer log and better pruning of server ports to minimize the number of unused ports over time Emerald 5.0.31 - 5/9/2007 -- * Added emernet data collector now supports 802.1q VLAN tagged ethernet frames in packet capture mode * Fixed emernet data collector was not always reporting both send and receive sides of an IPv4 packet in packet capture mode * Fixed error message is displayed while creating a new MBR assigned to a package during MBR creation Emerald 5.0.30 - 4/27/2007 -- * Added additional updates to better support the security countermeasures feature introduced in Emerald 5.0.29 * Fixed when editing an existing prepaid batch type the login and password sequence select lists do not default to their current values * Fixed closing an active web session from the Admin / Web Interface / Active Sessions menu succeeds but incorrectly redirects the operator to home rather than displaying a success message * Fixed when a signup server is configured to assume all signups are in a specific country the states shown in the signup form are not correct when the billing groups country differ from the configured country in the signup server * Added default prepaid card login sequences now accept prepended characters via the login prefix field when generating a new prepaid batch * Added warning messages when making changes to prepaid card sequences managed by Emerald to prevent overwrite of custom settings * Fixed when voiding invoices, deleting accounts or assigning default RADIUS attributes you may be redirected to the operator home page rather than completeing the intended action * Added show destination rate description field when listing destination rates of rating rules having the voice destination rating type * Fixed upgrade of calls table may fail if a call record has a null nas-port value * Added support for external linking to specific MBRs, Services and Incidents (mbr.ews?CustomerID=x, sa.ews?AccountID=x, incident.ews?IncidentID=x) * Fixed tax payments report may not show tax values for periods where tax was paid however all tax values displayed were correct * Fixed when creating a new incident or changing an existing incident the assignment selection list shows only 'myself' when there may be other qualifying operator roles that should also be avaliable * Fixed when a customers recurring credit card information through the customer account center their existing credit card on file is displayed depending on encryption and group right security settings * Added allow customers with manager rights to change their recurring credit card information through the customer account center when the allow payment change customer website option is disabled * Fixed an account search for unpaid invoices in some cases includes paid invoices within the search results * Fixed avaliable package offerings for a signup server did not concider the signup servers group membership incorrectly allowing packages specific to other groups or service groups to be displayed as signup options * Fixed when opening an inactive MBR that was not previously canceled a change conflict error of 'MBR Opening update' is displayed * Added automatic transactions for MBRs on CC or EFT auto pay with a default pay period having confirm trans enabled are now created as having to be confirmed * Added postal code field is not displayed within operator and customer MBR and credit card interfaces for countries that do not use postal codes * Added when signing up for new service from the customer signup server using a credit card the required status of AVS and CVV2 fields can now be controlled from the Emerald Admin / Web Interface / Customer Settings menu * Added customer signup server required field coloring in the contact and payment areas using the style label_required * Added billing group options to hide printing of invoice and or statement from the Emerald billing / send bills menu * Added account status display from the customer account center now shows the total of any currently pending credit card or EFT transactions for customers with manager access to their MBR * Fixed when displayed selection lists throughout the Emerald UI contain no items a javascript error may occur when performing client side validation of form input * Added additional consistancy checking to the verify invoices menu option in the MBR invoicing menu * Added when upgrading to Emerald 5 from an Emerald 4.5 system previously upgraded from Emerald 2.5 common data inconsistancies in Emerald 2.5 data are automatically corrected * Fixed remove print receipt checkbox from the Emerald customer center make payments form as receipts are avaliable only after batch processing from the billing menu Emerald 5.0.29 - 4/4/2007 -- * Added improved layout of the POS invoice line item form * Added customer account center option allowing customers to change their accounts login name * Fixed crystal reports "configuration error" displayed when emerald is installed in a folder containing spaces in its pathname * Fixed when a prepaid card direct use MBR and service are created the default remote access privilege should be 'manager' rather than 'service' * Added support for "bytes left" similiar to the "time left" fields used to enforce data usage based access limits * Fixed additional filtering in the Emerald customer center to keep customers from purchasing time/data options that would have no effect on their accounts due to incorrectly configured one-time charges * Fixed application of payment against one-time charges may result in an error causing the payment operation to fail * Added time and data limit values in the Account Status display of the Emerald Customer center are now updated in realtime during active RADIUS sessions * Fixed incorrect service type default limits may apply when creating new accounts via the signup server * Fixed when using the rule matching status field when rating external data a static per session cost should count as a match while default rule matching is disabled * Added included updated windows packet capture driver with EmerNet * Fixed while configuring server port access deny rules a javascript error may be displayed and the deny selection option may not be stored when saved * Added reverse ordering and inactive coloring for disabled service types and domains * Added new export system synchronization capabilities enabling complex network and web service based provisioning * Added support for Everyone.Net email hosting provider * Added per account external sync errors are now displayed in the services account detail summary * Added domains can now participate in service groups and new external reference fields for domains * Added external system type specific custom parameter fields * Fixed existing discounts, sales persons and pay periods are not defaulted in the selection listing when editing a service where the current item has been disabled from the admin menu * Fixed small memory leak in template based credit card processors and external export system * Added emerald customer center prepaid card recharge feature allowing direct use based recharge of existing accounts * Added per RADIUS client disconnect attribute settings allowing attributes sent to be enabled or disabled on a per client basis * Added support for sending Called-Station-ID attribute in disconnect messages initiated from the Emerald online list * Fixed when disconnecting a session from the Emerald online list disconnect failure messages may not always be displayed when avaliable * Fixed crystal reports printed through Emerald may produce an error or not display properly if the database name stored in the report does not match the name of the Emerald database * Added replaced emerweb deferred memory queue with reference tracking system to better detect errors * Added access logging improvements when a large number of operators are using Emerald at the same time * Added updated french language translation * Added when configuring external rating datasources from the Admin / Rating / Data Sources menu a new "billing mode" option toggles logging of rating results to Rate History * Fixed printable payment receipt is not displayed when applying a payment with the print receipt option selected * Fixed when using the bulk email option to send messages the entire contents of the message may not be included in outgoing emails * Fixed current balance displayed in the MBR detail is not updated when changes are made to an inactive accounts balance such as making a payment * Fixed Point-of-Sale and Adjustment MBR menu items must not be avaliable to inactive MBRs * Fixed MBRs having a cycle type of non-recurring should not dynamically update account expiration based on recurring rules * Fixed when signing up for new service using the signup server having a package type of non recurring with one-time charge for the initial purchase some service type default settings must be ignored based on the one time charge configuration * Added continually refresh Emerald customer center account status display while accounts have run out of time or data to reflect realtime status changes * Fixed when login changing is allowed customers should still not be able to change their login to a blank value from the manage accounts / change account login area in the Emerald customer center * Added credit transaction support and improved response messages for the paymentech orbital batch processor * Fixed license feature enforcement error messages were not being displayed * Added security countermeasures for client initiated requests initiated by links from external domains * Added Emerald database can now be backed up on a recurring or one time basis from the Admin / Database / Backup Emerald link when using the MSSQL database platform * Added when adding a new MBR from the Emerald client interface CC or EFT entry forms are displayed automatically when the new MBR has a payment type of CC or EFT * Fixed rating engine AV when processing external datasources with numeric rating rules having a "less than" match type * Added when rating data using the custom datasources rating menu StaticCost and InitialCost can now be specified in the rating request result set in addition to rating upload attributes * Added Voice Destination Rating type enabling DNIS specific rating and easier import of rate tables * Added allow signup server to be used when Emerald is not licensed for billing features * Fixed when searching for an incident by IncidentID and other search critera is defined that critera should not be concidered Emerald 5.0.28 - 3/14/2007 -- * Fixed email notices configured from the Admin / General / Notices menu may show the 'Schedule' option even after that notice has already been scheduled. Also when scheduling a notice from this menu the default notice type is incorrect and must be manually changed to 'tasknotices' * Fixed default credit limit and one time setup extensions are not set while creating a new MBR from the Emerald client interface * Added missing "Renewal move expiration forward strategy" and amount fields to the Admin / Accounting / Settings menu * Added support for moving expiration date forward proportional on a days scale to amount paid * Added support for requiring full payment before expiration is moved forward * Added in some cases the service expiration date can be rolled back when voiding invoices * Fixed application of invoice line item payments was ordered by invoice number rather than invoice creation date Emerald 5.0.27 - 3/9/2007 -- * Fixed payment distribution for credit adjustment amounts assumed a quantity of 1 when distributing payments to invoice line items * Fixed Credit Card or EFT payments applied to a specific invoice was not distributing the payment amount to the invoice before distributing the remaining payment amounts to invoce line items in reverse chronological order * Added allow custom cash payment types (Other #1 and Other #2) to modify the value of existing payments from the MBR history menu * Fixed insufficient precision in fractional rounding during invoice related billing processes (.499... rounds up rather than down in some cases) * Fixed recurring end date calculation on the Linux platform may be off by a day if the calculation covers a change in daylight savings time status * Fixed payments report payment type totals display did not properly concider change in payment amounts over time * Added card transaction type is now displayed in the credit card export preview display * Fixed typo in buttons_sa.ews theme file that may cause MBR service menu to display incorrectly with some language translations * Fixed customer account center should not show invoices that have not been processed such as POS estimates * Added notice to notify operators when incidents assigned to them have been updated with new actions * Added include local RADIUS server client entry by default to allow RADIUS settings update from admin 'apply' button * Fixed rating no data rules are loaded if there are no time rules assigned to a rate source Emerald 5.0.26 - 2/25/2007 -- * Fixed package type global option can not be changed from the admin / general / billing groups menu * Fixed loop while invoicing customers with tax configurations having the monthly cumulative type * Fixed duplicate login checking via the service edit form should ignore deleted accounts * Fixed many ews formatted custom reports included with Emerald do not display data when a specific billing group is selected with the report parameter options * Fixed incident searching with assignment option of 'to me' or 'Created by me' did not properly restrict incidents to the operator performing the incident search * Fixed when upgrading from Emerald 4.5 credit card type information is not calculated for Emerald 5 requiring the 'Any' card type to be checked in the batch processor configuration to process automatic card transactions * Added credit limit field is now always accessable via the edit MBR form regardless of weather the MBR has a balance forward or renewal billing cycle * Fixed database upgrade process from Emerald 4.5 fails for previous configurations of custom MBR and service data where one or more accounts have multiple values for the same attribute * Fixed free service and free MBR advanced search options were incorrectly showing accounts having a non-zero recurring cost * Fixed when rating charges for a month and user that has already had charges applied an error may be displayed when rating data covering the previously billed month * Fixed revenue by service type custom report displays incorrect or no results * Added MatchStatus row update variable for rating data sources allows determination of weather any rule sets with no default value (cost < 0) have matched * Added ability to treat non-processed POS invoices not marked as estimates similiar to estimates so that they can be processed in the future * Added EmerAuth support for Imail 2006.2 * Fixed when making a payment from the MBR menu the currently selected payment types options may not reflect that type if the default payment type sort orders have been changed * Fixed EmerAuth admin "invalid license key" error message is displayed when saving settings with a valid license key * Added support for two user definable cash oriented payment types * Added feature updating avaliable payment types via the admin / accounting menu allowing type descriptions, GL Codes and sort orders to be customized * Added default new MBR credit limit can now be set on a global or per billing group basis for balance forward accounts via the admin / accounting / settings menu * Fixed when enforcement of cost base session limits are enabled and the rate assigned to an account is a data only rate configured for session limiting the authentication request should be rejected when the avaliable realtime credit limit has been exceeded Emerald 5.0.25 - 2/11/2007 -- * Fixed when adding a new MBR after the Region option has been removed from the new MBR form via the billing groups menu an error is displayed. This can be fixed in current versions by going into the Admin / Advanced/ Meta Tables menu. Choose the numbered link for 'MasterAccounts', Choose 'RegionID', set nullable to 'Yes'. After updating the form click the apply button for the change to take effect. * Added support for IPWireless RADIUS VSA dictionary * Fixed custom data may be displayed at the MBR or Service level that is marked not visible by the data field configuration. (See Admin / Advanced / Acct Data Fields) * Fixed error displayed when adding IP Security entries from the Admin / Security / Operator Groups menu. This can be worked around in current versions by using the Admin / Security / IP Security menu. * Fixed removed Domains from service group Include/Exclude configuration as Domains can not participate in service groups * Added emerauth NTMail/Gordono Mail data format update for listing accounts within a domain * Fixed prorate options for package types did not appear in the admin package type configuration * Added database upgrade process and verify invoices now creates charge for all credit line items not already having an assigned charge * Fixed when upgrading from Emerald 4.5 remove ServerID from call records where the specified server no longer exists * Fixed while exporting credit card transactions to a batch file the error "external trans update failed" is displayed * Fixed current status of scheduled tasks may sometimes not update upon completion of a task as shown in the scheduler current activity display * Fixed reduced scheduler status window stay after successful task completion * Added support for transaction type sections when configuring an export template from the Admin / Advanced / Export menu * Added support for the Linux platform * Fixed loop when calculating prorate for future cancelations that effect services not yet billed in combinations of months and days in advance * Fixed when voiding cc or ach transactions that are awaiting batch import an error was displayed * Fixed invoices and statements were showing in the send bills summary display which should have been excluded by the "print 0 balance or credit" invoice and statement rules * Added initial support for sybase ASE 15.0 or later and updates to support case sensitive databases. Note: the "ddl in tran" option must be enabled on tempdb and we recommend utf8 as the servers default character set * Added it is now possible to mark invoices as having been sent similiar to the statement mark sent option * Fixed sent date display in invoices and statements now take into account any avaliable print and or email dates * Fixed improved bill day recalculation when upgrading from Emerald 4.5 Emerald 5.0.24 - 1/20/2007 -- * Fixed missing routing and auth name for manual ACH transactions * Fixed pending ACH transaction listing in billing menu does not correctly display bank number when data encryption is enabled * Fixed Auth.Net support for Void, Credit and Auth Capture * Added support for Transaction Central realtime credit card and ACH/EFT processing gateway * Fixed balance forward billing with credit limit exceeded should continue to invoice recurring services as did Emerald 4.5 * Fixed default billing cycle options included with new Emerald 5 installations were very confusing * Added support for multiple web server bind addresses with independent HTTP(S) listen port and certificate settings * Added support for PayPal's (formerly Verisign) Payflow Pro Credit Card and ACH/EFT processing gateway * Fixed error displayed after deleteing a credit card import column in the advanced options exports editor * Added limit ACH/EFT credits to the entire amount of the ECheck * Added support for case sensitive databases * Added workaround for IE7 print rendering bug in default statement report preventing the bottom portion from being displayed on all but the last statement when multiple statements are printed at once. If upgrading from a previous version of Emerald the updated statement reports are located in the orig/reports folder. * Fixed allow crystal reports without parameters to be displayed from the custom reports menu * Fixed query error displayed when editing an accounts radius attributes when the attribute is a string containing a space or other non alphanumeric values * Fixed when editing a service type RADIUS attribute from the admin/service types menu and the attribute is a string containing a space or other non alphanumeric value portions of the value may be missing in the edit attribute form * Fixed customer account center account status refresh for expired accounts can incorrectly redirect to Emerald login page rather than customer information page * Fixed when invoicing a recurring service pro-rated to align to the MBR/billing cycle day of month and the account is also being invoiced for the next whole pay period the next period starting date is one day ahead * Fixed recalculate bill day based on account billed thru dates during database upgrade from Emerald 4.5 to prevent unecessary prorates on first billing after upgrade * Fixed relaxed start date constraint disallowing invoice creation after canceling an MBR earlier than the accounts start date so that any necessary pro-rated invoices can be generated