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

WikiAdmin http://in.compucrete.com/index.php?title=Inventory_Reconciliation&diff=295&oldid=prev 2021-03-08T17:38:33Z

<p></p> <p><b>New page</b></p><div>__NOTOC__<br /> <br /> ==Inventory Reconciliation==<br /> <br /> '''[http://keystonehelp.compucrete.com/wiki/index.php/Inventory_Reconciliation See the latest version of this topic on Keystone Help Site]''' <br /> <br /> Topic Highlights:<br /> *Steps to Reconcile Inventory<br /> *ARTPRTRX transaction types<br /> <br /> How to [[DeReconcile Inventory]]<br /> <br /> ==Understanding the Reconcile Process==<br /> <br /> The reconcile process looks at only unreconciled transactions, starting with 'B' Balance transactions. The normal starting condition is for there to be just one unreconciled 'B' record all the transactions for the current period and possible some backdated unreconciled transactions for the prior period.<br /> <br /> *Get the beginning balance (This is normally a single unreconciled 'B' transaction)<br /> *Process all transactions in timestamp sequence including any the prior month.<br /> **Create G/L Transaction for where appropriate<br /> **Update the artprtrx record with<br /> ***New cost value<br /> ***Reconciled Flag set to Yes<br /> ***Set Recon Session No and Recon Trans No<br /> *Write an Unreconciled 'B' record with the updated cost and quantity on hand<br /> <br /> ==Simple Diagnostics==<br /> <br /> You can run this query to see the transactions that will be viewed in the process.<br /> &lt;PRE&gt;<br /> SELECT * FROM ARTPRTRX<br /> WHERE PRODUCT_CODE='xxxx'<br /> AND RECONCILED_FLAG='N'<br /> ORDER BY TRX_DATE,TRX_TIME<br /> &lt;/PRE&gt;<br /> The 'B' Record will appear in timestamp order, but the process will always place 'B' records first.</div>

Chanson