I considered posting this question in General, but it appears to be mostly spam there. So, my apologies in advance if this post is miscategorized.
I am attempting to build a query, from the OpenSync DB Schema, to display quantities and line items of bills and also the purchase order that each line item is connected to.
bill.TxnID links to txnitemlinedetail.IDKEY – but I cannot find where the txnitemlinedetail can refer back to a purchase order.
I’ve tried liking via linkedtxndetail, but this doesn’t specifically link line items from a bill to a purchase order.
