Showing posts with label Fun. Show all posts
Showing posts with label Fun. Show all posts

Wednesday, August 13, 2014

ARABIC & ENGLISH Amount in Words for Excel

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

2. Open Excel

image

3. Hit “ALT+F11” to get into the VBA editor

4. Right click the Microsoft Excel Objects Folder and click Import File

image

5. Select the file you just downloaded “DI.bas” and close the VBA editor.

image

6. Get back to your excel and start typing “=DITAFQEET“ you will see that the function was added to your library and ready to be tested!

image

7. Viola! Enjoy the below result

image

NOTE: upon saving the EXCEL you might be getting the following message:

image

Change the “Save As Type” to “Excel Macro-Enabled Workbook”

image

You can download a ready file from the below link:

http://www.di.jo/files/DI%20Tafqeet.zip

Enjoy!


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Tuesday, April 23, 2013

The Top 100 Most Influential People in Microsoft Dynamics List for 2013

Well it is funny! First of all leave whatever you are doing and go to the following link then vote for me, we are running late and I didn’t publish about this before!

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-10/

Talking about votes, I can see many names this year specially David Musgrave who is doing great for the time being, he owns 50% of the votes till now, he is on page 4:

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-4/

For me, I did vote for the following, these are the people I know and sorry if I missed anyone:

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-3/

Charles Allen, Christina Philips

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-4/

Erik P. Ernst, David Musgrave

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-5/

Gianmarco Salzano, Frank Hamelly

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-6/

Ian Stewart

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-7/

John Lowther, Jivtesh Singh, Jon Rivers

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-9/

My favorite list! Mark Polino, Leslie Vail and the GP King Mariano Gomez! Wish you luck guys in the same list.

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-11/

Nick Hoban, Pam Misialek

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-12/

Richard Whaley

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-13/

Steve Endow

http://www.dynamicsworld.co.uk/the-top-100-most-influential-people-in-microsoft-dynamics-list-for-2013-page-14/

Tom Taylor, Victoria Yudin


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Sunday, August 12, 2012

Selecting a New Microsoft Dynamics GP Partner

I got an interesting questions from one of the Dynamics GP users out of my region, on how to select the best partner to deliver my demands, for sure my immediate reply was “Select me!”

However, not all customers will select me! And this user been looking for local partner in their area, therefore I felt that this is the best time to publish how do I select a new partner if I been a customer and how not to be blamed if the partner been not as expected.

I been through this before, where I been selected to evaluate tendering process for selecting a partner for a customer out of my region who runs GP for a while and looking to re-implement the product to follow the standards and work on the product correctly.

For partner selection, I normally analyze all the aspects carefully before recommending any partners even if I worked with them closely, just to make sure that customers fully comfortable with the recommended partner before doing the selection, normally I recommend people I know abroad and looking for local partners to follow steps below before signing the agreement with the new partner:

Major Selection Criteria:

1.      Ask for the complete list of customers, make sure to visit 3 as per your selection not the partner and randomly talk to at least 10 on phone, select users from the accounting department who works on the product and have no interest in recommending the partner, ask for partner performance in delivering support, knowledge in business and knowledge in Dynamics GP modules, plus what modules do they really implements for customers? Do they deliver the core application modules to close the project or they really providing their customers with the max of Dynamics GP features.

2.      Ask the partner to deliver a presentation on Microsoft Dynamics GP features for you, and make sure to ignore normal product modules and focus your questions on the modules that requires a real experts in the product like (Payment Document Management, Cashbook Management, Electronic Funds Transfer, Electronic Bank Reconciliation, KPIs Management, Requisitions Management, and Workflow) which will enhance the product usability in the future and will benefit your organization.

3.      Ask to meet the resource who will be handling your support and make sure to include his name in the contract if you liked his experience.

4.      Make sure that the partner you selects runs a helpdesk system with monitored response time KPI to make sure that any delays in your call be monitored and accountable.

