Difference between qty and ref des
Hello, when trying to add item to BOM with different between number of RefDes and value of Qty AGILE put an warning
1. where could i control this to do blocking ? VIA smart Rules ?
2. is there is an option to get Report of all cases in system where in BOM tables there is a Difference between qty and ref des ?
A query that will point out where there is a difference would be :
select i.item_number ASSEMBLY, r.rev_number, b.item_number COMPONENT, b.quantity, (select count(*) from refdesig where bom = b.id) RD_CNT
from bom b, item i, rev r
where b.item = i.id and b.item = r.item and b.change_in = r.change
and to_number(b.quantity) <> (select count(*) from refdesig where bom = b.id)
and exists (select null from refdesig where bom = b.id);
This will list the assembly number, revision, component along with the BOM quantity and count of ref-des. Note that this will not handle ranges of RefDes (like “A1-3”) or much of anything other than simple values (which are stored separately in the REFDSIG table). You may well get a LOT of records that are not quite an issue, but I did exclude all records that do not have any RefDes at all. Also note that QUANTITY is a *text* field, so I had to use TO_NUMBER in the query. If you have strange characters in there (most do not, but….) the query will fail.