Friday, December 14, 2012

Dynamics GP Excel Paste has been ranked in DynamicsWorld Microsoft Dynamics Top 50 Add-Ons 2013

I got the mail this morning that the Dynamics GP Excel Paste has made it and ranked in the 2013 list of DynamicsWorld Microsoft Dynamics Top 50 Add-Ons.

Quoting from DynamicsWorld:

In previous years each platform has had its own Top 12, however, with an increasing number of ISVs now creating cross platform Add-Ons this year it was necessary to publish the top Add-Ons for Microsoft Dynamics as a single list of the Top 50.

The issue of what makes the best Add-On for an end user is dependent upon what the end user requires, so, as in previous years the list does not rank the Add-Ons in order of choice, instead, the list is published in Alphabetical order.

So GP Excel Paste might be the best! No body knows!!

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

Sunday, December 9, 2012

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:

image

The system will prompt you to select the printer:

image

Barcode will be printed!

image

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

Thursday, December 6, 2012

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

image

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:

image

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

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

image

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!

image

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

Auto Assign Newly Added Analytical Accounting Code to All Users

I got a request from one of my customers, they had a need to auto assign newly created AA codes to all users and that how the idea started, I saw the scripts created by Sivakumar earlier to auto assign all codes to all users and used his cross join to create the below trigger.

The trigger is simply works on AAG00401 table upon record insert, it assigns the newly created codes to all GP users automatically, just run below script over your company database and enjoy.

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

 

-- =============================================
-- Author : Mohammad R. Daoud
-- Create date: 09:56 AM ‎07/‎12/‎2012
-- Description: This trigger as created to auto assign
-- newly created analytical accounting codes to all users.
-- =============================================
CREATE TRIGGER DI_AutoAssignSecurity
ON AAG00401
FOR INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for trigger here
DECLARE @aaTrxDimID INT
DECLARE @aaTrxDimCodeID INT

SELECT TOP 1 @aaTrxDimID = aaTrxDimID, @aaTrxDimCodeID = aaTrxDimCodeID FROM INSERTED
DELETE FROM AAG02000 WHERE aaTrxDimID = @aaTrxDimID AND AAG02000.aaTrxDimCodeID = @aaTrxDimCodeID
INSERT INTO AAG02000 (USERID, aaTrxDimID, aaTrxDimCodeID, aaDistribute, aaAdjust) (SELECT B.USERID, A.aaTrxDimID, A.aaTrxDimCodeID, 1, 1 FROM AAG00401 A CROSS JOIN DYNAMICS..SY01400 B WHERE A.aaTrxDimID = @aaTrxDimID AND A.aaTrxDimCodeID = @aaTrxDimCodeID)
END
GO

Resizing SmartList TreeView and ListView panes using the Support Debugging Tool

David Musgrave has made it again, he has provided a way to resize the treeview of the smart list using a splitter control, take a look into his article below:

http://blogs.msdn.com/b/developingfordynamicsgp/archive/2012/12/05/update-resizing-smartlist-treeview-and-listview-panes-using-the-support-debugging-tool.aspx

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

Wednesday, December 5, 2012

Dynamics GP 2013 Release Date

It has been announced now that the release date for Microsoft Dynamics GP 2013 is 19-12-2013, take a look into the following post:

http://msdynamicsworld.com/story/microsoft-dynamics-gp-2013-has-release-date-december-19?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+msdynamicsworld/news+%28Microsoft+Dynamics+News%29&utm_content=Google+Reader

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.

image

Then: GPS Error: 58

image

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

image

Then: ODBC Error: 37000

image

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:

image

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

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

Wednesday, October 24, 2012

Errors while loading Dynamics GP

 

Have you ever lunched Dynamics GP and got the below error:

“FP: Bad component offset: 80Wind: 1Fld: 14”

image

And then got the below error:

“Unhandled script exception:

Illegal address for field Account Number in script Setup_Account_Format. Script terminated.”

image

If so all what you need to do is for this error or any similar issues related to the account framework is to go to Dynamics GP Folder\Data\Dex.ini and change a switch called “Synchronize” from FALSE to TRUE, this will require GP to run utilities and resynchronize your account framework and the issue will no longer exist.

Hope this helps.

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

Thursday, October 4, 2012

Dynamics GP Excel Paste–New version has been released

Yesterday we have released a new version of the Dynamics GP Excel Paste, it has many new features and enhancements, I am showing the main additions in this post:

1. One installation across all GL Versions: (GP 10.0, GP 2010, GP 2013), ALL Service Packs, all platforms (Windows XP, Windows 7, Windows Server), any CPU (64x, 32x).

2. Messages Handling: We left this option for end user to decide either to auto answer the dialogs or by manually handling answers:

image

Another message will be shown:

image

3. Added more free screens: we have allowed the paste over common objects across all companies, like Currencies, Users, Tasks and Roles.

4. Enhanced the connectivity to the internet: if you are running behind firewalls we been facing difficulties loading templates as your firewalls are blocking the outbound access to the SQL, by using an alternative to the 1433 port, currently the application automatically calls a web service using the default port and using default proxy settings to pass through firewalls and get the templates installed.

5. Enhanced the ability to paste into distribution windows: we found many issues pasting using Advanced Excel Paste into “Distribution Windows”, issue have been resolved and you can paste safely:

PM Transaction Entry with Distribution

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

Saturday, September 22, 2012

Web Client with Multiple GP Instances

I got a case on my server where I wanted the web client to work with different GP instant not the default, people start asking me you have multiple instances of Dynamics GP 2013 on your server!?! Yes I have installed the product 9 times with 9 different application instances and all are on the same SQL instant! This is what I liked with this version.

However, as I understood from the Dynamics GP Community, the web client is like the Dynamics.exe but on the web, meaning all application objects are to be loaded from the folder and the Dynamics.set will be called.

Hence, there must be somewhere to give the web client the path of the GP folder and it was there, I have noticed an XML file in the following path:

C:\Program Files\Microsoft Dynamics\GP Web Client\GPweb

File name is TenantConfiguration.xml, below is the content that explains itself:

<?xml version="1.0" encoding="utf-8"?>
<TenantConfiguration>
  <Tenants>
    <Tenant Name="GPWebApp">
      <Description>Microsoft Dynamics GP 2013</Description>
      <RuntimeApplicationDirectory>C:\Program Files (x86)\Microsoft Dynamics\GP2013\</RuntimeApplicationDirectory>
      <SetFile>C:\Program Files (x86)\Microsoft Dynamics\GP2013\Dynamics.set</SetFile>
      <DexIniFile>C:\Program Files (x86)\Microsoft Dynamics\GP2013\Data\Dex.ini</DexIniFile>
      <HeartbeatTimeout>0.20:00:00</HeartbeatTimeout>
    </Tenant>
  </Tenants>
</TenantConfiguration>

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 is now supported on GP 2013

We did few code modifications to get this works on GP 2013, it was a matter of doing some changes to database naming that was statically assigned like DYNAMICS and TWO.

image

For web client, I been able to load the menus into the additional menus of the application screens, but still unable to access the Clipboard to load data due to security complications between web client and server, besides we feel like the Continuum API which we use to perform the paste operation is not loaded over the web client, however as long as the .NET still supported, I assure you that we will make it, but we’ll be waiting for the RTM release to kickoff!

image

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

Changes to GP2013 that should be considered by ISV’s

I been working the last few days hard to discover the new changes Microsoft made on GP 2013 desktop version and the web client and went through the application architecture to understand how will our solutions work among new application features and below are my initial findings:

1. Starting from GP 6.0 or maybe before, we used to know a fact that DYNAMICS database is constant and will never be changed, therefore we used to use this name statically in our code, starting from this point you no longer able to set this statically and will need to find an alternative.

2. As long as the Dynamics database we also used to know that the Sample company database was always named “TWO”, now it might be anything! Therefore you will need to query the SY01500 table with company ID of –1 to get the Intercompany ID and know the database name accordingly.

3. Working with GPConnNet wasn’t changed, however you still need to find a way to test the connection by using the Intercompany ID instead of querying the DYNAMICS database and shown on the examples, you can use “Dynamics.Globals.IntercompanyID.Value” from your development platform to retrieve this.

I will keep posting my findings!

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

Friday, September 14, 2012

Microsoft Dynamics GP 2013 - Additional Core New Features

New Look and Feel! I liked the new look for the home page, customizable and more user friendly:

image

Reconcile to GL - Banks and Inventory was added! This is my favorite area, I been engaged in many assignments to reconcile modules to GL and suffered hard times!

image

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 2013 - Named DYNAMICS Database

In all previous versions, we used to created a separate SQL instant for each customer when doing a test environment on our servers, this makes working with multiple customer annoying! Check the below change in GP 2013:

image

NOTE: Database name must be less than 10 characters!

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 Installation - Where is the Analytical Accounting??

 

I been unable to wait for the next week to start testing! I started the installation this morning and below the first change I notice, Analytical Accounting is now integrated with Fixed Assets and cannot be installed with having the Fixed Assets installed:

