Need to pull revenue lines based on AR collection
We are trying to create a query where we need to pull corresponding revenue lines (BI_ACCTG_ENTRY) against the deposits that are applied to items (invoices). We are trying to join ITEM_DST or ITEM_ACTIVITY with BI_ACCTG_ENTRY but due to lack of proper joins (other than invoice Id we are not seeing any common link) we are not able to pull correct result when there are multiple lines.
Can you suggest:
- A better way to pull this information
- If we have to join AR tables with BI tables what tables to join and with what fields