Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Using Excel Upload to ...
Finance forum

Using Excel Upload to D365 - error in copy and paste dates

Posted on by 105

Hi,

I am trying to upload opening balances to D365 via Gl journals and have created a template.  When I copy and paste data from the template to the general journal upload it changes the dates to FY-14 - how can I stop this happening?

  • Suggested answer
    RE: Using Excel Upload to D365 - error in copy and paste dates

    When importing using data management, D365 is picky about date formats in excel.  What I've found is that if you format the date column as text, D365 will import whatever format you choose without problem.  It does sound like you are using data management, but this same trick might work for you.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Using Excel Upload to D365 - error in copy and paste dates

    Hi Louise,

    What exact environment do you have? What date did you provide and what exact date in 2014 is selected? Have you checked if you have a valid license? A demo license might have restrictions on the date. In that case it can be changed automatically.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans