Inbound Integrations refer to data imports that create or update Master Files and/or Transactions in NorthScope. Examples of Inbound Integrations include importing Customers, Items, and GL Accounts from Excel or from a third-party integration.

The purpose of this page is to show the details of a single record that is currently in the inbound queue that has not yet been successfully imported into NorthScope. From here users can Mass Update the status.

Software Version: 2023.08.31 and newer

Page Header

Toolbar Icons	Description
Help	Opens the online WIKI help page for the current page.
Save	Saves the changes made to the record. It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.
Fields	Description
Created Date	A non-editable text box to identify the Created Date & Time of the Transaction, formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.
Data	Displays the data of the record. This field is never editable.
Error	Displays the reason(s) that the file could not be successfully imported.
Last Processed	Identifies the Date & Time that the file was last processed or attempted to be processed. This is a system assigned value and is never editable by a user.
Source ID	Identifies the unique identifier assigned by the source system for the file. This is a system assigned value but is editable.
Source System	Identifies the system or process that originated the files that is being imported. This is a system assigned value but is editable.
Status	Identifies the Status of the transaction. The Statuses that apply to transactions in this List View include: New: The file has been submitted to the Inbound Queue, but no attempt has been made to import it. This is the first status assigned to all new files. InProcess: A batch of records that contains this file is currently being processed. This is a temporary status, if any records are in this status for more than one minute contact NorthScope Support. Complete: The file was successfully processed. Successfully imported files are no longer visible in this list view. Error: The file contains one or more errors and cannot be imported. Files in this status must be manually updated to either 'Reprocess' or 'User Bypassed'. Not Used: A manually set Status to indicate that the file should be removed. Reprocess: A manually set Status to indicate that the file should be re-evaluated the next time the Inbound Integration process runs. User Bypassed: A manually set Status to indicate that the file should no longer be evaluated (i.e., a subsequent file was imported so this one is no longer needed).
Type	Identifies the Transaction Type for each transaction. This displays the friendly name from the Inbound Supported Transactions table.

NorthScope

Inbound Integration Record View

Page Header

Related Topics

Page Definitions

Technical Details

Stored Procedures:
IQx_MFIntegInboundQueue
SPx_MFSEL_IntegInbound
SPx_MFSEL_IntegInboundHeader
SPx_MFUpdate_IntegInbound