Finance | Project Operations, Human Resources, ...

Correct filename not coming for File in electronic reporting in d365fo

(0) Share

Report

Posted on by Deeksha singh

Hi All,

I have created two designs for positive pay in electronic reporting as shown below-

I have given different filenames for both the files in designer and when i run from the designer as highlighted below it gives me the correct filename-

But when i run it from the Positive pay file batch job or bank accounts form page it gives me the wrong filename-

Am i missing any extra setup or anything that i have to do?

I have added my designs in positive pay format form too-

Can anybody help me? what step or configuration am i missing?

Any help will be appreciated.

Thanks in Advance

Deeksha

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (0)

Report

In Electronic Reporting ,after making file name change, did you change status to complete of ER ?

Was this reply helpful? Yes No
Deeksha singh 47 on at

Like (0)

Report

Hi Nuno,

Yes i have marked it as completed that's why the design was available in the positive pay format form and i was able to use that design in the positive pay batch job and bank account page.

Still getting different design names.

Was this reply helpful? Yes No
nunomaia 25 Moderator on at

Like (0)

Report

I was mentioned that, since already occurred to me a similar issue.

Corrected file name formula

Forgot to apply again status.

changes weren't applied by D365. It was still using older version of ER

Was this reply helpful? Yes No
Deeksha singh 47 on at

Like (0)

Report

I checked, my design and the version which i am using is mark as completed.

I am unable to understand what is the issue.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Deeksha,

Can you run the GER config directly to see if you get desired result?

Can you run test File name function to check if you get any result?

Was this reply helpful? Yes No
Deeksha singh 47 on at

Like (0)

Report

Hi Alireza,

Yes when i run directly from GER config, it gives me correct name but when i generate the file from positive pay batch job it gives me another name.

This is the formula which i am using-

CONCATENATE("CCLP","_","TX","_","USD",DATETIMEFORMAT(NOW(), "MMddyyHHMM" ))

file name which i get when i run from GER CONFIG- 'CCLP_TX_USD0915220809'

file name which i get when i run from batch job- 'P-PAY-US-0091-00361'

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Deeksha,

Like you mentioned, you have set the status to "Completed" after you made the modification. Can you run the "Generate a positive pay file" without batch to check if you get the file with correct name?

Nb.Your formula will work while it seems that it will have same value with each run (eg. you can run CONCATENATE("CCLP","_","TX","_","USD", DATETIMEFORMAT(NOW(), "dd.MM.yyyy HH:mm:ss" ))

Was this reply helpful? Yes No
Deeksha singh 47 on at

Like (0)

Report

Hi Alireza,

I get the correct name only when i run from GER config,

I ran from Generate a positive pay file but still getting that wrong filename.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Deeksha,

Please try to delete Positive pay formats, then delete your user data and then log out.

Try to login via private browser and create the Positive pay formats and then try to generate the file-

Was this reply helpful? Yes No
Deeksha singh 47 on at

Like (0)

Report

Hi Alireza,

I created new designs and still no luck i am getting the same output.

So i debugged and what i found from standard class-

I am getting the same output name(Wrong one) as highlighted below.

So after going through the method, i setup my format in ER Destinations, but still i am getting the same wrong output name from batch job, can anyone please help, its very urgent for me.

Thanks

Deeksha

Was this reply helpful? Yes No