image

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

Thursday, September 13, 2012

Dynamics GP 2013 – Beta Version has been released!!!!!

 

2013 banner

Microsoft Dynamics GP 2013 Beta Version has been released, go ahead a download your test version from the link below, while I am so excited to install and test, but I will be pushing myslef to publish my findings next week as I am going to relax this weekend!

https://mbs.microsoft.com/partnersource/support/selfsupport/productreleases/MDGP2013_TAPReleaseDownload

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

Tuesday, September 4, 2012

Microsoft Dynamics GP Excel Paste–New Version Release

I am sure that for some people this became annoying, but I assure you guys that for the last two months I did nothing but modifications on the Excel Paste due to the huge number of requests we got and still getting.

This version was scheduled to be released by the first of the month, but it was postponed for few days to include more enhancements, below what we have changed:

  • Additional Modules has been added:

Now the product does not works only with Dynamics Dictionary, it was extended to include almost all Dynamics GP modules, I personally have tested the below:

    1. Manufacturing
    2. Cashbook Management
    3. Fixed Assets
    4. Analytical Accounting

image

  • Special SQL Command Prior to Paste:

We did face many cases where the end user wanted to perform some operations on the database level before doing the paste, like deleting Journal Lines before pasting new lines, this would be possible before and now it became an easy setup.

  • Special SanScript Commands:

While trying to apply the tool over the Item Transfer form we have notice something cannot be done using old version specially when you have Multi-bin activated or Serial/Lot Tracking for your items, it took allot to be done but we have created an option for experts to run special SanScript commands before filling any of the fields and perform any kind of operations on the field, like getting new form opened or running some validations.

Inventory Item Transfers with Multi Bin
  • Products Online Download

We have added a functionality on the tool to accepts new Dynamics GP Products at runtime! There will be no need from the development team to release new package each time we add a module, we will be updating our host with Product configuration and all the necessary setup and the end user will only download the product to get it active:

image

  • Filtered Templates

Now you can filter the templates page by any available column, you just need to click on the column to get exactly what you are looking for:

image

  • Updated Menus Design:

We been asked many times which are your menus and which are other products menus within the “Additional” list, therefore we have identified the menus related to the Excel Paste with “DI”:

image

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

Saturday, August 18, 2012

Excel Paste and Payroll Transaction Entry

People been facing difficulties using the Excel Paste for Payroll Transaction Entry, therefore I have created the template and uploaded it to the host, you can download it now with the below format:

EmployeeId, ComputerTrxType, UprTrxCode, LocalAmount, LocalTrxNumber, LocalBtnNext

Watch the below:

Payroll Transaction Entry

Enjoy!

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

Sunday, August 12, 2012

Selecting a New Microsoft Dynamics GP Partner

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

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

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

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

Major Selection Criteria:

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

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

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

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

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

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

Other Points to Consider from the blogsphere:

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

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

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

Saturday, August 4, 2012

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:

image

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:

image

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:

image

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

Friday, August 3, 2012

Dynamics GP Excel Paste Templates

A new version of Microsoft Dynamics GP Excel Paste has been released, but not the one that pastes with header and details, instead we have decided to release “templates support” version until getting the other version ready due to the high demand to get this feature and to reduce the support tasks that been assigned to the support team.

By releasing this version, end users will be able to download ready templates from the following page:

http://di.jo/GPExcelPasteTemplates.aspx

And simply paste the template into the Dynamics GP Excel Paste Setup form as shown in the video below:

Setup Excel Paste Templates

Experts can easily create templates, copy what they have created from the grid to Excel and just send it to me for publishing, this will make users life easier!

Enjoy!

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

Friday, July 27, 2012

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

Friday, July 13, 2012

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

Wednesday, July 11, 2012

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

 

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

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

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

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

Tuesday, July 10, 2012

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 Smile

image

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

Thursday, July 5, 2012

COPY Advanced Financials Reports Across Companies

 
Normally you will need to create your balance sheet and paste it over all your companies, script below will do the task for you:
 
Download Link:
 
