NetForum Enterprise 2017.1.4 Build

Below are all resolved issues in version 2017.1.4

--- Added for service pack items only, the fixed 'previous build' column. If the column is blank this indicates the item is new to 2017EP version.

Go to Hotfix: Hotfix 1Hotfix 3Hotfix 4 Hotfix 5Hotfix 6

Netsuite ID Module Description Previous Release
14029 Exhibits Clicking on Exhibitor -> Exhibitor Management -> Can't register booth personnel in the exhibit module Booth Personnel causes errors to be logged into the error log 2017.1.3.2
17979 Accounting System Option: EWebInvoiceLineItemRemoval not functional 2017.1.3.5
18229 Accounting Lockbox Import Error for Multi Currency customer 2017.1.3.2
18993 eWeb Incorrect event time is displayed on the outlook calendar 2017.1.3.5
19978 Baseline Reports/Queries "Invoice With Format" report (Receipt): the CVV is not available on invoice  
20872 Payment Processing Error processing installment following Vantiv account update AAU 2017.1.3.5
21062 Framework Two of the parameters of the md_web_page_detail_list Stored Procedure (@wbc_page_name and @wbc_code) are open to SQL Injection attacks. 2017.1.3.2
21228 Accounting The "Finance Charge" generate with "invoice date" instead of the time period it is charged and only one "Finance Charge" is generated 2017.1.3.4
21474 Accounting When a fully recognized invoice that has 2 discounted line-items (1 item > $0; 1 item = $0), the discount is deferred is adjusted, the adjustments created cannot be processed when closing the batch.  
21540 Membership SP ‘mb_membership_proxy_populate_by_member’ contains a mass-insertion into mb_membership_proxy_ext table which can cause data conflicts and rollback of processes. This can cause processes like the batch-close process to fail 2017.1.3.4
21626 Accounting "Ending Balance" on "Revenue Recognized" report does not match that of the deferral record if there is a WriteOff 2017.1.3.2
21675 Outlook Integration Outlook Integration - delete email (co_email.eml_delete_flag = 1) should not display / Recipient should display 2017.1.3.2
21699 eWeb eWeb: Adding a Membership on eWeb without login (anonymously) does not add selected item to Cart ("Your Shopping Cart Is Empty") 2017.1.3.2
21722 eWeb eWeb: Unable to use "Make a Donation"/ "QuickGift" form on eWeb (error "UNABLE TO PROCESS.") 2017.1.3.2
21839 eWeb eWeb: "Check all" checkbox for "My Communication Preference" does not work  
22017 Accounting Cannot edit GL Account which is set up for "Account Split" on multiple prices - GLAccount data object 2017.1.3.2
22026 Events Internal and external notes added when adding an event sponsor invoice from the event profile don't show on invoice 2017.1.3.2
22128 Events "Delete Proforma Invoices" task for "Golf"/"Dinner Table" registrations generates the error [constraint "FK_ev_registrant_x_grouping_ev_registrant"] 2017.1.3.4
22183 CRM Designations are not being added with correct spacing/alignment 2017.1.3.5
22260 Accounting Multicurrency: Vantiv – "Japanese Yen"/"foreign currency" incorrectly charges the amount submitted from netFORUM  
22270 General EnableViewState Changed in DynamicEditModal.aspx for SP5 HF16 2017.1.3.2
22278 Accounting “A G/L account is missing” error when returning partially-paid, partially-recognized invoice and NOT selecting "writeoff unpaid recognized deferral amount?"  
22323 Admin “Import File Save Task” fails on COE object, error: "Failed to Insert Centralized Order Entry record. Object reference not set to an instance of an object" 2017.1.3.2
22326 Baseline Reports/Queries The Inventory "Stock Status Report" does not account for inventory transfer/re-allocation between warehouses 2017.1.3.5
22409 E-Marketing When Invoice Date: "inv_add_date" is parsed in email templates, it shows the time stamp 2017.1.3.2
22415 Baseline Reports/Queries "Invoice With Format" report (Receipt): the CVV is not available on invoice 2017.1.3.5
22483 Fundraising eWeb: duplicate confirmations sent when "gift template" is set in the "Campaign Profile" and a donation is made via eWeb 2017.1.3.4
22526 CRM eWeb: If a "Subscription Message"/"Mailing List" is unchecked in "My Communication Preferences" the system adds an "end date" (mk_mailing_list_detail.mld_end_date) preventing it from showing up again  
22543 eWeb Google Analytics Ecommerce Tracking not working 2017.1.3.4 2017.1.3.4
22594 Accounting "Drop Membership" and "Delete Proforma" tasks fail with error "Task: The transaction operation cannot be performed because there are pending requests working on this transaction." 2017.1.3.2
22619 Accounting Batches are allowed to be "closed" and "posted" to "inactive/hidden/deleted" GL Accounts 2017.1.3.4
22655 Membership "Order profile": Installment schedule incorrect if Credit Card fails 2017.1.3.2
22675 CRM iWeb: "COE > Line Items": updating "net payment" does not perform postback properly (error "Object reference not set to an instance of an object") 2017.1.3.4
22739 Membership "Membership Transfer" - not assigning current price in code MemberTransferMembershipNewItemDataRow 2017.1.3.4
22804 Admin "Recurring Gift Task" not releasing memory/ task fails with "out of memory" error 2017.1.3.2
22823 eWeb eWeb: Tax for download products only is being applied to non downloaded product 2017.1.3.2
22862 Accounting Multicurrency: Discounts not shown correct in batch (batch amount = product amount "+" discount amount) 2017.1.3.5
22884 General 2015 Upgrade - eWeb Performance 2017.1.3.3
22914 CRM Accumail Address validation response code error handing issues  

