SQL to change pending HQ Inventory Transfer

I am looking for a quick way to change an inventory transfer order. Actually, what I want to do is transfer everything in inventory at one store to another store. I am a little irritated that I can't create a transfer order from HQ (or from the sending store for that matter) and just select the items from inventory that have quantity 0. This isn't one of the criteria offered when you select items by Filter. In addition, you can't specify the transfer quantities based on the quantity in stock.

Anyway, I need to find out what tables the non-approved transfer orders are in within the HQ database.

Better yet, I would love the SQL to accomplish what I need to do.

I intend to create a transfer order that includes all items with a quantity of 1. This is easy to do with HQ. Then, I want to tell HQ to set the transfer quantity equal to the sending store quantity.

If there is an easier way to do it at the store level, that would also work fine, but the transfer would need to originate from the store in that case.

Reply to
Jason
Loading thread data ...

Here's an idea for you...

Try setting the value of some unused field as your filter. For example:

UPDATE Item SET PriceB = 7.77 WHERE Quantity > 0

Then use PriceB = 7.77 as your filter for WS330.

If PriceB doesn't work for you, you could choose a different field from the list of filterable fields for the WS330 filter.

After you have received the transfer order, you could: UPDATE Item SET PriceB = 0

Hope that helps, Tom

Reply to
Terrible Tom

That's a good idea. That will let me get only items where qty 0 onto a transfer order. Half of the problem is solved!

Unfortunately, I still need to change the quantity of each item on the transfer order to equal the quantity in stock at the sending store. Note: I am assuming the HQ snapshot quantity is correct in this scenario.

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.