Budget Friendly Bookkeeping
Level 5

Importing Rules turns off Auto Add flag with no method other than to change them back one at a time

Upon exporting Rules of a Client's database for business reasons and deleting them from the live file, it was noticed that after importing them, all of the Rules had the Auto Add flag set to the Off position.  Thinking this was nothing more than making the list Active since it showed Disabled, would fix this, unfortunately it did not.  Now, either we need to go through hundreds of Rules and edit them to turn on this flag on or is there  perhaps some coding that can be done in the Excel spreadsheet to make this flag Active?

If not, this is a very poor routine to have created without giving any warning what-so-ever to the user before its use which will create a lot of wasted and unbillable time.

 

Thank you for your any help you can give to this query.