Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I purge "...
Microsoft Dynamics GP (Archived)

How can I purge "in-transit" transfers?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Good Morning,

 

I have many "abandoned" in-transit" transfer that are "stuck" in the system. They no longer show as being available for receipt and yet still show as shipped. I had attempted a couple of times to flip the status back to "open" via SQL per the instructions of the vendor and then delete the transfer, but should there not be a better and safer way to do this in GP?

These transfers have been abandoned and are currently skewing our inventory qtys in our 10 locations and our partner/vendor has not provided any satisfactory responses to this issue. Is there a tool or utility I can run that will force through the 100 or so abandoned transfers older that say 4 months? 

 

Sigh, any insight will be greatly appreciated,

Sheldon Thomas
IT Manager, Trek, Inc.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How can I purge "in-transit" transfers?

    Thanks Again!

    Sheldon

  • Suggested answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: How can I purge "in-transit" transfers?

    Running this this script "drops" the inventory where ever it is and unallocates it.

    Tim

  • Verified answer
    DanMoore Profile Picture
    DanMoore on at
    Re: How can I purge "in-transit" transfers?

    Hello Sheldon,

    It looks like Tim answered your question. However I see you are wondering if the stock allocated or picked goes back into inventory. For this you would want to test it in a test company created from the live data. Here is a KB article that explains how to create a test company from the live data:

    871973Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, or SQL Server 2008

    support.microsoft.com/.../en-US

    This will allow you to make sure it is safe to use and does what you want it to. If you need more detailed information I would recommend opening a support incident so that an engineer can look into your question in more detail.

    Thanks!

    Best regards,

    Dan Moore

    Customer Online Technical Community

    -----------------------------------------------------------------------------------------

    We hope you get value from our new forums platform! Tell us what you think:

    social.microsoft.com/.../threads

    ------------------------------------------------------------------------------------------

    This posting is provided "AS IS" with no warranties, and confers no rights

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How can I purge "in-transit" transfers?

    I have this script and process from a predecessor, wasn't sure how "safe" it was. Thanks for the response Tim, I really appreciate it.

    Once they are received and moved to history, any stock allocated or picked simply goes back onto the shelf where it was last at per the ST? Right?

  • Verified answer
    Tim Foster Profile Picture
    Tim Foster 8,515 on at
    Re: How can I purge "in-transit" transfers?

    Sheldon,

    See this KB:

    support.microsoft.com/.../871916

    Even though it is "retired," it still works.  I have used this in GP 10.0 and GP 2010.

    Tim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans