I have a table with Inventory transacation records.
The table contains both Shipment (outgoing) and Receiving (incoming) transactions.
I'm trying to write a report that lists both Sales Orders that result in Shipment records and Purchase Orders that result in Receiving records.
If I link the Inventory Transaction table to the Shipment (Sales Order) tables and to the Receiving (Purchase Order) tables, I only get one or the other (Sales or Purchasing) records, not both. Is there a trick to this with Left, Inner and Right joins on the tables or do I need some other approach?
Thanks for the help,