I am looking for the unmatched transaction lines.
I found the MatchSetLines table, but I cannot find the match with the TransactionLines. How can I match the TransactionLines with the MatchSetLines?
MatchSetLines
TransactionLines
Endgoal is to find the TransactionLines which are not unmatched. See also the attachment:
Where is this screen located in the menu navigation?
When looking for unpaid invoices, I would use AROutstandingItems and/or APOutstandingItems and then optionally associate these on journal and number with TransactionLines.
AROutstandingItems
APOutstandingItems
I think you are looking for that
20 = Open (unmatched) 50 = Processed (matched)