Skip to Content

Internal reconciliation posting using sdk

Hi Experts!

Internal Reconciliation using SDK. I already used SAP 9.3 PL04 some error i experience

like

-- Multiple GL Account

-- No Matching OBDC

see attach screen shots.

and my encountered error.

sc1.png (25.7 kB)
err1.png (13.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Dim oParam As SAPbobsCOM.InternalReconciliationParams Dim oReconService As SAPbobsCOM.InternalReconciliationsService Dim oOposting As SAPbobsCOM.InternalReconciliationOpenTrans oReconService = oCompany.GetCompanyService.GetBusinessService(SAPbobsCOM.ServiceTypes.InternalReconciliationsService) oParam = oReconService.GetDataInterface(SAPbobsCOM.InternalReconciliationsServiceDataInterfaces.irsInternalReconciliationParams) oOposting = oReconService.GetDataInterface(SAPbobsCOM.InternalReconciliationsServiceDataInterfaces.irsInternalReconciliationOpenTrans) ' oReconService.Add(oOposting) With oOposting .CardOrAccount = SAPbobsCOM.CardOrAccountEnum.coaCard .InternalReconciliationOpenTransRows.Add() .InternalReconciliationOpenTransRows.Item(0).Selected = SAPbobsCOM.BoYesNoEnum.tYES .InternalReconciliationOpenTransRows.Item(0).TransId = 803 .InternalReconciliationOpenTransRows.Item(0).TransRowId = 1 .InternalReconciliationOpenTransRows.Item(0).ReconcileAmount = 738.38 'gridRecon.DataTable.GetValue("Actual Amount", gridRecon.GetDataTableRowIndex(i)) .InternalReconciliationOpenTransRows.Add() .InternalReconciliationOpenTransRows.Item(1).Selected = SAPbobsCOM.BoYesNoEnum.tYES .InternalReconciliationOpenTransRows.Item(1).TransId = 4510 .InternalReconciliationOpenTransRows.Item(1).TransRowId = 0 .InternalReconciliationOpenTransRows.Item(1).ReconcileAmount = -738.38 Try oParam = oReconService.Add(oOposting) Catch ex As Exception End Try

  • Anyone can help me

  • Get RSS Feed

5 Answers

  • Jan 11 at 04:23 PM

    Hello Michael,

    I experienced exactly the same problem. Have you any clue to solve it?

    Best regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15 at 11:03 AM

    Hello guys,

    I resolved my problem. In fact i was just forgotten to declare the transrowID in my reconciliation method. when i m doing that i don't have this error anymore but i have to declare only positive amount in the ReconcileAmount property. B1 sdk managed on its own the credit/debit according to the transrow ID.

    hope that can help you.

    Best regards

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you for your reply.

      I already declared the transrowID values, but I still get the error message.

      I'm trying two different cases, one to reconcile an Invoice with a Payment and the second to reconcile a Journal Entry with a Payment.

      Is there anything else you may have done?

      Also, what version of B1 are you running? We're on 9.3 PL04HF.

      Thank you in advance.

  • Jan 16 at 09:43 AM

    Hello,

    We are using the 9.3 PL04 version.

    I'm reconcialiating only journal entries between them. I don't have payment or invoice in my case.

       dsa_posting.InternalReconciliationOpenTransRows.Add()
       dsa_posting.InternalReconciliationOpenTransRows.Item(i).Selected = SAPbobsCOM.BoYesNoEnum.tYES
       dsa_posting.InternalReconciliationOpenTransRows.Item(i).TransId = dsa_recordset.Fields.Item(tbl_JournalEntries.fst_Code).Value
       dsa_posting.InternalReconciliationOpenTransRows.Item(i).TransRowId = dsa_recordset.Fields.Item(tbl_JournalEntries_Lines.fst_LineNum).Value
       dsa_posting.InternalReconciliationOpenTransRows.Item(i).ReconcileAmount = dsa_recordset.Fields.Item(tbl_JournalEntries_Lines.fst_Credit).Value + dsa_recordset.Fields.Item(tbl_JournalEntries_Lines.fst_Debit).Value
    
    Add comment
    10|10000 characters needed characters exceeded

  • Hello,

    currently having the same problem.

    Figured out we have to add the InternalReconciliationOpenTransParams in order to attach the CardCode or Account to reconcile, but still the same error occurs.

    _IR_OT_Params.ReconDate = DateTime.Now;
    _IR_OT_Params.CardOrAccount = SAPbobsCOM.CardOrAccountEnum.coaAccount;
    
    //_IR_OT_Params.CardOrAccount = SAPbobsCOM.CardOrAccountEnum.coaCard;
    _IR_OT_Params.AccountNo = AcountNum;
    
    //_IR_OT_Params.InternalReconciliationBPs.Add();
    //_IR_OT_Params.InternalReconciliationBPs.Item(0).BPCode = BPCode;
                               
    _IRservice.GetOpenTransactions(_IR_OT_Params);
    _IRservice.Add(_IRopenTrans);

    Still trying to solve this problem, but thought this could help.

    Add comment
    10|10000 characters needed characters exceeded

  • Dear Sébastien,

    Thank you for all your help, I finally managed to complete the reconciliation without errors.

    For anyone still wondering there is also the SAP note 2586911 that has some helpful info.

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded