http://in.compucrete.com/index.php?action=history&feed=atom&title=Inventory_Reconciliation_Report_Queries 2026-05-15T15:15:09Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Inventory_Reconciliation_Report_Queries&diff=298&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-297:rev-298 --> </table>

WikiAdmin http://in.compucrete.com/index.php?title=Inventory_Reconciliation_Report_Queries&diff=297&oldid=prev 2017-01-10T00:01:49Z

<p>1 revision imported</p> <p><b>New page</b></p><div>[[Category: Inventory]]<br /> [[Category: SQL]]<br /> <br /> Purchase Reciepts Review:<br /> &lt;PRE&gt;<br /> SELECT T.PRODUCT_CODE, t.trx_type,T.inventory_gl,P.inventory_gl PROD_INV_GL,<br /> T.offset_gl,apclear_gl,<br /> qty_change,T.COST, P.STandard_COST PRODCOST,T.qty_CHANGE*T.COST ext_cost,<br /> t.trx_date,P.ACTIVE_FLAG,P.STOCKED,t.trx_date mo<br /> FROM ARTPRTRX T <br /> INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE<br /> where trx_date between :Start_Date and :End_Date and trX_type='R'<br /> order by product_code,session_no,trans_no,trx_date<br /> &lt;/PRE&gt;<br /> <br /> Cost of Sales Review:<br /> &lt;PRE&gt;<br /> SELECT T.PRODUCT_CODE,P.DESCRIPTION_1, t.trx_type,T.inventory_gl ORIG_INV_GL,P.INVENTORY_GL,P.costofsales_gl,<br /> T.offset_gl,apclear_gl,<br /> qty_change,T.COST, P.STandard_COST PRODCOST,T.qty_CHANGE*T.COST ext_ORIG_cost,<br /> P.STandard_COST*T.QTY_CHANGE EXT_COST_STD,<br /> t.trx_date,P.ACTIVE_FLAG,P.STOCKED,t.trx_date mo<br /> FROM ARTPRTRX T <br /> INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE<br /> where trx_date between :Start_Date and :End_Date and trX_type='S'<br /> &lt;/PRE&gt;<br /> <br /> Physical Transaction Review:<br /> &lt;PRE&gt;<br /> SELECT T.PRODUCT_CODE,description_1, t.trx_type,P.inventory_gl PROD_INV_GL,<br /> qty_change,T.COST,t.cost*qty_change Inv_Value, P.STandard_COST PRODCOST,<br /> t.trx_date,P.ACTIVE_FLAG,P.STOCKED <br /> FROM ARTPRTRX T <br /> INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE<br /> where trx_date&gt;'12/31/6' and trX_type='P'<br /> order by PRODUCT_CODE,trx_date,trx_time,session_no,trans_no<br /> &lt;/PRE&gt;</div>

Intra>User