We have a report that will show any open replenishment purchase order lines. We are trying to connect this with the shipment table - to only show items that are currently not in stock but are on replenishment purchase orders.
When I try to join SOShipLine or SOShipLine Split - the report breaks. I believe I am using all the common fields to join them, but not sure why it breaks.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/823ef98b-c225-4903-b617-7bb81a29c6cd.png)
Could you please advise what I am missing? I have also attached the rpx file. Thank you in advance!
Best answer by lauraj46
View original