NorthScope 2019.03.08

Owned by Emma Greenwood
Last updated: Mar 11, 2019
2 min read

(Software Version: 2019.02.22 Database Version: 2019.03.08)

Release Date: March 8th, 2019


Improvements 

Fisherman Accounting

NS-4137 Added Master Account to Fisherman, Tenders, and Loans

A new Master Account property was added to the Fisherman, Tender, and Loan Record Views. This property allows users to associate fishing related accounts together for reporting purposes. This value can be set as follows for each account type:

  • Fishermen - the lookup contains a list of all ‘Active’ Fisherman, Tender, and Fisherman & Tenders accounts that do not already have a Master Account assigned to them.
  • Tenders - the lookup contains a list of all ‘Active’ Fisherman, Tender, and Fisherman & Tenders accounts that do not already have a Master Account assigned to them.
  • Fishermen & Tender - the lookup contains a list of all ‘Active’ Fisherman, Tender, and Fisherman & Tenders accounts that do not already have a Master Account assigned to them.
  • Loans - the lookup contains a list of all ‘Active’ Fisherman, Tender, Fisherman & Tenders, and Loan accounts that do not already have a Master Account assigned to them.

Master Account was also added to the Vendor List View, Vendor History and Fisherman Activity Inquiries, and the Vendor file import template.

Note: A fishing related account that already has a Master Account assigned cannot be a Master Account for another account.

Purchasing

NS-4137 Added Master Account to Vendors

A new Master Account property was added to the Vendor Record View. This property allows users to associate vendor accounts together for reporting purposes. The lookup for setting this value contains a list of all ‘Active’ vendors that do not already have a Master Account assigned to them.

Master Account was also added to the Vendor List View, Vendor History and the Vendor file import template.

Note: A Vendor that already has a Master Account assigned cannot be a Master Account for another vendor.

Technical Changes

Schema Changes

ALTER TABLE [dbo].[ERPx_APVendor] ADD [MasterVendorSK] BIGINT NULL

ALTER TABLE [dbo].[ERPx_APVendor] ADD CONSTRAINT [FK_ERPx_APVendor_ERPx_APVendor_2] FOREIGN KEY ([MasterVendorSK]) REFERENCES [dbo].[ERPx_APVendor] ([VendorSK])