Since your remote data access is an iffy service that can find company files easily corrupted, you should have a utility to download and re-upload transactions from a repaired file. Your solution to your issue that makes us restore from backup and re-enter transactions is pretty weak solution. As a software company you should be aiming to make your software work for your customers, not showing how little you care about your customers.
Matthew John McAdam
