• Connecting SO_OrderTierDist to SO_InvoiceTierDist in Crystal

    Has anyone had any luck connecting these two tables together? I am trying to create a daily sales report that has profit based on the lot number. The problem I am running into is the OrderTierDist clears when the sales order is being invoiced and pushes…