Appearance of duplicate records in Sales Analysis UXDETAIL file.

Possible causes:
     1.  Running parallel for several months and pulling DOS invoices into DOS SA, then converting to Windows and also retrieving same invoices in Windows.
     2.  Converting the DOS data twice.
     3.  Exporting and importing using the insert new records.
     4.  Converting DOS OE History to Windows (OE) and then converting DOS SA to Windows SA.
     5.  Restoring A4W OE data files after a Sales Analysis retrieval.

How to find duplicated records:
     1.  Use the Query engine to find the duplicated records, using date range or other criteria.
     2.  Use the Line # field in Sales Analysis.  All lines converted from DOS will have line number of zero (0).  All Windows data has line numbers of 1-2.

How to remove duplicate records:
     1.  Use Edit Data function to remove duplicate records one at a time.  This method is okay if there are not many duplicate records.
     2.  Use Export/Import to remove duplicate records if a large number of duplicates are detected.  Export all the Sales Analysis data to the format of your choice, remove the duplicated records, then import the corrected data being sure to use the Replace Current File option.
 

 

 

or email info@unidevco.com with questions or comments about this web. Last modified: November 22, 2006 Copyright © 2000 - 2005 Uni Development Company Inc. All rights reserved.  All other marks are trademarks or registered trademarks of their respective companies.