NorthScope 2018.12.21

(Software Version: 2018.12.21 Database Version: 2018.12.21)

Release Date: December 21, 2018

NS-3847 New feature to import new, and update existing Vendor, Fishermen and Loan Accounts

A new .csv file import has been created allowing users to import new Vendor, Fishermen, Tenders, and Loan Accounts from a downloadable .csv Vendor Template.  This also provides the ability to export the existing list, make edits in bulk and then re-import.

The template contains all the Vendor properties as well as all the Vendor Attributes currently configured.

Note: If the .csv list you are uploading contains any Attribute Values, for a Vendor Attribute with a “Data Type” of “List”, the import will automatically add the Attribute Value to your Attribute.

NS-2084 Removed the requirement that every company installed in NorthScope have a Host System and Host Database name assigned

Prior to this update, all companies in the System --> Companies page were required to have a “Host System” and “Host Database Name” assigned when they were installed. These fields are only used for NorthScope companies that integrated to a Dynamics GP or Dynamics AX host system, they are not used for stand-alone NorthScope companies.

In addition, the System --> Companies page was updated with the following changes:

• The “System” column has been renamed to “Host System” and a blank option has been added to the drop-down menu

• The “Database Name” column has been renamed to “Host Database Name”

Users can choose to have a blank Host System and Host Database Name, however if Company Outbound Integration is enabled for any transaction types, a message will be displayed warning the user that the integrations will fail.  Likewise, if users enable any outbound integrations and there is no Host System or Host Database Name configured, a message will be displayed to warn the user that no Host System or Database is setup for the company.

Note: The Host Database Name must be a valid database which is configured for the host system, a message will be displayed in the Outbound integration page.

Note: If users have a Host Database Name configured and choose a blank Host System, the database name will be cleared out upon save.

NS-3793 Improved the error message for Production transactions that have missing Production Batch Attribute values

When users were approving or posting Production transactions that contained one or more Production Batches with missing required Production Batch attributes; the error message only indicated there were missing attribute values, not which values were missing or which Production Batch the missing values were associated with. This message has been updated to specify both the Production Batch and the Attribute that is missing the value, making it much easier for users to fix. 

NS-3794 Added a Ticket Class List View, for Fish Tickets

Users can now see their Fish Ticket classes. The columns displayed in the list view are as follows:

• Ticket Class

• Description

• ADFG Landing Type

• Default Site Processed

• Rows to Create on New

• Default Price List

• Inactive

• Doc Prefix – Note: this column is not in the system view

• Next Ticket Number – Note: this column is not in the system view

All active Ticket Classes are shown when clicking the “New” icon on the Tickets List View and Ticket Record View’s header toolbar. The ticket class can also be assigned to a Fisherman’s permit from the Vendor Record View’s Permits tab.

NS-3794 Added a Ticket Class Record View, for Fish Tickets

Users can now add, edit, and remove their Fish Ticket classes.

The properties displayed in the record view are as follows:

• Group: Setup

  • Ticket Class

  • Description

  • Doc Prefix

  • Next Ticket Number

  • Rows to Create on New

  • Default Site Processed

  • Inactive

• Group: Pricing

  • Default Price List

• Group: ADFG

  • ADFG Landing Type

All active Ticket Classes are shown when clicking the “New” icon on the Tickets List View and Ticket Record View’s header toolbar. The ticket class can also be assigned to a Fisherman’s permit from the Vendor Record View’s Permits tab.

NS-3814 Updated the Vendor Record View to include Property groups

The following groups were added on the Vendor Record View Properties Tab:

ID and Descriptions

• Vendor ID

• Vendor Name

• Check Name

Configuration

• Vendor Type

• Vendor Class

• Attribute Class

• Checkbook

• Currency

• Payment Terms

 Fishing -This group is only visible for Vendor Types of Fisherman, Tender, and Fisherman & Tender

• CFECID – Updated to only be required for Vendor Types of Fisherman and Fishermen & Tender

• Primary Vessel

• Master Fisherman Account

Other

• Tax Class

• Vendor Account

• Tax Type

• 1099 Type

• Tax ID

• Tax Registration

• Hold

• Inactive

 NS-3814 Removed unused properties from the Vendor Record View

The following properties were removed from the Vendor Record View as they had no functionality associated with them in NorthScope:

• Payment Priority

• Discount Grace Period

• Due Date Grace Period

NS-3814 Removed unused Account Types from the Vendor Record View (GL) Accounts Tab

The following Account Types were removed from the Vendor Record View Accounts Tab as they had no functionality associated with them in NorthScope:

• Terms Discount Available

• Miscellaneous

• Freight

• Tax

• Trade Discount

• Accrued Purchases

• Purchase Price Variance

In addition, the Accounts Tab now conditionally shows Account Types based on the Vendor Type. The Account Types for Vendor Types of “Vendor” include:

• Accounts Payable

• Purchases

• Cash

• Terms Discount Taken

• Finance Charge

• Write Off

 The Account Types for all other Vendor Types (Fisherman, Tender, Fisherman & Tender, and Loan) include:

• Settlement Accrual

• Cash

• Terms Discount Taken

• Finance Charge

• Write Off

NS-3814 Changed the Tender Vessel Property name and updated the rules for using it

The Tender Vessel had been used exclusively for linking vessel to a “Tender” account as this is required for assigning the Tender on Fish Tickets imported from eLandings.  This property has been re-named to “Primary Vessel” and it is available for Vendor Types of Fisherman, Tender, and Fisherman & Tender. It is required for Vendor Types of Tender and Fisherman & Tender and it is optional for Vendor Types of Fisherman.

NS-3850 Updated the eLandings integration to correctly import Tickets containing the same ticket item multiple times

Previously, if a ticket was imported from eLandings that contained the same ticket item more than once AND both ticket lines included the # of fish, both ticket lines would import but only the first instance would have the # of fish in NorthScope. Also, the Ticket Item ID and Description was not being shown for Tickets with “Inactive” Ticket Items. 

NS-3785 Fixed an issue updating Transfer transactions between one-part and two-part Transfers

Users were experiencing issues trying to update an existing one-part transfer to a two part transfer (by updating the Ship Via value) and vice versa.

Note: The Ship Via field cannot be updated for Transfer Receipt transactions.

NS-3853 Fixed an issue where Invoice numbers were not being auto assigned consistently

In some instances, Invoice numbers were not always getting auto assigned when transactions were updated from New to Approved or Ready to Post from the Transaction List View.

ALTER TABLE [dbo].[ERPx_APTransactionClass] DROP COLUMN [VisibleInInterface]

ALTER TABLE [dbo].[ERPx_APTransactionClass] ADD [IsInactive] [bit] NOT NULL CONSTRAINT [DF_ERPx_APTransactionClass_IsInactive] DEFAULT ((0))

ALTER TABLE ERPx_APTransactionType DROP COLUMN [IsVisibleToAPTickets]

ALTER TABLE [dbo].[ERPx_MFDataEntityCompany] ALTER COLUMN [DatabaseName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL