NorthScope 2018.12.07

Owned by Emma Greenwood
Last updated: Dec 17, 2018
3 min read

(Software Version: 2018.11.21 Database Version: 2018.12.07)

Release Date: December 07, 2018


Improvements 

Financial

NS-3676 Updated the Journal Lines List View and Journal Lines Inquiry to show Project and Fishermen Distributions from AP Invoices & Credit Memos and Fisherman Adjustments   

Prior to this update, the journal entries for these transactions did not show Project or Fishermen Distributions. The Journal Entries for these transactions have been updated so that transaction line items are now unique by GL Account and Distributed To. As a result, this data can all be audited from the GL and or GL Reports such as the Ledger Detail or Trial Balance Detail. To accomplish this, the following columns were added to the Journal Lines List View and Journal Lines Inquiry and the ‘Project’ column was removed:

  • Distributed Type – Displays the type of distribution, for example Vendor type (Vendor, Fisherman, Tender, Fisherman & Tender, and Loan), Employee, or Project
  • Distributed To – Displays the name of the Vendor, Employee, or Project the amount is distributed to

This development item includes a data fix that 1) migrates project transactions to journal lines; 2) updates historical journal details to have distribution to vendors and employees.

Inventory

NS-3369 Updated Item Sets List View Default Sort to be by Item Set Name

The Item Sets List View was updated to sort by the Item Set Name by default.

Sales Order

NS-3803 Added the ability to import/export a Customer and Customer Attributes via the File Import tool

A new File Import template called Customer was created to provide users with the ability to import and export customers and attributes.  The template contains all the Customer properties that are displayed on the Customer record view properties tab and any customer attributes that are setup within NorthScope. 

Note: Importing a list type attribute value that does not already exist in the list will add the attribute value to that list and will be visible in both the Customer record view attributes tab drop-down menu for that attribute and in Company > Attributes > Customers > Add/Edit

Bug Fixes

Commodity Procurement

NS-3787 Fixed Duplication Issues on CP Tickets

There was an issue with accrual items duplicating when a CP price list contained an accrual item which was assigned to both a specific item and to all items.  There was also an issue when a CP ticket had multiples of the same item with the same price duplicating when the item was repriced.

As part of this work item, the “Applies To Item(s)” column on the ticket record view for Accruals/Charges has been updated to a multi select drop-down menu to allow users to select whether the Accrual/Charge applies to all items, a single item, or multiple items. This field is editable until the ticket is saved as Approved.

Purchasing

NS-3837 Fixed an issue in the Ticket Item List causing an invalid error

On some occasions when attempting to update the list of delivery ticket items in the Ticket Item List View, an invalid error would occur having to do with the length of the Item ID.

Technical Changes

Schema Changes

ALTER TABLE [dbo].[ERPx_APDeliveryTicketItem] ALTER COLUMN [ItemID] [varchar] (105) NOT NULL


ALTER TABLE [dbo].[ERPx_CPTicketAccrual] ADD [ItemSKCSV] [varchar] (max) NULL

ALTER TABLE [dbo].[ERPx_CPTicketAccrual] ADD [AccrualCalcMethodSK] [bigint] NULL


ALTER TABLE [dbo].[ERPx_CPTicketCharge] ADD [ItemSKCSV] [varchar] (max) NULL

ALTER TABLE [dbo].[ERPx_CPTicketCharge] ADD [ChargeCalcMethodSK] [bigint] NULL


ALTER TABLE [dbo].[ERPx_CPTicketReprice] ADD [TicketDetailSK] [bigint] NULL


ALTER TABLE [dbo].[ERPx_GLJournalLineDetail] ADD [MFDistributionAccountTypeEN] [bigint] NULL

ALTER TABLE [dbo].[ERPx_GLJournalLineDetail] ADD [DistributionAccountSK] [bigint] NULL


DROP TABLE ERPx_GLProjectTransaction


DROP TABLE ERPx_RSBOL_ExecutionHistory