Import/ Update Bank Details of Suppliers- DTW

[Former Member]

Hi All,

Any suggestions on how to import/ update Bank details of suppliers ?

I want to update the OCRB template and import these but I'm unable to do so, any suggestions?

Sample data from my template ismentioned below:

ParentKey

LineNum

AccountNo

BPCode

BankCode

Block

Branch

AccountName

BICSwiftCode

ControlKey

Country

County

IBAN

InternalKey

LogInstance

State

Street

UserNo1

UserNo2

UserNo3

UserNo4

ZipCode

CardCode

LineNum

AccountNo

BPCode

BankCode

Block

Branch

AcctName

SwiftNum

ControlKey

Country

County

IBAN

InternalKey

LogInstance

State

Street

UserNo1

UserNo2

UserNo3

UserNo4

ZipCode

T10001

1

10321761

S10275

BOFS

80-73-31

A1

UK

16

T10002

1

216 119

S10372

NBAG

360 200 30

A2

NBAG123

DE

39

While updating the business partner, it shows an error message 'Enter valid code'.

Any suggestions?

Thanks,

Joseph

[Former Member]

Hi All,

Created a new template from the sample template available and now the import works fine with a single OCRB template.

Thanks,

Joseph

[former_member184146]

Hi Joseph,

               In this case , you should have 2 templates i.e. 1 for the parent template only with CardCode Column, then in 2 template put the same list of cardcodes in child template i.e OCRB template your first and 4 column  should me same as in template of parent template then in LineNum column put 0 or leave it empty.

--Manish

[former_member212181]

Hi Joseph,

1)Please give same value in Parentkey and BP Code field ie. Business partner code in OCRD Table.

2) please give database name of BP Code field as CardCode on column No 4.

Thanks

Unnikrishnan

[Former Member]

Hi Unnikrishnan,

That does not help.

Actually, there was a change only in the second point which you mentioned, made that change but still does not work.

Do you have a sample template that works?

Can you send that to me?

Thanks,

Joseph

[former_member212181]

Hi Joseph,

I uploaded OCRB data in my system by using attached template in OEC Computers (test DB)

Please find the file attached

ParentKey

LineNum

LogInstance

UserNo4

BPCode

County

State

UserNo2

IBAN

ZipCode

City

Block

Branch

Country

Street

ControlKey

UserNo3

BankCode

AccountNo

UserNo1

InternalKey

BuildingFloorRoom

BIK

AccountName

CorrespondentAccount

Phone

Fax

CustomerIdNumber

ISRBillerID

ISRType

BICSwiftCode

ABARoutingNumber

MandateID

SignatureDate

MandateExpDate

SEPASeqType

CardCode

LineNum

LogInstanc

UsrNumber4

CardCode

County

State

UsrNumber2

IBAN

ZipCode

City

Block

Branch

Country

Street

ControlKey

UsrNumber3

BankCode

Account

UsrNumber1

AbsEntry

Building

BIK

AcctName

CorresAcct

Phone

Fax

CustIdNum

ISRBillerI

ISRType

SwiftNum

ABARoutNum

MandateID

SignDate

MandatDate

SeqType

C99998

0

C99998

HDFC0001234

123456

TEST City

IN

Test Street

HDFC

HDFC0001234

C99998

1

C99998

SBI0001234

123456

TEST City1

IN

Test Street1

SBI

SBI0001234

Thanks

Unnikrishnan

Message was edited by: Unnikrishnan Balan