5.     Grant added value for partner who worked on a business near to yours with other customers, this is really make a big difference.

With the above points, all your partners will get low scores, but at least you will know who gets the highest!

Other Points to Consider from the blogsphere:

  1. The partner you choose should be a "Managed Partner" for Dynamics GP by Microsoft. This assures access to local Microsoft resources and response to your needs by a team that is incented to work with you.
  2. Years in business and years of Microsoft Dynamics Experience - more is better. The average life of a Microsoft Dynamics GP partner is less than 4 years. Many partners have come and gone over the years. Many have closed their doors, sold, merged or have been acquired. Many of these players have resurfaced with new company names and new faces, leaving clients with broken partnerships and promises.
  3. Breadth of experience. Make sure partner has specialist and certified professionals for core competencies (Financial, Distribution/Manufacturing, Supply Chain, Payroll/Human Resources, CRM, etc.) around Dynamics.
  4. Partner Advantage Support. This is the highest level of support a partner can get from Microsoft for Dynamics. Your partner should have a contract with Microsoft for this level of Dynamics GP support. This provides the partner 24×7, level II one hour response times. Otherwise, 3 hour estimated response times is the norm, 8-5, level one support (less than the level of support a client can contract for).
  5. Microsoft Certified Sales Professionals. Partners with this position are allowed to provide clients with special offers on licenses and Microsoft services.
  6. Dedicated Client Account Manger (often referred to as a Customer Sales Manager, CSM, within the Microsoft Dynamics community). Partners that have CSMs value long-term relationships with customers and hold events to ensure your organization stays on top of the latest features and functionality long after go-live.
  7. Microsoft Sure Step Methodology for implementations. This methodology ensures confidence that implementations will go smoothly, be consistently replicated, and have predictable outcomes.
  8. Reasonable travel time and travel expense charges. These charges can add as much as a 50% to 100% surcharge to the effective hourly rate.
  9. Relationships with all of the Dynamics GP Independent Software Vendors (ISV) related to your implementation. Make sure your new partner has a positive previous working relationship with these vendors.

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, July 11, 2012

Auto Post for Dynamics GP Batches while GP Turned Off! Post Master Enterprise

 

I noticed an article by Steve Endow introducing a new feature added to the post master utility and I expected this to be an awesome feature, but honestly I never expected to be such a change.

Andrew Dean has finalized developing a new enhancement to their Post Master utility to be able to post batches automatically using a windows service that is always running, with the ability to drop reports using PDF into a user specific directory!

I saw this in Andrew video below, and as a developer I been sure that all such stuff is doable if GP was running, however the new ERA now is having all these features while GP closed, enjoy watching the video below:

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

Wednesday, June 20, 2012

Excel Paste for “Any Screen” in Microsoft Dynamics GP

 

Last few days, we have released a tool to paste data from Excel into Dynamics GP GL Transaction Entry form and published the tool for all users with no charge.

From that day, the development team in DI has decided to go further with this and tried to enhance the dynamicity of the tool to go beyond what we have developed and develop a tool for sale but worth payment, so end users can define the paste path and how to paste columns in Dynamics GP.

In addition they wanted to make this for all GP forms not only GL Transaction Entry, and going from there below what we have developed.

If you would like to watch this live on what we have done using excel paste for forms with scrolling windows, please take a look into the following video:

Purchase Order Excel Paste

So what if you do not have scrolling window and you want to paste from excel into “Cards”? We have included this we well! Check below video on how to paste customers:

Customer Card Excel Paste

Initially, users will need to analyze what fields need to be included in the paste operation, for example let us take the purchase order screen as an example:

image

I have picked the integration path that I need on the screen and been ready to setup my Excel Paste using the following setup screen:

image

End user will be able to define what they just analyzed using the above screen, they just select Form Name, Window Name and start selecting fields one by one.

Once finalizing the setup, copy data from an excel like the below:

image

And just paste on the purchase order screen:

image

Enjoy!!!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Saturday, June 16, 2012

