1. Home
  2. Point-Of-Sale Software
  3. Transferring EVERYTHING from one store to another

Transferring EVERYTHING from one store to another

I would like to transfer all inventory from one store location to another. There is no filter option in the HQ Inventory Transfer Style 330 to add all items that have Quantity 0, so I can't even limit the PO creation to items that are in stock! The only way I think I can do this is to manually add items or add all items and then manually input the quantities.

I need help badly. This is another shortcoming of RMS - how can they not have the filter allow Quantity as one of the filter fields? And why does it not give the option to trandsfer based on the quantity at the from location? Strange.

Here is my thinking - add all items to a transfer order (HQ Planner). Then, using SQL, change the order quantity to the quantity in stock. Next, delete all items from the transfer order that have Quantity = 0 using SQL.

Can someone help me out with the SQL statements required?

Reply to
Jason
Loading thread data ...

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.

Reply to
Afshin Alikhani

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?

Reply to
Jason

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?

Reply to
Jason

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...

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.