Tag: sql server 2008

ARABIC & ENGLISH Amount in Words for Excel

| 08/13/2014 | 0 Comments

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”.

Continue Reading

Dynamics CRM 2013 – Access Denied “SecLib::AccessCheckEx failed” – Error & Resolution #MSDynCRM

It’s been a long time since I had blogged anything out here. Partly due to working on various projects simultaneously. This post is about one CRM issue faced by one of our CRM users

Continue Reading

Currency Symbol is incorrect for some GP forms

| 06/05/2014 | 0 Comments

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 me@mohdaoud.com http://www.di.jo

Continue Reading

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

| 06/05/2014 | 0 Comments

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)

Continue Reading

Disable “Remember Company” checkbox

| 05/21/2014 | 0 Comments

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 me@mohdaoud.com http://www.di.jo

Continue Reading

Simulate DEX_ROW_ID in a SQL View Using ROW_NUMBER() – #MSDYNGP

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)

Continue Reading

Dynamics Innovations – Careers Opportunity

| 03/03/2014 | 0 Comments

I am proud to announce the availability of the following positions for talented candidates, if you feel that you are qualified to fulfill these positions, please feel free to submit your resume and we will be contacting you immediately. I would kindly ask only “ready” people to send their resumes, honestly  we cannot look into resumes without having enough qualifications, we are looking for candidates to start working on projects from day five, the first 4 days will be an orientation to get introduced to our standards and how we do business.

Continue Reading