We have material movers on our shop floor that do transfers and picking, issuing, etc and they want to be able to change a part’s primary bin location but they don’t have access to Part entry.
I’ve tried making an updateble BAQ using the Part, PartPlant and PlantWhse tables. The UBAQ act like it works in that you can double-click the primary bin and change it except that it really doesn’t change the primary bin as seen on the Part>Sites>Warehouses>Primary Bin tab.
Am I missing something or is there another way to change a part’s primary bin location without using Part entry?
According to the data dictionary PlantWhse looks to be the right table…field PrimBin…part of an index on the table.
1 Like
I’m not well-versed in UBAQs so I may be speaking out of turn. Maybe it won’t work if the field is part of an index? That’s the only thing I can think of…
I don’t what you mean by part of an index. I’ve not heard that term before. Can you tell me more about that?
How did you make the UBAQ? Using the checkbox thing? Or you made your own BPM to make the update?
I can confirm that every other field I’ve made updateble on the UBAQ does change the corresponding fields on the Part entry screen. Only the primary bin has no effect. No errors or anything, it just doesn’t update the field.
I cut/pasted a pic from the Data Dictionary earlier in the thread. The PlantWhse table uses field PrimBin as part of an index to the table (Company, warehouse, primary bin). Might be something, might be nothing.
I think that might just be referencing the record of the Primary Bin. The record on the PartWhse table would be the ‘ID’ to the primary bin table but you shouldn’t be updating that table.
I’m not able to see per your image but PartWhse is a different table than the Part table thus you’d have to include the key fields for that table too. In the image below is a uBAQ that I’ve created. It includes both the QuoteMtl and QuoteAsm tables. Notice how ‘Company’ is pulled twice as well as ‘Quote Num’, ‘Quote Line’, etc.
I don’t see primary bin in there. (unless I’m blind)
3 Likes
Wow, that’s weird. Why didn’t it show up automatically like the other fields?
You can try adding it, but it might not be a part of that Business object.
That seems correct, it doesn’t look like part of the BO. When I try to add it I don’t get a table selection for PlantWhse to choose the field from.
Not sure what to try next.
If you want to make that work you have to do the custom BPM route. You can maybe make widgets work (
) but code would be easier if you are doing multiple row editing. You can make a trace and just follow that. But I’m guessing that’s probably more advanced then where you’re at?
I’ve done tracing and made BPMs mostly with widgets, I seem to struggle with the “set field” widget. And yes, C# is my nemesis.
I was able to map the PartWhse.PrimBinNum to the PlantWhse.PrimBin and the update worked.
My query to object mapping
When I add the object to query mapping for this the line just disappears but the updates work. I’ve always thought that you needed mapping on both sides, query to object and object to query. But this seems to work. No syntax error and the field is updated.
3 Likes