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 ?

 

difference between qty and ref. des.

" class="qa-zoom" title="Difference between qty and ref des">Difference between qty and ref des

difference between qty and ref. des.

">

 

thank you.

Agile User Asked on February 10, 2020 in Agile PLM (v9).
Add Comment
3 Answer(s)

Hello

Please find answers

#1 – No, there is no smart rule for this

#2 – No out of the box report available. You may have to do thro’ SQL

– Raj

Agile Expert Answered on February 10, 2020.
Add Comment

Do you have an Example of such a Report already created and could share ?

Agile User Answered on February 10, 2020.
Add Comment

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.

Agile Angel Answered on February 10, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.