I am trying to build a report that shows our total supply and demand. A very condensed version of a time phase. I’d like a 1 row per part set of information. I have got everything I need except for Forecast totals by part.
I am using Part, Part Whse, Part Plant, and Job info all linked up and good. As soon as I try to add the ForeQty to the report and do the query relationships it all goes awry and I get a bunch of duplication and summing issues on most of the fields I already had showing correct values
Good so far
Add forecast field and relationship and it goes wonky
If I unhide the details it looks like it is repeating for the 7 firm sales orders we have, but I don’t even have SO info on here.
Any ideas on what I am doing wrong or do I just have to build this a different way?