Welcome, Guest. Please Login.
05/25/25 at 13:27:15
News:
Home Help Search Login


Pages: 1
Send Topic Print
Importing Chart of Accounts (Read 487 times)
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
Importing Chart of Accounts
04/12/06 at 08:33:01
 
I am trying to import a chart of accounts into a new company - basically exported COA from an existing Co, editing it and then importing. All I want is CODE, Descrip, Type & Non-Cash fields. When I run an error check (with errors only) all account codes are listed with no other information and the file will not import.
 
Am I missing required fields? Can anyone else duplicate this?
 
Keith
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Importing Chart of Accounts
Reply #1 - 04/12/06 at 08:52:00
 
Code and Type should be all you need.  Even Description is technically optional.  You are using numbers or upper case text for the Code and upper case A, L, O, I and E for the types?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
Re: Importing Chart of Accounts
Reply #2 - 04/12/06 at 09:52:43
 
Codes are numbers and types are upper case letters. I am really not changing anything, just deleting A/C's I don't want. Like I said I exported COA and tried importing the export as is and it still didn't work. I am using a Comma Delimited file and using only the first column representing the corresponding spreadsheet column.
 
Correct?
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Keith
Full Member
***


I love YaBB 1G -
SP1!

Posts: 106
Re: Importing Chart of Accounts
Reply #3 - 04/12/06 at 10:18:50
 
OK, I'm tired I was importing the TXT version and not the CSV file.
 
Sorry for wasting your time undecided
 
Keith
Back to top
 
 

Keith Ruskay
AI-TEK Instruments, LLC
Version 2004.1 IS Tech Support Update 05/08/06
kruskay   IP Logged
Pages: 1
Send Topic Print