Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / General Journal Line E...
Finance | Project Operations, Human Resources, ...
Suggested answer

General Journal Line Entry Excel Upload is changing the date of my data

(1) ShareShare
ReportReport
Posted on by EL-29050242-0 40
Hi,
I am manually uploading general journal entries via excel and it is unwilling changing the dates on my spreadsheet.
I have no idea why it is forcing dates to either January 1st of 2024 or January 31st of 2024.
Any solution for this?
 
Thank you
 
  • CU08080249-4 Profile Picture
    CU08080249-4 2 on at
    General Journal Line Entry Excel Upload is changing the date of my data
    Ensure the date format in your Excel spreadsheet matches the format required by your accounting system. Check if there are any default date settings or mapping configurations in your journal entry upload process that might be overriding the dates from your spreadsheet. Verify that the dates in your spreadsheet are correctly formatted and not being converted incorrectly by Excel. Additionally, review the upload template or guidelines provided by your accounting software to ensure compliance. If the issue persists, consider reaching out to the software's support team for further assistance to identify and resolve the date formatting issue. (Source)
  • EL-29050242-0 Profile Picture
    EL-29050242-0 40 on at
    General Journal Line Entry Excel Upload is changing the date of my data
    First 4 rows are recognized correctly, and also using the date format embedded in the spreadsheet is identical to what I did.
    It is so strange how only after row 4, the dates are forced to change as Jan 31st.
     
  • Community member Profile Picture
    Community member 4 on at
    General Journal Line Entry Excel Upload is changing the date of my data
    Double-check that the dates you're entering in the Excel cells are correctly formatted. Ensure that the dates are entered in the same format as the cell's formatting. For example, if the cell format is mm/dd/yyyy, make sure you enter the date in that format. <slope game>
  • EL-29050242-0 Profile Picture
    EL-29050242-0 40 on at
    General Journal Line Entry Excel Upload is changing the date of my data
    Hi Hana,
    Thank you for responding.
     
    I have done it multiple times but it started to be problematic this time only.
    Also not all but first few rows are ok but it gets changed after 5th row and they are all in same format.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    General Journal Line Entry Excel Upload is changing the date of my data
    Hi,
    Can you check if the date format is correct, you can refer to old threads similar to this question. Using Excel Upload to D365 - error in copy and paste dates (dynamics.com)
    Best Regards,
    Hana

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans