|
Posted by dpb on July 23, 2009, 12:46 pm
Please log in for more thread options
Mel_3 wrote:
> I'm attempting to migrage someone from an old custom COBOL application
> to quick books.
>
> I've extracted all the records as comma delimited files.
>
> Customer Records
> Products
> Orders (Contracts)
> Payments (some customers pay for products via a payment schedule)
> etc.
>
> Can I import these comma delimited files into QuickBooks?
> Can I associate the Customer Record with the Orders and Payments?
> Can I associate the Products with the Orders?
>
> There are about 4,000 customer records...
>
> - each having bought one or a few main products along with various
> associated products of lessor value.
> - each in various states of making their payments for the products
> purchased.
>
> Thanks for any help.
Only by using the data to build IIF (Intuit interchange format) files
which can be imported. There are significant limitations to what can
and can't be imported but the base data/transactions can be altho the
internal database links are _not_ established in transactions.
There have been two threads on IIF recently here that have the links to
the updated help files on the Intuit site; the subject was discussed
pretty thoroughly in them.
The other alternative is to use a 3rd party tool that makes use of the
SDK that is more capable than IIF; w/ that all the information of the
database can be recreated as if the data had been manually entered.
The problem w/ the SDK for the average user is it takes writing an
actual application to make use of it; for a developer there's always the
possibility of custom-building an app for the specific purpose if the
job will support it.
The links to the SDK are also in the two threads just mentioned...
--
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap