Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Ax2012 R3 GL journal data import using Excel-addin

Posted on by 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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ax2012 R3 GL journal data import using Excel-addin

    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

  • Chirani  Profile Picture
    Chirani 30 on at
    RE: Ax2012 R3 GL journal data import using Excel-addin

    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
    RE: Ax2012 R3 GL journal data import using Excel-addin

    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
    RE: Ax2012 R3 GL journal data import using Excel-addin

        

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,339 Super User 2024 Season 2 on at
    RE: Ax2012 R3 GL journal data import using Excel-addin

    Hi Chirani,

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

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ax2012 R3 GL journal data import using Excel-addin

    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

  • Chirani  Profile Picture
    Chirani 30 on at
    RE: Ax2012 R3 GL journal data import using Excel-addin

    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
    RE: Ax2012 GL journal data import using Excel-addin

    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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans