tag:blogger.com,1999:blog-3160669066424815487.post7236521213452485673..comments2024-03-28T02:06:02.629-07:00Comments on Dynamics GP Essentials: HITB Essentials Series – HITB Reset Tool DeploymentMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-3160669066424815487.post-33466047285676495682018-11-20T00:25:58.925-08:002018-11-20T00:25:58.925-08:00Hi Mahmoud
Hope you can help. I ran the IV Reset ...Hi Mahmoud<br /><br />Hope you can help. I ran the IV Reset Tool on GP2015R2 and when I was done, the HITB report was showing double what it was before. I can see the SEE30303 table now has all the previous entries as well as BBF entries for the Reset that I have done.<br /><br />Was I supposed to clear the SEE30303 table before I started?<br /><br />Regards<br />Riaan<br />Anonymoushttps://www.blogger.com/profile/05880991219608193197noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-24249294459017735722017-10-19T04:25:44.094-07:002017-10-19T04:25:44.094-07:00Hello Tim
Yes, there is definitely a way. This is ...Hello Tim<br />Yes, there is definitely a way. This is called "Internal Inventory Reconciliation", which requires resetting the inventory tables and ensuring that they are reconciled with the GL. <br /><br />Please feel free to contact me on my email for any further detailed explanations. <br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-47191383920702350542017-10-18T07:29:41.425-07:002017-10-18T07:29:41.425-07:00Hello, Mahmood.
We have been running inventory and...Hello, Mahmood.<br />We have been running inventory and the HITB tool was not run in the beginning because the inventory and HITB were started at the same time. over the past 4 years we have 40 items that have a gotten cost variance and some are negative costs on the HITB. Is there a way to fix these items on the HITB to match what it is in the iv10200? Can i clear out the se30300 table and run the HITB reset tool to get the HITB report in line with the IV10200? and by the way the class of items in this particular GL account ties to the HITB. negative costs included. If the HITB is in fact wrong and we have to adjust to get in line with the iv10200, will we have to make a gl entry to bring the gl to match the corrected HITB?<br /><br />thanks<br />tim<br />Tim Dhttps://www.blogger.com/profile/05503008300626582687noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-65632242292946302322017-01-20T13:40:57.861-08:002017-01-20T13:40:57.861-08:00Hello Melissa
Greetings, hope you are doing well
...Hello Melissa<br />Greetings, hope you are doing well <br />I have another approach which I usually consider in order to make sure that no adjusting entries are generated at all. Please email me on MahmoodSaadi@Live.com if you are willing to have a further in-depth discussion about your inquiry. <br /><br />Best Regards, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-48260965701158341532017-01-13T10:06:24.036-08:002017-01-13T10:06:24.036-08:00Hello, Mahmood.
We recently ran the HITB Rest Too...Hello, Mahmood.<br /><br />We recently ran the HITB Rest Tool resulting in over 500 pages of GL adjusting entries. Would you mind explaining how the new values are determined? Is the current cost used for each item? Does standard costing and/or current costing come into play? I am just curious how the new value was reached. <br /><br />P.S. The information you posted on error correction was very helpful as we had several pages of errors to correct as well. <br /><br />MelissaM Johnsonhttps://www.blogger.com/profile/14530598357902080932noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-74753493505681228932016-12-06T14:07:17.619-08:002016-12-06T14:07:17.619-08:00Hello Babu
I believe we have already settled this ...Hello Babu<br />I believe we have already settled this case on the mail :) <br /><br />Please never hesitate to share any further inquiries or concerns<br />Best Regards, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-32605304609757042382016-11-30T01:38:00.295-08:002016-11-30T01:38:00.295-08:00Hi Mahmoud,
Good morning and how are you doing. ...Hi Mahmoud,<br /><br />Good morning and how are you doing. I am having problem on inventory against GL so going to reset HITB on test company(copy of live) and try it out. Can you please confirm the following.<br /><br />1) copy the IVreset file to dynamics folder<br />2) HITB SQL script<br />2) run GP as admin<br /><br />follow all the steps of HITB reset and finalize.<br /><br />By doing the above the following will be available on menu in GP<br /><br />GP menu > Tools > Utilities > Inventory > HITB IV Reset Tool<br /><br />is this correct, I always get confused with this. Also will all the company this will get enabled or only the company you are login on that time. I am not very clear about this.<br /><br />Thanks,<br />Babu<br />3)Anonymoushttps://www.blogger.com/profile/00572249198421930382noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-80656693353442397532016-08-11T07:55:14.186-07:002016-08-11T07:55:14.186-07:00Hello Mahmoud,
My company has finally gotten arou...Hello Mahmoud,<br /><br />My company has finally gotten around to doing the upgrade from GP10 to 2015. I am working on doing some practice upgrades on our test server and was wondering if the offset GL account used in steps 5 and 6 is generally the same.<br /><br />Thanks for writing this helpful guide<br /><br />JustinAnonymoushttps://www.blogger.com/profile/12563479527213656558noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-17308767625231233922015-06-11T04:15:57.716-07:002015-06-11T04:15:57.716-07:00Hello Siva
Thanks for your interest in Dynamics GP...Hello Siva<br />Thanks for your interest in Dynamics GP Essentials blog,<br />In such cases, I would prefer to get the problem resolved from the roots rather than handling every single tiny error. For that, you may consider the following:<br /><br />- Consider a physical stock count for your inventory<br />- Take the system stock down to zero (Adjustment out), by offsetting an inventory offset account which will be closed when entering the beginning balances as derived from the physical stock count<br />- Reset inventory, by considering the HITB reset tool. It shall generate no journal entries since the inventory stock is zero<br />- Reconcile inventory to GL, by making sure that all your inventory GL account balances are zero<br />- Enter the inventory beginning balances as of a specific period. The variance amount between the physical stock count and the system stock count will remain in the original offset account. It should be closed either as win or loss accordingly<br /><br />Please never hesitate to share any further inquiries, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-14455542323482692302015-06-10T03:52:55.555-07:002015-06-10T03:52:55.555-07:00Hi Mahmoud,
Thank you so much for this amazing bl...Hi Mahmoud,<br /><br />Thank you so much for this amazing blog. It is always been a great support for me.<br /><br /><br />Please help me with this issue - My customer upgraded from GP 8 to GP 2013 by Jun 2014.They use average perpetual valuation and have 16K items. They did not imlement HITB after upgrade and they continued to use GP. But now they want to implement HITB. Now when we run Inventory reconcile report, it shows error for more than 30 pages.As per my analysis the most of errors in IV reconcile report is due to the duplicate RCTSEQNM in IV10200 (due to same RCTSEQNM for each "Stock in" entry before upgrade)<br /><br />I am worried how to resolve the issues. Is there any workaroud or any other solution to fix the duplicating RCTSEQNM ? <br /><br />Thanks,<br />SivaSivahttps://www.blogger.com/profile/18015470780030436271noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-32961342848792868642015-06-10T03:51:57.411-07:002015-06-10T03:51:57.411-07:00This comment has been removed by the author.Sivahttps://www.blogger.com/profile/18015470780030436271noreply@blogger.com