Hi All-
I am working with Quickbooks Premier 2005. This is my situation: I have lots of Memorized Transactions. To create an Invoice for a customer, I go into the Memorized Transactions List and double-click on the customer. A new Invoice pops open with some per-defined items already filled in (the "Item", "Cost" and "Rate" headers are filled-in
-- but the "Quantity" header isn't filled in).
Now I have some data in an external database -- that has the Quantity for all the items. I would like to know if there is any way to import this external data into Quickbooks, so that, when I double-click on a customer from the Memorized Transactions List, all the external data will also be filled-in for all the customers. (example, the Quantity of the items are filled-in for all the customers). Is this possible with Quickbooks imports?
I searched the Web, looked in Quickbooks Help files, searched Quickbooks Knowledge Base -- but couldn't find out how to do this via .IIF files. [BTW, support or even details about the .IIF files seems thin-stretched.] I also downloaded the SDK -- that didn't help much either. Am I missing something fundamental here or is it that Quickbooks can't do such a thing?
Can any of the third-party solutions do this?
Another solution to this problem would be to extract all the items from the Memorized Transactions and each month re-import them along with the data that changes. But even with this I was having difficulty -- I wasn't able to select a customer and open their invoice and have all the imported data right there -- I don't want to select the item from the drop down list -- I want it automatically filled in, from the imported data.
I got Quickbooks support -- they weren't of any help at all with this problem.
Thanks for any help!