Transferring EVERYTHING from one store to another

We are doing a small development so that after you create the transfer it controls what is being transferred and will not allow the items that are not avialble to be transferred. If you wish more info just contact me.

I'm interested if it does exactly what I need - transfer all inventory from one store to another.

It's a one-time deal - probably not worth the price of an add-in.

On that note, I can't even figure out what HQ table the unapproved transfer order is in so I can play with it... Any help?

I found the table that holds the unapproved transfer order: Worksheet_PurchaseOrder

I am getting close, but I can't figure out how to set up the joins to update the quantity. Here is what I have so far:

UPDATE Worksheet_PurchaseOrder SET Worksheet_PurchaseOrder.QuantityOrdered ItemDynamic.Quantity WHERE Worksheet_PurchaseOrder.ItemID = Item.ID AND ItemDynamic.ItemID Item.ID AND ((Worksheet_PurchaseOrder.WorksheetID966) AND (ItemDynamic.StoreID4) AND (ItemDynamic.Quantity0))

Any SQL gurus out there?

I came up with an alternative.

I downloaded the information I needed into Excel from these linked tables:

Worksheet_Purchaseorder ItemDynamic

The columns I needed were Worksheet_PurchaseOrder.WorksheetID, Worksheet_PurchaseOrder.ItemID, ItemDynamic.Quantity

I set the criteria to only show the ItemDynamic data from the "FROM" store.

Then I created another column with a bunch of text trings and cell links together to make UPDATE statements that looked like this:

UPDATE Worksheet_PurchaseOrder SET QuantityOrdered = 48 WHERE WorksheetID 16966 AND ItemID = 2 UPDATE Worksheet_PurchaseOrder SET QuantityOrdered = 100 WHERE WorksheetID 16966 AND ItemID = 4 etc.

I just copied and pasted the UPDATE statements into the HQ Admin SQL box and updated the Worksheet_PurchaseOrder table as needed.

Worked great. Not elegant, but job done...