IMPORTANT! RMS Data corruption possible from Windows XP Service Pack 3 and Vista Service Pack 1

https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/rms_xp_sp3_vista_sp1_compatibility.htm?printpage=false

Compatibility issue in Microsoft Dynamics RMS after Windows XP Service Pack 3 or Windows Vista Service Pack 1 is installed (Updated 5/14/08): May Cause Data Loss

Last Modified 5/16/2008Posted 4/22/2008
Microsoft has identified a compatibility issue that occurs after Windows XP Service Pack 3 (SP3) or Windows Vista Service Pack 1 (SP1) is installed on a Microsoft Dynamics Retail Management System (RMS) computer. This compatibility issue may cause data loss in Microsoft Dynamics RMS databases.


Overview
Windows XP SP3 and Windows Vista SP1 include a change to the handling of database records that include information from more than one table. For example, a supplier record in Microsoft Dynamics RMS includes information from both the Supplier and Item tables. In more technical terms, Identity field values are not reflected in record sets after installation of the service pack. This may cause data loss in Microsoft Dynamics RMS databases that may not be apparent to the user.


Details
Symptoms
These are some of the issues we are currently aware of that you may experience in Microsoft Dynamics RMS after you install Windows XP SP3 or Windows Vista SP1:
Inability to process Headquarters worksheets
Inability to create a supplier with associated items
Inability to create associations with Matrix, Lot Matrix, and Assembly items
Inability to add a quantity discount to an item
Application crash when you try to create Lot Matrix items
Application crash when you try to create a customer who has one or more shipping addresses


User Impact
All Microsoft Dynamics RMS users who have installed Windows XP SP3 or Windows Vista SP1 will be affected. Note While this issue extends to Windows Server 2008, that is not a supported operating system for Microsoft Dynamics RMS.


Resolution
Supported Windows Vista and Windows XP updates are now available from Microsoft that will prevent these issues from occurring.For more information about these updates and how to download them, visit the following Microsoft Web site:http://support.microsoft.com/?kbid=952287

Notes:
Applying this update will not fix any data damage that has occurred before applying the update
If you use Windows XP you must have Windows XP SP2 or Windows XP SP3 installed on the computer before you apply the update.
The Windows XP update information is located toward the bottom of the Knowledge Base article.
If you use Windows Vista you must have Windows Vista SP1 installed on the computer before you apply the update.