Tag: sql server 2008
Yes and it’s not an April Fool post.
5 years back I have published a script that allows you to view amount in words in Arabic, what we call it “TAFQEET”, the article is published under the following link: http://mohdaoud.blogspot.com/2008/10/convert-numbers-to-arabic-words-tafqeet_5647.html I been getting many requests across the years on how to make this works for Excel and my answer was always that you cannot make it as it is an SQL based function and not a VBA. This morning I have see a comment sharing me a video that shows how to make a simple VBA script to achieve the ENGLISH amount in words and the video is below: https://www.youtube.com/watch?v=fYAxYtzBi5A Moving forward I decided to make the same for ARABIC language considering that I have a script that works on .NET does the same and all what I need to do is to make this works for Visual Basic for Applications and the result is below: 1. Download the function from the following path: http://www.di.jo/files/DI.bas If that file was viewed and not downloaded, please right click and click “Save Target AS”.
After updating the currency index field across all database, one of the users has reported that currency symbol does not match the functional currency symbol defined in the currency setup, and for some screens multiple currencies are shown as below: After looking for this I have found this in MC40000 table, the Currency ID field represents the correct functional currency but the index was referring to another currency, updating the currency index field fixed the issue. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 firstname.lastname@example.org http://www.di.jo
Recently I had an interesting project with one of my customers, they had the following environment: Server I: Dynamics GP 9 RTM with 14 active companies. SQL Server 2005 (Collation is Arabic_CI_AS)
I got a request from one of my customers to disable the flag of “Remember Company” that exists on the company login form below: I have made this using VBA, please download the code using the link below: http://di.jo/Files/RememberCompany.zip Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 email@example.com http://www.di.jo
I have a requirement in which I have to access a SQL view from within my customisation dictionary, in order to create a custom lookup for users to select a value based on an Extender form and an Extender lookup. Easiest option is to create an Extender view (which in turn creates a SQL view for us)