I’m running a BAQ on PartUOM. It’s returning a partial list but not all. For example, on the following part I get only the first two records, but not the “PK” line, which is part specific.
The BAQ is running unfiltered and unjoined to anything else.
Is that maybe because the conversion is set to 1 EA? Defaulted?
I get that same PK code on lots of other parts, but not on some I’ve tested. All but a few are conversion factor 1.
It’s defaulting to 1 on the records I’ve checked on the DB I’m transferring these to.
I might be wrong here, but if the part has never been transacted in that UOM it will not show in PartUOM. It is probably better to join on the uomclassid and get the uoms from there. PartUOM does behave strangely. I think if you had track multiple on it may show in the part uom table.
I did a quick test in my system and it looks like you should only receive part specific conversions on that table that are different than the default conversion value in UOM Class. If this is the case you could set PK to default to 0 and then only set the conversion where needed.
Or is this happening on a secondary database when trying to upload part specific UOMs? I have had issues loading UOM conversions at the class and part level before and found that I had to load them twice in order for them to write to the database properly.
