Mahmoud Al Saadi – Dynamics GP MVP!!

 

I am proud to inform you that my colleague “Mahmoud M. Al Saadi” is now Dynamics GP MVP!

Well deserved and well expected!

---

Regards,

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

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

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

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

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

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!

7. Viola! Enjoy the below result

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

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

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

Dynamics GP Community is under attack!

It seems our community is under spam attack! It is getting spammed by few LOVE Specialists! I would kindly ask for users who has outstanding questions to “repost” their questions once Microsoft folks resolves this attack!

I feel like CAPTCHA will be added soon to the community to avoid such spammers and also to annoy users!

---

Regards,

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

MVP for another year!

Today I received a mail from Microsoft informing me that I have been awarded the MVP for the sixth successive year!

Nothing else to be said, thank you Microsoft for considering my community contributions!

---

Regards,

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

Dynamics Innovations - Careers Opportunity

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.

Opening #1 – Microsoft Dynamics CRM Expert:

We are looking for a highly effective Dynamics CRM Consultant to join our team full-time. This person will utilize best practices and methodologies to design, customize, integrate, implement and/or upgrade Microsoft Dynamics CRM and associated solutions for our clients. This consultant will work extensively with internal teams, clients, and vendors throughout the project, providing subject matter expertise and hands-on implementation experience. Consultants will also play a lead role for smaller clients and projects. This consultant must have strong written and oral communication skills.

Requirements and Qualifications

• 3-5 years of development experience, with at least 2 in Dynamics CRM versions 2011 or 2013 required.
• Must have excellent communication and interpersonal skills
• Microsoft certifications preferred
• Consulting experience preferred
• Ability to independently manage individual time and tasks.
• Complete project tasks as assigned, on time and budget
• Ability to quickly adapt to new requirements and changing situations.
• Professional and clear working manner onsite with clients.
• Technical experience with:
  • ASP.Net, C#, VB.Net
  • Microsoft SQL server, including SSRS and SSIS
  • Data Mining, T-SQL, Views, Stored Procedures, Database Design
  • HTML/DHTML/JavaScript/JQuery/VBScript/CSS
  • XML/XSL/Web Services

If you feel you are qualified to fulfill this position, please send an e-mail with the following format:

Subject : DI20140001: Dynamics CRM Consultant

To : careers@di.jo

 

Opening #2 – Microsoft Dynamics GP Support Specialist:

We are looking for a highly effective Dynamics GP Support Specialist to join our team full-time. This person will respond to and resolve support requests from customers, perform contracted maintenance and system management tasks, and identify and route consulting and development requests to the appropriate departments. This specialist must have very strong written and oral communication skills, be highly organized, and capable of multitasking and managing projects.

For sure due to the nature of our business, the role of position might be changed to Dynamics GP new implementations and therefore we are looking for resources who are capable to implement the product from the first day.

Requirements and Qualifications

• Respond to support requests within the contracted response time.
• Track and manage open cases to resolution.
• Install and configure GP and related products for end users.
• Troubleshoot issues in GP, FRx, Management Reporter, Integration Manager, Business Portal, and ISV products.
• Manage support tickets for ISV products
• Gather client requirements and document functional specifications
• Perform system testing and end user client training
• Troubleshoot and support Microsoft enterprise technologies
• Complete project tasks as assigned, on time and budget
• Provide client status updates to project manager and clients on a regular basis
• Receptive to mentoring

Qualifications

• 3-6 years working with Microsoft Dynamics GP in a consulting capacity, with at least 2 year experience with GP 2010 preferred.
• Demonstrated understanding of core Financials, POP, SOP, and Manufacturing is a plus
• Demonstrated understanding of Business Portal and requisition management
• Demonstrated understanding of ISVs preferred
• Ability to define, create and complete project deliverables with minimal guidance.
• Ability to independently manage individual time and tasks
• Ability to quickly adapt to new requirements and changing situations
• Exhibits professionalism at all times
• Microsoft Sure Step methodology certification and experience preferred
• Dynamics GP certification and experience preferred

Travel
Support coverage is primarily by telephone and email, using remote support tools. Travel may be required to a customer’s sites, we pay good per-diem!

If you feel you are qualified to fulfill this position, please send an e-mail with the following format:

Subject : DI20140001: Dynamics GP Support Specialist 

To : careers@di.jo

 

Company Overview

Dynamics Innovations Co. Is the top seller, BEST team of consultants and the leading Microsoft Dynamics GP gold certified partner in Jordan.

It was founded mainly to bridge the gap in the daily haphazardly management practices by providing personalized business solutions based on a solid experience and computerization the functionalities of the business organization departments.

Why Work for Us

Software Answers continually seeks to hire talented individuals to join our growing company. We’re proud of our high-quality Microsoft products, and look for the brightest, hard-working, most innovative individuals who share our commitment to our values, to our products and to our school district customers. We offer exceptional career opportunities and are a growth-oriented company.

Our greatest asset is our people, and we’re proud that our employees are some of the most intelligent, innovative talents in Jordan. We offer an open, friendly culture, where working hard and producing high quality work is rewarded, and personal development is encouraged. Our work environment is fast-paced – yet relaxed and at the same time exciting! Collaboration and innovation is a staple at Software Answers! The team work and camaraderie makes it exciting to come to work every day!

Number of Employees: 14 - 25

Weekends: Friday & Saturday

Lunch Break: We call it "Gaming" hour any time during the day in the gaming center of the company.

Working Hours: 09:00 AM - 06:00 PM

How do we look like:

Fell the Management Accounting power with ERP

Hello Guys,

I am joining Emad Al Faris from Microsoft in presenting a couple of sessions for JAMA (Jordanian Association for Management Accountants), under the subjects of:

1. Get to know ERP solutions – by Emad Al Faris

2. Fell the Management Accounting power with ERP

Everyone is welcome to join! Below the session brochure:

http://di.jo/files/erp.pdf

---

Regards,

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

Exchange Rates Feed

Few days back I got mails from many customers reporting that the exchange rates feed stopped working due to an error with the host, the tool was linked to a free exchange rates provider source and therefore it is unsupported.

Yesterday Mark Polino gave me a great idea to pull sources from YAHOO or GOOGLE and ignore the source we are using, and due to the large base of customers currently using this product I have redeveloped the product to count on more reliable source by readying from YAHOO which I believe will not go down for long time!

YAHOO API provides the rates over a methodology that does not work with the product, therefore I had to “find/amend” a web-service that reads from YAHOO and send results back to the application and the web-service is currently hosted at our web host, I know that the host is not reliable as YAHOO but at least we can get rid of issues we used to face and minimize the downtime as it became controllable.

To get the updated package, please drop me a mail and I will send it immediately!

---

Regards,

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

Moving from Dynamics GP to another ERP?

Are you looking to move from GP to another ERP like AX for example? I would extremely encourage you to read the following article by Martin in the eOne blog, the guy is collecting too many useful reasons to think twice before making this change, take a look into his article below:

http://eonesolutions.blogspot.com/2013/06/we-switched-from-gp-to.html

---

Regards,

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

LinkedIn

As many of you might notice that Linked In is celebrating their 200,000,000 users and started sending thanks for people who help spreading their name! They have ranked their users per the the viewing of their profile, so you either be one of the top 1% most viewer profiles, 5% or 10%.

I made the 5% List!

Regards,

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

Dynamics GP 2013 Demo Image

Yes it has been released, Microsoft team is doing everything fast in relation to GP 2013! take a look into the following article:

http://blogs.msdn.com/b/gp/archive/2013/01/15/where-s-the-demo-image-here-today.aspx

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

Analytical Account Posting Setup - Breaking the Hidden Secrets!!

Yesterday one of my customers reported an issue that the analytical accounting report is not being printed after the “General Posting Journal” upon posting a GL Transaction.

First thing came to my mind that this report has been unmarked in “Posting Setup” then in moment I realized that the Posting Setup does not contains anything for AA!!

It has been said in the analytical accounting installation manual that YOU MUST CONFIGURE YOU POSTING SETUP BEFORE ACTIVATING THE PRODUCT:

Setting up posting options for Analytical Accounting
Once you’ve installed Analytical Accounting for your company, you must set up
the appropriate posting options for Analytical Accounting in the Microsoft
Dynamics GP Posting Setup window. Be sure that you’ve completed this task before
you activate Analytical Accounting.

In order to collect analytical information for an account, the account must be linked
to an account class. Analytical Accounting does not support posting in summary.

So how to adjust this? Where can I find the posting setup for AA and how to configure my reports?

An hour of profiler trace returned what does GP actually do to load report, specially after activating the “Allow Transactions Posting” option and getting the error below on the report generation:

“Unable to obtain posting destination record.”

I my trace, I noticed that GP is running the following query to get report printed to the appropriate destination:

exec TWO.dbo.zDP_SY02200SS_1 2,'General Entry','General Posting Journal'

This script returned the following results:

Then I saw the following command which returned the following result:

exec TWO.dbo.zDP_SY02200SS_1 2,'General Entry','3180rpt_8'

At this moment I realized that this “3180rpt_8” report is being called without being exist in posting setup table and that’s why I used to get the above message and being able to get the report printed.

Resolution:

I just added the report row into SY02200 table and rerun the posting! That worked like a charm!

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

Error Saving Cashbook Management Transaction

This morning I been working on a wired case with Cashbook Management Module, the case was many error messages shown up upon saving the payment line:

First error was:

An error occurred executing SQL statements.

Then: GPS Error: 58

Then: SQL Error: 8114 Microsoft SQL Server Native Client 10.0 SQL Server Error converting data type varchar to datetime.

Then: ODBC Error: 37000

I felt like I am guilty! And thought that everything will be missed up after clicking tons of OK’s, then I decided to move on and look for the reasons behind this miss.

Running SQL Profiler Trace identified the query that been causing this error below:

