Inventory not changing account to the correct site account for all transactions

A wired case was reported this morning, our customer is having several inventory accounts one for each warehouse, they wanted the system to change the account upon changing the site, which is covered in the default Dynamics GP functionality, the setup for this is explained in the following article:

https://community.dynamics.com/gp/f/32/t/157821

The customer was having the correct setup, but the system wasn’t changing the account, which is normally occurs if the target account doesn’t exist, after checking I realized that accounts were there, but the system is also not flipping the accounts.

After further investigations it turned to be missing accounts in GL00105, accounts were exist in GL00100 but not in GL00105, I ran check links for financials and everything worked as expected!

Hope that this helps.

Regards,

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

Excel to GP – GL Transactions with Analytical Accounting

I know Mahmoud M. AlSaadi very well! He is a colleague and friend, I know very well his experience in Excel and SQL, I been watching Mahmoud last few months hardly collecting his experiences to make something and expected the thing to be big, he finally worked out his master piece and it was really amazing finding such a process in Dynamics GP.

He has created some refreshable sheets on a workbook that reads data directly from your GP database, and used this to validate a default sheet that represents your new GP GL Transaction Entry! Instead of manually creating transactions with complicated Analytical Accounting information, you just fill the Excel and his tool will automatically generate the macro needed to fill transactions inside GP.

Needless to say, it is a free tool that is shared on his blog post below:

http://mahmoudsaadi.blogspot.com/2014/11/analytical-accounting-entry-excel-to.html

I would advise you watch the below video and go to the download page to get your copy:

I would say good job Mahmoud! Looking to see you with us at the MVPs board soon.

---

Regards,

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

Analytical Accounting vs. Multidimensional Analysis

In earlier Dynamics GP versions, we used to use a module called MDA to manage our accounts dimensions and reduce the size of the chart of accounts, the module is very stable and works perfectly but with limited functionalities, when the Analytical Accounting was introduced, this module was retired and was no longer enhanced by Microsoft.

Personally, I been fighting with Analytical Accounting issues for many years now, I can count free hours spent to correct journals at the database level that unjustifiably corrupted and was not linked to the correct figures, which makes it a little bit annoying.

A couple of days back I seen a “conspiracy” being prepared between GP MVPs (including me!) against the Analytical Accounting pushing hard to get the MDA module back to track and enhanced to compete the AA module.

Frank has created the Connect request and we all voted to get this done, we need your help getting this ranked to the top of the list and to be considered in the very near release:

https://connect.microsoft.com/dynamicssuggestions/feedback/details/907907/bring-mda-back-to-dynamics-gp

---

Regards,

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

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

Recently I had an interesting project with one of my customers, they had the following environment:

Server I:

• Dynamics GP 9 RTM with 14 active companies.
• SQL Server 2005 (Collation is Arabic_CI_AS).
• Windows Server 2003 & FRx

Server II:

• Dynamics GP 11 RTM with 3 active companies.
• SQL Server 2008 R2 (Collation is Latin)
• Windows Server 2008 & FRx

The customer simply wanted to upgrade to Dynamics GP 2013 SP2 and to SQL 2012, and also wanted to consolidate the databases into one single DYNAMIMCS database.

Challenges:

Now we have few challenges detailed below:

1. Dynamics GP 2013 does not support upgrading from GP 9.0
2. Dynamics GP 2013 does not support SQL 2005 and GP 9.0 does not support SQL 2012.
3. Database collation differences between companies.
4. Data stored in DYNAMICS database like currencies, users and BP objects.
5. Changes that will occur on columns like “Company ID” and “Currency Index” which will be changed due to DYNAMICS data consolidation.
6. Security migration from GP 9.0 to GP 2013.
7. FRx migration to Management Reporter.
8. Minimum downtime need to be maintained! 17 companies across multiple countries cannot stay down forever!

Resolutions:

Well we believe that nothing is impossible in the IT field, we have planned for everything and scheduled the upgrade process, below the steps we followed:

Server I:

• Took a backup for all databases.
• Upgraded from version (GP 9.00.0114) to 9.00.0371 that supports the upgrade to GP 2010 (we need GP2010 because it supports both SQL 2005 and SQL 2012!)
• Upgrade from (GP 9.00.0114) to GP 2010 (GP 11.00.2320) that supports direct upgrade to GP 2013.
• Moved upgraded databases from SQL 2005 to SQL 2012 with moving all users and configurations.
• Upgraded to GP 2013 SP2.
• Checked System stability.
• Updated Users permissions and passwords.
• Installed Dynamics GP 2013 with SP2 on all clients
• Installed Management Reporter that replaces the FRx on the server and on the clients.
• Migrated existing FRx Reports to Management Reporter
• Activated SQL Reporting Services
• Installed and activated Dynamics GP Web Client
• Started the data entry!

This operation took the first weekend!

Server II:

• Took a backup for all databases.
• Upgraded from your current version GP to the service pack that supports the upgrade to GP 2013.
• Upgraded to GP 2013 SP2.
• Checked System stability
• Created new companies on the new server
• Restored databases from old server to PROCCOSQL over newly created databases
• Update databases collation to match old server collation (I used the tool that updates the SQL database collation by dropping all functions, constraints and indexes that is collation dependence)
• Updated CURRENCY ID in all databases columns to match the newly added currencies, it was indexed as “100X” and changed to “10XX”
• Update Company ID in all databases columns to match the newly added companies.
• Add newly created companies to Management Reporter
• Activate SQL Reporting Services

This operation took the second weekend! Till now everything is working properly and this is how their GP looks like right now:

---

Regards,

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

Cards Auto Numbering for Vendors, Customers and Items – Free Addon

We at Dynamics Innovations has developed a product for Dynamics GP allows end users to control the generation of the ID for customers, vendors and items, the tool is free and  available for use immediately, just drop me a mail and I will be sending the tool for you, once you get the DLL, please follow steps below to activate the product:

1. Copy sent DLL to GP\AddIns Folder.

2. Login first time with “sa” user to generate the needed database objects.

3. Open SQL and adjust the parameters to fit your needs:

a. You need to find a table called “DI_NextNumbers”, open the table.

b. Fill the prefix you need to use, length that includes the prefix, next number you wish to use.

Go to vendor card for testing and find the additional menu, same package works for customers and items if you wish to activate:

---

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

GP 2013 - Smart List Crash when it reach 32,767 Records for Export

As many of you might notice, upon exporting huge number of records from Smart List (specifically more than 32,767 records) Smart List generates an error, this is actually a bug in GP 2013 which reflect the maximum number the integer can handle.

The good thing is that this was resolved in the newly released SP 2:

---

Regards,

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

Business Portal 6.0 for Dynamics GP 2013

It has been finally released, Business Portal 6.0 for Dynamics GP 2013, it still does not support SharePoint 2013 but it has many enhancements could be found HERE.

Business Portal 6.0 is supported with the following: Click HERE to go to the System Requirements Page.

• SharePoint Server 2010 or SharePoint Foundation 2010 only. 
• Windows Server 2008 x64 SP2 or later or Windows Server 2008 R2 SP1 or later. 
• Internet Explorer 8.0, Internet Explorer 9.0, and Internet Explorer 10.0.

*NOTE:* SharePoint 2010 is currently not supported on Windows Server 2012 until the release of SharePoint 2010 Service Pack 2 due out this summer.

Below is the direct download link:

BusinessPortal60_RTM_x64.zip

---

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 Upgrade–Customized GL Inquiry Report

Guys,

If you are planning to upgrade to GP 2013, please consider to analyze your customizations carefully as there might be some changes between the application versions, I been in a situation were we upgraded from GP 2010 R2 to GP 2013 and the customer has a customized report for GL Transaction Entry Inquiry Report, the report didn’t work properly as the core table of the Report has been changed.

This is the only thing I found so far, but I wanted to let you know that you might need to plan redoing the customizations of this report upon upgrading to GP 2013.

---

Regards,

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

Mask a Field in Dynamics GP

I got an interesting question from one of the community followers and I saw that it should be published for community, the question was a request to have a special mask for the item number field, the user wanted to have the item number automatically has Dashes “-“ for each 3 letters to look like this >> “AAA-AAA-AAA” so the user will fill only 9 “A”s and the system to automatically add the “-“ in between and below how I covered this:

1. Go to Cards>> Inventory>> Item

2. Click on Tools>> Customize>> Modify Current Window which will open the modifier and allow you to modify the screen, click on the Item Number field and go to the “Properties” panel on the right:

3. Double click on “Field” option to get the following form:

4. Click on Open to go deeper with the Item Number format Options in Data Type Definition and then click on the button next to Format:

5. The format is currently set to be one of the out of the box formats that limits the length of the string to 30 characters, we will need to create a new format:

6. Customize the format as needed, for our example we will formatting the field as below:

7. Start clicking OKs to start all dialog windows, and save then get back to Dynamics GP and go to Cards>> Inventory>> Item:

8. Notice the change over all forms that has the item number field there!

Hope that this helps.

---

Regards,

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

Purchase Order Commitment–Required Date from PO Required Date or Item Required Date?

I got an interesting question from of my customers who are willing to activate the purchase order commitments, the question was the documentation stated the following:

The Required Date must fall in a valid and open fiscal period.

The purchase order header has a required date field and the line items each has its own required date field, so which one will be used to commit the purchase order against the budget?

Logically each line item will be validated separately against the budget and therefore the date should be the line item date, after checking this it turned to be right and the system is looking into the line item “Required Date”.

---

Regards,

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

Dynamics GP - Change a form field to “Required” field

I got many requests from my customers on how to make this happens and I used to create a package and send it to the users for import.

However with the new Licensing structure, everybody owns the modifier as a part of the starter pack! Therefore anyone can do the following steps to activate this:

1. Open the Form.
2. Go to Tools>> Customize >> Modify Current Window
3. Select the field and switch “Required” to true as shown below:

Hope that this helps!

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

Printing Barcodes for Fixed Assets

One of my customers has requested to prints barcodes for his assets, and therefore I have created this simple methodology, take a look into the steps below:

Go to the Asset General Information form (Cards >> Fixed Assets >> General), and note the Additional menu on the form:

The system will prompt you to select the printer:

Barcode will be printed!

To get this please go and download the following ZIP file:

http://di.jo/files/Asset Label Printing.zip

It has two files:

• “IDAutomationHC39M.ttf”: place this file inside “C:\Windows\Fonts”
• “Asset Label Printing.dll”: Place this file inside your Dynamics GP Folder >> AddIns

NOTE: we have added a little DI.JO inside the barcode, just e-mail me to send you a package without this, it was added to count the number of users!

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

Dynamics GP Excel Paste Updates

Since the first day I announced the release of the excel paste, I been getting questions and requests from customers who already purchased the tool to do few modifications.

Issues started with unique screens, since the product is totally dynamic and does not have screens statically defined, sometimes few screens might not be effective as required and we been working the last few weeks on catching these screens by following customers requests.

Honestly I didn’t expect this number of requests nor the number of interested customers, which added a big number of helpdesk incidents to cover customers demands and product gaps.

One of the big things we used to get was to include the ability of having “headers” and “details” as a part of the product functionality so end users can paste multiple invoices at once or one invoice with multiple lines and each line with multiple serials, and here the challenge was started!

We been able to dynamically deliver the first part, we have adjusted the product to accept multiple windows by having one to many relation between the header and details lines. Below video might clarify more:

Example on header and details lines in GP Excel Paste

This version will be published soon once it get released from the Quality Assurance team and fine tuning some features, and will keep trying hard to find a solution for items and serials.

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

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

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

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:

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:

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:

And just paste on the purchase order screen:

Enjoy!!!

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

Receivables Management Transaction Un-apply Tool

 

We finally can utilize this function! check the article below:

Receivables Management Transction Unapply Tool in the Professional Services Tools Library is now available!

---

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