One of the elements that keeps consulting work interesting is uncovering new or hidden features within the application your working with. At one of my recent clients, I discovered a piece of functionality that I have never played with before and thought it was useful enough that I would like to learn more about it [...]
The problem occurs when running the 7.4 packaged migration scripts on a version of Transport that does not have the ord_item table. Migrating data from say, the ord_qty table into the ord_item table requires the script to ‘dummy’ an Item to keep the relationship between the Order & Item intact - where previously none existed.