Outbound Integration List 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 all the records that are currently in the outbound queue that have not yet been successfully exported from 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 the selected record for editing. If a record is not selected, the page will not open.

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. 

Grid Layout

Error rendering macro 'excerpt-include' : No link could be created for 'Toolbar Icon - Grid'.

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 define the following criteria:  Data Search, Include Archived Records.

Mass Update

Opens the Mass Update dialog, which allows to update the status of multiple transactions simultaneously. 

Process

Invokes the procedure that processes all outbound records that are available to process.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Created Date
Error rendering macro 'excerpt-include' : No link could be created for 'Created - Date unsafe-Only'.
Created Time
Error rendering macro 'excerpt-include' : No link could be created for 'Created - Time unsafe-Only'.
IDIdentifies the ID of the transaction attempting to be exported.
Integration MessageIdentifies the reason(s) provided by the destination system explaining why the file could not be successfully exported.
Last Processed DateIdentifies the last date that the integration record attempted to be processed/received by the destination system.
Last Processed TimeIdentifies the last time that the integration record attempted to be processed/received by the destination system.
Reprocess Until DateDisplays the date that the transaction will stop attempting to reprocess.
Reprocess Until TimeDisplays the time that the transaction will stop attempting to reprocess.
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).  
Transaction Type

Identifies the Transaction Type for each transaction. This displays the friendly name from the Outbound Supported Transactions table.

Related Topics

Outbound Integration Record View

Integration Setup - Outbound

Outbound Integration User Guide


 Page Definitions


 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