tag:blogger.com,1999:blog-3160669066424815487.post6745574950352347653..comments2024-03-28T02:06:02.629-07:00Comments on Dynamics GP Essentials: Inventory versus GLMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-3160669066424815487.post-77757259263614087972019-07-28T05:44:11.449-07:002019-07-28T05:44:11.449-07:00Yes,
You need to run the inventory reset tool in ...Yes, <br />You need to run the inventory reset tool in order to rebuild the HITB table.<br /><br />Contact me on my primary email for further assistance MahmoodSaadi@Live.com<br /><br />Best Regards, <br />Mahmoud M. ALSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-77244175254221241782019-05-02T06:49:09.626-07:002019-05-02T06:49:09.626-07:00any suggestions if I don't have SE30300 turned...any suggestions if I don't have SE30300 turned on?Johnhttps://www.blogger.com/profile/12861745173214819957noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-77851429013464634692015-04-23T09:34:58.916-07:002015-04-23T09:34:58.916-07:00Thanks AgainThanks AgainAnonymoushttps://www.blogger.com/profile/11360035469922998858noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-2659445727301981862015-04-21T13:09:05.376-07:002015-04-21T13:09:05.376-07:00Hello again,
I greatly appreciate having you as a...Hello again, <br />I greatly appreciate having you as a follower, <br />As for your question, apparently you have not filled in the "account index" at the declare statement <br /><br />DECLARE @AccountIndex NVARCHAR(MAX)<br />SET @AccountIndex = 'Fill in Account Index'<br /><br />You will have to replace the (Fill in Account Index) by the inventory account index that you want to reconcile. To get the account index, consider checking the GL00100 or GL00105 as it includes an account index for every single account. In this essence, suppose the account index is (43), you will have to include it within the code above as follows:<br /><br />DECLARE @AccountIndex NVARCHAR(MAX)<br />SET @AccountIndex = '43'<br /><br />Never hesitate to share any further inquiries, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-18394646857455452032015-04-21T08:29:29.506-07:002015-04-21T08:29:29.506-07:00Hello. I congratulate you again for such a wonder...Hello. I congratulate you again for such a wonderful blog. I found very interesting things and answers to several problems I 've had. I have now the followinr error<br />"Conversion failed when converting the nvarchar value 'Fill in Account Index' to data type int."<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/11360035469922998858noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-27784942567148486752014-08-26T05:40:10.183-07:002014-08-26T05:40:10.183-07:00Thanks again Mr SaadiThanks again Mr SaadiAnonymoushttps://www.blogger.com/profile/14651853898518184587noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-88522568993018203462014-05-15T04:36:38.126-07:002014-05-15T04:36:38.126-07:00Mr. Julian
The account index refers to the invento...Mr. Julian<br />The account index refers to the inventory account on which reconciliation between Inventory and General Ledger is to be retrieved by the script. <br /><br />The following query shall retrieve all the inventory account indexes:<br /><br />SELECT DISTINCT IVIVINDX AS AccountIndex,<br /> C.ACTNUMST AS InventoryAccountNumber,<br /> B.ACTDESCR AS InventoryAccountDescription<br /> FROM IV00101 AS A<br /> LEFT OUTER JOIN dbo.GL00100 AS B <br /> ON A.IVIVINDX = B.ACTINDX LEFT OUTER JOIN GL00105 AS C<br /> ON B.ACTINDX = C.ACTINDX<br /><br />Your feedback is highly appreciated, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-38728363824355139922014-05-14T13:01:18.197-07:002014-05-14T13:01:18.197-07:00Thanks for you effort Mr. Alsaadi, but I can not u...Thanks for you effort Mr. Alsaadi, but I can not understand how do you relate #AccountIndex could you please enlight to us how do you made the link.<br /><br />Thanks Anonymoushttps://www.blogger.com/profile/14651853898518184587noreply@blogger.com