11872292 - Invalid Column Name ParentID When Posting
An old project long since phased out created a table named BDOrderAppointments to store Service Pro order appointment information. Because the code has been removed no new databases have this table. However, databases that have been running BirdDog long enough do
have this table since the creation was removed but the table was not dropped. When we implemented Service Pro Exchange, a table with this same name was created with a different schema. This has been working fine against all of the newer databases we've run it against. When this code is run against an older database, the code sees that the table exists and moves on. This update fixes it to see that it is the old table, drop it, and then recreate it with the new schema. For customers who attempted to post invoices before this fix was applied and received the ParentID error, there is also a data cleanup script that has to be run because the post process seems to have posted everything correctly and failed at the point where it was removing the open order records.