Inbound Integration List View

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. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

File ImportOpens 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) 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. 

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Created DateIdentifies 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 TimeIdentifies the time that the record was physically 'Created'. This is a system assigned value and is never editable by a user.
Error TextDisplays the reason(s) that the file could not be successfully imported.  
InboundSKIdentifies the unique identifier of the file. 
Last UserIdentifies the user that manually imported the file or the last user to make any Status changes to the file.
Processed DateIdentifies 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 TimeIdentifies 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 SystemIdentifies 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 TransactionIdentifies 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 UsedA 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.

Related Topics

Inbound Integration Record View

Dialog: File Import

Integration Setup - Inbound

File Import User Guide


 Page Definitions


 Technical Details
Table Names:
dbo.ERPx_INTEG_Inbound



Stored Procedures:
IQx_MFIntegInboundQueue
SPx_MFSEL_IntegInbound
SPx_MFSEL_IntegInboundHeader
SPx_MFUpdate_IntegInbound