Forums

Its not necessarily a bug, but make it absolutely sure the time and date is correct on all Server machines

Hi Jeff,

Thanks for the response.

HQ and Stores databases are in sync. ( no time differences ). Could there be any other reason for missing inter store transfers?

Regards,

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

support.microsoft.com/.../911389

Hi Keith,

Thanks for your response.

No, i have not seen the article. I will check and revert.

Cheers!

Sam.

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.

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?

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.

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