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 |