JDE allows you to maintain multiple Cross Reference Items with overlapping effective dates. Whenever a Cross Reference Item is fetched, in case of multiple entries, the first record is always selected.

Actually it should validate on the latest effective date and select the record with latest effective date.

Any expert opinion on the above functionality?