Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
QuickBooks Transactions
Message
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00460711
Message ID:
00460819
Views:
16
>In one place it said the minimum required fields were trnstype,acct, and amount - that's why I tried the small file that I emailed you earlier.

I would think a date would be a minimum requirement as well. In fact, if you aren't supplying a date, you might want to check if the transactions maybe did get imported and are sitting at the top of the register. If the register's in date sequence then blank dates would sort to the top, and if you're looking for them at the bottom they wouldn't be there. This happened with a client of mine one time.

Minimum required fields aside, you might still need to use all the field headers in the header records, and use placeholders (tab characters) for the unused data fields in the detail records. FWIW I always create the import files this way and they always work (at least so far).

>...If I use account names that are not in the existing chart of accounts, it does create new account entries for them - but the balances still do not change.

So this suggests that the file is being processed correctly. Hmmmm.... the only other thing I notice is that on my file (again, this is the QB 2000 spec) there are two amount fields in the split record, amount and price. Maybe both are needed?

> I tried calling Intuit, but they said they did not offer support for this process.

Well, no big surprise there. I'm sure we can figure this out without them, though.
Rick Borup, MCSD

recursion (rE-kur'-shun) n.
  see recursion.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform