Excel templates not publishing into D365FO

(0) Share

Report

Posted on by Alexio Pfumai

346

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)

Sort by

Suggested answer

Gaurangkumar Jani 4,558 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi Alexio,

Did you provide the Journal number on the journal line?

Thanks,

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

Like (0)

Report
Copy link

Link copied!

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,558 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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... 305,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,732 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,732 on at

Like (0)

Report
Copy link

Link copied!

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,422 on at

Like (0)

Report
Copy link

Link copied!

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