tag:blogger.com,1999:blog-5285970135510371565.post3237226841070151842..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Displaying Hijri dates in Microsoft Dynamics GPMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-5285970135510371565.post-2882836187265150102014-09-09T07:20:47.071-04:002014-09-09T07:20:47.071-04:00Wow, thats amazing work bro. Innovation should be ...Wow, thats amazing work bro. Innovation should be appreciated. Thanks for sharing this blog.<br /><a href="http://www.evinciblesolutions.com/solutions/microsoft_dynamics_gp.aspx%22" rel="nofollow">Microsoft Dynamics GP </a>Anonymoushttps://www.blogger.com/profile/04857981966809027275noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-44905349492291018912013-12-21T20:34:17.861-05:002013-12-21T20:34:17.861-05:00Thanks of for your reply, reading one article a da...Thanks of for your reply, reading one article a day for your blog, missed to respond on this one. <br />me toodatehttp://www.tare5.com/convert_date.htmlnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-42145281762937924832013-09-24T09:59:31.287-04:002013-09-24T09:59:31.287-04:00Hi Mariano,
Thanks of for your reply, reading one...Hi Mariano,<br /><br />Thanks of for your reply, reading one article a day for your blog, missed to respond on this one. <br /><br />Wanted to know if we can validated the doc dates on AP transaction just to make sure if doc date entered is within the GP Fiscal periods.<br /><br />Lesslie Vail at community directed to check doc verify tools of PSTL, which suits the requirements. <br /><br />Thanks -<br />Regards<br />SanjaySanjay Kumar Rajaraohttps://www.blogger.com/profile/07922082085432934232noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-84782342964045174392013-09-18T17:39:09.500-04:002013-09-18T17:39:09.500-04:00Sanjay,
Can you provide an example of what you me...Sanjay,<br /><br />Can you provide an example of what you mean? <br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-56934347464461390512013-09-18T16:57:39.638-04:002013-09-18T16:57:39.638-04:00Hi Mariano,
Do you have any example to custom val...Hi Mariano,<br /><br />Do you have any example to custom validate date based on fiscal periods.<br /><br />Thank you<br />SanjaySanjay Kumar Rajaraohttps://www.blogger.com/profile/07922082085432934232noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-81570626098193950452010-01-21T00:39:31.754-05:002010-01-21T00:39:31.754-05:00Hamada,
Thanks for the input! I am sure there are...Hamada,<br /><br />Thanks for the input! I am sure there are a lot of "gotchas" with Hijri dates, but as you said, a first step nonetheless. The good thing is enhancements can come one you have the basic idea.<br /><br />Keep up the readership!<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-10195794448510277842010-01-20T10:50:04.829-05:002010-01-20T10:50:04.829-05:00it's a first step, you need to handle some sci...it's a first step, you need to handle some scinarios like that transactin date can't accept date not exist in the current fiscal year, so i think you need to change the schema of each windows table and adding a new field, but its ofcourse danger for new updates and service packs, call me if you want more info<br /><br />BTW, good workHamada Ashourhttps://www.blogger.com/profile/00646777355635629527noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-46915318662225903092009-09-13T15:57:27.105-04:002009-09-13T15:57:27.105-04:00Faisal,
You certainly need to create a CLR functi...Faisal,<br /><br />You certainly need to create a CLR function for this. Take a look at the following post and make sure to follow the comments too:<br /><br />http://blogs.msdn.com/vsarabic/archive/2009/02/12/sql-server-umalqura-calendar-as-a-clr-type.aspx<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-16594135750817279412009-09-08T08:10:38.518-04:002009-09-08T08:10:38.518-04:00Sorry for interrupting .... I need help.
I am wor...Sorry for interrupting .... I need help.<br /><br />I am working on an application where I would have to save English date and its equivalent Hijri date (base on Um Al Qura Calendar). I have perform search operations based on both English and Hijri dates.<br /><br />- Should I use have two columns in my table; one for English date and one for Hijri date?<br />- Should I use DateTime CLR data type for both dates or?<br /><br />I will wait your email.<br /><br />Regards<br /> <br />Faisal<br />Jeddah, Saudi ArabiaUnknownhttps://www.blogger.com/profile/13906915151679420610noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-37145061723645465502009-08-16T13:59:01.025-04:002009-08-16T13:59:01.025-04:00Hello Mariano,
Im developing a web application
sy...Hello Mariano,<br /><br />Im developing a web application<br />system that converts english date to hijiri date. So the requirements must be in javascript...can you help on this stuff :))))? Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-8084540852921700992009-02-28T13:19:00.000-05:002009-02-28T13:19:00.000-05:00SQL Server does not have direct support for Um al-...SQL Server does not have direct support for Um al-Qura calendar, which is more intended for civil events. However, there is an implementation Um al-Qura in the .NET Framework which would allow you to implement a CLR type function for SQL Server.<BR/><BR/>You can take a look at how to do this at http://blogs.msdn.com/vsarabic/archive/2009/02/12/sql-server-umalqura-calendar-as-a-clr-type.aspx<BR/><BR/>Likewise, you could create a .NET assembly which can be wrapped around a COM object to use directly in VBA.<BR/><BR/>Best regards,<BR/><BR/>MG.-<BR/>Mariano Gomez, MVP<BR/>Maximum Global Business, LLC<BR/>http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-56669513323670051742009-02-27T14:13:00.000-05:002009-02-27T14:13:00.000-05:00Mariano ... what about Um Al kura Date its more Fi...Mariano ... what about Um Al kura Date its more Fixed solary than Hijri date thats make it more required at Saudi Arabia .. can we see a post about it - and please make more explanation about VBA when it comes to be used in your post(as my favorit it Dexterity language) thank you..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-80770094415286156282009-02-24T19:42:00.000-05:002009-02-24T19:42:00.000-05:00Amazing that you could actually get me hooked enou...Amazing that you could actually get me hooked enough to read the whole post. I don't have any need for this (so far) but loved the blog. I'd keep this in your favorite posts lists for sure.Doug Pitcherhttps://www.blogger.com/profile/00561267399443561604noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-51730861495875232702009-02-20T17:39:00.000-05:002009-02-20T17:39:00.000-05:00Jivtesh,Thanks for the kind words. This is one of ...Jivtesh,<BR/><BR/>Thanks for the kind words. This is one of the posts I believe I will come to love over the years.<BR/><BR/>MG.-<BR/>Mariano Gomez, MVP<BR/>Maximum Global Business, LLC<BR/>http://www.maximumglobalbusiness.comMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-61506393977485724372009-02-20T15:49:00.000-05:002009-02-20T15:49:00.000-05:00Awesome Post, and amazing history and introduction...Awesome Post, and amazing history and introduction to go along with it! Loved learning about this. <BR/><BR/>Thanks!Jivtesh Singhhttps://www.blogger.com/profile/09314498953058276237noreply@blogger.com