Internal reconciliation does not work

[egilberto-axap]

Hi everyone,

I am currently making a function to perform an internal reconciliation, however it gives me the following error:

"No existen registros coincidentes (ODBC -2028)"

I have checked the parameter values and everything is in order. I don't know what might be missing or happening.

It would be helpful if anyone has been through the same thing.

Thank you.

 public static void Reconciliar(string CardCode)
        {

            InternalReconciliationsService service = (InternalReconciliationsService)Utiles.Company.GetCompanyService().GetBusinessService(ServiceTypes.InternalReconciliationsService);
            InternalReconciliationOpenTransParams transParams = (InternalReconciliationOpenTransParams)service.GetDataInterface(InternalReconciliationsServiceDataInterfaces.irsInternalReconciliationOpenTransParams);
            InternalReconciliationParams _Parametros = (InternalReconciliationParams)service.GetDataInterface(InternalReconciliationsServiceDataInterfaces.irsInternalReconciliationParams);

            transParams.CardOrAccount = CardOrAccountEnum.coaCard;

            transParams.InternalReconciliationBPs.Add();
            transParams.InternalReconciliationBPs.Item(0).BPCode = CardCode;

            try
            {
                InternalReconciliationOpenTrans openTrans = (InternalReconciliationOpenTrans)service.GetDataInterface(InternalReconciliationsServiceDataInterfaces.irsInternalReconciliationOpenTrans);

                openTrans.ReconDate = DateTime.Now;

                openTrans.InternalReconciliationOpenTransRows.Add();
                openTrans.InternalReconciliationOpenTransRows.Item(0).Selected = SAPbobsCOM.BoYesNoEnum.tYES;
                openTrans.InternalReconciliationOpenTransRows.Item(0).TransId = 2222;
                openTrans.InternalReconciliationOpenTransRows.Item(0).TransRowId = 0;
                openTrans.InternalReconciliationOpenTransRows.Item(0).ReconcileAmount = 7600;


                openTrans.InternalReconciliationOpenTransRows.Add();
                openTrans.InternalReconciliationOpenTransRows.Item(1).Selected = SAPbobsCOM.BoYesNoEnum.tYES;
                openTrans.InternalReconciliationOpenTransRows.Item(1).TransId = 3069;
                openTrans.InternalReconciliationOpenTransRows.Item(1).TransRowId = 1;
                openTrans.InternalReconciliationOpenTransRows.Item(1).ReconcileAmount = -7600;


                _Parametros = service.Add(openTrans);
            }
            catch (Exception ex)
            {
                string _Error = ex.Message;
            }
        }

[former_member27]

Hi egilberto_axap,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi

[jitin_chawla]

Hi,

Can you double confirm the Transid and Line_ID taken for both rows, whether they are correct or not?

You can check the below thread as well:

https://answers.sap.com/questions/13744922/diapi-to-create-internal-reconciliations-failing.html

Kr,

Jitin