http://in.compucrete.com/index.php?action=history&feed=atom&title=Verify_Product_Cost_Rollup 2026-05-15T15:29:25Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Verify_Product_Cost_Rollup&diff=676&oldid=prev 2023-07-14T13:00:38Z

<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-675:rev-676 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Verify_Product_Cost_Rollup&diff=675&oldid=prev 2018-05-16T14:52:59Z

<p></p> <p><b>New page</b></p><div>[[Category: Inventory]]<br /> [[Category: SQL]]<br /> <br /> All Products<br /> &lt;pre&gt;select p1.product_class,p1.product_code,p1.description_1,p1.standard_cost, <br /> sum(qty_assembly*p2.standard_cost) &quot;Calc Std Cost&quot;, <br /> (sum(qty_assembly*p2.standard_cost))-p1.standard_cost &quot;Diff&quot; <br /> from artprod p1 <br /> inner join artprstr x on p1.product_code=x.assy_product_code inner join artprod p2 <br /> on x.comp_product_code=p2.product_code <br /> group by p1.product_class, p1.product_code,p1.description_1,p1.standard_cost order by 1 ,2<br /> order by 1<br /> &lt;/pre&gt;<br /> <br /> Products with cost mis-match<br /> &lt;pre&gt;<br /> select p1.product_class,p1.product_code,p1.description_1,p1.standard_cost,<br /> sum(qty_assembly*p2.standard_cost) &quot;Calc Std Cost&quot;,<br /> (sum(qty_assembly*p2.standard_cost))-p1.standard_cost &quot;Diff&quot;<br /> from artprod p1<br /> inner join artprstr x on p1.product_code=x.assy_product_code<br /> inner join artprod p2 on x.comp_product_code=p2.product_code<br /> where abs(p1.standard_cost-<br /> (select sum(x2.qty_assembly*p3.standard_cost) from artprstr x2<br /> inner join artprod p3 on x2.comp_product_code=p3.product_code<br /> where p1.product_code=x2.assy_product_code ))&gt; .0001<br /> group by p1.product_class, p1.product_code,p1.description_1,p1.standard_cost<br /> order by 1 ,2<br /> &lt;/pre&gt;</div>

Intra>Chanson