Bank Statement posting date is required to be same as of the transaction date

[RajanJha]

Dear Expert,

We are on S/4 HANA Cloud.

In the current scenario for the CAMT.053 reports(bank statement) we get the Previous Day Report (PDR) so the transactions for the date 08/14/2023 will come on 08/15/2023. When we get the file on 08/15/2023 system uses the file date as posting date.

In the above example instead of using 08/15/2023 we want to system use 08/08/2023 (transaction dates) as posting date.

We are not finding a way to do the required configuration for the above such requirement.

Could you please help on the above.

Thanks in Advance,

Rajan Jha

[JiriStarek]

Hi, you could use a FIORI APP: Map Format Data for Incoming Files from Banks and make manual mapping in CAMT53 format - and choose right date from XML NODE. 

[Bohdan]

Hi rajanjha02,

If you want to implement custom logic for determination of posting date for bank postings, I'd advise you to consider the following enhancement spots:

- BADI FIEB_CHANGE_BS_DATA. Here you'll need to adjust the value of the variable C_FEBEP-BUDAT in the method CHANGE_DATA.

- BADI FEB_BADI. Here you can change the posting date in the internal table T_FTPOST with the parameters of the accounting posting. Method name is CHANGE_POSTING_DATA.

I'd advise you to use the first BADI. It will be much easier to implement. Besides, if you use 2 posting areas, it will be executed once. Second BADI will be called once for each posting area. Besides, considering that you have to manipulate the internal table with the parameters of accounting document, it is a bit more complicated.

Regards,

Bohdan

[RajanJha]

Hi Bohdan,

Thank You for your message. Just I wanted to confirm whether the solution you provided is related to S/4 HANA Cloud?

Regards,

Rajan

[Bohdan]

Hi Rajan,

Yes, you're right. I missed the point about it being the S/4 HANA Cloud system. I just checked the list of BADIs for cloud version and cannot find anything of the same kind. Considering that my knowledge of cloud is limited to being non-existent at all, I wish you good luck and hope someone else comes by with an answer that sheds some light on the topic. I'd be interested about the details as well.

Regards,

Bohdan