Outbound Integration Record View

Outbound Integrations refer to Master File and/or Transaction data exports from NorthScope. Examples of Outbound Integrations include exporting Customers, Items, Journal Entries, and Sales Orders from NorthScope to be used by an external system. 

The purpose of this page is to show the details of a single record that is currently in the outbound queue that has not yet been successfully exported from NorthScope. From here users can Mass Update the Status.

Software Version: 2023.08.31 and newer

Page Header

Toolbar IconsDescription
Help Opens the online WIKI help page for the current page. 
SaveSaves the changes made to the record. 

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

FieldsDescription
CreatedA 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.
DataDisplays the data of the record. This field is never editable. The user can manipulate the data in an attempt to correct the integration error. NOTE: This does not update the originating record, it only updates what will be integrated to the host system.
ErrorDisplays the reason(s) that the file could not be successfully imported.  
Last ProcessedIdentifies 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 and is not editable.
Source SystemIdentifies the system or process that originated the files that is being imported. This is a system assigned value and is not 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 Outbound Queue, but no attempt has been made to retrieve. 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 exported files are no longer visible in this list view. 
  • Error: The file contains one or more errors and cannot be retrieved by the destination system. Files in this status must be manually updated to either 'Reprocess' or 'User Bypassed'.
  • Reprocess: A manually set Status to indicate that the file should be re-evaluated the next time the Outbound Integration process runs. 
  • Hold: The file is on hold and no attempts to process/reprocess it will be made.
  • User Bypassed: A manually set Status to indicate that the file should no longer be evaluated (i.e., a subsequent file was exported so this one is no longer needed).  
TypeIdentifies the Transaction Type for each transaction. This displays the friendly name from the Inbound Supported Transactions table.

Related Topics

Outbound Integration List View

Outbound Integration User Guide


 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:
dbo.ERPx_INTEG_Outbound
Stored Procedures:
IQx_MFIntegOutboundQueue
SPx_MFSEL_IntegOutboundADFG
SPx_MFSEL_IntegOutboundHeader
SPx_MFSEL_IntegOutboundTraceRegister
SPx_MFUPD_IntegOutbound
SPx_MFUpdate_IntegOutbound
SPx_MFUpdate_IntegOutboundTraceRegister
SPx_MFUpdate_IntegOutboundTransaction