Hotfix 1

Netsuite ID Module Description Dev Notes
21513 Accounting Posting batch results in error batch not balance for enity with Intacct Integration multi company accounts Changed the way the dimensions (class, location, department) are being retrieved by the ac_batch_close_payment_select and ac_batch_close_invoice_select sprocs during the batch pre-process functionality from the batch profile.
22125 Accounting "Revenue Available for Recognition" report "Include Open Batches" checkbox pulls no data/ the report is blank Updated the SP parameters on the ac_deferral_revenue_available_recognition report file so data is pulled properly.
22458 Inventory Item with DECLINED credit card can still be Fulfilled (SO: RecognizeRevenueDuringFulfillment = "true") Fulfill orders with the System Option RecognizeRevenueDuringFulfillmentIgnoreFailedPayments set to false, verified that the item is not fulfilled and the exception is added.
22510 CRM When choosing a saved/stored ACH payment method, the CD screen doesn't pull in the saved "account number" Added a new condition on the Control Data for pin_eft_account_number, pin_eft_routing_number and pin_eft_account_type, in order to invisible those controls when pin_cpi_key is empty.
22552 Subscriptions "Subscription Fulfillment" process incorrectly reducing the number of issues "remaining" Implemented a new function to calculate the number of issues remaining, use that value in the cp column.
22901 xWeb xWeb: Cancel date not updated when making an xweb call to the ev_registrant object The cancel date is now updated on xweb call to event registrant.
22917 Accounting No "credit" created and the "refund" does not go to the payment processor after "return/cancel" on an invoice and selecting "auto-refund" Added parameter to UpdateGridControl so that based on it the StartUp method will capture or not the posted value of the update grid before the initial creation of the control. Corrected validation of ret_distributed_liability_flag in ac_return.
22945 CRM "{CurrentDate}" in query builder includes timestamp which causes incorrect results for conditions that are equal to "currentdate" We have set the identity impersonate as true to apply a fix when a service running under NT AUTHORITY\Network Service account.
22954 E-Marketing When Invoice Transaction Date "inv_trx_date" is parsed in email templates, it shows the time stamp Removed the old logic that pulled timestamp when get the value equals CurrentDate in DataUtils method.
23030 Centralized Order Entry Adding "Installment Payment" Order with "First Payment date" in the future does not create "stored payment" info to process future payment Added a general fix to show a small datetime on template for different invoice datetime fields with a mask 99/99/9999.
23046 General Increase speed of SQL query to load UI links Removed superfluous logic from SQL used to load UI links to increase speed.
23042 UI [Current UI] No results if supersearch where clause includes extender table columns Changed sproc so that it can use extender table columns in the supersearch "where" clause.

Hotfix 3

