I need to retain the IFF item info, but also join in the

amount

field from TransactionAccountingLine?

sorry i may be wrong - I was trying something similar the other day trying to get

amount

from transaction ended up being the

foreigntotal

- LMK