Updating Data from Data in an External Financial Application

You can run External Financial Interface Data Request Utility manually (by clicking the Process button) or as a background process run on a regular basis.

Note: 
  • This utility is not used when running the SyteLine Enterprise Financials package that works with Infor SunSystems.
  • Before using this utility, you must set up the external financial interface.

    See Updating SyteLine Data from Data in an External Financial Application.

  • The data request utility is available only if you have selected Use External Financial Interface on the External Financial Interface Parameters form. This utility is needed only if the external system does not have the ability to "push" its data to SyteLine.
  • If records have been deleted in the external system, the corresponding records must be deleted manually in SyteLine. This utility does not delete records.
  • On-premise deployments only: For Infor Global Financials (IGF) integration, only Chart of Accounts, Currency Codes, and Currency Rates can be selected on the Table tab. All fields are available for use on the Customer Posted Balance tab. The IGF integration uses direct data access with this utility to retrieve data for SyteLine.

The Customer Posted Balance tab is enabled only if the Use External A/R System field is selected on the External Financial Interface Parameters form.

The External Financial Interface Data Request Utility can be set up to request updates to specific SyteLine database tables from the external financial application. This utility works as follows:

  1. When the utility's Process button is clicked, the system submits background tasks to TaskMan. The number of tasks submitted is dependent upon the number of check boxes selected.
  2. When the task is processed, it constructs an XML LoadCollection request (or XML Invoke method request for the Customer Posted Balance check box).
  3. The XML request is submitted to the replication tables to be picked up by the Infor Framework Replicator service and placed within the appropriate queue (in this case, the Outbound Queue), based upon the Replication Rules.
  4. The Replication Listener then posts it to the designated URL for the external financial application.
  5. The external financial system translates the XML into a request that its financial application can understand. The application responds to the request by returning a set of updated data.
    Note: This step and the following step are not part of the SyteLine system and must be set up according to the needs of the external financial system.
  6. The external financial system translates the set of data into an XML "load collection" request and places the request in the system mailbox.
  7. SyteLine picks up the XML request and processes it, validating the request and updating the proper table.