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 all the records that are currently in the inbound queue that have not yet been successfully imported into NorthScope. From here users can open a record for edit, Mass Update the statuses of one or more records, and open the File Import tool.

Software Version: 2023.08.31 and newer

Page Header

Toolbar Icons	Description
Edit	Opens a single selected record for editing.
Excel	Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported.
Favorites	Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
File Import	Opens the 'File Import' dialog to import new transactions or master file records.
Grid Layout	Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). The bolded view is the default view, which will determine the view will automatically display in when opened.
Help	Opens the online WIKI help page for the current page. This icon is only visible on pages that are documented in the online help.
Inquiry Criteria	Opens Inquiry Criteria window where users can specify the following criteria: Status: Select one or more Statuses Data Search: Searches the 'Error Text' field. Include Archived Records
Mass Update	Opens the Mass Update dialog, which allows the update of the 'Status' for multiple transactions simultaneously.
Fields	Description
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Created Date	Identifies the date that the record was physically 'Created', formatted from the users 'Date Format' preference. This is a system assigned value and is never editable by a user.
Created Time	Identifies the time that the record was physically 'Created'. This is a system assigned value and is never editable by a user.
Error Text	Displays the reason(s) that the file could not be successfully imported.
InboundSK	Identifies the unique identifier of the file.
Last User	Identifies the user that manually imported the file or the last user to make any Status changes to the file.
Processed Date	Identifies the date that the file was processed or attempted to be processed. This is a system assigned value and is never editable by a user.
Processed Time	Identifies the time that the file was processed or attempted to be processed. This is a system assigned value and is never editable by a user.
Source System	Identifies the system or process that originated the files that is being imported. This is a system assigned value and is never editable by a user.
Source Transaction	Identifies the unique identifier assigned by the source system for the file.
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).
Transaction Type	Identifies the Transaction Type for each transaction. This displays the friendly name from the Inbound Supported Transactions table.

NorthScope

Inbound Integration List View

Page Header

Toolbar Icons

Related Topics

Stored Procedures:
IQx_MFIntegInboundQueue
SPx_MFSEL_IntegInbound
SPx_MFSEL_IntegInboundHeader
SPx_MFUpdate_IntegInbound