1. There is no need to create additional customer and supplier transactions as movement information is recorded in the system stock audit trail, and it is possible to run movement reports to ascertain usage. Many users have requested an on-screen view of usage history and this is something we are looking into for a future release.
2. This is not a problem, it is by design. Remember that you can create assemblies without work orders. A work order must be issued first. In the past it was not possible to transfer work order notes to a newly created assembly task because the work order does not exist at the time the assembly is created. In the latest version of CAPITAL, if a template contains work order notes, you are now asked if you also wish to create a work order. If you do this, work order notes are then copied into the new assembly. By the sound of things you do not yet have a version available to you that incorporates this behaviour. (Tech Support, the Development Team and some Resellers operate versions of CAPITAL later than the official release.)
3. This is not a 'corruption' in the database. Some fields or sections of fields may be reserved for internal use or for future use. That usage may not be obvious to you. Right now it is difficult for us to justify making extensive modifications to our software simply to workaround functional limitations in some third-party tools, particularly with so many good ideas internally and from our users, waiting to be implemented. This is not to say we're not aware of the issue, but altering the structure of this table in this area involves a significant and risky change, so it is not something we are planning to do in the immediate future.