tag:blogger.com,1999:blog-3160669066424815487.post2154467064755443765..comments2024-03-28T02:06:02.629-07:00Comments on Dynamics GP Essentials: Historical IV Trial Balance - Per PeriodMahmoud M. AlSaadihttp://www.blogger.com/profile/07632688723943735412noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-3160669066424815487.post-31764783598948176532020-04-15T13:40:17.139-07:002020-04-15T13:40:17.139-07:00Mahmoud,
Thanks so much for this information. M...Mahmoud,<br /> Thanks so much for this information. My organization is hoping to get a look at historical data over the past 30 days. Is it possible to alter this code so that it shows 30 days, one day at a time, instead of the current year/period format? Thanks! JoelJPMotionhttps://www.blogger.com/profile/13175863706520807308noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-26510649063599605952020-04-15T13:37:18.423-07:002020-04-15T13:37:18.423-07:00This comment has been removed by the author.JPMotionhttps://www.blogger.com/profile/13175863706520807308noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-919955953559886762020-03-10T04:08:31.434-07:002020-03-10T04:08:31.434-07:00Yes, for sure.
There is another report which is ...Yes, for sure. <br /><br />There is another report which is built including the location code. <br /><br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-26598583555278670922020-03-02T12:54:03.324-08:002020-03-02T12:54:03.324-08:00Hi Mahmoud - are we able to add LOCNCODE to this? ...Hi Mahmoud - are we able to add LOCNCODE to this? Report is almost perfect. thanks, JayAnonymoushttps://www.blogger.com/profile/08172525478954022364noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-82400806001701140282018-02-25T20:22:07.752-08:002018-02-25T20:22:07.752-08:00Hello Tom
I have created another report (Historica...Hello Tom<br />I have created another report (Historical Inventory Trial Balance - per Location). It is scheduled to be published on the blog<br /><br />Please never hesitate to contact me on my email address MahmoodSaadi@Live.com, in order to provide you with the report. <br /><br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-10820124229203515292018-02-03T05:45:48.030-08:002018-02-03T05:45:48.030-08:00Thanks Alot Mr. Mahmood. How can I add column LOCN...Thanks Alot Mr. Mahmood. How can I add column LOCNCODE field of SEE030303 in the output?Tomhttps://www.blogger.com/profile/06124445654866777893noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-77119103894496785052017-06-01T05:27:56.723-07:002017-06-01T05:27:56.723-07:00Did I miss this post?Did I miss this post?GPPPPPhttps://www.blogger.com/profile/11440014649506947762noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-29762698743749791802017-03-31T17:17:47.105-07:002017-03-31T17:17:47.105-07:00By end of April, 2017.
Best Regards,
Mahmoud M. ...By end of April, 2017.<br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-20953547881983382922017-03-31T13:31:51.729-07:002017-03-31T13:31:51.729-07:00Sounds fantastic. Do you have an estimated date t...Sounds fantastic. Do you have an estimated date that you may publish it?GPPPPPhttps://www.blogger.com/profile/11440014649506947762noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-68167234892129147432017-03-09T05:03:03.050-08:002017-03-09T05:03:03.050-08:00Hello there
I have a different SQL script for HITB...Hello there<br />I have a different SQL script for HITB per location. Stay tuned as it will be published on my blog.<br /><br />Best Regards, <br />Mahmoud M. AlSaadiMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-51697014861845855052017-03-07T09:52:29.509-08:002017-03-07T09:52:29.509-08:00Whenever I add LOCNCODE to the above view it doesn...Whenever I add LOCNCODE to the above view it doesn't generate the correct totals. Can you add LOCNCODE to your view?GPPPPPhttps://www.blogger.com/profile/11440014649506947762noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-15040483283117706472015-06-09T05:18:24.045-07:002015-06-09T05:18:24.045-07:00Hi ,
In Historical aged trial balance I am not abl...Hi ,<br />In Historical aged trial balance I am not able to untick the items with zero quantity as on date. The field is not enabled. Can you please help.Unknownhttps://www.blogger.com/profile/02618829196040598266noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-60097992837489593802015-05-29T12:31:39.449-07:002015-05-29T12:31:39.449-07:00Hello Mr Mahmood
I'm using this SQL to consul...Hello Mr Mahmood<br /><br />I'm using this SQL to consult historical inventory balance., but I need to know the account number. How I can include it? Thanks<br /><br />DECLARE @ASOFDATE DATETIME<br />SET @ASOFDATE = '2014-02-01'<br /> <br />SELECT<br />ITEMNMBR AS [Item Number],<br />TRXLOCTN AS [Location],<br />SUM(Quantity) AS Quantity,<br />SUM([Extended Cost]) AS [Total Cost]<br /> <br />FROM<br /> <br />(SELECT ITEMNMBR,<br /> <br />(dbo.IV10200.QTYRECVD -<br />ISNULL((SELECT SUM(QTYSOLD) FROM IV10201<br /> WHERE SRCRCTSEQNM = IV10200.RCTSEQNM<br /> AND ITEMNMBR = IV10200.ITEMNMBR<br /> AND DOCDATE <= @ASOFDATE), 0))<br />AS [Quantity],<br /> UNITCOST *<br /> (dbo.IV10200.QTYRECVD -<br /> ISNULL((SELECT SUM(QTYSOLD) FROM IV10201<br /> WHERE SRCRCTSEQNM = IV10200.RCTSEQNM<br /> AND ITEMNMBR = IV10200.ITEMNMBR<br /> AND DOCDATE <= @ASOFDATE), 0))<br />AS [Extended Cost], <br />TRXLOCTN<br />FROM dbo.IV10200 WHERE DATERECD <@ASOFDATE) AS SOURCE<br />GROUP BY ITEMNMBR, TRXLOCTNAnonymoushttps://www.blogger.com/profile/11360035469922998858noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-10741921220295645652015-02-05T13:15:30.524-08:002015-02-05T13:15:30.524-08:00You are most welcome, You are most welcome, Mahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-26672153092027054682015-02-05T08:11:10.144-08:002015-02-05T08:11:10.144-08:00Thank you VERY much!!!Thank you VERY much!!!Alyhnahttps://www.blogger.com/profile/11923530384415166267noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-56303133092938047112014-09-17T13:10:07.867-07:002014-09-17T13:10:07.867-07:00Can you please tell me how to add to the view?
I n...Can you please tell me how to add to the view?<br />I need to show Account and Item description as well. <br /><br />Thank you!Anonymoushttps://www.blogger.com/profile/08067967947135744430noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-1018043217367627972014-09-16T15:46:07.330-07:002014-09-16T15:46:07.330-07:00Just run the script provided above on your SQL Man...Just run the script provided above on your SQL Management Studio, it will create a view named "V_HITB_Per_Period". <br />Once created, it can be reachable on the Excel sheet.<br /><br />After deploying the view above, check the script provided on http://mahmoudsaadi.blogspot.com/2014/01/hitb-per-period-cumulative-inventory.html<br />This will give you a cumulative running total for the item balanceMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-70206013688993980102014-09-16T13:56:49.007-07:002014-09-16T13:56:49.007-07:00I can get the tables in Excel. How do I create the...I can get the tables in Excel. How do I create the view?<br />Thanks!Anonymoushttps://www.blogger.com/profile/08067967947135744430noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-3733497883551780022014-09-15T04:06:04.593-07:002014-09-15T04:06:04.593-07:00It is actually a common question
On your Excel sh...It is actually a common question <br />On your Excel sheet, go to the "Data" tab, you will find a section named (Get external data), click on "From other Sources" > "From SQL Server"<br />You will be asked to enter the server name and associated authentication in order to retrieve the database objects. <br />Select the "Database", and the view created, next then finish.<br /><br />Let me know if you have any further questionsMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-43849853525965055272014-09-11T21:08:55.488-07:002014-09-11T21:08:55.488-07:00Sorry,dumb question.
How do I get the data into Ex...Sorry,dumb question.<br />How do I get the data into Excel?<br /><br />ThanksAnonymoushttps://www.blogger.com/profile/08067967947135744430noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-34892360898536511902014-08-29T09:23:46.397-07:002014-08-29T09:23:46.397-07:00@RLMcVicar you are most welcome
For the mean time,...@RLMcVicar you are most welcome<br />For the mean time, I have nothing done off-the-shelf for AP. Although, you can consider MVP Belinda method on creating a quick pivot table for AP Aging, it is quite efficient and straight to the point. <br />Check it out on <br />http://saci.com/blogs/belinda-the-gp-csi/bid/151057/AP-aging-in-Excel-thanks-to-Victoria-Yudin-in-Microsoft-Dynamics-GPMahmoud M. AlSaadihttps://www.blogger.com/profile/07632688723943735412noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-8924005491107263262014-08-27T07:16:45.615-07:002014-08-27T07:16:45.615-07:00Great input on this AR TB do you know if anyone ha...Great input on this AR TB do you know if anyone has done one for AP? if so could you point me to it? Please and thank youRLMcVicarhttps://www.blogger.com/profile/14640967967195938708noreply@blogger.comtag:blogger.com,1999:blog-3160669066424815487.post-27675554866484109752014-03-21T09:05:47.922-07:002014-03-21T09:05:47.922-07:00nice work mr mahmoudnice work mr mahmoudAnonymoushttps://www.blogger.com/profile/00333376326819208419noreply@blogger.com