Has anyone been able to add the PrimBin to both the Materials and Primary part on a Job Router. The issue is you cannot make a dual relationship to the same table in the RDD. We have a need to have the BIN for the materials and the upper-level part. Just curious if anyone has found a solution to this.
1 Like
Can you get to it through the linked tables of the existing data sources?
I do not see a way to get the primary part to the PlantWhse where the PrimBin is stored. I currently have the relationship going from the JobMtl to PlantWhse. Maybe that is the incorrect relationship to get the linked table to show up. Thoughts?
I don’t know if it’s a great option, but you could set the PlantWhse relationship to be Company to Company and then you’d return all your PlantWhse records. Then you could use the query in the RDL to join the same table twice, once from JobHead and the second time from JobMtl. Not sure how well that performs. Or you could write the Job part Primary bin to a UserChar field on JobHead. Those are already available and you could write that using a BPM maybe even when the Job Traveler is printed. Just a couple of ideas.
Wouldn’t it make sense if you could add the same table twice and just alias it differently like you can in SQL? It’s like they gave you the option to name your data source but then still don’t let you use the same table twice. Seems silly to me.
1 Like
Yes, totally agree. I will explore those couple of options. If you have any other thoughts, please let me know. I appreciate your insight.
Some other questions we might want to consider:
What is the purpose of identifying the primary bin on the Job Traveler? I can guess that the material primary bin is shown to help in locating the materials needed for the job. But why the job part primary bin?
Could the bin you’re looking to identify actually be identified in a different way? For instance, does the resource that will be used to complete the job have an output bin that might match what you’re looking for?
Along those lines, the PrimBin is not necessarily where the part is actually being held in inventory. It could be received, transferred, etc. into any bin. Whenever I reference bin information on a form, I pull in the PartBin table. This is where inventory is ACTUALLY on hand.
1 Like
We have the primary bin on our job traveler and I tied the job head to the part plant (both part and plant are on the job head) and then part plant to plant warehouse (Company to Company, Plant to Plant, PartNum to PartNum, and PrimWhse to WarehouseCode) but it’s pretty easy for us because we only have one warehouse per plant.
As for why we have it on the job traveler I believe it’s to make it easier to put it in the primary bin once the job is completed and not a random bin. I’ll be honest though I just completed the request and didn’t dig into it as much as I likely should have.
1 Like
That works fine, unless you want to add Bins to the Materials also. The previous idea of adding it to the company may work. Still testing out how it performs etc.
Hello David;
Did you find a resolution to this? I’m being asked to add Prim Bin to both Job P/N and Job Mtls.
Although like someone mentioned previously since mtls can exist in any bin it doesn’t make much sense to me.
Hello Max - I was so happy to read your post as I need to do this and have been failing getting the primary bin to show on the jobtrav report. It sounds like you were successful in adding the primary bin to the the raw material part of the job traveler. I followed your solution, but must be missing a link (ha).
I added the primary bin to the Traveler_RawMaterialComponents. When i edit the JobTrav RDD and add the PartPlant and PlantWhse tables, create the relationship, edit the SSRS query and fields in the sub-report - the report runs but the Raw Material sub-report does show on the report. Would you have any guidance why that might be so?
I can send copies of the query, relationships etc if you want to see them or let me know the specifics of the added relationships in the RDD and how the SSRS query was edited. Thank you for your time and any knowledge you can throw my way
I have tried tying PlantWhse to to other tables, and I get the subreport but no bin number.
Are your RDD relationships set up with Relation Type of Output?
Hi Lyz;
I was able to deploy Max’s solution and I created two Job Travelers, diff departments need it for diff reasons. One for Job Part Prim bin and one for Job Mtls prime bin. I can’t find a solution to create the relationships for both so that Prime Bin shows for both the Job Part and the Mtl Parts in one SSRS report. RDD doesn’t like it.
- Shows the primary bin for the Job Part.
JobHead 2 PartPlant - joining company, Partnum & Plant.
PartPlant to PlantWhse, join on company, plant, partnum and primwhse to Warehouse code.
- Shows the primary bin for the Mtl Parts.
JobMtl to PartPlant join on Company, Plant and PartNum
PartPlant to PlantWhse, join on company, plant, partnum and primwhse to Warehouse code
1 Like
Good point. They have been both. Currently both set to Output. Thank you for that. I forgot to ask that key point 
Valorie - Thank you so much for the relationship info! I am diving in to option 2, but wanted to take time to thank you for your response!
THANK YOU!!! That was the detail I needed and never would have gotten that on my own. i was going to write that the subreport still did not show this morning; but when I looked at my code, I had the feeling an invisible cat was sitting on my keyboard yesterday when I was typing the changes. Once typed correctly, works fine
1 Like
Lyz, Valorie, or Max. Would one of you be willing to share your RDL that puts the Primary Bin for the Job Part? I’m almost there but I’m doing something wrong that I can’t figure out. I’m probably missing something from the queries, but I’m not SSRS savvy at all, so I’m struggling. I have all my tables joined and relationships built, but when generating the report the field is empty.
Any help is appreciated.
check the relationship type in your RDD on the new ones you added make sure they are setup to Output as mentioned by Max previously.
My RDD won’t help you because there are other customizations in there that will cause problems for you i believe.
Nevermind! I forgot to add it to my select statement. Silly mistake.
Figures though, bang my head off the wall for 2 days and then figure it out 30 seconds after I finally ask for help.
¯_(ツ)_/¯
1 Like