Dynamics GP Roadmap up Until 2020 - Enhancements are to Come

The GP Tech Conference has come to an end last week, lots of news have been introduced about the promising future of Dynamics GP, which includes the road map of the product, the promising enhancements to be introduced in the next release along with the Intelligent Edge.

Microsoft has published the road map of the product  up until 2020 which promises Dynamics GP clients with promising and core enhancements to the product. Most interesting of all is that Dynamics GP 2018 R2 will be released in October, 2018.

Dynamics GP Roadmap - GP Tech Conference

In addition to the various features and enhancements which are to be provided in the next release of Dynamics GP which will cover wide aspects of financial, sales and purchasing modules, the intelligence edge is a new concept introduced by Microsoft to literally "bridge the digital and real world", as declared by Microsoft; "it will enable the businesses to deliver seamless experience and compute capabilities wherever data exists, either in the cloud or offline."

 
The intelligent bridge will enable on-premises Microsoft Dynamics ERPs specifically including Dynamics GP, NAV, SL and Business Central (On Premises) to synchronize data with a cloud instance of Dynamics 365 Business Central and get access to all the interesting and powerful features such as; power BI, Power App, Flow and other powerful analytics tools. 

Intelligent Edge

In brief, the intelligence bridge will provide data synchronization utility which will open the horizons for existing on premises Dynamics ERPs to the wide azure services along with mobile accessibility features. 

What does that mean in simple words, remember with previous versions when Microsoft introduced the Power BI  as part of the reporting tools setup inside Dynamics GP, with that feature ... we could deploy Power BI reports and dashboards on the cloud, and then get them synced into Dynamics GP Home page as illustrated below:

Dynamics GP - Power BI Dashboard on Home Page

Now, with the intelligent edge, Microsoft has opened up the wide features of Dynamics GP on premises installations to get them synced with the cloud instance, have unlimited access to the various powerful capabilities and present analytics and dashboards on Dynamics GP Home page.

Best Regards,
Mahmoud M. AlSaadi

Dynamics GP - In Transit Documents and Reversal

In Transit transfer in Dynamics GP is a way to transfer items from one site to another via a specific site, though which laded cost functionality can be used in order to allocated further cost factors on the transferred items such as freight, shipping cost, packaging costs ...etc.

This functionality is quite effective in GP, and it might be used basically when products are shipped from one location to another via a vehicle or truck. This will definitely enure that quantities are being tracked even while they are being shipped. 

The visualization below illustrates how items could be transferred from one location to another, through a specific in-transit site.

In Transit Transfer - Dynamics GP

The process starts from the window "In Transit Transfer", which can be opened from Dynamics GP by following the following path: Inventory  > Transactions > In Transit

In Transit Transfer  ( Inventory > Transactions > In Transit ) 

On this window, you will have to specify the following:

•  Document Number ( you need to click on "New" button to get a new number, unlike other Dynamics GP forms in which the document number is automatically populated)
• Order Date
• From Site ID (From Site)
• Via Site ID
• To Side ID (Destination Site)

Once the items are filled out on the in-transit window, they need to be shipped, upon which an inventory transfer document will be posted automatically transferring the items from the (From Site) to the (Via Site)

The items will be on the "via site" as long as they are being shipped. Upon reaching the destination site ( To Site), you will have to go to "Receiving Transaction Entry" and choose the type "In Transit" receipt, from which you can either "Auto Receive" the whole in transit document, or choose line item by line item in-transit document. Below is the receiving transaction entry form, which include the "In Transit" type.

Receiving Transaction Entry  Window - In Transit Type

Once this document is posted, the items will be transferred from the "via site" into the "To Site" which represents the destination site. 

In Transit Reversal - Stuck Documents

It is worth to mention that throughout this process, the in transit document can not be reversed. In this essence, we have received several support cases from clients on how to clear stuck in-transit document. The answer is thoroughly illustrated in Microsoft Support Article; KB 871916

Here is the few lines of code which updates the status of the stuck in-transit document and moves it to history tables ( please make sure to follow the instructions provided in the support article, back up is always important)

"

Question:
I have a Service Transfer that has multiple lines, some are shipped and some are not. I am removing some open transfer lines that were duplicates. All that is remaining on the transfer are shipped lines. The status of the Service transfer remains partially shipped. How do I get it to update the status to complete and have it move to history?

Answer:
The first step is the update this record in the SVC00700 to a 6. After you have updated the record to a status of 6, you can run two stored procedures to move the record to the history table. Here are the two scripts:

UPDATE SVC00700 SET STATUS = 6 WHERE ORDDOCID = 'TransferNumber'

exec SVC_Transfer_TransferToHistory 'TransferNumber'

"

Best Regards, 

Mahmoud M. AlSaadi