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
What do you do if you do not see the transfer in Headquarters to get autoID?
I tried this query on my database no results returned...my transfers are only partial and i need to complete them.
ANY ASSISTANCE PLEASE
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
I HAVE DONE THIS ALSO...
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.
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
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
Actually i had this query before and i did it for last time.No i didnt try to update anything in DBTimestamp.
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.
I tried this query..it shows 0 rows affected.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,802 Super User 2024 Season 2
Martin Dráb 229,129 Most Valuable Professional
nmaenpaa 101,154