Script:
--REPLACE Source with your source Company ID
--REPLACE Destination with your destination Company ID
INSERT INTO [Destination].DBO.AF40100 ([RPRTNAME],[REPORTID],[RPRTTYPE],[CLCFRPRT],[LSTMODIF],[NOTEINDX])  SELECT [RPRTNAME],[REPORTID],[RPRTTYPE],[CLCFRPRT],[LSTMODIF],[NOTEINDX] FROM [Source].DBO.AF40100
INSERT INTO [Destination].DBO.AF40101 ([REPORTID],[MNHDRCNT],[MNFTRCNT],[SHDRCNT],[SFTRCNT],[ROWCNT1],[COLCNT],[SHDRPCNT],[SFTRPCNT],[MNHDRFLG],[MNFTRFLG],[SHDRFLAG],[SFTRFLAG],[MNHDRSIZ],[MNFTRSIZ],[SHDRSIZE_1],[SHDRSIZE_2],[SHDRSIZE_3],[SHDRSIZE_4],[SHDRSIZE_5],[SFTRSIZE_1],[SFTRSIZE_2],[SFTRSIZE_3],[SFTRSIZE_4],[SFTRSIZE_5],[SHDROPT_1],[SHDROPT_2],[SHDROPT_3],[SHDROPT_4],[SHDROPT_5],[SHDRPRT_1],[SHDRPRT_2],[SHDRPRT_3],[SHDRPRT_4],[SHDRPRT_5],[SFTROPT_1],[SFTROPT_2],[SFTROPT_3],[SFTROPT_4],[SFTROPT_5],[SFTRPRT_1],[SFTRPRT_2],[SFTRPRT_3],[SFTRPRT_4],[SFTRPRT_5],[COLHDCNT],[COLDHSIZ_1],[COLDHSIZ_2],[COLDHSIZ_3],[COLDHSIZ_4],[COLDHSIZ_5],[COLDHSIZ_6],[RTOTLSIZ],[COLTOSIZ],[COLOFSIZ],[LFTMARGN],[RTMARGIN],[TOPMARGN],[BOTMARGN]) SELECT [REPORTID],[MNHDRCNT],[MNFTRCNT],[SHDRCNT],[SFTRCNT],[ROWCNT1],[COLCNT],[SHDRPCNT],[SFTRPCNT],[MNHDRFLG],[MNFTRFLG],[SHDRFLAG],[SFTRFLAG],[MNHDRSIZ],[MNFTRSIZ],[SHDRSIZE_1],[SHDRSIZE_2],[SHDRSIZE_3],[SHDRSIZE_4],[SHDRSIZE_5],[SFTRSIZE_1],[SFTRSIZE_2],[SFTRSIZE_3],[SFTRSIZE_4],[SFTRSIZE_5],[SHDROPT_1],[SHDROPT_2],[SHDROPT_3],[SHDROPT_4],[SHDROPT_5],[SHDRPRT_1],[SHDRPRT_2],[SHDRPRT_3],[SHDRPRT_4],[SHDRPRT_5],[SFTROPT_1],[SFTROPT_2],[SFTROPT_3],[SFTROPT_4],[SFTROPT_5],[SFTRPRT_1],[SFTRPRT_2],[SFTRPRT_3],[SFTRPRT_4],[SFTRPRT_5],[COLHDCNT],[COLDHSIZ_1],[COLDHSIZ_2],[COLDHSIZ_3],[COLDHSIZ_4],[COLDHSIZ_5],[COLDHSIZ_6],[RTOTLSIZ],[COLTOSIZ],[COLOFSIZ],[LFTMARGN],[RTMARGIN],[TOPMARGN],[BOTMARGN] FROM [Source].DBO.AF40101
INSERT INTO [Destination].DBO.AF40102 ([REPORTID],[HDRFTRTY],[FLDNUM],[FLDPOSX1],[FLDPOSY1],[FLDPOSX2],[FLDPOSY2],[FLDTYPE],[FLDFRMAT],[SBHSBFIN],[FLDOPT],[FLDOPT2],[FLDALIGN],[FLDFTFML],[FLDFTSIZ],[FLDSTYLE_1],[FLDSTYLE_2],[FLDSTYLE_3],[FLDSTYLE_4],[FLDSTYLE_5],[FLDSTYLE_6],[FLDVALUE],[FLDVALU2],[FLDPRNAM]  ) SELECT [REPORTID],[HDRFTRTY],[FLDNUM],[FLDPOSX1],[FLDPOSY1],[FLDPOSX2],[FLDPOSY2],[FLDTYPE],[FLDFRMAT],[SBHSBFIN],[FLDOPT],[FLDOPT2],[FLDALIGN],[FLDFTFML],[FLDFTSIZ],[FLDSTYLE_1],[FLDSTYLE_2],[FLDSTYLE_3],[FLDSTYLE_4],[FLDSTYLE_5],[FLDSTYLE_6],[FLDVALUE],[FLDVALU2],[FLDPRNAM]   FROM [Source].DBO.AF40102
INSERT INTO [Destination].DBO.AF40103 ([REPORTID],[COLNUM],[CLTKNCNT],[COLTYPE],[COLSIZE],[COLOMCNT],[COLOFMRK_1],[COLOFMRK_2],[COLOFMRK_3],[COLOFMRK_4],[HIDEFLAG],[TEXTVALU],[STPERIOD],[ENDPEROD],[AMNTFROM],[HISTYEAR],[BUDID],[PRTSIGN],[PRTCOMMA],[PRTPCENT],[PRTTEXT],[ROUNDOPT],[HEADALIN],[HDFTFMLY],[HDFTSIZE],[HEDSTYLE_1],[HEDSTYLE_2],[HEDSTYLE_3],[HEDSTYLE_4],[HEDSTYLE_5],[HEDSTYLE_6],[HEADTYPE_1],[HEADTYPE_2],[HEADTYPE_3],[HEADTYPE_4],[HEADTYPE_5],[HEADTYPE_6],[HEDFRMAT_1],[HEDFRMAT_2],[HEDFRMAT_3],[HEDFRMAT_4],[HEDFRMAT_5],[HEDFRMAT_6],[HEADOPT_1],[HEADOPT_2],[HEADOPT_3],[HEADOPT_4],[HEADOPT_5],[HEADOPT_6],[HEADOPT2_1],[HEADOPT2_2],[HEADOPT2_3],[HEADOPT2_4],[HEADOPT2_5],[HEADOPT2_6],[COLHDNG_1],[COLHDNG_2],[COLHDNG_3],[COLHDNG_4],[COLHDNG_5],[COLHDNG_6],[COLHDNG2_1],[COLHDNG2_2],[COLHDNG2_3],[COLHDNG2_4],[COLHDNG2_5],[COLHDNG2_6],[ALGNOFST],[COLEXPER],[NOTEINDX],[SEGFROM_1],[SEGFROM_2],[SEGFROM_3],[SEGFROM_4],[SEGFROM_5],[SEGFROM_6],[SEGFROM_7],[SEGFROM_8],[SEGFROM_9],[SEGFROM_10],[SEGTO_1],[SEGTO_2],[SEGTO_3],[SEGTO_4],[SEGTO_5],[SEGTO_6],[SEGTO_7],[SEGTO_8],[SEGTO_9],[SEGTO_10]) SELECT [REPORTID],[COLNUM],[CLTKNCNT],[COLTYPE],[COLSIZE],[COLOMCNT],[COLOFMRK_1],[COLOFMRK_2],[COLOFMRK_3],[COLOFMRK_4],[HIDEFLAG],[TEXTVALU],[STPERIOD],[ENDPEROD],[AMNTFROM],[HISTYEAR],[BUDID],[PRTSIGN],[PRTCOMMA],[PRTPCENT],[PRTTEXT],[ROUNDOPT],[HEADALIN],[HDFTFMLY],[HDFTSIZE],[HEDSTYLE_1],[HEDSTYLE_2],[HEDSTYLE_3],[HEDSTYLE_4],[HEDSTYLE_5],[HEDSTYLE_6],[HEADTYPE_1],[HEADTYPE_2],[HEADTYPE_3],[HEADTYPE_4],[HEADTYPE_5],[HEADTYPE_6],[HEDFRMAT_1],[HEDFRMAT_2],[HEDFRMAT_3],[HEDFRMAT_4],[HEDFRMAT_5],[HEDFRMAT_6],[HEADOPT_1],[HEADOPT_2],[HEADOPT_3],[HEADOPT_4],[HEADOPT_5],[HEADOPT_6],[HEADOPT2_1],[HEADOPT2_2],[HEADOPT2_3],[HEADOPT2_4],[HEADOPT2_5],[HEADOPT2_6],[COLHDNG_1],[COLHDNG_2],[COLHDNG_3],[COLHDNG_4],[COLHDNG_5],[COLHDNG_6],[COLHDNG2_1],[COLHDNG2_2],[COLHDNG2_3],[COLHDNG2_4],[COLHDNG2_5],[COLHDNG2_6],[ALGNOFST],[COLEXPER],[NOTEINDX],[SEGFROM_1],[SEGFROM_2],[SEGFROM_3],[SEGFROM_4],[SEGFROM_5],[SEGFROM_6],[SEGFROM_7],[SEGFROM_8],[SEGFROM_9],[SEGFROM_10],[SEGTO_1],[SEGTO_2],[SEGTO_3],[SEGTO_4],[SEGTO_5],[SEGTO_6],[SEGTO_7],[SEGTO_8],[SEGTO_9],[SEGTO_10] FROM [Source].DBO.AF40103
INSERT INTO [Destination].DBO.AF40104 ([REPORTID],[CLCOLNUM],[TKNODNUM],[TKNTYPE],[TKNVALUE],[TKNDLVAL],[TKNUNACT_1],[TKNUNACT_2],[TKNUNACT_3],[TKNUNACT_4],[TKNUNACT_5],[TKNUNACT_6],[TKNUNACT_7],[TKNUNACT_8],[TKNUNACT_9],[TKNUNACT_10]) SELECT [REPORTID],[CLCOLNUM],[TKNODNUM],[TKNTYPE],[TKNVALUE],[TKNDLVAL],[TKNUNACT_1],[TKNUNACT_2],[TKNUNACT_3],[TKNUNACT_4],[TKNUNACT_5],[TKNUNACT_6],[TKNUNACT_7],[TKNUNACT_8],[TKNUNACT_9],[TKNUNACT_10] FROM [Source].DBO.AF40104
INSERT INTO [Destination].DBO.AF40105 ([REPORTID],[CLCOLNUM],[TKNODNUM],[TKNTYPE],[TKNVALUE],[TKNDLVAL],[TKNUNACT_1],[TKNUNACT_2],[TKNUNACT_3],[TKNUNACT_4],[TKNUNACT_5],[TKNUNACT_6],[TKNUNACT_7],[TKNUNACT_8],[TKNUNACT_9],[TKNUNACT_10]     ) SELECT [REPORTID],[CLCOLNUM],[TKNODNUM],[TKNTYPE],[TKNVALUE],[TKNDLVAL],[TKNUNACT_1],[TKNUNACT_2],[TKNUNACT_3],[TKNUNACT_4],[TKNUNACT_5],[TKNUNACT_6],[TKNUNACT_7],[TKNUNACT_8],[TKNUNACT_9],[TKNUNACT_10]FROM [Source].DBO.AF40105
INSERT INTO [Destination].DBO.AF40106 ([REPORTID],[ROWNUMBR],[TOTKNCNT],[ROWTYPE],[ROWSIZE],[ROLUPFLG],[ROWDESC],[SUBSUDID],[TYPCLBAL],[CATNUMBR],[PRTSIGN],[PRTHEDER],[CENTHEDR],[ROWFTFAM],[ROWFTSIZ],[ROWSTYLE_1],[ROWSTYLE_2],[ROWSTYLE_3],[ROWSTYLE_4],[ROWSTYLE_5],[ROWSTYLE_6],[ROFMRKIN_1],[ROFMRKIN_2],[ROFMRKIN_3],[ROFMRKIN_4],[ROFMRKIN_5],[ROFMRKIN_6],[ROFMRKIN_7],[ROFMRKIN_8],[ROFMRKIN_9],[ROFMRKIN_10],[ROFMRKIN_11],[ROFMRKIN_12],[ROFMRKIN_13],[ROFMRKIN_14],[ROFMRKIN_15],[ROFMRKIN_16],[ROFMRKIN_17],[ROFMRKIN_18],[ROFMRKIN_19],[ROFMRKIN_20],[ROFMRKIN_21],[ROFMRKIN_22],[ROFMRKIN_23],[ROFMRKIN_24],[ROFMRKIN_25],[ROFMRKIN_26],[ROFMRKIN_27],[ROFMRKIN_28],[ROFMRKIN_29],[ROFMRKIN_30],[ROFMRKIN_31],[ROFMRKIN_32],[ROFMRKIN_33],[ROFMRKIN_34],[ROFMRKIN_35],[ROFMRKIN_36],[ROFMRKIN_37],[ROFMRKIN_38],[ROFMRKIN_39],[ROFMRKIN_40],[CFLOSCTN],[RWEXPERR],[NOTEINDX],[STTACCT_1],[STTACCT_2],[STTACCT_3],[STTACCT_4],[STTACCT_5],[STTACCT_6],[STTACCT_7],[STTACCT_8],[STTACCT_9],[STTACCT_10],[ENDACCT_1],[ENDACCT_2],[ENDACCT_3],[ENDACCT_4],[ENDACCT_5],[ENDACCT_6],[ENDACCT_7],[ENDACCT_8],[ENDACCT_9],[ENDACCT_10]) SELECT [REPORTID],[ROWNUMBR],[TOTKNCNT],[ROWTYPE],[ROWSIZE],[ROLUPFLG],[ROWDESC],[SUBSUDID],[TYPCLBAL],[CATNUMBR],[PRTSIGN],[PRTHEDER],[CENTHEDR],[ROWFTFAM],[ROWFTSIZ],[ROWSTYLE_1],[ROWSTYLE_2],[ROWSTYLE_3],[ROWSTYLE_4],[ROWSTYLE_5],[ROWSTYLE_6],[ROFMRKIN_1],[ROFMRKIN_2],[ROFMRKIN_3],[ROFMRKIN_4],[ROFMRKIN_5],[ROFMRKIN_6],[ROFMRKIN_7],[ROFMRKIN_8],[ROFMRKIN_9],[ROFMRKIN_10],[ROFMRKIN_11],[ROFMRKIN_12],[ROFMRKIN_13],[ROFMRKIN_14],[ROFMRKIN_15],[ROFMRKIN_16],[ROFMRKIN_17],[ROFMRKIN_18],[ROFMRKIN_19],[ROFMRKIN_20],[ROFMRKIN_21],[ROFMRKIN_22],[ROFMRKIN_23],[ROFMRKIN_24],[ROFMRKIN_25],[ROFMRKIN_26],[ROFMRKIN_27],[ROFMRKIN_28],[ROFMRKIN_29],[ROFMRKIN_30],[ROFMRKIN_31],[ROFMRKIN_32],[ROFMRKIN_33],[ROFMRKIN_34],[ROFMRKIN_35],[ROFMRKIN_36],[ROFMRKIN_37],[ROFMRKIN_38],[ROFMRKIN_39],[ROFMRKIN_40],[CFLOSCTN],[RWEXPERR],[NOTEINDX],[STTACCT_1],[STTACCT_2],[STTACCT_3],[STTACCT_4],[STTACCT_5],[STTACCT_6],[STTACCT_7],[STTACCT_8],[STTACCT_9],[STTACCT_10],[ENDACCT_1],[ENDACCT_2],[ENDACCT_3],[ENDACCT_4],[ENDACCT_5],[ENDACCT_6],[ENDACCT_7],[ENDACCT_8],[ENDACCT_9],[ENDACCT_10] FROM [Source].DBO.AF40106
INSERT INTO [Destination].DBO.AF40107 ([REPORTID] ,[TOTRWNUM],[TKNODNUM],[STROWNUM],[ENDRWNUM]) SELECT [REPORTID] ,[TOTRWNUM],[TKNODNUM],[STROWNUM],[ENDRWNUM] FROM [Source].DBO.AF40107
INSERT INTO [Destination].DBO.AF40108 ([REPORTID],[TOTRWNUM],[MBRWNUM]) SELECT [REPORTID],[TOTRWNUM],[MBRWNUM] FROM [Source].DBO.AF40108
INSERT INTO [Destination].DBO.AF40109 ([FLDPRNAM],[FLDPCTUR]) SELECT [FLDPRNAM],[FLDPCTUR] FROM [Source].DBO.AF40109
--INSERT INTO [Destination].DBO.AF40110 ([USERNAME],[SHGRDFLG],[SHCGRFLG],[SHTBARFL],[SCDEFAFL],[SHRWARFL],[SHOFMKFL],[SNPTGRFL],[SHMARFLG],[SHPGBDFL],[SHRLRSFL] ) SELECT [USERNAME],[SHGRDFLG],[SHCGRFLG],[SHTBARFL],[SCDEFAFL],[SHRWARFL],[SHOFMKFL],[SNPTGRFL],[SHMARFLG],[SHPGBDFL],[SHRLRSFL]  FROM [Source].DBO.AF40110




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

