Resolved the issue by updating our selection script based on the migration date. The source of the reason code/remarks field is different in JDA 4R4 and JDA Fused. Once the brand gets migrated to JDA Fused the remarks are now saved in the CSDDOC Field from the previously CSDRSN field in JDA 4R4. Met with Mark to have the script on the Pentaho report updated and make it dynamic based on the transaction date.