Dynamics GP Journal Entry: Paste From Excel–Free Add-in

This morning, I been in my company with the team and been discussing what kind of innovations we should think of next, specially after delivering the first version of data level security for partners out of the kitchen for Quality Assurance and testing!

While reviewing articles published by the community leaders, we have noticed an article by Mark Polino discussing a product enhancement to have the ability to paste from excel into General Transaction Entry form, and we liked the idea and started the development!

Below is our outcome:

Paste from Excel

And in writing, you will need to request a DLL from Dynamics Innovations by sending a mail to me (temporary until publishing the file) you just need to click on the below link and download the tool, then place the DLLs in your AddIns folder:

http://www.di.jo/GPExcelPaste.aspx

Go to excel and create a new excel to look as the below:

image

Copy data from this excel and get back to Transaction Entry window of Dynamics GP, go to additional >> Paste From Excel, or press on CTRL + F and enjoy!

Update: While testing the tool we have noticed the below:

1. Distribution reference column is required, you will need include the column while copying even if the column was empty.

2. Tool was not accepting empty cells in credit and debit columns, it was modified to work.

3. Tool has been merged with paid version and published over the company website.

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Saturday, April 14, 2012

How to display EURO Currency symbol in Dynamics GP?

 

Looks an easy question right? Go to Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Currency >> Currency expansion button and select the € symbol!

Well not that’s easy, if you had languages other that the English or your collation for SQL is not Latin you will get the below:

image

This symbol actually represents the Euro currency symbol, select this symbol and go try to print a report, you will find the symbol there:

image

Enjoy!


Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Tuesday, April 3, 2012

MVP for another year!

 

I like that feeling when receiving the same mail from Microsoft! Informing me about the MVP award renewal.

Glad that I made it, thank you all for your support.


Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Monday, February 6, 2012

Microsoft Dynamics Salary Survey 2012

 

Banner Large

Nigel Frank International would like to invite you to complete our annual survey of global Microsoft Dynamics salaries. The survey will only take a couple of minutes to complete and your response and any personal details will be kept strictly confidential.

Complete the survey by the closing date and you will automatically be entered into our prize draw to win one of five amazing prizes:

1st Prize = Apple iPad2 16gb with Wi-Fi + 3G

2nd Prize = Microsoft Xbox 360 250gb + Kinect

3rd Prize = Kindle Keyboard with Free 3G + Wi-Fi

4th Prize = Microsoft LifeCam Studio Webcam

5th Prize = Microsoft Arc Touch Mouse

You will also receive a FREE copy of the Salary Survey report once it has been compiled.

Please click on the following link to complete the Microsoft Dynamics Salary Survey 2012:

http://survey.nigelfrank.com/en/microsoft-dynamics-salary-survey-2012.html

The survey is available in 12 languages for your convenience.


Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Wednesday, August 24, 2011

Recovered!

 

Last couple of months, I been very very very much engaged, mainly with the below:

1. Did huge enhancements to my house, it took me around 21 days to finalize.

2. Setup new offices for my Dynamics Innovations www.di.jo, it took years!

3. Upgraded 5 clients to Dynamics GP 2010 and enhanced their environment by implementing Portals, Workflows and Reporting.

4. Went a trip around the Middle East for some clients (Bahrain, Lebanon, Saudi Arabia Jeddah and Makah and finally Syria)

5. Did a big task in reconciling one of my clients inventories to General Ledger along with identifying reasons behind having such a difference which was the nightmare.

6. Answered around 9 RFP’s.

7. Did more than 20 presentations for Microsoft Dynamics GP in my home country, 3 in Lebanon and 1 presentation in Bahrain.

I feel guilty not being an active blogger for the last couple of months, but will make sure to make it up for blog follower in the upcoming days!

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Monday, July 11, 2011

Dynamics Innovations @ Dead Sea

 

We got a visit from one of our foreign customers and decided to take Thursday as a vacation day for all the company staff! We went to the Dead Sea SPA Hotel and enjoyed amazing three days of hot swimming in the hotel pools and the dead sea itself.

