web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

ER File Import From SharePoint broken?

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, 

I experience some difficulties importing files stored on SharePoint via ER as described on this docs site:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-configure-data-import-sharepoint

The log of the batch job says "There is no suitable file to import in the source."

It is not something special, just a simple Excel file with 2 data records that I want to import. 

Interestingly, if I manually import the file via ER without making use of the ER source and batch job configuration, the file import works fine. 

Any hints/tips welcome. 

Thanks, 

Ludwig

I have the same question (0)
  • VRD Profile Picture
    on at

    Hi Ludwig,

    Sorry I cannot help you on your issue. But I need some help from you regarding this ER file import. But I need to implement similar ER file import like you. I have non-standard model to setup which I have done. This file comes from bank and need to mark payment journal transaction payment status as 'Rejected'. The files are text files (not CSV) format and will be placed at Sharepoint.

    Do you think we need to write a custom batch job to read this file and import through ER where i need to write whole code of how ER will be kicked in to convert the Bank file to appropriate format first and then do code to mark ledger transaction payment status to 'Rejected'.

    Your pointer can be of great help to me. Thanks.

    ~ Vikky

  • Bhanu Pratap Singh Profile Picture
    272 on at
    Hi Ludwig, 
    I am facing the same issue, could you please let me know if you got a solution of the issue.

    Thanks, 
    Pratap
     
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,679 Super User 2025 Season 2 on at
    Hi Dr. Ludwig Reinhard,
    Was the issue related to "Run ER import of manually uploaded documents in batch" feature?
  • DianaRaileanu Profile Picture
    6 on at
    Hello everyone, 

    Has anyone found a resolution for this issue?

    Thank you in advance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans