Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Tuesday, June 5, 2018

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