Bob is right, ALE's do not handle "one to many" relationships between table links. There also doesn't appear to be any ALEs defined for AR_InvoiceHistoryTracking table so no inquiry tasks exist to try to piggy back on.
What is the goal?
Can they use BIE?
If yes, there already is a "Package Tracking" preview that can be selected from the "Customer History Invoices" view.
If not, then one possible solution would be to create a UDF long enough to handle the highest anticipated number of tracking numbers that might occur on a single invoice and use a pre-write event script to join all the tracking numbers into a delimited string and set that into the UDF. Push it through to AR History and you can then add the UDF to the ALE and use the "Contains" operand to locate invoices by the tracking numbers.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 08-23-2019 21:01
From: Bob Pfahnl
Subject: Need the tracking number in ALE
Probably because there are multiple packages per invoice. You might be able to capture Pkg 1.
---------------------------------
Bob Pfahnl
General Manager - Silicon Valley Office
DSD Business Systems
CA
408-641-0922
---------------------------------