A while back I wrote a new macro to import IIF transactions, New Excel Macro to import IIF transactions. Last week I put it to the test and found several bugs. All of the bugs were minor but annoying. They created a lot more work for me but I am hopeful the next time I test this macro, it will save me time. Most of my bugs were spelling issues. I used different spellings on one customer and I forgot to include the group item. Naturally the spellings are very important if you want the invoices to end up with the right customer and account. The sneakiest bug was the one I got when I started a row with TRN rather than TRNS. QuickBooks complained about an out of place SPL row rather than pointing out my transaction should have started with TRNS rather than TRN.
Related posts:
- New Excel Macro to import IIF transactions
- Problems importing IIF transactions into QB2004
- Excel Tip: Converting CSV files into IIF files
- Using VBA to create import files for QuickBooks
- Excel Round time to the nearest quarter hour
Related posts brought to you by Yet Another Related Posts Plugin.
1 response so far ↓
1 David Kelly // Dec 4, 2006 at 9:27 pm
Sounds like a very, very cool macro. Is this something you can share?
David
Leave a Comment