Netsuite ID Module Description Dev Notes
20551 Payment Processing Voided same day payments are sent as credit to Sage [and all gateways] Updated InvoiceVoidExtension to allow netFORUM to attempt a gateway-Void if the operator wants to void all the payment details in a netFORUM payment.
22027 eWeb eWeb: does not correctly calculate Invoice Amount on a "partially paid" invoice that is added to the Shopping Cart Added, updated and deleted several fields over COE in eWeb forms, also fixed calculation for invoice.
22333 CRM Collective Payment: "payment to apply"/“credit to apply” subform grid not able to order by "Liability Name"  
22459 Accounting Price on Order is incorrectly set when "line item price" is modified in COE (SO: RecognizeRevenueDuringFulfillment = "true") Added a condition in order to update the orderDetail with the correct price, previously we just had a condition when a order did not exist and that was the problem.
22466 eWeb eWeb: When using the Add Individual process in eWeb, the person's e-mail address that is being newly added ends up within the individual record of the person that is actively entering the information Created a workflow for a IndividualEmail and Individual-eWeb (member directory) and verify that the emails are correctly updated.
22591 Accounting "Collective Dues": Unable to "Generate Next Installment" with end-dated/cancelled "local members" relationships (error “Cannot create an invoice w/o line items”) Added bypass for CancelAssociateOrderDetail method if the product is a *collective due* when running the scheduled task for returns. That way odd_cancel_qty in the oe_order_detail will not be updated incorrectly.
22995 CRM Designations removed/ deleted after "editing name & address" Designations after the first no longer deleted when saving the individual.
23021 CRM AddressCorrection: "Group1" address validation the URL endpoints need to be updated Changed config settings to use the new "pitneybowes" endpoint URLs.
23028 Framework Security groups with access are missing modules due to new stored procedure (cm_group_item_link_getNavByUser) pulling in hidden group items NavMenu modules and items are now accessible when marked as hidden.
23041 Reports "A/R Aging" report reporting "Discounts" as "outstanding amount" on installment invoices The Report logic has been modified when calculating discount to correctly deduct the discounted amount for installment billing invoices. All other types of invoices already had the discount amount calculated correctly from the invoice amounts.
23050 CRM Increase number of characters for "interest code" (itc_code) N/A
23158 Accounting "Create Next Installment": error has occurred in "AC.InstallmentBilling.GenerateNextInstallment": "Object reference not set to an instance of an object"  

Hotfix 4

Netsuite ID Module Description Dev Notes
22297 Development Toolkit Parameter set to NVARCHAR(2000) over-loaded with string of less than 700 characters (Stored Procedure "sc_merchandise_list") Altered sc_merchandise_list such that instead of preloading a long string of data onto a single variable, the strings are combined at query time.
22860 eWeb eWeb (mobile): Render menus dynamically from underlying CMS metadata, rather than hard-coded HTML (ensure a web page is viewed on a "mobile" device same as on a "desktop" browser) Refactored the default pane (Menu Bar) so now the web links are retrieved from database to build the Menu Bar dynamically.
22865 Events "Copy Event": Computed GUID column causes errors "The column X cannot be modified because it is either a computed column or is the result of a UNION operator" Added av_key validation in insert/update since in baseline we do not have a case where a computed column is av_key.
22972 CRM "Failed to load viewstate" error when trying to "add" new telephone number in Organization Profile The telephone form contains a lookup that is never used by the phone but it's the cause of the problem. Made sure that the sort made on load will only be done if the update grid does have sortable columns.
23011 Centralized Order Entry Error "Conversion failed when converting from a character string to uniqueidentifier" is thrown when paying a membership invoice that has a complementary product and "RecognizeRevenueDuringFulFillment" system option is "false" Added a conditional statement to not set the oOrderEntry invoice key with an empty value.
23128 Accounting "Fundraising > Add Gift": adding "recurring" gift with "First Invoice On" date in the future does not create "stored payment" info to process future payment System now allows to have an order with a linked cpi even if a payment is not applied by calling CreateCustomerPaymentInfo in the insert of ac_installment_billing only if there is no payment to do.
23137 Fundraising [Performance] Gift Details Task performance to be improved by two new indexes. No behavioral change Added two SQL indexes to improve performance of Gift Details task.
23153 Payment Processing Payment_Process: Wrong fields are displayed at "Add Payment Wizard" form for "Check" payment method. Deleted unnecessary conditions for making invisible the following controls: pin_eft_account_number, pin_eft_routing_number, pin_eft_account_type.
23158 Accounting "Create Next Installment": error has occurred in "AC.InstallmentBilling.GenerateNextInstallment": "Object reference not set to an instance of an object" Added checks in AC.InstallmentBilling.GenerateNextInstallment to handle condition when the oFacadeObject is null.
23166 Membership Adding "Installment Payment" Order with "First Payment date" in the future does not create "stored payment" info to process future payment for memberships System now allows to have an order with a linked cpi even if a payment is not applied by calling CreateCustomerPaymentInfo in the insert of ac_installment_billing only if there is no payment to do.
23167 Accounting "Collective Dues > Select Invoices to Pay" form: "distribute credit" applying incorrect "credit amount" / does not distribute FULL "credit amount" Corrected issue in ac_invoice_detail to stop add to credit to apply when the credit had no more balance left. Also improved the performance of the DistributLiability method as well as track the idc_credit_to_apply during distribution.

Hotfix 5

Netsuite ID Module Description Dev Notes
17597 Accounting Cannot close batch due to calculation of split-revenue being partially recognized. Fix was a refactoring on the process deferral for payment return where the return code and amount is added on ledger table, but the gl account for the unrecognized portion is missing when we have split prices.
21578 Reports "Customer Statement" report showing the incorrect "Bill To" customer Changed the "Arrange by Sell to or Bill to Customer" parameter logic in the sproc to use the Billing customer over the Invoice customer when the "Either" option is selected.
21904 eWeb eWeb membership renewal does not display all information and use different layout if membership renewal is linked to a chapter membership Made a metadata change of layout type on the grid control for the membership chapter object (DESIGNEDLISTCONTROL_DOD_Chapter Membership).
22734 CRM "Add Organization" allows you to "save" without an address/"Edit name & address" form - the address is "Required" [2014] Removed the address initialization because we do not need to populate the address at the beginning. [2017] Removed read only and required logic because is not required add an address for a organization when you Edit name and address.
22831 Exhibits Sponsor purchase for Exhibits does not send "confirmation email" correspondence Set missing fields cct_key (email template key) and eml_key (email key) to send the email confirmation on exhibit event sponsor component.
22960 Centralized Order Entry COE: The "Apply Credit" link is not visible when "Bill to" field does not match "Ship to" field and "Ship to" has no credits The credit modal correctly uses the billing customer's credits but the link to access that modal was only displaying if the shipping customer had credits. The change was to the logic to check the billing customer instead of the shipping customer.
22971 Fundraising eWeb_Make a Pledge : Make a pledge from eweb creates an invoice and payment without payment information record Changed logic so that signed pledges will create the requested payment info record.
23001 Membership National Membership (with associated Chapter membership) does not update (dates flip, etc) when paying a transferred membership. This occurs when a membership is transferred after already having an open invoice created (such as a renewal) The mxi_mxi_key was set in CreateDuesInvoiceRecords method for a chapter and after that never cleared. Added conditional statement to clear the mxi_mxi_key if the membership does not have a relation with another membership and has a chapter related.
23063 Fundraising Fundraising>Gift : Adding a gift to "Gift Batch Entry" displays an error message "Valid Fund Price is not available, Please create a price with this fund." Called SetPriceKey method without validating if prd_key (in oProduct) or gty_key (in oGiftType) are different than the values in the Gift object.
23073 General Replace the current way we are handling the capture request to use SEVD Changed PostAuthorization method to work with SEVD to send the Capture request.
23089 Accounting Write-off "Account Split" issue during batch "pre-processing" - "Error: The Batch is not balanced" Changed call to MultiCurrencyModifications for writeoff to avoid using decPaymentAmount to override the led_amount.
23198 Payment Processing GatewayErrorLogger not working properly in a multi-threaded process Added ThreadStatic so each thread has its own instance, sharing all the threads were causing to log errors for successful payment that belong to another transaction. Note: This feature was added to 2015 so is not impacting 2014.
23235 Centralized Order Entry "iWeb > COE" form: changing "Ship To Address" after selecting a taxed publication does not update the "Tax" Updated logic to check when the shipping address changes and recalculate taxes.

Hotfix 6

Netsuite ID Module Description Dev Notes
22302 Events iWeb: "Event Group Registration Wizard" doesn't capture more than 20 registrants (limit) causing Payment error "This change does not obey the required constraints of the data"(constraint "FK_ev_registrant_ac_invoice_detail") Added an extension for removing elements of GroupRegistration collection each time that a postback is done and delete invoice details related with the registrant that was delete it.
22895 CRM The "co_email_optout.emo_optout_flag" remains checked even if the mailing type is unchecked in the "Individual Communications Preference" Added control to verify if the emo_opt_flag was checked or unchecked on promotional emailing type.
23019 Payment Processor SAGE Payment Processor: When an ACH payment is made and we try to "refund" payment an error appears "Credit could not be granted on the void: UNABLE TO PROCESS" Changed Sage ACH transactions to use CreditWithoutReference "07" TransactionType and null VANReference.
23070 Fundraising Fundraising>Gift : All left group items /"Navigation menu" expand to "page width" when editing a gift in "Gift Batch Entry" When creating the URL do not include modal parameter if we will not open a new modal.
23086 xweb xWeb: "WEBCentralizedShoppingCartOpenInvoiceGet" or "WEBCentralizedShoppingCartMembershipOpenInvoiceGet" discount not populating in "inv_discount" Discounts were not being properly accounted for when making calculations for several of the fields but making sure the discounts are calculated in will return the correct values.
23122 Fundraising [Current UI] Fundraising>Gift: when using "Gift Batch Entry", netFORUM seems to "go to" the "Abstract" module after clicking “Continue” to add the Gift to the Batch Removed invalid URL parameters that was causing invalid behavior on post back.
23178 CRM Individual Profile: not able to remove / delete designation The solution was to change original designation instead of designation to remove the correct designation in edit individual form.
23215 eweb eWeb: "Tax" rate for specific State (e.g. "DC") does not reflect change after "shipping address" changed on eWeb Added logic in order to distribute the new Tax amount, as we already have a method that the name is Distribute and receive as a parameter the type of the product; we just needed to call to this method.
23319 COI The page errors out if you try to display a wizard that is pointing to a user control. N/A