Guys,
Did you know that Microsoft Dynamics GP can process up to 3.28 MILLION business transactions and 10.66 MILLION business transaction line items over an 8 hour day!
Checkout the complete article @ Microsoft Dynamics GP Official blog:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Have you ever wanted to rollup multiple accounts into one? lets say you have the following situation:
| 000-1000-00 | Expenses |
| 000-1000-01 | Finance Dept Expenses |
| 000-1000-02 | IT Dept Expenses |
| 000-1000-03 | HR Dept Expenses |
You want all the transactions on departments accounts to be accumulated into the main expenses account based on its budgets without using FRx?
Mark Polino explained how could this happen using account rollup inquiry, checkout his post below:
http://msdynamicsgp.blogspot.com/2009/07/weekly-review-account-rollup.html
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Checkout this post in Mariano blog! Really interesting!!
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Microsoft just released the GP 10.0 SP3 VPC, here are some highlights of the new Microsoft Dynamics GP 10.0 SP3 VPC or click here to visit the official Microsoft Dynamics GP Blog:
Applications Upgraded/Installed:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Patrick the Microsoft Developer Support posted a solution to inform the users that the CAPS lock is enabled, checkout his post below:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
I found an interested article in Merit Solutions blog about the announce of Microsoft discount for current Sage users!!
The promotion is comprised of an up to 50% discount on Advanced Management (AM) or Business Essential (BE) users. In addition your customers can receive a service rebate of up to a 25% discount of the Suggested List Price (SLP) to apply towards implementation costs and/or services, with a maximum amount of $25,000 USD. This offer applies to new customers migrating from Sage MAS90/200 to Microsoft Dynamics.
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
GP 4 Arab under my friend the MVP Monzer Osama leading is preparing for online session about preparing SQL views and export those views to Excel IN ARABIC.
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
As we all know GP still not released in Arabic language by Microsoft for Microsoft Dynamics GP (Great Plains), and here in our region we are getting allot of requests to have it in Arabic.
Therefore to work around this I outsourced translating all strings and messages in the application to a specialized company in this field and imported translated strings and messages into GP dictionaries, I used "Forms" and "Reports" dictionaries for the import so GP core dictionaries will not be affected and errors caused by this change will be avoided.
Arabic interfaces looks like the following:
Financial's Home Page:
Checkbook Maintenance:
Sales Transaction Entry:
Issues in this version:
1. Forms direction is not "Right to Left".
2. Fields direction is not "Right to Left", this cause an issue that the user cannot delete a part of the description as they cannot select the correct word when double clicking it, so they will have to clear the entire field.
David posted methods for flipping forms but his last step requires some work that could not be affordable right now.
Arabic version with the above criteria's is available for Sale with competitive prices, currently applicable for GP 10.0, GP 9.0 and GP 8.0, let me know if anyone interested!
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Few weeks ago I have posted a method to call GP lookup using VBA, but I have noticed that the account lookup form did not show data, so I looked into GP SDK and applied the account lookup calling through ExecuteSanScript function as shown below:
Dim GPApp As New Dynamics.Application
Dim ErrMsg As String
GPApp.CurrentProductID = 1493
Dim strCommand As String
strCommand = " local GLCOA_AccountLookupInfo LookupInfo."
strCommand = strCommand + " set 'LookupInfo:Series' to FINANCIAL. {Series}" + vbNewLine
strCommand = strCommand + " set 'LookupInfo:Sort By' to 4. {Sort By Account Number}" + vbNewLine
strCommand = strCommand + " set 'LookupInfo:Post_Acct' to POST_ACCT.{Show Posting Account}" + vbNewLine
strCommand = strCommand + " set 'LookupInfo:Post_Alloc_Acct' to POST_ALLOC_ACCT." + vbNewLine
strCommand = strCommand + " {-- Show Posting alloc Acct --}" + vbNewLine
strCommand = strCommand + " set 'LookupInfo:Active' to false. {No inactive accounts}" + vbNewLine
strCommand = strCommand + " set 'LookupInfo:Return Alias' to false. {-- Don't return Alias --}" + vbNewLine
strCommand = strCommand + " call Open of form Account_Lookup," + vbNewLine
strCommand = strCommand + " LookupInfo, 'Account Number CS' of window 'GL_Account_Maintenance' of form 'GL_Account_Maintenance', 'Account Number CS' of window 'GL_Account_Maintenance' of form 'GL_Account_Maintenance'." + vbNewLine
GPApp.ExecuteSanscript strCommand, ErrMsg
Now to get this lookup customized to your form and return the data to your field, there are two parameters need to be changed as explained below:
The primary function that will call the lookup is "call Open of form Account_Lookup" the function requires two parameters:
call Open of form Account_Lookup, "Initial Value", "Field to set the returned value in".
1. "Initial Value": this is the value that will be passed to the lookup to initiate the search, by default you might need to use your customized field instead.
2. "Field to set the returned value in": here you need to identify the field that the lookup will return the value in.
So basically replace "'Account Number CS' of window 'GL_Account_Maintenance' of form 'GL_Account_Maintenance'" with your field name and place code above in your Lookup button and the form will show up and works!
Hope that this helps.
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
We have just released a new feature to the inventory module in Microsoft Dynamics GP based on the huge requests we got in the company by factories that uses ABC (Activity Based Costing) in their process.
The tool mainly reads and maps you excel sheet that contains your items new costs and performs mass cost adjustment to all items in the selected file between two dates to balance you inventory at period end.
Its mainly developed using VBA and Modifier, and launched from the item card as shown in the image below:
Pressing the button in the item card will open the following form:
The form will allow you to select you excel file, map fields in the file to the needed columns and create cost adjustments records for each item in Tools >> Utilities >> Inventory >> Adjust Cost one by one:
For sure this tool is not free!! But its available for purchase with its source code for customizations and modifications.
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
daoudm@di.jo
http://www.di.jo/
Guys,
I found an interesting post at the Newsgroup on how to remove the GP 10.0 home page, definitely the short answer will be it cannot be removed, but if this request is a must, we must workaround it, therefore I wrote this article to modify the home page file and replace its content with single logo that represents the company logo, below sample shows the home page after the modification:
Now to have your home page looks like the above you will need to follow steps below:
1. Locate "C:\Program Files\Microsoft Dynamics\GP\Background\HomePage.xsl" and copy it to have a backup of the file.
2. Open the file using Notepad or any available editor.
3. Remove all the code inside the file and place code below instead with changing the image in the code to your company logo.
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:output method="html" indent="yes" />
<!-- 'Page' element handler -->
<xsl:template match="Page">
<br></br>
<br></br>
<br></br>
<center><img src="D:\My Documents\GPLogo.jpg" alt="Company Logo" title="Logo" /></center>
</xsl:template>
</xsl:stylesheet>
Refresh your GP home page and enjoy!
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
Guys,
Post below is good for transferring GP databases from one server to another, the author detailed the whole process:
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCT, MCBMSP, MCTS, MCBMSS
CTO
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com
Guys,
Well yes I got carious when I saw this subject @ Matt Landis blog on what it could be? Go and check by yourself, its just Great!!
https://dynamicsgptestdrive.com/console.aspx?exercise=1
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
Guys,
Please send your congratulations and best wishes to Mariano Gomez for his new year as MVP!! Personally I think he deserves more than MVP award.
Congratulations Mariano and keep the good work up.
Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/