Finally I noticed that the time attached to the query is ‘12:00:00 ص’ instead of ‘12:00:00 AM’

I replaced Arabic character in my time format from Arabic to English and it worked like a charm!!!

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

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

Working with Customers remotely

Many of us support customers remotely to save time and avoid any unnecessary costs, some customers can afford a remote connection with high technology to make the helpdesk support engineer life easier, however others are not!

To workaround this we used to use http://www.TeamViewer.com before, but after realizing the cost of the product that is around 800$ we have switched to http://www.AMMYY.com, it is a simple remote desktop sharing application that works perfectly without the need to perform any complicated installations and cost is affordable (around 30$!).

We do support our own accounting department who are in the same building but different floor remotely!

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

Dynamics GP Excel Paste – New Features has been Added!

Following to the requests we are getting from many users, we have added the below functionalities the the product:

Move rows up and down

You can now add your rows and then use arrows to move your record up and down:

Direct Grid Modifications

You can now perform modifications to the product by modifying the grid directly and then click on “Save Grid Modifications” so if you missed up with Excel Column Index for example you can simple readjust the sequence and save:

Download Templates

Few days back we have released the ability to paste the setup directly to the tool, but found this a little bit hard for end users to copy tasks one by one, therefore we have added a new functionality to download templates from the internet directly to your database:

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

Pricing for Microsoft Dynamics GP 2013 has been changed!

 

Pam over Developing for Microsoft Dynamics GP published an article about the changes on Dynamics GP 2013 Pricelist, take a look into his article below:

http://blogs.msdn.com/b/gp/archive/2012/07/11/napkin-pricing.aspx

As per the published article at the partner source, prices are expected to be launched in August 1, 2012

“Microsoft Dynamics GP 2013 Draft Price List Coming August 1, 2012”

Review the article below:

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID=%7b504666FB-DFE2-43CF-A576-E8DFFCE9DBE7%7d&NRORIGINALURL=%2fpartnersource%2fpartneressentials%2flicensingpolicies%2fperpetual-licensing%3fr%3d13%26l%3d11&NRCACHEHINT=Guest&l=11&r=13

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

Dynamics GP Excel Paste Now on Microsoft Pinpoint

 

The tool was approved for publishing yesterday, you can now find it by searching the applications directory:

http://pinpoint.microsoft.com/en-jo/applications/microsoft-dynamics-gp-excel-paste-12884944257/reviews

I expect a small review from you all to support the tool

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

Microsoft Dynamics GP Excel Paste is now Online

 

Production version of Microsoft Dynamics GP Excel Paste is now released and the development team has updated the website to integrate PayPal!

Download Fabrikam copy now or purchase your company version now from the below link:

http://www.dynamicsinnovations.com/GPExcelPaste.aspx

Below is the pricing table for the tool:

Core Financial Modules (GL, CM, DTA)	350$
Accounts Payables and Receivables (AR, AP)	300$
Sales Order Processing (SOP)	400$
Purchase Order Processing (POP, POR, POE)	400$
Inventory Control (IV, IVC)	300$
Payroll (UPR)	300$
Full Package – All Modules	1,300 $

Enjoy!

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

Mismatched Inventory Quantities

 

Sometime you face difficulties in your inventories where your quantities does not match between applications forms, for example the on hand quantity does not match the historical stock status report or the item stock inquiry, and this is really annoying as the inventory reconciliation utility does not fix this and the resolution for this is a nightmare.

Reason behind such an issue might be a packets loss during the transaction posting where the system inserted the transactions in some tables and did not insert into the other, for instance a normal inventory transaction posting affect IV00102 table to adjust quantity, insert records into IV30300 for history and affect IV10200 and IV10201, all these tables must have the same quantity in normal cases, but in some cases you might have differences.

To fix this issue you will need to follow how Dynamics GP works, as a start we know that the reconciliation utility for the inventory items reconciles the quantity of IV00102 based on the difference between Quantity Received and Quantity Sold of IV10200 table, therefore after performing “Reconcile” for your inventories you can be sure that IV00102 is matched to IV10200.

Now the challenge is how to reconcile IV30300 to IV10200, first of all you will need to identify differences, I have created the below script that generate differences in quantity for all your items per each site between IV10200 and IV30300:

SELECT ITEMNMBR                                       AS ITEMNUMBER, 
       LOCNCODE                                       AS LOCATIONCODE, 
       Sum(TRXQTY * QTYBSUOM)                         AS QTYIV30300, 
       (SELECT Sum(QTYRECVD - QTYSOLD) FROM IV10200 WHERE  IV10200.ITEMNMBR = IV30300MODIFIED.ITEMNMBR AND TRXLOCTN = IV30300MODIFIED.LOCNCODE) AS QTYIV10200, 
       Sum(TRXQTY * QTYBSUOM) - (SELECT Sum(QTYRECVD - QTYSOLD) FROM   IV10200 WHERE  IV10200.ITEMNMBR = IV30300MODIFIED.ITEMNMBR AND TRXLOCTN = IV30300MODIFIED.LOCNCODE) AS DIFF

