Mailing List Archive

QuickBooks/Interchange
Hey Everybody try and figure this one out:

I have started using the quicken import feature of IC and the first 3 order
that it placed in a file name date.iif worked GREAT. Then the 4th entry it
made it in there makes quickbooks fault everytime. I have looked at the
structure of that entry for about 2 days. I wont attach the said iif file
for everyone to look at. But for all intents and purposes I have not seen
any problems with the entry. I can remove the entire entry and it imports
fine. I can remove some of the items from the entry and the file wont cause
any problems. But the LAST entry will not be int he INVOICES. Any ideas?

Beriah
QuickBooks/Interchange [ In reply to ]
At 02:37 PM 1/3/01 -0600, you wrote:
>Hey Everybody try and figure this one out:
>
>I have started using the quicken import feature of IC and the first 3 order
>that it placed in a file name date.iif worked GREAT. Then the 4th entry it
>made it in there makes quickbooks fault everytime. I have looked at the
>structure of that entry for about 2 days. I wont attach the said iif file
>for everyone to look at. But for all intents and purposes I have not seen
>any problems with the entry. I can remove the entire entry and it imports
>fine. I can remove some of the items from the entry and the file wont cause
>any problems. But the LAST entry will not be int he INVOICES. Any ideas?
>
>Beriah

Your timing is fortuitous - I happen to working on a bilateral adaptation
of the trans_quickbooks file for a customer(adapt up to QB2000, adapt down
to MV3.14!) and I may be able to help you. The copy of trans_quickbooks
which I got from the CVS a couple of weeks ago uses [item-field title] for
the INVITEM field in the SPL (line item) records. It appears that if this
evaluates to longer than appox 15 characters, or blank, Quickbooks
crashes. I would try finding this area in trans_quickbooks and replacing
[item-field title] with [item-code], then delete the qb*.iif file, place
the last order again, and try importing again.

- Ed L.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
New Media E.M.S. Software Solutions for Business
463 Main St., Suite D edl@newmediaems.com
Placerville, CA 95667 http://www.newmediaems.com
(530) 622-9421 (530) 622-9426 Fax
(866) 519-4680 Toll-Free
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>