Spent 6 hours on a Friday trying to sync 14 change orders into our PM software and got nowhere
I told the super I'd have the change order log updated by end of day last Friday so he could send it to the owner's rep. Two of the COs were missing attachments in the system and the other twelve wouldn't pull the right cost codes no matter what I did. I tried importing a CSV three different times, then re-entered six of them by hand, then called support and sat on hold for 40 minutes. Turns out the issue was a duplicate project ID left over from when our GC merged two jobs back in March and nobody cleared it out. The tech on the phone said he'd seen it twice this year, so apparently it's a known thing but not documented anywhere. I ended up exporting everything to a spreadsheet, fixing it there, and emailing it at 9pm on a Friday. Has anyone else run into duplicate project IDs after a job merge, and is there a way to catch this before it wrecks a whole afternoon?