Incorrect dates are exported when you export data to Excel from the Transaction Enquiry/Void window in Cashbook Bank Management in Microsoft Dynamics GP 9.0

Symptoms

When you export data to Microsoft Excel from the Transaction Enquiry/Void window in Cashbook Bank Management in Microsoft Dynamics GP 9.0, incorrect dates are exported. This problem occurs if the Deposit Date field or the Reconciled Date field contains the value 00/00/0000. In this situation, the date appears as "30/11/1999" in the Excel worksheet.

Note This article applies only to installations in the United Kingdom.

Resolution

To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 9.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners

https://mbs.microsoft.com/partnersource/downloads/servicepack/Customers

https://mbs.microsoft.com/customersource/support/downloads/servicepacks

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft Dynamics GP 9.0 Service Pack 3.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×