I haven't looked at QBXML yet. First seeing if I have to use QBXML or if there is another way.

In QB I exported the list: Chart of accounts to an IIF file, which I could open in Excel.

There is a field REFNUM which looks unique. Did a search but couldn't find anything to confirm it.

Do you know if REFNUM be used as a reference to an account?

Cyril


>I was of the impression that QB prevented you from creating accounts, customers, jobs, classes, etc... with a duplicate name. So your customer names for example had to be unique. Granted in your situation, that doesnt help much if the user changes the account name after previously exporting.
>
>If you are using Intuit's QBXML, each transaction, record, account, class, customer, job, etc... has an internally set QBID value assigned when the data is created in QB. You could use that but i dont believe its available to the QB end-user via an "export to excel" type option.
>
>>Any QB experts here?
>>
>>The data I need is in the trial balance, which I can export to Excel, and from there to my VFP application. Easy enough.
>>
>>When QB is setup to use account numbers, the Excel file includes account numbers. However, in QB the user is not obliged to use account numbers. When they are not used:
>>
>>Next time I import the data into my VFP application, I want it to update the same record in my VFP application. However, without an account number I don't know how to match it up!
>>
>>Is there a way that I can identify the QB account on each line of the trail balance report so my VFP application can handle it correctly?
>>
>>
>>Cyril