NorthScope 2018.11.30

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

(Software Version: 2018.11.21 Database Version: 2018.11.30)

Release Date: November 30, 2018


New Features

Purchasing

Feature Spotlight! NS-3761 Added a new tax calculation concept to Fish Tickets

A new tax calculation concept was added to Fish Tickets that allows tax amounts to be calculated from a specified Tax Price instead of the Ticket Price. This concept can be used in a situation when a higher price is paid for FAS (Frozen at Sea) items, but the tax is paid only for the dock price. 

To support this, a new “Calculated On” method of “% Taxable Amount” was added to Fish Ticket Taxes. When this is selected as the calculation method, the tax is calculated from the Tax Price instead of the Ticket Price.

The following columns were added to Ticket records:

  • Tax Price - Specify the price for tax calculation on the ticket. Defaults from the Price List if the Tax Price is configured. Otherwise defaults to blank. 
  • Gross Taxable Amount - Identifies the gross amount calculated from the Tax Price. 

Fish Ticket price lists were also updated to allow users to configure price lists with both a Price and a Tax Price. The following columns were added to the Fish Ticket Price List record:

  • Tax Price – Specify the price for tax calculation. This defaults to blank and is not required.
  • Current Tax Price – Identifies the current price for tax calculation.
  • Next Tax Price – Identifies the future price for tax calculation.

These new columns added to Ticket record and Fish Ticket Price List record are not in the system view. 

Note: This change impacts the system view of Fish Ticket Price List and Ticket Record and previously saved custom views must be removed and recreated in order to view the new column.

Improvements 

Purchasing

NS-3697 Disabled Fish Ticket header properties, that have financial significance, when Status >= Approved

The following properties have been updated to be disabled when a Fish Ticket is in the status of Approved, Ready to Post, Posted, Replaced, Deleted, or Void: 

  • Price List
  • Chill Type
  • Dock Delivery
  • Management Program

Sales Order

NS-3735 Removed Reliance on GP Master Number 

Users were occasionally experiencing instances with duplicate master numbers when Sales Order transactions were set to integrate with Dynamics GP. An update was made to ensure the Master Number in GP will not link to different NorthScope transaction types (e.g. Price adjustments and Returns). This was causing inconsistent reporting problems with on screen inquiries.  

Note: The functionality of Master Number in NorthScope is unchanged and will work the same as before.  


NS-3754 Added Additional Columns to the Transaction History Inquiry

Two columns, PO and Salesperson, were added to the Sales Order Transaction History Inquiry.  The values for these columns will be displayed from the value entered on the transaction (Sales Order, Return, Price Adjustment). 

Note: This change impacts the system view of the Transaction History Inquiry and previously saved custom views must be removed and recreated to view the new column.

Note: The Salesperson column displays the Outside Salesperson from the transaction.

Bug Fixes

Commodity Procurement

NS-3780 Fixed CP Ticket Item Lookup

Previously, users were experiencing an issue when adding new line items to a CP ticket.  The item drop-down appeared blank, but after a value was selected and saved, the value became visible.

Inventory

NS-3800 Fixed Base UOM and UOM Schedule Conversion Issue 

Previously, UOM schedule conversions were not auto populating when new UOM schedules were created and the Base UOM didn’t save for NorthScope systems that do not integrate with Dynamics GP.

Technical Changes

Schema Changes

ALTER TABLE [dbo].[ERPx_APDeliveryTicketLine] ADD [TaxPrice] [numeric] (18, 5) NULL

ALTER TABLE [dbo].[ERPx_APDeliveryTicketLine] ADD [GrossTaxableAmount] [numeric] (18, 5) NULL

ALTER TABLE [dbo].[ERPx_MFPriceListItemHistory] ADD [TaxPrice] [numeric](18,5) NULL

ALTER TABLE dbo.ERPx_SOOrderItem DROP COLUMN [OverrideWeight]