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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ax2012 R3 GL journal d...
Microsoft Dynamics AX (Archived)

Ax2012 R3 GL journal data import using Excel-addin

(0) ShareShare
ReportReport
Posted on by Chirani 30

Hi, 

In Ax2012 R3 I am trying to setup data import using Excel-adding for accounting staff. I have deployed the service, created the excel template and uploaded data once. When i try to use the same excel template again to do the data upload i am getting an error. 

I tried several times, only first time it uploads, cannot use the same excel template again. 

Please help. 

Thank you, 
Chirani

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Chirani,

    I have seen this when Excel templates are created by one user and shared with others. The only option usually is then creating a new template. As you have already the columns / data you want to import this can quickly be realized even if it is cumbersome.

    Best regards,

    Ludwig

  • Chirani Profile Picture
    Chirani 30 on at

    Thank you Ludwig. I tried creating a new template first time it does the work. But again if i try to use the same template,  I am getting an error.  

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Chirani,

    Has another user tried setting up the template and got the same error?

    What also usually does the Job is opening the AiF Service form from the AOT and refresh the LedgerGeneralJournalService.

    The last thing I would suggest trying is deactivating and reactivating the inbound port in the system administration module.

    Hope this helps,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,801 Super User 2025 Season 2 on at

    Hi Chirani,

    Can you mention the error details and/or share a screenshot of the error?

  • Chirani Profile Picture
    Chirani 30 on at

        

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Chirani,

    Do you have any News, screenprint, etc. on that?

    I cannot identify anything from the response above.

    Ludwig

  • Chirani Profile Picture
    Chirani 30 on at

    Hi Ludwig, 

    Thank you for your message.  I have done what you asked me to do, and I haven't got any errors.  

    But I make sure I have created a new template, save it. When I use the template  I keep the original template intact. Not saving anything on it.  I manage to upload about 5 times using the same template, without any errors.  

    And when defining, dimension structures, always did the lookup, and validate from the lookup window.

    I have tested with another user, it worked. 

    All working now. 

    Thank you for your help. 

    Chirani

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Chirani,

    Would be great if you could verify as I believe some other users might experience the same issue.

    Thank you and best regards,

    Ludwig

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#2
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

#2
Rahul.p Profile Picture

Rahul.p 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans