A custom report with problem dates

(0) Share

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

All responses (1)

Answers (0)

Suggested answer

Josh Page on at

Like (0)

Report

RE: A custom report with problem dates

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.