Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
edy_simon
Active Contributor
4,015

I have just encountered a strange problem with DI API outgoing payment with check as payment means.

I thought I would just share this here.

I had a running addon which creates an outgoing payment using checks as payment mean in SBO 882.PL8

below is the code to include the check :

            Dim oPym As SAPbobsCOM.Payments
            Set oPym = .GetBusinessObject(oPaymentsDrafts)
            oPym.DocObjectCode = bopot_OutgoingPayments
           
            oPym.CardCode = "S32"
            oPym.Invoices.DocEntry = 42
            oPym.Invoices.InvoiceType = it_PurchaseInvoice
            oPym.Invoices.SumApplied = 150
           
            oPym.Checks.CheckSum = 150
            oPym.Checks.BankCode = "BankCode"
            oPym.Checks.AccounttNum = "BankAccount"
   
            lErr = oPym.Add

While testing, we had upgraded the SBO + database into SBO 882.PL9.

After this upgrade, the outgoing payment does not get created anymore, with error 'No Matching Record Found.'

After much testing, we found out that in order to create checks as the payment mean from DI,

The BankCode and BankAccount must match the Default HouseBank in the Administration - System Initialization - Company Details - Basic Initialization. (which does not make sense, since the UI allows us to create check from other bank)

Or, if we need to use other bank account, the setup in the Default House Bank must be emptied. (This includes all the field in this section).

Now, in my original 882PL8 database, this setting is empty. Thus I can create the document without problem.

When we upgraded this database to 882PL9, somehow after PL Upgrade there is a Default Bank Country here.

Because of this, the DI throwing the error when creating.

In short, if you encounter 'No Matching Record Found.' when creating check outgoing payment :

1. Check that your Bank Account and Bank Code exists in DSC1 Table.

2. As this documents show, Check the Default House Bank in  Administration - System Initialization - Company Details - Basic Initialization.

Regards
Edy

PS: I have tested this problem occurs in :

- SBO 882PL8

- SBO 882PL10

- SBO 882PL11

1 Comment
Labels in this area