http://in.compucrete.com/index.php?action=history&feed=atom&title=Product_Structure%3A_Identify_U%2FM_MismatchesProduct Structure: Identify U/M Mismatches - Revision history2026-05-15T18:01:27ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=Product_Structure:_Identify_U/M_Mismatches&diff=512&oldid=prevWikiAdmin: 1 revision imported2023-07-14T13:00:34Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:00, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-511:rev-512 -->
</table>WikiAdminhttp://in.compucrete.com/index.php?title=Product_Structure:_Identify_U/M_Mismatches&diff=511&oldid=prevIntra>Chanson: /* About */2021-04-30T20:06:31Z<p><span dir="auto"><span class="autocomment">About</span></span></p>
<p><b>New page</b></p><div>==About==<br />
<br />
This query batches component products unit of measure compared with the u/m in the product structure table.<br />
<br />
To be compatable these should need either...<br />
*The same unit of measure type (e.g. volume to volume, weight to weight)<br />
*Have an ARTPRODUMS record to relate the products (e.g. Product: Fiber YD, Mix Fiber LB - Prod UMS 1.2 LB to 1.0 YD)<br />
*For Volume to Weight have Specific Gravity setup. (e.g. Product: Water GL, Mix Water LB - Specific Gravity 1.0)<br />
<br />
==Query==<br />
<br />
<PRE><br />
select 1 ct, x.*,p.product_code,p.unit_of_measure produm,pu.ums_type prdUMtype,cu.ums_type cmpUMtype,p.specific_gravity,u.conv_ratio <br />
,CASE when (Specific_Gravity=0) then 'N' else 'Y' end "SpcGrvYN"<br />
,case when (u.product_code is null) then 'N' ELSE 'Y' end "PrdCnvUMYN"<br />
from artprstr x<br />
inner join artprod p on p.product_code = x.comp_product_code<br />
inner join artums pu on pu.unit_of_measure=p.unit_of_measure<br />
inner join artums cu on cu.unit_of_measure=x.comp_ums<br />
left outer join artprodums u on u.product_code=p.product_code and<br />
((u.conv_source_ums=x.comp_ums and u.conv_target_ums=p.unit_of_measure) or <br />
(u.conv_target_ums=x.comp_ums and u.conv_source_ums=p.unit_of_measure))<br />
</PRE><br />
<br />
==Setup Datascope==<br />
<br />
===DATA: ===<br />
*CT<br />
<br />
===Top Axis===<br />
*CmpUMtype<br />
*Comp_ums<br />
<br />
===Left Axis===<br />
*PrdUMtype<br />
*prdCnvUMYN<br />
*SpcGrvYN<br />
*ProdUM</div>Intra>Chanson