Matching Invoices with Payments made via Web Service – Clearing Open Entries

[AaronMendieta]

Hi Experts!

- I have been trying to create a Payment and match it with an Invoice via Web Service (I'm using ManageBankAdviceIn) in order to clear them, however, as response I get the next:

<Log>
            <MaximumLogItemSeverityCode>2</MaximumLogItemSeverityCode>
            <Item>
               <TypeID>400(/FOP_DUE_CLR_BL/)</TypeID>
               <CategoryCode>INC.BOI</CategoryCode>
               <SeverityCode>2</SeverityCode>
               <Note>Posting not possible; clearing  inconsistent</Note>
            </Item>
         </Log>


  

- I have been following the structure and the examples given in the official help SAP portal (https://help.sap.com/doc/a2b4c7ef61d64397b2b1d052082a8a08/1908/en-US/PSM_ISI_R_II_A1SCI_CI_QUERY_IB.html) but it does not seem to work.

- The structure I have been working with is as follows:

  <BasicMessageHeader>
  
 	</BasicMessageHeader>
 	
 	<BankAdvice>
 	
  		<CompanyID>COMPANY_ID</CompanyID>
  		<ExternalAdviceID>TEST_PA_WB</ExternalAdviceID>
  		<AccountDebitIndicator>false</AccountDebitIndicator>
  		<AdviceDate>2020-11-30</AdviceDate>
  		<PostingDate>2020-11-30</PostingDate>
  		<PaymentFormCode>05</PaymentFormCode>
  		<EffectivePaymentAmount currencyCode="MXN">100.00</EffectivePaymentAmount>
  		<HouseBankAccountInternalID>BANK_ID</HouseBankAccountInternalID>
  		<BusinessPartnerInternalID>PARTNER_ID</BusinessPartnerInternalID>
  	
  	<PaymentExplanationItem>
   		
   		<ID>ANY_ID</ID>
   		<BusinessTransactionDocumentDate>2020-11-30</BusinessTransactionDocumentDate>
   		<CompanyID>COMPANY_ID</CompanyID>
   		<BusinessPartnerInternalID>PARTNER_ID</BusinessPartnerInternalID>
		<NetAmount currencyCode="MXN">100.00</NetAmount>
   		<CashDiscountAmount currencyCode="MXN">0.00</CashDiscountAmount>
   		
   		<PaymentTransactionDestinatedInvoiceReference>
    			<ID>INVOICE_ID</ID>
   		</PaymentTransactionDestinatedInvoiceReference>


/////////////////// I've tried commenting and uncommenting this part, however, I get the same result.
/////////////////// In the given example in SAP portal it is commented.
<!--<PaymentTransactionInitiatorInvoiceReference>  //External Reference of the Invoice 
    <ID>MCCI-214</ID>
   </PaymentTransactionInitiatorInvoiceReference> -->
///////////////////
  
  	</PaymentExplanationItem>
  	
  	<PaymentExplanationItemListCompleteTransmissionIndicator>true</PaymentExplanationItemListCompleteTransmissionIndicator>
 	</BankAdvice>  

- I found this possible solution, it describes my issue so I tried it, didn't work though. https://apps.support.sap.com/sap/support/knowledge/en/2490272

- By trial and error I have looked for the "optional" elements that could solve my problem, among the various options I have found that if I add the element <PaymentReferenceID>? </PaymentReferenceID> (for the value "?" have tried entering the ID of my invoice, as well as some unique ID of my own) to my structure, the response that I get when executing my web service returns without any warning, however, clearing is not carried out and it seems like the relationship between Payment-Invoice is more inconsistent.

Any help will be really appreciated!

Thanks in advance for your attention and best regards!

[frank_jahnigen]

Hello,

In an opened incident we described that with identical payload and similar parameters as partial clearing/applied cash discounts/surcharges etc. we were able to generate a clearing in this Bank Advice web-service scenario. Does the problem still occur - and if resolved - maybe let us know what has been altered?

Best Regards,

Frank