- February 2, 2011
- Posted by: Mary Brettmann
- Category: QuickBooks Enterprise
Don’t forget the power of the excel import function. Materials Processing needed to add the terms for about 10,000 customers to the customer terms field. It took hours to go from A-D. During my next visit, they asked if I could automate the process.
I exported the customer list into excel and then used the find and replace function. Most people don’t know that it is possible to search for an empty cell and replace it with a phrase. It worked flawlessly. In fact the whole process probably took a half-hour. Brandon was do happy the he exclaimed, “You just saved me 16.5 hours!”