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) / TRANSFER IS MISSING IN...
Microsoft Dynamics RMS (Archived)

TRANSFER IS MISSING IN ONE STORE

(0) ShareShare
ReportReport
Posted on by Community Member

I MADE ONE TRANSFER FROM ONE STORE TO ANOTHER STORE AND COMMIT.BUT IN ANOTHER STORE(TOSTORE) THAT PARTICULAR TRANSFER HAS NOT REACH.I TRIED TO MAKE WORKSHEET 401-REQUEST DATA UPLOAD,BUT STILL THAT TRANSFER IS MISSING.SO HOW CAN I GET THAT TRANSFER IN THAT PARTICULAR STORE.????PLZ HELP ME TO FIND OUT

*This post is locked for comments

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

    Your RMS version number please? RMS has a lot issues with inter-store transfers. Sometimes some items in the transfer will be missing or the Transfer itself missing.  

  • Community Member Profile Picture
    Community Member on at

    My RMS version is Version 2.0.1006

  • Community Member Profile Picture
    Community Member on at

    OK. Do you see the transfer in HQ? I mean in HQ Manager > View > Inventory Transfer Status report.

  • Community Member Profile Picture
    Community Member on at

    Ys, its showing,But  From PlacementStatus showing "Not Placed"

  • Community Member Profile Picture
    Community Member on at

    If it is in HQ, you may need to run some SQL to update HQMessage table to download this data to destination store.

    First get the ID of transfer from PurchaseOrder table. Then use below query.

    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

    or

    just Update PurchaseOrder / Entry tables by StoreID = StoreID and run a 401. (Find ID first and then do the update. Don't update all the records)

    Try to communicate the HQ Client again and see.

    Hope this will help you.

  • Community Member Profile Picture
    Community Member on at

    OK.Thanks I will try this and get back to u..Actually Why this happend ?

  • Community Member Profile Picture
    Community Member on at

    I tried this query..it shows 0 rows affected.

  • Community Member Profile Picture
    Community Member on at

    I am not sure whether you are good in SQL. Did you use the same SQL which I gave you? didn't you change the autoid accordingly? did you try to update the DBTimeStamp? I have been using this for years to correct the transfer missing issues. But I am afraid, I can't explain all the steps one by one. The logic can vary w.r.t situations.

  • Community Member Profile Picture
    Community Member on at

    Actually i had this query before and i did it for last time.No i didnt try to update anything in DBTimestamp.

  • M. Abbasi Profile Picture
    M. Abbasi 15 on at

    Actual problem is a time and Date Difference between two Stores.

    Make sure the Date is same at all the stores. 

    The best way to avoid this problem is Always change the Transfer Time at least one hour before the actual time of Transfer.

    I hope this will solve your problem.

    Thanks

    JA 

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