Views:

Applies to Product - Dynamics 365 Finance
 

What’s happening?
The FEC audit file generated from Electronic Reporting does not correctly display integration transactions in the report columns, leading to discrepancies in the data representation.
 

Reason:
This arises due to the use of the “|” character as a delimiter for invoice numbers in both the FEC audit file and the system. This results in the invoice number being split into two different columns when the data is converted to Excel or uploaded into a custom staging table, causing subsequent columns to shift.
 

Resolution:

  1. Discuss with the client the following options to address this:
  2. Change the invoice number format to avoid using the “|” character, as this will prevent future issues with the FEC file.
  3. Customize the FEC audit file (FR) to replace the “|” character during file export with another character that is not used in any other column of the FEC file values.
  4. If customization is chosen, follow these steps:
  5. Create a Draft configuration.
  6. Go to Format Designer and select the second Sequence option.
  7. Since the PieceRef column in the Excel is alphanumeric, alter only the txt:Sequence.
  8. Update the current formula to replace the “|” character in the .txt file from the invoice number (e.g., current format 123|456) with “” (e.g., 123456).
  9. Test the changes in the client’s environment to ensure the modifications work as intended.