Excel templates not publishing into D365FO

(0) Share

Report

Posted on by Alexio Pfumai

344

Hi all,

I have created a custom excel template by downloading an excel template under common>common> office integration>document templates.

I have added columns and removed some columns. i have created an invoice journal populated 1 line and viewed in Excel. When i change the amount, or add any other details and click publishing, it is not publishing. Message action centre is showing that no changes were detected.

I am kindly requesting for your assistance

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Alexio,

Did you provide the Journal number on the journal line?

Thanks,

Was this reply helpful? Yes No
Alexio Pfumai 344 on at

Like (0)

Report

Hi G thanks for your response, the journal number is there on the journal lines

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,534 User Group Leader on at

Like (0)

Report

Hi Alexio,

Can you share a screenshot of fields you have added to your template?

Thanks,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (0)

Report

Hi Alexio,

Please provide some more information how you created the Excel template. Did you create one from scratch or did you use one out of the box as start?

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hi ALEXIO PFUMA,

Also check from this angle too. Once you have published the data with this template and tried again to publish using the same template, may not work this time. Alternatively, you have to generate the template again, update the data and then publish back.

Regards,
Sourav

Was this reply helpful? Yes No
Verified answer

greengrimms 1,400 on at

Like (0)

Report

Hi Alexio,

I ran into the same issue a while ago. Please check if you included all the fields that compose the data entity key in your excel template. You probably removed some of the columns that are a part of that key.

That should fix it.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hi ALEXIO PFUMAI,

One more point would like to highlight. Is there any Line number available in this template?

Please make sure each invoice line should be maintained with a line number.

Regards,
Sourav

Was this reply helpful? Yes No
Verified answer

Prem Kumar Bachu 3,418 on at

Like (0)

Report

Hi Alexio,

Does this issue resolved? If these answers helped you to fix the issue please mark as verified.

One of the Microsoft site says "All key and required fields must be present to publish data back to the entity. Try to edit the design to add more fields to the binding."

Thanks,

Prem

Was this reply helpful? Yes No