This content has been marked as final. Show 2 replies
join using the distributions table
ap_invoice_distributions has po_distribution_id. Join it to the po_distributions_all.po_distribution_id.
Hope this helps,
Remember to filter the right invoice distributions. The invoice distribution could be tax, variance, item and etc. We should pull only the relevant distributions.