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.

Viewing 1 post (of 1 total)
  • Author
  • #67401

    Chris Olson

    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.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.