AOA,
 
As per request, I have added a new process in the utility named 'Audit Valid Customers Data' which takes Master List of Valid Customers as an XL file and validates existing customers in the AR system against it. On finding any invalid customers in the system which don't exist in your master list, it safely removes them (+ and their transactions) from the AR system. 
 
For example, while running this process, I found this list (attached herewith) of customers in the system which don't exist in ur provided master list; more ever, there are 480 transactions (of different types) of these invalid customers (out of 1,22,910 transactions upto 25-10-2008).
 
Therefore, if you confirm that the utility has pointed out correct lists of invalid customers data, I can send you an updated version of the utility with this new functionality so that you can remove unwanted customers accounts & their invalid transactions from the system by just a button click.
 
Waiting for your confirmation....
 
Zeeshan Hanif - Software 
=================================


OK, If you think that both the customers list & vouchers list given in the xl file that I sent to you should be removed from the system: 1- unzip this file ( Utility Updated 11-05-2008.zip ) 2- copy/paste the two files in CurrentEXE folder3- run the utility again, browse for master customer list xl file; you will find a new process like 'Audit Customers Data'; select it & the correct sheet; preview & run update process.4- Now check out New Customers List; it should now become far less than before; also check out the other reports in the system; which should now show changed balances because around 480 transactions of these invalid customers were also deleted by this process Hope things remain OK; if some problem happens, plz let me know via SMS or email Regards, ZEEshan Hanif