Looking for a reasonable process to handle converting dropships to backorders inside of Great Plains - currently have to delete the Sales Document - PO link, delete the PO, convert items to backorder on sales document, recreate the PO.
Have not been able to come up with any process in Great Plains that handles this efficiently. (Is there a trick I am not aware of?)
Alternative is to handle via SQL - anyone have a SQL Script that can take an open dropship order with links to an open dropship PO and convert to a backorder? Any guidance in creating one? (Could not find a reference this process on typical GP Research sites). Would also consider outsourcing the script.
After running script:
Sales line orders go from Dropship to Backorder Status. Linked PO. Shipping address on PO changed to hardcoded value / default warehouse shipping address)
For use on new open dropship orders where nothing has been received yet.
Thank you