Just wanted to share a shot:

IMAG0322

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Friday, June 17, 2011

Time Estimation for Packages Installation

 

Sometimes I like the way packages estimates the time required to install! Today I have installed Service Pack 2 for Dynamics GP 2010 R2 Workflow and got the below message:

image

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Thursday, March 31, 2011

Votes – DynamicsWorld

 

Somehow, my name was moved from list 8 to list 1 with zero votes along with Mariano Gomez with 80 votes!?! What’s going on? Am I the only one who was not informed about resetting the counters?

Looks like http://DynamicsWorld.co.uk does not represents the actual votes for nominees.

Below is the list:

http://www.micropoll.com/a/mpview/1068215-405998

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Wednesday, March 23, 2011

Who is the Most Influential Person in Microsoft Dynamics for 2011?

 

I noticed that people of DynamicsWorld has changed the order of nominated candidates, I am now on POLL 1, below is the updated link:

http://www.micropoll.com/a/mpview/1068215-405998

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Wednesday, March 16, 2011

2011 TOP 100 MOST INFLUENTIAL MICROSOFT DYNAMICS PEOPLE

Most Influential Dynamics People is back for 2011, I am nominated this year and wants your support!

Below is the list with my name:

http://www.micropoll.com/a/mpview/1068215-403055

And below the complete list:

http://www.dynamicsworld.co.uk/2011Voting.php

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
www.mohdaoud.com

Sunday, January 9, 2011

My son Rida with Dynamics GP

He successfully finalized an implementation:

IMG_0975

He discovered a bug in the application after 3 months of going live:

IMG_0977

He’s looking deeply trying to fix it up:

IMG_0978

He finalized fixing the bug by deploying a service pack:

IMG_0979

He discovered more bugs and resolved them one by one:

IMG_0980

He get bored fixing application issues and got out of his mind:

IMG_0983

He finally decided to drop this out and found another career path:

IMG_0934

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
me@mohdaoud.com
www.mohdaoud.com

Saturday, January 1, 2011

Dynamics GP Sessions (Introduction & Developing for Dynamics GP)

microsoft-dynamics-gp I am excited to announce my sessions next Wednesday as a part of the Microsoft Community Activities in Jordan.

My friend Omar will present an introduction about Dynamics GP for newbie’s and then I will jump in and introduce how to extend Dynamics GP using available modules, we’ll talk about Extender, VS Toolkit, Modifier, VBA and finally several integration tools that used to integrate the application.


We are excited to share the sessions! People who ever heard about Dynamics GP will really enjoy the sessions and people who never will learn allot.

Click here to locate the event home page and don’t hesitate to contact me if you have any queries.

Regards,
--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
me@mohdaoud.com
www.mohdaoud.com

Monday, December 6, 2010

Mark Polino Vs. David Musgrave!?!?!?!

Its all about extracting data from Dynamics GP! Take a look into Mariano article here and you will understand!

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCT, MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
http://www.mohdaoud.com

Wednesday, July 28, 2010

Currency Exchange Rates Feed (Importer) for Microsoft Dynamics GP 10.0

Long time ago, I have developed a service that loads currency exchange rates from the internet directly into Dynamics GP, I am willing to share the tool for free if you are interested to send me your information and willing to be on my company reference list!

Worth mentioning that the current source of the rates is this free online web service that provide currency rates on daily bases, if you wish to change the source of rates, feel free to change the configuration.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Recover “Not Reset!” the System Password!?!?!?!?!?!

Well, we used to run a script to reset the system password to “NONE” when forgetting it, but now you can recover the password you forgot by following the method posted in the Key to Information and Knowledge Sharing blog, its by just getting the field out to a new report! Checkout the complete details with steps here.

Regards,
--
Mohammad R. Daoud - CTO
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85 
mohdaoud@gmail.com
mohdaoud.blogspot.com

Related Posts:

Related Posts with Thumbnails