NorthScope 2019.01.25

Owned by Emma Greenwood
Last updated: Jan 28, 2019
3 min read

(Software Version: 2019.01.25 Database Version: 2019.01.25)

Release Date: January 25, 2019


Improvements 

Inventory

NS-4018 Added “Third Party” column to the Lot Owners Master File

A new column called “Third Party” has been added to the Lot Owners list view to allow users to identify third party product owners, outside of your organization. This field contains a lookup with the values “Yes” or “No”, defaults to “No” and is editable at any time.   This field is for information only.

Note: Default Owner cannot be edited.

NS-3820 Added an integration property to Inventory and Sales Order Transaction Classes  

Added the ability to determine if an Inventory Transaction or a Sales Order would be integrated to the Host System at the Class level. This new property is called “Transaction Integration” and has two options: “No Integration” and “Transaction with Journal Details”.

This means that if the company integration setup is set to “Immediate” or “Timed” for Inventory or Sales Order and the Class level is set to “No Integration”, then neither the transaction or the journal details for the transaction will integrate to the host system. This also means that if the company integration setup is set to “None” for Inventory or Sales Order then no transactions will integrate to the host system no matter the property on the Transaction Class.

If no Host System is setup for the Company and the integration method is set to “No Integration”, the Transaction Integration property defaults to “No Integration” and the field is disabled.  Current Transaction Classes set to “Transaction with Journal Details” will remain setup this way but when moved to “No Integration” the dropdown will be disabled. This field will be re-enabled if a Host System is added to the company setup.

Note: This property will be added by default with “Transaction with Journal Details” option assigned which will not change any current functionality in the system for integrating Inventory Transactions or Sales Orders to the host system.

Sales Order

NS-3820 Added an integration property to Inventory and Sales Order Transaction Classes  

Added the ability to determine if an Inventory Transaction or a Sales Order would be integrated to the Host System at the Class level. This new property is called “Transaction Integration” and has two options: “No Integration” and “Transaction with Journal Details”.

This means that if the company integration setup is set to “Immediate” or “Timed” for Inventory or Sales Order and the Class level is set to “No Integration”, then neither the transaction or the journal details for the transaction will integrate to the host system. This also means that if the company integration setup is set to “None” for Inventory or Sales Order then no transactions will integrate to the host system no matter the property on the Transaction Class.

If no Host System is setup for the Company and the integration method is set to “No Integration”, the Transaction Integration property defaults to “No Integration” and the field is disabled.  Current Transaction Classes set to “Transaction with Journal Details” will remain setup this way but when moved to “No Integration” the dropdown will be disabled. This field will be re-enabled if a Host System is added to the company setup.  

Note: This property will be added by default with “Transaction with Journal Details” option assigned which will not change any current functionality in the system for integrating Inventory Transactions or Sales Orders to the host system.

Bug Fixes

Logistics

NS-3934 Fixed Issues with the Move Orders on Load Record View

Fixed several issues with this process. 

Sales Order 

NS-4028 Fixed an Issue with GL Date being set when an Order was Shipped 

Fixed a bug where the GL Date was being incorrectly assigned when the order was shipped rather than on approval.   

Technical Changes

Schema Changes

ALTER TABLE [dbo].[ERPx_SOOrderTypeDocument] ADD [IntegrationMethodEN] [BIGINT] NULL

ALTER TABLE [dbo].[ERPx_IMTransactionClass] ADD [IntegrationMethodEN] [BIGINT] NULL

ALTER TABLE [dbo].[ERPx_IMLotOwner] ADD [IsThirdParty] [bit] NOT NULL DEFAULT((0))


CREATE UNIQUE NONCLUSTERED INDEX [IX_ERPx_APProgram_UniqueKey] ON [dbo].[ERPx_APProgram] ([APProgramID], [APProgramTypeEN], [DataEntityCompanySK]) ON [PRIMARY]