I’m looking to add some data to the time Phased Material Requirements report. Buyer and Part Class specifically from Part Entry. Any ideas where to start? I don’t see a BAQ linked to it. So probably something in the Report Data Definitions?
That report may be a bit extra annoying since it’s not dealing with standard tables. You’ll need to edit the Report Data Definition to add Part (Class) and PartPlant (Buyer). You’ll need to join these to the calculated fields in the Tphse table that’s being generated. Then you’ll have to go to Report Style, edit the report, add the joins and fields to the SSRS query, then add them to the SSRS report itself.
1 Like
It turns out the Part Class was actually already in the table, just had to add a new text box. Buyer is trickier. i went into the RDD and unchecked excluding it as it’s already under PartPlant in there. Then I added a new calculated field in the Report Style. Not sure how to link it though.
also, this might even get tougher because there is a hiearchy for buyers and planners… if you dont set the buyer/planner in PartPlant, then it falls back to the PartClass/ProductGroup, and if not there, then it falls back to the site table (If i remember correctly).
but one other thing… my question (one that i would have asked when I was a consultant). Why are you printing this report in the first place. Very few customers (in my experience) use this report since we already have he Planner release workbench, and the PO Suggestions screen that allow for filtering. Printing out to get lots of paper that becomes obsolite the moment you print is fairly old-school.
We don’t use Planner Release Workbench. At least I have never seen someone use it.
We don’t print the report. We have it email everyday for when parts go below 0. It’s super helpful as we get an 8am report for any emergency parts that are required. Including when they are needed.