Report recurring entries?

[sanne_larsen]

Hi, 

We're implementing a S4 public cloud and have come across the reccuring entries which the customer wants to use, but they will need to preform reconciliation of the prepaid accounts and want to extract a report of the reccuring entries and details related to this. I can't find any report suitable, does anyone have any suggested? 

If they could wish they want to include: 
- GL-account
- Reccuring entry number
- Starting amount
- Remaining amount
- Remaining period
- Text in the reccuring entry
- Receiving account in the montly run

I know that I've seen reports like this when in ECC but I can't find any in public cloud. 

Kind Regards, Sanne

[OwenLiu]

Hi Sanne, what is the report you mentioned in ECC?

[sanne_larsen]

I've tried to look for it but can't find the one I'm thinking about maybe that was a Z-report..

[HenrikeGrtecke]

Hello, thank you for your question. It has been forwarded to the experts. Kind regards, Henrike

[ChumaDavid · Accepted solution]

Hello @sanne_larsen 

There is no standard report in SAP S/4HANA Public Cloud Edition, as previously mentioned by Bob.  The delivered app, Manage Recurring Journal Entries, allows you to create/edit templates, as well as view posting status; however, it does not provide a reconciliation view for prepaid.

SAP Help Portal-Manage Recurring Journal Entries(SAP Help Portal)

SAP FioriAppsLibrary-Manage Recurring Journal Entries(watch the interactive demo)

SAP Help-Manage Journal Entries (New Version) Use this to filter, view, and export journal documents posted by those templates; consider it the actuals side for reconciliation purposes.

With best regards

Chuma

[BobShen]

Unfortunately, there is no standard report in S/4HANA Public Cloud that provides all the details for recurring entries as specified in your question. However, here are some alternative approaches you can consider:

1. Custom Report Development:

   • Create a custom report using CDS Views to extract the required information about recurring entries [1].
   • This approach allows you to tailor the report to include specific fields like GL account, recurring entry number, starting amount, remaining amount, remaining period, text, and receiving account.

2. Existing Reports and Apps:

   • While not specifically designed for recurring entries, you can utilize some standard reports and apps to gather partial information:
     • "Manage Customer Line Items" app: This evolved version of the FBL5N transaction can provide some relevant data [2].
     • "Order to Cash Dashboard": This dashboard includes multiple tiles with various financial information, which might be useful for reconciliation purposes [2].

3. Data Extraction and Manipulation:

   • Extract data from relevant tables related to recurring entries.
   • Use SAP Analytics Cloud or other reporting tools to combine and manipulate the data to create the desired report format.

4. SAP Support Engagement:

   • If these options don't meet your needs, consider engaging SAP support to explore additional possibilities or to request enhancements to existing reports for recurring entry management in S/4HANA Public Cloud.

Remember that the availability of reporting options may vary based on your specific S/4HANA Public Cloud version and configuration. It's advisable to test these approaches in a non-production environment before implementing them in your live system.