×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Importing Sales Journal ... Locked Out ... PT2004

Importing Sales Journal ... Locked Out ... PT2004

Importing Sales Journal ... Locked Out ... PT2004

(OP)
I have a "minimum" Sales Journal field list setup in order to import sales into PeachTree 2004. I did a backup just before running the import routine. The Sales Journal came in just fine so I am sure that the procedure I'm using is correct. I did notice a problem with 1 entry that would not import.

Subsequently, I rebooted the computer, and I did a "restore" to the data to get back to square one ... then  tryed running the import again. Now for some reason, I got error messages saying there was something wrong with the "DUE DATE" field in Line #2. I certainly can't see any problems with my file. When opening it in Excel, it looks fine.

Now I get a messages saying "Can't Open C:\sales.csv file for Importing".

I recreated the import CSV file again, giving it another name.
Same result.

It seems as if Peachtree has locked out the importing functions.

Has anyone seen anything like this ??

Here's the beginning of my CSV file and one Sales Journal Entry:

Customer ID,Invoice/CM #,Date,Date Due,Accounts Receivable Account,Sales Tax Code,Number of Distributions,Description,G/L Account,Tax Type,Amount,Sales Tax Authority
DomU,21079,01/31/06,03/02/06,1200,NP,4,"Non Profit Sales",2390,0,0.00,NP
DomU,21079,01/31/06,03/02/06,1200,NP,4,"115,000 - 26th Annual Benefit Tickets 7/book",5007,1,-1249.57,NP
DomU,21079,01/31/06,03/02/06,1200,NP,4,"6272 - Additional Annual Benefit Tickets",5007,1,-68.65,NP
DomU,21079,01/31/06,03/02/06,1200,NP,4,"30863 - Additional  Annual Benefit Tickets",5007,1,-335.64,NP


Thank you ....

RE: Importing Sales Journal ... Locked Out ... PT2004

Did you map your fields in Peachtree's import Sales Journal to the CSV file you have?

RE: Importing Sales Journal ... Locked Out ... PT2004

(OP)
Thanks blueboyz for replying ....

I found the problem ... I had a carriage return + line space in the invoice description field. The import routine burped!
The import program didn't recognize it as a proper CSV format.

Jim

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close