http://in.compucrete.com/index.php?action=history&feed=atom&title=Inventory_Valuation 2026-05-15T16:11:24Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Inventory_Valuation&diff=306&oldid=prev 2023-07-14T12:58:51Z

<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 12:58, 14 July 2023</td> </tr> <!-- diff cache key my_wiki:diff::1.12:old-305:rev-306 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Inventory_Valuation&diff=305&oldid=prev 2018-05-16T14:51:10Z

<p></p> <p><b>New page</b></p><div>[[Category: SQL]]<br /> <br /> Inventory valuation vs G/L valuation (By Inventory G/L Account):<br /> &lt;PRE&gt;<br /> select p.inventory_gl,sum(qty_on_hand*p.standard_cost) Value_STD,<br /> (select sum(trx_amount) from glttrx a where a.gl_account=p.inventory_gl) GLBal<br /> from artprod p<br /> inner join ARPPRTRX_QTY_ON_HAND(p.product_code,'12/31/13',2359,0) x on 1=1 <br /> where p.stocked='Y' and inventory_gl is not null<br /> group by p.inventory_gl<br /> &lt;/PRE?\&gt;</div>

Chanson