Articles in this section

Reconcile functional acknowledgment for an EDI transaction

A functional (FA) serves as a receipt for the receiver (an integrator.io user) to confirm the transaction sent by a trading partner. This receipt confirms that the receiver's transaction has been successfully processed. The primary purpose of a functional acknowledgment (EDI transaction 997) is to provide reliable confirmation of the integrity and successful delivery of EDI transactions between trading partners.

A functional acknowledgment includes details such as:

  • Sender and receiver identification

  • Control numbers

  • Date and time of receipt

  • Status code indicating the outcome of the transmission, which can vary depending on the EDI standards, such as ANSI X12 or EDIFACT.

functional_acknowledgment_reconciliation_drawio.svg

After the EDI file sent by the trading partner is validated against the file definition rules during export, the verification results are used as input for the import process. This process then generates and sends the Functional Acknowledgment (FA) back to the originator of the EDI file.

Example of a functional acknowledgment sample file

ISA*00*          *00*          *14*001695568GT    *14*001695568GP    *240613*2246*^*00501*000000001*0*T*>~  GS*FA*XXXXXXXXXXXXXXX*XXXXXXXXXXXXXXX*20240613*2246*1*X*005010ST*997*0008*3~AK1*AA*49*001000~AK2*100*001*REFNO~AK3*BEG*01*1*1~AK4*3*02*1*1~AK5*A*1*2*1*2*4~AK9*A*1*2*3*2*1*3*2*4~SE*31*0008~GE*1*1~IEA*1*000000001~

Create a custom flow

  1. In your integrator.io account, from the respective EDI integration tile, click + Create flow.

    Note

    The flow should be created in the same EDI integration that includes the EDI flows.

  2. On the new flow page, click Add source and enter configure an export based on the source application you are connecting to.

    Important

    In the EDI parser helper, add "documentType": "997" in the file definition rules for the FA status column in the Dashboard - EDI Activity to be updated.

    edi-parser-helper-x12.png
  3. On the new flow page, below Destination & Lookups, click Add destination/lookup.

  4. In the Application field, enter integrator.io.

  5. On the Create destination/lookup window, in the What would you like to do? drop-down menu, select Import records into destination application.

  6. Click Create flow step.

    Destination_window.png
  7. On the Create import window, provide a Name and Description.

  8. In the Connection field, either select an existing connection or create a new connection.

  9. Below the How would you like the records imported? section,

    1. In the Resource drop-down menu, select EDI transactions.

    2. In the API endpoint drop-down menu, select Update operation.

      IO_connection_reconciliation.png
  10. Click Save & close.

After you configure the source and destination, see the sample image.

FA_reconciliation_flow.png

Check the FA status or download the acknowledgment from the dashboard

  1. In integrator.io, from the left menu, click Dashboard.

  2. In the EDI activity tab, view the functional acknowledgment (FA) status or download the acknowledgment (ack). For more information, see Understand the Dashboard - EDI activity.

    FA_reconciliation_flow_Dashboard_status.png