Hi, I want to query Purchase Orders and show related Item Receipts. When I join NextTransactionLineLink table with below criteria, query filters out Purchase Orders without Item Receipt. Any idea how this can be achieved? I want to join NextTransactionLineLink table again to show also data from Vendor Bill as well.

LEFT JOIN NextTransactionLineLink NTLIR ON TL.id = NTLIR.previousline AND TL.transaction = NTLIR.previousdoc AND BUILTIN.DF(NTLIR.nextType) = 'Item Receipt'

I think doing the filter in where clause where you can do instead of the join. (Nexttype ='item receipt' or nexttype is null) should do the job

then it joins all other transaction types which I don't require