DTW - Illegal parent number - Chart of Accounts.

[former_member268939]

Hi, im trying to import the chart of accounts and having the illegal parent number in every row of the file, there is an example of what im doing.

PD: Im using TXT. Tab delimited.

I attached the file im trying to import, and bellow there is a example.

Code

Name

CashAccount

BudgetAccount

ActiveAccount

DataExportCode

FatherAccountKey

ExternalCode

RateConversion

TaxLiableAccount

TaxExemptAccount

AccountType

LoadingType

LoadingFactorCode

AcctCurrency

Protected

ReconciledAccount

LiableForAdvances

ForeignName

Details

ProjectCode

RevaluationCoordinated

LockManualTransaction

FormatCode

DefaultVatGroup

AllowChangeVatGroup

Category

TransactionCode

LoadingFactorCode5

LoadingFactorCode2

LoadingFactorCode3

LoadingFactorCode4

PlanningLevel

AcctCode

AcctName

Finanse

Budget

Postable

ExportCode

FatherNum

AccntntCod

RateTrans

TaxIncome

ExmIncome

ActType

OverType

OverCode

ActCurr

Protected

RealAcct

Advance

FrgnName

Details

Project

RevalMatch

LocManTran

FormatCode

DfltVat

VatChange

Category

TransCode

OverCode5

OverCode2

OverCode3

OverCode4

PlngLevel

1100000

ACTIVOS CORRIENTES

tNO

100000000000000

at_Other

tNO

1100000

1110000

EFECTIVO EN CAJA Y BANCO

tNO

1100000

at_Other

tNO

1110000

1111000

EFECTIVO EN CAJAS

tNO

1110000

at_Other

tNO

1111000

1111001

CAJA GENERAL

tYES

1111000

at_Other

tNO

1111001

1111002

CAJA CHICA FINCA

tYES

1111000

at_Other

tNO

1111002

1111003

CAJA CHICA FINCA ADM.II

tYES

1111000

at_Other

tNO

1111003

1112000

EFECTIVO EN BANCO

tNO

1110000

at_Other

tNO

1112000

1112001

BANCO POPULAR

tYES

1112000

at_Other

tNO

1112001

1112002

BANCO RESERVAS

tYES

1112000

at_Other

tNO

1112002

1120000

CUENTAS Y DOC. POR COBRAR

tNO

1100000

at_Other

tNO

1120000

1121000

CUENTAS POR COBRAR

tNO

1120000

at_Other

tNO

1121000

1121001

CLIENTES

tYES

1121000

at_Other

tNO

1121001

1121002

EMPRESAS RELACIONADAS

tYES

1121000

at_Other

tNO

1121002

1121003

FUNCIONARIOS Y EMPLEADOS

tYES

1121000

at_Other

tYES

1121003

1121004

AVANCES A PROVEEDORES

tYES

1121000

at_Other

tYES

1121004

1121005

PROVISION P/CUENTAS

tYES

1121000

at_Other

tYES

1121005

1122000

DOCUMENTOS POR COBRAR

tNO

1120000

at_Other

tYES

1122000

1130000

INVENTARIO

tNO

1100000

at_Other

tNO

1130000

1131000

INVENTARIOS ACTIVOS BIOLOG. PROC.

tNO

1130000

at_Other

tNO

1131000

1131001

MACHOS LACTANTES

tYES

1131000

at_Other

tNO

1131001

1131002

MACHOS LEVANTE

tYES

1131000

at_Other

tNO

1131002

OACT - ChartOfAccounts1 (Catalogo) Cabecera.txt.zip

[Former Member · Accepted solution]

Hi,

Try the below mentioned steps;

Thanks

SP Samy

[kothandaraman_nagarajan]

Hi,

Please check this:

http://wiki.scn.sap.com/wiki/display/B1/SAP+Business+One+...To+Go+-+10.+Data+Transfer+Workbench?orig...

Thanks & Regards,

Nagarajan

[julie_jamieson2]

Hi,

Try splitting the DTW into two files, one for your non posting accounts & one for your posting ones. Import the parent accounts first, then your sub accounts should import OK

[Former Member]

Hi,

Please check below thread,

Regards,

Santosh.

[former_member268939]

Hi Dhere, I did that before i posted here.