Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

  • 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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded