Transaction interface

  1. Upload the CSV file.
  2. Select Financials > Global Ledger > Processing > Transaction Interface > Transaction Interface.
  3. Click Actions > Interface Transactions.
    The Interface Transactions window is displayed.
  4. Select the Run Group that you want to interface and specify this information:
    Edit Only No Update
    Select this check box to check the run groups for errors. If there are records that contain errors, they will be marked so they can be manually corrected before running the transaction interface in update mode.
    Partial Update
    Select this check box to interface records that have no errors and to flag incorrect records that did not interface because of error. If this field is blank, then all records are interfaced. If there are errors, then records with errors are flagged and no records are updated.
    Journalize By Accounting Entity
    Select this check box to journalize transactions by accounting entity, which affects how an async transaction is created. If this check box is selected, a multiple Journalize Transaction AsyncActionRequest is created. The transaction is based on the number of involved entities on your entries to be interfaced. If this check box is cleared, a single Journalize Transaction AsyncActionRequest is created to process your entries.
    Split Journals by Journal Code
    Select this check box to generate journal entries by journal code.
    Bypass Organization Code
    If all of your records are formatted to use valid accounting entity/accounting units that are defined in the Finance Enterprise Group, then select this check box. The entered data values are used and the check for Organization Code mapping is skipped.
    Bypass Account Code
    If all of your records are formatted to use valid accounts defined in the Finance Enterprise Group, then select this check box. The entered data values are used and the check for Account Code mapping is skipped.
    Bypass Structure Relation Validation
    Select this check box if you do not want the interface to validate the structure relations that are defined for your finance structure. If you do not select this check box, then structure relation validation errors will prevent the data from interfacing.
    Interface In Detail
    Select this check box if you do not want transactions to be summarized.
    Currency Table
    Select the currency table for the interface.
    Bypass Negative Rate Edit
    Select this check box to preserve negative rates you have for interface records in Global Ledger.
  5. Click OK to start the interface.
  6. Check for errors.
    1. Click Refresh. If any errors exist, they will be displayed in the Upload tab. Fix any errors.
    2. If you fixed errors in the Finance Enterprise Group setup, click Actions > Reset Upload Errors.
    3. Repeat the Run the upload step until all records are loaded without errors.
      If you have many records, the interface will take some time. To view the progress of the action, select Start > My Actions.
      • If the transactions are interfaced successfully, they are not displayed on this form and can be viewed as Released journal entries. Navigate to one of these to view the journal entries:
        • Processing > Transaction Interface > Interface Run Results.
        • Processing > Journal > Journals
      • If the transactions are not interfaced successfully, then the transaction is flagged where errors exist. Open each transaction to view the nature of the error and to correct the transaction.