tag:blogger.com,1999:blog-3160669066424815487.post3011049866227678622..comments2024-03-28T02:06:02.629-07:00Comments on Dynamics GP Essentials: Inventory Reconciliation - Purchase Receipt Work and DetailsMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-3160669066424815487.post-56146725743315423882017-11-15T20:58:12.629-08:002017-11-15T20:58:12.629-08:00Hi Mahmood I run the scrit, few records pulled up....Hi Mahmood I run the scrit, few records pulled up. Then i run Inventory Reconciliation, executed your script again to see no changes at all. few recors that Pulled up is as below:<br />ITEMNMBR TRXLOCTN QTYRECVD_200 QTYSOLD_200 ITEMNMBR TRXLOCTN SRCRCTSEQNM QTYSOLD_201 VARIANCE<br />0033 6022 92.53000 92.53000 NULL NULL NULL NULL NULL<br />0066 6022 5478.00000 5478.00000 NULL NULL NULL NULL NULL<br />0259 6022 4225.00000 4225.00000 NULL NULL NULL NULL NULL<br />208001 2004 2357.91000 2357.91000 208001 2004 1 2075.67000 282.24000<br />0121 6022 1521.00000 1521.00000 NULL NULL NULL NULL NULLAnonymoushttps://www.blogger.com/profile/17135507893287076623noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-68887276827546820692014-11-04T00:37:50.296-08:002014-11-04T00:37:50.296-08:00Deleting records from IV10200 is not something to ...Deleting records from IV10200 is not something to consider at all, it will have negative ramifications on several associated modules and functionsMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-20746049505212680042014-10-17T17:15:47.407-07:002014-10-17T17:15:47.407-07:00Thanks for the details and script. Please need an ...Thanks for the details and script. Please need an advise. I run a reconciliation process about a week ago and it takes almost 3 days to finish. So, i came up with series of testing. I deleted some data on IV10200 and IV10202 (retain 3 months on current) and the reconciliation process only takes 3 hours. But i having issue on Historical stock status report major item are dis balance.<br />Please help me.wolfparkinghttps://www.blogger.com/profile/17714502167775063863noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-86636808285341389752014-04-30T00:00:55.248-07:002014-04-30T00:00:55.248-07:00The script above returns mainly the corrupted purc...The script above returns mainly the corrupted purchase receipt layers, further correction needs consideration for each of the records retrieved to determine what's the best method for resolution.<br />In this essence, I would not go with the macro automation suggestion as inventory corruption should not be a usual issue. If you frequently have issues with inventory, then you might need to find the root causes of the problem.Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-30229562229373323382014-04-29T07:42:48.306-07:002014-04-29T07:42:48.306-07:00Thanks for the script, I believe I can use it to h...Thanks for the script, I believe I can use it to help find corruption issues, but my next step is automating inventory reconcile (so it can run during off peak hours).<br /><br />The only solution I have come up with is SQL writing to a text file (which is in the form of an Inventory Reconcile macro); then adding a task to launch GP with the macro during off peak hours. Do you have any other solutions regarding possible Inventory Reconcile automation? ThanksGradyhttps://www.blogger.com/profile/11387261717180552174noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-48886944005014683012013-11-16T22:38:14.754-08:002013-11-16T22:38:14.754-08:00Those three records are corrupted cost layers. The...Those three records are corrupted cost layers. The first step to get them corrected is to run the Inventory Reconciliation for each of the items above solely. Let me know what's the resultMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-66109148895352212792013-11-15T12:49:52.110-08:002013-11-15T12:49:52.110-08:00Thanks for the post Mahmoud. I ran the above scrip...Thanks for the post Mahmoud. I ran the above scrip and 3 records pulled up. Whats next?Anonymoushttps://www.blogger.com/profile/02047564333605222847noreply@blogger.com