Quote:
Originally Posted by wdfifteen
That's cool. I had no idea Excel was so powerful. This brings back memories of writing "if then else" lines in FORTRAN - on punch cards.
|
I was considering writing some visual basic but thought Excel must have come along way by now, thanks again to Aggie!
Quote:
Originally Posted by berettafan
suggest considering quickbooks for a/r if not already doing. it can do late fees, monthly statements, etc. very easily. also exports reports to excel.
can even email statements/invoices to customers.
|
Excellent suggestion, I use QB for all bookkeeping but we created a custom Access db for our order entry and invoicing that also does inventory. We did this before we bought QB and someday I'll figure out how to create seasonal SKUs in QB so it's all in one system and I won't have to jump through these hoops. What I like about the current one is generates nice reports, exactly as I want them which can be exported to Excel. So I have to invest the time into quickbooks to generate the same reporting, and I am sure if will even be better than what we have now.