I have a ton of jobs in my company that are open because of an AP invoice from years ago that may be off by a few dollars. This discrepancy does not allow me to delete parts or assemblies in my database.

There are parts and assemblies from 6+ years ago that I no longer need but I can't delete them because of a 6 year old invoice that has the part on it that is off by $5.

There needs to be an override for this. I understand the way the tables are all linked in SQL database format. However, when wanting to delete an old part, there should be a 'replacement/filler part' that fills in the line item for the conflicting reference so that the part can still be deleted and not damage the table relationships.

Same goes for assemblies. I have dozens of assemblies that can't be deleted because there are takeoff references for them from jobs that are 6 years old. And since I can't delete the assembly, I cant delete the class either.

This is a major pain and I wish I could go back to v19 when this was still possible.

by: JJ S. | over a year ago | Estimating