NorthScope 2019.04.01

Owned by Emma Greenwood
Last updated: Apr 01, 2019
1 min read

(Software Version: 2019.04.01 Database Version: 2019.04.01)

Release Date: April 01, 2019


Improvements 

Fisherman Accounting 

NS-4273 Updated Payee Name to support 150 characters 

Previously, the Payee Name field in the Process Checks page only supported 65 characters and users were experiencing some issues trying to process checks.  The Payee Name field has been updated to support 150 characters which is displayed in the Payee field on the check.  

Purchasing 

NS-4273 Updated Check Name to support 150 characters 

The Check Name field on the Vendor Properties and Addresses tab of the Record View has been updated to support 150 characters which is displayed in the Payee field on the check.  

Technical Changes 

Schema Changes 

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [CheckName] [varchar] (150) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [HostSystemLink] [varchar] (100) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [VendorID] [varchar] (50) NOT NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [VendorName] [varchar] (100) NOT NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [VendorAccount] [varchar] (25) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [TaxID] [varchar] (15) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [TaxRegistration] [varchar] (25) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [CFECID] [varchar] (50) NULL

ALTER TABLE [dbo].[ERPx_APVendor] ALTER COLUMN [LastUser] [varchar] (150) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [PayeeName] [VARCHAR] (150) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [TransactionID] [varchar] (20) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [Description] [varchar] (250) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [LastUser] [varchar] (150) NOT NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [Address1] [varchar] (75) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [Address2] [varchar] (75) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [Address3] [varchar] (75) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [City] [varchar] (35) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [State] [varchar] (30) NULL

ALTER TABLE [dbo].[ERPx_MFCheckbookTransaction] ALTER COLUMN [Zip] [varchar] (15) NULL