SAP Knowledge Base Article - Public

3493935 - Bank statement API BankStatementPost_In overwrites Posting Date

Symptom

While posting bank statement via API BankStatementPost_In, it overwrites line item posting date filled in payload with header bank statement date.

Environment

SAP S/4HANA Cloud

Reproducing the Issue

Post bank statement with API BankStatementPost_In. In the payload file enter different date for <BankStatementDate> and for <BankPostingDate>.

After posting <BankPostingDate> tag at the item level is being overwritten by the header tag <BankStatementDate>. If <BankStatementDate> is not filled (optional), it is also overwritten by creation date. 

...

<BankStatementHeader>
        <BankNumber/>
      <BankCountry>XX</BankCountry>
      <SWIFTCode>....</SWIFTCode>
      <BankAccount>12345678</BankAccount>
      <BankAccountHolderName>John Smith</BankAccountHolderName>
      <BankAccountAdditionalName>John John Smith</BankAccountAdditionalName>
        <BankAccountType></BankAccountType>
        <BankStatement>1</BankStatement>
      <BankStatementDate>2024-07-10</BankStatementDate>
      <BankStatementPeriodStartDate>YYYY-MM-DD</BankStatementPeriodStartDate>
      <BankStatementPeriodEndDate>YYYY-MM-DD</BankStatementPeriodEndDate>
        <Currency>EUR</Currency>
      <OpeningBalAmtInBankAcctCrcy currencyCode="EUR">100</OpeningBalAmtInBankAcctCrcy>
        <TotalDebitAmtInBkAcctCrcy currencyCode="EUR">0</TotalDebitAmtInBkAcctCrcy>
        <TotalCreditAmtInBkAcctCrcy currencyCode="EUR">100</TotalCreditAmtInBkAcctCrcy>
      <ClsgBalAmtInBkAcctCrcy currencyCode="EUR">200</ClsgBalAmtInBkAcctCrcy>
        <BankStatementNumberOfItems>1</BankStatementNumberOfItems>
        <SenderIBAN/>
       </BankStatementHeader>
       <BankStatementLineItems>
      <BankPostingDate>2024-07-09</BankPostingDate>

...


Cause

Standard system design.

Resolution

The API uses always the bank statement date for posting. The API was designed in that way that it is not using the bank posting date on item level as posting date. 

The purpose of tag <BankPostingDate> is to fill the document date of the journal entry.

See Also

Bank Statement - Post

APIs on SAP Business Accelerator Hub

Keywords

bank statement, post, posting date, statement date, FEBKO-AZDAT, FEBEP-BUDAT, API, BankStatementPost_In, BankStatementDate, BankPostingDate, SAP_COM_0316  , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions