Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Invoices

Status
Not open for further replies.

bicyleman9008

IS-IT--Management
May 19, 2005
30
We are trying to import invoices into Peachtree.
The import of data returns no errors, but the data is all wrong in the system.

Our fields are:


* Customer ID
* Date (Invoice Date)
* Ship To Name
* Ship To Address1
* Ship To Address2
* Ship To City
* Ship To State
* Ship To Zip
* Ship To Country
* Customer PO (from I/O Number on Advertising Screen)
* Date Due (check the field, but we are not using it)
* Discount Amount
* Sales Rep ID
* GL account
* Number of Distributions
* Quantity Automatically calculated
* Item ID
* Item Description
* Revenue Account - on Export Screen
* Tax Type
* Amount - calculated automatically
* Sales Tax Authority
* Voided By Transaction - not used, but check it

In the invoice, I get NO:
Item
Description
Price

The entire sales amount is in the Sales Tax Column.

Here is a sample of my import file:

ACTDBB,1/25/2007,ACTDBB Inc,PO Box 80814,,Lafayette ,LA,70598, , ,,,EF,4000-00,2,0,GROSS,01/25/06-0.50 4C Iw Display Reg Frequency Rates ,1080-000,2,-643,LA
ACTDBB,1/25/2007,ACTDBB Inc,PO Box 80814,,Lafayette ,LA,70598, , ,,,EF,4000-00,2,0,COLOR,Color Charges,1080-000,2,-107,LA
ALLDUH,1/25/2007,Allen Duhe - Van Eaton,900 South College,,Lafayette ,LA,70503, , ,,,EF,4000-00,2,0,GROSS,0.17 4C Iw Display Rate Freq Rate 2 08/10/05 Issue ,1080-000,2,-235,LA
ALLDUH,1/25/2007,Allen Duhe - Van Eaton,900 South College,,Lafayette ,LA,70503, , ,,,EF,4000-00,2,0,COLOR,Color Charges,1080-000,2,-20,LA

Can anyone help.


Thanks,
Glenn A
 
I would try exporting the sales journal with column headings from a sample company first, like Bellwether. Then, open that file, sales.csv, in Excel and look how the data is placed and formatted.

When you are in the Select Import/Export window you can click on the HELP button. Then click on the arrow button in the paragraph: For a list of standard import/export templates, field names, and field requirements, click >.

Select the Sales Journal and you can see what fields can be imported and what is required and what format the data is for each field.

It could be that your file doesn't map with the way Peachtree needs it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top