Is there a way to get all the items from a PO and make a Transfer Inventory Out Order with those same items? If not, how would I go about creating my own customization to do this? I know how to query tables and such in SO Administrator, but I don't know how to make that into software to copy the information from the PO to a new TO. And would it be safe to modify the database in this way, creating a new TO with items? I would obviously create a test environment for this. I know that from a PO# I can query the PurchaseOrder table to get the ID. I would then query the PurchaseOrderEntry table, filtering out all data without that ID, and use that data to create a new TO with that data. Would this work?
- posted
14 years ago