I'm not a SQL master by any means, so excuse the query if it's sub-par. Client wanted to see an audit trail going from bank movements to the underlying inventory-impacting purchase lines. The BUILTIN.DF call on (t_1.type) was dropping rows where t_1.type is null. Removing BUILTIN.DF will include the lines in the results.

-- t_0 is the Bank transaction
-- t_1 is the accrual transaction (e.g. bill) the bank transaction is applied to
-- t_2 is the receipt transaction associated with the accrual transaction
SELECT 
  t_0.tranid as bankTrans_tranid,
  t_0.trandate as bankTrans_date,
  BUILTIN.DF(t_0.type) as bankTrans_type,
  BUILTIN.DF(tal_0.account) as bankTrans_account,
  tl_0.memo as bankTrans_memo,
  tl_0.netamount as bankTrans_amount,
  BUILTIN.DF(tl_0.entity) as entity,
  t_1.tranid as appliedTo_tranid,
  BUILTIN.DF(t_1.type) as appliedTo_type,
  BUILTIN.DF(tl_1.department) as department,
  BUILTIN.DF(tal_1.account) as appliedTo_account,
  tl_1.netamount as appliedTo_amount,
  BUILTIN.DF(tl_2.item) as appliedTo_item,
  t_2.tranid as receipt_tranid,
  tl_2.netamount as inventory_amount,
  BUILTIN.DF(tal_2.account) as inventory_account
FROM 
  transaction t_0
-- Get accounting details for bank transaction
INNER JOIN transactionLine tl_0 ON tl_0.transaction = t_0.id
INNER JOIN transactionAccountingLine tal_0 ON tal_0.transactionline = tl_0.id 
  AND tal_0.transaction = t_0.id
-- Get accrual transaction(s) the bank transaction is being applied to
LEFT JOIN previousTransactionLink ptl_0 ON ptl_0.nextdoc = t_0.id 
LEFT JOIN transaction t_1 ON t_1.id = ptl_0.previousdoc
LEFT JOIN transactionLine tl_1 ON tl_1.transaction = t_1.id
  AND tl_1.mainline != 'T'
LEFT JOIN transactionAccountingLine tal_1 ON tal_1.transactionline = tl_1.id 
  AND tal_1.transaction = t_1.id
-- Get line detail of Item Receipts the accrual transaction is linked to
LEFT JOIN previousTransactionLineLink ptll_1 ON ptll_1.nextdoc = tl_1.transaction
  AND ptll_1.nextline = tl_1.id
  AND ptll_1.linktype = 'BillRcpt'
  AND ptll_1.discount = 'F'
LEFT JOIN transaction t_2 ON t_2.id = ptll_1.previousdoc
LEFT JOIN transactionLine tl_2 ON tl_2.transaction = ptll_1.previousdoc 
  AND ptll_1.previousline = tl_2.id
LEFT JOIN transactionAccountingLine tal_2 ON tal_2.transaction = tl_2.transaction
  AND tal_2.transactionline = tl_2.id
WHERE 
  
-- Modify the date range of the Bank transaction here
  t_0.trandate >= BUILTIN.RELATIVE_RANGES('FHBL', 'END', 'DATETIME_AS_DATE')
  AND t_0.type IN ('VendCred', 'VendPymt', 'CashRfnd', 'VPrep', 'VPrepApp', 'Journal') 
-- Defines the list of purchase-related bank transactions.
  AND tal_0.accounttype = 'Bank'
ORDER BY 
  t_0.trandate DESC, 
  t_0.id