Mohammad R. Daoud

Sure Step 2010

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 20 Dec 2009 00:17:00 +0000

Sure Step 2010 was finally released! download your copy now.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Dynamics GP “11” (2010) Training Sessions for Partners are coming

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 23:43:00 +0000

Inside Microsoft Dynamics GP posted a new article, they are preparing for a partner training on the new features on Dynamics GP “11”, checkout the training dates and locations in this post.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

PURCH Account couldn’t be changed while receiving?!

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 23:37:00 +0000

I thought GP behaves like this from the earlier versions, but Frank in this post corrected me that this was on GP 9.0 SP3 and later versions, this change caused allot of requests from one of my clients after upgrading the GP 10.0, and the answer is below:

“This was a design change made to help with matching the value in the inventory account in the General Ledger to the value of inventory in the Inventory module.”

Checkout Frank post for more information.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

This Document has been posted – SOP Documents?!?

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 23:24:00 +0000

Vaidy been in this error and investigated the reasons and resolutions behind the issue, checkout this post in his blog.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Item Manufacturing Accounts

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 23:10:00 +0000

Another great article by WAQAS, he did deeply explain the needed accounts for items in a manufacturing firm, it really worth looking into this post if you are already running GP Manufacturing.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Mariano on the Press!!!

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 22:50:00 +0000

For those who do not really know Mariano Gomez the Dynamics GP MVP, checkout his interview with DynamicsWorld.com here, great answers Mariano, wish you all the best.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

David Musgrave and Posting from the Past

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 21:47:00 +0000

David started his series of posts from the history, this series looks interesting, I am very excited to read those posts! Checkout his list of posts here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Dynamics GP Date Tricks!!

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 19 Dec 2009 21:39:00 +0000

Alice Newsam in the Developing for Dynamics GP Blog posted a new article about date configurations in DEX.ini that allows you to change the application’s date behavior, checkout her blog post here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Skipping Documents Numbers Randomly

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 13 Dec 2009 07:04:00 +0000

Mariano posted a solution to the behavior of skipping PO number randomly, and interested to post more solutions upon request, find his post here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Combine Data from Excel with your FRx GL Report

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 13 Dec 2009 07:00:00 +0000

The subject describes the contents, yet another interesting article by Waqas, check it our here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

FRx Reporting Portal

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 13 Dec 2009 06:57:00 +0000

Intersting article by Waqas, he did cover installing FRx WebPort in details and examples, worth looking at the screenshots in this post.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Installing Service Packs on a specific GP instant

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 13 Dec 2009 06:54:00 +0000

Frank has a new interesting post on this subject, founded in knowledgebase! Find out his post here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Consultant VS Sales

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 12 Dec 2009 08:55:00 +0000

Interesting article by Martin @ eOne blog, discussing the differences between the consultant and the salesman from the client prospective, find the complete article under “Consultant Sell” subject here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Dynamics GP Receiving entry, Item line divided into two lines!?!?

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 09 Dec 2009 16:23:00 +0000

Allot of questions were posted in the newsgroup about the behavior GP act when receiving items, sometimes the receiving divide the item into two lines, one with the original item cost and quantity – 1 and the other line with quantity 1 and different cost.

This behavior occurs when you have currency or quantity variances when the decimal places are not enough to cover the whole number decimals.

Frank Hamelly did explain this behavior with examples in this post.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Dynamics GP Bloggers

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 09 Dec 2009 15:21:00 +0000

For those who’s trying to think that Mark Polino in Dynamics Accounting blog is not an active blogger! Please check the the analytics graph below in Janakiram M.P. blog:

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Yearend Closing Notes

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 09 Dec 2009 15:11:00 +0000

Christina Phillips in the THIS post covered important points needed when performing yearend closing, you all guys must read it.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Overriding Credit Limit Password

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 09 Dec 2009 09:06:00 +0000

Guys,

I found an interesting post in the newsgroup, the user wanted to override the credit limit password for predefined customers or classes using VBA, code below will run temporary runtime created macro to fill the password as required and proceed:

Private Sub ExtendedPrice_AfterLostFocus()

‘Fill you if condition here.
Set CompilerApp = CreateObject("Dynamics.Application")
Commands = ""
Commands = Commands & "local integer l_file_id; " & vbCrLf
Commands = Commands & "local string pathname; " & vbCrLf
Commands = Commands & "pathname = ""C:\CreditLimitPassword.mac""; " & vbCrLf
Commands = Commands & "l_file_id = TextFile_Open(pathname, 0, 0); " & vbCrLf

Commands = Commands & "TextFile_WriteLine(l_file_id, "" Logging file 'macro.log' ""); " & vbCrLf

Commands = Commands & "TextFile_WriteLine(l_file_id, "" NewActiveWin dictionary 'default' form DiaLog window DiaLog ""); " & vbCrLf
Commands = Commands & "TextFile_WriteLine(l_file_id, "" TypeTo field ANSWER , 'ACCESS' ""); " & vbCrLf
Commands = Commands & "TextFile_WriteLine(l_file_id, "" MoveTo field OK ""); " & vbCrLf
Commands = Commands & "TextFile_WriteLine(l_file_id, "" ClickHit field OK ""); " & vbCrLf
Commands = Commands & "TextFile_Close(l_file_id); " & vbCrLf
Commands = Commands & "if File_Probe(pathname) then " & vbCrLf
Commands = Commands & " run macro pathname; " & vbCrLf
Commands = Commands & "end if; " & vbCrLf
'Execute SanScript
CompilerError = CompilerApp.ExecuteSanscript(Commands, CompilerMessage)
If CompilerError <> 0 Then
MsgBox CompilerMessage
End If
End Sub

Hope that this helps.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Interview with Microsoft Feed

daoudm@greatpbs.com (Mohammad R. Daoud) — Tue, 08 Dec 2009 15:31:00 +0000

Guys,

Find my interview with Microsoft Feed below:

http://microsoftfeed.com/2009/meet-mohammad-r-daoud-dynamics-gp-mvp-from-jordan/

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

How to Generate Analytical Accounting Reports Using Inquiry

daoudm@greatpbs.com (Mohammad R. Daoud) — Tue, 01 Dec 2009 23:08:00 +0000

Go to “Inquiry >> Financial >> Analytical Accounting >> Distribution Query” and select “Query Maintenance”.

Click next and fill the ID and the name of the query:

Click next and select the needed columns:

Click Next and filter your data as needed, you could select any column to filter except the date which will be filtered later.

Click next and insert the order of the data sorting if you have a special sort order:

Now you are ready to filter your data based on the date or period and generate the report, just make sure you checked “Execute Query” and your report will be generated:

Next time you need to run this report, just select “Execute Existing Query” option from the first screen:

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Changing the Column Names in Smart-List

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 25 Nov 2009 21:33:00 +0000

If you normally exports data from Smart-List to excel and do not like the names of the default smart-list columns, you might need to take a look to THIS post by Mark Polino @ DynamicsAccounting blog before changing the columns headers in your excel.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Posting Transactions that has document date in unopened period.

daoudm@greatpbs.com (Mohammad R. Daoud) — Wed, 25 Nov 2009 21:02:00 +0000

First, checkout below a conversation between me and one of my clients:

Client : “We need option to void invoice recorded at a vendor account with a date in unopened period.”

Me : “Unfortunately the only available option is to open the year!”

Client : “Let us wait until year end, but the question is why would GP allow this in the beginning??”

In fact, GP allows such operation, it allows setting the Document Date to unopened period and the posting date to the current period, which logically couldn’t be correct.

The big problem right now is when trying to void this invoice, using “Void Open Payables Transactions” form, GP will not allow to have the Void Date before Document Date, neither having the Void Date in an unopened period check messages below:

Today, Frank Hamelly in one of his great tips pointed us to a “free” tool developed by the MBS team to prevent such operation, the tool is called “Document Date Verify Tool”, just contact MBS Professional Services and they will send it to you.

Summery about the tool from its documentation:

“When a document date is entered in the following windows, a check will be performed to determine if the document date is in a fiscal period. If the date does not fall within a valid fiscal period, a message will be issued and the user will not be allowed to continue until the date is in a valid period.

Payables Transaction Entry

Receivables Transaction Entry

Invoice Entry PM

Manual Payment Entry

SOP Entry

IV Transaction Entry

Cash Receipts Entry

POP PO Entry

Receiving Entry

POP Invoice Entry

This customization will also do a validation if the period is closed. If the Document Date falls in a period that is closed, a message will be issued that will allow the user to correct the date or continue on leaving the date.”

Hope that helps.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Integrating Microsoft Dynamics GP With SQL Reporting Services

daoudm@greatpbs.com (Mohammad R. Daoud) — Mon, 23 Nov 2009 16:47:00 +0000

Interesting method in GP 10.0 to have customized reports developed on SQL Reporting Services launched from GP, follow steps below to complete the installation:

1. First you need to run the Reporting Services setup wizard from GP CD2:

2. After having the wizard installed, we need to define the reports and web services path in “Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Reporting Tools Setup”:

Fields need to be set as documented in Help:

Report manager URL

Enter the Report Manager URL for SQL Server Reporting Services. Report Manager is a report server administrative web page that enables you to manage (create, edit, delete) data sources.

The URL should follow this general syntax:

http://<<server>>/<<ReportsFolder>>/Pages/Folder.aspx

If you do not know this information, contact your system administrator.

Report Server URL

Enter the Report Server URL for SQL Server Reporting Services. This is the location of the reporting server site that hosts the Web Service. You specified this location when you installed SQL Server Reporting Services.

The URL should follow this general syntax:

http://<<server>>/ReportServer/reportservice.asmx

3. Go to Administration tab and find “Custom Report List”:

4. Enjoy having your reports in the list:

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Different Errors for One Reason!!!

daoudm@greatpbs.com (Mohammad R. Daoud) — Sun, 22 Nov 2009 23:10:00 +0000

Sometimes you finds your self in a very deep technical investigations looking for the cause of a very stupid error message or behavior that does not represents the actual cause of the message, such as situations below:

1. “All Call Stack in use. Cannot Start Script” When opening GL Transaction Entry From.

2. Smart-list has no objects and tree view that holds the smart-lists is empty.

https://community.dynamics.com/forums/p/25304/43005.aspx

3. Smart-lists returns no data, smart-lists are exist but no data are shown in the lists.

http://www.eggheadcafe.com/forumarchives/greatplains/Feb2006/post25875635.asp

4. On checkbook reconciliation, no data is presented on transactions preview to be reconciled.

Go to Reconcile Bank Statement>> Select your checkbook>> Click on Transactions>> No data!!

5. Smart-list exports unknown letters when exporting non-English characters to Excel.

6. Integration Manager integrates question marks “???” instead of the original non-English text upon importing any kind of transactions.

All the above point became well known behaviors to the collation conflict for non-Unicode characters, the simple solution for all the above errors is to Set the language to English under “Advanced” tab in Regional and Language options.

Hope that helps.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Smart-lists and Reminders

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 21 Nov 2009 12:11:00 +0000

Mark post a good article about creating Reminders in Microsoft Dynamics GP, checkout his post here.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com

Microsoft Dynamics GP Manufacturing for Chemicals Industry

daoudm@greatpbs.com (Mohammad R. Daoud) — Sat, 21 Nov 2009 11:36:00 +0000

Nancy Phillippi, Custom Information Services post a great article at the ERP Software Blog about Microsoft Dynamics GP Manufacturing and Chemicals Industries, checkout the article HERE.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com