Skip to Content
0
Former Member
Dec 26, 2015 at 05:49 PM

Update OCRB via SDK

225 Views

Hi expert

i want to update the OCRB bank account via sdk. i've a simple file excel with 4 columns

the code is ok but Sap doesn't update nothing

Dim Retval As Long

Dim bp As SAPbobsCOM.BusinessPartners

Set bp = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oBusinessPartners)

Row = 2

Do While ActiveSheet.Cells(Row, 1) <> ""

bp.BPBankAccounts.BPCode = ActiveSheet.Cells(Row, 1)

bp.BPBankAccounts.BankCode = ActiveSheet.Cells(Row, 3)

bp.BPBankAccounts.InternalKey = ActiveSheet.Cells(Row, 2)

bp.BPBankAccounts.AccountNo = ActiveSheet.Cells(Row, 4)

bp.BPBankAccounts.Country = "IT"

If bp.BPBankAccounts.BPCode <> "" Then

Retval = bp.Add

End If

Row = Row + 1

Loop

oCompany.Disconnect

End Sub

Cardcode is already insert in Sap b1 and i want to update the OCRD bank account

can anyone help me

Attachments

image_ocrb.png (9.4 kB)