Sunday, June 24, 2012

What do you expect from Dynamics GP 2013??

 

I been looking around the blogosphere an noticed an awesome article by Frank Hamelly simply summarizing new features of Dynamics GP 2013, I am sure that you are very much excited to check what that could be therefore I have copied them all, sorry Frank for the infringe of your copyrights! but I wanted to bold features that is useful for customers in my region, blow is the list:

  • Excel Export Using Open XML
  • Enable printing of SSRS report from forms
  • Navigation Lists for Web Client (BA Functionality)
  • Re-architect home pages to WPF
  • New SSRS reports to support Web Client templated forms
  • Business Analyzer WPF upgrade
  • Additional Word Templates for SOP
  • Single Email with multiple attachments
  • SRS Reports
  • Print Customer Items option
  • Select invoice on one-off Email window
  • Notes on Credit Documents
  • Document Attach
  • Item Standard Cost adjustment post to GL
  • Multi-S/N select
  • Inactivate a Site and Item Site
  • Reason Codes for stock movements/adjustments
  • Inactive Items - Inventory Status enhancements
  • Bin Transfer History
  • Tolerance Handling
  • Track Serial Numbers for Drop Ship items
  • Allow prepayments on a PO
  • Prevent PO close prior to Invoice Match
  • Print Button on Pick List Shortage Inquiry
  • Ship to Address has different Company Name
  • Relate / Link Items for suggestions on Sales
  • Integrate AA with Copier Series SOP/POP and GL Copy
  • Add Field Service Allocations to Item Allocation Inquiry Window
  • Update Back Order Quantity in Item Maintenance
  • RMA Entry - Update Contact & Address ID
  • Consolidate Revenue Recognition
  • Item Description from RMA Credit
  • Multi-User check in RMA Entry
  • Equipment Super Session
  • Hotline Update
  • RMA Return Quantity and Type
  • Ship to Address Integration to SOP
  • Cross Ship RMA consolidation
  • Honor Discontinued Item Status
  • Auto Populate Customer ID
  • Add a Contract Number search in Revenue recognition window
  • Allow contract line to be moved to another contract even if on an open service call
  • Option to have an equipment card created when manufacturing receives a serialized item into inventory
  • Contract Workflow
  • Add BAI2 format support to eReconcile
  • FA Calendar Setup
  • FA Intercompany Asset Transfer
  • FA Historical Depreciation Report
  • Lock Current FA Year and Mass Backout
  • FA to GL posting process updates
  • FA Updates for MACRS
  • Integrate Fixed Assets with AA
  • GL Journal Entry Inquiry for History
  • Reconcile Bank Reconciliation with GL
  • Year End Close Options
  • Subledger Reconcile IV to GL
  • Calculate Average Exchange Rate for Currency Translation
  • Integrate GL with encumbrance
  • Enable Enc to assign Multiple GL Budgets for Fiscal Year
  • Encumbrance Cost Diff Notification
  • Restrict Void of reconciled check, display reconcile status in Check Inquiry
  • Void of check returns applied Credits
  • Void credit card payment vendor invoice - void to original vendor
  • EFT add settlement date option
  • EFT Field Length and Delimitation Options
  • Edit Payables Transactions: Remit to Address, 1099 information, Edit Description
  • PM Reprint Checks/Remittance forms
  • Need a 1096 Form
  • Allow renaming of user-defined fields on Customer Address
  • Multicurrency apply in cash entry
  • Database multi-tenancy (named system database)
  • Application multi-tenancy
  • Report deployment and retrieval for multi-tenant
  • Multi-tenant Applications - tenant service
  • Multi-tenant Integration Manager
  • Multi-tenant web service
  • Life Insurance enhancements
  • Check Build Exception Report
  • Stop Duplicate Checks
  • Paycode History Edit
  • Paycode, Deduction, Benefit Modifier
  • FICA TSA Deductions
  • Customer Fields
  • Advanced Warning Notice and Delete History Records
  • Mandatory Arrears Template and Reminders
  • DIA Reporting
  • Voucher Description and Voucher Document Number
  • Voucher Consolidation
  • HR Calendar
  • Negative Carryover
  • PTO Detail and History
  • PTO Manual Checks
  • Year End PTO
  • Office Presence in Advanced HR, Advanced Payroll, Payroll Extensions & PTO Manager
  • HR Requisition List View
  • Consolidated Invoicing
  • Additional String Resources (Dex)
  • Key Relations tracked in index file for source control(Dex)
  • Update VBA Components
  • Enhance the AltMod windows with a mark all/unmark all functionality
  • 64 Bit Support for Email (Dex)
  • Default sort for Customer and Vendor lookups
  • Email Indicators in Transaction lists

  • Save batch approval information

  • Select Printer at time of print AND Support for http:// on the Report Destination window

  • Adding support for the Business Analyzer to NLB

  • Grouped Reports

  • SmartList Builder - remove dependency on having an Admin login after new install

  • Extender Window export/import to include Smartlist integrations

  • Add Extender & SmartList Builder Default Security

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

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

Wednesday, June 20, 2012

Excel Paste for “Any Screen” in Microsoft Dynamics GP

 

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

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

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

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

Purchase Order Excel Paste

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

Customer Card Excel Paste

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

image

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

image

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

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

image

And just paste on the purchase order screen:

image

Enjoy!!!

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

Saturday, June 16, 2012

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

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

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

Below is our outcome:

Paste from Excel

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

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

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

image

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

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

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

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

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

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

Saturday, May 12, 2012

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

Related Posts:

Related Posts with Thumbnails