FROM   (
--Correct IV30300 To Include Transfers
SELECT     TRXSORCE, DOCTYPE, DOCNUMBR, DOCDATE, HSTMODUL, CUSTNMBR, ITEMNMBR, UOFM, TRXQTY, UNITCOST, EXTDCOST, 
                      TRXLOCTN AS LOCNCODE, QTYBSUOM, TRFQTYTY, TRTQTYTY
FROM         dbo.IV30300 WHERE     (DOCTYPE <> 3)
UNION ALL
SELECT     TRXSORCE, DOCTYPE, DOCNUMBR, DOCDATE, HSTMODUL, CUSTNMBR, ITEMNMBR, UOFM, TRXQTY * - 1 AS Expr1, UNITCOST, EXTDCOST, 
                      TRXLOCTN AS LOCNCODE, QTYBSUOM, TRFQTYTY, TRTQTYTY
FROM         dbo.IV30300 WHERE     (DOCTYPE = 3)
UNION ALL
SELECT     TRXSORCE, DOCTYPE, DOCNUMBR, DOCDATE, HSTMODUL, CUSTNMBR, ITEMNMBR, UOFM, TRXQTY, UNITCOST, EXTDCOST, 
                      TRNSTLOC AS LOCNCODE, QTYBSUOM, TRFQTYTY, TRTQTYTY
FROM         dbo.IV30300 WHERE     (DOCTYPE = 3)
) AS  IV30300MODIFIED
WHERE  IV30300MODIFIED.ITEMNMBR IN 

--Select Inventory Items with Type "Sales Invetory" Only
(SELECT ITEMNMBR FROM IV00101 WHERE (ITEMTYPE = 1) )

GROUP  BY ITEMNMBR, 
          LOCNCODE 

HAVING
Sum(TRXQTY * QTYBSUOM) <> (SELECT Sum(QTYRECVD - QTYSOLD) FROM IV10200 WHERE  IV10200.ITEMNMBR = IV30300MODIFIED.ITEMNMBR AND TRXLOCTN = IV30300MODIFIED.LOCNCODE)

For the time being you had a list of variances, you will need to identify what figures are really matches your physical, if it was the IV30300, then you will need to create an adjustment using Inventory Transaction Entry to correct IV10200 to match IV30300 and then delete the record from the IV30300, by this the IV10200 will be affected and IV30300 will not. Otherwise if the IV10200 is correct and the issue is in IV30300 then you will need to create a database adjustment in IV30300 to correct the difference and match your IV30300 to the IV10200.

I know that this is not an easy process to be done but I can assure you that above steps can save you several weeks of researches specially if your inventories are loaded with items.

Hope that this helps.

---

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

Microsoft Dynamics Most Influential People Analysis

 

Doug Pitcher’s has released his countable and actual list of OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2012!

The list is awesome, he used transparent and unbiased methods to nominate and elect for people (for sure he been a little biased with himself! But as the list belongs to his blog then he can do whatever he needs as what others do!).

Personally I liked the idea of having list of most influential people over the Dynamics Community but the questionable part is the “votes” that would value the level of influence you have over the product you support, as what have been introduced in DynamicsWorld’s list, but following everyone else I been nominated and encouraged my followers to vote for me for the last three rounds of votes and unfortunately this round I didn’t make it to the list.

Following the selection criteria of DynamicsWorld’s list which was quoted from the site:

We base our selections on a number of criteria including: Number of nominations received; Number of Microsoft Dynamics employees employed; Number of clients your ISV/VAR has; As an end user how many user licences taken; Social Media Followers (bloggers/twitter/ linkedin) (bonuses for group owners); Number of years experience of Microsoft Dynamics; MVP Recipients; Developers of Add-Ons and new verticals; Speakers and writers about Microsoft Dynamics; Forum contributors and Number of votes received. We attempt to limit what can actually be described as a sphere of influence. The advantage that we have had in quantifying influence in Microsoft Dynamics is that we are dealing with a group of people with similar interests, and so it is possible to be able to quantify one persons influence over the group against another person’s influence.

Unfortunately the people did not publish what the weight of each role and how the roles will be measured, where I would question the transparency of the selection and therefore do not count on the list as a measurement of the product influence, I have saw people on the list with thousands of votes where I never saw a contribution for these nor I knew what does they really do! and on the other hand the list is missing many valuable resources who indeed has big influence over the blogosphere and on the product itself, I am so sure that David' Musgrave might take the first name on the list but he wasn’t counted.

My advise to everyone, do not always believe what published! Do your evaluation in person and decide who can make it in your list as Doug did!

I have did my homework and reanalyzed the results as below, check and enjoy:

 

Name	List	Votes	Made It	Rank
Rav Lal	List 7	31,340	Yes	100
Scott Mertes	List 7	29,690	Yes	60
Obed Alberto Ortiz Patiño	List 6	19,217	No	0
Andrii Butenko	List 1	14,223	Yes	74
Butenko Andrii	List 1	14,196	No	0
Paul Blott	List 6	11,552	Yes	44
Carsten Groth	List 2	4,306	No	0
Edvandro Santos	List 2	4,015	Yes	54
Amo Khan	List 1	3,503	Yes	86
Dinesh Badagandi	List 2	3,262	No	0
Mariano Gomez	List 5	2,506	Yes	66
Mohammed Rasheed	List 6	2,431	No	0
Mohamed Aamer Ala El Din	List 6	2,302	Yes	41
Carsten Olholm	List 2	1,994	Yes	32
Mitch Milam	List 6	1,783	Yes	40
Matthew Wittemann	List 6	1,781	Yes	62
Leon Tribe	List 5	1,699	Yes	45
Kirill Tatarinov	List 5	1,690	Yes	3
Marco Amoedo	List 5	1,679	Yes	46
Bob Scarborough	List 1	1,673	No	0
Joris de Gruyter	List 4	1,653	Yes	51
Rachel Carney	List 7	1,573	Yes	88
Sean Fellowes	List 7	1,547	No	0
Brandon George	List 1	1,526	Yes	19
Dhan Raj Bansal	List 2	1,433	Yes	59
Dmitry Bogolyubov	List 2	1,383	No	0
Andrew Snook	List 1	1,319	No	0
Jens Lykkegaard	List 4	1,044	Yes	72
Michael Sulz	List 6	1,041	Yes	63
Cesar Palmieri	List 2	1,022	Yes	89
Andy Vabulas	List 1	1,009	Yes	14
Mariano Arias	List 5	963	Yes	64
Frank Lee	List 3	912	Yes	73
Ian Stewart	List 3	876	No	0
Ilya Feigin	List 3	870	Yes	58
Preben Damgaard	List 7	804	Yes	7
Mark Polino	List 5	738	Yes	20
Jurgen Beck	List 4	478	Yes	75
Joel Lindstrom	List 4	475	Yes	50
Jim Glass	List 4	474	No	0
Steen Andreasen	List 8	472	No	0
Amer Atiyah	List 1	462	No	0
Andre dos Reis Santos	List 1	462	Yes	95
Ahmed ElSayed Ibrahim	List 1	440	Yes	55
Jivtesh Singh	List 4	405	No	0
Andy Hayward	List 1	390	Yes	23
Dilip Nair	List 2	380	Yes	28
Sandeep Walia	List 7	363	Yes	96
Bryn Forrest	List 1	350	Yes	99
Andries Klumpenaar	List 1	349	No	0
Joe Tews	List 4	347	Yes	49
Patrick Roth	List 6	341	No	0
Andy Hafer	List 1	305	Yes	17
Steen Waever Poulsen	List 8	284	No	0
David Musgrave	List 2	277	No	0
Nico Tissink	List 6	267	Yes	12
Adam Warby	List 1	264	Yes	1
Jehanzeb Javeed	List 4	260	Yes	48
Philippe Bouaziz	List 7	247	No	0
Frank Maier	List 3	240	Yes	76
Luciano Cunha	List 5	231	Yes	47
Soren Alexandersen	List 8	231	No	0
Kurt Hatlevik	List 5	225	No	0
Leen Zevenbergen	List 5	218	Yes	13
Kim Peterson	List 5	215	No	0
Muhammed Rafeeq	List 6	206	No	0
Kerry Rosvold	List 5	195	No	0
Ben Grech	List 1	189	Yes	81
Garth Laird	List 3	189	Yes	34
John Lowther	List 4	177	No	0
Gianmarco Salzano	List 3	174	No	0
Giridhar Raj Singh Chowhan	List 3	163	Yes	77
Brandon Kirby	List 1	156	Yes	84
Clinton Weldon	List 2	149	Yes	53
Bob McAdam	List 1	145	Yes	83
Jeff Geisler	List 4	140	No	0
Dwight Specht	List 2	139	No	0
Jose Maria Sanchez	List 4	133	No	0
Poul Kjaer	List 7	121	Yes	4
Eric Wauters	List 2	119	Yes	22
Victoria Yudin	List 8	118	Yes	93
Jack Ades	List 4	112	No	0
Cornelis Bosch	List 2	111	No	0
Ian Corcoran	List 3	109	No	0
Lionel Trigo	List 5	95	No	0
Randy Keith	List 7	93	Yes	36
Richard Whaley	List 7	89	No	0
Albert Porra	List 1	88	No	0
Mattias Englund	List 6	84	No	0
Mark LaBelle	List 5	81	No	0
Gerhard Winter	List 3	80	No	0
Dick Wenning	List 2	77	Yes	57
Troy Ensor	List 8	76	No	0
Lisa Frank	List 5	74	No	0
Christian Espinoza	List 2	72	No	0
Mohammad R Daoud	List 6	69	No	0
Christina Philips	List 2	69	No	0
Jens Bach Larsen	List 4	69	Yes	85
Chad Sogge	List 2	63	No	0
Henning Lund	List 3	62	No	0
Arvind Raman	List 1	61	No	0
Brian Ryssel Vittrup	List 1	61	No	0
Frank Vukovits	List 3	59	No	0
Julio Moreno	List 4	59	No	0
Fiona Nolan	List 3	57	Yes	87
Niels-Erik Hansen	List 6	56	No	0
Ankit Shah	List 1	56	Yes	91
Axel Kuhn	List 1	56	No	0
Erik van Hoof	List 2	56	Yes	33
Cheryl Strege	List 2	55	No	0
Craig Steere	List 2	55	No	0
David Singleton	List 2	55	Yes	82
Jose Ramirez	List 4	55	No	0
Jon Rivers	List 4	54	Yes	38
Shane Hall	List 8	54	Yes	24
Brian Ambrosius	List 1	53	No	0
David Gumpert	List 2	52	No	0
Doug Kennedy	List 2	51	Yes	9
Emir Taner	List 2	51	No	0
Eta Novak	List 2	51	No	0
Alex Vandereycken	List 1	50	Yes	29
Dan Cefaratti	List 2	50	No	0
Claus Hansen	List 2	48	Yes	10
Cristina Carcelén	List 2	48	No	0
Chantal Poisson	List 2	47	No	0
Don Currie	List 2	47	No	0
Zubin Gidwani	List 8	47	No	0
David Rosney	List 2	46	No	0
Duane Bell	List 2	46	Yes	42
Carsten Howitz	List 2	45	Yes	52
Christian Bentzen	List 2	45	No	0
Will McIntee	List 8	45	No	0
Craig Dewar	List 2	44	No	0
Daniel Sargiotto	List 2	44	No	0
Darryl Henderson	List 2	44	Yes	35
Hayley Bass	List 3	44	No	0
Paul Colella	List 6	43	No	0
Daniel Boecker	List 2	43	No	0
David Hutchinson	List 2	43	No	0
David Lastern	List 2	43	No	0
Chris Elving	List 2	42	No	0
Guobjartur Pall Guobjartsson	List 3	42	No	0
Harish Mohanbabu	List 3	42	No	0
Christian Holst-Jensen	List 2	41	No	0
Clarke Peters	List 2	41	No	0
Cochat Pierre	List 2	41	No	0
Colin Baine	List 2	41	No	0
Frank Hamelly	List 3	41	Yes	67
Gordon Tait	List 3	41	No	0
Henrik Marx Larsen	List 3	41	No	0
Josep Pagès	List 4	41	No	0
Leslie Vail	List 5	41	No	0
Christian Pedersen	List 2	39	No	0
Steven Weaver	List 8	39	Yes	79
Christopher Cameron	List 2	38	No	0
Reginald Howatson	List 7	38	No	0
Scott Isaacs	List 7	38	No	0
Michelle Spitzer	List 6	37	No	0
Damon Repton	List 2	37	No	0
Rene Gayer	List 7	37	Yes	68
Daniel Sargiotto	List 2	36	No	0
Erik Ernst	List 2	36	Yes	15
Frands Sharpe	List 3	36	No	0
Martin Olsen	List 5	36	No	0
Sebastian Waksmundzki	List 8	36	No	0
Torben Brammer	List 8	36	Yes	37
Evert Bos	List 3	35	No	0
Jimmi Jakobsen	List 4	35	Yes	70
Maria Jesus Llorente	List 5	35	No	0
Timo Lässer	List 8	35	No	0
Scott Hamilton	List 7	34	No	0
uMar Khan	List 8	34	No	0
Joakim Källebrink	List 4	33	No	0
Tony DiBenedetto	List 8	33	No	0
Michael Blatherwick	List 6	32	Yes	21
Mike Ferreira	List 6	32	No	0
Joni Vincent	List 4	32	No	0
Kelly Youells	List 5	32	No	0
Larry Lentz	List 5	32	No	0
Ryan Casey	List 7	32	No	0
Vjekoslav Babic	List 8	32	No	0
Michelle Williams	List 6	31	No	0
Pam Misialek	List 6	31	No	0
John Kleb	List 4	31	Yes	80
Steve Ballmer	List 8	31	No	0
Nick Hoban	List 6	30	No	0
Andrew Devitt	List 1	29	No	0
Joerg Stryk	List 4	29	No	0
Mark Rhodes	List 5	29	Yes	71
Mark Brummel	List 5	28	No	0
Mark Corley	List 5	28	Yes	11
Shannon McElheney DiBenedetto	List 8	28	No	0
Simon Bright	List 8	28	Yes	43
Luc van Dyck	List 5	27	Yes	31
Stefan van den Brink	List 8	27	No	0
Arijit Basu	List 1	26	Yes	97
Jeff Onesto	List 4	26	No	0
John Stulak	List 4	26	No	0
Shafiq Rehman	List 8	26	No	0
Yulia Barabanova	List 8	26	No	0
Mey MeenakshiSundaram	List 6	25	No	0
Jerry Weinstock	List 4	25	No	0
Juliano Bassetto	List 4	25	No	0
Scott Pugmire	List 7	25	No	0
Tom Galambos	List 8	25	No	0
Olga Mulvad	List 6	24	No	0
Dave Darling	List 2	24	No	0
Ian Mac Hueg	List 3	24	No	0
Jesper Dyhr	List 4	24	No	0
Steve Endow	List 8	24	No	0
Vijay Bhat	List 8	24	No	0
Michael Nielsen	List 6	23	No	0
Mike Gillis	List 6	23	Yes	2
Mohammed Feradh Zain	List 6	23	No	0
Felipe Girrado	List 3	23	Yes	25
Hal Howard	List 3	23	Yes	65
Hynek Mulhbacher	List 3	23	No	0
Jeff Edwards	List 4	23	Yes	69
Paul White	List 7	23	No	0
Sivakumar Malli	List 8	23	No	0
Sophie Sheikh	List 8	23	No	0
Stephen Holden	List 8	23	No	0
Tarek Demaiti	List 8	23	No	0
Tom Taylor	List 8	23	No	0
Natalie Karolak	List 6	22	No	0
Jacob Dall	List 4	22	No	0
Jean-Philippe Courtois	List 4	22	No	0
Jered Cady	List 4	22	No	0
Jesper Kiehn	List 4	22	No	0
Jim Bowman	List 4	22	No	0
Johnny Rosenberg	List 4	22	No	0
Jon Roskill	List 4	22	Yes	6
Kamil Sacek	List 5	22	No	0
Reuben Krippner	List 7	22	No	0
Stein Revelsby	List 8	22	No	0
Tracy Kinsey	List 8	22	No	0
Trevor Gilchrist	List 8	22	No	0
Wael Gawdat	List 8	22	No	0
Morten Bech	List 6	21	No	0
Finn Nielsen-Friis	List 3	21	No	0
Henrik Skov Pedersen	List 3	21	No	0
Ian Cowan	List 3	21	No	0
Jean-Pierre LE Cloerec	List 4	21	No	0
Jeff Wallis	List 4	21	No	0
Jens Baun	List 4	21	No	0
John Boehm	List 4	21	No	0
Julian Bacon	List 4	21	No	0
Sameer Chachra	List 7	21	No	0
Sandeep Singla	List 7	21	No	0
Steve Bredall	List 8	21	No	0
Steve Farr	List 8	21	No	0
Stian Stabell	List 8	21	No	0
Svend Birk-Hansen	List 8	21	No	0
Thomas Blak	List 8	21	No	0
Thomas Olofsson	List 8	21	No	0
Torben Wind	List 8	21	No	0
Valter Braghin	List 8	21	No	0
Wolfgang Rieger	List 8	21	No	0
Yaniv Herling	List 8	21	No	0
Mitesh Gandhi	List 6	20	No	0
Obie Kokich	List 6	20	No	0
Anya Ciecierski	List 1	20	Yes	90
Eyjólfur Eyjólfsson	List 3	20	No	0
Faizal Jivraj	List 3	20	No	0
Filippo Lombardo	List 3	20	No	0
Frank Ziccarell	List 3	20	No	0
Harry Ruiz	List 3	20	No	0
Henrik Aaen	List 3	20	No	0
Henrik Toftum	List 3	20	No	0
Iain Wright	List 3	20	No	0
Ian Sefton	List 3	20	No	0
Jeffrey Goldstein	List 4	20	No	0
Jesper Balser	List 4	20	Yes	8
Joe Tatarian	List 4	20	No	0
John Pavin	List 4	20	No	0
Sean Colohan	List 7	20	No	0
Sheldon Kralstein	List 8	20	No	0
Tomer Sagie	List 8	20	No	0
Toni Savage	List 8	20	No	0
Wim Jansen	List 8	20	No	0
Michael Griffiths	List 6	19	No	0
Michael Johnson	List 6	19	No	0
Munir Remahl	List 6	19	No	0
Nico Debeuckelaere	List 6	19	No	0
Onur Namli	List 6	19	No	0
Federico Favero	List 3	19	No	0
Frank Jensen	List 3	19	No	0
Fred Studer	List 3	19	Yes	5
Guus Krabbenborg	List 3	19	No	0
Henrik Jaeger	List 3	19	No	0
Jason Baldwin	List 4	19	No	0
Jason Ferguson	List 4	19	No	0
Jeff Hall	List 4	19	No	0
Jeff Lee	List 4	19	No	0
Jeff Rudolph	List 4	19	No	0
Kapil Khanna	List 5	19	No	0
Luc van Vugt	List 5	19	No	0
Raghunathan Jayaraman	List 7	19	No	0
Ronald Haantjes	List 7	19	No	0
Satya Narayana	List 7	19	No	0
Solange Triplett	List 8	19	No	0
Steven Biesterbos	List 8	19	No	0
Tommy Larsen	List 8	19	No	0
Michal Kupczyk	List 6	18	No	0
Palle Arentoft	List 6	18	No	0
Carolyn Blaylock	List 1	18	No	0
Greg Kaupp	List 3	18	No	0
Hans Veldman	List 3	18	No	0
Heine Krog Iversen	List 3	18	Yes	92
Henrik Bergholt	List 3	18	No	0
Henrik Helgesen	List 3	18	No	0
Hong Liu	List 3	18	No	0
Joseph Longo	List 4	18	No	0
Martin Drab	List 5	18	No	0
Richard Bross	List 7	18	No	0
Matt Woodhouse	List 6	17	No	0
Michael Gaardboe	List 6	17	No	0
Michael Medsker	List 6	17	No	0
Mikkel Poulsen	List 6	17	No	0
Morten Oxfeldt	List 6	17	No	0
Murali Ponnada	List 6	17	No	0
Nathan Benelli	List 6	17	No	0
Nobuko Lima	List 6	17	No	0
Nurul Kabir	List 6	17	No	0
Allison Watson	List 1	17	Yes	16
Anne Stanton	List 1	17	No	0
Henrik Kristiansen	List 3	17	No	0
Kenneth Kryger Gram	List 5	17	No	0
Lance Knepper	List 5	17	No	0
Manny Blits	List 5	17	No	0
Matt Bailey	List 5	17	No	0
Per Mogensen	List 7	17	Yes	94
Ricardo Nunes	List 7	17	No	0
Richard Bessant	List 7	17	No	0
Richard Hines	List 7	17	No	0
Richard St Clair Quentin	List 7	17	No	0
Ross Carlson	List 7	17	No	0
Sam Vaddi	List 7	17	No	0
Matthew Woodget	List 6	16	No	0
Maurice Ghosn	List 6	16	No	0
Mike Rogers	List 6	16	No	0
Alper Tekin	List 1	16	Yes	30
Ash Sharma	List 1	16	No	0
Graham Hill	List 3	16	No	0
Kees Hertogh	List 5	16	No	0
Keith Dunkinson	List 5	16	No	0
Kevin Turner	List 5	16	No	0
Linda Rose	List 5	16	No	0
Philip Stride	List 7	16	No	0
Prabh Updesh Singh	List 7	16	No	0
Rajdeep Tiwari	List 7	16	No	0
Rich Carr	List 7	16	No	0
Richard Covington	List 7	16	No	0
Robert Bertell	List 7	16	No	0
Ron Hanson	List 7	16	No	0
Russell Smith	List 7	16	Yes	26
Matthew Ha	List 6	15	No	0
Aad van der Velden	List 1	15	No	0
Alex Chow	List 1	15	No	0
Andrew Bibby	List 1	15	No	0
Andy Hill	List 1	15	No	0
Brad Wilson	List 1	15	No	0
Girish Raja	List 3	15	No	0
Karine Allouche Salanon	List 5	15	No	0
Katrin Smuikat	List 5	15	No	0
Philippe Jacobsen	List 7	15	No	0
Roman Ganopolskyi	List 7	15	No	0
Ron Draganowski	List 7	15	No	0
Abinsam Kottikal	List 1	14	No	0
Ben Corwin	List 1	14	No	0
Brad Dennison	List 1	14	No	0
Brian Stenzel	List 1	14	No	0
Kenneth Frostholm Olesen	List 5	14	No	0
Maanish Roy	List 5	14	No	0
Marianne Lindhard Moe	List 5	14	No	0
Pavel Hruby	List 7	14	No	0
Peter Hallgren Bünger	List 7	14	No	0
Piers Thompson	List 7	14	No	0
Adriana Di Vito	List 1	13	Yes	98
Alastair Thomas	List 1	13	No	0
Amrit Malhotra	List 1	13	No	0
Brent Twist	List 1	13	No	0
Brian Gailica	List 1	13	No	0
Carolinne Baltazar	List 1	13	No	0
Keith Pittaway	List 5	13	No	0
Klaus Holse Andersen	List 5	13	No	0
LaShonda Anderson Williams	List 5	13	No	0
Lindy Antonelli	List 5	13	No	0
Louis Veilleux	List 5	13	No	0
Luis Mourão	List 5	13	No	0
Paulo Ferreira	List 7	13	No	0
Pernille Whited	List 7	13	No	0
Peter Braun	List 7	13	No	0
Peter Waldron	List 7	13	No	0
Anders Jönsson	List 1	12	No	0
Brian Ocheltree	List 1	12	Yes	78
Kent Tranberg Pedersen	List 5	12	No	0
Laura Robinson	List 5	12	No	0
Lee Durrant	List 5	12	No	0
Nick Meredith	List 6	9	No	0
Jussi Kestilä	List 5	9	No	0
401 Nominees	8 Lists	195,836 Votes!!	95 Winners!

I used every single piece of my mind to try to find a reasonable link between votes and results with no luck, maybe one of the community has a bigger mind can help simplify the calculation!

---

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