web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / receveing transfers
Microsoft Dynamics RMS (Archived)

receveing transfers

(0) ShareShare
ReportReport
Posted on by Community Member

If store A received a transfer from store B

example :

Store  B Sent " 6 misc items" to store A

Store A received 3 items (3 lost in transit or stolen or employe miscalc'ed let's say)

Store A transfer shows (RCVD 3, for 6 items)

 

Store B never knows about it......

HQ manager never knows unless one looksup all transfers and checks...

Any way to know if somehitng is not adding up ?

 

*This post is locked for comments

I have the same question (0)
  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    I'm not aware of any built in way to check this short of looking at individual past transfers in HQ. The best solution would be to write a custom report in HQ, but for a quick fix you could run this query in HQ Administrator (assuming you have "Automatically create receive inventory order" enabled in HQ manager configuration) :

    SELECT PONumber, Itemdescription, quantityordered AS 'Quantity Sent', quantityreceivedtodate AS 'Quantity Received', (quantityreceivedtodate - quantityordered) AS 'Delta' FROM purchaseorderentry JOIN purchaseorder ON purchaseorderentry.purchaseorderid = purchaseorder.id AND purchaseorderentry.storeid = purchaseorder.storeid WHERE potype = '2' AND status = '2' AND quantityreceivedtodate <> quantityordered

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    Note that this will not find transfers originated through worksheet 330 in HQ. To find these you would need to replace

    WHERE potype='2'

    with

    WHERE (potype='2' OR potype='4')

    complete with the parentheses.

  • Alwani Profile Picture
    Alwani 710 on at

    I had similar issue and I solve this by creating one transit store inside my real store, so instead of shipping to directly to store, I shipped this to transit store and from there first received it and then ship the actual qty received to my real store, I know this is kind of big job but can be done some customization to over come on this.

    Let me know what help you need to setup this configuration. Else you can write some script which will not update the store A, when Store B received only 3 out of 6 being ship.

    With Transit store concept you can always have balance in that store if there is discrepancies, easy to track.

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December 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