Skip to main content

Notifications

Microsoft Dynamics RMS forum

TRANSFER IS MISSING IN ONE STORE

Posted on by Microsoft Employee

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

  • Jayvincom876 Profile Picture
    Jayvincom876 50 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    What do you do if you do not see the transfer in Headquarters to get autoID?

  • Jayvincom876 Profile Picture
    Jayvincom876 50 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    I tried this query on my database no results returned...my transfers are only partial and i need to complete them.

    ANY ASSISTANCE PLEASE

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    Could you please run this query and tell me the exact result:

    SELECT  fromstore.StoreCode AS FromStore ,

           CASE WHEN tostore.StoreCode IS NOT NULL THEN tostore.StoreCode ELSE 'No tagged rcvng store' END AS ToStore,

           CASE po.Status when 0 THEN 'OPEN' WHEN 1 THEN 'PARTIAL' WHEN 2 THEN 'COMMITTED' END AS TransferOutStatus,

           po.PONumber, CASE h.STATUS WHEN 2 THEN 'TO DOWNLOAD' WHEN 3 THEN 'RECEIVED' ELSE CAST(h.STATUS AS NVARCHAR) END AS RcvngStore_Status, COUNT(DISTINCT pe.ItemID) AS Total_TransferOut_Items

    FROM    dbo.PurchaseOrder po

           LEFT JOIN dbo.HQMessage h ON h.FromStoreID = po.StoreID

                                        AND po.OtherStoreID = h.ToStoreID

                                        AND po.ID = h.AttachmentID

                                        AND h.Style = 2

           LEFT JOIN store tostore ON tostore.ID = po.OtherStoreID

           LEFT JOIN dbo.Store fromstore ON fromstore.ID = po.StoreID

           LEFT JOIN dbo.PurchaseOrderEntry pe ON pe.PurchaseOrderID = po.ID AND pe.StoreID = po.StoreID

           WHERE po.POType = 3 AND

           -- now insert the values required between the two single quotes

           fromstore.StoreCode = '' AND tostore.storecode = '' AND po.PONumber = ''

           GROUP BY fromstore.StoreCode, tostore.StoreCode, po.Status , po.PONumber, h.STATUS

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: TRANSFER IS MISSING IN ONE STORE

    I HAVE DONE THIS ALSO...

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    Once you do the above instructions, try to open and update the transfer from receiving store. In this case, the database timestamp will be updated and will be hooked up the next sync.

    Run data upload then check hq for transfer status.

  • Suggested answer
    archelle16 Profile Picture
    archelle16 1,735 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    Have you done this?

    1. Create and approve the transfer out.

    2. Check items included in transfer out. Items must be present in receiving store. If not, hq must issue worksheet to download the items.

    3. Sync receiving store to download the items first.

    2. Contact HQ to issue data upload both for reference and receiving store.

    4. Make sure data upload of reference store has been worked out first.

    5. Determine if HQ got the reference store's transfer out by checking hq reports or by this sql query:

    DECLARE @storecode AS NVARCHAR(20)

    DECLARE @ponumber AS NVARCHAR(20)

    SET @storecode = 'Enter reference storecode between this single quote'

    SET @ponumber =  'Enter reference ponumber between this single quote'

    SELECT  fromStore.StoreCode AS FromStore, toStore.StoreCode AS ToStore, dbo.PurchaseOrder.PONumber AS ReferncePO,

    dbo.PurchaseOrderEntry.ItemDescription,dbo.PurchaseOrderEntry.QuantityOrdered,

    CASE dbo.HQMessage.Status

    WHEN 2 THEN 'To Download' WHEN 3 THEN 'Received' END AS Status

    FROM    dbo.HQMessage

           INNER JOIN dbo.PurchaseOrder ON dbo.PurchaseOrder.ID = dbo.HQMessage.AttachmentID

                                           AND HQMessage.FromStoreID = dbo.PurchaseOrder.StoreID

                                           AND dbo.HQMessage.ToStoreID = dbo.PurchaseOrder.OtherStoreID

                                           AND dbo.PurchaseOrder.POType = 3

                                           AND dbo.PurchaseOrder.Status = 2

           LEFT JOIN dbo.PurchaseOrderEntry ON dbo.PurchaseOrder.StoreID = dbo.PurchaseOrderEntry.StoreID

                                               AND purchaseorder.ID = dbo.PurchaseOrderEntry.PurchaseOrderID

           LEFT JOIN dbo.Store fromStore ON fromStore.ID = dbo.HQMessage.FromStoreID

           LEFT JOIN dbo.Store toStore ON toStore.ID = dbo.HQMessage.ToStoreID

    WHERE   fromStore.StoreCode = @storecode AND dbo.PurchaseOrder.PONumber = @ponumber

    4. Sync receiving store to receive the transfer out.

    5. Check receiving store if transfer out has been received.

    If not, execute the query again above and see the status of transfer out.

    if status = "Received",

    you can redownload the transfer out by updating its status in hq:

    DECLARE @storecode AS NVARCHAR(20)

    DECLARE @ponumber AS NVARCHAR(20)

    SET @storecode = 'Enter reference storecode between this single quote'

    SET @ponumber =  'Enter reference ponumber between this single quote'

    UPDATE dbo.HQMessage SET HQMessage.Status = 2

    FROM    dbo.HQMessage

           INNER JOIN dbo.PurchaseOrder ON dbo.PurchaseOrder.ID = dbo.HQMessage.AttachmentID

                                           AND HQMessage.FromStoreID = dbo.PurchaseOrder.StoreID

                                           AND dbo.HQMessage.ToStoreID = dbo.PurchaseOrder.OtherStoreID

                                           AND dbo.PurchaseOrder.POType = 3

                                           AND dbo.PurchaseOrder.Status = 2

           LEFT JOIN dbo.PurchaseOrderEntry ON dbo.PurchaseOrder.StoreID = dbo.PurchaseOrderEntry.StoreID

                                               AND purchaseorder.ID = dbo.PurchaseOrderEntry.PurchaseOrderID

           LEFT JOIN dbo.Store fromStore ON fromStore.ID = dbo.HQMessage.FromStoreID

           LEFT JOIN dbo.Store toStore ON toStore.ID = dbo.HQMessage.ToStoreID

    WHERE   fromStore.StoreCode = @storecode AND dbo.PurchaseOrder.PONumber = @ponumber

  • M. Abbasi Profile Picture
    M. Abbasi 15 on at
    RE: TRANSFER IS MISSING IN ONE STORE

    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 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: TRANSFER IS MISSING IN ONE STORE

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: TRANSFER IS MISSING IN ONE STORE

    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 Microsoft Employee on at
    RE: TRANSFER IS MISSING IN ONE STORE

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

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