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.

PartnersCustomers

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.