🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: alt.comp.software.financial
Article #88

Re: QBP 99 merge problem

#88
From: mblockNO_SPAM
Date: Mon, 26 Jun 2000 00:00
66 lines
2899 bytes
On Sun, 25 Jun 2000 20:05:59 GMT, jpharroun@my-deja.com wrote:

>snip, as you put it...
>>
>> Except for the Accountants Review Copy, QB does
>> not have practical way to merge the files.
>
>OK, so there may be some 'impractical' ways of pulling this off?  I
>mean, my guess is that there would be some sort of 'hacker' type of
>means to pull raw data from the guts of one file and 'transplant
>them' into the other.
>
If there was a reasonable alternative to manual entries I would 
have suggested it. QB only exports lists, not transactions. You
can get an audit trail report, Customize it for all transaction types
and fields you want and "print it" in Excel format. However, you
still need to make manual entries, so you may as well simply 
print invoices or sales entries on paper.

I did not tell you everything because it was impractical for a 
one-time transfer. http://datablox.com/ has a very good QB to
Access transfer utility. Access can produce transaction data
in QuickBooks IIF import/export format. However, you have
sales transactions and I believe there is no IIF import 
transaction type for sales. 

mike block

>I mean, my only other choice, and on which I have already begun, is to
>export to excel specific reports on each set of data types (i.e.
>invoices, checks, payment, etc.), then re-enter these sets of data.
>
>>Very few programs have something like ARC and this
>> part of QB is very limited.
>
>I am unfamiliar with ARC

Sorry, Accountants Review Copy.
>
>Thanks again for your assistance.
>
>JP Harroun
>The Grateful Bread Company
>Maui, Hawaii
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>

  Mike Block, Tax Fighting C.P.A.
 World's #1 QuickBooks Top Tester
  FREE 462p QB book/error codes/
80 QB add-ons http://blocktax.com/
QB no-spam news:biz.comp.accounting
-----------------------------------
Spam bait (credit E. Needham):
 root@localhost
 postmaster@localhost
 admin@localhost
 abuse@localhost
 webmaster@localhost
 postmaster@127.0.0.1
 enforcement@sec.gov
 cyberfraud@nasaa.org
Technical Details
Message-ID: <395bded2.781211609@news.mindspring.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <8j421v$72j$1@nnrp2.deja.com> <395832ec.737199009@news.mindspring.com> <395765e4.750249344@news.mindspring.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffcb3,bb09f21f11c184eb
X-Google-Attributes: gidffcb3,public
X-Google-Thread: fbe20,d8c9361808f3c340
X-Google-Attributes: gidfbe20,public
From: <mblockNO_SPAM@blocktax.com> (Mike Block, Tax Fighting C.P.A.)
Subject: Re: QBP 99 merge problem
Date: 2000/06/26
Message-ID: <395bded2.781211609@news.mindspring.com>
X-Deja-AN: 638985026
Content-Transfer-Encoding: 7bit
Approved: mblock@blocktax.com
References: <8j421v$72j$1@nnrp2.deja.com> <395832ec.737199009@news.mindspring.com> <395765e4.750249344@news.mindspring.com>
Organization: MindSpring Enterprises
X-Server-Date: 26 Jun 2000 05:14:42 GMT
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: alt.comp.software.financial,biz.comp.accounting