Hi,
We have a customer that we also sell the same product to. Sell out of one location and buy into another to save on freight differentials. Each sales order has a freight line with the linked Freight Company PO showing how much we pay for the freight on the sale and each purchase also has a freight line showing how much we pay on the purchase. It is not done as a landed cost. Obviously this is an inventory item so the purchase does not show in a P&L. I can run a combined P&L to show but it is only showing actual P&L transactions. How can i get a similar report that will show the inventory purchase as well as the sales and incorporating both freight lines? Is it possible do you think?