We’d like to display the receiving bin location for Job Material on the Job Traveler.
I understand that data is in PartBin table but I believe that’s only true with the AMM module which we don’t currently have.
I can see the receiving location in the PartTran table and I’m able to aggregate in a BAQ to get bin totals by JobMtl, but I’m not sure whether this data can go on the existing report nor whether this is good practice.
- Is it true PartBin is not used absent AMM license?
- Is it possible to add a BAQ to an existing RDD/RDL? If so, should I bother?
I’m thinking the aggregate BAQ could become a perf issue as there are likely gazillions of records in PartTran once we go-live. True?
Would it make more sense to BPM copy receiving bin to a user field in JobMtl table instead?
Edit: Basically, we’re looking at going live without AMM and most of our material is order to job auto-issued and no material moves. As a result we lose visibility into JobMtl location and we’re looking at ways to close that gap without AMM.
If anyone has done the same, I’m open to suggestions.
TIA,
Josh