Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

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. 

Header Toolbar

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. 

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. 

Columns

Column Headers

Description
Created DateDisplays the creation date of the line item.
Created TimeDisplays the creation time of the line item.
Error TextDisplays the error details for unsuccessful file imports.  
InboundSKDisplays the SK value assigned to the inbound integration transaction. 
Processed DateDisplays the date of the file processing event.
Processed TimeDisplays the time of the file processing event.
Source SystemDisplays the source system name of the line item.
Source TransactionDisplays the source transaction of the line item. 
StatusDisplays the status of the line item (Complete, Error, InProcess, New, Not Used, Reprocess or User Bypassed).

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














  • No labels