Search Again:

More Quickbooks 2003 woes

From: Jeff Folk
Date: Thursday, September 25, 2003
Time: 1:27:21 pm

Hi;

Actually, this is my first addition to the Quickbooks import subject, but I
can't get it to work either. Personally, I can't stand Quickbooks, but my
employer made the decision...

Is anyone out there using accounting codes for their sales items (I actually
have accounting codes for some, but not others, for my Texas Sales Tax
report) and are able to import to Quickbooks (2003)? Any guidance would be
greatly appreciated. I'm used to dealing with "real" general ledger
programs...

When I import, I get an error stating that I can't associate sales tax with
a customer. Here is a sample of the import file:

!TRNS,TRNSID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,TOPRINT
,NAMEISTAXABLE,ADDR1,ADDR2,ADDR3,ADDR4,DUEDATE,TERMS,OTHER1

!SPL,SPLID,TRNSTYPE,DATE,ACCNT,NAME,CLASS,AMOUNT,DOCNUM,MEMO,CLEAR,QNTY,PRIC
E,INVITEM,PAYMETH,TAXABLE,VALADJ,SERVICEDATE,OTHER2,EXTRA

!ENDTRNS

TRNS,1,INVOICE,1/2/03,Accounts
Receivable,mkemp,,644.08,021217-0001,,N,N,Y,"Kemp Financial Services","Mark
Kemp","500 North Water St., STE 701","Corpus Christi, TX 78471",1/28/03,,

SPL,1,INVOICE,1/2/03,"4010","",,-594.99,,"CPE, 2.6 GHz,
Ethernet",N,-1,594.99,"2600E",,Y,N,,,

SPL,2,INVOICE,1/2/03,"Sales Tax Payable","Comptroller of Public
Accounts",,-49.09,,"",N,,8.25%,"",,N,N,,,AUTOSTAX,

ENDTRNS

!TRNS,TRNSID,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM

!SPL,SPLID,TRNSTYPE,DATE,ACCNT,NAME,AMOUNT,DOCNUM

!ENDTRNS



Thanks;

Jeff


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.521 / Virus Database: 319 - Release Date: 9/23/2003


---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------



Messages In This Thread:



Return to Digital Point Solutions' Home Page