cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Updating Custom Fields in Journal Entry in S4 Hana Public Cloud

Oliver231
Explorer
0 Kudos
594

Hello,

I would like to check if there is a way to update the Journal Entry custom fields after creating checks in Manage Outgoing Checks.
I have tested all available Journal Entry custom logic options, but none of them are triggered or update the custom fields.

I need this for a custom report in Create Correspondence, where the data from Manage Outgoing Checks must be reflected in the Journal Entry custom fields.

if you have any recommendations or alternative solutions, please let me know.

Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Chris1973
Active Contributor
0 Kudos

Good day @Oliver231 

Thank you for your question.

Have a look at these references for more details.

App Extensibility: Post General Journal Entries, Process Extensibility for Journal Entries, Queries

Journal Entry Item - Read (A2X), Journal Entry - Post (Synchronous), Secure Extensibility

The postings you mentioned are not done by user-interactive BAdIs that are tied to Manage Journal Entries or Journal Entry Post APIs, instead they are often created by automatic payment (legal compliance related) program logic. Once payment document is created, it is not re-processed through the extensibility points in Journal Entry and any custom fields defined on the journal entry item is only populated during document creation. So, your test result is the expected outcome.

To summarise, in public cloud, you cannot update custom journal-entry fields after creating check. The payment program posts those entries in a locked accounting context.

The correct clean-core approach is to join check data and journal-entry data through a Custom CDS View (or CBO if needed) for you correspondence/reporting instead of attempting to modify the journal entry itself.

 

Below is a step-by-step clean-core approach:

  • First phase is to 

Open CDS Views, create and name “YY1_JournalEntryCheckLink”

Chris1973_6-1762602025285.png

Chris1973_5-1762602012405.png

For the Primary data source --> I_JournalEntryItem.

Chris1973_4-1762601983394.png

Then add association --> I_Check

Chris1973_3-1762601965773.png

Chris1973_2-1762601947986.png

Then Join the CompanyCode and JournalEntry (where available). Add required fields, save and publish it.

 

  • Second phase is to consume your reporting by

Opening Custom Analytical Queries

Chris1973_1-1762601897023.png

 

Create a query based on your new CDS, add filter on Check Number/Payment Document, save. Then use in Create Correspondence.

Chris1973_0-1762601876623.png

Let me know if you have further questions.

Best regards

Chris

Oliver231
Explorer
0 Kudos
Hi Cris
Oliver231
Explorer
0 Kudos
Hi Cris, May I ask how I can use the custom CDS view in the Create Correspondence feature for report viewing in Journal Entries? Best regards, Oliver
Oliver231
Explorer
0 Kudos
May I ask how I can use the custom CDS view in the Create Correspondence feature for report viewing in Journal Entries?
Oliver231
Explorer
0 Kudos
how I can use the custom CDS view in the Create Correspondence feature for report viewing in Journal Entries?
Oliver231
Explorer
0 Kudos
May I ask how I can use the custom CDS view in the Create Correspondence
Oliver231
Explorer
0 Kudos
May I ask how I can use the custom CDS view
Oliver231
Explorer
0 Kudos
How I can use the custom CDS view in the Create Correspondence
Oliver231
Explorer
0 Kudos
Hi Chis I already tried your approach, But still the data fields from Outgoing Checks still not showing to Journal Entry

Answers (0)