Skip to Content
author's profile photo Former Member
Former Member

Import/ Update Bank Details of Suppliers- DTW

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:

ParentKeyLineNumAccountNoBPCodeBankCodeBlockBranchAccountNameBICSwiftCodeControlKeyCountryCountyIBANInternalKeyLogInstanceStateStreetUserNo1UserNo2UserNo3UserNo4ZipCodeCardCodeLineNumAccountNoBPCodeBankCodeBlockBranchAcctNameSwiftNumControlKeyCountryCountyIBANInternalKeyLogInstanceStateStreetUserNo1UserNo2UserNo3UserNo4ZipCodeT10001110321761S10275BOFS80-73-31A1UK16T100021216 119S10372NBAG360 200 30A2NBAG123DE39

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

Any suggestions?

Thanks,

Joseph

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on May 19, 2015 at 06:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Joseph,

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

      Please find the file attached

      ParentKeyLineNumLogInstanceUserNo4BPCodeCountyStateUserNo2IBANZipCodeCityBlockBranchCountryStreetControlKeyUserNo3BankCodeAccountNoUserNo1InternalKeyBuildingFloorRoomBIKAccountNameCorrespondentAccountPhoneFaxCustomerIdNumberISRBillerIDISRTypeBICSwiftCodeABARoutingNumberMandateIDSignatureDateMandateExpDateSEPASeqTypeCardCodeLineNumLogInstancUsrNumber4CardCodeCountyStateUsrNumber2IBANZipCodeCityBlockBranchCountryStreetControlKeyUsrNumber3BankCodeAccountUsrNumber1AbsEntryBuildingBIKAcctNameCorresAcctPhoneFaxCustIdNumISRBillerIISRTypeSwiftNumABARoutNumMandateIDSignDateMandatDateSeqTypeC999980

      C99998


      HDFC0001234123456TEST City

      INTest Street

      HDFCHDFC0001234
















      C999981

      C99998


      SBI0001234123456TEST City1

      INTest Street1

      SBISBI0001234
















      Thanks

      Unnikrishnan

      Message was edited by: Unnikrishnan Balan

  • Posted on May 19, 2015 at 06:32 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2015 at 07:00 AM

    Hi All,

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

    Thanks,

    Joseph

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.