Finance | Project Operations, Human Resources, ...

French local report- FEC audit file

(1) Share

Report

Posted on by Grace1609

108

Hi ,

Any experts here who can assist with me on FEC reporting , a local French report. D365 has ER configurations that can be downloaded to be able to generate this report. Link below

docs.microsoft.com/.../emea-fra-fec-audit-file

The report requires all transactions to be reported in EURO currency only, however the report is showing both Accounting Currency Amount and Transaction currency amount when generating the report. Is there any way we can select or limit this report to only reflect Accounting/Local currency when generating this report so all transactions are reflected in EURO

Thanks ! Grace

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Grace,

As this is an electronic report, you can modify the report design yourself in the electronic reporting workspace.

In case you don't like a specific column - such as the one with the transaction currency - you can simply remove it.

If you have not done this before, ask a technical colleague for some support.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

CU02101010-0 4 on at

Like (1)

Report
Copy link

Link copied!

Hi

@Ludwig Hufnagl said "In case you don't like a specific column - such as the one with the transaction currency - you can simply remove it"

This is not a right answer as all columns are required in a FEC (18 or 19 fields) and must be included in the FEC file, even if some are empty in your system.

So, if all of transactions are in euro only, keep in your file the columns "montant en devise"/Amont in currency (fied 17) and "Identifiant de la devise (à vide si non utilisé)" / Currency code (field 18). There will be empty (no space).

Otherwise, the file will be rejected.

Generaly speeking, some datas are compulsory (as account code, accounting date etc) et others are optional with "A vide si non utilisée"/Empy if not used

Best regards

Was this reply helpful? Yes No