I need a little direction. On the Order Register it did not contain SOShipment table in it. I want to add that so that I can pull in the field SOShipment.CuryFreightCost to the report. I have it pulling, but when I run the report, it messes up the Total Lines Amount column. I haven’t made changes to it, so I feel that it has to do with the relationship that I have when I added the SOShipment table. I’ve tried multiple relations and haven’t found the right one.
This is the report with the relationships that I have in the report. The original report had the top 3 lines already there and I added the last line.
In this screenshot the highlighted item is the one that I’ve been using to test for accuracy. The number 7475.00 is supposed to be the Total Lines Amt. However, the correct amount that it should be is 575.00.
Any ideas or direction is much appreciated!!
Best answer by Laura02View original