RE: Altair personal slc select records in the transaction worksheet that are not in the master worksheet
Too Long to Post to Listserv, see github
github
https://github.com/rogerjdeangelis/utl-altair-personal-slc-select-records-in-transaction-worksheet-that-are-not-in-master-worksheet
The trans worksheet is unique on amount, if there are multiples, -229 amounts in the master, WITH DIFFERENT DATES,
YOU NEED MULTIPLE -229S IN THE RECONCILIATION TO PERSERVE ALL THE DATES IN THE MASTER.
SOLUTIONS
1 left join with preserving date information in master
2 left join without duplicates (keep only the maximum date in the master.)
community.altair
https://community.altair.com/discussion/4952
