Hello all,
Is there any permanent fix for the Missing Inter-Store transfer bug in RMS?
Regards,
Sam.
*This post is locked for comments
Moataz Mohamed,
Do you have Automatically create inter-store receive inventory order and Automatically create inter-store issue inventory order checked off in HQ Manager configuration? Let me know and I'll try to help out.
Sincerely,
Chris
Please help me
i Have a problem in warehouse not uploading the transfer ?
If it is not a bug what is it? A feature?
Use the following sql script...you'll notice near the end there is the following line with a date...
po1.otherpoid = 0 and po1.DateCreated = convert(datetime, 'may 17 2013 00:00AM')
Change the date in that field to pull transfers that are 'in limbo' for a specific date. The sql script on the post I mentioned earlier should pull transfers that are in limbo for the current month up to the previous day(won't pull the current day's missing transfers which is why I modified the script to pull for a specific date. I prefer to check this on a daily basis in the morning and afternoon.)
Hope this helps.
po1.StoreID,po1.POTitle,sum(e.quantityordered) as Qty,
sum(e.quantityordered*e.price) as Total,
Department.Name,po1.DateCreated,po1.LastUpdated,po1.PONumber,po1.[shipTo]
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 e WITH(NOLOCK) ON po1.ID=e.PurchaseOrderID AND
po1.StoreID = e.StoreID
LEFT JOIN Item WITH(NOLOCK) on e.ItemID=Item.ID
LEFT JOIN Department with(NOLOCK) on Item.DepartmentID=Department.ID
where po2.id Is Null and po1.otherstoreid > 0 and po1.status=2 and
po1.otherpoid = 0 and po1.DateCreated = convert(datetime, 'may 17 2013 00:00AM')
group by
po1.StoreID,po1.POTitle,Department.Name,po1.DateCreated,po1.LastUpdated,po1.PONumber,po1.[shipTo]
Order by po1.PONumber asc
well... I use query and it work like charm!
This query will show you which POs are stuck in the system. And get the AutoID from table once it creates it!
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
Step 2 - enter AutoID# below and it will work!
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
I wish MS come out with a hotfix to fix this automatically though.
i have the same problem anyone know how to solve this cause its really bad for your reports
dcbailey, i checked out that thread and somehow step1 query shows me all OPEN POs or transfer in/out. Have anyone used hotfix to solve this problem yet?
You may want to check this thread...
community.dynamics.com/.../142977.aspx
I also have transfer issues...mine seem to go "In Limbo" on days with heavy inventory transfers. I have 14 stores and 2 stores(set up as inventory warehouses.) Usually on Mondays when our store managers have placed orders to replenish stock from the weekend sales is when this problem occurs for me. On days with light transfers the same shops will get their receive order with no problem.
At any rate the SQL scripts in the thread above are the only fixes I've found that work.
Hi Keith,
Thanks for your response.
No, i have not seen the article. I will check and revert.
Cheers!
Sam.
Hi samuraiDXB,
Have you gone through the following KB article?
ArticleID: 911389.
You experience unexpected results when you try to process inventory transfers in Headquarters or in Store Operations
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