Incorrect asset reports by 'main number' if subnumber '0' is retired
Asset reports displays the different results when executed with the options of list assets and main numbers. For example asset number X has three sub numbers (0,1,2) where sub numbers 0 and 1 are retired and sub-number 2 exists. When asset reports are executed with the option of 'display main number', no assets are shown. When asset reports are executed with list assets, sub-number 2 is selected. e.g. S_ALR_87011990 - Asset History Sheet
Any ideas how to avoid this kind of problem. Please suggest.