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
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