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.