Skip to main content

Notifications

Microsoft Dynamics RMS forum

Missing Inter-Store Transfers

Posted on by Microsoft Employee

Hello all,

Is there any permanent fix for the Missing Inter-Store transfer bug in RMS?

Regards,
Sam.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Inter-Store Transfers

    Moataz Mohamed,

    Do you have Automatically create inter-store receive inventory order and Automatically create inter-store issue inventory order checked off in HQ Manager configuration?  Let me know and I'll try to help out.

    Sincerely,

    Chris

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Inter-Store Transfers

    Please help me

    i Have a problem in warehouse not uploading the transfer ?

  • Jack D Kyte Profile Picture
    Jack D Kyte 105 on at
    RE: Missing Inter-Store Transfers

    If it is not a bug what is it? A feature?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Missing Inter-Store Transfers

    Use the following sql script...you'll notice near the end there is the following line with a date...

    po1.otherpoid = 0 and po1.DateCreated = convert(datetime, 'may 17 2013 00:00AM')

    Change the date in that field to pull transfers that are 'in limbo' for a specific date.  The sql script on the post I mentioned earlier should pull transfers that are in limbo for the current month up to the previous day(won't pull the current day's missing transfers which is why I modified the script to pull for a specific date.  I prefer to check this on a daily basis in the morning and afternoon.)

    Hope this helps.

    po1.StoreID,po1.POTitle,sum(e.quantityordered) as Qty,

    sum(e.quantityordered*e.price) as Total,

    Department.Name,po1.DateCreated,po1.LastUpdated,po1.PONumber,po1.[shipTo]

    from purchaseorder as po1 WITH(NOLOCK)

    left join purchaseorder as po2 WITH(NOLOCK) on po2.otherpoid = po1.id and

    po2.otherstoreid = po1.storeid

    Inner JOIN PurchaseOrderEntry e WITH(NOLOCK) ON po1.ID=e.PurchaseOrderID AND

    po1.StoreID = e.StoreID

    LEFT JOIN Item WITH(NOLOCK) on e.ItemID=Item.ID

    LEFT JOIN Department with(NOLOCK) on Item.DepartmentID=Department.ID

    where po2.id Is Null and po1.otherstoreid > 0 and po1.status=2 and

    po1.otherpoid = 0 and po1.DateCreated = convert(datetime, 'may 17 2013 00:00AM')

    group by

    po1.StoreID,po1.POTitle,Department.Name,po1.DateCreated,po1.LastUpdated,po1.PONumber,po1.[shipTo]

    Order by po1.PONumber asc

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Missing Inter-Store Transfers

    well... I use query and it work like charm!

    This query will show you which POs are stuck in the system. And get the AutoID from table once it creates it!

    Select

    Store.ID, po1.POTitle, Department.Name, po1.DateCreated, po1.LastUpdated,

    po1.Status, po1.PONumber, Store.Name, po1.[To], po1.autoid

    from purchaseorder as po1 WITH(NOLOCK)

    left join purchaseorder as po2 WITH(NOLOCK) on po2.otherpoid = po1.id and

    po2.otherstoreid = po1.storeid

    Inner JOIN PurchaseOrderEntry WITH(NOLOCK) ON

    po1.ID=PurchaseOrderEntry.PurchaseOrderID AND po1.StoreID =

    PurchaseOrderEntry.StoreID

    LEFT JOIN Item WITH(NOLOCK) on PurchaseOrderEntry.ItemID=Item.ID

    LEFT JOIN Department with(NOLOCK) on Item.DepartmentID=Department.ID

    LEFT JOIN Category WITH(NOLOCK) ON Item.CategoryID=Category.ID

    LEFT JOIN Supplier WITH(NOLOCK) ON Item.SupplierID=Supplier.ID

    LEFT JOIN Store ON po1.OtherStoreID = Store.ID

    WHERE

      po2.id Is Null and po1.otherstoreid > 0 and po1.status=2 and

    po1.otherpoid = 0

      and

    po1.lastupdated<convert(nvarchar,month(getdate()))+'/'+convert(nvarchar,day(getdate()))+'/'+convert(nvarchar,year(getdate()))

      and

    po1.lastupdated>convert(nvarchar,month(getdate()))+'/1/'+convert(nvarchar,year(getdate()))

    Group By

      Store.ID, po1.POTitle, Department.Name, po1.DateCreated, po1.LastUpdated,

    po1.Status, po1.PONumber, Store.Name, po1.[To], po1.autoid

      Order By po1.PONumber

    Step 2 -  enter AutoID# below and it will work!

    update h set h.status=2

    from purchaseorder p join hqmessage h

    on fromstoreid=storeid and attachmentid=p.id

    where style=2 and h.status=3 and p.autoid=9804

    I wish MS come out with a hotfix to fix this automatically though.

  • Suggested answer
    randell wells Profile Picture
    randell wells 30 on at
    Re: Missing Inter-Store Transfers

    i have the same problem anyone know how to solve this cause its really bad for your reports

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Missing Inter-Store Transfers

    dcbailey, i checked out that thread and somehow step1 query shows me all OPEN POs or transfer in/out. Have anyone used hotfix to solve this problem yet?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Missing Inter-Store Transfers

    You may want to check this thread...

    community.dynamics.com/.../142977.aspx

    I also have transfer issues...mine seem to go "In Limbo" on days with heavy inventory transfers.  I have 14 stores and 2 stores(set up as inventory warehouses.)  Usually on Mondays when our store managers have placed orders to replenish stock from the weekend sales is when this problem occurs for me.  On days with light transfers the same shops will get their receive order with no problem.  

    At any rate the SQL scripts in the thread above are the only fixes I've found that work.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Missing Inter-Store Transfers

    Hi Keith,

    Thanks for your response.

    No, i have not seen the article. I will check and revert.

    Cheers!

    Sam.

  • Keith.N Profile Picture
    Keith.N on at
    Re: Missing Inter-Store Transfers

    Hi samuraiDXB,

    Have you gone through the following KB article?

    ArticleID: 911389.

    You experience unexpected results when you try to process inventory transfers in Headquarters or in Store Operations

    support.microsoft.com/.../911389

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans