NetForum Enterprise 2017.1.7 Build
Below are all resolved issues in version 2017.1.7
--- 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 1A Hotfix 2
| Netsuite ID | Module | Description | Previous Release |
|---|---|---|---|
| 18406 | Baseline Reports/Queries | Remove debugging lines from error log | 2017.1.6.1 |
| 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 | 2017.1.6.2 |
| 21011 | Inventory | Valued inventory report does not take into account negative adjustments | 2017.1.6.2 |
| 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 | 2017.1.6.2 |
| 21680 | Subscriptions | Error "Arithmetic overflow error converting expression to data type varchar." encountered when running the subscription fulfillment process | 2017.1.6.2 |
| 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" | 2017.1.6.1 |
| 22152 | Inventory | "Canceled" Orders are picked up by "Fulfill Processed Orders" (STEP # 2) process | 2017.1.6.2 |
| 22257 | Grants | Grant "distribution amount" not the same as "awarded amount" for additional applicants fund distribution | 2017.1.6.1 |
| 22461 | eWeb | eWeb: Event fees cannot have both "member"/"non-member" type and "customer attribute 1" as price attributes | 2017.1.6.2 |
| 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 | 2017.1.6.1 |
| 22625 | xWeb | xWeb: GetQuery logs "Unclosed quotation mark after the character string ' and isnull(lsc_order,0)..." error | 2017.1.6.1 |
| 22833 | xWeb | netFORUM does not properly handle "pending" "Auth Only" 411411 transaction in Sage | 2017.1.6.2 |
| 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") | 2017.1.6.2 |
| 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) | 2017.1.6.2 |
| 23025 | eWeb | eWeb: "Shipping method" price being removed from Cart when re-selecting the "Shipping method" | 2017.1.6.1 |
| 23040 | General | Possible race condition in Current UI "supersearch" during "app pool recycle" | 2017.1.6.1 |
| 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 | 2017.1.6.1 |
| 23133 | CRM | Baseline update statements causing great amount of database blocking | 2017.1.6.2 |
| 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 | 2017.1.6.2 |
| 23338 | Accounting | Intacct Integration: "Department" and "Class" dimensions incorrect in "ledger" record when a product uses "price override account" for dimensions | 2017.1.6.1 |
| 23358 | Accounting | "Collective Dues": "PaymentsReturnsGenerationTask" not inserting into "ac return x customer" table | 2017.1.6.1 |
| 23363 | Baseline Reports/Queries | Views should allow nullable av flag columns | 2017.1.6.2 |
| 23366 | Baseline Reports/Queries | "Revenue Available for Recognition" report: "Write off" payment stays ON and doesn't get removed | 2017.1.6.1 |
| 23367 | Membership | Deferral record "start date" ("ac_deferral.def start date") does not match "mb membership x ac invoice.mxi term start date" | 2017.1.6.2 |
| 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 | 2017.1.6.2 |
| 23439 | Membership | Proration not calculating correctly when "Dues Period" not matching "Fiscal Period" (SO: CalculateProrationBasedOnDuesPeriod = "false") | 2017.1.6.1 |
| 23522 | xWeb | xWeb: Price control is selecting incorrect shipping prices in the method GetShippingSql | 2017.1.6.1 |
| 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") | 2017.1.6.1 |
| 23671 | CRM | Current UI LinkButton MVC Widget does not recognize " blank" in the "target" field and does not open WEBSITE in a new tab | 2017.1.6.1 |
| 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" | 2017.1.6.2 |
| 23699 | CRM | GDPR Failing on outstanding "credit", but credit has been "refunded" and "batches have been closed" (CANNOT ANONYMIZE: Customer has outstanding Credit.) | 2017.1.6.1 |
| 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.) | 2017.1.6.1 |
| 23731 | CRM | GDPR fails on "End dated" Chapter relationship (CANNOT ANONYMIZE: Customer has non-househould relationship to another customer or organization) | 2017.1.6.1 |
| 23733 | Subscriptions | "Subscription Fulfillment" task: Is not possible to fulfill a Subscription (multiple prices) when subscribe again to same subscription using a "second price" | 2017.1.6.2 |
| 23739 | CRM | Using foreign key constraints on "co relationship type.rlt code" when "rlt key" is faster | 2017.1.6.1 |
| 23754 | Accounting | Batch Profile: Invoice discounted 100% shows in batch with "batch total" 0.00 (zero) instead of "original invoice amount" | 2017.1.6.1 |
| 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') | 2017.1.6.1 |
| 23779 | Admin | Performance issues on "Gift Details Task" and "Fund Statistics Task" | 2017.1.6.1 |
| 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) | 2017.1.6.1 |
| 23791 | General | Unable to parse more than one key column parameter to pull child/grandchild form data | 2017.1.6.1 |
| 23808 | Fundraising | "Edit Fundraising Pledge" form: a pledge’s "solicitor" does not appear/ blank | 2017.1.6.1 |
| 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) | 2017.1.6.1 |
| 23821 | General | Lookup validation failing when data is returned from search window (Lookup background color is set red) | 2017.1.6.1 |
| 23832 | Baseline Reports/Queries | "Customer Statement" displays "Balance Due" for the "cancelled" Event Registration and the "Event Cancellation Fee" as a separate section | 2017.1.6.2 |
| 23848 | Fundraising | "Edit Salutations" form: Is not possible update the salutation fields in 2017v in classic and Current UI | 2017.1.6.2 |
| 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" | 2017.1.6.2 |
| 23858 | Fundraising | "Upgrade/Downgrade Pledge" error when executed outside of iWeb | 2017.1.6.1 |
| 23865 | Fundraising | Fundraising: severe performance issues with "Recurring Gift Bulk Cancel" Task | 2017.1.6.1 |
| 23868 | Accounting | "Generate Next Installment" process updates "Stored Credit Card" "Expiration Date" to incorrect format (YY/MM) when using "Account Updater" | 2017.1.6.2 |
| 23868 | Accounting | "Generate Next Installment" process updates "Stored Credit Card" "Expiration Date" to incorrect format (YY/MM) when using "Account Updater" | 2017.1.6.2 |
| 23898 | CRM | Grandchild form "ADD" link does not work (e.g. "Sub-committee" grandchild form) | 2017.1.6.2 |
| 23927 | eWeb | eWeb: "security" module not preventing changing another customer's password | 2017.1.6.2 |
| 23939 | Accounting | An Exception prevents "saving the payment" in NFE and "Payment Processor" but the "invoice is created" | 2017.1.6.2 |
| 23942 | eWeb | DataUtils.ParseValues() can go into an infinite loop | 2017.1.6.2 |
| 23968 | COI | "Request Profile ": COI Scheduled message not created after rescheduling a job for a Request | 2017.1.6.2 |
| 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." | 2017.1.6.2 |
| 23993 | CMS | eWeb: Security vulnerability with parsing values in eWeb | 2017.1.6.2 |
Hotfix 1
| Netsuite ID | Product Area | Description |
|---|---|---|
| 18671 | eWeb | eWeb: "Print Invoice > Invoices with Format eWeb": empty "red error box" appears on "Report Parameters" pop-up form |
| 19058 | CRM | Adding "Sponsor Contact" on the "Add - Event Sponsor" form refreshes screen causing "Sponsor fee" and "total amount" to get cleared |
| 19632 | Events | When editing registrant info from group registration wizard, changes are not saved |
| 21170 | Exhibits | Expo integration in NF-2015 uses baseline table but it is missing the facade objects to insert and update the tables |
| 21884 | CRM | The "Required" field validation (e.g. "Address line 1 is required") is missing when inserting/maintaining an "international"/"foreign" address (outside the US) (iWeb only) |
| 22194 | Membership | Membership on Auto-Pay does not receive Payment Confirmation Email during Mass "Membership Renewal" Task |
| 22291 | Accounting | 1 (one) cent off issue when returning/cancelling last installment on order (cancelled invoice has "invoice total" = $ 0.01) |
| 22646 | Fundraising | New unpaid "Recurring Gift"- creates a "Gift" Record even if proforma/unpaid when the "First invoice date" is "today's date" |
| 22728 | Baseline Reports/Queries | "Exhibit Booth Summary Report" does not show "Status" column when exported to .CSV |
| 22853 | E-Marketing | "Communication Preferences" form: Email optout question / potential problem [There is no record in EMO table and the mailing list is unchecked in iWeb] |
| 22991 | E-Marketing | "Invoice" "list type" template does not include "Individual" object "fields" |
| 23071 | xWeb | WEBCentralizedShoppingCartMembershipGetPackageComponentListFromObject is throwing exception: "Column 'prc_price' does not belong to table Table." |
| 23295 | CRM | "Combine/Merge Dups" error "Multiple controls with the same ID" |
| 23381 | Accounting | The "inv_trx_date" is being set with "timestamp" when invoice is paid from eWeb |
| 23414 | CRM | Improve Current UI Find/List Links UX -- "List Individuals/List Organizations"/"List results": list results after going to record from "Find Individual"/ "Find Organizations" |
| 23419 | Accounting | Alignment "Batch Profile" form: the "Summary Information" not aligned [total amount and total count] |
| 23421 | eWeb | eWeb: Error "Discount Code 'DiscountCode' already applied" when trying to apply a "Discount" to "existing" Invoice |
| 23443 | Accounting | Accounting_Sage : Sage "Void" function tries to add blank account info into the vault. Causes pointless "empty" vault requests for Credit Card. And voiding a netForum Credit fails with "Object Reference" error for ACH; Causes pointless "empty" vault requests for Credit Card. |
| 23506 | eWeb | eWeb: "Shopping Cart-Open Invoices" page only shows the membership line item when you click "Next/ Add To Cart"; "additional" components line items from the invoice are not shown |
| 23510 | eWeb | eWeb: eWeb not loading "all line items" from an Invoice into Shopping Cart |
| 23518 | CRM | "Combine/Merge Dups": Relationship records "hard-deleted" / Address "removed" from "Individual Profile" - upon merging Organizations that are related to an Individual/Organization |
| 23634 | Membership | "Transfer Membership" Wizard: the "transaction date" is not auto populating |
| 23647 | Accounting | "Cost of Goods Sold" report: re-allocating inventory creates an "adjustment" that is showing on the "Cost of Goods Sold" report |
| 23742 | Fundraising | eWeb: "Quick Donation" form fails when NOT LOGGED IN using "Vantiv" with Gateway "Level 2" enabled ("Error validating xml data against the schema on line 31 Content of element "customerReference" is incomplete") |
| 23755 | Fundraising | "Gift > Add Gift" form: unable to set a "tax deductible amount" that is different from a "gift amount" |
| 23756 | Framework | Add/Edit/Delete record from a "child form" does not "refresh"/ "postback" the childform (or the page) |
| 23782 | Membership | "Membership Renewal Task" Profile: "Renewal Invoice Batch" clears out once the "Step 1: Get Records Completed" is completed [visual issue only] |
| 23829 | Framework | [Current UI] Form footer: "Changed" field not displaying properly/misleading when "editing" profile |
| 23891 | COI | COI "Request Profile": the "Refresh List" button "deletes" or doesn't update individuals |
| 23935 | Subscriptions | Subscription "prorate" pricing only works on "first" price |
| 23937 | General | Sort Order Saving issue: Childform "sorting" not caching for users as expected |
| 23953 | CRM | "FileUpload" extension does not work on any object except "Abstract Submission" |
| 23961 | CRM | "CEU Credit Generation" task: when generating CEU credits, the system shows its been generated but when you check its not there |
| 23986 | Baseline Reports/Queries | Accounting Period: "Deferral Revenue Available for Recognition" report calculating "Beginning Balance"/"Cancels" amounts incorrectly |
| 24030 | General | [Security] iWeb: Path Traversal Vulnerability on the login process |
| 24091 | Membership | When transferring members from "in-state", to "out-of-state", the "district(chapter) expire date" is being advanced 1 year forward (not matching the state(national) expire date). |
| 24110 | Fundraising | Editing a gift clears appeal, package, campaign, purpose fields IF corresponding FUND product fields are NULL |
| 24115 | CRM | Need to override "GetRltKey" method |
Hotfix 1A
| Netsuite ID | Product Area | Description |
|---|---|---|
| 24210 | CRM | CustomerSetup: Any change in record in any child form is raising a warning '..some features have failed to load...' |
Hotfix 2
| Netsuite ID | Module | Description | Dev Notes |
|---|---|---|---|
| 20725 | Fundraising | Fundraising codes (purpose, campaign, appeal, package) are not auto-populating when a Fund code is selected during the Add Pledge process. | Added conditionals in order to update the Fundraising codes (purpose, campaign, appeal, package) and populate when Fund code is selected |
| 22180 | CRM | "Create SQL": Unable to save query if there are "commented out sections" in a query | Query Builder form will now allow comments with either "--" or "/* */" syntax. |
| 22368 | Inventory | "Add - Purchase Order" shows 2 row lines instead of one | Delete the StartOnLoad call because it was causing to load twice the row of the grid |
| 22740 | eWeb | eWeb: "My Contact Information" page text says "checkmark" when it should say "flag" | Text change from checkmark to flag. |
| 22774 | Subscriptions | Issue based Subscription fulfillment when renewing membership that includes subscription | I did a basic fulfillment issues |
| 23098 | Accounting | Project Code issues in GP export | |
| 23421 | eWeb | eWeb: Error "Discount Code 'DiscountCode' already applied" when trying to apply a "Discount" to "existing" Invoice | Verify if inv_proforma field was setting with some value("0" or "1") in order to apply the discount if this field is null or empty (it means is a new invoice) |
| 23450 | eWeb | eWeb/mobile: StartPage.aspx is not responsive on tablet/mobile devices | I tested the starPage.aspx with the mobile browser |
| 23611 | Accounting | COE: Adding Order for a "shippable" product generates the error "Exception has been thrown by the target of an invocation" after "deleting"/"re-adding" a line item(SO: RecognizeRevenueDuringFulfillment = "true") | Added a shippable product in COE deleting and re adding a line item. |
| 23621 | E-Marketing | eMarketing template: Template built on "Invoice" List type confirmation templates do not parse "ind_first_name" / Template page "field list" dropdowns misbehaving | eMarketing templates built on the "Invoice" List Type now have a "CustomerIndividual" and "BillTocustomerIndividual" entry in the "field list" drop down. The associated fields now show the correct values in when the templates is used. |
| 23717 | Exhibits | The "pc_ex_exhibit_match_booth_prices" SProc has deployment script at end | Bug 18816: Remove deployment script and move the changes to dynamic_form_control in order to save the old fix for Bug 64682 |
| 23759 | Accounting | "Batch Profile"/ "Batch Report": some "Project Code" ("led_pjt_code") are not getting populated when the Batch is "closed" and the "ledger are created" | |
| 23816 | Events | "Event Session" tied to "Fundraising Product" does not set "np_gift.gft_ivd_key" field | |
| 23916 | Accounting | [Performance] "vw_ac_invoice_detail_amount_due" update made for "Bug 117766[23352]" introduced performance issues | Rollback changes for 117766 since the change was causing performance issues and was not a correct change |
| 24002 | Committees | "Committee Search > List Committee Participants" form: QuickReport.aspx launched by "Report" button on EMSWizardPage.aspx throws error "HTTP status 404: Not Found" | The url being created to call the report was building each segment incorrectly causing it not to pass the correct details. |
| 24014 | Membership/Accounting | " ""Transfer Membership"": Subscription ""dates"" go to NEXT YEAR when ""transferring Memberships"" with the ""same Subscription"" ""Invoice Profile"": ""Invoice number"" displays an ""asterisk""/""required field"" when in ""Classic Mode""" | "Change membership transfer to cancel the existing membership invoice and create the credits first before creating the invoice for the transfer membership. CSS class removed" |
| 24047 | Fundraising | "Primary Module" USER Preference routing functionality does not work | "redirect to constituent if individual or organization contains an associated constituent. refactored to share some code between old and Current UI implementation changed redirection logic to use PageUtils.Redirect instead of Server.Transfer" |
| 24049 | Centralized Order Entry | Unable to purchase "shippable" Merchandise when "Shipping is 'taxed' and using 'invoice totals' " (constraint "FK_oe_order_detail_additional oe_order_detail_oda_odd_key") | Fixed how order details and order detail additionals are inserted for shipping tax details. Fixed system so we don't lose applied payment information for shipping tax when the shipping tax is recalculated. |
| 24059 | Accounting | "No deferral" record created in specific scenario (price is "prorate", dues based in "calendar" and "update dates when : Invoice Created") | Update ac_deferral_insert_dues_no proration_invoice_created to include if a prorated price (prc_prorate_flag =1) and does not have ivd_pro_key value. |
| 24073 | CRM | Address validation: [Melissa Data AVS] Auto address validation for "Canadian" addresses will remove "Province" and default "Country" to "United States" | PageUtils changes to PopulateStateDropdownList and RenderAddressControls |
| 24075 | CRM | Child form # items to display should preserve after navigating out and back [Currently it reverts back to the previous default of 5, regardless if you select 5, 10, 25, or All] | We are saving the Paging Row Count into Jason format into the md_dynamic_form_mvcWidgetPersonalization table as per user login and whenever we are visiting that grid we are pulling row count from the same table and setting up into the grid. |
| 24092 | Membership | When transferring members from "out-of-state", to "in-state", the "member type" on the record is being changed (downgraded) | I tested the transfer membership using proforma. |
| 24101 | CRM | The "Add Sub-committee" form will not pre-populate the "parent committee" and any further "Add Sub-committee" forms will also not pre-populate the "parent committee" | We have created extension to handle parent child relationship because it's not working from Related Object. |
| 24110 | Fundraising | Editing a gift clears appeal, package, campaign, purpose fields IF corresponding FUND product fields are NULL | Avoid to load the information of the fund if we are on edit mode |
| 24139 | Membership | "Transfer Membership": Transferring a National Membership with a "cancelled" Chapter Membership shows the Chapter Membership | Modifying the Membership Transfer Extension to check if the chapter has been cancelled. |
| 24158 | CRM | Member Transfer invoice amounts calculating incorrectly | "Additional details added in History field When system option CreditTransferMebersipBasedOnMonthsUsed is true only membership dues and subscriptions must be re-calculated based in the month used." |
| 24187 | Fundraising | Apostrophe in "user name" ("usr_code") not escaped in stored procedure called after donation checkout (SP 'np_rfm_summary') | Escape out single quote before calling np_rfm_summary. |
| 24200 | Payment Processing | Multithreaded Scheduled Task payment performance is throttled for Sage and BluePay by HttpWebRequest concurrent connection limit | Previously communications with Sage (Paya) payments (and possibly BluePay) could hit connection bottlenecks when multiple concurrent payments were processed at the same time. Most noticeable in multi-threaded scheduled tasks like Recurring Gifts. |
| 24246 | Development Toolkit | [Current UI] When adding a record from a Grandchild Form, properties are not defaulted from its Parent record via Related Object/Controls | Whenever we have a grandchild, get the correct data from the parent and set it to the parent-form-key (pfKey), parent-key (pKey) and also get the correct objectKeyFrom. |