US Form 4797 - Sales or Exchanges of Property Report not showing all the Retired assets

Hi all,

We are facing an issue related to Standard US Form 4797 - Sales or Exchanges of Property Report. This report not showing all the Retired assets with Retirement type as Sale.

Also referred the below information as well:

For an asset to be selected by this report the following criteria must be met:

1. TRANSACTION_TYPE_CODE in FA_TRANSACTIONS_HEADERS must be 'FULL RETIREMENT' or 'PARTIAL RETIREMENT'.
2. RETIREMENT_TYPE_CODE in FA_RETIREMENTS must contain "SALE" OR RETIREMENT_TYPE_CODE must be NULL and PROCEEDS_OF_SALE in FA_RETIREMENTS is greater than 0. 

Assets Not Appearing On US Form 4797 Reports(KB45926)