You will have many issues doing this externally with only this update query. Better to do it in the macola user interface, print the POs, which will update QOO, etc, write the trx records, allow you to close and purge, etc. Sounds like you are overdue for major data cleanup. Unless you know...