web
You’re offline. This is a read only version of the page.
close
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 RMS (Archived) / Lost Inter store Trans...
Microsoft Dynamics RMS (Archived)

Lost Inter store Transfer in limbo

(1) ShareShare
ReportReport
Posted on by Community Member
I have a situation where every once in a while a store will send transfer to another store and the receiving store will never get it. You can see it is in HQ status closed but not at the receiving store. Sending store inventory has been adjusted correctly. Transfer is in limbo. We are currently sending ws 307 to the receiving store to fix inventory. Any Ideas how to fix or work around these situations?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    There is a daily proceedure that I do to find and fix this problem:
    1. run a report MTD through yesterday to find lost transfers.
    2. backdate a worksheet 401 to receiving store from the lost transfer's
    creation date
    3. process 401 worksheet and check report again to see if the transfer went
    4. if still won't go, update the hqmessage entry to flag transfer to
    transmit again <-- most effective solution
    5. if hqmessage for that transfer doesn't exist, create one to force the queue
    6. process another 401 worksheet and check again to see if that went
    7. extremely rarely do previous steps not work, but sometime have to put the
    inventory back in sending store, remove all trace of previous transfer, and
    recreate

    here are the queries that accomplish this
    1. run a report MTD through yesterday to find lost transfers.

    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

    4. if still won't go, update the hqmessage entry to flag transfer to
    transmit again

    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=122390

    5. if hqmessage for that transfer doesn't exist, create one to force the queue

    insert into hqmessage (status, style, fromstoreid, tostoreid, attachmentid,
    datesent)
    select 2,2,storeid,otherstoreid,id,datecreated from purchaseorder where
    autoid=122390

  • Community Member Profile Picture
    Community Member on at
    I want to get clear on somethings what report are you referring to in step 1. The only way I know I have a lost transfer a store reports that they have a Transfer order sheet but not in there Transfer in box. What report could I run daily that would show lost transfer? Is step 1 actually the query Select Store.ID, po1.POTitle, Department.Name, po1.DateCreated, po1.LastUpdated.....
  • Community Member Profile Picture
    Community Member on at

    yes, that query will show what transfers have been issued, but not transmitted to the receiving store. This enables you to be proactive about this problem to get it fixed before the stores even know it was broken.  Another advantage is independant oversight: not relying on complaints from the stores in case they ignore the problem and steal the merchandise.

  • Community Member Profile Picture
    Community Member on at
    Ok The report only shows one transfer looks like the one I am looking for. My question is in the report last column TO is that the sending store and Id is the receiving store? I have back dated the ws closest to the transfer time for the receiving store and 401 completed successfully but the transfer did not go through. Before I go forward I want to make sure my assumptions are right concerning the report columns.
  • Community Member Profile Picture
    Community Member on at
    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=122390 I am assuming I change p.autoid with the autoid from the report.? Would that be the only change is this query?
  • Community Member Profile Picture
    Community Member on at

    id is the storeid of the destionation.

    autoid in step 4 is the autoid of the problem transfer from step1.

  • Community Member Profile Picture
    Community Member on at
    Ok great. It worked like a charm. This makes my job so much easier adding it as daily procedure from now on. Thanks so much again!!
  • Community Member Profile Picture
    Community Member on at

    @Matt Hurst

    Yes! your steps worked like a charm for me too... :o)

    Thanks!

  • Community Member Profile Picture
    Community Member on at

    Matt,

    Thanks for sharing your knowledge with us.  I too have this issue.  It's disturbing that this is happening but it doesn't appear that MS has addressed this.  Any ideas as to the root cause of this problem?  I have noticed that when this occurs it is usually on days that have heavier transfers(today transfers from our main warehouse which is set up as a store to 7 different shops...about 30 total transfer orders.)  On the first occurrence the numbers were similar.

    Also on my end both times I've had to run the insert scripts to place the entries into the hqmessage table as the entries didn't exist with just a status flagged incorrectly.  I did notice that upon running the insert the first field 'ID' in HQMESSAGE is populating with a zero instead of autoincrementing...is this acceptable or is there something else that would need to be done to correct this?  Please let me know.

    Thanks again!

  • Community Member Profile Picture
    Community Member on at

    I think the problem has something to do with stores not connecting with HQ on the right schedule, and when a transfer is submitted or uploaded to HQ late and the receiving store has already synced for  that time period, the connection gets missed.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans