Home › Forums › OpenSync › Schema Linkage Question
This topic contains 0 replies, has 1 voice, and was last updated by Chris Olson 6 months, 2 weeks ago.
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.
You must be logged in to reply to this topic.
Copyright © 2013 Synergration Inc