http://52.173.207.40/wiki/index.php?action=history&feed=atom&title=Inventory_Reconciliation_Report_Queries 2026-04-25T05:03:15Z Revision history for this page on the wiki MediaWiki 1.34.0 http://52.173.207.40/wiki/index.php?title=Inventory_Reconciliation_Report_Queries&diff=289&oldid=prev 2020-01-08T13:00:00Z

<p>1 revision imported</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 13:00, 8 January 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

User http://52.173.207.40/wiki/index.php?title=Inventory_Reconciliation_Report_Queries&diff=288&oldid=prev 2017-01-06T21:00:42Z

<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>

en>User