Accountant Forums


Reply
Thread Tools

Peachtree Import and Custom Invoice

 
 
Melissa
Guest
Posts: n/a
Thanked:
 
      10-20-2005, 12:48 AM
Each month I receive an excel spreadsheet that contains information I need
to use to invoice my customers. I have tried to import this information into
Peachtree, but have not been able to do so. Is there a way to customize the
import utility? I also need to print a very detailed invoiced based on the
information that I import. Can anyone tell me where I can find the
information to be able to do this? I am also willing to pay a consultant to
set this up for me if anyone has a suggestion on who to use. I am in
Alabama.

Thanks in advance for any help.
Melissa


 
Reply With Quote
 
 
 
 
Laura
Guest
Posts: n/a
Thanked:
 
      10-22-2005, 02:25 AM
Melissa wrote:

>Each month I receive an excel spreadsheet that contains information I need
>to use to invoice my customers. I have tried to import this information into
>Peachtree, but have not been able to do so. Is there a way to customize the
>import utility? I also need to print a very detailed invoiced based on the
>information that I import. Can anyone tell me where I can find the
>information to be able to do this? I am also willing to pay a consultant to
>set this up for me if anyone has a suggestion on who to use. I am in
>Alabama.
>
>Thanks in advance for any help.
>Melissa
>
>
>
>

You will need to format that spreadsheet to correspond to the proper
column layout that peachtree requires.

I've done it for very basic invoices but I've never tried it on complex
ones. Output a sample invoice or 2 (File>>export) On the Accounts
Receivables tab select the Sales Journal entry and click on export. Then
go to the Fields tab and check only the necessary fields. Then go to the
Options tab and put a check mark in the "include headers" box. Now click
on okay. The output file will be c:\sales.csv. This file can be opened
up in excel. Experiment with your export until all of the fields that
your invoice spreadsheet are included. Then you need to get our invoice
spreadsheet in the same order as your export file. You might experiment
with setting up formulas to the right of your received data to create
the right output file. Hopefully this will get you started on your project.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Peachtree 2008 Read All Old Peachtree Files? Albert Peachtree Accounting 1 08-03-2007 12:45 PM
import invoice data in peachtree 2006 John Peachtree Accounting 0 12-15-2006 05:41 AM
Peachtree Custom Templates Jamesgang Peachtree Accounting 1 10-13-2006 10:10 PM
Peachtree Custom Invoice with Crystal Reports ToastyAlbus Peachtree Accounting 0 09-27-2006 10:59 PM
Item custom templates and custom feilds Bamboo Sticks in Gelly Quickbooks 3 08-27-2005 04:32 PM


All times are GMT. The time now is 11:50 PM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.