web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... A custom report with p...

Finance | Project Operations, Human Resources, ...

Suggested Answer

A custom report with problem dates

(0) Share

Report

Report

Posted on by Julia_Gallegos

HI,

I have a custom report into GP, this report can export to excel, the report is a inventory kardex, and show all the inventory transaction in a period time, today when I generate te report with 4th July, in Excel the dates appears like 02/01/1900, when check the information in the table by SQL all the records have empty date, they are like 01/01/1900...

Can be this a problem from some update in Office? now in July?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Josh Page Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

If the query itself is returning a blank date, what query is being ran to get the data? Once we know where the data is coming from in the query, you can then review the transaction which set the data to see if we potentially have a cause.

Once you see what table the data i pulled from and review the transaction, in a test company try to recreate the transaction and see if the same issue occures.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 341 Most Valuable Professional

#2

CU10121822-0 312

#3

André Arnaud de Cal... 262 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans