NetForum Enterprise 2017.1.6 Build

Below are all resolved issues in version 2017.1.6

--- 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 1 Hotfix 2

Netsuite ID Module Description Previous Release
18914 Accounting Invoice message that contains carriage return cannot be selected for a report 2017.1.5.6
19699 xWeb https connection problems with load balancer in place for renew membership and back button from add sponsor 2017.1.5.3
20086 CRM Error is thrown upon changing password using Web Login on Ind Profile if you reenter the start date -Your web account has been disabled 2017.1.5.4
20369 Inventory Disable the "Inventory Transaction" button if there is no Cost of Goods Sold to recognize 2017.1.5.4
20767 Events "Registrant Transfer Wizard": When transferring from one Event to a new Event the "transfer fee" is doubled 2017.1.5.1
22477 xWeb netFORUM 2013 Service pack for TLS 1.2 issue with table lock while using shopping-cart 2017.1.5.1
22599 Membership "Error: Payment method is required" generated when an "invalid" Credit Card is used when "adding"/"renewing" membership if "auto-pay membership" is checked 2017.1.5.3
22606 Accounting Accounting Period: "Revenue Recognized" report calculating "Cancels"/"Ending Balance" amounts incorrectly 2017.1.5.6
22652 Accounting Unable to Import Projects from Intacct across Multiple Business Units 2017.1.5.5
22673 CRM "Soft" deleted CRM records are not shown as deleted (missing "Record is deleted" notification) 2017.1.5.3
22874 General "TEST" watermark not available 2017.1.5.3
22939 Framework Need Grandchildforms in Current UI, Implement FormDesigner and Converter for Grandchildforms in Current UI 2017.1.5.1
22944 CRM LinkText MVC Widget does not recognize "_blank" in the "target" field and does not open WEBSITE in a new tab 2017.1.5.3
22951 CRM "Contact info > Addresses": "Select address to link" defaults to "individuals address" instead of "null"/"read only" 2017.1.5.3
22962 Membership "Def_next_period_recognized" set to the period after "def_arp_key_end" if Membership is purchased for the Current Year 2017.1.5.5
22980 CRM "Email to List" function is sending emails to email addresses it shouldn't, which is caused by being able to click the "Send Messages Now!" multiple times 2017.1.5.6
23014 Events "Export to ASCII/ CSV" does not convert column "names" to column "description" 2017.1.5.4
23033 CRM When clicking "GoTo record" on the "Subscriptions > Active Subscriptions" child form, it redirects to “Edit - Invoice Detail Term - Subscription Detail” 2017.1.5.3
23081 CRM "Organization Profile": the Organization "Sort Name" doesn't update when you change the "Organization Name"  
23087 CRM "Address change log" childform does not have address line breaks which makes address lines run together/ wrapped 2017.1.5.3
23099 Accounting If customer "upgraded to 2017.x" and has any invoices that are "cancelled" on an Order, they aren't able adjust installments because it sets the remaining prices to $0.00 2017.1.5.3
23107 Accounting "Add Payment": Unchecking "Auto Default" when "Adding Payment" causes Overpayment Credit in addition to payment 2017.1.5.4
23142 Admin Security groups: child forms do not honor "group child form privileges" 2017.1.5.5
23161 Baseline Reports/Queries "Invoices With Format by Batch"/"Invoices Without Format by Batch": the browser freezes when "Batch" parameter dropdown field has large dataset (32k+ batches) 2017.1.5.3
23174 General netFORUM defaultSQL is not considering "extender" tables and columns 2017.1.5.3
23175 General Lookups do not set "extender" columns into "Facade" when saved 2017.1.5.5
23211 CRM Address Correction issues with "Country" field (Occurs with CDYNE and AccuMail) (SO AddressCorrection = AccumailWebServices) 2017.1.5.1
23222 CRM AccuMail address validation: validate Address for adding "Suite #" puts the "Suite" in the "City" field (SO AddressCorrection = AccumailWebServices) 2017.1.5.1
23223 General Group item link security extremely slow for customers with a large amount of "Users" and/or "Security Groups" 2017.1.5.3
23225 Advertising "Add Insertion Order" error from "custom" extension causes form to clear fields/controls 2017.1.5.5
23231 CRM AccuMail address validation: when "linking" an Individual to an Organization issue (SO AddressCorrection = AccumailWebServices) 2017.1.5.1
23232 eWeb eWeb: "Complimentary gifts" page does not display the "donation Purpose"/"donation Amount" when "Purpose"/"Amount" are setup on the "Fund Profile" 2017.1.5.1
23274 Centralized Order Entry "Credits applied" are cleared out when you select "terms" invoice and you are paying 100% of the cost with "Credits" 2017.1.5.3
23300 Fundraising "Fundraising > Constituent Profile": Customer "Source Code" cannot be removed from Organization record 2017.1.5.2
23330 Accounting Changing "Project" merchandise PRICE makes Batch unclosable (Batch gets stuck in "close batch" process at 80%, error with constraint "FK_ac_ledger_ac_project1") 2017.1.5.4
23338 Accounting Intacct Integration: "Department" and "Class" dimensions incorrect in "ledger" record when a product is "purchased" and is "NOT paid" and then "returned/canceled" for a product that uses "price override account" for dimensions 2017.1.5.1
23349 CRM CRM: "Audience Counts" appearing as "0" (zero) when list table "joins" contain aliases ("From Table Alias") 2017.1.5.3
23352 Accounting "Add Payment" wizard: when you convert a "proforma" invoice to an "installment billing" invoice, it shows "payment amount" for the first TWO payments even though only the FIRST payment is due 2017.1.5.3
23369 Inventory "Discount" is excluded from the "invoiced order" when multiple products (shippable and non-shippable) are purchased in one Cart with the "RecognizeRevenueDuringFulfillment" set to “true” and Discount "number of uses" = 1 2017.1.5.1
23396 Fundraising "Highest gift" source (Fund, "dnr_rfm_highest_source") calculations are incorrect and not accurate (the SP "np_rfm_summary_for_history" is overwriting this value) 2017.1.5.1
23405 Sales “Edit – File Upload” form: when attempting to edit an "existing" document for "Sales Opportunities"/"Moves"/"Gift Opportunities"/"Awards" entries, the user receives an error "File upload is required" (path is not preserved) 2017.1.5.2
23408 Membership [NFR] "Transfer Membership" wizard should allow you to "transfer both" CHAPTER and NATIONAL memberships to a NEW MEMBER TYPE 2017.1.5.3
23413 Accounting Performance issue on trm_num_issues_remain_cp 2017.1.5.3
23415 Subscriptions Subscriber Profile: the "renew" button appears on the page when Subscription is "tied (or linked)" to the Membership/ "Membership Renewal"does not include "linked" Subscription 2017.1.5.5
23420 Fundraising iWeb-"Add Gift" form: the "np_premium_code_select" sproc is triggered multiple times and it runs slowly when there are a large number of records involved 2017.1.5.4
23430 Accounting Deferral records created with incorrect start date and period. 2017.1.5.1
23441 Subscriptions "Subscription Renewal": "invoice terms" are not populating within the invoice/ the renewal invoices are not taking the invoice "batch date" as the "invoice date" 2017.1.5.2
23442 Accounting Sage : if the user incorrectly enters the CVV in an eWeb transaction, netForum will process the PreAuth, but then reject it and rollback the transaction in netForum, but the void of PreAuth will fail, causes duplicate transaction in Sage 2017.1.5.3
23485 Membership "Membership Renewal" task: allows selecting "proforma" and "terms" simultaneously/ does not carry over the "invoice terms" selected 2017.1.5.4
23491 E-Marketing "Call To Action": "Set Parameters" is not working when using a "data source" that has "Ask At Run-Time" parameters 2017.1.5.5
23495 Fundraising "Constituent Profile": WealthEngine links are not available in Constituent Profile / "WealthEngine" childform - "click here" hyperlink is not clickable 2017.1.5.3
23508 Accounting "Authorize.Net": Gateway errors generated by the "Order Installment"/ "Recurring Gift"/ "Installment Payment" tasks are not logged in the Gateway Error table if you use "Authorize.Net" 2017.1.5.6
23529 CRM "Combine/Merge Dups": Change Date ("cxa_change_date", "adr_change_date") not updated upon merging Individuals / Organizations 2017.1.5.4
23531 Fundraising xWeb: "Upgrade/Downgrade Pledge"module as it calls for session object and fails, especially if the calling code is coming from TaskSchedule 2017.1.5.6
23535 CRM GDPR validation not recognizing "terminated" membership date (CANNOT ANONYMIZE: Customer has at least one active individual membership. Must terminate before continuing) 2017.1.5.4
23557 Exhibits "Exhibitor Transfer Wizard": Installment Transfer "payment method" error is displayed 2017.1.5.5
23560 eWeb [NFR] eWeb: Tags and/or attribute in code for "Forgot password" and "change password" pages  
23561 Operations Performance improvement for the "np_update_funds_raised" sproc 2017.1.5.4
23565 CRM "Collective Dues > Select Invoices to Pay" form: "Distributed payment liability..." error upon payment of CD invoice after distributing credits 2017.1.5.4
23567 xWeb Stored Procedure: "ws_exchange_token_new" is missing NOLOCK (table "ws_security") 2017.1.5.4
23573 Accounting Cannot close batch with ITEM having SPLIT-REVENUE accounts, never paid, and returned ("Error: The GL Account is missing") 2017.1.5.4
23593 Fundraising "Query Fundraising Constituents": Can't query correct WealthEngine table (WealthEngine8 integration, "np_wealthengine_data" table) 2017.1.5.4
23616 Framework DataUtils.ExecuteSql(string) overload was removed 2017.1.5.4
23617 Fundraising Default "Donor category" not added for Constituents created when a GIFT is inserted from COE (CRM) in iWeb/ eWeb/ or via xWeb 2017.1.5.5
23631 Membership "Transfer Membership" Wizard: when transferring CHAPTER memberships the "Chapter" field does not reflect the NEW "Chapter" 2017.1.5.5
23635 Membership "Transfer Membership" Wizard: cannot set/change the "credit amount" to $0.00 (zero) 2017.1.5.5
23659 Fundraising "Upgrade/Downgrade Pledge": When a user attempts to upgrade or downgrade "recurring gift" order (pledge), an error message displays: "Error: Pledge type is invalid. Must be set to: Signed, Verbal or Installment." 2017.1.5.6
23660 Fundraising "Upgrade/Downgrade Pledge": the "NEXT Installment" should not be processed, when a user attempts to upgrade/downgrade a "verbal" pledge (order type = installment) 2017.1.5.6
23661 Fundraising "Upgrade/Downgrade Pledge": The “first payment date” cannot be changed to be a date any LESS that ONE month from the "current" date [verbal pledge (order type = installment)] 2017.1.5.6
23670 Membership "Subscription Renewal"/ "Membership Renewal": "invoice terms" are not populating within the invoice (SO SubscriptionRenewalMethod = "GroupBySoldToCustomer") 2017.1.5.6
23695 Fundraising Manual "add gift" triggers "np_premium_code_select" multiple times and which causes very poor performance on large data sets 2017.1.5.6

Hotfix 1

Netsuite ID Module Description Dev Notes
18406 Baseline Reports/Queries Remove debugging lines from error log Add the Config,DebugMode condition to display the error log messages when the debugMode value is true Changes only code
22147 Membership When a calendar-based membership that is not set up to "prorate" is transferred , netFORUM is automatically prorating the "Credit Amount" and the "Balance Due" Changed the Membership Transfer Extension logic that controls the Membership Transfer form.
22257 Grants Grant "distribution amount" not the same as "awarded amount" for additional applicants fund distribution Fix the issue updating the query sql in order to get the award amount, replacing the applicant key insteand of program key that return the current award amount.
22566 CRM [NFR] Current UI is missing the "first", "previous", "next", and "last" navigation links while viewing records that are returned from a "Find X" query Added ProfilePaging class and partial view, loaded it from content, filled with keys from the current page and enabled pagination.
22625 xWeb xWeb: GetQuery logs "Unclosed quotation mark after the character string ' and isnull(lsc_order,0)..." error Remove the single quote because now we are using AddParameter method in order to parameterize the query
23025 eWeb eWeb: "Shipping method" price being removed from Cart when re-selecting the "Shipping method" Added condition in order to avoid to remove the shipping product which was added recently
23040 General Current UI Possible race condition in Current UI "supersearch" during "app pool recycle" Added checks to avoid inserting records twice
23060 Admin Multicurrency: The "Exchange Rate Updater" task: completes with COMPWITHERROR and the system doesn’t insert any "ac_exchange_rate_record"/ calls a WebService that no longer works Update service to convert the currency rates from a currency to a home currency and add anew SO : MulticurrencyAPIkey
23338 Accounting Intacct Integration: "Department" and "Class" dimensions incorrect in "ledger" record when a product uses "price override account" for dimensions Override dimensions of GL account when the pyd_type is return in payment transactions, avoid to override liability account in a refund transaction.
23358 Accounting "Collective Dues": "PaymentsReturnsGenerationTask" not inserting into "ac_return_x_customer" table Change the validation in order to insert a record in ac_return_x_customer to be based on return amount
23366 Baseline Reports/Queries "Revenue Available for Recognition" report: "Write off" payment stays ON and doesn't get removed Multiple problems across both reports ended up being accumulated and causing the problem reported. Multiple fixes on across rpt_ac_deferral_revenue_recognized and av_ac_deferral_def_writeoff_amount_cp fixed the problems.
23439 Membership Proration not calculating correctly when "Dues Period" not matching "Fiscal Period" (SO: CalculateProrationBasedOnDuesPeriod = "false") Using the transaction date to calculate the effective year and add a extra valiation to use the transaction year if effective years is less than the transaction year
23522 xWeb xWeb: Price control is selecting incorrect shipping prices in the method GetShippingSql Add a conditional in the xweb case in order to get a value for inv_total_wieght Using the shelveset that Yoel provided.
23666 Accounting Unable to close batch if "partially recognized" invoice with its balance "written off" is "voided with adjustment" and "credit" created for the actual payment. ("Error: The Batch is not balanced") Changed calculation of Cancel Amount when closing a batch with Adjustments
23671 CRM Current UI LinkButton MVC Widget does not recognize "_blank" in the "target" field and does not open WEBSITE in a new tab Add logic in the LinkButton widget in order to support the target _blank
23699 CRM GDPR Failing on outstanding "credit", but credit has been "refunded" and "batches have been closed" (CANNOT ANONYMIZE: Customer has outstanding Credit.) Update the "Customer has outstanding Credit" GDPR validation for open credits Only script change
23700 CRM GDPR fails on outstanding order, but order has been shipped (CANNOT ANONYMIZE: Customer has outstanding Credit. / Customer has fulfillments that have not been shipped.) Delete the Validation that looks at oe_fulfillment (#23) and instead rely on the #7 validation which ensures there are no open Orders. #7 is all we need.
23731 CRM GDPR fails on "End dated" Chapter relationship (CANNOT ANONYMIZE: Customer has non-househould relationship to another customer or organization) Update co_individual_gdpr_validation query in order to validate the end date for a chapter relationship
23739 CRM [Performance] Using foreign key constraints on "co_relationship_type.rlt_code" when "rlt_key" is faster Performance: add and use ixo_rlt_key instead of ixo_rlt_code in joins to rlt_code NOTE: for use, must populate privileges on the new ixo_rlt_key column
23754 Accounting Batch Profile: Invoice discounted 100% shows in batch with "batch total" 0.00 (zero) instead of "original invoice amount" Sum the total ivd amount without include ivd_type as discount
23755 Fundraising "Gift > Add Gift" form: unable to set a "tax deductible amount" that is different from a "gift amount" Updated condition in order to avoid updating tax deductible amount when manually set
23777 Fundraising "Combine/Merge Dups": Constituents can't be merged if they both have "fund-level" "Giving Summary Statistics" (constraint 'UC_np_constituent_fund_gift_summary') Update all the np_constituent_fund_gift_summary that are in B but not in A and execute np_fund_gift_summary
23779 Admin [Performance] Performance issues on "Gift Details Task" Changed the Gift Details Task so that it runs a single sproc (instead of RBAR). This is now default, but can be controlled by the new BulkFundraisingUpdateGiftDetailsTask system option.
23779 Admin [Performance] Performance issues on "Fund Statistics Task" Changed the Gift Fund Statisitics Task so that it runs a single sproc (instead of RBAR). This is now default, but can be controlled by the new BulkFundraisingUpdateGiftFundStatisticsTask system option.
23780 Membership "Transfer Membership" wizard is creating an invoice with a "balance" when "transfering" National Membership (with associated Chapter membership) and editing "credit amount" and "new price" amount to 0.00 (zero) The credit amount should no longer reset when the user manually changes it.
23791 General [Current UI] Unable to parse more than one key column parameter to pull child/grandchild form data "Grandchildform SQL may now filter using any GUID or alphanumeric column from the parent row "
23808 Fundraising "Edit Fundraising Pledge" form: a pledge’s "solicitor" does not appear/ blank the porblem was that pledge did not load the Solicitor Object to show the text in cs3__cst_sort_name_dn in order to solve the problem I set the szParentForeignKeyColumn with the correct value.
23815 Membership "Membership Renewal Task": "Membership dates" not updated/"payment" not created when the "CHAPTER Membership" is set to be "auto paid" and associated with the "National Membership" which is $0.00 (zero) Added a conditional in order to review the chapter memberships and valid if autopay is checked.
23821 General Lookup validation failing when data is returned from search window (Lookup background color is set red) Modified lookupGridClick to refresh the form validator if there are any validation errors on the element
23829 Framework [Current UI] Form footer: "Changed" field not displaying properly/misleading when "editing" profile Update the data table condition to determine whether the last prefix change date value has been changed.
23858 Fundraising "Upgrade/Downgrade Pledge" error when executed outside of iWeb Add logic in order to set the value of 'odd_cancellation_bat_key' always an not only when we do an upgrade/drowngrade from eWeb also update the Cancel logic when we are setting the inv_newBatch_key value
23865 Fundraising [Performance] Fundraising: severe performance issues with "Recurring Gift Bulk Cancel" Task Changed visibility SQL on the "Suite:" label on the United States Address subform

Hotfix 2

Netsuite ID Module Description
20716 Payment Processing when you process transactions through eWeb the batch name is going over as the default WEB batch name instead of the batch name that the actual payment was added
21011 Inventory Valued inventory report does not take into account negative adjustments
21660 Payment Processing No error is thrown when a credit card expire date is not formatted in YYYY/MM, due to faulty code that fails to format properly
21680 Subscriptions Error "Arithmetic overflow error converting expression to data type varchar." encountered when running the subscription fulfillment process
22152 Inventory "Canceled" Orders are picked up by "Fulfill Processed Orders" (STEP # 2) process
22461 eWeb eWeb: Event fees cannot have both "member"/"non-member" type and "customer attribute 1" as price attributes
22833 xWeb netFORUM does not properly handle "pending" "Auth Only" 411411 transaction in Sage
22940 Membership "Membership > Overview > Change Status": "validation error" on "fw_error_log" once a membership is detected to "change the status" ("An input value... of "36" characters exceeds the max length of "30" characters..on the field "mbs_code")
23007 eWeb eWeb: New user registration allows sign up using an e-mail that is already in the system, email search only searches on "primary" email (SO: DuplicateEmail=Deny)
23133 CRM Baseline update statements causing great amount of database blocking
23192 CRM When an exception is made during the "payment processing" and payment information was not created to the invoice the confirmation email is still sent
23363 Baseline Reports/Queries Views should allow nullable av_flag columns
23367 Membership Deferral record "start date" ("ac_deferral.def_start_date") does not match "mb_membership_x_ac_invoice.mxi_term_start_date
23409 xWeb xWeb: the baseline is setting the list column on the object for the table definition that is on the request and after that the system is adding the alias to the list column
23685 Membership "Transfer membership": transferring a membership triggers CHECK constraint because SP "mb_membership_transfer_new_dates" that is returning "wrong dates" when getting new dates/ "Failed to Create Membership Renewal"
23733 Subscriptions "Subscription Fulfillment" task: Is not possible to fulfill a Subscription (multiple prices) when subscribe again to same subscription using a "second price"
23821 General [Current UI] Lookup validation failing when data is returned from search window (Lookup background color is set red)
23832 Baseline Reports/Queries "Customer Statement" displays "Balance Due" for the "cancelled" Event Registration and the "Event Cancellation Fee" as a separate sectio
23848 Fundraising "Edit Salutations" form: Is not possible update the salutation fields in 2017v in classic and Current UI
23854 Fundraising "Add Gift"/"Add a Donation" forms: modifying "gift amount" clears/resets "gift amount" on postback when using "Fund Code" autofill from "Source Code"
23868 Accounting "Generate Next Installment" process updates "Stored Credit Card" "Expiration Date" to incorrect format (YY/MM) when using "Account Updater"
23877 eWeb eWeb: "Invoice Listing" and "Invoice Summary/ Details" does not accurately account for ALL transactions attached (duplicate invoices, missing "-1" invoice suffix)
23898 CRM [Current UI] Grandchild form "ADD" link does not work (e.g. "Sub-committee" grandchild form)
23927 eWeb [Security] eWeb: "security" module not preventing changing another customer's password
23939 Accounting An Exception prevents "saving the payment" in NFE and "Payment Processor" but the "invoice is created
23942 eWeb DataUtils.ParseValues() can go into an infinite loop
23968 COI "Request Profile ": COI Scheduled message not created after rescheduling a job for a Request
23988 CMS EDIT "web page" detail fails to SAVE with a conversion failed error "SQL Server syntax error converting from a character string to uniqueidentifier."
23993 CMS [Security] eWeb: Security vulnerability with parsing values in eWeb