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

Community site session details

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

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

(0) ShareShare
ReportReport
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?

I have the same question (0)
  • Suggested answer
    Mark Schurmann Profile Picture
    4 on at
    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
    297,205 Super User 2025 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 > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans