NorthScope 2018.11.09

Owned by Emma Greenwood
Last updated: Nov 12, 2018
4 min read

(Software Version: 2018.11.09 Database Version: 2018.11.09)

Release Date: November 09, 2018


Improvements 

Inventory

NS-3753 Improved the Performance of the Inventory Items List View

Users were occasionally experiencing latency when opening the Inventory Items list view.  The code was restructured to improve the performance of this list view. This improvement has no other user impact than improved performance.

Purchasing

NS-3295 Added a new validation to the Fish Ticket Mass Update

When a Ticket’s status is changed to “Approved” or “Ready to Post” from the Record View, there is a validation that ensures the “GL Date” is not in the future. However, this validation was not happening for Tickets that were being updated using the “Mass Update” from the Tickets List View. This has been added to the Mass Update and a message will display if one or more tickets violates this rule.

NS-3744 Added “Email” address to Vendors, Fishermen, Tenders, and Loan Addresses

An “Email” field has been added to the Vendor Record View. This provides a place to store email information for a Vendor, Fisherman, Tender, and Loan. This field has also been added to the list views and record views:

  • Vendor Record View
  • Vendor Addresses List View – this new list view was added to the menu under Vendors.

Users will be able to save an Email address directly at the address level of Customers and Vendors without the need to determine which contact type to use.  These email addresses will be visible from both the Customer Address and Vendor Address list views.  

Note: This new Email field does not change the functionality of Contact Types. It is for informational use only.

Note: This change impacts the system view of the Vendor List View and Vendor Record View. Any existing custom user views on these pages will need to be deleted and re-created.         

Sales Order

NS-3744 Added “Email” address to Customer Addresses

An “Email” field has been added to the Customer Address. This provides a place to store email information for Customer Addresses. This field has been added to the Customer Address List View and the following record views:

  • Customer Record View - Address tab
  • Customer Address Record View

Users will be able to save an Email address directly at the address level of Customers and Vendors without the need to determine which contact type to use.  These email addresses will be visible from both the Customer Address and Vendor Address list views.  

Note: This new Email field does not change the functionality of Contact Types. It is for informational use only.

Note: This change impacts the system view of the Customers List View and the Customer Addresses List View. Any existing custom user views on these pages will need to be deleted and re-created. 

System

NS-3726 Redesigned the Login Page

The login page has been redesigned with an improved look and feel for users. The functionality of the page and all the hyperlinks remain the same except for the Help & Support hyperlink, which has been moved to the ‘About’ page underneath the Release Notes hyperlink.

Note: Custom logo images on the login screen are no longer supported. 

NS-3762 Added Security to Sales Order Payment Terms

The “Payment Terms” field on the Sales Order Record View Properties Tab has been added to security to allow administrators to restrict users from setting or changing them on sales order transactions.  

Note: Payment Terms will default to “Full Rights” for all new and existing Security Groups. 

Note: Because this field is on a Properties Grid, there is no way to hide it from users. As a result, setting the Security Mode to “No Rights” will function as if it were set to “Read Only”, it will be visible but not editable. 

Bug Fixes

Financial

NS-3739 Incorrect fiscal year start date with multiple companies installed

Previously, when a new Fiscal Year was added in a NorthScope system, with more than one Company installed, the beginning date of the new fiscal year was always set from Company 1’s fiscal table, no matter which company the year was being added to. This was only evident in systems with more than one Company where the companies were not on the same fiscal calendar.

NS-3755 Fixed Fiscal Year Saving

Previously, an error message was displayed when Fiscal Period start dates were updated and saved on a Fiscal Year record. The issue prevented users from updating Fiscal Period dates.  

Purchasing

NS-3441 Fixed Stat Area Details Void/Correct screen

Due to broken navigation which caused the system view not to load, users were receiving a server error trying to access the Void/Correct screen from the Stat Area Details Inquiry.  The link has been updated to ensure the Void/Correct screen loads without error.

Sales Order

NS-3717 Fixed Unique Key Violation Error on Sales Order Item Attributes for Returns and Price Adjustments

Users were seeing a unique key violation error message when Returning or making Price Adjustments for an item from multiple lots and had order item attributes assigned.  The code has been updated to ensure no error message is received when users create Returns or Price Adjustments for items from multiple lots with order item attributes assigned.

Technical Changes

Schema Changes

ALTER TABLE [dbo].[ERPx_APVendorAddress] ADD [Email] [varchar](1000) NULL

ALTER TABLE [dbo].[ERPx_ARCustomerAddress] ADD [Email] [varchar](1000) NULL

ALTER TABLE [dbo].[ERPx_IMItem] ADD CONSTRAINT [FK_ERPx_IMItem_ERPx_MFHoldCode_LotHoldNew] FOREIGN KEY ([LotHoldNew]) REFERENCES [dbo].[ERPx_MFHoldCode] ([HoldCodeSK])

ALTER TABLE [dbo].[ERPx_IMItem] ADD CONSTRAINT [FK_ERPx_IMItem_ERPx_MFHoldCode_LotHoldReturn] FOREIGN KEY ([LotHoldReturn]) REFERENCES [dbo].[ERPx_MFHoldCode] ([HoldCodeSK])